History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"anna"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
915 | 2024-04-05 10:34:59 | anna | 1 | 13983 | 11 | 0.810 | 17263.0 |
914 | 2024-04-04 22:41:09 | anna | 1 | 13983 | 11 | 0.686 | 20383.4 |
913 | 2024-04-02 18:23:56 | anna | 1 | 13983 | 11 | 0.266 | 52567.7 |
912 | 2024-04-01 14:23:00 | anna | 1 | 13983 | 11 | 0.296 | 47239.9 |
911 | 2024-04-01 06:29:38 | anna | 1 | 13983 | 11 | 0.263 | 53167.3 |
910 | 2024-03-30 20:36:03 | anna | 1 | 13983 | 11 | 0.310 | 45106.5 |
909 | 2024-03-29 10:17:02 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
908 | 2024-03-27 04:36:49 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
907 | 2024-03-05 20:07:28 | anna | 1 | 13983 | 11 | 0.953 | 14672.6 |
906 | 2024-03-03 20:15:45 | anna | 2 | 29872 | 150 | 0.860 | 34734.9 |
905 | 2024-03-02 18:16:04 | anna | 2 | 29872 | 150 | 2.546 | 11732.9 |
904 | 2024-03-02 17:31:00 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
903 | 2024-02-25 17:07:37 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
902 | 2024-02-12 18:36:07 | anna | 2 | 29872 | 150 | 0.876 | 34100.5 |
901 | 2024-02-05 08:48:13 | anna | 2 | 29872 | 150 | 1.033 | 28917.7 |
900 | 2024-02-03 01:05:34 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
899 | 2023-12-27 08:27:52 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
898 | 2023-12-25 06:08:38 | anna | 1 | 13983 | 11 | 0.483 | 28950.3 |
897 | 2023-12-25 01:23:25 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
896 | 2023-12-24 03:46:52 | anna | 1 | 13983 | 11 | 0.236 | 59250.0 |
895 | 2023-12-07 22:16:56 | anna | 1 | 13983 | 11 | 0.500 | 27966.0 |
894 | 2023-12-07 22:16:55 | anna | 1 | 13983 | 11 | 0.500 | 27966.0 |
893 | 2023-12-03 03:39:37 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
892 | 2023-12-03 03:39:36 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
891 | 2023-11-25 18:46:31 | anna | 2 | 29872 | 150 | 0.953 | 31345.2 |
890 | 2023-11-14 22:51:05 | anna | 2 | 29872 | 150 | 0.780 | 38297.4 |
889 | 2023-11-11 23:22:34 | anna | 2 | 29872 | 150 | 0.780 | 38297.4 |
888 | 2023-11-09 14:31:43 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
887 | 2023-11-08 14:15:27 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
886 | 2023-11-07 11:25:50 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
885 | 2023-11-03 18:37:03 | anna | 2 | 29872 | 150 | 0.796 | 37527.6 |
884 | 2023-10-26 04:52:58 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
883 | 2023-10-24 10:58:48 | anna | 1 | 13983 | 11 | 0.266 | 52567.7 |
882 | 2023-10-20 04:48:32 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
881 | 2023-10-17 03:52:20 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
880 | 2023-10-12 21:02:57 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
879 | 2023-10-12 02:23:05 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
878 | 2023-10-11 11:38:39 | anna | 2 | 29872 | 150 | 0.783 | 38150.7 |
877 | 2023-10-10 10:32:35 | anna | 1 | 13983 | 11 | 0.266 | 52567.7 |
876 | 2023-10-03 20:29:34 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
875 | 2023-09-22 16:58:31 | anna | 1 | 13983 | 11 | 0.266 | 52567.7 |
874 | 2023-09-11 04:39:39 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
873 | 2023-09-07 16:13:33 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
872 | 2023-08-14 12:26:56 | anna | 2 | 29872 | 150 | 0.783 | 38150.7 |
871 | 2023-08-08 07:28:06 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
870 | 2023-07-17 10:59:02 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
869 | 2023-06-30 18:45:27 | anna | 2 | 29872 | 150 | 0.783 | 38150.7 |
868 | 2023-06-16 04:55:37 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
867 | 2023-06-03 22:04:15 | anna | 1 | 13983 | 11 | 0.266 | 52567.7 |
866 | 2023-05-22 15:11:39 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
865 | 2023-05-07 17:34:33 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
864 | 2023-04-28 00:31:52 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
863 | 2023-04-26 11:38:07 | anna | 2 | 29872 | 150 | 0.920 | 32469.6 |
862 | 2023-04-02 08:28:19 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
861 | 2023-03-23 02:56:51 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
860 | 2023-03-06 00:20:40 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
859 | 2023-03-02 23:43:02 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
858 | 2023-03-01 06:50:44 | anna | 1 | 13983 | 11 | 0.236 | 59250.0 |
857 | 2023-02-07 04:49:55 | anna | 1 | 13983 | 11 | 0.236 | 59250.0 |
856 | 2023-01-28 17:02:45 | anna | 2 | 29872 | 150 | 0.763 | 39150.7 |
855 | 2023-01-13 20:26:58 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
854 | 2022-12-27 07:59:04 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
853 | 2022-12-21 18:45:55 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
852 | 2022-11-29 18:19:21 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
851 | 2022-11-26 12:15:35 | anna | 1 | 13983 | 11 | 0.436 | 32071.1 |
850 | 2022-11-26 10:56:15 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
849 | 2022-11-10 17:05:09 | anna | 2 | 29872 | 150 | 0.953 | 31345.2 |
848 | 2022-11-04 20:06:45 | anna | 1 | 13983 | 11 | 0.263 | 53167.3 |
847 | 2022-10-13 10:50:57 | anna | 1 | 13983 | 11 | 0.203 | 68881.8 |
846 | 2022-09-21 02:01:53 | anna | 1 | 13983 | 11 | 0.236 | 59250.0 |
845 | 2022-09-15 19:03:24 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
844 | 2022-09-10 14:18:34 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
843 | 2022-08-31 08:57:30 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
842 | 2022-08-19 05:23:03 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
841 | 2022-08-05 12:28:03 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
840 | 2022-07-18 21:01:53 | anna | 1 | 13983 | 11 | 0.236 | 59250.0 |
839 | 2022-07-10 15:15:18 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
838 | 2022-06-15 20:37:33 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
837 | 2022-06-12 10:13:36 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
836 | 2022-06-10 21:11:01 | anna | 2 | 29872 | 150 | 0.813 | 36742.9 |
835 | 2022-06-07 02:48:10 | anna | 1 | 13983 | 11 | 0.236 | 59250.0 |
834 | 2022-05-23 04:53:33 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
833 | 2022-05-10 07:34:46 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
832 | 2022-04-28 16:29:07 | anna | 1 | 13983 | 11 | 0.296 | 47239.9 |
831 | 2022-04-04 10:41:43 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
830 | 2022-03-14 03:50:08 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
829 | 2022-03-11 23:19:18 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
828 | 2022-02-05 09:20:21 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
827 | 2022-01-01 22:52:05 | anna | 1 | 13983 | 11 | 0.263 | 53167.3 |
826 | 2021-11-30 01:32:42 | anna | 1 | 13983 | 11 | 0.263 | 53167.3 |
825 | 2021-11-11 02:13:24 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
824 | 2021-11-04 15:13:02 | anna | 1 | 13983 | 11 | 0.216 | 64736.1 |
823 | 2021-10-21 18:19:39 | anna | 1 | 13983 | 11 | 0.236 | 59250.0 |
822 | 2021-10-21 17:50:54 | anna | 1 | 13983 | 11 | 0.250 | 55932.0 |
821 | 2021-10-08 18:45:14 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
820 | 2021-09-04 12:51:39 | anna | 1 | 13983 | 11 | 0.233 | 60012.9 |
819 | 2021-08-20 03:06:01 | anna | 1 | 13983 | 11 | 0.373 | 37487.9 |
818 | 2021-08-12 17:20:31 | anna | 1 | 13983 | 11 | 0.266 | 52567.7 |
817 | 2021-08-01 10:01:57 | anna | 1 | 13983 | 11 | 0.220 | 63559.1 |
816 | 2021-07-11 10:58:51 | anna | 2 | 29872 | 150 | 0.893 | 33451.3 |