misspelled keyword matching in Mysql

misspelled select statement issue

[tabish]

Hello,

I am stuck with an mysql select statement, please help me.

I have few keyword lists already in mysql table. for example keywords are like indian army, indian boys, USA people and something like that.

So if someone searches using my search and use some misspelled keyword like he enters "indan boys" so i want that "Indian Boys" option should be selected from my sql database.

Is there anyway by which i can display nearest correct keyword from database?

Thank you so much.
Regards

[eelixduppy]

Related Thread [webmasterworld.com]

Some of the suggestions will help :)