Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (A, B) AS
SELECT 'stack',   'stock'    FROM DUAL UNION ALL
SELECT 'müll',    'mall'     FROM DUAL UNION ALL
SELECT 'müll',    'mall'     FROM DUAL UNION ALL
SELECT 'déja-vu', 'deja-vu'  FROM DUAL UNION ALL
SELECT 'château', 'château!' FROM DUAL;
5 rows affected

SELECT a,
       b,
       DUMP(a),
       DUMP(b),
       UTL_MATCH.EDIT_DISTANCE(a, b) AS edist
FROM   table_name


A
B
DUMP(A)
DUMP(B)
EDIST


stack
stock
Typ=1 Len=5: 115,116,97,99,107
Typ=1 Len=5: 115,116,111,99,107
1

müll
mall
Typ=1 Len=5: 109,195,188,108,108
Typ=1 Len=4: 109,97,108,108
2

müll
mall
Typ=1 Len=6: 109,117,204,136,108,108
Typ=1 Len=4: 109,97,108,108
3

déja-vu
deja-vu
Typ=1 Len=8: 100,195,169,106,97,45,118,117
Typ=1 Len=7: 100,101,106,97,45,118,117
2

château
château!
Typ=1 Len=8: 99,104,195,162,116,101,97,117
Typ=1 Len=9: 99,104,195,162,116,101,97,117,33
1

A	B	DUMP(A)	DUMP(B)	EDIST
stack	stock	Typ=1 Len=5: 115,116,97,99,107	Typ=1 Len=5: 115,116,111,99,107	1
müll	mall	Typ=1 Len=5: 109,195,188,108,108	Typ=1 Len=4: 109,97,108,108	2
müll	mall	Typ=1 Len=6: 109,117,204,136,108,108	Typ=1 Len=4: 109,97,108,108	3
déja-vu	deja-vu	Typ=1 Len=8: 100,195,169,106,97,45,118,117	Typ=1 Len=7: 100,101,106,97,45,118,117	2
château	château!	Typ=1 Len=8: 99,104,195,162,116,101,97,117	Typ=1 Len=9: 99,104,195,162,116,101,97,117,33	1