구글링하다가 문자열 유사도를 확인할 수 있는 패키지를 찾아서
어쩌면 유용하게 사용할 수도 있을 것 같아서 올려봅니다.
SELECT UTL_MATCH.EDIT_DISTANCE_SIMILARITY ('gurubee oracle', 'gurubee oramaster') EDS
--Calculates the number of changes required to transform string-1 into string-2, returning a value between 0 (no match) and 100 (perfect match)
,UTL_MATCH.JARO_WINKLER_SIMILARITY ('gurubee oracle', 'gurubee oramaster') JWS
--Calculates the measure of agreement between string-1 and string-2, returning a value between 0 (no match) and 100 (perfect match)
FROM DUAL
https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/u_match.htm