MySQL Bugs: #21175: Fulltext cannot find misspelled words

Bug #21175	Fulltext cannot find misspelled words
Submitted:	20 Jul 2006 9:10	Modified:	20 Jul 2006 10:15
Reporter:	Mirza Hadzic	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: FULLTEXT search	Severity:	S4 (Feature request)
Version:	All	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
It would be very usefull if fulltext engine could also find misspelled words (and apply lower match-rating to it). For example, searching for word "example" should also (optionally) find words "examlpe" or "exaple". 

How to repeat:
Search for misspelled word using FULLTEXT index.

Thank you for a reasonable feature request. This feature or, at least, builtin function similar to Oracle's SOUNDEX will be really usefull in some cases.