with
patt as(select 'bbb' p1, 'ccc' p2 from rdb$database)
,data as(
 select 'aaa bbb ccc ddd' s from rdb$database union all
 select 'zzz ccc aaa bbb' s from rdb$database union all
 select 'bbb aaa xxx ccc' s from rdb$database union all
 select 'ccc aaa xxx ccc' s from rdb$database union all
 select 'bbb fff ggg bbb' s from rdb$database union all
 select 'ccc aaa ddd yyy' s from rdb$database
)
select d.*
from data d,patt p
where
     d.s similar to '%'||p.p1||'%'||p.p2||'%'
     or
     d.s similar to '%'||p.p2||'%'||p.p1||'%'