Is there an EF Core function (using SQL Server) to calculate levenshtein distance or a similar string comparison to sort a table by string similarity?

Asked Jul 29 '22 at 13:29

Active Jul 29 '22 at 15:54

Viewed 362 times

I found EF.Functions.TrigramsSimilarityDistance at https://github.com/npgsql/npgsql for postgresql.

And I found a raw sql solution here:

I could use by implementing a stored procedure but I would prefer a SQL or EF function..

edited Jul 29 '22 at 15:54

marc_s

asked Jul 29 '22 at 13:29

Max

2

[Levenshtein distance in T-SQL](https://stackoverflow.com/questions/560709/levenshtein-distance-in-t-sql) has SQL solutions though.. What's wrong with them? – Thom A Jul 29 '22 at 13:32
Create a T-SQL function then call it using function mapping https://learn.microsoft.com/en-us/ef/core/querying/user-defined-function-mapping – Charlieface Jul 29 '22 at 13:36
Yes, I guess that is what I will have to do, but I was hoping there was a solution with documentation/ support for instance included in a nuget package similar to the one for postgresql – Max Aug 01 '22 at 09:54

0 Answers0