3 ms·
Fuzzy logic that usually requires "tricks of the trade". Good suggestions here. Some other things we have used over the years to remove dups: SOUNDEX (last
by edw519 18y ago
Fuzzy logic that usually requires "tricks of the trade". Good suggestions here.
Some other things we have used over the years to remove dups:
SOUNDEX (last name, first name, street name)
Zip Code (1st 2 digits, 1st 3 digits, all 5 digits)
Street Name only (discard numerics)
First letter of First name only (watch out, Joe and Jerry may be reduced to one record)
For mailing lists, are 2 people with the same last name at the same address really 2 people? (Sometimes yes, sometimes no)