History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"snell"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
715 | 2024-04-03 04:22:07 | snell | 1 | 28756 | 9 | 1.156 | 24875.4 |
714 | 2024-03-31 02:44:34 | snell | 1 | 28756 | 9 | 0.513 | 56054.6 |
713 | 2024-03-12 21:28:30 | snell | 1 | 28756 | 9 | 0.533 | 53951.2 |
712 | 2024-03-04 02:23:03 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
711 | 2024-02-25 19:16:35 | snell | 1 | 28756 | 9 | 0.470 | 61183.0 |
710 | 2024-02-24 00:17:55 | snell | 3 | 83667 | 905 | 7.670 | 10908.3 |
709 | 2024-02-23 22:58:29 | snell | 2 | 53800 | 90 | 1.780 | 30224.7 |
708 | 2024-02-23 01:12:49 | snell | 2 | 53800 | 90 | 1.830 | 29398.9 |
707 | 2024-02-03 02:53:47 | snell | 1 | 28756 | 9 | 0.516 | 55728.7 |
706 | 2024-01-26 02:13:25 | snell | 1 | 28756 | 9 | 0.546 | 52666.7 |
705 | 2024-01-14 18:03:07 | snell | 3 | 83667 | 905 | 4.516 | 18526.8 |
704 | 2024-01-04 12:10:17 | snell | 2 | 53800 | 90 | 1.873 | 28724.0 |
703 | 2023-12-28 06:41:55 | snell | 3 | 83667 | 905 | 3.326 | 25155.4 |
702 | 2023-12-20 05:24:28 | snell | 1 | 28756 | 9 | 0.470 | 61183.0 |
701 | 2023-12-11 21:40:08 | snell | 1 | 28756 | 9 | 0.516 | 55728.7 |
700 | 2023-11-26 10:04:07 | snell | 2 | 53800 | 90 | 1.516 | 35488.1 |
699 | 2023-11-22 03:52:38 | snell | 2 | 53800 | 90 | 1.500 | 35866.7 |
698 | 2023-11-22 03:52:35 | snell | 3 | 83667 | 905 | 3.843 | 21771.3 |
697 | 2023-11-20 16:51:12 | snell | 3 | 83667 | 905 | 4.000 | 20916.8 |
696 | 2023-11-18 18:52:14 | snell | 2 | 53800 | 90 | 1.406 | 38264.6 |
695 | 2023-11-17 08:34:15 | snell | 2 | 53800 | 90 | 1.486 | 36204.6 |
694 | 2023-11-15 11:41:27 | snell | 3 | 83667 | 905 | 4.016 | 20833.4 |
693 | 2023-11-15 00:41:51 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
692 | 2023-11-14 14:53:48 | snell | 1 | 28756 | 9 | 0.513 | 56054.6 |
691 | 2023-11-08 16:32:06 | snell | 1 | 28756 | 9 | 0.513 | 56054.6 |
690 | 2023-11-04 17:00:10 | snell | 3 | 83667 | 905 | 4.560 | 18348.0 |
689 | 2023-11-03 13:26:39 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
688 | 2023-10-31 07:11:26 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
687 | 2023-10-28 11:12:19 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
686 | 2023-10-28 11:12:11 | snell | 2 | 53800 | 90 | 1.546 | 34799.5 |
685 | 2023-10-27 05:42:57 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
684 | 2023-10-21 22:43:35 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
683 | 2023-10-21 03:08:03 | snell | 3 | 83667 | 905 | 3.873 | 21602.6 |
682 | 2023-10-16 22:31:58 | snell | 3 | 83667 | 905 | 4.406 | 18989.3 |
681 | 2023-10-13 22:54:19 | snell | 1 | 28756 | 9 | 0.576 | 49923.6 |
680 | 2023-10-05 14:03:28 | snell | 1 | 28756 | 9 | 0.440 | 65354.5 |
679 | 2023-10-04 15:28:04 | snell | 3 | 83667 | 905 | 3.906 | 21420.1 |
678 | 2023-10-01 14:26:26 | snell | 3 | 83667 | 905 | 4.533 | 18457.3 |
677 | 2023-09-29 01:28:47 | snell | 3 | 83667 | 905 | 4.516 | 18526.8 |
676 | 2023-09-26 19:37:15 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
675 | 2023-09-25 00:42:28 | snell | 1 | 28756 | 9 | 0.440 | 65354.5 |
674 | 2023-09-14 10:13:55 | snell | 1 | 28756 | 9 | 0.750 | 38341.3 |
673 | 2023-08-18 12:26:29 | snell | 2 | 53800 | 90 | 1.343 | 40059.6 |
672 | 2023-08-10 18:47:40 | snell | 2 | 53800 | 90 | 1.390 | 38705.0 |
671 | 2023-07-21 09:16:12 | snell | 1 | 28756 | 9 | 0.483 | 59536.2 |
670 | 2023-07-09 11:51:14 | snell | 3 | 83667 | 905 | 3.406 | 24564.6 |
669 | 2023-06-26 13:18:48 | snell | 1 | 28756 | 9 | 0.436 | 65954.1 |
668 | 2023-05-18 00:26:32 | snell | 2 | 53800 | 90 | 1.516 | 35488.1 |
667 | 2023-05-02 19:02:14 | snell | 2 | 53800 | 90 | 1.376 | 39098.8 |
666 | 2023-04-22 23:43:15 | snell | 2 | 53800 | 90 | 1.376 | 39098.8 |
665 | 2023-04-16 06:47:57 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
664 | 2023-04-05 19:52:42 | snell | 2 | 53800 | 90 | 1.576 | 34137.1 |
663 | 2023-03-28 12:44:31 | snell | 3 | 83667 | 905 | 3.986 | 20990.2 |
662 | 2023-03-20 10:26:57 | snell | 2 | 53800 | 90 | 1.686 | 31909.8 |
661 | 2023-02-25 06:03:30 | snell | 1 | 28756 | 9 | 0.466 | 61708.2 |
660 | 2023-02-09 23:19:38 | snell | 2 | 53800 | 90 | 1.360 | 39558.8 |
659 | 2023-02-06 10:49:01 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
658 | 2022-12-26 02:26:54 | snell | 3 | 83667 | 905 | 3.610 | 23176.5 |
657 | 2022-12-04 20:26:12 | snell | 1 | 28756 | 9 | 0.440 | 65354.5 |
656 | 2022-11-21 12:20:40 | snell | 2 | 53800 | 90 | 1.610 | 33416.1 |
655 | 2022-10-21 15:13:03 | snell | 1 | 28756 | 9 | 0.440 | 65354.5 |
654 | 2022-10-18 00:54:17 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
653 | 2022-08-28 12:37:00 | snell | 3 | 83667 | 905 | 3.356 | 24930.6 |
652 | 2022-07-31 21:01:28 | snell | 1 | 28756 | 9 | 0.436 | 65954.1 |
651 | 2022-07-19 04:28:29 | snell | 3 | 83667 | 905 | 3.563 | 23482.2 |
650 | 2022-06-16 11:41:59 | snell | 1 | 28756 | 9 | 0.450 | 63902.2 |
649 | 2022-06-05 08:18:04 | snell | 3 | 83667 | 905 | 4.110 | 20356.9 |
648 | 2022-04-28 06:28:30 | snell | 3 | 83667 | 905 | 3.843 | 21771.3 |
647 | 2022-04-26 23:57:31 | snell | 2 | 53800 | 90 | 1.580 | 34050.6 |
646 | 2022-03-26 05:31:22 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
645 | 2022-03-25 14:20:56 | snell | 3 | 83667 | 905 | 4.186 | 19987.3 |
644 | 2022-02-04 20:02:51 | snell | 1 | 28756 | 9 | 0.436 | 65954.1 |
643 | 2022-01-01 03:16:28 | snell | 1 | 28756 | 9 | 0.563 | 51076.4 |
642 | 2021-12-10 09:29:04 | snell | 3 | 83667 | 905 | 4.266 | 19612.5 |
641 | 2021-11-26 11:16:50 | snell | 1 | 28756 | 9 | 0.470 | 61183.0 |
640 | 2021-11-01 15:22:04 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
639 | 2021-10-12 03:39:09 | snell | 1 | 28756 | 9 | 0.436 | 65954.1 |
638 | 2021-09-21 01:34:13 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
637 | 2021-09-18 21:50:54 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
636 | 2021-09-03 17:11:15 | snell | 1 | 28756 | 9 | 0.483 | 59536.2 |
635 | 2021-09-01 11:44:18 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
634 | 2021-07-12 06:11:21 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
633 | 2021-07-10 20:38:20 | snell | 1 | 28756 | 9 | 0.436 | 65954.1 |
632 | 2021-04-30 20:56:04 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
631 | 2021-04-11 08:12:59 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
630 | 2021-03-30 04:27:41 | snell | 1 | 28756 | 9 | 0.483 | 59536.2 |
629 | 2021-02-07 23:10:36 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
628 | 2021-02-03 17:31:18 | snell | 1 | 28756 | 9 | 0.483 | 59536.2 |
627 | 2020-12-25 11:31:37 | snell | 1 | 28756 | 9 | 0.830 | 34645.8 |
626 | 2020-10-26 18:33:07 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
625 | 2020-10-01 01:16:28 | snell | 1 | 28756 | 9 | 0.436 | 65954.1 |
624 | 2020-09-21 15:16:31 | snell | 1 | 28756 | 9 | 0.440 | 65354.5 |
623 | 2020-07-27 17:16:46 | snell | 1 | 28756 | 9 | 0.486 | 59168.7 |
622 | 2020-06-05 01:39:20 | snell | 1 | 28756 | 9 | 0.453 | 63479.0 |
621 | 2020-04-28 15:23:29 | snell | 1 | 28756 | 9 | 0.500 | 57512.0 |
620 | 2020-03-26 08:39:20 | snell | 1 | 28756 | 9 | 1.000 | 28756.0 |
619 | 2020-03-23 18:44:56 | snell | 1 | 28756 | 9 | 0.516 | 55728.7 |
618 | 2020-03-23 06:07:37 | snell | 1 | 28756 | 9 | 0.546 | 52666.7 |
617 | 2020-03-23 00:51:25 | snell | 1 | 28756 | 9 | 1.046 | 27491.4 |
616 | 2020-03-21 21:13:56 | snell | 1 | 28756 | 9 | 0.483 | 59536.2 |