spell checking and "did you mean?"

From: Date: Thu, 23 Mar 2006 19:22:24 +0000
Subject: spell checking and "did you mean?"
Groups: php.db 
Request: Send a blank email to php-db+get-41599@lists.php.net to get a copy of this message
Hi All I am looking to check whether a keyword a user has entered already exists in the database I can find exact matches, but I am having trouble with typos. I am looking for something like Google's "did you mean" if you type in a close match. SO if someone types in saet it returns "did you mean seat ?" Any suggestions which is best - SOUNDEX in MySql or the php functions levenshtein(), soundex(),metaphone() or similar_text() on the returned result. Any other suggestions welcome. Thanks Peter

« previous php.db (#41599) next »