I don't believe you're going to find a magic formula for what you're suggesting. The same thing could be said about last or first names as you are suggesting could happen with SSNs. What if somebody misspells Smith for Smit, for example? But worse yet, what if it is not a misspelling situation and the Smit is actually Smit? The same is true for SSNs, switching the last 2 digits does not mean it was a "misspell", it could just be that 2 different people have the same name and very similar SSNs. You have to draw a line somewhere, I think.
You could use auto-complete fields and then provide options based on records found using the 'LIKE' option in the where clause using the information currently being entered. That might help but I think you'll find it's not worth the effort. On Jul 11, 12:42 pm, Justin Stanczak <rizen...@gmail.com> wrote: > That would help slow the duplication, but if someone fills out a form and > submits fname, lname, ss#, and they typo the ss# I would have a duplicate. I > would like to display to admin users that this record has a related link, or > is similar. Similar to how Google finds duplicates in your contacts and > merges them. > > > > > > > > On Mon, Jul 11, 2011 at 12:25 PM, pepe <p...@betterrpg.com> wrote: > > validate_uniqueness_of might be of help? > > > On Jul 10, 6:21 pm, Justin Stanczak <rizen...@gmail.com> wrote: > > > How are others doing duplicate record detection? I'm not finding very > > many > > > solutions, or methods online. I found one called SimString, but not much > > > else. I was wondering how others are detecting duplicates. Similar to > > > suggested items, I would like to show records that may match or have > > similar > > > attributes. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Ruby on Rails: Talk" group. > > To post to this group, send email to rubyonrails-talk@googlegroups.com. > > To unsubscribe from this group, send email to > > rubyonrails-talk+unsubscr...@googlegroups.com. > > For more options, visit this group at > >http://groups.google.com/group/rubyonrails-talk?hl=en. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.