Re^2: Module to intelligently handle names with two last names and other best practices?

[AnomalousMonk]

... index the full names by *all* the words ...

I don't understand that. Wouldn't that just result in an index choked with a zillion John/Jan/Jacob/Juan/Joan/Ioan/Ian/Ivan/... useless entries (and that's just a few of the European variations of the male version of one, simple given name). I agree it's a very frustrating problem. In the end, aren't we stuck with coming up with some massive AI to figure it all out and keep it straight and usable?

[BrowserUk]

Yes, but it can allow you to match "J L Smith" against "Mr John L. Smith" or even "Jim Smithe" and similar variations. Usually that alone won't be enough, but combined with other data and perhaps human oversight it can allow you to detect/eliminate duplicates. (You do have to be careful of John Smith Senior and John Smith Junior who live at the same address.)

I implemented this years ago on a 6 million name dataset and it (helped) illiminate over 20,000 misreads, data entry errors and fraudulent attempts. The indexes were implemented as bitfields -- 1 bit per full name -- which allowed any entry to be rapidly compared against all the names and reduced to a tiny subset of the 6 million for further manual investigation.