Inexact Duplicates

R

RayRay

I am trying to find matching names between two tables. However, not all the
names are exact matches. How do I get the matching names even if they are
not exact?
 
O

Ofer

To get matching names, tou can create a query that includes both tables and
join them by the name field.
Now, what do you mean by not always matching.
If there is no rule for the different between them, then it will be
impossible to do that.
If you have a rule, there is a same different between them, then what is,
and we'll try to remove that different so we can match them
 
R

RayRay

Thanks for the answer. The differences between the information in the two
data sets are varied so I guess I'll just have to deal with it.
 
J

John Vinson

I am trying to find matching names between two tables. However, not all the
names are exact matches. How do I get the matching names even if they are
not exact?
Click to expand...

Examples?

Computers are VERY literal minded. To a human being, "Bob Jones" and
"Robert A. Jones Jr." could very well evoke the reaction "that's
probably the same person"; to a computer, of course, they're utterly
different. Any algorithm that would match those two names would
perforce also treat "Helen Jones" and "Jones Truck Lines" as probable
matches as well - or even return all names containing A!

There is a good reason that there are (rather expensive, often)
mailing list cleaning services. It's hard work, and requires a lot of
manual intervention!

John W. Vinson[MVP]
 
Top