title: Find Similar Rows in Database
body: <p>I try to design my app to find database entries which are similar.</p>
  
  <p>Let's for example take the table <em>car</em> (Everything in one table to keep the example simple):</p>
  
  <pre><code>CarID  |  Car Name  | Brand | Year | Top Speed | Performance | Displacement | Price
  1         Z3          BMW     1990    250          5.4           123           23456
  2         3er         BMW     2000    256          5.4           123           23000
  3         Mustang     Ford    2000    190          9.8           120           23000
  </code></pre>
  
  <p>Now i want to do Queries like that:</p>
  
  <p>"Search for Cars similar to Z3 (all brands)" (ignore "Car Name")</p>
  
  <p>Similar in this context means that the row where the most columns are exactly the same is the most similar. </p>
  
  <p>In this example it would be "3er BMW" since 2 columns(Performance and Displacement are the same)</p>
  
  <p>Can you give me hints how to design database queries/application like that. The application gonna be really big with a lot of entries.</p>
  
  <p>Also I would really appreciate useful links or books. (No problem for me to investigate further if i know where to search or what to read)</p>