History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"submitter"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 352 | 2025-07-19 10:05:51 | submitter | 2 | 121436 | 6 | 3.703 | 32794.0 |
| 351 | 2025-07-19 06:35:06 | submitter | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 350 | 2025-06-24 06:01:02 | submitter | 1 | 81242 | 3 | 5.656 | 14363.9 |
| 349 | 2025-06-22 08:35:17 | submitter | 1 | 81242 | 3 | 9.376 | 8664.9 |
| 348 | 2025-06-08 15:07:54 | submitter | 1 | 81242 | 3 | 8.516 | 9539.9 |
| 347 | 2025-05-30 07:50:32 | submitter | 3 | 148641 | 53 | 23.173 | 6414.4 |
| 346 | 2025-05-27 16:21:24 | submitter | 3 | 148641 | 53 | 47.766 | 3111.9 |
| 345 | 2025-05-26 12:56:54 | submitter | 1 | 81242 | 3 | 9.813 | 8279.0 |
| 344 | 2025-05-24 18:31:12 | submitter | 1 | 81242 | 3 | 6.360 | 12773.9 |
| 343 | 2025-05-23 16:06:09 | submitter | 3 | 148641 | 53 | 27.983 | 5311.8 |
| 342 | 2025-05-23 08:15:21 | submitter | 3 | 148641 | 53 | 32.973 | 4508.0 |
| 341 | 2025-05-23 00:11:56 | submitter | 3 | 148641 | 53 | 12.906 | 11517.2 |
| 340 | 2025-05-19 23:17:46 | submitter | 3 | 148641 | 53 | 36.423 | 4081.0 |
| 339 | 2025-05-16 11:30:21 | submitter | 3 | 148641 | 53 | 29.986 | 4957.0 |
| 338 | 2025-05-16 03:09:24 | submitter | 2 | 121436 | 6 | 21.220 | 5722.7 |
| 337 | 2025-05-15 15:52:47 | submitter | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 336 | 2025-04-30 22:16:27 | submitter | 1 | 81242 | 3 | 6.706 | 12114.8 |
| 335 | 2025-04-28 14:47:24 | submitter | 1 | 81242 | 3 | 9.206 | 8824.9 |
| 334 | 2025-04-26 12:02:04 | submitter | 1 | 81242 | 3 | 6.753 | 12030.5 |
| 333 | 2025-04-11 11:27:39 | submitter | 1 | 81242 | 3 | 5.313 | 15291.2 |
| 332 | 2025-03-28 10:07:57 | submitter | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 331 | 2025-03-23 18:05:31 | submitter | 3 | 148641 | 53 | 26.520 | 5604.9 |
| 330 | 2025-03-23 13:38:41 | submitter | 2 | 121436 | 6 | 15.843 | 7665.0 |
| 329 | 2025-03-23 11:50:05 | submitter | 3 | 148641 | 53 | 19.220 | 7733.7 |
| 328 | 2025-03-22 13:22:46 | submitter | 1 | 81242 | 3 | 6.563 | 12378.8 |
| 327 | 2025-03-15 15:19:16 | submitter | 3 | 148641 | 53 | 41.953 | 3543.0 |
| 326 | 2025-03-14 08:15:53 | submitter | 2 | 121436 | 6 | 26.516 | 4579.7 |
| 325 | 2025-03-11 11:24:54 | submitter | 1 | 81242 | 3 | 13.296 | 6110.3 |
| 324 | 2025-03-10 13:09:39 | submitter | 1 | 81242 | 3 | 9.280 | 8754.5 |
| 323 | 2025-03-10 04:36:31 | submitter | 3 | 148641 | 53 | 41.876 | 3549.6 |
| 322 | 2025-03-08 19:09:41 | submitter | 3 | 148641 | 53 | 31.203 | 4763.7 |
| 321 | 2025-03-08 19:09:40 | submitter | 2 | 121436 | 6 | 24.280 | 5001.5 |
| 320 | 2025-03-08 19:07:33 | submitter | 1 | 81242 | 3 | 9.690 | 8384.1 |
| 319 | 2025-03-08 19:06:45 | submitter | 1 | 81242 | 3 | 8.220 | 9883.5 |
| 318 | 2025-03-08 14:48:15 | submitter | 1 | 81242 | 3 | 7.500 | 10832.3 |
| 317 | 2025-02-07 03:42:08 | submitter | 1 | 81242 | 3 | 6.860 | 11842.9 |
| 316 | 2025-02-06 15:10:44 | submitter | 3 | 148641 | 53 | 46.973 | 3164.4 |
| 315 | 2025-02-06 15:10:39 | submitter | 2 | 121436 | 6 | 20.890 | 5813.1 |
| 314 | 2025-02-05 15:03:04 | submitter | 1 | 81242 | 3 | 6.076 | 13371.0 |
| 313 | 2025-02-01 09:50:01 | submitter | 1 | 81242 | 3 | 1.450 | 56029.0 |
| 312 | 2025-01-31 22:00:22 | submitter | 3 | 148641 | 53 | 43.020 | 3455.2 |
| 311 | 2025-01-30 18:12:59 | submitter | 3 | 148641 | 53 | 49.363 | 3011.2 |
| 310 | 2025-01-30 18:12:54 | submitter | 3 | 148641 | 53 | 30.406 | 4888.5 |
| 309 | 2025-01-30 18:13:03 | submitter | 2 | 121436 | 6 | 15.250 | 7963.0 |
| 308 | 2025-01-30 18:11:18 | submitter | 1 | 81242 | 3 | 3.420 | 23755.0 |
| 307 | 2025-01-26 14:11:28 | submitter | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 306 | 2025-01-04 13:21:27 | submitter | 3 | 148641 | 53 | 30.970 | 4799.5 |
| 305 | 2025-01-04 13:21:29 | submitter | 2 | 121436 | 6 | 16.156 | 7516.5 |
| 304 | 2025-01-04 13:19:59 | submitter | 1 | 81242 | 3 | 9.906 | 8201.3 |
| 303 | 2025-01-01 20:45:09 | submitter | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 302 | 2024-12-28 17:16:05 | submitter | 3 | 148641 | 53 | 35.736 | 4159.4 |
| 301 | 2024-12-26 06:53:08 | submitter | 1 | 81242 | 3 | 2.766 | 29371.7 |
| 300 | 2024-12-23 05:33:52 | submitter | 3 | 148641 | 53 | 35.863 | 4144.7 |
| 299 | 2024-12-21 21:38:54 | submitter | 3 | 148641 | 53 | 43.583 | 3410.5 |
| 298 | 2024-12-20 00:22:43 | submitter | 3 | 148641 | 53 | 39.033 | 3808.1 |
| 297 | 2024-12-20 00:22:49 | submitter | 2 | 121436 | 6 | 21.500 | 5648.2 |
| 296 | 2024-12-20 00:22:49 | submitter | 3 | 148641 | 53 | 18.516 | 8027.7 |
| 295 | 2024-12-19 23:27:12 | submitter | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 294 | 2024-11-24 21:17:56 | submitter | 3 | 148641 | 53 | 35.020 | 4244.5 |
| 293 | 2024-11-24 21:17:35 | submitter | 1 | 81242 | 3 | 3.123 | 26014.1 |
| 292 | 2024-11-18 17:43:27 | submitter | 3 | 148641 | 53 | 41.750 | 3560.3 |
| 291 | 2024-11-18 17:42:54 | submitter | 3 | 148641 | 53 | 35.346 | 4205.3 |
| 290 | 2024-11-18 17:42:58 | submitter | 2 | 121436 | 6 | 25.393 | 4782.3 |
| 289 | 2024-11-18 16:58:33 | submitter | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 288 | 2024-11-16 03:51:48 | submitter | 3 | 148641 | 53 | 38.110 | 3900.3 |
| 287 | 2024-11-11 18:27:01 | submitter | 3 | 148641 | 53 | 24.393 | 6093.6 |
| 286 | 2024-11-11 09:30:41 | submitter | 1 | 81242 | 3 | 3.156 | 25742.1 |
| 285 | 2024-10-29 11:52:16 | submitter | 1 | 81242 | 3 | 6.486 | 12525.7 |
| 284 | 2024-10-23 02:27:19 | submitter | 2 | 121436 | 6 | 27.030 | 4492.6 |
| 283 | 2024-10-20 22:26:15 | submitter | 1 | 81242 | 3 | 4.923 | 16502.5 |
| 282 | 2024-10-20 14:49:50 | submitter | 1 | 81242 | 3 | 4.003 | 20295.3 |
| 281 | 2024-10-03 08:02:32 | submitter | 2 | 121436 | 6 | 28.203 | 4305.8 |
| 280 | 2024-09-26 08:59:10 | submitter | 2 | 121436 | 6 | 34.156 | 3555.3 |
| 279 | 2024-09-25 06:55:05 | submitter | 3 | 148641 | 53 | 65.283 | 2276.9 |
| 278 | 2024-09-25 06:55:00 | submitter | 3 | 148641 | 53 | 52.160 | 2849.7 |
| 277 | 2024-09-25 06:55:09 | submitter | 2 | 121436 | 6 | 42.016 | 2890.2 |
| 276 | 2024-09-25 06:54:36 | submitter | 1 | 81242 | 3 | 8.860 | 9169.5 |
| 275 | 2024-09-24 01:10:44 | submitter | 1 | 81242 | 3 | 9.143 | 8885.7 |
| 274 | 2024-08-25 22:41:48 | submitter | 1 | 81242 | 3 | 9.690 | 8384.1 |
| 273 | 2024-08-16 14:48:08 | submitter | 1 | 81242 | 3 | 7.563 | 10742.0 |
| 272 | 2024-08-11 12:28:56 | submitter | 1 | 81242 | 3 | 2.796 | 29056.5 |
| 271 | 2024-07-31 07:20:18 | submitter | 1 | 81242 | 3 | 5.876 | 13826.1 |
| 270 | 2024-07-30 01:33:05 | submitter | 1 | 81242 | 3 | 6.093 | 13333.7 |
| 269 | 2024-07-25 20:41:40 | submitter | 1 | 81242 | 3 | 2.546 | 31909.7 |
| 268 | 2024-07-17 05:15:58 | submitter | 2 | 121436 | 6 | 13.690 | 8870.4 |
| 267 | 2024-07-14 15:15:53 | submitter | 3 | 148641 | 53 | 40.203 | 3697.3 |
| 266 | 2024-07-14 04:23:05 | submitter | 3 | 148641 | 53 | 22.596 | 6578.2 |
| 265 | 2024-07-14 04:23:07 | submitter | 2 | 121436 | 6 | 13.173 | 9218.6 |
| 264 | 2024-07-14 04:18:24 | submitter | 1 | 81242 | 3 | 5.533 | 14683.2 |
| 263 | 2024-07-11 23:49:09 | submitter | 1 | 81242 | 3 | 5.360 | 15157.1 |
| 262 | 2024-07-10 16:52:57 | submitter | 4 | 165329 | 398 | 68.643 | 2408.5 |
| 261 | 2024-07-10 02:10:23 | submitter | 4 | 165329 | 398 | 67.240 | 2458.8 |
| 260 | 2024-07-09 00:23:21 | submitter | 4 | 165329 | 398 | 41.970 | 3939.2 |
| 259 | 2024-07-06 13:56:11 | submitter | 1 | 81242 | 3 | 3.296 | 24648.7 |
| 258 | 2024-07-06 13:49:21 | submitter | 4 | 165329 | 398 | 28.660 | 5768.6 |
| 257 | 2024-07-06 13:48:52 | submitter | 3 | 148641 | 53 | 23.346 | 6366.9 |
| 256 | 2024-07-06 13:47:42 | submitter | 4 | 165329 | 398 | 47.580 | 3474.8 |
| 255 | 2024-07-06 13:47:49 | submitter | 3 | 148641 | 53 | 18.143 | 8192.7 |
| 254 | 2024-07-06 13:47:25 | submitter | 2 | 121436 | 6 | 13.250 | 9165.0 |
| 253 | 2024-07-06 13:42:45 | submitter | 1 | 81242 | 3 | 7.500 | 10832.3 |