---
title: "Fuzzy search a text column in Strata | Oplema"
description: "Search a text column for close matches, even with typos, with Fuzzy Search. Every row is kept and ranked by a _fuzzy_score column, best match first."
url: "https://oplema.com/docs/strata/prep/fuzzy-search"
updated: "2026-11-04"
---

# Fuzzy Search

Fuzzy Search ranks rows by how closely a column resembles the text you type, even if letters are missing. It keeps every row and adds a \_fuzzy\_score column, highest first. Rows with no match get NULL and go last. Case is ignored.

**Learn this in context:** [More data tools: when you'd use each one](https://oplema.com/learn/table-to-dashboard/more-data-tools) (Build and publish a dashboard)

## Search company names

Manual Input holds four company names. Fuzzy Search looks for nrthwnd in the company column, with its vowels missing.

Result
| company | \_fuzzy\_score |
| --- | --- |
| Northwind Traders | 135 |
| North Wind Farm | 135 |
| Nordic Trade |  |
| Harbor Foods |  |

1. Look at the preview. Northwind Traders and North Wind Farm come first with a score of 135. Nordic Trade and Harbor Foods have NULL because they don't contain those letters in that order.
2. Change Query to `harbor`. Harbor Foods moves to the top with a score, and the other three have NULL.

## When to use

Use Fuzzy Search to find rows when you only roughly know how a value is spelled, such as a customer name typed in different ways. Follow it with Filter on \_fuzzy\_score to keep only the matches. To link two tables by similar text, use Fuzzy Match. To order rows exactly, use Sort.

To link two tables by similar text, use [Fuzzy Match](https://oplema.com/docs/strata/combine/fuzzy-match).

To keep only rows above a score, use [Filter](https://oplema.com/docs/strata/prep/filter).

## Inputs and outputs

### Inputs

1 port

**In Required**

Accepts: Tables, Geospatial data.

Accepts one connection on this port.

### Outputs

1 port

**Out**

## Configure the block

**Column**

Column to compare.

**Query**

Value to match against. Case is ignored.

## Fuzzy Search FAQs

**Does Fuzzy Search remove rows?**

No. It keeps every row. Rows with no match have NULL in \_fuzzy\_score and go last. To keep only matches, follow it with Filter on \_fuzzy\_score.

**Does case matter?**

No. Case is ignored when the column is compared with the query.

**How is it different from Fuzzy Match?**

Fuzzy Search compares one table with a term you type. Fuzzy Match links two tables by similar text.

### 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)
