Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sxbo672158
Starting Member
4 Posts |
 Posted - 2011-07-19 : 22:25:42
|
| Hi,allIs there any way that I can identify similar records in a huge table instead of manually check the records?For example, if I have similar emails in the table like:abcd123@gmail.comabcd1234@gmail.comabcd12345@gmail.comAnd I want to find them out, and output into a new table.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-20 : 06:35:21
|
| seems like what you're looking for is some kind of fuzzy grouping alogorithm------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sxbo672158
Starting Member
4 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-21 : 02:12:45
|
| you need to clearly specify upto what level you want to consider for matching.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
How to identify similar records