Fuzzy search column values
fuzzy_search_columnFind rows with values similar to your search term using Jaro-Winkler fuzzy matching on a text column. Samples distinct values server-side and ranks them client-side.
Instructions
Jaro-Winkler fuzzy search over the distinct values of a single text column — use this to find rows whose value is close to (but not an exact match for) a search term. Samples up to sampleSize distinct values server-side, then ranks them client-side.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max results to return (default 20, max 100) | |
| table | Yes | Table or view name | |
| column | Yes | Text column to search — must exist on the table | |
| schema | Yes | Schema name, e.g. 'dbo' | |
| sampleSize | No | Max distinct values to scan server-side (default 2000, max 5000) | |
| searchTerm | Yes | Value to fuzzy-match against |