Contains Searching

The contains uses SQL Full Text Indexing, which works with word separators, basically anything that isn't A-Z or 0-9 is a separator. Anything between separators is considered 'word' that can be searched, but you do have to search for the full word. Partial word matching isn't supported.