Match tracker

cvs sterling heights
doordash · 4025 18 Mile Road, Sterling Heights, MI, 48314
Joined with 7 other record(s) — by address+name, judge-same.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: cvs sterling heights✓ Street with a house number: 4025 18 Mile Road✓ ZIP: 48314✓ City + state: Sterling Heights, MI✓ Pin (lat/lng): 42.59415, -83.07014✗ Phone

2. Address joined

Is anyone else at this street + ZIP?
4 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
11 maddress+name rule: passes (name similarity 0.45)joined (address+name)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: passes (name similarity 0.45)joined (address+name)
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)joined (judge-same)
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)same outlet (through another record)

3. City key joined

Anyone at this street in this city (no ZIP needed)?
4 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
11 maddress+name rule: passes (name similarity 0.45)joined (address+name)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: passes (name similarity 0.45)joined (address+name)
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)joined (judge-same)
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)same outlet (through another record)

4. Street spelling found, not joined

Same house number, street written differently?
2 found (2 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
ab-inbev CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
11 mstreet-variant rule: does not passjoined (judge-same)
vtinfo CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
17 mstreet-variant rule: does not passsame outlet (through another record)

5. Nearby pins found, not joined

Anyone within 100 m?
7 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.
RecordDistanceWhat the rule saysWhat the master did
ubereats CVS
4025 EIGHTEEN MILE ROAD, STERLING HEIGHTS, MI, 48160
9 mstratum proximityjoined (judge-same)
ab-inbev CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
11 mstratum nearjoined (judge-same)
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
11 mstratum addr-agreejoined (address+name)
vtinfo CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
17 mstratum nearsame outlet (through another record)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 mstratum addr-agreejoined (address+name)
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 mstratum same-addressjoined (judge-same)
1 more
RecordDistanceWhat the rule saysWhat the master did
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 mstratum same-addresssame outlet (through another record)

6. Claude judge joined

What did Claude's judge say?
answered 3 pair(s); its 'same' joined
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 withAnswerWhat the master did
ubereats CVS
4025 EIGHTEEN MILE ROAD, STERLING HEIGHTS, MI, 48160
claude-haiku-5-5:v4:medium: same (0.93) — Both records give the same street address (4025 Eighteen Mile Road, Sterling Heights, MI) with coordinates about 9 m apart, the only business at that address in our data, and both are named CVS, so they are one CVS store listed on two deliv
claude-haiku-5-5:v7:medium: same (0.93) — Both records are CVS at 4025 Eighteen Mile Road, Sterling Heights, with coordinates about 9 m apart, one business at the address, and no separate suite or competing business; the ZIP differs (48314 vs 48160), which is a minor discrepancy, a
claude-opus-5-5:v7:medium: same (0.93) — Both records are the CVS at 4025 18 (Eighteen) Mile Road in Sterling Heights, 9 m apart, and it is the only business our data holds at that address; the differing ZIP on the Uber Eats record looks like a data error.
claude-haiku-5-5:v9:medium: same (0.93) — Both records are CVS at the same street address (4025 Eighteen Mile Road, Sterling Heights) with coordinates 9 m apart, the only business at that address; the DoorDash and Uber Eats listings are one store's storefronts, and Michigan's rule
claude-opus-5-5:v12:low · pinned: same (0.90) — Same CVS address; ZIP typo on one side
joined (judge-same)
ab-inbev CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
claude-haiku-5-5:v9:medium: same (0.90) — Both records are CVS at the same street address in Sterling Heights, MI (4025 Eighteen Mile Rd, distance 0.011 km, one business at the address), and Michigan's rule makes a chain store's alcohol listing its own in-store department, so this
claude-opus-5-5:v12:low · pinned: same (0.93) — CVS same address; pharmacy is same store
joined (judge-same)
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
claude-haiku-5-5:v9:medium: same (0.93) — Both records are CVS at 4025 18 Mile Road, Sterling Heights, MI 48314 (coordinates within about 60 m), with the DoorDash listing matching the CVS pharmacy licensed premises, and Michigan's rule treats a chain store's alcohol listing at its
claude-opus-5-5:v12:low · pinned: same (0.90) — Same CVS store address; pharmacy listing is same outlet.
joined (judge-same)

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 7 other record(s)
Outlet O0e2bb8eadc93: 8 record(s) from ab-inbev, cvs, doordash, mi-lcc, overture, ubereats, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
ubereats CVS
4025 EIGHTEEN MILE ROAD, STERLING HEIGHTS, MI, 48160
9 maddress+name rule: does not pass (name similarity 1.00)joined (judge-same)
ab-inbev CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
11 maddress+name rule: does not pass (name similarity 0.45)joined (judge-same)
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
11 maddress+name rule: passes (name similarity 0.45)joined (address+name)
vtinfo CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
17 maddress+name rule: does not pass (name similarity 0.45)same outlet (through another record)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: passes (name similarity 0.45)joined (address+name)
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)joined (judge-same)
1 more
RecordDistanceWhat the rule saysWhat the master did
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)same outlet (through another record)
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.