3 ms·
My solution will catch a lot of trivial errors like simple misspellings. You could have a relational tables with dozens of columns, each with its own dictionary
by didgetmaster 1y ago
My solution will catch a lot of trivial errors like simple misspellings. You could have a relational tables with dozens of columns, each with its own dictionary; but that won't catch wrong combinations between columns.
For example, there is a Paris, Texas; but I doubt there is a London, Texas. Dictionaries of state names and city names would not catch someone's error of matching the wrong city with a state when entering an address.
Is this the kind of error you encounter often?
- axegon_ 1y agoOh don't even get me started on cities, states, towns and addresses :D https://www.google.com/maps/place/95450+Us,+France/@49.105313,1.9355878,5830m/data=!3m2!1e3!4b1!4m6!3m5!1s0x47e6f21fd4aa2993:0x40b82c3688b2ca0!8m2!3d49.105077!4d1.959952!16zL20vMGJfeTh3?entry=ttu&g_ep=EgoyMDI1MDYxNi4wIKXMDSoASAFQAw%3D%3D https://www.google.com/maps/place/95450+Us,+France/@49.10531...