Closed

Duplicate Detector for SQL Server

In this project I need a duplicate detector developed for SQL Server 2005 as a stored procedure, VB Script, or VB.NET application. The detector should be based on the Jaro-Winkler algorithm, and should be capable determining all groups of duplicates within a data set of up to 500,000 records in under 2 hours (performance is extremely important.<br><br>

The Jaro Winkler algorithm has been implemented for SQL Server 2000, and can be found here:<br><br>

http://www.sqlservercentral.com/articles/SQL+Puzzles/sql2000dbatoolkitpart3/2363/

<br>

<br>

The procedure, script, or application should take as input a particular field in a database table, and return 'groups of duplicates' thus that all fields of the record are returned, for example:<br><br>

Group 1:<br>

R1Field 1 R1Field 2 R1Field 3 R1Field 4 R1Field 5

R2Field 1 R2Field 2 R2Field 3 R2Field 4 R2Field 5

R3Field 1 R3Field 2 R3Field 3 R3Field 4 R3Field 5

<br>

Group 2:<br>

R1Field 1 R1Field 2 R1Field 3 R1Field 4 R1Field 5

R2Field 1 R2Field 2 R2Field 3 R2Field 4 R2Field 5

R3Field 1 R3Field 2 R3Field 3 R3Field 4 R3Field 5

<br>

Skills: .NET, Engineering, MySQL, PHP, Project Management, Software Architecture, Software Testing, SQL, Visual Basic

See more: visual basic algorithm example, visual basic algorithm, vb.net articles, vb net algorithm, vb articles, vb algorithm, example for algorithm, algorithm vb.net, algorithm in visual basic, sql server or, SQL Server, sql server c, sql server c# 2008, sql duplicates, net sql server, net c# sql server, detector, c sql server, duplicate table, net sql script

About the Employer:
( 104 reviews ) SCOTTSDALE, United States

Project ID: #3017966

7 freelancers are bidding on average $85 for this job

maeenul

See private message.

$85 USD in 14 days
(159 Reviews)
5.8
seventhsensesl

See private message.

$85 USD in 14 days
(74 Reviews)
5.0
adeeylx

See private message.

$85 USD in 14 days
(12 Reviews)
4.7
notvalidalv

See private message.

$85 USD in 14 days
(43 Reviews)
4.6
farooqgill

See private message.

$85 USD in 14 days
(15 Reviews)
4.6
jpandyavw

See private message.

$85 USD in 14 days
(2 Reviews)
1.9
racexpertvw

See private message.

$85 USD in 14 days
(0 Reviews)
0.0