History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stem"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
902 | 2024-04-25 09:11:28 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
901 | 2024-04-13 07:25:44 | stem | 2 | 29872 | 180 | 0.876 | 34100.5 |
900 | 2024-04-05 20:38:40 | stem | 1 | 13983 | 11 | 0.343 | 40766.8 |
899 | 2024-04-05 12:47:23 | stem | 1 | 13983 | 11 | 0.296 | 47239.9 |
898 | 2024-04-04 19:30:28 | stem | 1 | 13983 | 11 | 0.313 | 44674.1 |
897 | 2024-04-03 01:02:42 | stem | 2 | 29872 | 180 | 1.640 | 18214.6 |
896 | 2024-04-03 00:59:15 | stem | 1 | 13983 | 11 | 0.576 | 24276.0 |
895 | 2024-03-31 03:19:32 | stem | 1 | 13983 | 11 | 0.266 | 52567.7 |
894 | 2024-03-26 21:02:52 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
893 | 2024-03-09 01:32:05 | stem | 1 | 13983 | 11 | 0.280 | 49939.3 |
892 | 2024-03-05 17:42:08 | stem | 1 | 13983 | 11 | 0.810 | 17263.0 |
891 | 2024-03-03 19:48:09 | stem | 1 | 13983 | 11 | 0.203 | 68881.8 |
890 | 2024-02-29 23:09:28 | stem | 1 | 13983 | 11 | 0.283 | 49409.9 |
889 | 2024-02-25 16:36:30 | stem | 1 | 13983 | 11 | 0.216 | 64736.1 |
888 | 2024-02-03 00:31:49 | stem | 1 | 13983 | 11 | 0.500 | 27966.0 |
887 | 2024-01-28 15:16:44 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
886 | 2024-01-26 12:13:13 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
885 | 2024-01-23 18:54:57 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
884 | 2024-01-02 08:08:23 | stem | 1 | 13983 | 11 | 0.563 | 24836.6 |
883 | 2023-12-25 07:58:52 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
882 | 2023-12-18 12:43:24 | stem | 2 | 29872 | 180 | 0.750 | 39829.3 |
881 | 2023-12-11 23:59:17 | stem | 2 | 29872 | 180 | 0.923 | 32364.0 |
880 | 2023-12-03 19:48:54 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
879 | 2023-12-03 19:48:53 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
878 | 2023-11-25 03:27:10 | stem | 2 | 29872 | 180 | 2.093 | 14272.3 |
877 | 2023-11-18 10:31:14 | stem | 2 | 29872 | 180 | 0.983 | 30388.6 |
876 | 2023-11-11 21:44:43 | stem | 1 | 13983 | 11 | 0.236 | 59250.0 |
875 | 2023-11-09 00:24:32 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
874 | 2023-11-05 17:58:06 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
873 | 2023-11-02 08:41:04 | stem | 2 | 29872 | 180 | 0.876 | 34100.5 |
872 | 2023-10-30 14:19:54 | stem | 2 | 29872 | 180 | 0.783 | 38150.7 |
871 | 2023-10-25 23:16:26 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
870 | 2023-10-22 00:06:13 | stem | 1 | 13983 | 11 | 0.563 | 24836.6 |
869 | 2023-10-17 23:44:15 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
868 | 2023-10-12 19:23:02 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
867 | 2023-10-12 04:31:58 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
866 | 2023-10-05 02:30:34 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
865 | 2023-09-29 03:31:35 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
864 | 2023-09-12 15:39:36 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
863 | 2023-09-11 04:24:53 | stem | 2 | 29872 | 180 | 0.750 | 39829.3 |
862 | 2023-09-09 00:00:43 | stem | 2 | 29872 | 180 | 0.750 | 39829.3 |
861 | 2023-08-27 17:55:48 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
860 | 2023-08-07 00:20:08 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
859 | 2023-05-28 07:21:26 | stem | 2 | 29872 | 180 | 0.860 | 34734.9 |
858 | 2023-05-25 17:18:23 | stem | 2 | 29872 | 180 | 0.733 | 40753.1 |
857 | 2023-05-07 11:17:43 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
856 | 2023-04-25 20:34:43 | stem | 1 | 13983 | 11 | 0.486 | 28771.6 |
855 | 2023-03-06 21:07:49 | stem | 2 | 29872 | 180 | 0.733 | 40753.1 |
854 | 2023-02-28 18:36:40 | stem | 1 | 13983 | 11 | 0.203 | 68881.8 |
853 | 2022-12-26 20:58:05 | stem | 1 | 13983 | 11 | 0.203 | 68881.8 |
852 | 2022-12-25 20:45:19 | stem | 1 | 13983 | 11 | 0.236 | 59250.0 |
851 | 2022-12-13 11:18:55 | stem | 2 | 29872 | 180 | 0.750 | 39829.3 |
850 | 2022-09-13 10:32:34 | stem | 1 | 13983 | 11 | 0.236 | 59250.0 |
849 | 2022-09-10 15:38:47 | stem | 1 | 13983 | 11 | 0.216 | 64736.1 |
848 | 2022-09-03 13:17:58 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
847 | 2022-09-01 00:40:26 | stem | 2 | 29872 | 180 | 0.750 | 39829.3 |
846 | 2022-08-22 00:40:22 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
845 | 2022-08-15 17:29:38 | stem | 2 | 29872 | 180 | 0.860 | 34734.9 |
844 | 2022-08-14 07:45:56 | stem | 1 | 13983 | 11 | 0.203 | 68881.8 |
843 | 2022-08-10 14:51:16 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
842 | 2022-08-06 00:12:58 | stem | 1 | 13983 | 11 | 0.216 | 64736.1 |
841 | 2022-08-02 23:24:02 | stem | 1 | 13983 | 11 | 0.216 | 64736.1 |
840 | 2022-07-31 23:16:16 | stem | 2 | 29872 | 180 | 0.766 | 38997.4 |
839 | 2022-07-30 07:00:28 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
838 | 2022-07-29 03:14:38 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
837 | 2022-07-19 09:17:09 | stem | 2 | 29872 | 180 | 0.736 | 40587.0 |
836 | 2022-07-16 18:48:57 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
835 | 2022-07-02 23:57:12 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
834 | 2022-04-14 12:56:27 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
833 | 2022-04-10 23:42:08 | stem | 1 | 13983 | 11 | 0.203 | 68881.8 |
832 | 2022-03-16 12:56:42 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
831 | 2022-03-14 08:55:30 | stem | 1 | 13983 | 11 | 0.376 | 37188.8 |
830 | 2021-12-22 12:48:38 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
829 | 2021-12-20 08:49:30 | stem | 1 | 13983 | 11 | 0.266 | 52567.7 |
828 | 2021-10-29 12:22:31 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
827 | 2021-09-20 00:27:35 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
826 | 2021-09-03 09:23:44 | stem | 1 | 13983 | 11 | 0.236 | 59250.0 |
825 | 2021-08-18 03:52:26 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
824 | 2021-08-16 00:07:05 | stem | 1 | 13983 | 11 | 0.203 | 68881.8 |
823 | 2021-06-02 12:28:39 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
822 | 2021-05-31 17:42:58 | stem | 1 | 13983 | 11 | 0.266 | 52567.7 |
821 | 2021-05-18 08:40:36 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
820 | 2021-05-15 05:11:24 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
819 | 2021-05-06 11:11:15 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
818 | 2021-04-18 08:43:57 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
817 | 2021-03-28 04:48:04 | stem | 2 | 29872 | 180 | 0.750 | 39829.3 |
816 | 2021-02-27 20:30:37 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
815 | 2021-02-20 22:41:51 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
814 | 2021-01-30 09:57:56 | stem | 1 | 13983 | 11 | 0.250 | 55932.0 |
813 | 2021-01-11 11:57:38 | stem | 2 | 29872 | 180 | 0.750 | 39829.3 |
812 | 2020-11-18 13:19:59 | stem | 1 | 13983 | 11 | 0.233 | 60012.9 |
811 | 2020-10-28 12:37:22 | stem | 1 | 13983 | 11 | 0.263 | 53167.3 |
810 | 2020-10-26 22:56:53 | stem | 1 | 13983 | 11 | 0.216 | 64736.1 |
809 | 2020-10-24 07:12:04 | stem | 2 | 29872 | 180 | 0.753 | 39670.7 |
808 | 2020-10-18 03:39:41 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
807 | 2020-10-17 21:54:12 | stem | 1 | 13983 | 11 | 0.216 | 64736.1 |
806 | 2020-10-15 21:48:38 | stem | 1 | 13983 | 11 | 0.216 | 64736.1 |
805 | 2020-10-02 04:08:48 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
804 | 2020-08-22 14:42:45 | stem | 1 | 13983 | 11 | 0.220 | 63559.1 |
803 | 2020-08-14 06:22:40 | stem | 1 | 13983 | 11 | 0.236 | 59250.0 |