Add built in functions to compare texts in popular algorithms

FirebirdSQL / firebird

Firebird server, client and tools

https://firebirdsql.org

1.26k stars 217 forks source link

Add built in functions to compare texts in popular algorithms #8297

Open livius2 opened 3 weeks ago

livius2 commented 3 weeks ago

Add built in functions to compare texts in popular algorithms:

Jaro
Jaro-Winkler
Levenshtein
Damerau-Levenshtein
Hamming Distance (simple i know)
Cosine Similarity
....

asfernandes commented 3 weeks ago

External functions can be created. I don't think this is general enough to be in the engine. Never heard about them.

livius2 commented 3 weeks ago

@asfernandes Consider Firebird as a versatile tool with numerous built-in functions and a strong presence worldwide. Currently, many people use functions like hash functions built into Firebird, rather than relying on external libraries (i know 3 developers doing this as embeded FB ;-).

However, string comparison (similarity) functions are closely related to data processing, and having these built in would be highly beneficial. Right now, we use a UDF for this purpose.