Good day, all you SQL geniuses out there. I'm running into a bit of an issue. The firm I work at uses EXASOL SQL and I'm trying to get find a function that I can use in order to fuzzy match two strings.

For example, Let's say we have these two strings:

1. 123 ALPHABET STREET

2. 123 ALPHABET ST

I would want to know how similar those two strings are, but the Exasol SQL the firm uses (Metabase / Looker), does not appear to have functions like compged() or something similar. Does anyone out there have any functions that can help me with this?

Thank you!

CodePudding user response：

You can use EDIT_DISTANCE to compute the Levenshtein distance in exasol.

If you need a custom function to compute another distance metric you can define a User Defined Function (UDF) in Lua, Python, Java, or R.