Data deduplication key collision audit calculator

Calculate repeated key groups [key,count] and conflicting payload key IDs with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use repeated key groups [key,count] and conflicting payload key IDs to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

JSON Rows [business key string,canonical payload JSON value]
[["A",{"v":1}],["A",{"v":1}],["B",{"v":2}],["B",{"v":3}]]
Repeated key groups [key,count]
[["A",2],["B",2]]
Conflicting payload key IDs
["B"]
Rows beyond first per key
2

Try another scenario

JSON Rows [business key string,canonical payload JSON value]
[["A",{"v":1}],["A",{"v":2}],["B",{"v":2}],["B",{"v":2}]]
Repeated key groups [key,count]
[["A",2],["B",2]]
Conflicting payload key IDs
["A"]
Rows beyond first per key
2
Calculation method

Calculation method

Repeated key groups [key,count]

Exact business-key groups with more than one row.

Conflicting payload key IDs

Repeated key groups with more than one canonical JSON payload.

Rows beyond first per key

Sum group count−1 across all groups.

Symbols and units
a
JSON Rows [business key string,canonical payload JSON value]

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Full row/payload collision audit. Keys are explicitly supplied business keys; payload identity uses recursively sorted-key canonical JSON with 12 significant digit numeric display convention. No automatic destructive merge. Supported limits: 1–1000 rows; payload JSON finite, depth≤8, serialized length≤10000 per row.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.