select CLI_DIRECCION,
(case when CLI_DIRECCION containing :PALABRA1 then 1 else 0 end +
case when CLI_DIRECCION containing :PALABRA2 then 1 else 0 end +
case when CLI_DIRECCION containing :PALABRA2 then 1 else 0 end) as COINCIDENCIAS
from CL_CLIENTES
where CLI_DIRECCION containing :PALABRA1 or
CLI_DIRECCION containing :PALABRA2 or
CLI_DIRECCION containing :PALABRA3
order by COINCIDENCIAS descending