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 
 |
| Screenshot of results of DuplicateNameSearch query |
 |
| Screenshot of RootsMagic Duplicate Search Merge |