Re: Any Fuzzy Software ( Other than SOUNDEX / NYSIIS )?

Evaluating Fuzzy SW wrote:
>
> Hi All
>
> We are using soundex (and later tried Nysiis) for fuzzy name search
> software. But we faced a lot of problems the search accuracy was not very
> good also we saw a lot of misses of relevant names.
>
> There are many problems other than precision and accuracy, with soundex and
> NYSIIS.
>
> e.g.
>
> Look for Smith and it will come-up with around 250 very popular last names.
> That dones not help much when a user is searching for "John Smith". Also, it
> does not return Creighton for Kryton as the search string.
>
> I googled a little and saw soming called NamiX. Without contacting the
> company ( arizcon.com ) directly, I wanted to get feedback from newsgroups
> or people who are experts at this. Has anyone used this software? If so, Is
> it as good as they claim?
>
> Thanks a million in advance.
>
> Steve Creighton
> (please remove .antispam from email address) or post back your answers to
> this group

you could search the net for metaphone and double-metaphone but all these algorithms will always suffer to some degree from false positives. The only real successful means seems to be massive thesaurus based products (none of which any of my clients have ever opted for due to cost)

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------