History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
737 | 2024-04-02 21:41:00 | grant | 1 | 28756 | 12 | 0.486 | 59168.7 |
736 | 2024-04-02 10:30:41 | grant | 2 | 53800 | 159 | 1.436 | 37465.2 |
735 | 2024-03-31 02:08:16 | grant | 1 | 28756 | 12 | 1.220 | 23570.5 |
734 | 2024-03-28 23:29:33 | grant | 2 | 53800 | 159 | 2.860 | 18811.2 |
733 | 2024-03-28 23:29:29 | grant | 1 | 28756 | 12 | 1.093 | 26309.2 |
732 | 2024-03-28 23:29:22 | grant | 2 | 53800 | 159 | 3.436 | 15657.7 |
731 | 2024-03-28 23:29:18 | grant | 1 | 28756 | 12 | 1.093 | 26309.2 |
730 | 2024-03-28 22:08:30 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
729 | 2024-02-27 20:21:34 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
728 | 2024-01-29 00:07:39 | grant | 1 | 28756 | 12 | 0.453 | 63479.0 |
727 | 2024-01-28 20:17:37 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
726 | 2024-01-09 06:17:29 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
725 | 2024-01-04 00:07:52 | grant | 2 | 53800 | 159 | 1.516 | 35488.1 |
724 | 2024-01-02 04:03:42 | grant | 2 | 53800 | 159 | 1.640 | 32804.9 |
723 | 2023-12-06 21:12:21 | grant | 2 | 53800 | 159 | 1.623 | 33148.5 |
722 | 2023-11-24 20:36:09 | grant | 2 | 53800 | 159 | 1.466 | 36698.5 |
721 | 2023-11-20 11:37:44 | grant | 1 | 28756 | 12 | 0.440 | 65354.5 |
720 | 2023-11-13 18:57:19 | grant | 1 | 28756 | 12 | 0.423 | 67981.1 |
719 | 2023-11-01 13:46:10 | grant | 1 | 28756 | 12 | 0.440 | 65354.5 |
718 | 2023-10-31 07:07:45 | grant | 1 | 28756 | 12 | 0.486 | 59168.7 |
717 | 2023-10-21 23:49:56 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
716 | 2023-10-19 09:15:55 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
715 | 2023-10-18 15:50:00 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
714 | 2023-10-17 13:19:30 | grant | 2 | 53800 | 159 | 3.406 | 15795.7 |
713 | 2023-10-11 00:08:43 | grant | 1 | 28756 | 12 | 0.513 | 56054.6 |
712 | 2023-10-03 16:08:46 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
711 | 2023-09-26 03:02:49 | grant | 1 | 28756 | 12 | 0.516 | 55728.7 |
710 | 2023-09-22 02:06:21 | grant | 1 | 28756 | 12 | 0.470 | 61183.0 |
709 | 2023-09-03 21:57:15 | grant | 2 | 53800 | 159 | 1.440 | 37361.1 |
708 | 2023-08-26 07:36:34 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
707 | 2023-07-10 00:37:05 | grant | 1 | 28756 | 12 | 0.453 | 63479.0 |
706 | 2023-05-26 03:31:27 | grant | 1 | 28756 | 12 | 0.470 | 61183.0 |
705 | 2023-04-02 11:41:14 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
704 | 2023-03-21 16:31:49 | grant | 1 | 28756 | 12 | 0.466 | 61708.2 |
703 | 2023-01-07 06:16:39 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
702 | 2022-12-24 13:58:46 | grant | 1 | 28756 | 12 | 0.453 | 63479.0 |
701 | 2022-12-22 17:40:52 | grant | 2 | 53800 | 159 | 1.343 | 40059.6 |
700 | 2022-10-02 05:51:10 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
699 | 2022-09-19 18:11:04 | grant | 1 | 28756 | 12 | 0.420 | 68466.7 |
698 | 2022-09-18 13:31:45 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
697 | 2022-09-09 11:52:19 | grant | 1 | 28756 | 12 | 0.470 | 61183.0 |
696 | 2022-09-06 17:33:58 | grant | 1 | 28756 | 12 | 0.486 | 59168.7 |
695 | 2022-09-03 09:06:35 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
694 | 2022-08-26 04:29:40 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
693 | 2022-08-19 06:54:43 | grant | 2 | 53800 | 159 | 1.360 | 39558.8 |
692 | 2022-08-15 00:18:49 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
691 | 2022-08-14 05:17:42 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
690 | 2022-08-07 05:11:27 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
689 | 2022-08-05 21:49:48 | grant | 1 | 28756 | 12 | 0.420 | 68466.7 |
688 | 2022-07-30 05:23:37 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
687 | 2022-07-17 18:34:49 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
686 | 2022-07-10 04:18:01 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
685 | 2022-07-03 12:07:35 | grant | 1 | 28756 | 12 | 0.470 | 61183.0 |
684 | 2022-07-02 15:59:01 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
683 | 2022-07-02 06:49:32 | grant | 1 | 28756 | 12 | 0.440 | 65354.5 |
682 | 2022-05-17 11:21:00 | grant | 1 | 28756 | 12 | 0.796 | 36125.6 |
681 | 2022-05-15 07:13:54 | grant | 1 | 28756 | 12 | 0.420 | 68466.7 |
680 | 2022-05-15 04:50:56 | grant | 1 | 28756 | 12 | 0.470 | 61183.0 |
679 | 2022-05-13 02:51:30 | grant | 1 | 28756 | 12 | 0.453 | 63479.0 |
678 | 2022-02-07 00:36:20 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
677 | 2022-02-06 09:08:26 | grant | 2 | 53800 | 159 | 1.736 | 30990.8 |
676 | 2022-01-27 17:23:52 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
675 | 2022-01-25 14:32:17 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
674 | 2022-01-06 04:52:39 | grant | 1 | 28756 | 12 | 0.546 | 52666.7 |
673 | 2022-01-05 17:35:58 | grant | 1 | 28756 | 12 | 0.516 | 55728.7 |
672 | 2022-01-05 08:18:28 | grant | 1 | 28756 | 12 | 0.530 | 54256.6 |
671 | 2022-01-04 17:07:28 | grant | 1 | 28756 | 12 | 0.530 | 54256.6 |
670 | 2021-12-07 23:22:05 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
669 | 2021-12-07 12:00:49 | grant | 1 | 28756 | 12 | 0.513 | 56054.6 |
668 | 2021-12-07 02:34:53 | grant | 1 | 28756 | 12 | 0.503 | 57169.0 |
667 | 2021-12-06 11:35:55 | grant | 1 | 28756 | 12 | 0.513 | 56054.6 |
666 | 2021-12-05 20:05:24 | grant | 1 | 28756 | 12 | 0.450 | 63902.2 |
665 | 2021-12-05 08:58:44 | grant | 1 | 28756 | 12 | 0.453 | 63479.0 |
664 | 2021-12-02 03:59:50 | grant | 1 | 28756 | 12 | 0.563 | 51076.4 |
663 | 2021-12-01 17:02:07 | grant | 1 | 28756 | 12 | 1.080 | 26625.9 |
662 | 2021-12-01 10:20:41 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
661 | 2021-11-30 15:26:48 | grant | 1 | 28756 | 12 | 0.533 | 53951.2 |
660 | 2021-11-29 23:17:06 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
659 | 2021-11-29 12:01:44 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
658 | 2021-11-29 03:48:34 | grant | 1 | 28756 | 12 | 0.453 | 63479.0 |
657 | 2021-11-21 11:29:07 | grant | 1 | 28756 | 12 | 0.453 | 63479.0 |
656 | 2021-11-20 23:42:21 | grant | 1 | 28756 | 12 | 0.486 | 59168.7 |
655 | 2021-11-18 21:40:50 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
654 | 2021-11-12 23:26:54 | grant | 1 | 28756 | 12 | 0.516 | 55728.7 |
653 | 2021-11-09 11:35:03 | grant | 2 | 53800 | 159 | 1.780 | 30224.7 |
652 | 2021-11-02 17:46:32 | grant | 1 | 28756 | 12 | 0.513 | 56054.6 |
651 | 2021-10-21 14:31:42 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
650 | 2021-10-20 16:57:27 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
649 | 2021-10-02 13:30:57 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
648 | 2021-09-22 17:13:47 | grant | 1 | 28756 | 12 | 0.516 | 55728.7 |
647 | 2021-09-22 01:01:49 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
646 | 2021-09-21 10:24:03 | grant | 1 | 28756 | 12 | 0.516 | 55728.7 |
645 | 2021-09-15 00:31:52 | grant | 1 | 28756 | 12 | 0.500 | 57512.0 |
644 | 2021-08-31 01:24:04 | grant | 1 | 28756 | 12 | 0.513 | 56054.6 |
643 | 2021-08-15 19:08:33 | grant | 1 | 28756 | 12 | 0.436 | 65954.1 |
642 | 2021-08-02 22:37:06 | grant | 1 | 28756 | 12 | 0.423 | 67981.1 |
641 | 2021-06-03 03:36:26 | grant | 1 | 28756 | 12 | 0.423 | 67981.1 |
640 | 2021-04-25 00:57:55 | grant | 1 | 28756 | 12 | 0.483 | 59536.2 |
639 | 2021-04-07 10:28:21 | grant | 1 | 28756 | 12 | 0.640 | 44931.3 |
638 | 2021-02-16 18:09:01 | grant | 2 | 53800 | 159 | 1.406 | 38264.6 |