Is this the right way to use "contains keyword(s)"?

[tqecampos]

Hey guys, I want to know if this is the right way to use the “contains keyword(s)” constraint:

I need to retrieve any of these three variations.

[dorilama]

an example:
contains keywords the cat is on the table

will match these value in the database (just some example):
cat table
CAT table
the cat is on the yellow table
the table is a cat
your cat is not a TABLE
I think my TaBLe is a Cat
one cat plus one cat equals a table
many cats on the table
tables cat
tables cats

but it will not match:
the cat is on the tablet
catss table
i just have one cat
the table is empty

I hope this helps

Cheers
Mariano

[NigelG]

You might be better off making the input lowercase, and then matching with a lowecased “skilled”.

[dorilama]

being this a database search wouldn’t “contains keywords skilled” be easier?
It will match any string with skilled regardless of the case without the need to transform the strings yourself.
I wonder how the speed of a search in a database is affected when using “contains keywords”