History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gadid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
759 | 2024-05-08 23:45:11 | gadid | 1 | 28756 | 6 | 1.220 | 23570.5 |
758 | 2024-05-06 16:00:24 | gadid | 3 | 83667 | 1114 | 11.826 | 7074.8 |
757 | 2024-05-06 10:57:09 | gadid | 2 | 53800 | 86 | 1.733 | 31044.4 |
756 | 2024-05-06 10:56:50 | gadid | 3 | 83667 | 1114 | 4.326 | 19340.5 |
755 | 2024-05-06 06:44:00 | gadid | 2 | 53800 | 86 | 2.906 | 18513.4 |
754 | 2024-05-06 06:43:56 | gadid | 3 | 83667 | 1114 | 4.796 | 17445.2 |
753 | 2024-05-06 06:43:52 | gadid | 1 | 28756 | 6 | 0.563 | 51076.4 |
752 | 2024-05-06 06:43:11 | gadid | 3 | 83667 | 1114 | 8.813 | 9493.6 |
751 | 2024-05-06 06:43:15 | gadid | 2 | 53800 | 86 | 3.596 | 14961.1 |
750 | 2024-05-06 06:42:27 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
749 | 2024-04-30 21:14:44 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
748 | 2024-04-28 01:43:13 | gadid | 1 | 28756 | 6 | 1.140 | 25224.6 |
747 | 2024-04-13 07:26:33 | gadid | 1 | 28756 | 6 | 0.580 | 49579.3 |
746 | 2024-04-06 05:38:46 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
745 | 2024-03-31 09:24:05 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
744 | 2024-03-31 00:47:06 | gadid | 2 | 53800 | 86 | 4.513 | 11921.1 |
743 | 2024-03-30 22:24:32 | gadid | 2 | 53800 | 86 | 1.906 | 28226.7 |
742 | 2024-03-30 20:01:53 | gadid | 3 | 83667 | 1114 | 4.610 | 18149.0 |
741 | 2024-03-30 18:29:25 | gadid | 2 | 53800 | 86 | 1.593 | 33772.8 |
740 | 2024-03-30 18:29:24 | gadid | 1 | 28756 | 6 | 0.533 | 53951.2 |
739 | 2024-03-30 18:28:53 | gadid | 3 | 83667 | 1114 | 4.206 | 19892.3 |
738 | 2024-03-30 00:59:58 | gadid | 3 | 83667 | 1114 | 9.503 | 8804.3 |
737 | 2024-03-29 16:27:01 | gadid | 2 | 53800 | 86 | 3.563 | 15099.6 |
736 | 2024-03-29 16:26:53 | gadid | 3 | 83667 | 1114 | 4.610 | 18149.0 |
735 | 2024-03-29 16:26:23 | gadid | 1 | 28756 | 6 | 1.140 | 25224.6 |
734 | 2024-03-07 04:05:05 | gadid | 1 | 28756 | 6 | 1.123 | 25606.4 |
733 | 2024-03-05 16:00:30 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
732 | 2024-03-02 08:15:42 | gadid | 1 | 28756 | 6 | 1.703 | 16885.5 |
731 | 2024-03-01 07:58:28 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
730 | 2024-02-28 19:18:51 | gadid | 2 | 53800 | 86 | 1.486 | 36204.6 |
729 | 2024-02-28 18:37:06 | gadid | 3 | 83667 | 1114 | 4.186 | 19987.3 |
728 | 2024-02-28 10:41:09 | gadid | 2 | 53800 | 86 | 1.783 | 30173.9 |
727 | 2024-02-28 10:40:45 | gadid | 3 | 83667 | 1114 | 5.716 | 14637.3 |
726 | 2024-02-28 08:07:45 | gadid | 3 | 83667 | 1114 | 4.690 | 17839.4 |
725 | 2024-02-28 08:07:44 | gadid | 2 | 53800 | 86 | 4.016 | 13396.4 |
724 | 2024-02-28 08:07:37 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
723 | 2024-02-03 18:30:59 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
722 | 2024-01-29 05:27:37 | gadid | 1 | 28756 | 6 | 0.486 | 59168.7 |
721 | 2024-01-28 22:04:03 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
720 | 2024-01-14 16:21:10 | gadid | 3 | 83667 | 1114 | 3.516 | 23796.1 |
719 | 2024-01-14 16:21:11 | gadid | 2 | 53800 | 86 | 1.580 | 34050.6 |
718 | 2023-12-31 06:52:09 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
717 | 2023-12-25 21:26:35 | gadid | 3 | 83667 | 1114 | 3.470 | 24111.5 |
716 | 2023-12-25 21:26:37 | gadid | 2 | 53800 | 86 | 1.640 | 32804.9 |
715 | 2023-12-25 05:57:05 | gadid | 3 | 83667 | 1114 | 3.373 | 24804.9 |
714 | 2023-12-25 05:57:01 | gadid | 2 | 53800 | 86 | 1.423 | 37807.4 |
713 | 2023-11-18 02:45:09 | gadid | 3 | 83667 | 1114 | 3.953 | 21165.4 |
712 | 2023-11-18 02:45:01 | gadid | 2 | 53800 | 86 | 1.393 | 38621.7 |
711 | 2023-11-12 22:02:42 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
710 | 2023-11-12 09:58:08 | gadid | 1 | 28756 | 6 | 0.440 | 65354.5 |
709 | 2023-11-01 20:09:29 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
708 | 2023-10-27 08:27:04 | gadid | 1 | 28756 | 6 | 0.483 | 59536.2 |
707 | 2023-10-22 09:15:32 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
706 | 2023-10-21 14:38:23 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
705 | 2023-10-18 17:51:55 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
704 | 2023-10-13 16:42:48 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
703 | 2023-10-04 01:23:55 | gadid | 1 | 28756 | 6 | 0.486 | 59168.7 |
702 | 2023-09-27 01:14:15 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
701 | 2023-09-13 12:41:07 | gadid | 1 | 28756 | 6 | 0.466 | 61708.2 |
700 | 2023-08-16 23:11:59 | gadid | 1 | 28756 | 6 | 0.483 | 59536.2 |
699 | 2023-07-18 12:16:00 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
698 | 2023-05-16 18:55:05 | gadid | 1 | 28756 | 6 | 0.470 | 61183.0 |
697 | 2023-04-10 17:13:53 | gadid | 1 | 28756 | 6 | 0.440 | 65354.5 |
696 | 2023-03-14 15:14:41 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
695 | 2023-03-12 15:10:26 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
694 | 2023-01-03 13:50:00 | gadid | 1 | 28756 | 6 | 0.466 | 61708.2 |
693 | 2022-12-29 02:32:11 | gadid | 1 | 28756 | 6 | 0.483 | 59536.2 |
692 | 2022-09-24 11:39:59 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
691 | 2022-09-14 16:30:51 | gadid | 1 | 28756 | 6 | 0.470 | 61183.0 |
690 | 2022-06-01 15:46:47 | gadid | 1 | 28756 | 6 | 0.440 | 65354.5 |
689 | 2022-05-25 21:05:02 | gadid | 1 | 28756 | 6 | 0.453 | 63479.0 |
688 | 2022-05-08 02:02:25 | gadid | 1 | 28756 | 6 | 0.456 | 63061.4 |
687 | 2022-04-28 06:48:39 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
686 | 2022-02-21 14:49:46 | gadid | 1 | 28756 | 6 | 0.470 | 61183.0 |
685 | 2022-01-26 22:53:34 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
684 | 2021-11-28 09:40:01 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
683 | 2021-11-24 09:15:30 | gadid | 1 | 28756 | 6 | 0.546 | 52666.7 |
682 | 2021-11-16 21:40:20 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
681 | 2021-11-13 09:34:45 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
680 | 2021-10-10 03:58:24 | gadid | 1 | 28756 | 6 | 0.466 | 61708.2 |
679 | 2021-09-08 04:22:04 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
678 | 2021-08-21 13:47:49 | gadid | 1 | 28756 | 6 | 0.453 | 63479.0 |
677 | 2021-08-14 00:08:45 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
676 | 2021-06-03 13:18:05 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
675 | 2021-05-13 06:56:20 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
674 | 2021-05-09 17:34:56 | gadid | 1 | 28756 | 6 | 0.516 | 55728.7 |
673 | 2021-05-09 07:57:17 | gadid | 1 | 28756 | 6 | 0.546 | 52666.7 |
672 | 2021-02-20 14:39:59 | gadid | 1 | 28756 | 6 | 1.000 | 28756.0 |
671 | 2021-02-16 22:16:15 | gadid | 1 | 28756 | 6 | 0.453 | 63479.0 |
670 | 2021-02-04 04:48:40 | gadid | 1 | 28756 | 6 | 0.500 | 57512.0 |
669 | 2020-11-02 17:26:50 | gadid | 1 | 28756 | 6 | 0.466 | 61708.2 |
668 | 2020-10-20 06:41:49 | gadid | 1 | 28756 | 6 | 0.436 | 65954.1 |
667 | 2020-10-09 16:26:29 | gadid | 1 | 28756 | 6 | 0.453 | 63479.0 |
666 | 2020-09-24 04:52:10 | gadid | 1 | 28756 | 6 | 0.423 | 67981.1 |
665 | 2020-09-16 21:44:25 | gadid | 1 | 28756 | 6 | 0.456 | 63061.4 |
664 | 2020-08-26 14:24:40 | gadid | 1 | 28756 | 6 | 0.486 | 59168.7 |
663 | 2020-08-18 11:54:38 | gadid | 1 | 28756 | 6 | 0.466 | 61708.2 |
662 | 2020-08-02 16:38:17 | gadid | 1 | 28756 | 6 | 0.563 | 51076.4 |
661 | 2020-07-30 18:32:56 | gadid | 1 | 28756 | 6 | 0.483 | 59536.2 |
660 | 2020-07-26 07:10:44 | gadid | 1 | 28756 | 6 | 0.466 | 61708.2 |