mysql正确拼写,MYSQL搜索正确的单词|修正拼写错误

I have a table dictionary which contains a list of words Like:

ID|word

---------

1|hello

2|google

3|similar

...

so i want if somebody writes a text like

"helo iam looking for simlar engines for gogle".

Now I want to check every word if it exists in the database, if not it should

get me the similar word for the word. For example: helo = hello, simlar = similar, gogle = google.

Well, i want to fix the spelling errors. In my database i have a full dictionary of all english words. I coudn't find any mysql function which helps me. LIKE isn't helpfull in my situation.

解决方案

There is a function that does roughly want you want, but it's intensive and will slow queries down. You might be able to use in your circumstances, I have used it before. It's called Levenshtein. You can get it here How to add levenshtein function in mysql?