Databases are great at finding data, provided you know exactly what you’re looking for. As an example, consider the names listed below:

DavidAnders
DavdAnderson
David Andersen

It’s easy enough for the human eye to see that these names are similar. The problem is, how do you get software to recognize and rank their similarity? Fortunately for us, large, well-funded organizations such as the US Census Bureau have spent a great deal of money and effort developing effective fuzzy matching techniques. The FuzzyTools component brings a suite of fuzzy comparisons tools to 4th Dimension.

Download Complete Tech Note and Example: Windows | Mac