title: Magento search not showing relevant results
body: <p>My magento store is having trouble showing relevant results when it comes to the search. A perfect example is: </p>
  
  <p><a href="http://supercb.com/catalogsearch/result/?q=cobra+ltd" rel="nofollow">http://supercb.com/catalogsearch/result/?q=cobra+ltd</a></p>
  
  <p>As you can see further down the page there are several products that have "cobra ltd" in the name however they are not at the top of the results. I have the search set to fulltext and only the name attribute is searchable. The minimum search query is set at 2, although the mysql configuration (ft_min_word_length) is at 3. Also in the mage core I changed the like condition to</p>
  
  <pre><code>$likeCond = '(' . join(' AND ', $like) . ')';
  </code></pre>
  
  <p>I've cleared the cache and database results and still am having no luck. Does anyone have any ideas why my search isn't working properly? And since a lot of my products have 2 letter parts to the names will I have to change the mysql config? (Not sure if that is possible on hostgator)</p>