Duplicate Name Search – query #duplicates #names

This query lists duplicate name pairs with a weighted score indicating the degree of match similar to RootsMagic 4’s Duplicate Search Merge tool. On a large database, it produced useful results in 4.5 minutes compared to 45 minutes for RM4. It operates with fixed settings similar to DSM’s default settings, e.g. Birth Years within 2 years of each other. In use, one would run the query to produce a report and from its list carry out Manual Merge in RootsMagic.

Download: DuplicateNameSearch.sql RMtrix_tiny_check.png

SQLite-DuplicateNameSearch-screenshot.png
Screenshot of results of DuplicateNameSearch query
RM4-DuplicateSearchMerge-screenshot.png
Screenshot of RootsMagic Duplicate Search Merge

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.