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

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 07 Jan 2005 13:58:38 +0100
Message-ID: <crm10b$mvm$1@news4.zwoll1.ov.home.nl>

Connor McDonald wrote:

> 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, would that [massive thesaurus based] include Oracle's ConText option? It has a thesaurus option, alongside the text index option.

To the OP: have you been looking at the capabilities of Oracle Text?
http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=3#index-TEX

-- 
Regards,
Frank van Bortel

Received on Fri Jan 07 2005 - 06:58:38 CST