Skip to main content

AutoMerge versus Native/OOB Merge

Dynamics 365 has duplicate detection and a merge dialog built in but they weren't designed for volume or for messy real-world data. Below is the comparison, capability by capability.

Verified against Microsoft's current duplicate detection and merge documentation, August 2026.

Matching duplicates

Native matching covers the basics: whole-string matches, partial ZIP matches, and criteria based on fields on the record itself, across a limited number of rule sets.

CapabilityNative CRMAutoMerge
Number of match rules allowedLimited to 5 published rules per tableUnlimited
Match on related-record fields (e.g. parent account's phone)NoYes
Alternate spellings, misspellings, phonetic matchingNoYes
Nickname matching ("Bob" = "Robert")NoYes
Phone punctuation ignored across formatsNoYes
Company name variants ("The Acme Company" = "Acme")NoYes
Street, state, and country address variantsNoYes
Cross-field matching (e.g. email1 matches email3)NoYes
Match precision score per duplicate setNoYes
Detection partitioning (e.g. by business unit)NoYes
Match Leads to existing Accounts/ContactsNoYes

The practical consequence of the first row: five published rules per table is a real ceiling. Most organizations need more than five ways of recognizing that two records are the same person.

Merging duplicates

Native CRM has a manual merge dialog for picking a winner and merging one set of two records at a time. It works. It isn't built for thousands of sets.

CapabilityNative CRMAutoMerge
Manual merge dialogYes (2 records)Yes 2
Duplicate sets merged per operationOne set of two recordsMultiple sets of two or more records each, in one click
Automatically merge all duplicate setsNoYes
Match precision score per setNoYes
Preserve populated fields otherwise lost on the loserNoYes
Address block preservation (kept together, not mixed)NoYes
Winner determined from the record's own fieldsYesYes
Winner determined from related-record fields (owning user, parent account, business unit, primary contact)NoYes
Quickly validate or change which record winsNoYes
Exclude records from future analysisNoYes
View historically merged loser records from the winnerNoYes
Dashboards of historical and upcoming mergesNoYes
Configure merges to run outside business hoursNoYes

2. The Potential Duplicates Grid (web resource) can be configured onto any CRM form of your choosing, and lets you view and merge 2 or more records at once. See Potential Duplicates subgrid.

The field-loss problem worth knowing about

Certain columns never appear in the native merge dialog at all: hidden columns, parentaccountid and parentcustomerid, Owner-type columns, and some Choice columns.

Because they aren't shown, their values on the losing record can't be selected, so they're silently lost. Nobody chose to discard them; the dialog simply never offered them.

AutoMerge preserves any populated field regardless of whether the native dialog would have displayed it.

When native merge is the right tool

It genuinely is, in one case: a handful of very large, relationship-heavy sets that time out even at the smallest Maximum Duplicate Set Size. Native merge runs asynchronously and escapes Microsoft's 2-minute synchronous plugin limit.

See Timeout errors for how to do that correctly, including the checkbox that preserves field data.