Not all diakritika are converted

[holgergrote]

In the SQL Version some 'Diakritische Zeichen' like é are encoded, but a lot are missing like óoôîêâ

In Oracle are some functions to change these characters.
One solution coud be to use
utl_raw.cast_to_varchar2(nlssort(, 'nls_sort=binary_ai'))

With this the ß does also not need the replaced manually. The result would be:

   word := regexp_replace(
       utl_raw.cast_to_varchar2(nlssort(
           replace(
               translate(word, 'vwjy', 'ffii'),
           'ph', 'f'),
       'nls_sort=binary_ai')),
   '[^a-z]', ' ');