Dear All,
I am trying with utl_match.jaro_winkler_similarity function in my code for search related scenarios.
I have tried utl_match.jaro_winkler_similarity function by replacing oracle text index contains - fuzzy function.
utl_match.jaro_winkler_similarity (string1, string2) >= 77
gives the most possible values like oralce text index fuzzy. It gives the fast result comparing to text index fuzzy. Most importantly it retrieves the tuples which are not retrieved by oracle text index fuzzy with default score of 60. Fuzzy is not working for numeric values, rather utl_match.jaro_winkler_similarity successfully retrieves numeric values.
I have two questions.
1. Can i use utl_match.jaro_winkler_similarity function instead of oracle text index - fuzzy? Is there any limitations by using this utl_match function?
2. Can i create a function based index on utl_match.jaro_winkler_similarity to improve performance?
Regards,
Suresh.