The current CONTAINS operations are minimal. Only single word matches are allowed. See the attached references for more information.

See the topics on full text search for the current level of implementation.