How to find a "close word" in MySQL?

Question

For example, I want to find the word " marple ", this should return a string with the close or exact word " marble ", " maple ',' marple , etc.

How to do this in mysql query? or is it better to give a sentence for a word, if any?

Answer 1

SOUNDEX function .

"Two lines that sound almost the same should have the same soundex lines."

Answer 2

In MySQL, you can try using the soundex function, but this is not a real solution. Use Sphinx or Lucene.

Answer 3

You can use this

$ sql = "select * from tbl_name, where is your_field, for example '% is your search keyword%'";