History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"acts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
956 | 2024-04-26 12:10:16 | acts | 2 | 29872 | 306 | 0.953 | 31345.2 |
955 | 2024-04-04 22:40:11 | acts | 1 | 13983 | 12 | 0.296 | 47239.9 |
954 | 2024-03-30 20:40:20 | acts | 2 | 29872 | 306 | 3.203 | 9326.3 |
953 | 2024-03-30 20:36:32 | acts | 1 | 13983 | 12 | 0.266 | 52567.7 |
952 | 2024-03-05 20:56:13 | acts | 2 | 29872 | 306 | 1.030 | 29001.9 |
951 | 2024-03-05 19:56:56 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
950 | 2024-03-02 18:06:22 | acts | 2 | 29872 | 306 | 3.060 | 9762.1 |
949 | 2024-03-02 17:44:05 | acts | 1 | 13983 | 12 | 0.266 | 52567.7 |
948 | 2024-02-26 20:57:40 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
947 | 2024-02-23 20:55:15 | acts | 2 | 29872 | 306 | 0.906 | 32971.3 |
946 | 2024-02-10 08:46:42 | acts | 2 | 29872 | 306 | 1.046 | 28558.3 |
945 | 2024-02-03 02:44:11 | acts | 1 | 13983 | 12 | 0.560 | 24969.6 |
944 | 2024-01-24 17:38:59 | acts | 1 | 13983 | 12 | 0.266 | 52567.7 |
943 | 2024-01-23 19:16:30 | acts | 1 | 13983 | 12 | 0.263 | 53167.3 |
942 | 2023-12-21 10:20:18 | acts | 2 | 29872 | 306 | 0.783 | 38150.7 |
941 | 2023-12-15 22:58:13 | acts | 1 | 13983 | 12 | 0.283 | 49409.9 |
940 | 2023-12-11 17:57:59 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
939 | 2023-12-08 06:31:09 | acts | 1 | 13983 | 12 | 0.266 | 52567.7 |
938 | 2023-12-08 06:31:08 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
937 | 2023-11-25 17:31:25 | acts | 2 | 29872 | 306 | 0.920 | 32469.6 |
936 | 2023-11-18 07:12:19 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
935 | 2023-11-12 00:46:33 | acts | 2 | 29872 | 306 | 0.920 | 32469.6 |
934 | 2023-11-11 21:04:56 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
933 | 2023-11-09 18:09:26 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
932 | 2023-11-07 13:22:01 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
931 | 2023-11-07 08:06:51 | acts | 1 | 13983 | 12 | 0.500 | 27966.0 |
930 | 2023-11-02 23:49:28 | acts | 2 | 29872 | 306 | 0.763 | 39150.7 |
929 | 2023-11-01 18:07:26 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
928 | 2023-11-01 00:08:30 | acts | 2 | 29872 | 306 | 0.843 | 35435.3 |
927 | 2023-10-26 03:09:35 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
926 | 2023-10-20 16:32:09 | acts | 2 | 29872 | 306 | 0.783 | 38150.7 |
925 | 2023-10-19 23:59:34 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
924 | 2023-10-16 22:19:29 | acts | 1 | 13983 | 12 | 0.236 | 59250.0 |
923 | 2023-10-11 09:32:05 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
922 | 2023-10-07 09:10:26 | acts | 2 | 29872 | 306 | 0.923 | 32364.0 |
921 | 2023-10-03 11:50:31 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
920 | 2023-09-27 08:15:08 | acts | 2 | 29872 | 306 | 0.843 | 35435.3 |
919 | 2023-09-21 11:39:26 | acts | 2 | 29872 | 306 | 0.860 | 34734.9 |
918 | 2023-09-19 17:49:53 | acts | 1 | 13983 | 12 | 0.203 | 68881.8 |
917 | 2023-09-15 15:38:44 | acts | 2 | 29872 | 306 | 0.906 | 32971.3 |
916 | 2023-09-13 23:20:14 | acts | 1 | 13983 | 12 | 0.266 | 52567.7 |
915 | 2023-09-10 15:28:31 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
914 | 2023-09-05 08:13:55 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
913 | 2023-07-17 03:20:04 | acts | 1 | 13983 | 12 | 0.263 | 53167.3 |
912 | 2023-06-27 21:47:52 | acts | 2 | 29872 | 306 | 0.763 | 39150.7 |
911 | 2023-06-26 07:13:44 | acts | 2 | 29872 | 306 | 0.763 | 39150.7 |
910 | 2023-06-09 01:16:57 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
909 | 2023-04-05 16:55:50 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
908 | 2023-03-28 11:47:57 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
907 | 2023-03-27 14:05:07 | acts | 2 | 29872 | 306 | 0.860 | 34734.9 |
906 | 2023-03-26 04:48:13 | acts | 2 | 29872 | 306 | 0.813 | 36742.9 |
905 | 2023-03-23 01:49:49 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
904 | 2023-03-22 08:02:07 | acts | 2 | 29872 | 306 | 0.763 | 39150.7 |
903 | 2023-01-16 16:06:18 | acts | 2 | 29872 | 306 | 0.783 | 38150.7 |
902 | 2023-01-11 13:12:48 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
901 | 2022-12-31 11:17:21 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
900 | 2022-12-22 09:36:30 | acts | 2 | 29872 | 306 | 0.766 | 38997.4 |
899 | 2022-10-29 03:33:39 | acts | 2 | 29872 | 306 | 0.766 | 38997.4 |
898 | 2022-10-25 16:03:30 | acts | 1 | 13983 | 12 | 0.236 | 59250.0 |
897 | 2022-09-20 13:31:25 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
896 | 2022-09-17 18:53:05 | acts | 2 | 29872 | 306 | 0.783 | 38150.7 |
895 | 2022-09-08 07:11:13 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
894 | 2022-09-05 00:06:10 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
893 | 2022-08-18 20:28:10 | acts | 2 | 29872 | 306 | 0.750 | 39829.3 |
892 | 2022-06-19 14:07:55 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
891 | 2022-06-14 21:26:10 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
890 | 2022-06-03 16:26:23 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
889 | 2022-02-23 19:34:48 | acts | 1 | 13983 | 12 | 0.280 | 49939.3 |
888 | 2022-02-22 12:25:17 | acts | 1 | 13983 | 12 | 0.373 | 37487.9 |
887 | 2021-12-13 16:22:45 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
886 | 2021-11-22 07:42:19 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
885 | 2021-11-10 21:36:08 | acts | 1 | 13983 | 12 | 0.266 | 52567.7 |
884 | 2021-10-22 23:00:16 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
883 | 2021-10-05 01:00:44 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
882 | 2021-09-27 01:22:30 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
881 | 2021-09-20 20:35:46 | acts | 2 | 29872 | 306 | 0.860 | 34734.9 |
880 | 2021-09-20 20:10:54 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
879 | 2021-09-19 00:58:38 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
878 | 2021-09-11 00:59:06 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
877 | 2021-09-10 21:33:27 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
876 | 2021-09-08 16:53:49 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
875 | 2021-08-24 06:38:00 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
874 | 2021-08-19 11:04:18 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
873 | 2021-07-11 05:13:03 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
872 | 2021-05-25 18:40:55 | acts | 2 | 29872 | 306 | 0.783 | 38150.7 |
871 | 2021-05-15 22:32:13 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
870 | 2021-05-12 02:19:52 | acts | 1 | 13983 | 12 | 0.266 | 52567.7 |
869 | 2021-04-29 13:09:15 | acts | 2 | 29872 | 306 | 0.890 | 33564.0 |
868 | 2021-04-29 06:49:52 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
867 | 2021-03-28 21:56:55 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
866 | 2021-02-19 07:44:38 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
865 | 2021-02-07 17:49:27 | acts | 1 | 13983 | 12 | 0.233 | 60012.9 |
864 | 2021-02-07 00:34:24 | acts | 2 | 29872 | 306 | 0.783 | 38150.7 |
863 | 2021-02-02 18:40:20 | acts | 1 | 13983 | 12 | 0.220 | 63559.1 |
862 | 2021-01-29 13:35:14 | acts | 1 | 13983 | 12 | 0.250 | 55932.0 |
861 | 2021-01-12 18:55:17 | acts | 2 | 29872 | 306 | 0.780 | 38297.4 |
860 | 2021-01-12 15:36:04 | acts | 1 | 13983 | 12 | 0.216 | 64736.1 |
859 | 2020-11-12 09:31:34 | acts | 2 | 29872 | 306 | 0.810 | 36879.0 |
858 | 2020-11-03 04:02:49 | acts | 2 | 29872 | 306 | 0.796 | 37527.6 |
857 | 2020-10-30 10:33:21 | acts | 2 | 29872 | 306 | 0.796 | 37527.6 |