History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"effs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
977 | 2024-04-25 12:47:57 | effs | 1 | 13983 | 6 | 0.250 | 55932.0 |
976 | 2024-04-25 02:31:22 | effs | 1 | 13983 | 6 | 0.546 | 25609.9 |
975 | 2024-04-22 22:44:56 | effs | 1 | 13983 | 6 | 0.216 | 64736.1 |
974 | 2024-04-22 22:41:41 | effs | 1 | 13983 | 6 | 0.210 | 66585.7 |
973 | 2024-04-22 22:31:09 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
972 | 2024-04-17 23:33:01 | effs | 1 | 13983 | 6 | 0.703 | 19890.5 |
971 | 2024-04-05 01:17:12 | effs | 1 | 13983 | 6 | 0.266 | 52567.7 |
970 | 2024-03-29 21:20:07 | effs | 2 | 29872 | 121 | 1.936 | 15429.8 |
969 | 2024-03-29 21:19:43 | effs | 1 | 13983 | 6 | 0.513 | 27257.3 |
968 | 2024-03-18 09:15:03 | effs | 2 | 29872 | 121 | 1.860 | 16060.2 |
967 | 2024-03-18 09:14:57 | effs | 1 | 13983 | 6 | 0.250 | 55932.0 |
966 | 2024-03-05 21:00:20 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
965 | 2024-02-28 20:00:06 | effs | 1 | 13983 | 6 | 0.236 | 59250.0 |
964 | 2024-02-21 04:02:09 | effs | 1 | 13983 | 6 | 0.263 | 53167.3 |
963 | 2024-02-14 19:13:54 | effs | 2 | 29872 | 121 | 0.860 | 34734.9 |
962 | 2024-02-14 19:13:49 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
961 | 2024-02-05 04:08:48 | effs | 1 | 13983 | 6 | 0.486 | 28771.6 |
960 | 2024-02-03 03:54:06 | effs | 1 | 13983 | 6 | 0.250 | 55932.0 |
959 | 2024-01-29 03:38:57 | effs | 1 | 13983 | 6 | 0.220 | 63559.1 |
958 | 2024-01-15 11:39:28 | effs | 1 | 13983 | 6 | 0.266 | 52567.7 |
957 | 2024-01-14 07:17:20 | effs | 2 | 29872 | 121 | 0.783 | 38150.7 |
956 | 2023-12-18 06:42:14 | effs | 2 | 29872 | 121 | 0.843 | 35435.3 |
955 | 2023-11-27 20:51:53 | effs | 1 | 13983 | 6 | 0.236 | 59250.0 |
954 | 2023-11-27 07:52:26 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
953 | 2023-11-23 14:59:22 | effs | 1 | 13983 | 6 | 0.216 | 64736.1 |
952 | 2023-11-18 18:33:07 | effs | 2 | 29872 | 121 | 0.736 | 40587.0 |
951 | 2023-11-15 21:22:22 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
950 | 2023-11-11 21:06:14 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
949 | 2023-11-02 06:38:20 | effs | 1 | 13983 | 6 | 0.216 | 64736.1 |
948 | 2023-11-02 04:40:03 | effs | 2 | 29872 | 121 | 0.813 | 36742.9 |
947 | 2023-10-31 00:30:04 | effs | 1 | 13983 | 6 | 0.250 | 55932.0 |
946 | 2023-10-24 11:49:53 | effs | 2 | 29872 | 121 | 0.813 | 36742.9 |
945 | 2023-10-21 13:41:37 | effs | 1 | 13983 | 6 | 0.236 | 59250.0 |
944 | 2023-10-18 12:06:09 | effs | 1 | 13983 | 6 | 0.250 | 55932.0 |
943 | 2023-10-11 05:29:34 | effs | 1 | 13983 | 6 | 0.220 | 63559.1 |
942 | 2023-10-05 00:59:40 | effs | 1 | 13983 | 6 | 0.236 | 59250.0 |
941 | 2023-09-26 19:36:21 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
940 | 2023-09-26 14:26:36 | effs | 1 | 13983 | 6 | 0.236 | 59250.0 |
939 | 2023-09-13 03:29:46 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
938 | 2023-08-08 23:11:56 | effs | 2 | 29872 | 121 | 0.736 | 40587.0 |
937 | 2023-08-02 17:50:43 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
936 | 2023-07-29 14:45:13 | effs | 1 | 13983 | 6 | 0.203 | 68881.8 |
935 | 2023-06-20 01:48:20 | effs | 1 | 13983 | 6 | 0.220 | 63559.1 |
934 | 2023-04-28 15:31:51 | effs | 1 | 13983 | 6 | 0.203 | 68881.8 |
933 | 2023-04-10 00:54:08 | effs | 2 | 29872 | 121 | 0.843 | 35435.3 |
932 | 2023-04-03 13:42:47 | effs | 1 | 13983 | 6 | 0.203 | 68881.8 |
931 | 2023-01-26 15:56:13 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
930 | 2023-01-24 00:47:21 | effs | 2 | 29872 | 121 | 0.826 | 36164.6 |
929 | 2023-01-23 19:33:44 | effs | 1 | 13983 | 6 | 0.233 | 60012.9 |
928 | 2023-01-21 11:45:50 | effs | 2 | 29872 | 121 | 0.720 | 41488.9 |
927 | 2023-01-19 09:07:55 | effs | 2 | 29872 | 121 | 0.876 | 34100.5 |
926 | 2023-01-17 11:53:18 | effs | 1 | 13983 | 6 | 0.203 | 68881.8 |
925 | 2023-01-15 07:45:57 | effs | 2 | 29872 | 121 | 0.796 | 37527.6 |
924 | 2023-01-15 02:25:04 | effs | 2 | 29872 | 121 | 0.813 | 36742.9 |
923 | 2023-01-12 02:42:57 | effs | 2 | 29872 | 121 | 0.846 | 35309.7 |
922 | 2023-01-11 15:36:47 | effs | 2 | 29872 | 121 | 0.716 | 41720.7 |
921 | 2023-01-10 01:04:17 | effs | 2 | 29872 | 121 | 0.810 | 36879.0 |
920 | 2023-01-07 12:08:48 | effs | 2 | 29872 | 121 | 0.813 | 36742.9 |
919 | 2023-01-04 23:32:23 | effs | 2 | 29872 | 121 | 0.720 | 41488.9 |
918 | 2022-11-07 04:54:53 | effs | 1 | 13983 | 6 | 0.203 | 68881.8 |
917 | 2022-10-18 00:52:19 | effs | 2 | 29872 | 121 | 0.720 | 41488.9 |
916 | 2022-10-02 07:47:33 | effs | 1 | 13983 | 6 | 0.220 | 63559.1 |
915 | 2022-08-08 23:38:18 | effs | 2 | 29872 | 121 | 0.843 | 35435.3 |
914 | 2022-06-27 13:21:12 | effs | 1 | 13983 | 6 | 0.220 | 63559.1 |
913 | 2022-06-11 16:40:06 | effs | 1 | 13983 | 6 | 0.216 | 64736.1 |
912 | 2022-06-03 15:19:26 | effs | 2 | 29872 | 121 | 0.716 | 41720.7 |
911 | 2022-05-19 19:45:23 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
910 | 2022-05-06 22:30:15 | effs | 2 | 29872 | 121 | 0.860 | 34734.9 |
909 | 2022-05-06 10:19:05 | effs | 2 | 29872 | 121 | 0.763 | 39150.7 |
908 | 2022-05-05 18:05:42 | effs | 2 | 29872 | 121 | 0.826 | 36164.6 |
907 | 2022-05-05 12:53:41 | effs | 2 | 29872 | 121 | 0.860 | 34734.9 |
906 | 2022-05-05 03:18:37 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
905 | 2022-05-04 18:53:28 | effs | 2 | 29872 | 121 | 0.906 | 32971.3 |
904 | 2022-05-04 07:06:23 | effs | 2 | 29872 | 121 | 0.766 | 38997.4 |
903 | 2022-05-03 21:57:23 | effs | 2 | 29872 | 121 | 0.906 | 32971.3 |
902 | 2022-05-03 08:56:14 | effs | 2 | 29872 | 121 | 0.873 | 34217.6 |
901 | 2022-05-03 05:33:13 | effs | 2 | 29872 | 121 | 0.733 | 40753.1 |
900 | 2022-05-02 20:52:34 | effs | 2 | 29872 | 121 | 0.826 | 36164.6 |
899 | 2022-05-01 14:07:12 | effs | 2 | 29872 | 121 | 0.813 | 36742.9 |
898 | 2022-04-30 22:39:34 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
897 | 2022-04-30 22:27:41 | effs | 2 | 29872 | 121 | 0.733 | 40753.1 |
896 | 2022-04-30 05:33:56 | effs | 2 | 29872 | 121 | 0.876 | 34100.5 |
895 | 2022-04-29 10:33:07 | effs | 2 | 29872 | 121 | 1.110 | 26911.7 |
894 | 2022-04-28 22:48:19 | effs | 2 | 29872 | 121 | 0.983 | 30388.6 |
893 | 2022-04-27 21:49:51 | effs | 2 | 29872 | 121 | 0.890 | 33564.0 |
892 | 2022-04-27 09:38:22 | effs | 2 | 29872 | 121 | 0.936 | 31914.5 |
891 | 2022-04-26 18:47:59 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
890 | 2022-04-26 07:23:12 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
889 | 2022-04-25 20:57:54 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
888 | 2022-04-25 09:55:01 | effs | 2 | 29872 | 121 | 0.876 | 34100.5 |
887 | 2022-04-24 17:35:07 | effs | 2 | 29872 | 121 | 0.733 | 40753.1 |
886 | 2022-04-23 19:10:57 | effs | 2 | 29872 | 121 | 0.846 | 35309.7 |
885 | 2022-04-22 23:57:27 | effs | 2 | 29872 | 121 | 1.080 | 27659.3 |
884 | 2022-04-22 05:21:30 | effs | 2 | 29872 | 121 | 0.876 | 34100.5 |
883 | 2022-04-21 15:36:41 | effs | 2 | 29872 | 121 | 1.063 | 28101.6 |
882 | 2022-04-21 03:45:43 | effs | 2 | 29872 | 121 | 0.736 | 40587.0 |
881 | 2022-04-20 10:10:23 | effs | 2 | 29872 | 121 | 0.983 | 30388.6 |
880 | 2022-04-19 21:11:16 | effs | 2 | 29872 | 121 | 0.970 | 30795.9 |
879 | 2022-04-19 07:49:08 | effs | 2 | 29872 | 121 | 0.750 | 39829.3 |
878 | 2022-04-18 19:37:23 | effs | 2 | 29872 | 121 | 0.903 | 33080.8 |