Any Fuzzy Software ( Other than SOUNDEX / NYSIIS )?

Evaluating Fuzzy SW

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

Jul 23 '05 #1

Subscribe Reply

3776

Ray

Steve,

This is not really the group for this kind of question but Name match
software or simply text matching software can be reasonably cheap or very
expensive. The best I've used (~$100K price tag for prod software only) was
Ascentials Quality Stage Server. Just so I related this to SQL Server after
all what group is this posted in?

A company I consulted for had a need to match names address pairs to members
in thier SQL DB. They already owned and used Quality Server for other
purposes. They eventually decided to write an extensive TSQL stored
procedure that checked for about 20 different combinations of things like
soundex of last name plus state plus first three letters of street address.
The client was statisfied with the match rate and they could understand it
well. The moral of the story here is if absolute highest accurate match
rate is essential then use a package writen by someone with a PHD in
statistics. If over 99% is all your looking for, write it in something you
can support and maintain.

Ray

"Evaluating Fuzzy SW" <ev*******@hotm ail.com> wrote in message
news:Ze******** *********@bgtns c04-news.ops.worldn et.att.net...

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

Jul 23 '05 #2

Similar topics

3341

Using Soundex (OT?)

by: Ricky Romaya | last post by:

Hi, I'm curious about soundex. All I know that it's a way for making spelling- error-tolerant word matching. What I want to know is whether the soundex algorithm are made exclusively for english language, or can it be used for any arbitrary language with satisfactory performance (by 'satisfactory performance' I meant that it can detect at least 80% spelling-errors). What about PHP soundex support? TIA

PHP

14049

Fuzzy matching of postal addresses

by: Andrew McLean | last post by:

I have a problem that is suspect isn't unusual and I'm looking to see if there is any code available to help. I've Googled without success. Basically, I have two databases containing lists of postal addresses and need to look for matching addresses in the two databases. More precisely, for each address in database A I want to find a single matching address in database B. I'm 90% of the way there, in the sense that I have a simplistic...

Python

2256

Search methods, "fuzzy" logic, duplicate checking, oh my!

by: William Morris | last post by:

Apologies in advance for the cross-post. Not sure if this is better handled in ASP code or TransactSQL. Windows2000 Server SQL 2000 tblPeople contactid int firstname varchar(25) lastname varchar(25)

ASP / Active Server Pages

2675

Fuzzy Lookups

by: BBands | last post by:

I have some CDs and have been archiving them on a PC. I wrote a Python script that spans the archive and returns a list of its contents: ...]. I wanted to add a search function to locate all the versions of a particular song. This is harder than you might think. For example the Cajun "national anthem" is Jolie Blond, but it can be spelled several different ways jolie, joli, blon, blond, etc... In addition the various online services that...

Python

14406

Can Access use Fuzzy Logic

by: cassetti | last post by:

Here's the issue: I have roughly 20 MS excel spreadsheets, each row contains a record. These records were hand entered by people in call centers. The problem is, there can and are duplicate phone numbers, and emails and addresses even person names. I need to sift through all this data (roughly 300,000+ records and use fuzzy logic to break it down, so that i have only unique records.

Microsoft Access / VBA

8586

Use of Soundex fields in access

by: vonclausowitz | last post by:

Hi All, I have database with names on which I want to use the soundex option. So I have created two seperate fields for the Lastname and Firstname in which I save the Soundex version of a new name I save in the database. I have the soundex code with the 6 numeric option. So I save for example in the field LastnameSE = 600192 and in the FirstnameSE = 545910.

Microsoft Access / VBA

13477

Fuzzy string comparison

by: Steve Bergman | last post by:

I'm looking for a module to do fuzzy comparison of strings. I have 2 item master files which are supposed to be identical, but they have thousands of records where the item numbers don't match in various ways. One might include a '-' or have leading zeros, or have a single character missing, or a zero that is typed as a letter 'O'. That kind of thing. These tables currently reside in a mysql database. I was wondering if there is a...

Python

2356

how to implement fuzzy search using soundex in SQL SERVER 2005!

by: jojo41300000 | last post by:

Hi all, Is there any ideas how to implement the fuzzy search using soundex in SQL server 2005? Could you please post some suggestions, ideas, or source codes if you have already implemented? Thanks alot. Jason

Microsoft SQL Server

7086

Fuzzy logic for duplicate identification?

by: Yashgt | last post by:

Hi, We have a table of users with about 10000 rows. We have to import a large text file into this table. While doing so we would like to ensure that if a row already exists, it should not be imported. Rather that True/false logic, we need to apply Fuzzy logic here so that if we find similarities in the name, address, ad a few other columns, we treat the row as a duplicate. Such possibly duplicate rows should be identified and logged...

Microsoft SQL Server

8449

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8360

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8556

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7387

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6198

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5666

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4371

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2011

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1777

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General