Match tracker
TOTAL WINE, SPIRITS, BEER & MORE
mi-lcc · 1242 S Rochester Rd, Rochester Hills, MI, 48307
Joined with 6 other record(s) — by address+name, duplicate-listing.
1. Record ready
What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: TOTAL WINE, SPIRITS, BEER & MORE✓ Street with a house number: 1242 S Rochester Rd✓ ZIP: 48307✓ City + state: Rochester Hills, MI✓ Pin (lat/lng): 42.66342, -83.13318✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
4 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc TOTAL WINE, SPIRITS, BEER & MORE 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| ubereats Total Wine & More 1242 South Rochester Rd, Rochester Hills, MI, 48307 | 213 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| totalwine Total Wine & More 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 259 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| overture Total Wine & More 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 259 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
4 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc TOTAL WINE, SPIRITS, BEER & MORE 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| ubereats Total Wine & More 1242 South Rochester Rd, Rochester Hills, MI, 48307 | 213 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| totalwine Total Wine & More 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 259 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| overture Total Wine & More 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 259 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
4. Street spelling found, not joined
Same house number, street written differently?
2 found (2 from another source); none joined by this step
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ab-inbev TOTAL WINE & MORE 1242 S ROCHESTER, ROCHESTER, MI, 48307 | 56 m | street-variant rule: does not pass | same outlet (through another record) |
| vtinfo TOTAL WINE & MORE 1242 S ROCHESTER, ROCHESTER, MI, 48307 | 209 m | street-variant rule: does not pass | same outlet (through another record) |
5. Nearby pins found, not joined
Anyone within 100 m?
4 within 100 m — distance alone never merges; these are questions for Claude
Pins are often geocoded from the address itself, so two pins agree whenever the addresses do — they cannot confirm a match, and never merge on their own.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc TOTAL WINE, SPIRITS, BEER & MORE 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| ab-inbev TOTAL WINE & MORE 1242 S ROCHESTER, ROCHESTER, MI, 48307 | 56 m | stratum near | same outlet (through another record) |
| vtinfo X GOLF 1134 S ROCHESTER RD, ROCHESTER, MI, 48307 | 12 m | stratum control | not joined |
| ab-inbev X GOLF 1134 S ROCHESTER RD, ROCHESTER, MI, 48307 | 22 m | stratum control | not joined |
6. Claude judge found, not joined
What did Claude's judge say?
answered 1 pair(s)
Haiku screens every candidate pair; only Opus judge
claude-opus-5-5:v12:low can merge, at confidence ≥ 0.8, with a numbered street on both sides.| Pair with | Answer | What the master did |
|---|---|---|
| ubereats Total Wine & More 1242 South Rochester Rd, Rochester Hills, MI, 48307 | claude-haiku-5-5:v9:medium: same (0.93) — Both records sit at 1242 S Rochester Rd in Rochester Hills, MI with ZIP 48307, the only business at that address, and the licence's trade name 'Total Wine, Spirits, Beer & More' matches the Uber Eats chain store 'Total Wine & More', with th | joined (address+name) |
7. Web agent nothing found
What did the web agent find?
not asked
8. Person nothing found
What did a person answer?
no answers yet
9. Result joined
Where did it end up?
one outlet with 6 other record(s)
Outlet O06d2cfc197ae: 7 record(s) from ab-inbev, mi-lcc, overture, totalwine, ubereats, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc TOTAL WINE, SPIRITS, BEER & MORE 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| ab-inbev TOTAL WINE & MORE 1242 S ROCHESTER, ROCHESTER, MI, 48307 | 56 m | address+name rule: does not pass (name similarity 0.65) | same outlet (through another record) |
| vtinfo TOTAL WINE & MORE 1242 S ROCHESTER, ROCHESTER, MI, 48307 | 209 m | address+name rule: does not pass (name similarity 0.65) | same outlet (through another record) |
| ubereats Total Wine & More 1242 South Rochester Rd, Rochester Hills, MI, 48307 | 213 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| totalwine Total Wine & More 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 259 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| overture Total Wine & More 1242 S Rochester Rd, Rochester Hills, MI, 48307 | 259 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
Read-only. Every candidate is scored by the same code the master build uses, and "what the master did" is what the last build stored. Each search shows at most 40 records.