History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"apples"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
961 | 2024-05-02 19:46:38 | apples | 1 | 48755 | 7 | 1.126 | 43299.3 |
960 | 2024-04-29 18:04:23 | apples | 2 | 82551 | 72 | 2.796 | 29524.7 |
959 | 2024-04-29 18:04:18 | apples | 3 | 112716 | 923 | 6.450 | 17475.3 |
958 | 2024-04-29 18:04:20 | apples | 2 | 82551 | 72 | 2.826 | 29211.3 |
957 | 2024-04-29 18:04:07 | apples | 1 | 48755 | 7 | 0.780 | 62506.4 |
956 | 2024-04-29 18:03:38 | apples | 3 | 112716 | 923 | 5.860 | 19234.8 |
955 | 2024-04-28 00:06:29 | apples | 3 | 112716 | 923 | 15.516 | 7264.5 |
954 | 2024-04-17 14:01:59 | apples | 2 | 82551 | 72 | 2.813 | 29346.2 |
953 | 2024-04-16 17:24:48 | apples | 1 | 48755 | 7 | 1.263 | 38602.5 |
952 | 2024-04-12 22:56:51 | apples | 1 | 48755 | 7 | 0.936 | 52088.7 |
951 | 2024-04-08 06:01:42 | apples | 3 | 112716 | 923 | 9.313 | 12103.1 |
950 | 2024-04-05 06:22:52 | apples | 3 | 112716 | 923 | 5.720 | 19705.6 |
949 | 2024-04-05 06:22:53 | apples | 2 | 82551 | 72 | 2.640 | 31269.3 |
948 | 2024-04-03 11:34:13 | apples | 2 | 82551 | 72 | 8.500 | 9711.9 |
947 | 2024-04-03 11:34:14 | apples | 1 | 48755 | 7 | 1.856 | 26268.9 |
946 | 2024-04-03 07:07:10 | apples | 3 | 112716 | 923 | 10.373 | 10866.3 |
945 | 2024-04-03 06:59:51 | apples | 3 | 112716 | 923 | 8.170 | 13796.3 |
944 | 2024-03-30 20:52:37 | apples | 3 | 112716 | 923 | 13.770 | 8185.6 |
943 | 2024-03-30 00:58:23 | apples | 3 | 112716 | 923 | 14.030 | 8033.9 |
942 | 2024-03-29 03:42:17 | apples | 2 | 82551 | 72 | 3.356 | 24598.0 |
941 | 2024-03-29 02:33:06 | apples | 1 | 48755 | 7 | 0.893 | 54596.9 |
940 | 2024-03-29 02:32:58 | apples | 3 | 112716 | 923 | 6.673 | 16891.4 |
939 | 2024-03-29 02:32:59 | apples | 2 | 82551 | 72 | 2.470 | 33421.5 |
938 | 2024-03-29 02:32:55 | apples | 1 | 48755 | 7 | 0.890 | 54780.9 |
937 | 2024-03-28 23:40:46 | apples | 1 | 48755 | 7 | 2.720 | 17924.6 |
936 | 2024-02-27 21:56:52 | apples | 1 | 48755 | 7 | 1.970 | 24748.7 |
935 | 2024-02-27 21:32:01 | apples | 1 | 48755 | 7 | 0.936 | 52088.7 |
934 | 2024-02-07 17:07:31 | apples | 2 | 82551 | 72 | 2.440 | 33832.4 |
933 | 2024-02-07 17:06:55 | apples | 3 | 112716 | 923 | 7.783 | 14482.3 |
932 | 2024-02-07 09:36:37 | apples | 3 | 112716 | 923 | 5.796 | 19447.2 |
931 | 2024-02-03 04:08:22 | apples | 3 | 112716 | 923 | 5.716 | 19719.4 |
930 | 2024-01-31 10:31:52 | apples | 2 | 82551 | 72 | 2.423 | 34069.7 |
929 | 2024-01-31 10:29:44 | apples | 3 | 112716 | 923 | 8.720 | 12926.1 |
928 | 2024-01-23 16:08:16 | apples | 3 | 112716 | 923 | 22.516 | 5006.0 |
927 | 2024-01-19 23:33:53 | apples | 3 | 112716 | 923 | 5.390 | 20912.1 |
926 | 2024-01-09 20:40:20 | apples | 3 | 112716 | 923 | 5.640 | 19985.1 |
925 | 2024-01-08 21:32:34 | apples | 2 | 82551 | 72 | 4.220 | 19561.8 |
924 | 2024-01-08 21:32:28 | apples | 3 | 112716 | 923 | 8.250 | 13662.5 |
923 | 2024-01-07 04:52:20 | apples | 1 | 48755 | 7 | 0.780 | 62506.4 |
922 | 2024-01-05 17:50:03 | apples | 1 | 48755 | 7 | 0.763 | 63899.1 |
921 | 2024-01-03 00:22:50 | apples | 3 | 112716 | 923 | 5.690 | 19809.5 |
920 | 2024-01-03 00:22:51 | apples | 2 | 82551 | 72 | 2.643 | 31233.8 |
919 | 2023-12-30 11:03:39 | apples | 1 | 48755 | 7 | 0.780 | 62506.4 |
918 | 2023-12-25 16:58:26 | apples | 1 | 48755 | 7 | 0.750 | 65006.7 |
917 | 2023-12-14 13:12:52 | apples | 3 | 112716 | 923 | 4.703 | 23966.8 |
916 | 2023-12-12 23:05:04 | apples | 2 | 82551 | 72 | 2.576 | 32046.2 |
915 | 2023-12-07 13:12:13 | apples | 3 | 112716 | 923 | 5.016 | 22471.3 |
914 | 2023-12-07 13:12:06 | apples | 3 | 112716 | 923 | 5.266 | 21404.5 |
913 | 2023-12-06 23:15:10 | apples | 3 | 112716 | 923 | 4.783 | 23566.0 |
912 | 2023-11-27 19:01:31 | apples | 1 | 48755 | 7 | 0.766 | 63648.8 |
911 | 2023-11-24 02:59:58 | apples | 1 | 48755 | 7 | 0.860 | 56691.9 |
910 | 2023-11-16 05:45:42 | apples | 1 | 48755 | 7 | 0.766 | 63648.8 |
909 | 2023-10-31 14:50:57 | apples | 1 | 48755 | 7 | 0.830 | 58741.0 |
908 | 2023-10-31 04:13:05 | apples | 1 | 48755 | 7 | 0.860 | 56691.9 |
907 | 2023-10-19 15:11:16 | apples | 1 | 48755 | 7 | 0.890 | 54780.9 |
906 | 2023-10-17 15:53:58 | apples | 1 | 48755 | 7 | 2.343 | 20808.8 |
905 | 2023-10-15 13:37:25 | apples | 1 | 48755 | 7 | 0.763 | 63899.1 |
904 | 2023-10-08 06:49:23 | apples | 1 | 48755 | 7 | 0.766 | 63648.8 |
903 | 2023-09-26 07:07:48 | apples | 1 | 48755 | 7 | 0.750 | 65006.7 |
902 | 2023-09-25 09:54:07 | apples | 1 | 48755 | 7 | 1.610 | 30282.6 |
901 | 2023-09-18 04:07:37 | apples | 1 | 48755 | 7 | 0.860 | 56691.9 |
900 | 2023-09-15 19:53:56 | apples | 1 | 48755 | 7 | 0.860 | 56691.9 |
899 | 2023-09-12 13:00:00 | apples | 2 | 82551 | 72 | 2.110 | 39123.7 |
898 | 2023-09-11 21:55:27 | apples | 3 | 112716 | 923 | 7.436 | 15158.1 |
897 | 2023-09-05 22:55:22 | apples | 3 | 112716 | 923 | 5.563 | 20261.7 |
896 | 2023-09-03 14:46:08 | apples | 3 | 112716 | 923 | 4.716 | 23900.8 |
895 | 2023-08-14 23:17:25 | apples | 1 | 48755 | 7 | 0.750 | 65006.7 |
894 | 2023-06-14 03:25:34 | apples | 1 | 48755 | 7 | 0.873 | 55847.7 |
893 | 2023-06-05 11:48:39 | apples | 2 | 82551 | 72 | 2.093 | 39441.5 |
892 | 2023-05-25 14:27:46 | apples | 3 | 112716 | 923 | 4.563 | 24702.2 |
891 | 2023-05-13 20:48:28 | apples | 1 | 48755 | 7 | 0.750 | 65006.7 |
890 | 2023-03-31 13:54:07 | apples | 3 | 112716 | 923 | 4.626 | 24365.8 |
889 | 2023-03-30 17:06:03 | apples | 3 | 112716 | 923 | 4.593 | 24540.8 |
888 | 2023-03-26 06:05:16 | apples | 3 | 112716 | 923 | 5.250 | 21469.7 |
887 | 2023-03-25 16:26:48 | apples | 3 | 112716 | 923 | 4.596 | 24524.8 |
886 | 2023-03-11 17:26:31 | apples | 1 | 48755 | 7 | 0.813 | 59969.2 |
885 | 2023-03-09 14:13:02 | apples | 3 | 112716 | 923 | 4.576 | 24632.0 |
884 | 2023-03-09 01:43:51 | apples | 2 | 82551 | 72 | 2.123 | 38884.1 |
883 | 2023-03-07 15:08:50 | apples | 1 | 48755 | 7 | 0.733 | 66514.3 |
882 | 2023-02-09 23:16:55 | apples | 3 | 112716 | 923 | 4.580 | 24610.5 |
881 | 2023-02-04 14:56:20 | apples | 3 | 112716 | 923 | 5.283 | 21335.6 |
880 | 2023-01-16 10:12:40 | apples | 3 | 112716 | 923 | 5.233 | 21539.5 |
879 | 2022-12-29 07:49:51 | apples | 1 | 48755 | 7 | 0.860 | 56691.9 |
878 | 2022-12-16 01:14:32 | apples | 2 | 82551 | 72 | 2.093 | 39441.5 |
877 | 2022-12-15 15:56:50 | apples | 3 | 112716 | 923 | 5.703 | 19764.3 |
876 | 2022-12-06 18:48:09 | apples | 1 | 48755 | 7 | 0.890 | 54780.9 |
875 | 2022-11-21 08:02:06 | apples | 3 | 112716 | 923 | 5.266 | 21404.5 |
874 | 2022-09-17 02:05:13 | apples | 1 | 48755 | 7 | 0.750 | 65006.7 |
873 | 2022-09-03 15:21:33 | apples | 1 | 48755 | 7 | 1.530 | 31866.0 |
872 | 2022-08-23 05:47:36 | apples | 1 | 48755 | 7 | 0.826 | 59025.4 |
871 | 2022-08-15 16:31:08 | apples | 1 | 48755 | 7 | 0.923 | 52822.3 |
870 | 2022-08-10 15:36:34 | apples | 1 | 48755 | 7 | 0.843 | 57835.1 |
869 | 2022-08-05 15:02:42 | apples | 2 | 82551 | 72 | 2.173 | 37989.4 |
868 | 2022-08-02 23:41:45 | apples | 1 | 48755 | 7 | 0.813 | 59969.2 |
867 | 2022-07-25 04:36:20 | apples | 1 | 48755 | 7 | 0.796 | 61250.0 |
866 | 2022-07-18 10:15:12 | apples | 1 | 48755 | 7 | 0.766 | 63648.8 |
865 | 2022-07-15 22:27:28 | apples | 1 | 48755 | 7 | 0.750 | 65006.7 |
864 | 2022-06-17 04:13:22 | apples | 1 | 48755 | 7 | 0.766 | 63648.8 |
863 | 2022-06-16 20:17:47 | apples | 1 | 48755 | 7 | 0.763 | 63899.1 |
862 | 2022-06-04 03:37:09 | apples | 1 | 48755 | 7 | 0.750 | 65006.7 |