Pricing

from $2.00 / 1,000 reconciled rows

Fuzzy List Reconciler - VLOOKUP That Tolerates Typos

Fuzzy-join two lists (CSV/JSON) on a key column with a similarity threshold. Returns matched pairs with scores, plus unmatched and near-match rows.

Pricing

from $2.00 / 1,000 reconciled rows

Rating

0.0

(0)

Developer

Simon Fletcher

Actor stats

Bookmarked

Total users

Monthly active users

5 days ago

Last modified

Categories

Developer tools

Left list (data)

leftData

Required

The FIRST list to reconcile. Paste a JSON array of objects, CSV text (with a header row), an http(s) URL to a JSON/CSV file, or base64 content prefixed with 'base64:'. Format is auto-detected.

Type:string

Right list (data)

rightData

Required

The SECOND list to reconcile against the first. Same accepted formats as the left list (JSON array, CSV text, http(s) URL, or 'base64:' content). Format is auto-detected.

Type:string

Left key column(s)

leftKey

Required

Column name in the left list to match on. For a composite key, list several columns comma-separated (e.g. 'first_name,last_name'). Values are joined before comparison.

Type:string

Example:company

Right key column(s)

rightKey

Required

Column name in the right list to match on. Must have the same NUMBER of columns as the left key (composite keys are compared position-by-position).

Type:string

Example:name

Similarity algorithm

algorithm

Optional

String-similarity metric. jaro_winkler favours matching prefixes (best for names). levenshtein is classic edit distance. token_sort / token_set ignore word order (good when tokens are reordered or one string is a subset).

Type:string

Default:jaro_winkler

Options:

jaro_winklerlevenshteintoken_sorttoken_set

Match threshold

threshold

Optional

Minimum similarity (0.0-1.0) for a pair to count as a MATCH. 0.85 is a good default; lower it to catch looser matches, raise it to be stricter.

Type:number

Minimum:0

Maximum:1

Default:0.85

Match strategy

matchStrategy

Optional

best_one_to_one: each row on either side is used at most once (true reconciliation). best_per_left: each left row takes its best right match (right rows may repeat, like VLOOKUP). all_above_threshold: emit every pair at/above the threshold (many-to-many).

Type:string

Default:best_one_to_one

Options:

best_one_to_onebest_per_leftall_above_threshold

Normalize keys

normalize

Optional

Fold accents, strip punctuation, collapse whitespace and lowercase key values before comparing. Strongly recommended.

Type:boolean

Default:true

Case sensitive

caseSensitive

Optional

Keep letter case when comparing. Ignored effect when Normalize is on (normalization lowercases). Default off.

Type:boolean

Default:false

Near-match margin

nearMatchMargin

Optional

How far BELOW the threshold a left row's best candidate can be and still be reported as a 'near_match' for manual review. E.g. threshold 0.85 and margin 0.15 reports best candidates scoring 0.70-0.849.

Type:number

Minimum:0

Maximum:1

Default:0.15

Include unmatched rows

includeUnmatched

Optional

Emit unmatched_left and unmatched_right records (rows with no match). Turn off to output only matched pairs.

Type:boolean

Default:true

Include near matches

includeNearMatches

Optional

Emit near_match records (best candidate just below the threshold) to help you tune the threshold.

Type:boolean

Default:true

Left format (advanced)

leftFormat

Optional

Override auto-detection of the left list format.

Type:string

Default:auto

Options:

autojsoncsv

Right format (advanced)

rightFormat

Optional

Override auto-detection of the right list format.

Type:string

Default:auto

Options:

autojsoncsv

Fuzzy Search Dataset Actor

dtrungtin/fuzzy-search-dataset-actor

Search any Apify dataset using typo-tolerant fuzzy matching.

Tin

Content Similarity Finder

fiery_dream/content-similarity-finder

Find duplicate and similar content with advanced fuzzy matching algorithms. Perfect for data cleaning and deduplication.

Cody Churchwell

Fuzzy CSV Reconciler Actor for Insurance Claim Registers

armourylabs/fuzzy-csv-reconciler-actor-for-insurance-claim

Reconciles insurer bordereaux against internal claim registers: exact and fuzzy key matching, amount tolerance checks, unmatched-row surfacing, and a forwardable mismatch report per run. Deterministic difflib matching — no AI. CSV in, forwardable JSON report out. Built for broker ops and MGAs.

Christopher Smith

Entity Deduplication Matcher

junipr/entity-deduplication-matcher

Fuzzy-match and deduplicate company, product, location, or entity rows into canonical records.

junipr

HubSpot Company Enrichment & Fuzzy Matcher for Clay

alizarin_refrigerator-owner/hubspot-company-enrichment-fuzzy-matcher-for-clay

Fuzzy match and enrich companies against your HubSpot CRM using multi-signal matching (domain, company name, phone, location). Returns HubSpot ID, lifecycle stage, deal status & confidence scores. Perfect for Clay workflows, lead deduplication, and outbound enrichment.

The Howlers

OFAC Sanctions List Search — SDN Screening with Fuzzy Matching

ryanclinton/ofac-sanctions-search

Screen names against the US Treasury OFAC SDN sanctions list and get a decision, not just rows: a clear / potential-match / likely-match verdict per subject, plus false-positive resolution that explains why a hit is NOT the sanctioned person. Batch screening, watchlist monitoring, no API key.

Ryan Clinton

Join.com Jobs Scraper

fantastic-jobs/join-jobs-scraper

A simple Join.com Jobs Scraper with Title, Locations, Description, and Date. Extract job postings from any Join.com career page!

Fantastic.jobs

Dataset Join and Enrichment

eager_vitamin/apify-dataset-join-enrichment

Join and enrich two Apify datasets by URL, ID, or another stable key with bounded, collision-safe output.

Lau Kuan Ee

Songkick Scraper

hoholabs/songkick-scraper

No API key. No URL hunting. Type an artist, city, or venue in plain English — fuzzy matching handles typos and punctuation automatically. Extracts upcoming concert data from Songkick: tour dates, venues, performers, ticket links, and geo coordinates in clean normalized JSON.