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

[20 Jul 2006 9:10] Mirza Hadzic
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.
[20 Jul 2006 10:15] Valeriy Kravchuk
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.