--- title: Fuzzy Term description: Finds results that approximately match the query token, allowing for a certain edit distance canonical: https://docs.paradedb.com/documentation/query-builder/term/fuzzy-term --- Highlighting is not supported for `pdb.fuzzy_term`. For most use cases, we recommend using the [fuzzy query string](/documentation/full-text/fuzzy) syntax instead. `fuzzy_term` finds results that approximately match the query term, allowing for minor typos in the input. ```sql SELECT description, rating, category FROM mock_items WHERE description @@@ pdb.fuzzy_term('shoez') LIMIT 5; ```
Defines the term you are searching for within the specified field, using fuzzy logic based on Levenshtein distance to find similar terms. The maximum Levenshtein distance (i.e. single character edits) allowed to consider a term in the index as a match for the query term. Maximum value is `2`. When set to `true`, transpositions (swapping two adjacent characters) as a single edit in the Levenshtein distance calculation, while `false` considers it two separate edits (a deletion and an insertion). When set to `true`, the initial substring (prefix) of the query term is exempted from the fuzzy edit distance calculation, while false includes the entire string in the calculation.