>
> I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are
> there other MySQL features that help with Fuzzy searching?
>
> Soundex seems very useful, but I'm not sure how to apply it to multi-word
> strings.
>
> I'd also be interested in pointers to general info on writing fuzzy searches.
>
> A Perl example would be great.
>
>
> I think what I want it a kind of combination of SOUNDEX and the relevance
> value from MATCH/AGAINST. Is something like this possible?
I looked into soundex (in general, not just wrt MySQL), and didn't like what I
found all that much, so rolled my own and ended up re-inventing phonex
without realising it.
What I've ended up with is a modified-phonex-encoded name in a database table
which works really well for fuzzy matching. YMMV of course.
If you're interested, email me off the list and I'll outline what I did
and why.
Paul Wilson
iiNet Ltd
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php