How to find a similar word for a misspelled one in PHP?

Viewed 8058

I'll explain my problem:

I have a database table called country. It has two columns: ID and name.

When I want to search for 'paris', but misspelled the word: 'pares' ('e' instead of 'i'), I won't get any result from DB.

I want the the system to suggest similar words that could help in the search.

So, I am looking for help writing a script that makes suggestions from the DB that contain similar words like: paris, paredes, ... etc.

5 Answers
Related