Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE subs (
   word VARCHAR(50),
   subs_list VARCHAR(500)
)
INSERT INTO subs (word, subs_list)
VALUES('MOUNTAIN',('MOUNTAIN, MOUNT, MT, MTN'));
1 rows affected

INSERT INTO subs (word, subs_list)
VALUES('VIEW',('VIEW, VU'));
1 rows affected

SELECT * FROM subs


WORD
SUBS_LIST


MOUNTAIN
MOUNTAIN, MOUNT, MT, MTN

VIEW
VIEW, VU


CREATE TABLE syns (
   word VARCHAR(50),
   syn_list VARCHAR(500)
)
INSERT INTO syns (word, syn_list)
VALUES('EDUCATION',('SCHOOL, UNIVERSITY, COLLEGE, TRAINING'))
1 rows affected

INSERT INTO syns (word, syn_list)
VALUES('FOOD',('BAR, CAFE, CANTINA, FOOD, RESTAURANT'))
1 rows affected

select * from syns


WORD
SYN_LIST


EDUCATION
SCHOOL, UNIVERSITY, COLLEGE, TRAINING

FOOD
BAR, CAFE, CANTINA, FOOD, RESTAURANT


CREATE TABLE institutions ( name ) AS
SELECT 'FORMULA VIEW UNIVERSITY'    FROM DUAL UNION ALL
SELECT 'FOURMULAE VULCAN COLLEGE' FROM DUAL UNION ALL
SELECT '4MULA VU CAFE' FROM DUAL;
3 rows affected

SELECT * FROM institutions


NAME


FORMULA VIEW UNIVERSITY

FOURMULAE VULCAN COLLEGE

4MULA VU CAFE


create or replace function replace_synonyms(i_text in varchar2) return varchar2
is
    p_text varchar2(4000) := i_text;

    cursor c_subs is
    select word, trim(column_value) text 
      from subs, xmltable(('"' ||replace(subs_list, ',', '","') || '"'))
      where p_text like '%'||trim(column_value)||'%'
    union 
    select word, trim(column_value) text 
      from syns, xmltable(('"' ||replace(syn_list, ',', '","') || '"'))
      where p_text like '%'||trim(column_value)||'%';
      
begin
   for i in c_subs
    loop
      p_text := regexp_replace(
          p_text, '(^|[^a-z0-9])' || i.text || '($|[^a-z0-9])', 
          '\1' || i.word || '\2', 1, 0,  'i');
    end loop;

   return p_text;
end;
/
SELECT name, replace_synonyms(name) corrected_name
FROM   institutions
WHERE  replace_synonyms(name) LIKE replace_synonyms('FORMULA VU SCHOOL')


NAME
CORRECTED_NAME


FORMULA VIEW UNIVERSITY
FORMULA VIEW EDUCATION
WORD	SYN_LIST
EDUCATION	SCHOOL, UNIVERSITY, COLLEGE, TRAINING
FOOD	BAR, CAFE, CANTINA, FOOD, RESTAURANT