How to search a 'near word' in MySQL?

Question

For example, I want to search a word 'marple', this should return row with near or exact word like 'marble','maple','marple', etc...

How to do it in mysql query? or better give word suggestion if any?

Answer 1

SOUNDEX function.

"Two strings that sound almost the same should have identical soundex strings."

Answer 2

In MySQL you can try use soundex function, but it's not a real solution. Use Sphinx or Lucene.