create or replace function abbr_replace ( str varchar2 )   
  return varchar2 deterministic as 
begin 
  return replace(  
	   replace(  
	     replace(  
	       replace( 
		 replace( lower( str ), 'preparatory', 'prep' ),  
		 'junior', 'jr'), 
	       'elementary school', 'es'),  
	     'alternative', 'alt' ),  
	   'elementary school', 'es'  
	 ); 
end abbr_replace; 

create table source1 ( 
  name         varchar2(100), 
  replace_name varchar2(100) as (  
    cast ( abbr_replace ( name ) as varchar2(100) )  
  ) 
)

create table source2 ( 
  name         varchar2(100), 
  replace_name varchar2(100) as (  
    cast ( abbr_replace ( name ) as varchar2(100) )  
  ) 
)

insert into source1 (name) values ('Adda Clevenger Jr Prep School')

insert into source1 (name) values ('Alice Fong Yu Alt School')

insert into source1 (name) values ('Convent Of Sacred Heart Es')

insert into source1 (name) values ('Rosa Parks Elementary School')

insert into source2 (name) values ('Adda Clevenger Junior Preparatory School')

insert into source2 (name) values ('Alice Fong Yu Alternative School')

insert into source2 (name) values ('Convent of Sacred Heart Elementary School')

insert into source2 (name) values ('Rosa Parks Elementary School')

commit

select s1.name, s2.name 
from   source1 s1 
join   source2 s2 
on     s2.replace_name = s1.replace_name

select s1.name, s2.name, utl_match.jaro_winkler(s1.name, s2.name) jw 
from   source1 s1 
join   source2 s2 
on     utl_match.jaro_winkler(s1.name, s2.name) > .9