History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subcounty"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 275 | 2025-11-11 13:36:44 | subcounty | 3 | 148641 | 16 | 6.403 | 23214.3 |
| 274 | 2025-11-11 11:16:25 | subcounty | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 273 | 2025-11-10 13:51:42 | subcounty | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 272 | 2025-11-09 20:00:02 | subcounty | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 271 | 2025-11-07 12:18:31 | subcounty | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 270 | 2025-11-07 03:49:14 | subcounty | 2 | 121436 | 1 | 3.360 | 36141.7 |
| 269 | 2025-11-06 02:36:35 | subcounty | 3 | 148641 | 16 | 7.126 | 20859.0 |
| 268 | 2025-11-04 17:37:45 | subcounty | 4 | 165329 | 130 | 20.686 | 7992.3 |
| 267 | 2025-11-03 21:14:20 | subcounty | 4 | 165329 | 130 | 17.516 | 9438.7 |
| 266 | 2025-11-02 04:57:51 | subcounty | 3 | 148641 | 16 | 7.000 | 21234.4 |
| 265 | 2025-11-01 10:34:24 | subcounty | 1 | 81242 | 1 | 1.486 | 54671.6 |
| 264 | 2025-10-02 10:34:12 | subcounty | 2 | 121436 | 1 | 3.250 | 37364.9 |
| 263 | 2025-10-02 01:55:57 | subcounty | 1 | 81242 | 1 | 1.360 | 59736.8 |
| 262 | 2025-09-27 21:56:56 | subcounty | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 261 | 2025-09-08 22:07:16 | subcounty | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 260 | 2025-08-29 11:29:04 | subcounty | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 259 | 2025-08-27 21:51:19 | subcounty | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 258 | 2025-08-09 23:05:51 | subcounty | 1 | 81242 | 1 | 4.203 | 19329.5 |
| 257 | 2025-08-01 15:09:39 | subcounty | 1 | 81242 | 1 | 7.676 | 10583.9 |
| 256 | 2025-07-25 09:56:58 | subcounty | 1 | 81242 | 1 | 7.390 | 10993.5 |
| 255 | 2025-07-24 21:27:00 | subcounty | 1 | 81242 | 1 | 6.470 | 12556.7 |
| 254 | 2025-07-24 17:57:05 | subcounty | 1 | 81242 | 1 | 4.516 | 17989.8 |
| 253 | 2025-07-22 01:39:00 | subcounty | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 252 | 2025-07-16 05:24:44 | subcounty | 1 | 81242 | 1 | 5.233 | 15524.9 |
| 251 | 2025-06-04 13:15:51 | subcounty | 1 | 81242 | 1 | 6.953 | 11684.5 |
| 250 | 2025-05-24 00:35:47 | subcounty | 2 | 121436 | 1 | 11.003 | 11036.6 |
| 249 | 2025-05-03 09:40:19 | subcounty | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 248 | 2025-04-30 06:53:26 | subcounty | 1 | 81242 | 1 | 5.656 | 14363.9 |
| 247 | 2025-04-29 21:18:43 | subcounty | 1 | 81242 | 1 | 3.423 | 23734.2 |
| 246 | 2025-03-31 12:09:38 | subcounty | 1 | 81242 | 1 | 6.173 | 13160.9 |
| 245 | 2025-03-26 16:27:46 | subcounty | 1 | 81242 | 1 | 9.436 | 8609.8 |
| 244 | 2025-03-25 06:18:13 | subcounty | 3 | 148641 | 16 | 35.890 | 4141.6 |
| 243 | 2025-03-22 20:42:28 | subcounty | 4 | 165329 | 130 | 51.816 | 3190.7 |
| 242 | 2025-03-21 03:48:54 | subcounty | 4 | 165329 | 130 | 76.140 | 2171.4 |
| 241 | 2025-03-16 15:36:41 | subcounty | 4 | 165329 | 130 | 63.440 | 2606.1 |
| 240 | 2025-03-11 23:35:00 | subcounty | 3 | 148641 | 16 | 27.580 | 5389.4 |
| 239 | 2025-03-10 21:27:52 | subcounty | 4 | 165329 | 130 | 76.813 | 2152.4 |
| 238 | 2025-03-10 21:27:51 | subcounty | 3 | 148641 | 16 | 47.063 | 3158.3 |
| 237 | 2025-03-10 21:27:46 | subcounty | 2 | 121436 | 1 | 15.576 | 7796.4 |
| 236 | 2025-03-10 20:34:09 | subcounty | 1 | 81242 | 1 | 1.516 | 53589.7 |
| 235 | 2025-03-08 02:03:57 | subcounty | 1 | 81242 | 1 | 9.063 | 8964.1 |
| 234 | 2025-03-07 16:44:09 | subcounty | 3 | 148641 | 16 | 28.203 | 5270.4 |
| 233 | 2025-03-03 04:06:28 | subcounty | 1 | 81242 | 1 | 6.470 | 12556.7 |
| 232 | 2025-02-13 20:09:36 | subcounty | 3 | 148641 | 16 | 32.720 | 4542.8 |
| 231 | 2025-02-13 20:09:38 | subcounty | 3 | 148641 | 16 | 29.483 | 5041.6 |
| 230 | 2025-02-13 01:19:28 | subcounty | 3 | 148641 | 16 | 37.016 | 4015.6 |
| 229 | 2025-02-13 01:19:27 | subcounty | 3 | 148641 | 16 | 33.533 | 4432.7 |
| 228 | 2025-02-13 01:19:25 | subcounty | 2 | 121436 | 1 | 24.626 | 4931.2 |
| 227 | 2025-02-12 13:28:14 | subcounty | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 226 | 2025-01-31 18:31:24 | subcounty | 1 | 81242 | 1 | 7.283 | 11155.0 |
| 225 | 2025-01-30 21:40:26 | subcounty | 3 | 148641 | 16 | 33.156 | 4483.1 |
| 224 | 2025-01-29 08:23:52 | subcounty | 3 | 148641 | 16 | 36.030 | 4125.5 |
| 223 | 2025-01-21 14:05:52 | subcounty | 1 | 81242 | 1 | 10.720 | 7578.5 |
| 222 | 2025-01-20 22:54:33 | subcounty | 3 | 148641 | 16 | 34.093 | 4359.9 |
| 221 | 2025-01-13 17:21:42 | subcounty | 3 | 148641 | 16 | 34.733 | 4279.5 |
| 220 | 2025-01-12 02:11:27 | subcounty | 3 | 148641 | 16 | 28.033 | 5302.4 |
| 219 | 2025-01-12 02:11:32 | subcounty | 2 | 121436 | 1 | 17.563 | 6914.3 |
| 218 | 2025-01-12 02:10:31 | subcounty | 1 | 81242 | 1 | 7.513 | 10813.5 |
| 217 | 2025-01-10 14:30:24 | subcounty | 4 | 165329 | 130 | 67.716 | 2441.5 |
| 216 | 2025-01-01 12:16:41 | subcounty | 4 | 165329 | 130 | 79.503 | 2079.5 |
| 215 | 2024-12-27 02:41:21 | subcounty | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 214 | 2024-12-14 06:53:55 | subcounty | 1 | 81242 | 1 | 6.546 | 12410.9 |
| 213 | 2024-12-14 03:44:42 | subcounty | 4 | 165329 | 130 | 32.326 | 5114.4 |
| 212 | 2024-12-13 21:11:12 | subcounty | 4 | 165329 | 130 | 61.453 | 2690.3 |
| 211 | 2024-12-11 11:58:29 | subcounty | 4 | 165329 | 130 | 73.176 | 2259.3 |
| 210 | 2024-11-29 19:54:44 | subcounty | 4 | 165329 | 130 | 63.080 | 2620.9 |
| 209 | 2024-11-26 18:26:20 | subcounty | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 208 | 2024-11-16 00:22:09 | subcounty | 1 | 81242 | 1 | 7.420 | 10949.1 |
| 207 | 2024-11-09 20:00:30 | subcounty | 4 | 165329 | 130 | 61.490 | 2688.7 |
| 206 | 2024-11-09 14:03:24 | subcounty | 4 | 165329 | 130 | 75.163 | 2199.6 |
| 205 | 2024-11-03 20:09:26 | subcounty | 3 | 148641 | 16 | 23.156 | 6419.1 |
| 204 | 2024-10-30 06:15:43 | subcounty | 3 | 148641 | 16 | 48.910 | 3039.1 |
| 203 | 2024-10-30 06:15:44 | subcounty | 3 | 148641 | 16 | 36.063 | 4121.7 |
| 202 | 2024-10-09 08:30:15 | subcounty | 2 | 121436 | 1 | 13.936 | 8713.8 |
| 201 | 2024-10-09 08:28:53 | subcounty | 1 | 81242 | 1 | 7.203 | 11278.9 |
| 200 | 2024-10-09 06:56:01 | subcounty | 1 | 81242 | 1 | 3.873 | 20976.5 |
| 199 | 2024-10-07 16:13:10 | subcounty | 3 | 148641 | 16 | 57.676 | 2577.2 |
| 198 | 2024-09-29 10:06:43 | subcounty | 3 | 148641 | 16 | 75.833 | 1960.1 |
| 197 | 2024-09-29 10:06:44 | subcounty | 3 | 148641 | 16 | 45.300 | 3281.3 |
| 196 | 2024-09-27 19:15:31 | subcounty | 3 | 148641 | 16 | 52.626 | 2824.5 |
| 195 | 2024-09-25 21:41:57 | subcounty | 4 | 165329 | 130 | 117.976 | 1401.4 |
| 194 | 2024-09-25 21:42:01 | subcounty | 3 | 148641 | 16 | 77.353 | 1921.6 |
| 193 | 2024-09-25 21:42:05 | subcounty | 2 | 121436 | 1 | 13.766 | 8821.4 |
| 192 | 2024-09-25 21:35:38 | subcounty | 1 | 81242 | 1 | 4.703 | 17274.5 |
| 191 | 2024-09-20 06:12:58 | subcounty | 2 | 121436 | 1 | 39.320 | 3088.4 |
| 190 | 2024-09-20 06:12:53 | subcounty | 3 | 148641 | 16 | 27.616 | 5382.4 |
| 189 | 2024-09-20 06:12:32 | subcounty | 1 | 81242 | 1 | 7.153 | 11357.8 |
| 188 | 2024-08-27 20:46:32 | subcounty | 3 | 148641 | 16 | 76.840 | 1934.4 |
| 187 | 2024-08-27 14:01:57 | subcounty | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 186 | 2024-08-26 01:22:38 | subcounty | 2 | 121436 | 1 | 19.720 | 6158.0 |
| 185 | 2024-08-26 01:20:54 | subcounty | 3 | 148641 | 16 | 28.190 | 5272.8 |
| 184 | 2024-08-26 01:19:59 | subcounty | 1 | 81242 | 1 | 4.766 | 17046.2 |
| 183 | 2024-08-16 11:05:03 | subcounty | 3 | 148641 | 16 | 47.126 | 3154.1 |
| 182 | 2024-08-15 15:42:00 | subcounty | 1 | 81242 | 1 | 10.000 | 8124.2 |
| 181 | 2024-08-11 04:31:30 | subcounty | 3 | 148641 | 16 | 40.833 | 3640.2 |
| 180 | 2024-08-02 18:56:55 | subcounty | 1 | 81242 | 1 | 7.093 | 11453.8 |
| 179 | 2024-07-28 10:35:28 | subcounty | 3 | 148641 | 16 | 33.206 | 4476.3 |
| 178 | 2024-07-26 22:10:42 | subcounty | 3 | 148641 | 16 | 25.516 | 5825.4 |
| 177 | 2024-07-26 14:09:03 | subcounty | 3 | 148641 | 16 | 32.300 | 4601.9 |
| 176 | 2024-07-25 22:22:13 | subcounty | 3 | 148641 | 16 | 16.483 | 9017.8 |