History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chapter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
967 | 2024-04-27 17:46:42 | chapter | 1 | 69583 | 7 | 1.656 | 42018.7 |
966 | 2024-04-25 19:54:19 | chapter | 1 | 69583 | 7 | 1.343 | 51811.6 |
965 | 2024-04-21 23:01:30 | chapter | 1 | 69583 | 7 | 2.140 | 32515.4 |
964 | 2024-03-30 06:48:52 | chapter | 1 | 69583 | 7 | 1.500 | 46388.7 |
963 | 2024-03-07 06:25:13 | chapter | 2 | 107671 | 77 | 3.843 | 28017.4 |
962 | 2024-03-06 21:44:18 | chapter | 3 | 134027 | 664 | 8.250 | 16245.7 |
961 | 2024-03-06 04:26:29 | chapter | 3 | 134027 | 664 | 24.316 | 5511.9 |
960 | 2024-03-05 03:39:56 | chapter | 3 | 134027 | 664 | 19.596 | 6839.5 |
959 | 2024-03-04 22:03:25 | chapter | 3 | 134027 | 664 | 17.970 | 7458.4 |
958 | 2024-03-04 12:52:46 | chapter | 2 | 107671 | 77 | 9.890 | 10886.9 |
957 | 2024-03-03 12:24:57 | chapter | 3 | 134027 | 664 | 18.720 | 7159.6 |
956 | 2024-03-03 12:24:54 | chapter | 2 | 107671 | 77 | 9.486 | 11350.5 |
955 | 2024-03-03 12:24:40 | chapter | 1 | 69583 | 7 | 4.093 | 17000.5 |
954 | 2024-02-08 18:07:34 | chapter | 3 | 134027 | 664 | 8.813 | 15207.9 |
953 | 2024-02-05 09:04:07 | chapter | 3 | 134027 | 664 | 7.813 | 17154.4 |
952 | 2024-02-05 02:46:38 | chapter | 3 | 134027 | 664 | 7.343 | 18252.3 |
951 | 2024-01-30 14:26:27 | chapter | 1 | 69583 | 7 | 1.250 | 55666.4 |
950 | 2024-01-28 19:11:43 | chapter | 3 | 134027 | 664 | 5.720 | 23431.3 |
949 | 2024-01-24 03:50:14 | chapter | 3 | 134027 | 664 | 5.923 | 22628.2 |
948 | 2024-01-11 13:35:17 | chapter | 3 | 134027 | 664 | 6.750 | 19855.9 |
947 | 2024-01-08 00:08:22 | chapter | 3 | 134027 | 664 | 5.956 | 22502.9 |
946 | 2024-01-07 09:39:59 | chapter | 3 | 134027 | 664 | 9.003 | 14886.9 |
945 | 2024-01-01 14:03:28 | chapter | 3 | 134027 | 664 | 6.690 | 20033.9 |
944 | 2023-12-17 00:37:12 | chapter | 1 | 69583 | 7 | 1.123 | 61961.7 |
943 | 2023-12-15 20:01:45 | chapter | 2 | 107671 | 77 | 2.936 | 36672.7 |
942 | 2023-12-11 08:35:42 | chapter | 1 | 69583 | 7 | 1.203 | 57841.2 |
941 | 2023-11-26 22:44:49 | chapter | 2 | 107671 | 77 | 2.830 | 38046.3 |
940 | 2023-11-25 13:27:01 | chapter | 1 | 69583 | 7 | 1.190 | 58473.1 |
939 | 2023-11-23 18:26:52 | chapter | 3 | 134027 | 664 | 7.173 | 18684.9 |
938 | 2023-11-19 16:07:25 | chapter | 1 | 69583 | 7 | 1.220 | 57035.2 |
937 | 2023-11-15 00:15:11 | chapter | 1 | 69583 | 7 | 1.313 | 52995.4 |
936 | 2023-11-14 21:36:15 | chapter | 3 | 134027 | 664 | 7.046 | 19021.7 |
935 | 2023-11-09 11:08:05 | chapter | 1 | 69583 | 7 | 1.076 | 64668.2 |
934 | 2023-11-04 06:37:19 | chapter | 3 | 134027 | 664 | 6.360 | 21073.4 |
933 | 2023-10-31 13:56:11 | chapter | 3 | 134027 | 664 | 12.736 | 10523.5 |
932 | 2023-10-30 21:55:35 | chapter | 1 | 69583 | 7 | 1.153 | 60349.5 |
931 | 2023-10-29 00:33:53 | chapter | 1 | 69583 | 7 | 1.140 | 61037.7 |
930 | 2023-10-21 21:52:30 | chapter | 3 | 134027 | 664 | 6.656 | 20136.3 |
929 | 2023-10-15 04:38:30 | chapter | 1 | 69583 | 7 | 1.236 | 56296.9 |
928 | 2023-09-26 07:43:05 | chapter | 1 | 69583 | 7 | 1.220 | 57035.2 |
927 | 2023-09-26 02:19:20 | chapter | 1 | 69583 | 7 | 1.186 | 58670.3 |
926 | 2023-09-11 01:57:15 | chapter | 1 | 69583 | 7 | 1.236 | 56296.9 |
925 | 2023-08-27 06:26:55 | chapter | 3 | 134027 | 664 | 5.706 | 23488.8 |
924 | 2023-08-26 21:28:48 | chapter | 3 | 134027 | 664 | 10.486 | 12781.5 |
923 | 2023-08-26 09:23:47 | chapter | 3 | 134027 | 664 | 6.220 | 21547.7 |
922 | 2023-08-25 10:57:20 | chapter | 2 | 107671 | 77 | 2.826 | 38100.1 |
921 | 2023-08-25 08:40:14 | chapter | 3 | 134027 | 664 | 6.393 | 20964.6 |
920 | 2023-08-23 18:22:12 | chapter | 3 | 134027 | 664 | 12.390 | 10817.4 |
919 | 2023-08-22 03:27:04 | chapter | 3 | 134027 | 664 | 5.953 | 22514.2 |
918 | 2023-08-20 20:18:18 | chapter | 3 | 134027 | 664 | 7.766 | 17258.2 |
917 | 2023-08-19 02:15:03 | chapter | 3 | 134027 | 664 | 6.000 | 22337.8 |
916 | 2023-08-10 05:36:35 | chapter | 3 | 134027 | 664 | 6.140 | 21828.5 |
915 | 2023-08-04 19:40:04 | chapter | 3 | 134027 | 664 | 5.830 | 22989.2 |
914 | 2023-07-26 03:15:51 | chapter | 1 | 69583 | 7 | 1.063 | 65459.1 |
913 | 2023-06-17 20:11:26 | chapter | 1 | 69583 | 7 | 1.063 | 65459.1 |
912 | 2023-06-05 19:23:44 | chapter | 3 | 134027 | 664 | 5.876 | 22809.2 |
911 | 2023-06-01 19:25:22 | chapter | 3 | 134027 | 664 | 8.343 | 16064.6 |
910 | 2023-05-11 12:37:30 | chapter | 2 | 107671 | 77 | 2.890 | 37256.4 |
909 | 2023-05-11 03:26:17 | chapter | 2 | 107671 | 77 | 2.780 | 38730.6 |
908 | 2023-04-24 04:37:00 | chapter | 3 | 134027 | 664 | 6.216 | 21561.6 |
907 | 2023-04-21 14:38:54 | chapter | 1 | 69583 | 7 | 1.123 | 61961.7 |
906 | 2023-04-01 05:35:34 | chapter | 1 | 69583 | 7 | 1.156 | 60192.9 |
905 | 2023-03-31 06:52:41 | chapter | 2 | 107671 | 77 | 2.890 | 37256.4 |
904 | 2023-03-01 04:27:26 | chapter | 3 | 134027 | 664 | 11.156 | 12013.9 |
903 | 2023-02-28 04:21:38 | chapter | 3 | 134027 | 664 | 5.750 | 23309.0 |
902 | 2023-02-27 14:51:47 | chapter | 3 | 134027 | 664 | 6.280 | 21341.9 |
901 | 2023-02-27 04:19:54 | chapter | 3 | 134027 | 664 | 6.453 | 20769.7 |
900 | 2023-02-26 04:18:29 | chapter | 3 | 134027 | 664 | 6.436 | 20824.6 |
899 | 2023-02-25 04:15:22 | chapter | 3 | 134027 | 664 | 5.640 | 23763.7 |
898 | 2023-02-24 04:12:19 | chapter | 3 | 134027 | 664 | 5.780 | 23188.1 |
897 | 2023-02-22 04:08:08 | chapter | 3 | 134027 | 664 | 6.470 | 20715.1 |
896 | 2023-02-20 11:00:41 | chapter | 2 | 107671 | 77 | 3.140 | 34290.1 |
895 | 2023-02-17 04:07:18 | chapter | 3 | 134027 | 664 | 5.610 | 23890.7 |
894 | 2023-02-15 04:05:09 | chapter | 3 | 134027 | 664 | 6.530 | 20524.8 |
893 | 2023-02-10 07:36:56 | chapter | 3 | 134027 | 664 | 5.563 | 24092.6 |
892 | 2023-02-09 11:31:49 | chapter | 3 | 134027 | 664 | 6.093 | 21996.9 |
891 | 2023-02-08 02:57:32 | chapter | 3 | 134027 | 664 | 5.750 | 23309.0 |
890 | 2023-02-07 06:09:13 | chapter | 3 | 134027 | 664 | 6.313 | 21230.3 |
889 | 2023-02-06 09:44:01 | chapter | 3 | 134027 | 664 | 9.983 | 13425.5 |
888 | 2023-02-05 15:16:09 | chapter | 3 | 134027 | 664 | 5.843 | 22938.0 |
887 | 2023-02-04 10:43:27 | chapter | 3 | 134027 | 664 | 6.796 | 19721.5 |
886 | 2023-02-03 12:55:44 | chapter | 3 | 134027 | 664 | 6.703 | 19995.1 |
885 | 2023-02-02 06:28:34 | chapter | 3 | 134027 | 664 | 7.456 | 17975.7 |
884 | 2023-02-01 11:15:24 | chapter | 3 | 134027 | 664 | 6.393 | 20964.6 |
883 | 2023-01-31 07:18:07 | chapter | 3 | 134027 | 664 | 6.000 | 22337.8 |
882 | 2023-01-30 10:03:45 | chapter | 3 | 134027 | 664 | 7.000 | 19146.7 |
881 | 2023-01-30 08:56:06 | chapter | 3 | 134027 | 664 | 6.373 | 21030.4 |
880 | 2023-01-29 07:52:47 | chapter | 3 | 134027 | 664 | 5.563 | 24092.6 |
879 | 2023-01-14 08:31:03 | chapter | 1 | 69583 | 7 | 1.063 | 65459.1 |
878 | 2023-01-09 05:02:21 | chapter | 1 | 69583 | 7 | 1.576 | 44151.6 |
877 | 2023-01-07 01:34:22 | chapter | 3 | 134027 | 664 | 6.610 | 20276.4 |
876 | 2022-12-15 21:03:09 | chapter | 3 | 134027 | 664 | 6.410 | 20909.0 |
875 | 2022-12-01 15:27:02 | chapter | 2 | 107671 | 77 | 2.763 | 38968.9 |
874 | 2022-11-16 16:23:00 | chapter | 3 | 134027 | 664 | 6.160 | 21757.6 |
873 | 2022-11-14 22:32:17 | chapter | 3 | 134027 | 664 | 12.423 | 10788.6 |
872 | 2022-11-11 19:49:07 | chapter | 3 | 134027 | 664 | 7.030 | 19065.0 |
871 | 2022-11-06 09:52:49 | chapter | 1 | 69583 | 7 | 1.046 | 66522.9 |
870 | 2022-09-21 19:40:09 | chapter | 1 | 69583 | 7 | 1.346 | 51696.1 |
869 | 2022-09-14 05:31:30 | chapter | 3 | 134027 | 664 | 5.830 | 22989.2 |
868 | 2022-09-11 12:32:33 | chapter | 2 | 107671 | 77 | 2.813 | 38276.2 |