History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lakes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
995 | 2024-04-11 04:36:24 | lakes | 1 | 28756 | 29 | 0.516 | 55728.7 |
994 | 2024-04-08 13:47:19 | lakes | 1 | 28756 | 29 | 0.533 | 53951.2 |
993 | 2024-04-03 04:05:24 | lakes | 1 | 28756 | 29 | 1.170 | 24577.8 |
992 | 2024-04-03 04:05:03 | lakes | 2 | 53800 | 450 | 3.843 | 13999.5 |
991 | 2024-04-02 21:21:00 | lakes | 1 | 28756 | 29 | 0.563 | 51076.4 |
990 | 2024-04-02 18:51:03 | lakes | 2 | 53800 | 450 | 3.423 | 15717.2 |
989 | 2024-04-01 22:43:58 | lakes | 2 | 53800 | 450 | 1.390 | 38705.0 |
988 | 2024-03-31 02:20:53 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
987 | 2024-03-30 21:36:14 | lakes | 2 | 53800 | 450 | 5.703 | 9433.6 |
986 | 2024-03-29 22:12:53 | lakes | 2 | 53800 | 450 | 2.736 | 19663.7 |
985 | 2024-03-28 23:55:03 | lakes | 2 | 53800 | 450 | 2.140 | 25140.2 |
984 | 2024-03-28 23:10:08 | lakes | 1 | 28756 | 29 | 0.610 | 47141.0 |
983 | 2024-03-28 16:35:23 | lakes | 1 | 28756 | 29 | 0.563 | 51076.4 |
982 | 2024-02-28 10:31:23 | lakes | 1 | 28756 | 29 | 1.516 | 18968.3 |
981 | 2024-02-28 00:51:02 | lakes | 2 | 53800 | 450 | 1.673 | 32157.8 |
980 | 2024-02-27 22:58:05 | lakes | 2 | 53800 | 450 | 2.796 | 19241.8 |
979 | 2024-02-27 20:41:11 | lakes | 1 | 28756 | 29 | 0.530 | 54256.6 |
978 | 2024-02-06 03:03:35 | lakes | 1 | 28756 | 29 | 1.080 | 26625.9 |
977 | 2024-02-02 07:18:48 | lakes | 1 | 28756 | 29 | 0.440 | 65354.5 |
976 | 2024-01-04 04:58:39 | lakes | 2 | 53800 | 450 | 1.640 | 32804.9 |
975 | 2023-12-30 20:31:51 | lakes | 1 | 28756 | 29 | 0.486 | 59168.7 |
974 | 2023-12-26 20:13:14 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
973 | 2023-12-05 09:55:32 | lakes | 2 | 53800 | 450 | 3.390 | 15870.2 |
972 | 2023-11-28 12:52:33 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
971 | 2023-11-27 17:46:50 | lakes | 1 | 28756 | 29 | 0.530 | 54256.6 |
970 | 2023-11-24 09:47:02 | lakes | 2 | 53800 | 450 | 1.626 | 33087.3 |
969 | 2023-11-23 04:33:57 | lakes | 2 | 53800 | 450 | 1.406 | 38264.6 |
968 | 2023-11-21 01:01:01 | lakes | 1 | 28756 | 29 | 0.546 | 52666.7 |
967 | 2023-11-20 19:10:09 | lakes | 2 | 53800 | 450 | 1.623 | 33148.5 |
966 | 2023-11-15 10:02:05 | lakes | 1 | 28756 | 29 | 0.563 | 51076.4 |
965 | 2023-11-09 13:18:16 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
964 | 2023-11-09 04:01:38 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
963 | 2023-10-31 08:00:47 | lakes | 1 | 28756 | 29 | 0.563 | 51076.4 |
962 | 2023-10-21 23:25:58 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
961 | 2023-10-18 15:51:44 | lakes | 1 | 28756 | 29 | 0.466 | 61708.2 |
960 | 2023-10-15 10:56:35 | lakes | 1 | 28756 | 29 | 1.033 | 27837.4 |
959 | 2023-10-14 12:05:30 | lakes | 1 | 28756 | 29 | 0.466 | 61708.2 |
958 | 2023-10-12 11:30:37 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
957 | 2023-10-11 17:55:06 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
956 | 2023-10-05 19:36:25 | lakes | 1 | 28756 | 29 | 0.516 | 55728.7 |
955 | 2023-09-26 18:58:32 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
954 | 2023-09-14 09:31:31 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
953 | 2023-09-01 08:57:28 | lakes | 2 | 53800 | 450 | 1.393 | 38621.7 |
952 | 2023-08-31 14:19:00 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
951 | 2023-08-20 13:23:30 | lakes | 1 | 28756 | 29 | 1.046 | 27491.4 |
950 | 2023-08-10 17:05:55 | lakes | 1 | 28756 | 29 | 0.516 | 55728.7 |
949 | 2023-07-05 00:15:30 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
948 | 2023-06-07 21:28:28 | lakes | 1 | 28756 | 29 | 0.470 | 61183.0 |
947 | 2023-05-18 15:14:52 | lakes | 2 | 53800 | 450 | 1.563 | 34421.0 |
946 | 2023-05-11 09:34:50 | lakes | 1 | 28756 | 29 | 0.440 | 65354.5 |
945 | 2023-05-06 08:19:44 | lakes | 1 | 28756 | 29 | 0.470 | 61183.0 |
944 | 2023-04-01 05:21:23 | lakes | 1 | 28756 | 29 | 0.440 | 65354.5 |
943 | 2023-03-19 09:33:29 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
942 | 2023-03-05 22:12:56 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
941 | 2023-02-23 12:55:14 | lakes | 2 | 53800 | 450 | 1.686 | 31909.8 |
940 | 2023-01-13 11:17:33 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
939 | 2022-12-27 23:27:48 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
938 | 2022-12-27 01:14:01 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
937 | 2022-12-04 21:32:54 | lakes | 2 | 53800 | 450 | 1.376 | 39098.8 |
936 | 2022-09-19 22:29:25 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
935 | 2022-09-13 21:56:38 | lakes | 1 | 28756 | 29 | 0.483 | 59536.2 |
934 | 2022-09-12 17:12:49 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
933 | 2022-08-15 05:18:28 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
932 | 2022-08-14 20:12:02 | lakes | 1 | 28756 | 29 | 0.516 | 55728.7 |
931 | 2022-08-07 00:10:36 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
930 | 2022-07-30 01:38:59 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
929 | 2022-07-29 04:24:12 | lakes | 1 | 28756 | 29 | 0.486 | 59168.7 |
928 | 2022-07-20 01:26:23 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
927 | 2022-07-14 18:36:23 | lakes | 2 | 53800 | 450 | 1.393 | 38621.7 |
926 | 2022-07-12 04:34:57 | lakes | 2 | 53800 | 450 | 1.500 | 35866.7 |
925 | 2022-07-03 09:48:39 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
924 | 2022-06-25 21:32:06 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
923 | 2022-06-16 09:46:53 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
922 | 2022-06-08 22:37:50 | lakes | 1 | 28756 | 29 | 0.470 | 61183.0 |
921 | 2022-06-08 19:31:40 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
920 | 2022-06-01 21:25:57 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
919 | 2022-05-30 22:46:05 | lakes | 1 | 28756 | 29 | 0.470 | 61183.0 |
918 | 2022-03-19 09:33:31 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
917 | 2022-03-18 13:51:29 | lakes | 1 | 28756 | 29 | 0.626 | 45936.1 |
916 | 2022-03-17 18:35:28 | lakes | 1 | 28756 | 29 | 0.593 | 48492.4 |
915 | 2022-03-16 20:54:31 | lakes | 1 | 28756 | 29 | 0.483 | 59536.2 |
914 | 2022-03-16 06:14:07 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
913 | 2022-03-15 11:52:02 | lakes | 1 | 28756 | 29 | 0.640 | 44931.3 |
912 | 2022-03-15 06:56:57 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
911 | 2022-03-14 15:09:59 | lakes | 1 | 28756 | 29 | 0.876 | 32826.5 |
910 | 2022-03-13 18:07:16 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
909 | 2022-03-13 00:14:21 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
908 | 2022-03-12 05:05:50 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
907 | 2022-03-11 17:42:15 | lakes | 1 | 28756 | 29 | 0.500 | 57512.0 |
906 | 2022-03-11 05:26:05 | lakes | 1 | 28756 | 29 | 0.516 | 55728.7 |
905 | 2022-03-10 20:30:28 | lakes | 1 | 28756 | 29 | 0.593 | 48492.4 |
904 | 2022-03-10 00:49:11 | lakes | 1 | 28756 | 29 | 1.046 | 27491.4 |
903 | 2022-03-09 09:30:43 | lakes | 1 | 28756 | 29 | 0.640 | 44931.3 |
902 | 2022-03-08 15:33:56 | lakes | 1 | 28756 | 29 | 0.626 | 45936.1 |
901 | 2022-03-07 15:38:13 | lakes | 1 | 28756 | 29 | 0.453 | 63479.0 |
900 | 2022-03-07 02:09:57 | lakes | 1 | 28756 | 29 | 0.436 | 65954.1 |
899 | 2022-03-06 11:05:41 | lakes | 1 | 28756 | 29 | 0.466 | 61708.2 |
898 | 2022-03-05 20:34:57 | lakes | 1 | 28756 | 29 | 0.440 | 65354.5 |
897 | 2022-03-05 03:34:10 | lakes | 1 | 28756 | 29 | 0.483 | 59536.2 |
896 | 2022-03-04 12:51:17 | lakes | 1 | 28756 | 29 | 0.593 | 48492.4 |