Visual for multi-word text search

Has anyone every found a solution or are they going to build a feature like this.  I would like to see if there is something like the SQL command "Like".  Select * from <table> where <field> like '%hello%Fred%'  This will search for a record that contains those 2 words in any patteren but the text filters only all you to searc if they contain those characters in the same patteren.