title: Finding similar number patterns in table
body: <p>Ok, let's suppose we have <code>members</code> table. There is a field called, let's say, <code>about_member</code>. There will be a string like this <code>1-1-2-1-2</code> for everybody. Let's suppose member_1 has this string <code>1-1-2-2-1</code> and he searches who has the similar string or as much similar as possible. For example if member_2 has string <code>1-1-2-2-1</code> it will be 100% match, but if member_3 has string like this <code>2-1-1-2-1</code> it will be 60% match. And it has to be ordered by match percent. What is the most optimal way to do it with MYSQL and PHP? It's really hard to explain what I mean, but maybe you got it, if not, ask me. Thanks.<p></p>
  
  <p><strong>Edit: Please give me ideas without Levenshtein method. That answer will get bounty. Thanks. (bounty will be announced when I will be able to do that)</strong></p>