That's a tough one. Basically, you need a spell checker plug-in for your
application, I don't think there's much hope of doing this in MySQL alone.
You might find a spell checker that uses MySQL for a back end, of course,
but I doubt it.
Doing a search on Google, I found some open-source spell checkers
(, et al). I
don't know what language you are using, so I can't go further than that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Message
From: Neil Tompkins [mailto:neildtompkins (AT) hotmail (DOT) com]
Sent: Wednesday, August 23, 2006 4:02 PM
To: mysql (AT) lists (DOT) mysql.com
Subject: RE: Search Engine type search
K, I appear to be getting somewhere with the FULL TEXT search. Does anyone
have any good resources about producing search engine type results ? for
example if some enters a search phrase like londn how would I suggest the
word london ?