History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ghi"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
787 | 2024-05-11 09:18:40 | ghi | 1 | 5146 | 7 | 0.203 | 25349.8 |
786 | 2024-05-03 19:55:55 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
785 | 2024-05-03 00:11:16 | ghi | 2 | 14084 | 164 | 0.360 | 39122.2 |
784 | 2024-05-01 15:25:11 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
783 | 2024-04-29 20:02:02 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
782 | 2024-04-29 04:33:29 | ghi | 1 | 5146 | 7 | 0.186 | 27666.7 |
781 | 2024-04-29 04:30:45 | ghi | 1 | 5146 | 7 | 0.296 | 17385.1 |
780 | 2024-04-29 00:57:22 | ghi | 1 | 5146 | 7 | 0.190 | 27084.2 |
779 | 2024-04-19 19:18:46 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
778 | 2024-04-19 15:16:11 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
777 | 2024-04-11 16:18:56 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
776 | 2024-04-11 14:49:48 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
775 | 2024-04-02 17:44:01 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
774 | 2024-03-30 18:59:30 | ghi | 1 | 5146 | 7 | 0.390 | 13194.9 |
773 | 2024-03-26 17:05:55 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
772 | 2024-03-02 16:14:57 | ghi | 1 | 5146 | 7 | 0.283 | 18183.7 |
771 | 2024-02-29 17:42:08 | ghi | 1 | 5146 | 7 | 0.096 | 53604.2 |
770 | 2024-02-25 15:37:03 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
769 | 2024-02-08 02:43:08 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
768 | 2024-02-02 13:57:27 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
767 | 2024-01-27 19:01:07 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
766 | 2024-01-26 04:33:11 | ghi | 1 | 5146 | 7 | 0.203 | 25349.8 |
765 | 2024-01-26 02:29:53 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
764 | 2024-01-19 00:30:13 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
763 | 2024-01-11 03:42:54 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
762 | 2023-11-27 01:26:11 | ghi | 2 | 14084 | 164 | 0.406 | 34689.7 |
761 | 2023-11-25 15:50:07 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
760 | 2023-11-20 09:45:27 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
759 | 2023-11-13 12:38:35 | ghi | 2 | 14084 | 164 | 0.356 | 39561.8 |
758 | 2023-11-08 12:14:34 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
757 | 2023-11-08 11:00:13 | ghi | 2 | 14084 | 164 | 0.390 | 36112.8 |
756 | 2023-11-07 07:46:02 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
755 | 2023-11-07 07:03:59 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
754 | 2023-11-05 05:04:25 | ghi | 2 | 14084 | 164 | 0.406 | 34689.7 |
753 | 2023-11-04 22:30:44 | ghi | 2 | 14084 | 164 | 0.326 | 43202.5 |
752 | 2023-10-26 09:14:23 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
751 | 2023-10-21 04:54:33 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
750 | 2023-10-17 14:23:24 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
749 | 2023-10-12 21:53:23 | ghi | 2 | 14084 | 164 | 0.360 | 39122.2 |
748 | 2023-10-10 13:33:35 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
747 | 2023-10-04 11:28:24 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
746 | 2023-09-27 03:12:10 | ghi | 2 | 14084 | 164 | 0.310 | 45432.3 |
745 | 2023-09-22 00:26:48 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
744 | 2023-09-19 17:22:06 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
743 | 2023-09-18 18:48:23 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
742 | 2023-09-12 10:31:42 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
741 | 2023-09-06 15:26:34 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
740 | 2023-06-29 23:07:03 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
739 | 2023-06-09 17:42:52 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
738 | 2023-05-29 09:16:03 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
737 | 2023-03-31 15:12:10 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
736 | 2023-03-29 06:49:44 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
735 | 2023-02-09 19:00:37 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
734 | 2023-01-12 06:44:16 | ghi | 1 | 5146 | 7 | 0.063 | 81682.5 |
733 | 2022-10-27 16:31:02 | ghi | 1 | 5146 | 7 | 0.060 | 85766.7 |
732 | 2022-10-26 16:16:13 | ghi | 2 | 14084 | 164 | 0.330 | 42678.8 |
731 | 2022-10-26 15:57:45 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
730 | 2022-10-23 06:25:11 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
729 | 2022-09-12 07:06:27 | ghi | 1 | 5146 | 7 | 0.063 | 81682.5 |
728 | 2022-09-10 16:40:31 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
727 | 2022-08-29 08:07:26 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
726 | 2022-08-06 22:50:34 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
725 | 2022-07-03 09:08:25 | ghi | 1 | 5146 | 7 | 0.063 | 81682.5 |
724 | 2022-07-02 09:39:05 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
723 | 2022-06-29 14:05:35 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
722 | 2022-06-25 20:47:07 | ghi | 1 | 5146 | 7 | 0.126 | 40841.3 |
721 | 2022-06-16 09:06:45 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
720 | 2022-06-16 05:57:22 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
719 | 2022-06-15 20:05:31 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
718 | 2022-06-08 19:16:03 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
717 | 2022-06-08 16:17:08 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
716 | 2022-06-01 12:38:46 | ghi | 1 | 5146 | 7 | 0.063 | 81682.5 |
715 | 2022-05-26 01:51:42 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
714 | 2022-05-25 16:06:13 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
713 | 2022-03-06 02:56:16 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
712 | 2022-02-19 10:35:13 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
711 | 2021-12-10 18:27:51 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
710 | 2021-11-22 08:50:03 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
709 | 2021-10-24 04:16:59 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
708 | 2021-09-10 00:58:19 | ghi | 1 | 5146 | 7 | 0.093 | 55333.3 |
707 | 2021-09-07 20:27:17 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
706 | 2021-08-19 01:29:08 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
705 | 2021-08-16 04:17:29 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
704 | 2021-08-11 12:19:43 | ghi | 2 | 14084 | 164 | 0.330 | 42678.8 |
703 | 2021-07-26 14:04:12 | ghi | 2 | 14084 | 164 | 0.310 | 45432.3 |
702 | 2021-07-24 03:19:02 | ghi | 2 | 14084 | 164 | 0.373 | 37758.7 |
701 | 2021-07-07 15:41:32 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
700 | 2021-06-20 11:58:25 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
699 | 2021-05-12 03:16:53 | ghi | 1 | 5146 | 7 | 0.186 | 27666.7 |
698 | 2021-04-30 05:17:44 | ghi | 2 | 14084 | 164 | 0.330 | 42678.8 |
697 | 2021-02-24 21:24:24 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
696 | 2021-02-07 19:15:16 | ghi | 1 | 5146 | 7 | 0.096 | 53604.2 |
695 | 2021-02-02 19:59:17 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
694 | 2021-01-29 14:37:15 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
693 | 2021-01-15 14:46:40 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
692 | 2020-11-19 03:40:21 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |
691 | 2020-11-04 14:51:55 | ghi | 2 | 14084 | 164 | 0.313 | 44996.8 |
690 | 2020-10-29 08:29:37 | ghi | 1 | 5146 | 7 | 0.080 | 64325.0 |
689 | 2020-10-26 20:23:08 | ghi | 1 | 5146 | 7 | 0.096 | 53604.2 |
688 | 2020-10-23 08:56:44 | ghi | 1 | 5146 | 7 | 0.076 | 67710.5 |