Netezza string searching (fuzzy searching)

648 views Asked by At

As far as I know Netezza for string searching only offers two functions le_dst(str_expr_1, str_expr_2) and dle_dst (str_expr_1, str_expr_2) as mentioned here

Are there any other more advanced options for fuzzy searching in netezza like oracle has Oracle Text for example

1

There are 1 answers

0
Lars G Olsen On BEST ANSWER

Apart from Those two fuzzy matching functions, there are a couple of phonetic matching functions as well. See these:

https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.dbu.doc/r_dbuser_functions_expressions_phonetic_funcs.html

I hope that helps in your case :)