I am trying to do a SIMILAR TO query and can't this one worked out.

In my database I have "Robocop"

I want this to come back as a result if the user types in any of the following

Robocop Blu-ray
Robocop Trilogy
Robocop Collectors Edition
Critieon Collection Robocop

and so on.

I know how to look for the reverse (searching Robocop in a datafield with Robocop Blu-ray in it) but not this way.