<div>
Use can use Oracle To Solve this Issue.. There is a Function in Oracle called Soundex() which Finds Names Which Sound Similar.. So It Would be a good option for you to find duplicates in names..
</div>


Use can use Oracle To Solve this Issue.. There is a Function in Oracle called Soundex() which Finds Names Which Sound Similar.. So It Would be a good option for you to find duplicates in names..

<div>
I think SOUNDEX function is also available in SQL Server.. So try searching for more info about it..
</div>


I think SOUNDEX function is also available in SQL Server.. So try searching for more info about it..

<div>
You can try these links...<br />
<a href="http://anastasiosyal.com/archive/2009/01/11/18.aspx" rel="ugc">http://anastasiosyal.com/archive/2009/01/11/18.aspx</a><br />
<a href="http://msdn.microsoft.com/en-us/library/aa259235%28v=sql.80%29.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/aa259235%28v=sql.80%29.aspx</a><br />
<a href="http://www.tek-tips.com/faqs.cfm?fid=4110" rel="ugc">http://www.tek-tips.com/faqs.cfm?fid=4110</a><br />

</div>


You can try these links...
http://anastasiosyal.com/archive/2009/01/11/18.aspx [http://anastasiosyal.com/archive/2009/01/11/18.aspx]
http://msdn.microsoft.com/en-us/library/aa259235%28v=sql.80%29.aspx [http://msdn.microsoft.com/en-us/library/aa259235%28v=sql.80%29.aspx]
http://www.tek-tips.com/faqs.cfm?fid=4110 [http://www.tek-tips.com/faqs.cfm?fid=4110]


<div>
<a href="http://www.techonthenet.com/oracle/functions/soundex.php" rel="ugc">http://www.techonthenet.com/oracle/functions/soundex.php</a><br />
<a href="http://databases.about.com/od/development/l/aasoundex.htm" rel="ugc">http://databases.about.com/od/development/l/aasoundex.htm</a><br />
<a href="http://www.orafaq.com/wiki/SOUNDEX" rel="ugc">http://www.orafaq.com/wiki/SOUNDEX</a><br />
<br />
...Links in Oracle
</div>


http://www.techonthenet.com/oracle/functions/soundex.php [http://www.techonthenet.com/oracle/functions/soundex.php]
http://databases.about.com/od/development/l/aasoundex.htm [http://databases.about.com/od/development/l/aasoundex.htm]
http://www.orafaq.com/wiki/SOUNDEX [http://www.orafaq.com/wiki/SOUNDEX]

...Links in Oracle

<div>
<div class="content wysiwyg-content">
Hi There<br />
<br />
I have an array of of peoples names<br />
<br />
Example<br />
string[] names = new string[] {&quot;Jim Bean&quot;,&quot;Jack Daniels&quot; ,&quot;Jim Bean&quot; ,&quot;Tim Bean&quot;}<br />
<br />
How do I loop through the array to find duplicates.<br />
I also need to know how I can find similar names in the array to find mispelt names as in the example.<br />
pseudo-code will be good enough<br />
<br />
<br />
<br />
Thanks<br />
Stanton
</div>
</div>


Hi There

I have an array of of peoples names

Example
string[] names = new string[] {"Jim Bean","Jack Daniels" ,"Jim Bean" ,"Tim Bean"}

How do I loop through the array to find duplicates.
I also need to know how I can find similar names in the array to find mispelt names as in the example.
pseudo-code will be good enough



Thanks
Stanton

Finding duplicate records and potential mispellings in an array

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).