title: How to find similar products
body: <p>I am creating price comparison website in php and mysql. so i need to find similar products and map it to create price comparison table. In my database 10,000+ products are available, so to find similar products i have create mysql fulltext index in product name and description columns and compare product with other products, but i can't get desire result, for example if i Search</p>
  
  <p>Search for "Samsung Galaxy A7 (2017) 32gb", get results:</p>
  
  <ol>
  <li>Samsung Galaxy A7 32gb (2017)</li>
  <li>Samsung Galaxy A7 smartphone</li>
  <li>Samsung Galaxy J7 (2017) 32gb Black</li>
  <li>Samsung Galaxy A7 64gb (NEW)</li>
  <li>Samsung Galaxy J7 Prime 16gb</li>
  <li>Samsung Galaxy J7 (16gb, Black)</li>
  <li>Samsung Galaxy J2 Pro (16gb)</li>
  <li>Samsung Galaxy A5 (32gb)</li>
  <li>Samsung Galaxy S7 Edge 32gb Blue Coral</li>
  </ol>
  
  <p><em>Note: In result set only first two and fourth product is similar, not other are</em></p>
  
  <p>Now, i have question:</p>
  
  <p>How to find important keyword from search query, so that keyword are required at least in other product to know similarity? for example in above search query "Samsung Galaxy A7" is important keyword, and that should be required in other product in result. We Human can know, "Samsung Galaxy A7" is important keyword from "Samsung Galaxy A7 (2017) 32gb" to compare with other products, but how can know computer program?</p>
  
  <p>There is any algorithm to compare similar product by important keyword as like sift algorithm in image comparison.</p>
  
  <p>If you have any good method to find similar products, please suggest me</p>