Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions

Question

Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions

utsav

Old Hand

Points: 339
More actions
March 28, 2025 at 12:00 am

#4566122

Comments posted to this topic are about the item Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32416 More actions · Answer 1

Thanks for mentioning the new interesting commands.

According to https://learn.microsoft.com/en-us/sql/t-sql/functions/jaro-winkler-distance-transact-sql?view=azuresqldb-current it's still in preview

Jeff Moden SSC Guru Points: 1004589 More actions · Answer 2

I wonder what the "compute cost" of these new functions is?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

utsav Old Hand Points: 339 More actions · Answer 3

You are right. Its still in preview mode but you can try it on Azure SQL right now.

utsav Old Hand Points: 339 More actions · Answer 4

These functions cause index scan. I have not done deep analysis, but I am assuming it will similar to any scan operation.

MMartin1 One Orange Chip Points: 27839 More actions · Answer 5

Jeff Moden wrote:

I wonder what the "compute cost" of these new functions is?

I dont imagine this type of processing being done on a live OLTP system. More likely a read only DB or some type of warehouse.

A question I have: I wonder if column store indexes would help with the efficiency of this type of processing.

----------------------------------------------------

Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions

Cookies on SQLServerCentral