History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sweep"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
530 | 2024-03-29 06:36:17 | sweep | 3 | 83667 | 957 | 7.376 | 11343.1 |
529 | 2024-03-29 06:35:57 | sweep | 2 | 53800 | 98 | 3.703 | 14528.8 |
528 | 2024-03-29 06:35:54 | sweep | 1 | 28756 | 10 | 1.500 | 19170.7 |
527 | 2024-03-29 06:35:44 | sweep | 3 | 83667 | 957 | 10.953 | 7638.7 |
526 | 2024-03-29 06:35:42 | sweep | 2 | 53800 | 98 | 3.140 | 17133.8 |
525 | 2024-03-29 06:35:31 | sweep | 1 | 28756 | 10 | 1.673 | 17188.3 |
524 | 2024-03-04 04:13:52 | sweep | 2 | 53800 | 98 | 3.440 | 15639.5 |
523 | 2024-03-04 04:13:50 | sweep | 3 | 83667 | 957 | 4.576 | 18283.9 |
522 | 2024-03-04 00:36:16 | sweep | 1 | 28756 | 10 | 0.750 | 38341.3 |
521 | 2024-03-01 08:01:52 | sweep | 2 | 53800 | 98 | 1.576 | 34137.1 |
520 | 2024-03-01 08:00:57 | sweep | 3 | 83667 | 957 | 8.000 | 10458.4 |
519 | 2024-02-28 22:51:53 | sweep | 2 | 53800 | 98 | 1.716 | 31352.0 |
518 | 2024-02-28 22:51:28 | sweep | 3 | 83667 | 957 | 4.470 | 18717.4 |
517 | 2024-02-28 03:07:34 | sweep | 1 | 28756 | 10 | 0.530 | 54256.6 |
516 | 2024-02-27 12:31:10 | sweep | 2 | 53800 | 98 | 1.626 | 33087.3 |
515 | 2024-02-27 12:30:37 | sweep | 3 | 83667 | 957 | 5.956 | 14047.5 |
514 | 2024-02-25 03:28:25 | sweep | 3 | 83667 | 957 | 3.453 | 24230.2 |
513 | 2024-02-02 21:54:39 | sweep | 1 | 28756 | 10 | 1.000 | 28756.0 |
512 | 2024-01-28 23:51:53 | sweep | 1 | 28756 | 10 | 0.513 | 56054.6 |
511 | 2024-01-25 06:45:43 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
510 | 2024-01-17 17:10:52 | sweep | 3 | 83667 | 957 | 3.280 | 25508.2 |
509 | 2024-01-09 13:42:24 | sweep | 2 | 53800 | 98 | 1.423 | 37807.4 |
508 | 2024-01-09 13:42:21 | sweep | 3 | 83667 | 957 | 3.296 | 25384.4 |
507 | 2024-01-09 09:50:47 | sweep | 3 | 83667 | 957 | 7.296 | 11467.5 |
506 | 2024-01-01 14:41:42 | sweep | 3 | 83667 | 957 | 3.330 | 25125.2 |
505 | 2024-01-01 14:41:40 | sweep | 2 | 53800 | 98 | 1.406 | 38264.6 |
504 | 2023-12-16 14:06:41 | sweep | 2 | 53800 | 98 | 1.516 | 35488.1 |
503 | 2023-11-30 05:19:04 | sweep | 1 | 28756 | 10 | 0.483 | 59536.2 |
502 | 2023-11-22 02:47:15 | sweep | 1 | 28756 | 10 | 0.500 | 57512.0 |
501 | 2023-11-16 21:55:40 | sweep | 3 | 83667 | 957 | 3.486 | 24000.9 |
500 | 2023-11-14 20:21:32 | sweep | 1 | 28756 | 10 | 0.533 | 53951.2 |
499 | 2023-10-30 22:34:17 | sweep | 1 | 28756 | 10 | 0.500 | 57512.0 |
498 | 2023-10-30 17:53:25 | sweep | 1 | 28756 | 10 | 0.503 | 57169.0 |
497 | 2023-10-23 22:02:06 | sweep | 1 | 28756 | 10 | 0.453 | 63479.0 |
496 | 2023-10-20 00:13:19 | sweep | 1 | 28756 | 10 | 0.483 | 59536.2 |
495 | 2023-10-11 16:26:12 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
494 | 2023-10-08 05:12:01 | sweep | 1 | 28756 | 10 | 0.450 | 63902.2 |
493 | 2023-09-26 08:27:49 | sweep | 1 | 28756 | 10 | 0.610 | 47141.0 |
492 | 2023-09-24 07:42:22 | sweep | 1 | 28756 | 10 | 0.500 | 57512.0 |
491 | 2023-09-17 02:24:07 | sweep | 2 | 53800 | 98 | 1.626 | 33087.3 |
490 | 2023-09-08 17:16:29 | sweep | 1 | 28756 | 10 | 0.500 | 57512.0 |
489 | 2023-08-17 20:00:00 | sweep | 3 | 83667 | 957 | 3.750 | 22311.2 |
488 | 2023-06-23 00:50:48 | sweep | 2 | 53800 | 98 | 1.390 | 38705.0 |
487 | 2023-06-16 01:09:25 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
486 | 2023-06-12 09:49:49 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
485 | 2023-05-05 13:55:03 | sweep | 2 | 53800 | 98 | 1.346 | 39970.3 |
484 | 2023-04-30 11:52:03 | sweep | 3 | 83667 | 957 | 3.250 | 25743.7 |
483 | 2023-04-08 23:17:41 | sweep | 2 | 53800 | 98 | 1.576 | 34137.1 |
482 | 2023-03-30 19:30:44 | sweep | 1 | 28756 | 10 | 0.423 | 67981.1 |
481 | 2023-03-16 13:16:32 | sweep | 2 | 53800 | 98 | 1.580 | 34050.6 |
480 | 2023-02-04 04:29:50 | sweep | 3 | 83667 | 957 | 3.220 | 25983.5 |
479 | 2023-01-31 03:36:15 | sweep | 1 | 28756 | 10 | 0.483 | 59536.2 |
478 | 2023-01-13 06:38:31 | sweep | 1 | 28756 | 10 | 0.423 | 67981.1 |
477 | 2022-12-17 00:04:32 | sweep | 2 | 53800 | 98 | 1.576 | 34137.1 |
476 | 2022-11-15 16:00:49 | sweep | 3 | 83667 | 957 | 3.656 | 22884.8 |
475 | 2022-11-03 04:40:23 | sweep | 1 | 28756 | 10 | 0.440 | 65354.5 |
474 | 2022-09-18 01:54:49 | sweep | 1 | 28756 | 10 | 0.440 | 65354.5 |
473 | 2022-08-09 11:36:18 | sweep | 2 | 53800 | 98 | 1.343 | 40059.6 |
472 | 2022-06-23 10:38:35 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
471 | 2022-05-19 02:50:30 | sweep | 3 | 83667 | 957 | 3.360 | 24900.9 |
470 | 2022-05-12 06:00:26 | sweep | 1 | 28756 | 10 | 0.513 | 56054.6 |
469 | 2022-05-11 12:24:01 | sweep | 3 | 83667 | 957 | 4.940 | 16936.6 |
468 | 2022-02-26 12:43:57 | sweep | 1 | 28756 | 10 | 0.453 | 63479.0 |
467 | 2022-02-24 09:38:16 | sweep | 1 | 28756 | 10 | 0.513 | 56054.6 |
466 | 2022-01-11 03:42:24 | sweep | 1 | 28756 | 10 | 0.453 | 63479.0 |
465 | 2022-01-08 23:17:20 | sweep | 3 | 83667 | 957 | 3.440 | 24321.8 |
464 | 2021-12-19 16:25:21 | sweep | 1 | 28756 | 10 | 0.513 | 56054.6 |
463 | 2021-12-17 13:52:47 | sweep | 1 | 28756 | 10 | 0.483 | 59536.2 |
462 | 2021-10-26 17:36:00 | sweep | 1 | 28756 | 10 | 0.593 | 48492.4 |
461 | 2021-09-25 07:20:06 | sweep | 1 | 28756 | 10 | 0.453 | 63479.0 |
460 | 2021-09-17 00:44:12 | sweep | 1 | 28756 | 10 | 0.516 | 55728.7 |
459 | 2021-08-28 07:14:12 | sweep | 1 | 28756 | 10 | 0.470 | 61183.0 |
458 | 2021-06-22 06:21:30 | sweep | 1 | 28756 | 10 | 0.516 | 55728.7 |
457 | 2021-05-28 00:59:58 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
456 | 2021-05-02 05:37:09 | sweep | 1 | 28756 | 10 | 0.500 | 57512.0 |
455 | 2021-04-09 07:50:59 | sweep | 1 | 28756 | 10 | 0.533 | 53951.2 |
454 | 2021-04-01 16:33:23 | sweep | 1 | 28756 | 10 | 0.500 | 57512.0 |
453 | 2021-03-20 00:59:37 | sweep | 1 | 28756 | 10 | 0.483 | 59536.2 |
452 | 2021-02-09 05:40:31 | sweep | 1 | 28756 | 10 | 0.483 | 59536.2 |
451 | 2021-01-15 01:31:34 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
450 | 2020-12-17 03:10:53 | sweep | 1 | 28756 | 10 | 0.453 | 63479.0 |
449 | 2020-11-20 19:30:05 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
448 | 2020-11-07 05:57:05 | sweep | 1 | 28756 | 10 | 0.516 | 55728.7 |
447 | 2020-10-30 08:16:02 | sweep | 1 | 28756 | 10 | 0.470 | 61183.0 |
446 | 2020-10-02 02:08:53 | sweep | 1 | 28756 | 10 | 0.440 | 65354.5 |
445 | 2020-09-03 02:45:20 | sweep | 1 | 28756 | 10 | 0.466 | 61708.2 |
444 | 2020-08-30 19:12:35 | sweep | 1 | 28756 | 10 | 0.453 | 63479.0 |
443 | 2020-08-15 22:43:37 | sweep | 1 | 28756 | 10 | 0.470 | 61183.0 |
442 | 2020-07-24 06:54:52 | sweep | 1 | 28756 | 10 | 0.470 | 61183.0 |
441 | 2020-05-19 07:49:39 | sweep | 1 | 28756 | 10 | 0.436 | 65954.1 |
440 | 2020-05-16 20:52:09 | sweep | 1 | 28756 | 10 | 0.440 | 65354.5 |
439 | 2020-03-27 16:06:52 | sweep | 1 | 28756 | 10 | 0.563 | 51076.4 |
438 | 2020-03-27 08:16:20 | sweep | 3 | 83667 | 957 | 4.703 | 17790.1 |
437 | 2020-03-27 03:42:28 | sweep | 3 | 83667 | 957 | 4.296 | 19475.6 |
436 | 2020-03-26 09:03:10 | sweep | 3 | 83667 | 957 | 4.783 | 17492.6 |
435 | 2020-03-26 03:02:51 | sweep | 3 | 83667 | 957 | 3.703 | 22594.4 |
434 | 2020-03-25 17:30:53 | sweep | 3 | 83667 | 957 | 5.126 | 16322.1 |
433 | 2020-03-25 09:50:07 | sweep | 3 | 83667 | 957 | 3.766 | 22216.4 |
432 | 2020-03-23 13:40:57 | sweep | 1 | 28756 | 10 | 1.110 | 25906.3 |
431 | 2020-03-23 08:40:07 | sweep | 1 | 28756 | 10 | 0.500 | 57512.0 |