History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"droughts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
990 | 2024-05-05 04:03:11 | droughts | 1 | 82945 | 4 | 1.486 | 55817.6 |
989 | 2024-04-30 08:11:45 | droughts | 4 | 161609 | 601 | 13.076 | 12359.2 |
988 | 2024-04-27 01:43:32 | droughts | 4 | 161609 | 601 | 41.156 | 3926.7 |
987 | 2024-04-26 16:12:59 | droughts | 4 | 161609 | 601 | 14.563 | 11097.2 |
986 | 2024-04-21 08:46:32 | droughts | 4 | 161609 | 601 | 47.143 | 3428.1 |
985 | 2024-04-10 07:14:12 | droughts | 2 | 121059 | 18 | 7.516 | 16106.8 |
984 | 2024-04-10 07:14:07 | droughts | 1 | 82945 | 4 | 2.360 | 35146.2 |
983 | 2024-04-08 06:29:50 | droughts | 1 | 82945 | 4 | 3.263 | 25419.9 |
982 | 2024-04-06 01:29:07 | droughts | 3 | 146162 | 95 | 25.830 | 5658.6 |
981 | 2024-04-06 00:46:50 | droughts | 4 | 161609 | 601 | 20.173 | 8011.2 |
980 | 2024-04-05 21:20:40 | droughts | 2 | 121059 | 18 | 8.953 | 13521.6 |
979 | 2024-04-05 20:58:18 | droughts | 3 | 146162 | 95 | 8.406 | 17387.8 |
978 | 2024-04-05 20:58:01 | droughts | 4 | 161609 | 601 | 18.376 | 8794.6 |
977 | 2024-04-05 18:20:18 | droughts | 1 | 82945 | 4 | 1.796 | 46183.2 |
976 | 2024-04-01 08:45:13 | droughts | 2 | 121059 | 18 | 4.080 | 29671.3 |
975 | 2024-04-01 08:45:05 | droughts | 1 | 82945 | 4 | 3.156 | 26281.7 |
974 | 2024-03-31 23:42:58 | droughts | 3 | 146162 | 95 | 14.173 | 10312.7 |
973 | 2024-03-31 21:00:02 | droughts | 4 | 161609 | 601 | 15.236 | 10607.0 |
972 | 2024-03-30 14:41:46 | droughts | 4 | 161609 | 601 | 40.143 | 4025.8 |
971 | 2024-03-30 14:41:45 | droughts | 3 | 146162 | 95 | 27.753 | 5266.5 |
970 | 2024-03-30 13:09:36 | droughts | 1 | 82945 | 4 | 1.626 | 51011.7 |
969 | 2024-03-29 22:27:06 | droughts | 2 | 121059 | 18 | 8.670 | 13963.0 |
968 | 2024-03-28 22:30:35 | droughts | 3 | 146162 | 95 | 17.126 | 8534.5 |
967 | 2024-03-28 22:22:31 | droughts | 2 | 121059 | 18 | 14.970 | 8086.8 |
966 | 2024-03-28 22:22:33 | droughts | 3 | 146162 | 95 | 9.343 | 15644.0 |
965 | 2024-03-28 22:22:26 | droughts | 1 | 82945 | 4 | 4.906 | 16906.8 |
964 | 2024-03-27 00:33:14 | droughts | 4 | 161609 | 601 | 17.580 | 9192.8 |
963 | 2024-03-24 18:59:05 | droughts | 4 | 161609 | 601 | 12.843 | 12583.4 |
962 | 2024-03-06 22:55:02 | droughts | 4 | 161609 | 601 | 39.583 | 4082.8 |
961 | 2024-03-06 14:20:46 | droughts | 4 | 161609 | 601 | 20.033 | 8067.1 |
960 | 2024-03-06 13:46:58 | droughts | 1 | 82945 | 4 | 1.310 | 63316.8 |
959 | 2024-03-02 06:44:27 | droughts | 1 | 82945 | 4 | 1.516 | 54713.1 |
958 | 2024-03-01 17:34:04 | droughts | 4 | 161609 | 601 | 14.173 | 11402.6 |
957 | 2024-03-01 00:01:06 | droughts | 1 | 82945 | 4 | 1.486 | 55817.6 |
956 | 2024-02-26 20:18:03 | droughts | 3 | 146162 | 95 | 8.266 | 17682.3 |
955 | 2024-02-25 17:23:31 | droughts | 4 | 161609 | 601 | 24.720 | 6537.6 |
954 | 2024-02-23 01:31:08 | droughts | 3 | 146162 | 95 | 11.860 | 12323.9 |
953 | 2024-02-19 23:04:19 | droughts | 3 | 146162 | 95 | 19.500 | 7495.5 |
952 | 2024-02-14 21:18:07 | droughts | 2 | 121059 | 18 | 4.110 | 29454.7 |
951 | 2024-02-14 21:17:48 | droughts | 3 | 146162 | 95 | 8.156 | 17920.8 |
950 | 2024-02-06 06:21:58 | droughts | 3 | 146162 | 95 | 6.280 | 23274.2 |
949 | 2024-02-05 08:51:10 | droughts | 4 | 161609 | 601 | 15.923 | 10149.4 |
948 | 2024-01-31 06:44:31 | droughts | 2 | 121059 | 18 | 3.670 | 32986.1 |
947 | 2024-01-30 15:54:43 | droughts | 1 | 82945 | 4 | 2.453 | 33813.7 |
946 | 2024-01-30 00:33:17 | droughts | 2 | 121059 | 18 | 3.876 | 31233.0 |
945 | 2024-01-27 17:19:33 | droughts | 3 | 146162 | 95 | 7.956 | 18371.3 |
944 | 2024-01-27 06:05:39 | droughts | 4 | 161609 | 601 | 11.766 | 13735.3 |
943 | 2024-01-26 12:55:29 | droughts | 4 | 161609 | 601 | 11.626 | 13900.7 |
942 | 2024-01-26 11:41:59 | droughts | 4 | 161609 | 601 | 13.126 | 12312.1 |
941 | 2024-01-22 18:34:33 | droughts | 3 | 146162 | 95 | 10.986 | 13304.4 |
940 | 2024-01-19 14:10:45 | droughts | 2 | 121059 | 18 | 3.516 | 34430.9 |
939 | 2024-01-15 18:06:23 | droughts | 3 | 146162 | 95 | 6.563 | 22270.6 |
938 | 2024-01-12 14:12:20 | droughts | 3 | 146162 | 95 | 6.623 | 22068.9 |
937 | 2024-01-12 14:12:18 | droughts | 2 | 121059 | 18 | 3.656 | 33112.4 |
936 | 2023-12-27 18:12:33 | droughts | 1 | 82945 | 4 | 1.406 | 58993.6 |
935 | 2023-12-27 04:03:25 | droughts | 1 | 82945 | 4 | 1.233 | 67270.9 |
934 | 2023-12-23 10:55:16 | droughts | 4 | 161609 | 601 | 10.703 | 15099.4 |
933 | 2023-12-07 16:04:08 | droughts | 4 | 161609 | 601 | 12.846 | 12580.5 |
932 | 2023-12-07 15:54:32 | droughts | 4 | 161609 | 601 | 11.763 | 13738.8 |
931 | 2023-12-07 15:45:28 | droughts | 4 | 161609 | 601 | 11.016 | 14670.4 |
930 | 2023-12-03 15:23:25 | droughts | 4 | 161609 | 601 | 10.846 | 14900.3 |
929 | 2023-12-03 15:17:45 | droughts | 4 | 161609 | 601 | 12.986 | 12444.9 |
928 | 2023-12-03 15:14:16 | droughts | 4 | 161609 | 601 | 13.826 | 11688.8 |
927 | 2023-11-30 07:35:50 | droughts | 4 | 161609 | 601 | 11.313 | 14285.2 |
926 | 2023-11-20 16:42:40 | droughts | 1 | 82945 | 4 | 1.330 | 62364.7 |
925 | 2023-11-19 21:10:51 | droughts | 2 | 121059 | 18 | 3.343 | 36212.7 |
924 | 2023-11-18 09:51:40 | droughts | 4 | 161609 | 601 | 13.050 | 12383.8 |
923 | 2023-11-15 19:52:58 | droughts | 4 | 161609 | 601 | 11.126 | 14525.3 |
922 | 2023-11-15 13:54:40 | droughts | 1 | 82945 | 4 | 2.110 | 39310.4 |
921 | 2023-11-14 03:01:46 | droughts | 4 | 161609 | 601 | 15.236 | 10607.0 |
920 | 2023-11-08 06:40:01 | droughts | 4 | 161609 | 601 | 11.123 | 14529.3 |
919 | 2023-11-04 21:40:00 | droughts | 1 | 82945 | 4 | 2.720 | 30494.5 |
918 | 2023-10-31 11:23:31 | droughts | 2 | 121059 | 18 | 3.140 | 38553.8 |
917 | 2023-10-27 02:16:11 | droughts | 3 | 146162 | 95 | 8.796 | 16616.9 |
916 | 2023-10-24 17:30:26 | droughts | 3 | 146162 | 95 | 6.560 | 22280.8 |
915 | 2023-10-19 19:02:56 | droughts | 3 | 146162 | 95 | 8.750 | 16704.2 |
914 | 2023-10-19 19:02:52 | droughts | 4 | 161609 | 601 | 12.810 | 12615.8 |
913 | 2023-10-19 19:02:58 | droughts | 2 | 121059 | 18 | 3.986 | 30371.0 |
912 | 2023-10-19 14:16:56 | droughts | 1 | 82945 | 4 | 1.500 | 55296.7 |
911 | 2023-10-19 14:05:12 | droughts | 1 | 82945 | 4 | 1.343 | 61761.0 |
910 | 2023-10-18 04:13:26 | droughts | 4 | 161609 | 601 | 28.313 | 5707.9 |
909 | 2023-10-16 14:47:08 | droughts | 4 | 161609 | 601 | 24.563 | 6579.4 |
908 | 2023-10-14 14:05:12 | droughts | 1 | 82945 | 4 | 1.376 | 60279.8 |
907 | 2023-10-13 16:49:00 | droughts | 1 | 82945 | 4 | 1.283 | 64649.3 |
906 | 2023-10-04 04:02:02 | droughts | 4 | 161609 | 601 | 11.736 | 13770.4 |
905 | 2023-09-24 23:30:00 | droughts | 1 | 82945 | 4 | 1.423 | 58288.8 |
904 | 2023-09-14 01:33:20 | droughts | 1 | 82945 | 4 | 1.393 | 59544.1 |
903 | 2023-09-11 20:11:39 | droughts | 4 | 161609 | 601 | 14.970 | 10795.5 |
902 | 2023-08-28 21:49:22 | droughts | 4 | 161609 | 601 | 11.766 | 13735.3 |
901 | 2023-08-15 17:21:02 | droughts | 4 | 161609 | 601 | 10.533 | 15343.1 |
900 | 2023-08-15 07:18:02 | droughts | 1 | 82945 | 4 | 1.236 | 67107.6 |
899 | 2023-08-11 15:30:22 | droughts | 1 | 82945 | 4 | 1.296 | 64000.8 |
898 | 2023-08-08 12:43:54 | droughts | 2 | 121059 | 18 | 3.220 | 37596.0 |
897 | 2023-08-04 16:09:39 | droughts | 3 | 146162 | 95 | 7.296 | 20033.2 |
896 | 2023-05-28 20:06:29 | droughts | 1 | 82945 | 4 | 1.826 | 45424.4 |
895 | 2023-05-12 22:33:29 | droughts | 4 | 161609 | 601 | 10.860 | 14881.1 |
894 | 2023-05-02 09:47:39 | droughts | 1 | 82945 | 4 | 1.376 | 60279.8 |
893 | 2023-04-23 09:45:16 | droughts | 1 | 82945 | 4 | 1.343 | 61761.0 |
892 | 2023-04-22 22:37:01 | droughts | 2 | 121059 | 18 | 3.186 | 37997.2 |
891 | 2023-04-12 20:51:16 | droughts | 3 | 146162 | 95 | 6.123 | 23871.0 |