Forum Moderators: phranque

Message Too Old, No Replies

A method to suggest other names when user makes typos

mp3 playr --> mp3 player

         

guarriman

10:02 am on Nov 3, 2005 (gmt 0)

10+ Year Member



Hello.

Working with Apache+PHP+MySQL, I'm developing a website to allow users to find within a product catalog. Product info is stored within a MySQL table (ID, name, price).

These users usually make typos and mistakes when typing the product name, and I want to suggest them other names, similars to the typed one. For instance:
mp3 playr --> mp3 player

Does anybody know any algorithm or method to perform it? Thank you very much.

Sanenet

10:58 am on Nov 3, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



soundex() would probably do the trick.

[dev.mysql.com...]

nonstop

12:17 pm on Nov 22, 2005 (gmt 0)

10+ Year Member Top Contributors Of The Month



Can I use soundex with a full text search?