title: Best way to search in a varchar column in sql server
body: <p>What would you recommend to search a sql server table (varchar(max) column) for a term?</p>
  
  <p>Let's say, like in ebay, if you search for "wii brand new", you get results like "Brand New Nintendo Wii Fit Game + Balance Board Bundle", "Wii Fit (Wii) BRAND NEW WII FIT GAME + BALANCE BOARD".</p>
  
  <p>I think it basically searches every word and returns the ones that contains all the words, what would you recommend?</p>