History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mercery"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
980 | 2024-04-26 13:34:59 | mercery | 1 | 69583 | 4 | 4.186 | 16622.8 |
979 | 2024-04-24 02:18:19 | mercery | 3 | 134027 | 209 | 19.753 | 6785.1 |
978 | 2024-04-23 02:13:24 | mercery | 3 | 134027 | 209 | 6.810 | 19680.9 |
977 | 2024-04-22 02:14:58 | mercery | 3 | 134027 | 209 | 20.750 | 6459.1 |
976 | 2024-04-20 01:42:06 | mercery | 3 | 134027 | 209 | 24.893 | 5384.1 |
975 | 2024-04-19 01:37:08 | mercery | 3 | 134027 | 209 | 6.796 | 19721.5 |
974 | 2024-04-18 01:36:33 | mercery | 3 | 134027 | 209 | 12.046 | 11126.3 |
973 | 2024-04-13 01:27:50 | mercery | 3 | 134027 | 209 | 12.503 | 10719.6 |
972 | 2024-04-12 01:28:14 | mercery | 3 | 134027 | 209 | 8.970 | 14941.7 |
971 | 2024-04-11 01:19:09 | mercery | 3 | 134027 | 209 | 9.656 | 13880.2 |
970 | 2024-04-10 07:18:16 | mercery | 3 | 134027 | 209 | 8.216 | 16312.9 |
969 | 2024-04-10 01:20:58 | mercery | 3 | 134027 | 209 | 24.360 | 5501.9 |
968 | 2024-04-09 01:12:17 | mercery | 3 | 134027 | 209 | 9.796 | 13681.8 |
967 | 2024-04-08 01:17:37 | mercery | 3 | 134027 | 209 | 20.550 | 6522.0 |
966 | 2024-04-07 01:19:23 | mercery | 3 | 134027 | 209 | 18.550 | 7225.2 |
965 | 2024-04-06 01:04:55 | mercery | 3 | 134027 | 209 | 17.706 | 7569.6 |
964 | 2024-04-05 01:11:17 | mercery | 3 | 134027 | 209 | 6.143 | 21817.8 |
963 | 2024-04-04 23:53:47 | mercery | 3 | 134027 | 209 | 15.953 | 8401.4 |
962 | 2024-04-04 01:09:13 | mercery | 3 | 134027 | 209 | 16.783 | 7985.9 |
961 | 2024-04-03 01:03:30 | mercery | 3 | 134027 | 209 | 7.753 | 17287.1 |
960 | 2024-04-02 02:38:42 | mercery | 3 | 134027 | 209 | 6.360 | 21073.4 |
959 | 2024-04-01 16:02:20 | mercery | 3 | 134027 | 209 | 10.203 | 13136.0 |
958 | 2024-04-01 16:02:05 | mercery | 1 | 69583 | 4 | 2.200 | 31628.6 |
957 | 2024-04-01 02:21:17 | mercery | 3 | 134027 | 209 | 19.313 | 6939.7 |
956 | 2024-03-31 02:17:07 | mercery | 3 | 134027 | 209 | 11.266 | 11896.6 |
955 | 2024-03-31 00:08:27 | mercery | 3 | 134027 | 209 | 15.893 | 8433.1 |
954 | 2024-03-30 02:13:32 | mercery | 3 | 134027 | 209 | 7.546 | 17761.3 |
953 | 2024-03-29 02:18:34 | mercery | 3 | 134027 | 209 | 19.796 | 6770.4 |
952 | 2024-03-28 20:58:35 | mercery | 3 | 134027 | 209 | 22.143 | 6052.8 |
951 | 2024-03-28 02:14:50 | mercery | 3 | 134027 | 209 | 7.110 | 18850.5 |
950 | 2024-03-27 02:11:32 | mercery | 3 | 134027 | 209 | 9.016 | 14865.5 |
949 | 2024-03-25 20:16:51 | mercery | 3 | 134027 | 209 | 8.453 | 15855.6 |
948 | 2024-03-24 03:06:27 | mercery | 1 | 69583 | 4 | 2.890 | 24077.2 |
947 | 2024-03-24 02:48:26 | mercery | 3 | 134027 | 209 | 10.280 | 13037.6 |
946 | 2024-03-24 02:48:27 | mercery | 2 | 107671 | 16 | 7.033 | 15309.4 |
945 | 2024-03-24 02:45:45 | mercery | 1 | 69583 | 4 | 1.890 | 36816.4 |
944 | 2024-03-11 00:03:42 | mercery | 3 | 134027 | 209 | 6.703 | 19995.1 |
943 | 2024-03-10 00:08:28 | mercery | 3 | 134027 | 209 | 14.080 | 9519.0 |
942 | 2024-03-09 00:10:15 | mercery | 3 | 134027 | 209 | 14.706 | 9113.8 |
941 | 2024-03-07 23:59:50 | mercery | 3 | 134027 | 209 | 9.814 | 13656.7 |
940 | 2024-03-07 00:06:09 | mercery | 3 | 134027 | 209 | 17.110 | 7833.3 |
939 | 2024-03-06 00:01:21 | mercery | 3 | 134027 | 209 | 16.236 | 8254.9 |
938 | 2024-03-05 00:00:23 | mercery | 3 | 134027 | 209 | 9.156 | 14638.2 |
937 | 2024-03-03 23:55:20 | mercery | 3 | 134027 | 209 | 20.423 | 6562.6 |
936 | 2024-03-02 23:36:58 | mercery | 3 | 134027 | 209 | 6.623 | 20236.6 |
935 | 2024-03-02 18:30:13 | mercery | 3 | 134027 | 209 | 16.826 | 7965.5 |
934 | 2024-03-02 03:11:41 | mercery | 3 | 134027 | 209 | 14.796 | 9058.3 |
933 | 2024-02-26 08:19:47 | mercery | 3 | 134027 | 209 | 8.436 | 15887.5 |
932 | 2024-02-22 10:04:04 | mercery | 3 | 134027 | 209 | 6.420 | 20876.5 |
931 | 2024-02-22 10:04:06 | mercery | 2 | 107671 | 16 | 3.360 | 32044.9 |
930 | 2024-02-21 20:04:54 | mercery | 1 | 69583 | 4 | 1.313 | 52995.4 |
929 | 2024-02-21 08:57:52 | mercery | 3 | 134027 | 209 | 24.266 | 5523.2 |
928 | 2024-02-21 02:20:30 | mercery | 3 | 134027 | 209 | 7.673 | 17467.4 |
927 | 2024-02-20 06:48:11 | mercery | 3 | 134027 | 209 | 8.030 | 16690.8 |
926 | 2024-02-18 21:54:47 | mercery | 3 | 134027 | 209 | 11.596 | 11558.0 |
925 | 2024-02-18 10:25:08 | mercery | 3 | 134027 | 209 | 15.580 | 8602.5 |
924 | 2024-02-18 01:09:42 | mercery | 3 | 134027 | 209 | 6.626 | 20227.4 |
923 | 2024-02-16 00:07:59 | mercery | 3 | 134027 | 209 | 7.296 | 18369.9 |
922 | 2024-01-27 04:09:49 | mercery | 3 | 134027 | 209 | 6.513 | 20578.4 |
921 | 2024-01-23 13:08:42 | mercery | 3 | 134027 | 209 | 16.160 | 8293.8 |
920 | 2024-01-20 14:33:37 | mercery | 3 | 134027 | 209 | 6.986 | 19185.1 |
919 | 2024-01-12 06:26:06 | mercery | 1 | 69583 | 4 | 1.233 | 56433.9 |
918 | 2024-01-10 00:39:29 | mercery | 1 | 69583 | 4 | 1.203 | 57841.2 |
917 | 2023-12-24 06:12:47 | mercery | 1 | 69583 | 4 | 1.186 | 58670.3 |
916 | 2023-12-12 05:04:12 | mercery | 3 | 134027 | 209 | 5.873 | 22820.9 |
915 | 2023-12-11 15:47:58 | mercery | 3 | 134027 | 209 | 5.796 | 23124.1 |
914 | 2023-12-11 06:36:29 | mercery | 3 | 134027 | 209 | 10.016 | 13381.3 |
913 | 2023-12-10 04:55:49 | mercery | 1 | 69583 | 4 | 1.190 | 58473.1 |
912 | 2023-12-10 02:29:41 | mercery | 3 | 134027 | 209 | 6.406 | 20922.1 |
911 | 2023-12-07 10:33:40 | mercery | 1 | 69583 | 4 | 1.080 | 64428.7 |
910 | 2023-12-07 10:33:39 | mercery | 1 | 69583 | 4 | 1.080 | 64428.7 |
909 | 2023-12-06 07:59:20 | mercery | 3 | 134027 | 209 | 11.173 | 11995.6 |
908 | 2023-12-05 10:00:53 | mercery | 3 | 134027 | 209 | 10.593 | 12652.4 |
907 | 2023-12-04 05:54:27 | mercery | 3 | 134027 | 209 | 7.360 | 18210.2 |
906 | 2023-12-03 15:42:51 | mercery | 1 | 69583 | 4 | 2.406 | 28920.6 |
905 | 2023-12-03 00:41:31 | mercery | 3 | 134027 | 209 | 5.876 | 22809.2 |
904 | 2023-12-01 09:05:15 | mercery | 3 | 134027 | 209 | 6.406 | 20922.1 |
903 | 2023-11-26 17:58:02 | mercery | 3 | 134027 | 209 | 5.813 | 23056.4 |
902 | 2023-11-25 20:21:22 | mercery | 3 | 134027 | 209 | 10.313 | 12995.9 |
901 | 2023-11-24 23:32:23 | mercery | 3 | 134027 | 209 | 6.173 | 21711.8 |
900 | 2023-11-23 00:51:12 | mercery | 3 | 134027 | 209 | 8.330 | 16089.7 |
899 | 2023-11-19 15:26:43 | mercery | 1 | 69583 | 4 | 1.030 | 67556.3 |
898 | 2023-11-17 23:32:51 | mercery | 1 | 69583 | 4 | 1.296 | 53690.6 |
897 | 2023-11-06 13:07:44 | mercery | 1 | 69583 | 4 | 1.063 | 65459.1 |
896 | 2023-11-01 08:54:11 | mercery | 1 | 69583 | 4 | 1.063 | 65459.1 |
895 | 2023-10-28 13:51:03 | mercery | 3 | 134027 | 209 | 6.986 | 19185.1 |
894 | 2023-10-15 02:17:08 | mercery | 1 | 69583 | 4 | 1.093 | 63662.4 |
893 | 2023-10-08 13:51:01 | mercery | 1 | 69583 | 4 | 1.063 | 65459.1 |
892 | 2023-09-27 05:44:30 | mercery | 1 | 69583 | 4 | 1.203 | 57841.2 |
891 | 2023-09-14 14:55:07 | mercery | 3 | 134027 | 209 | 6.186 | 21666.2 |
890 | 2023-09-13 14:11:18 | mercery | 3 | 134027 | 209 | 7.220 | 18563.3 |
889 | 2023-09-13 11:54:59 | mercery | 1 | 69583 | 4 | 1.063 | 65459.1 |
888 | 2023-09-12 16:00:11 | mercery | 3 | 134027 | 209 | 6.593 | 20328.7 |
887 | 2023-09-10 20:23:15 | mercery | 3 | 134027 | 209 | 12.783 | 10484.8 |
886 | 2023-09-09 01:55:31 | mercery | 3 | 134027 | 209 | 5.860 | 22871.5 |
885 | 2023-09-05 12:29:00 | mercery | 3 | 134027 | 209 | 7.686 | 17437.8 |
884 | 2023-09-03 16:13:02 | mercery | 3 | 134027 | 209 | 5.906 | 22693.4 |
883 | 2023-09-02 20:53:45 | mercery | 3 | 134027 | 209 | 6.656 | 20136.3 |
882 | 2023-08-31 22:10:06 | mercery | 3 | 134027 | 209 | 6.126 | 21878.4 |
881 | 2023-08-31 01:48:04 | mercery | 3 | 134027 | 209 | 6.623 | 20236.6 |