Logo Home    Page list

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

Screenshot of results of DuplicateNameSearch query

Screenshot of RootsMagic Duplicate Search Merge