History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"footfall"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 421 | 2025-09-19 15:58:41 | footfall | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 420 | 2025-09-07 21:44:07 | footfall | 2 | 121059 | 11 | 3.236 | 37410.1 |
| 419 | 2025-08-31 22:11:09 | footfall | 2 | 121059 | 11 | 3.470 | 34887.3 |
| 418 | 2025-08-07 12:58:32 | footfall | 3 | 146162 | 51 | 15.533 | 9409.8 |
| 417 | 2025-08-06 14:33:28 | footfall | 3 | 146162 | 51 | 16.046 | 9108.9 |
| 416 | 2025-08-02 10:28:14 | footfall | 3 | 146162 | 51 | 15.126 | 9663.0 |
| 415 | 2025-08-01 10:41:19 | footfall | 3 | 146162 | 51 | 17.970 | 8133.7 |
| 414 | 2025-07-30 23:15:51 | footfall | 1 | 82945 | 4 | 8.190 | 10127.6 |
| 413 | 2025-07-29 12:40:25 | footfall | 3 | 146162 | 51 | 18.703 | 7814.9 |
| 412 | 2025-07-29 01:37:34 | footfall | 3 | 146162 | 51 | 18.003 | 8118.8 |
| 411 | 2025-07-24 00:35:34 | footfall | 1 | 82945 | 4 | 8.343 | 9941.9 |
| 410 | 2025-07-23 14:29:32 | footfall | 1 | 82945 | 4 | 3.470 | 23903.5 |
| 409 | 2025-07-20 23:42:44 | footfall | 3 | 146162 | 51 | 7.016 | 20832.7 |
| 408 | 2025-06-27 23:20:39 | footfall | 1 | 82945 | 4 | 6.873 | 12068.2 |
| 407 | 2025-06-23 22:08:57 | footfall | 1 | 82945 | 4 | 7.453 | 11129.1 |
| 406 | 2025-06-22 02:47:31 | footfall | 4 | 161609 | 316 | 69.750 | 2317.0 |
| 405 | 2025-06-20 14:08:17 | footfall | 4 | 161609 | 316 | 36.550 | 4421.6 |
| 404 | 2025-06-19 04:38:47 | footfall | 4 | 161609 | 316 | 13.983 | 11557.5 |
| 403 | 2025-06-18 16:25:54 | footfall | 4 | 161609 | 316 | 53.380 | 3027.5 |
| 402 | 2025-06-16 15:50:10 | footfall | 4 | 161609 | 316 | 50.500 | 3200.2 |
| 401 | 2025-05-28 22:24:03 | footfall | 1 | 82945 | 4 | 3.326 | 24938.4 |
| 400 | 2025-05-20 04:14:51 | footfall | 4 | 161609 | 316 | 40.906 | 3950.7 |
| 399 | 2025-05-18 15:29:54 | footfall | 4 | 161609 | 316 | 64.660 | 2499.4 |
| 398 | 2025-05-16 09:39:16 | footfall | 4 | 161609 | 316 | 56.003 | 2885.7 |
| 397 | 2025-05-14 17:01:20 | footfall | 4 | 161609 | 316 | 51.033 | 3166.8 |
| 396 | 2025-05-13 04:49:35 | footfall | 4 | 161609 | 316 | 13.656 | 11834.3 |
| 395 | 2025-05-07 01:07:29 | footfall | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 394 | 2025-05-02 03:10:44 | footfall | 1 | 82945 | 4 | 4.750 | 17462.1 |
| 393 | 2025-04-27 22:47:58 | footfall | 1 | 82945 | 4 | 4.513 | 18379.1 |
| 392 | 2025-04-27 05:56:05 | footfall | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 391 | 2025-04-22 22:13:41 | footfall | 1 | 82945 | 4 | 6.753 | 12282.7 |
| 390 | 2025-04-14 01:50:19 | footfall | 1 | 82945 | 4 | 8.503 | 9754.8 |
| 389 | 2025-04-04 02:51:09 | footfall | 2 | 121059 | 11 | 19.063 | 6350.5 |
| 388 | 2025-04-03 21:23:54 | footfall | 3 | 146162 | 51 | 19.393 | 7536.8 |
| 387 | 2025-04-03 08:54:04 | footfall | 2 | 121059 | 11 | 6.893 | 17562.6 |
| 386 | 2025-04-02 16:33:49 | footfall | 3 | 146162 | 51 | 35.360 | 4133.5 |
| 385 | 2025-04-01 18:51:22 | footfall | 3 | 146162 | 51 | 6.343 | 23043.0 |
| 384 | 2025-03-26 12:11:19 | footfall | 3 | 146162 | 51 | 35.063 | 4168.6 |
| 383 | 2025-03-24 22:52:11 | footfall | 1 | 82945 | 4 | 7.173 | 11563.5 |
| 382 | 2025-03-24 01:55:16 | footfall | 4 | 161609 | 316 | 64.893 | 2490.4 |
| 381 | 2025-03-20 17:34:51 | footfall | 4 | 161609 | 316 | 57.520 | 2809.6 |
| 380 | 2025-03-20 05:46:47 | footfall | 4 | 161609 | 316 | 43.900 | 3681.3 |
| 379 | 2025-03-18 04:40:03 | footfall | 1 | 82945 | 4 | 8.000 | 10368.1 |
| 378 | 2025-03-18 04:13:20 | footfall | 4 | 161609 | 316 | 78.130 | 2068.5 |
| 377 | 2025-03-18 04:12:25 | footfall | 3 | 146162 | 51 | 26.393 | 5537.9 |
| 376 | 2025-03-15 15:13:07 | footfall | 3 | 146162 | 51 | 54.926 | 2661.1 |
| 375 | 2025-03-14 00:45:30 | footfall | 1 | 82945 | 4 | 4.200 | 19748.8 |
| 374 | 2025-03-04 17:23:29 | footfall | 1 | 82945 | 4 | 6.486 | 12788.3 |
| 373 | 2025-02-20 22:21:27 | footfall | 3 | 146162 | 51 | 34.656 | 4217.5 |
| 372 | 2025-02-17 19:04:58 | footfall | 1 | 82945 | 4 | 5.940 | 13963.8 |
| 371 | 2025-02-12 05:44:59 | footfall | 3 | 146162 | 51 | 31.923 | 4578.6 |
| 370 | 2025-02-10 20:23:55 | footfall | 3 | 146162 | 51 | 39.063 | 3741.7 |
| 369 | 2025-02-08 17:25:49 | footfall | 4 | 161609 | 316 | 58.423 | 2766.2 |
| 368 | 2025-02-08 14:20:33 | footfall | 1 | 82945 | 4 | 7.813 | 10616.3 |
| 367 | 2025-02-08 14:19:43 | footfall | 4 | 161609 | 316 | 53.750 | 3006.7 |
| 366 | 2025-02-08 14:19:42 | footfall | 2 | 121059 | 11 | 18.466 | 6555.8 |
| 365 | 2025-02-08 14:13:00 | footfall | 3 | 146162 | 51 | 7.190 | 20328.5 |
| 364 | 2025-02-04 12:19:10 | footfall | 1 | 82945 | 4 | 3.110 | 26670.4 |
| 363 | 2025-02-04 12:16:04 | footfall | 2 | 121059 | 11 | 17.766 | 6814.1 |
| 362 | 2025-02-03 21:33:21 | footfall | 3 | 146162 | 51 | 26.486 | 5518.5 |
| 361 | 2025-02-03 21:33:22 | footfall | 2 | 121059 | 11 | 9.513 | 12725.6 |
| 360 | 2025-02-03 21:33:19 | footfall | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 359 | 2025-01-17 14:58:20 | footfall | 3 | 146162 | 51 | 49.346 | 2962.0 |
| 358 | 2025-01-16 13:35:33 | footfall | 3 | 146162 | 51 | 31.316 | 4667.3 |
| 357 | 2025-01-10 10:41:17 | footfall | 3 | 146162 | 51 | 11.186 | 13066.5 |
| 356 | 2025-01-10 10:03:08 | footfall | 3 | 146162 | 51 | 46.126 | 3168.8 |
| 355 | 2025-01-08 02:47:55 | footfall | 3 | 146162 | 51 | 36.736 | 3978.7 |
| 354 | 2025-01-07 03:25:32 | footfall | 3 | 146162 | 51 | 28.720 | 5089.2 |
| 353 | 2024-12-28 11:20:05 | footfall | 1 | 82945 | 4 | 6.380 | 13000.8 |
| 352 | 2024-12-25 15:01:46 | footfall | 1 | 82945 | 4 | 3.156 | 26281.7 |
| 351 | 2024-12-11 19:21:49 | footfall | 3 | 146162 | 51 | 29.770 | 4909.7 |
| 350 | 2024-12-09 00:16:56 | footfall | 3 | 146162 | 51 | 11.453 | 12761.9 |
| 349 | 2024-12-08 02:35:49 | footfall | 2 | 121059 | 11 | 17.733 | 6826.8 |
| 348 | 2024-12-07 10:31:55 | footfall | 3 | 146162 | 51 | 32.763 | 4461.2 |
| 347 | 2024-12-06 04:21:43 | footfall | 3 | 146162 | 51 | 41.020 | 3563.2 |
| 346 | 2024-12-06 04:21:46 | footfall | 2 | 121059 | 11 | 27.643 | 4379.4 |
| 345 | 2024-12-06 04:21:06 | footfall | 1 | 82945 | 4 | 10.250 | 8092.2 |
| 344 | 2024-12-06 01:30:40 | footfall | 4 | 161609 | 316 | 19.533 | 8273.6 |
| 343 | 2024-12-05 17:26:04 | footfall | 4 | 161609 | 316 | 58.693 | 2753.5 |
| 342 | 2024-12-05 13:30:08 | footfall | 4 | 161609 | 316 | 62.723 | 2576.6 |
| 341 | 2024-12-05 06:43:44 | footfall | 4 | 161609 | 316 | 64.803 | 2493.9 |
| 340 | 2024-12-04 12:09:39 | footfall | 1 | 82945 | 4 | 6.703 | 12374.3 |
| 339 | 2024-11-25 12:44:14 | footfall | 1 | 82945 | 4 | 7.610 | 10899.5 |
| 338 | 2024-11-23 07:30:47 | footfall | 4 | 161609 | 316 | 48.176 | 3354.6 |
| 337 | 2024-11-22 12:14:31 | footfall | 1 | 82945 | 4 | 6.453 | 12853.7 |
| 336 | 2024-11-07 20:30:30 | footfall | 2 | 121059 | 11 | 3.140 | 38553.8 |
| 335 | 2024-11-07 20:30:03 | footfall | 3 | 146162 | 51 | 9.563 | 15284.1 |
| 334 | 2024-11-05 18:37:29 | footfall | 4 | 161609 | 316 | 44.283 | 3649.5 |
| 333 | 2024-11-05 14:19:59 | footfall | 2 | 121059 | 11 | 23.346 | 5185.4 |
| 332 | 2024-11-05 14:15:13 | footfall | 3 | 146162 | 51 | 7.563 | 19325.9 |
| 331 | 2024-11-05 14:15:12 | footfall | 3 | 146162 | 51 | 7.656 | 19091.2 |
| 330 | 2024-11-05 08:39:26 | footfall | 4 | 161609 | 316 | 61.533 | 2626.4 |
| 329 | 2024-11-05 08:39:29 | footfall | 3 | 146162 | 51 | 36.533 | 4000.8 |
| 328 | 2024-11-05 08:39:29 | footfall | 2 | 121059 | 11 | 18.610 | 6505.1 |
| 327 | 2024-11-05 08:39:24 | footfall | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 326 | 2024-11-04 01:19:43 | footfall | 3 | 146162 | 51 | 11.733 | 12457.3 |
| 325 | 2024-11-04 01:19:42 | footfall | 3 | 146162 | 51 | 8.203 | 17818.1 |
| 324 | 2024-11-04 01:19:44 | footfall | 2 | 121059 | 11 | 4.516 | 26806.7 |
| 323 | 2024-11-04 01:19:39 | footfall | 1 | 82945 | 4 | 1.890 | 43886.2 |
| 322 | 2024-10-25 17:17:42 | footfall | 1 | 82945 | 4 | 3.830 | 21656.7 |