By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select *
from (select 'SHIPPING ITEM' as col from dual union all
select 'SPINDLE PIN' from dual union all
select 'BASEBALL' from dual union all
select 'BALL' from dual
) x cross join
(select 'PIN,BALL' as words from dual) w
where regexp_like(' ' || col || ' ', '\W' || replace(w.words, ',', '\W|\W') || '\W')
| COL | WORDS |
|---|---|
| SPINDLE PIN | PIN,BALL |
| BALL | PIN,BALL |