Fuzzy Term
fuzzy_term.Basic Usage
fuzzy_term finds results that approximately match the query term,
allowing for minor typos in the input.
value is treated as a token. Use fuzzy_phrase to perform fuzzy search over
a phrase containing multiple tokens.
SELECT * FROM search_idx.search(
query => paradedb.fuzzy_term(field => 'description', value => 'wolo')
);
Specifies the field within the document to search for the term.
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.
Was this page helpful?