History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lotions"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
975 | 2024-04-07 05:33:38 | lotions | 3 | 134027 | 457 | 16.173 | 8287.1 |
974 | 2024-04-06 02:09:17 | lotions | 3 | 134027 | 457 | 27.626 | 4851.5 |
973 | 2024-04-06 00:07:12 | lotions | 3 | 134027 | 457 | 25.050 | 5350.4 |
972 | 2024-03-25 05:03:45 | lotions | 2 | 107671 | 43 | 3.343 | 32207.9 |
971 | 2024-03-25 04:48:05 | lotions | 3 | 134027 | 457 | 6.093 | 21996.9 |
970 | 2024-03-22 07:16:40 | lotions | 2 | 107671 | 43 | 2.983 | 36094.9 |
969 | 2024-03-22 07:16:00 | lotions | 3 | 134027 | 457 | 9.376 | 14294.7 |
968 | 2024-03-19 20:51:40 | lotions | 2 | 107671 | 43 | 6.503 | 16557.1 |
967 | 2024-03-19 20:49:29 | lotions | 3 | 134027 | 457 | 7.233 | 18529.9 |
966 | 2024-03-19 20:49:31 | lotions | 2 | 107671 | 43 | 3.563 | 30219.2 |
965 | 2024-03-19 20:49:20 | lotions | 1 | 69583 | 6 | 1.283 | 54234.6 |
964 | 2024-03-19 20:48:58 | lotions | 3 | 134027 | 457 | 7.360 | 18210.2 |
963 | 2024-03-19 19:29:30 | lotions | 3 | 134027 | 457 | 21.940 | 6108.8 |
962 | 2024-03-10 23:44:42 | lotions | 1 | 69583 | 6 | 1.283 | 54234.6 |
961 | 2024-03-07 14:38:16 | lotions | 1 | 69583 | 6 | 1.280 | 54361.7 |
960 | 2024-02-07 00:18:30 | lotions | 2 | 107671 | 43 | 2.843 | 37872.3 |
959 | 2024-02-07 00:18:10 | lotions | 3 | 134027 | 457 | 7.033 | 19056.9 |
958 | 2024-02-02 17:58:15 | lotions | 2 | 107671 | 43 | 3.280 | 32826.5 |
957 | 2024-02-01 07:01:32 | lotions | 2 | 107671 | 43 | 3.236 | 33272.9 |
956 | 2024-02-01 07:01:12 | lotions | 3 | 134027 | 457 | 5.970 | 22450.1 |
955 | 2024-02-01 05:35:48 | lotions | 3 | 134027 | 457 | 6.393 | 20964.6 |
954 | 2024-02-01 03:05:33 | lotions | 3 | 134027 | 457 | 7.126 | 18808.2 |
953 | 2024-01-08 20:16:01 | lotions | 3 | 134027 | 457 | 7.030 | 19065.0 |
952 | 2023-12-24 06:33:45 | lotions | 3 | 134027 | 457 | 7.296 | 18369.9 |
951 | 2023-12-16 12:29:43 | lotions | 3 | 134027 | 457 | 6.063 | 22105.7 |
950 | 2023-12-15 18:09:37 | lotions | 3 | 134027 | 457 | 6.046 | 22167.9 |
949 | 2023-12-15 06:29:26 | lotions | 1 | 69583 | 6 | 1.266 | 54962.9 |
948 | 2023-12-15 05:56:53 | lotions | 2 | 107671 | 43 | 3.393 | 31733.3 |
947 | 2023-12-15 04:47:34 | lotions | 3 | 134027 | 457 | 6.640 | 20184.8 |
946 | 2023-12-08 18:23:30 | lotions | 3 | 134027 | 457 | 5.986 | 22390.1 |
945 | 2023-12-01 05:15:22 | lotions | 3 | 134027 | 457 | 9.936 | 13489.0 |
944 | 2023-11-28 10:51:31 | lotions | 3 | 134027 | 457 | 5.736 | 23365.9 |
943 | 2023-11-25 08:09:21 | lotions | 3 | 134027 | 457 | 8.330 | 16089.7 |
942 | 2023-11-24 23:11:20 | lotions | 1 | 69583 | 6 | 1.063 | 65459.1 |
941 | 2023-11-13 07:46:02 | lotions | 3 | 134027 | 457 | 6.673 | 20085.0 |
940 | 2023-11-11 21:16:57 | lotions | 1 | 69583 | 6 | 1.033 | 67360.1 |
939 | 2023-11-10 00:51:04 | lotions | 3 | 134027 | 457 | 7.643 | 17535.9 |
938 | 2023-11-07 01:29:22 | lotions | 1 | 69583 | 6 | 1.203 | 57841.2 |
937 | 2023-11-04 10:19:03 | lotions | 1 | 69583 | 6 | 1.173 | 59320.5 |
936 | 2023-11-01 03:59:00 | lotions | 1 | 69583 | 6 | 1.063 | 65459.1 |
935 | 2023-10-17 12:25:21 | lotions | 1 | 69583 | 6 | 1.360 | 51164.0 |
934 | 2023-10-11 20:16:18 | lotions | 1 | 69583 | 6 | 1.140 | 61037.7 |
933 | 2023-10-06 14:44:07 | lotions | 1 | 69583 | 6 | 1.060 | 65644.3 |
932 | 2023-10-04 00:35:53 | lotions | 3 | 134027 | 457 | 8.220 | 16305.0 |
931 | 2023-10-04 00:35:41 | lotions | 2 | 107671 | 43 | 3.783 | 28461.8 |
930 | 2023-10-02 02:55:58 | lotions | 1 | 69583 | 6 | 1.046 | 66522.9 |
929 | 2023-10-01 11:17:03 | lotions | 2 | 107671 | 43 | 3.656 | 29450.5 |
928 | 2023-10-01 07:20:07 | lotions | 3 | 134027 | 457 | 13.033 | 10283.7 |
927 | 2023-09-28 01:54:37 | lotions | 2 | 107671 | 43 | 3.360 | 32044.9 |
926 | 2023-09-28 01:54:01 | lotions | 3 | 134027 | 457 | 6.296 | 21287.6 |
925 | 2023-09-25 00:32:35 | lotions | 1 | 69583 | 6 | 1.046 | 66522.9 |
924 | 2023-09-21 19:40:04 | lotions | 1 | 69583 | 6 | 1.203 | 57841.2 |
923 | 2023-08-13 02:53:05 | lotions | 3 | 134027 | 457 | 6.453 | 20769.7 |
922 | 2023-08-12 16:58:40 | lotions | 3 | 134027 | 457 | 5.826 | 23005.0 |
921 | 2023-08-10 15:38:31 | lotions | 3 | 134027 | 457 | 6.233 | 21502.8 |
920 | 2023-07-31 02:55:39 | lotions | 1 | 69583 | 6 | 1.063 | 65459.1 |
919 | 2023-07-20 06:22:25 | lotions | 1 | 69583 | 6 | 1.203 | 57841.2 |
918 | 2023-05-01 18:00:39 | lotions | 3 | 134027 | 457 | 5.796 | 23124.1 |
917 | 2023-04-29 00:20:35 | lotions | 1 | 69583 | 6 | 1.080 | 64428.7 |
916 | 2023-04-24 15:27:10 | lotions | 3 | 134027 | 457 | 6.796 | 19721.5 |
915 | 2023-04-12 08:13:54 | lotions | 1 | 69583 | 6 | 1.173 | 59320.5 |
914 | 2023-03-28 13:34:54 | lotions | 3 | 134027 | 457 | 12.923 | 10371.2 |
913 | 2023-02-18 10:03:57 | lotions | 1 | 69583 | 6 | 1.060 | 65644.3 |
912 | 2023-02-07 05:30:27 | lotions | 3 | 134027 | 457 | 6.843 | 19586.0 |
911 | 2023-01-29 05:49:51 | lotions | 3 | 134027 | 457 | 5.720 | 23431.3 |
910 | 2023-01-07 06:09:03 | lotions | 1 | 69583 | 6 | 1.220 | 57035.2 |
909 | 2022-12-21 18:57:57 | lotions | 3 | 134027 | 457 | 6.610 | 20276.4 |
908 | 2022-12-16 16:02:45 | lotions | 1 | 69583 | 6 | 1.046 | 66522.9 |
907 | 2022-12-06 09:19:48 | lotions | 3 | 134027 | 457 | 15.236 | 8796.7 |
906 | 2022-12-05 19:56:29 | lotions | 3 | 134027 | 457 | 8.313 | 16122.6 |
905 | 2022-11-10 08:55:34 | lotions | 3 | 134027 | 457 | 7.076 | 18941.1 |
904 | 2022-11-09 21:08:27 | lotions | 3 | 134027 | 457 | 5.703 | 23501.1 |
903 | 2022-11-03 19:33:47 | lotions | 3 | 134027 | 457 | 6.716 | 19956.4 |
902 | 2022-10-26 05:12:34 | lotions | 3 | 134027 | 457 | 6.080 | 22043.9 |
901 | 2022-10-22 12:27:44 | lotions | 3 | 134027 | 457 | 5.813 | 23056.4 |
900 | 2022-10-06 05:49:09 | lotions | 3 | 134027 | 457 | 6.936 | 19323.4 |
899 | 2022-10-05 07:28:26 | lotions | 3 | 134027 | 457 | 6.813 | 19672.2 |
898 | 2022-10-04 16:52:11 | lotions | 3 | 134027 | 457 | 6.936 | 19323.4 |
897 | 2022-10-03 06:54:49 | lotions | 3 | 134027 | 457 | 12.266 | 10926.7 |
896 | 2022-10-03 05:17:11 | lotions | 3 | 134027 | 457 | 5.783 | 23176.0 |
895 | 2022-10-03 02:28:44 | lotions | 3 | 134027 | 457 | 5.703 | 23501.1 |
894 | 2022-10-02 04:06:16 | lotions | 3 | 134027 | 457 | 6.670 | 20094.0 |
893 | 2022-10-01 05:04:03 | lotions | 3 | 134027 | 457 | 7.030 | 19065.0 |
892 | 2022-09-30 12:55:54 | lotions | 3 | 134027 | 457 | 6.686 | 20045.9 |
891 | 2022-09-29 07:50:44 | lotions | 3 | 134027 | 457 | 14.670 | 9136.1 |
890 | 2022-09-28 15:01:51 | lotions | 3 | 134027 | 457 | 6.593 | 20328.7 |
889 | 2022-09-27 04:22:17 | lotions | 3 | 134027 | 457 | 7.376 | 18170.7 |
888 | 2022-09-26 14:22:55 | lotions | 3 | 134027 | 457 | 7.220 | 18563.3 |
887 | 2022-09-25 08:27:48 | lotions | 3 | 134027 | 457 | 7.093 | 18895.7 |
886 | 2022-09-24 05:44:45 | lotions | 3 | 134027 | 457 | 6.483 | 20673.6 |
885 | 2022-09-23 07:34:05 | lotions | 3 | 134027 | 457 | 5.720 | 23431.3 |
884 | 2022-09-22 04:35:57 | lotions | 3 | 134027 | 457 | 6.670 | 20094.0 |
883 | 2022-09-21 22:37:41 | lotions | 3 | 134027 | 457 | 7.640 | 17542.8 |
882 | 2022-09-20 04:26:48 | lotions | 3 | 134027 | 457 | 6.936 | 19323.4 |
881 | 2022-09-19 21:32:58 | lotions | 1 | 69583 | 6 | 1.266 | 54962.9 |
880 | 2022-09-19 05:52:48 | lotions | 3 | 134027 | 457 | 7.360 | 18210.2 |
879 | 2022-09-19 05:36:49 | lotions | 1 | 69583 | 6 | 1.060 | 65644.3 |
878 | 2022-09-18 22:14:03 | lotions | 3 | 134027 | 457 | 7.106 | 18861.1 |
877 | 2022-09-17 03:29:21 | lotions | 3 | 134027 | 457 | 7.220 | 18563.3 |
876 | 2022-09-02 06:56:38 | lotions | 1 | 69583 | 6 | 1.063 | 65459.1 |