0

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

hidross
  • 123
  • 3
  • 16

1 Answers1

1

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 :)

Lars G Olsen
  • 1,093
  • 8
  • 11