<div>
Thanks for the great answers guys. I solved with the folowing (rather clumsy yet effective) code :<br />
<br />
foreach ($total_names as $r) {<br />
foreach ($total_names as $s) {<br />
$lev = levenshtein($r, $s);<br />
if (($lev&lt;2) &amp;&amp;&nbsp;($lev!=0)) {<br />
echo &quot;$r (Input) &lt;br&gt;$s (Word) $lev (Score)&lt;br&gt;&lt;br&gt;\n&quot;;<br />
}<br />
}<br />
<br />
n.b set_time_limit(0); doesnt always work, use metabase explorer to set CGI_TIMEOUT :)
</div>


<div>
<div class="content wysiwyg-content">
I am trying to merge two tables of similar data, but am having the problem that the indexes are text, and dont match in both tables. For example &quot;This Weeks Advertisements&quot; might be &quot;This weeks Advertisement&quot; in the other. <br />
<br />
So far I have put all the values from both tables into an array and am comparing them by eye but its taking a long time. <br />
<br />
My question is, is there an easy way to search through an array for similar values and group them based on some kind of score that indicates how similar they are?
</div>
</div>


I am trying to merge two tables of similar data, but am having the problem that the indexes are text, and dont match in both tables. For example "This Weeks Advertisements" might be "This weeks Advertisement" in the other. 

So far I have put all the values from both tables into an array and am comparing them by eye but its taking a long time. 

My question is, is there an easy way to search through an array for similar values and group them based on some kind of score that indicates how similar they are?

Thanks for the great answers guys. I solved with the folowing (rather clumsy yet effective) code :

foreach ($total_names as $r) {
foreach ($total_names as $s) {
$lev = levenshtein($r, $s);
if (($lev&amp;lt;2) &amp;amp;&amp;amp; ($lev!=0)) {
echo &amp;quot;$r (Input) &amp;lt;br&amp;gt;$s (Word) $lev (Score)&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;\n&amp;quot;;
}
}

n.b set_time_limit(0); doesnt always work, use metabase explorer to set CGI_TIMEOUT :)

php array want to loop through for similar values

I am trying to merge two tables of similar data, but am having the problem that the indexes are text, and dont match in both tables. For example &amp;quot;This Weeks Advertisements&amp;quot; might be &amp;quot;This weeks Advertisement&amp;quot; in the other. 

So far I have put all the values from both tables into an array and am comparing them by eye but its taking a long time. 

My question is, is there an easy way to search through an array for similar values and group them based on some kind of score that indicates how similar they are?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.