History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gnat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
815 | 2024-04-19 20:31:21 | gnat | 1 | 13983 | 8 | 0.626 | 22337.1 |
814 | 2024-04-17 16:30:16 | gnat | 1 | 13983 | 8 | 0.436 | 32071.1 |
813 | 2024-04-17 16:29:41 | gnat | 1 | 13983 | 8 | 0.343 | 40766.8 |
812 | 2024-04-04 19:32:58 | gnat | 1 | 13983 | 8 | 0.516 | 27098.8 |
811 | 2024-04-03 00:25:58 | gnat | 1 | 13983 | 8 | 0.266 | 52567.7 |
810 | 2024-03-30 19:39:27 | gnat | 2 | 29872 | 175 | 1.953 | 15295.4 |
809 | 2024-03-30 18:52:10 | gnat | 1 | 13983 | 8 | 0.263 | 53167.3 |
808 | 2024-03-29 07:25:08 | gnat | 2 | 29872 | 175 | 1.186 | 25187.2 |
807 | 2024-03-28 19:50:23 | gnat | 2 | 29872 | 175 | 1.046 | 28558.3 |
806 | 2024-03-28 19:25:33 | gnat | 1 | 13983 | 8 | 0.513 | 27257.3 |
805 | 2024-03-28 11:40:13 | gnat | 1 | 13983 | 8 | 0.250 | 55932.0 |
804 | 2024-03-05 17:32:41 | gnat | 1 | 13983 | 8 | 0.546 | 25609.9 |
803 | 2024-03-03 19:48:56 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
802 | 2024-02-26 22:44:02 | gnat | 2 | 29872 | 175 | 1.783 | 16753.8 |
801 | 2024-02-26 19:36:45 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
800 | 2024-02-02 15:09:47 | gnat | 1 | 13983 | 8 | 0.236 | 59250.0 |
799 | 2024-01-27 15:58:13 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
798 | 2024-01-24 01:20:58 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
797 | 2024-01-04 08:38:23 | gnat | 2 | 29872 | 175 | 0.720 | 41488.9 |
796 | 2023-12-30 22:45:29 | gnat | 1 | 13983 | 8 | 0.250 | 55932.0 |
795 | 2023-12-22 13:22:39 | gnat | 2 | 29872 | 175 | 0.826 | 36164.6 |
794 | 2023-11-23 20:06:08 | gnat | 1 | 13983 | 8 | 0.236 | 59250.0 |
793 | 2023-11-22 03:59:07 | gnat | 2 | 29872 | 175 | 0.860 | 34734.9 |
792 | 2023-11-19 18:42:10 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
791 | 2023-11-14 21:36:41 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
790 | 2023-11-12 02:59:25 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
789 | 2023-11-06 13:01:25 | gnat | 1 | 13983 | 8 | 0.486 | 28771.6 |
788 | 2023-11-03 19:31:53 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
787 | 2023-11-03 08:01:14 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
786 | 2023-11-02 03:37:27 | gnat | 2 | 29872 | 175 | 0.720 | 41488.9 |
785 | 2023-11-02 02:12:54 | gnat | 1 | 13983 | 8 | 0.250 | 55932.0 |
784 | 2023-10-31 06:58:34 | gnat | 2 | 29872 | 175 | 0.813 | 36742.9 |
783 | 2023-10-25 23:56:46 | gnat | 1 | 13983 | 8 | 0.486 | 28771.6 |
782 | 2023-10-21 19:27:15 | gnat | 1 | 13983 | 8 | 0.250 | 55932.0 |
781 | 2023-10-17 17:14:00 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
780 | 2023-10-12 08:37:29 | gnat | 1 | 13983 | 8 | 0.406 | 34440.9 |
779 | 2023-10-05 04:41:33 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
778 | 2023-09-26 03:03:09 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
777 | 2023-09-25 01:56:30 | gnat | 1 | 13983 | 8 | 0.216 | 64736.1 |
776 | 2023-09-19 03:06:59 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
775 | 2023-09-17 08:58:02 | gnat | 1 | 13983 | 8 | 0.206 | 67878.6 |
774 | 2023-09-15 08:03:11 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
773 | 2023-09-13 17:03:47 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
772 | 2023-09-12 18:50:53 | gnat | 1 | 13983 | 8 | 0.236 | 59250.0 |
771 | 2023-09-10 23:09:18 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
770 | 2023-09-06 05:23:34 | gnat | 1 | 13983 | 8 | 0.216 | 64736.1 |
769 | 2023-09-05 02:06:24 | gnat | 1 | 13983 | 8 | 0.216 | 64736.1 |
768 | 2023-08-30 05:46:35 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
767 | 2023-08-29 06:43:21 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
766 | 2023-08-05 02:16:33 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
765 | 2023-08-03 02:11:40 | gnat | 1 | 13983 | 8 | 0.216 | 64736.1 |
764 | 2023-07-18 23:29:08 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
763 | 2023-07-18 08:15:04 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
762 | 2023-07-17 01:15:47 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
761 | 2023-07-15 23:38:36 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
760 | 2023-07-15 00:49:21 | gnat | 1 | 13983 | 8 | 0.263 | 53167.3 |
759 | 2023-07-14 01:08:48 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
758 | 2023-07-13 00:45:35 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
757 | 2023-07-12 18:02:34 | gnat | 1 | 13983 | 8 | 0.216 | 64736.1 |
756 | 2023-07-11 13:26:09 | gnat | 1 | 13983 | 8 | 0.266 | 52567.7 |
755 | 2023-07-10 03:57:09 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
754 | 2023-06-09 04:58:18 | gnat | 1 | 13983 | 8 | 0.200 | 69915.0 |
753 | 2023-04-23 23:57:21 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
752 | 2023-04-22 07:37:28 | gnat | 1 | 13983 | 8 | 0.236 | 59250.0 |
751 | 2023-04-21 08:45:53 | gnat | 1 | 13983 | 8 | 0.250 | 55932.0 |
750 | 2023-04-20 07:29:16 | gnat | 1 | 13983 | 8 | 0.500 | 27966.0 |
749 | 2023-04-19 20:30:45 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
748 | 2023-04-19 00:23:17 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
747 | 2023-04-07 11:52:52 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
746 | 2023-04-03 18:26:50 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
745 | 2023-03-28 11:18:57 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
744 | 2023-01-11 12:13:27 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
743 | 2022-12-25 20:07:55 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
742 | 2022-12-06 15:34:04 | gnat | 2 | 29872 | 175 | 0.703 | 42492.2 |
741 | 2022-10-18 23:57:38 | gnat | 1 | 13983 | 8 | 0.200 | 69915.0 |
740 | 2022-09-12 04:01:23 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
739 | 2022-09-11 12:47:40 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
738 | 2022-08-14 23:45:04 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
737 | 2022-08-06 21:21:39 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
736 | 2022-07-29 07:54:43 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
735 | 2022-07-17 21:38:31 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
734 | 2022-07-17 17:18:41 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
733 | 2022-06-10 11:19:58 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
732 | 2022-06-08 07:04:33 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
731 | 2022-06-02 00:49:53 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
730 | 2022-05-29 20:25:17 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
729 | 2022-04-11 12:01:15 | gnat | 2 | 29872 | 175 | 0.810 | 36879.0 |
728 | 2022-02-25 10:41:50 | gnat | 1 | 13983 | 8 | 0.263 | 53167.3 |
727 | 2022-02-18 01:17:25 | gnat | 1 | 13983 | 8 | 0.236 | 59250.0 |
726 | 2021-12-07 07:54:15 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
725 | 2021-11-28 08:11:35 | gnat | 1 | 13983 | 8 | 0.346 | 40413.3 |
724 | 2021-11-27 05:21:44 | gnat | 1 | 13983 | 8 | 0.250 | 55932.0 |
723 | 2021-11-20 14:16:41 | gnat | 1 | 13983 | 8 | 0.236 | 59250.0 |
722 | 2021-11-15 22:21:46 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
721 | 2021-10-22 21:58:49 | gnat | 1 | 13983 | 8 | 0.250 | 55932.0 |
720 | 2021-10-20 20:36:13 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |
719 | 2021-09-06 10:58:14 | gnat | 1 | 13983 | 8 | 0.220 | 63559.1 |
718 | 2021-09-04 06:33:42 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
717 | 2021-08-21 00:19:01 | gnat | 1 | 13983 | 8 | 0.203 | 68881.8 |
716 | 2021-08-19 20:41:03 | gnat | 1 | 13983 | 8 | 0.233 | 60012.9 |