History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dreams"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
988 | 2024-04-19 02:51:20 | dreams | 1 | 48755 | 10 | 0.846 | 57630.0 |
987 | 2024-04-03 04:37:41 | dreams | 1 | 48755 | 10 | 1.953 | 24964.2 |
986 | 2024-03-09 11:14:32 | dreams | 1 | 48755 | 10 | 0.733 | 66514.3 |
985 | 2024-03-04 23:26:08 | dreams | 2 | 82551 | 85 | 2.673 | 30883.3 |
984 | 2024-03-04 23:25:41 | dreams | 1 | 48755 | 10 | 0.890 | 54780.9 |
983 | 2024-03-04 23:25:21 | dreams | 3 | 112716 | 872 | 6.140 | 18357.7 |
982 | 2024-03-04 04:23:12 | dreams | 3 | 112716 | 872 | 6.313 | 17854.6 |
981 | 2024-03-04 04:23:13 | dreams | 2 | 82551 | 85 | 4.406 | 18736.0 |
980 | 2024-03-04 04:23:12 | dreams | 1 | 48755 | 10 | 0.856 | 56956.8 |
979 | 2024-03-02 15:36:41 | dreams | 1 | 48755 | 10 | 1.313 | 37132.5 |
978 | 2024-02-28 05:31:42 | dreams | 1 | 48755 | 10 | 2.326 | 20960.9 |
977 | 2024-02-06 09:04:27 | dreams | 2 | 82551 | 85 | 5.516 | 14965.7 |
976 | 2024-02-06 09:02:42 | dreams | 3 | 112716 | 872 | 5.966 | 18893.1 |
975 | 2024-02-06 05:16:25 | dreams | 2 | 82551 | 85 | 2.123 | 38884.1 |
974 | 2024-02-06 05:15:21 | dreams | 3 | 112716 | 872 | 5.266 | 21404.5 |
973 | 2024-02-06 04:23:22 | dreams | 2 | 82551 | 85 | 2.516 | 32810.4 |
972 | 2024-02-06 04:22:50 | dreams | 3 | 112716 | 872 | 5.546 | 20323.8 |
971 | 2024-02-05 18:56:14 | dreams | 3 | 112716 | 872 | 6.050 | 18630.7 |
970 | 2024-02-03 06:14:32 | dreams | 1 | 48755 | 10 | 2.173 | 22436.7 |
969 | 2024-01-26 15:12:46 | dreams | 1 | 48755 | 10 | 0.860 | 56691.9 |
968 | 2023-12-26 07:14:36 | dreams | 3 | 112716 | 872 | 9.236 | 12204.0 |
967 | 2023-12-23 04:26:55 | dreams | 3 | 112716 | 872 | 5.283 | 21335.6 |
966 | 2023-12-03 20:27:38 | dreams | 1 | 48755 | 10 | 0.840 | 58041.7 |
965 | 2023-12-03 20:27:37 | dreams | 1 | 48755 | 10 | 0.813 | 59969.2 |
964 | 2023-11-25 17:06:53 | dreams | 1 | 48755 | 10 | 0.766 | 63648.8 |
963 | 2023-11-23 14:38:32 | dreams | 2 | 82551 | 85 | 2.796 | 29524.7 |
962 | 2023-11-23 01:56:19 | dreams | 1 | 48755 | 10 | 1.656 | 29441.4 |
961 | 2023-11-22 08:48:27 | dreams | 1 | 48755 | 10 | 0.826 | 59025.4 |
960 | 2023-11-19 18:36:13 | dreams | 2 | 82551 | 85 | 2.266 | 36430.3 |
959 | 2023-11-12 16:29:03 | dreams | 3 | 112716 | 872 | 4.750 | 23729.7 |
958 | 2023-11-07 20:03:07 | dreams | 2 | 82551 | 85 | 2.110 | 39123.7 |
957 | 2023-11-04 02:11:25 | dreams | 1 | 48755 | 10 | 0.860 | 56691.9 |
956 | 2023-10-29 22:35:19 | dreams | 1 | 48755 | 10 | 0.860 | 56691.9 |
955 | 2023-10-19 22:53:55 | dreams | 1 | 48755 | 10 | 0.766 | 63648.8 |
954 | 2023-10-13 03:20:23 | dreams | 3 | 112716 | 872 | 5.330 | 21147.5 |
953 | 2023-10-13 03:20:24 | dreams | 2 | 82551 | 85 | 2.546 | 32423.8 |
952 | 2023-10-12 22:12:47 | dreams | 1 | 48755 | 10 | 0.796 | 61250.0 |
951 | 2023-10-07 19:15:19 | dreams | 1 | 48755 | 10 | 0.860 | 56691.9 |
950 | 2023-09-26 01:45:12 | dreams | 1 | 48755 | 10 | 0.826 | 59025.4 |
949 | 2023-09-14 15:47:55 | dreams | 1 | 48755 | 10 | 0.840 | 58041.7 |
948 | 2023-08-15 16:24:57 | dreams | 3 | 112716 | 872 | 4.843 | 23274.0 |
947 | 2023-08-12 21:40:14 | dreams | 2 | 82551 | 85 | 2.453 | 33653.1 |
946 | 2023-08-10 11:14:37 | dreams | 1 | 48755 | 10 | 0.783 | 62266.9 |
945 | 2023-05-02 22:52:15 | dreams | 1 | 48755 | 10 | 0.716 | 68093.6 |
944 | 2023-05-01 17:48:38 | dreams | 3 | 112716 | 872 | 4.673 | 24120.7 |
943 | 2023-04-27 03:00:22 | dreams | 2 | 82551 | 85 | 2.330 | 35429.6 |
942 | 2023-03-04 13:26:17 | dreams | 1 | 48755 | 10 | 0.720 | 67715.3 |
941 | 2023-02-05 05:43:59 | dreams | 3 | 112716 | 872 | 4.580 | 24610.5 |
940 | 2023-01-30 20:15:17 | dreams | 2 | 82551 | 85 | 2.080 | 39688.0 |
939 | 2023-01-20 16:45:44 | dreams | 1 | 48755 | 10 | 0.733 | 66514.3 |
938 | 2022-12-11 06:33:07 | dreams | 3 | 112716 | 872 | 5.360 | 21029.1 |
937 | 2022-11-16 16:36:20 | dreams | 3 | 112716 | 872 | 5.596 | 20142.2 |
936 | 2022-11-16 13:07:51 | dreams | 3 | 112716 | 872 | 5.000 | 22543.2 |
935 | 2022-11-10 23:13:23 | dreams | 2 | 82551 | 85 | 2.156 | 38289.0 |
934 | 2022-10-08 05:36:02 | dreams | 3 | 112716 | 872 | 4.876 | 23116.5 |
933 | 2022-10-06 11:03:02 | dreams | 1 | 48755 | 10 | 0.733 | 66514.3 |
932 | 2022-10-02 21:09:43 | dreams | 1 | 48755 | 10 | 0.736 | 66243.2 |
931 | 2022-09-22 15:39:24 | dreams | 1 | 48755 | 10 | 0.733 | 66514.3 |
930 | 2022-09-19 05:03:45 | dreams | 1 | 48755 | 10 | 0.766 | 63648.8 |
929 | 2022-09-16 12:34:16 | dreams | 3 | 112716 | 872 | 4.686 | 24053.8 |
928 | 2022-09-01 16:40:40 | dreams | 3 | 112716 | 872 | 5.296 | 21283.2 |
927 | 2022-09-01 10:42:07 | dreams | 2 | 82551 | 85 | 2.360 | 34979.2 |
926 | 2022-08-31 02:59:49 | dreams | 1 | 48755 | 10 | 0.733 | 66514.3 |
925 | 2022-08-26 04:15:37 | dreams | 1 | 48755 | 10 | 0.733 | 66514.3 |
924 | 2022-08-23 03:41:11 | dreams | 1 | 48755 | 10 | 0.750 | 65006.7 |
923 | 2022-08-17 15:17:47 | dreams | 1 | 48755 | 10 | 0.826 | 59025.4 |
922 | 2022-08-15 11:21:40 | dreams | 1 | 48755 | 10 | 0.750 | 65006.7 |
921 | 2022-08-14 13:20:47 | dreams | 1 | 48755 | 10 | 0.813 | 59969.2 |
920 | 2022-08-09 08:18:17 | dreams | 1 | 48755 | 10 | 0.750 | 65006.7 |
919 | 2022-08-08 01:47:18 | dreams | 3 | 112716 | 872 | 5.610 | 20092.0 |
918 | 2022-08-03 03:34:39 | dreams | 2 | 82551 | 85 | 2.126 | 38829.3 |
917 | 2022-08-01 01:34:12 | dreams | 1 | 48755 | 10 | 0.750 | 65006.7 |
916 | 2022-07-21 17:12:34 | dreams | 1 | 48755 | 10 | 0.813 | 59969.2 |
915 | 2022-06-17 23:58:08 | dreams | 3 | 112716 | 872 | 4.670 | 24136.2 |
914 | 2022-06-15 22:46:43 | dreams | 1 | 48755 | 10 | 0.736 | 66243.2 |
913 | 2022-05-25 18:26:27 | dreams | 2 | 82551 | 85 | 2.093 | 39441.5 |
912 | 2022-05-16 08:49:51 | dreams | 1 | 48755 | 10 | 0.920 | 52994.6 |
911 | 2022-05-08 10:39:35 | dreams | 1 | 48755 | 10 | 0.783 | 62266.9 |
910 | 2022-04-16 10:20:08 | dreams | 2 | 82551 | 85 | 2.470 | 33421.5 |
909 | 2022-04-15 16:39:48 | dreams | 2 | 82551 | 85 | 2.796 | 29524.7 |
908 | 2022-04-14 23:38:19 | dreams | 2 | 82551 | 85 | 2.576 | 32046.2 |
907 | 2022-04-14 00:41:13 | dreams | 2 | 82551 | 85 | 2.530 | 32628.9 |
906 | 2022-04-08 09:03:06 | dreams | 2 | 82551 | 85 | 2.720 | 30349.6 |
905 | 2022-04-07 16:29:22 | dreams | 2 | 82551 | 85 | 2.376 | 34743.7 |
904 | 2022-04-07 00:58:41 | dreams | 2 | 82551 | 85 | 2.486 | 33206.4 |
903 | 2022-04-06 05:48:44 | dreams | 2 | 82551 | 85 | 2.106 | 39198.0 |
902 | 2022-04-05 20:05:57 | dreams | 2 | 82551 | 85 | 2.296 | 35954.3 |
901 | 2022-04-04 23:23:34 | dreams | 2 | 82551 | 85 | 2.406 | 34310.5 |
900 | 2022-04-04 10:39:12 | dreams | 2 | 82551 | 85 | 2.670 | 30918.0 |
899 | 2022-04-03 18:48:02 | dreams | 2 | 82551 | 85 | 2.420 | 34112.0 |
898 | 2022-04-02 07:19:27 | dreams | 2 | 82551 | 85 | 2.356 | 35038.6 |
897 | 2022-04-01 16:04:49 | dreams | 2 | 82551 | 85 | 2.330 | 35429.6 |
896 | 2022-04-01 00:48:03 | dreams | 2 | 82551 | 85 | 2.686 | 30733.8 |
895 | 2022-03-30 23:14:40 | dreams | 2 | 82551 | 85 | 2.546 | 32423.8 |
894 | 2022-03-30 11:19:51 | dreams | 2 | 82551 | 85 | 2.716 | 30394.3 |
893 | 2022-03-29 14:39:21 | dreams | 2 | 82551 | 85 | 5.313 | 15537.5 |
892 | 2022-03-29 07:37:54 | dreams | 2 | 82551 | 85 | 2.373 | 34787.6 |
891 | 2022-03-28 09:09:45 | dreams | 2 | 82551 | 85 | 2.906 | 28407.1 |
890 | 2022-03-27 17:11:16 | dreams | 2 | 82551 | 85 | 2.326 | 35490.5 |
889 | 2022-03-27 04:10:14 | dreams | 2 | 82551 | 85 | 2.483 | 33246.5 |