When I helped create a database and user interface a few years back for a company to track their testing for book titles, we included a "Find Similar" function which was extremely useful. It allowed the user to set a threshold for similarity (what % of words were identical, with some extremely common words like "the" and "an" omitted) and pull up a found set of similar titles.
Such a function would be extremely useful to me in Donorview, especially when it comes to finding duplicate constituent records containing typos, or identifying constituents who share a business or household. I would love to be able to find similar names, emails, phone numbers, addresses, etc.
Paul
When I helped create a database and user interface a few years back for a company to track their testing for book titles, we included a "Find Similar" function which was extremely useful. It allowed the user to set a threshold for similarity (what % of words were identical, with some extremely common words like "the" and "an" omitted) and pull up a found set of similar titles.
Such a function would be extremely useful to me in Donorview, especially when it comes to finding duplicate constituent records containing typos, or identifying constituents who share a business or household. I would love to be able to find similar names, emails, phone numbers, addresses, etc.