Jake,
You're getting into an area that has been wrestled with for years, and the
true solutions are very, very complex. So your choices on implementation
will depend on just far into the forest you want to go.
Do a Google search on fuzzy name matching. You'll find links to academic
white papers
-Original Message-
From: Tom McNeer [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 08, 2007 10:09 AM
To: CF-Talk
Subject: Re: Smart Names implementation
Jake,
As I say, fuzzy name matching is a very large-scale software challenge
that
people have thrown millions of dollars
I guess I was thinking of something a bit more relational (2 tables: [id,name]
[id,sameAsID]), but your example would do the trick :).
However I could see this becoming an additional bottleneck in our system. We
often have tables with tens or hundreds of thousands of records, and there are
a
On 3/7/07, Jake Pilgrim wrote:
...
Now that I think about it, maybe I'm looking at the wrong approach...
There's always the potential for type-o's and I would like to catch those
too (Robert vs Roebrt) -- obviously this would be beyond the
capabilities of a smart name search (unless i
I've done something similar with part numbers. The hard part isn't
doing lookups -- one table, three columns (id, name1, name2), two
subselects -- the hard part is populating that table.
I'm happy to show you how to do the lookup, but do you have a plan for
populating the table?
--Ben Doom
5 matches
Mail list logo