HI All
I have a requirement wherein I need to find matching strings.
I need to scan all rows of table 1, pick column1 (varchar2(1000))
and scan table 2 for all the rows and find matching data in the
column2 of table2 (which is again varchar). This matching isnt simple
becuase the data might have typos, the texts might appear shuffled and
in addition, the text might have additional texts. However, What I need
is a match; I am aware of jaro wrinkler alogorithm but I want to use that
very cautiously as the matched data will is business critical.
pls help