---
title: "Fuzzy match tables on similar text in Strata | Oplema"
description: "Join two tables on similar text, such as misspelled company names, with Fuzzy Match. Each pair gets a score from 0 to 100, and you set the cutoff."
url: "https://oplema.com/docs/strata/combine/fuzzy-match"
updated: "2026-11-04"
---

# Fuzzy Match

Fuzzy Match links rows from two tables when text columns are similar, not identical. Each pair of values is scored from 0 to 100, ignoring case and outer spaces. Rows link when every pair reaches the Threshold. Matched has the linked rows and a \_match\_score column. Left and Right have the rows that found no match. Blocking Keys compare only rows that share an exact value, which is much faster on large tables. Keep decides whether each Left row gets its best match or all of them.

**Learn this in context:** [Match misspelled names between two tables](https://oplema.com/learn/many-sources/match-misspelled-names) (Combine and reconcile data files)

## Match vendor names

The Left input has three vendors and the Right input has three invoices. Names are compared with Threshold 60, only within the same city.

Result
| company | city |
| --- | --- |
| Harbor Foods | Lima |

1. The preview opens on OUTPUT LEFT with one row: Harbor Foods has no invoice similar enough.
2. Select OUTPUT MATCHED above the preview, or the middle output port on the block. It has two pairs: Acme Ltd with ACME Limited, scored about 93, and Mesa Supply with Mesa Suply, about 98.
3. Select OUTPUT RIGHT. Tidewater Paper is the invoice that matched nothing.
4. Change Threshold to `95` and select OUTPUT MATCHED. Only Mesa Supply remains, and Acme Ltd moves to OUTPUT LEFT.

## When to use

Use Fuzzy Match when the same thing is written differently in two tables, such as ACME Limited and Acme Ltd, and there's no shared ID. Add a blocking key such as city or country to avoid comparing every row with every other row. For exact keys, use Join. To search one table for a typed term, use Fuzzy Search.

For exact key matches, use [Join](https://oplema.com/docs/strata/combine/join).

To rank one table against a typed term, use [Fuzzy Search](https://oplema.com/docs/strata/prep/fuzzy-search).

## Inputs and outputs

### Inputs

2 ports

**Left Required**

Accepts: Tables, Geospatial data.

Accepts one connection on this port.

**Right Required**

Accepts: Tables, Geospatial data.

Accepts one connection on this port.

### Outputs

3 ports

**Left**

**Matched**

**Right**

## Configure the block

**Match Fields**

Text column pairs to compare. A row links only when every pair clears the threshold.

**Blocking Keys**

Optional column pairs that must be exactly equal for two rows to be compared at all. Leave empty to compare every Left row against every Right row.

**Similarity**

Jaro-Winkler favors matching prefixes and suits names. Edit distance counts insert/delete/substitute/transpose edits and suits typos. Character overlap ignores order and suits reordered tokens.

Default: `Jaro-Winkler`

Options: Jaro-Winkler, Edit distance, Character overlap.

**Threshold**

Minimum similarity (0-100) a pair must reach to count as a match. Higher is stricter.

Default: `85`

**Keep**

Best match keeps only the closest Right row for each Left row. All matches keeps every Right row above the threshold.

Default: `Best match`

Options: Best match, All matches.

**Columns**

Shape the Matched output: keep, drop, reorder, rename or cast each column, including \`\_match\_score\`. Use the output names: the right blocking key is dropped, and shared names end in \_left or \_right. Leave empty to keep every column and the score. Left and Right don't change.

## Fuzzy Match FAQs

**What does \_match\_score mean?**

It's the lowest Match Fields similarity for the pair, from 0 to 100. A row links only when every Match Fields pair reaches the Threshold.

**What do Blocking Keys do?**

They compare only rows that share an exact value in the chosen columns, which is much faster on large tables. Leave them empty to compare every Left row with every Right row.

**What is the difference between Best match and All matches?**

Best match keeps only the closest Right row for each Left row. All matches keeps every Right row at or above the Threshold.

### Prepare your data. Build it in Strata.

Strata opens in your browser, with no account.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
