PHP DB - spell checking and "did you mean?"

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

spell checking and "did you mean?"

peter lovatt

2006-03-23, 6:58 pm

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

Sponsored Links