My user has a 'wim wom slurping valve' so is looking for records containing the words 'wim' and/or 'wom' he will be most interested in records that contain either both words or a lot of references to wim or wom. the record with both words will be ranked above the record with only one word even if that record has lots of references to that word. A record with ten reference to wim will be ranked higher than a record with only five.
This has been a basic requirement for text searches ever since searching was possible so I am assuming that SQL Server can do it natively, and I would like to know which method to follow. (I'm also assuming there are lots of ways to do it!) My user is stupid so ideally shouldn't be asked to choose 'and' or 'or'.