History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crawdad"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1035 | 2024-06-05 07:34:19 | crawdad | 2 | 107671 | 7 | 2.940 | 36622.8 |
1034 | 2024-05-31 09:38:47 | crawdad | 3 | 134027 | 78 | 11.300 | 11860.8 |
1033 | 2024-05-31 00:54:59 | crawdad | 3 | 134027 | 78 | 7.376 | 18170.7 |
1032 | 2024-05-31 00:54:56 | crawdad | 2 | 107671 | 7 | 3.420 | 31482.7 |
1031 | 2024-05-28 13:04:03 | crawdad | 4 | 151207 | 1119 | 69.583 | 2173.0 |
1030 | 2024-05-28 03:41:41 | crawdad | 1 | 69583 | 2 | 5.656 | 12302.5 |
1029 | 2024-05-26 23:33:42 | crawdad | 4 | 151207 | 1119 | 17.686 | 8549.5 |
1028 | 2024-05-26 02:37:42 | crawdad | 4 | 151207 | 1119 | 32.376 | 4670.3 |
1027 | 2024-05-23 08:02:00 | crawdad | 3 | 134027 | 78 | 8.250 | 16245.7 |
1026 | 2024-05-23 08:02:00 | crawdad | 2 | 107671 | 7 | 4.203 | 25617.7 |
1025 | 2024-05-07 23:46:59 | crawdad | 4 | 151207 | 1119 | 21.140 | 7152.6 |
1024 | 2024-05-07 21:21:01 | crawdad | 1 | 69583 | 2 | 2.763 | 25183.9 |
1023 | 2024-05-07 12:48:12 | crawdad | 4 | 151207 | 1119 | 19.970 | 7571.7 |
1022 | 2024-05-07 09:00:49 | crawdad | 1 | 69583 | 2 | 1.266 | 54962.9 |
1021 | 2024-05-07 08:04:20 | crawdad | 3 | 134027 | 78 | 7.826 | 17125.9 |
1020 | 2024-05-07 08:04:15 | crawdad | 2 | 107671 | 7 | 5.033 | 21393.0 |
1019 | 2024-05-07 03:08:36 | crawdad | 4 | 151207 | 1119 | 29.690 | 5092.9 |
1018 | 2024-05-07 00:51:16 | crawdad | 4 | 151207 | 1119 | 20.300 | 7448.6 |
1017 | 2024-05-06 22:40:57 | crawdad | 4 | 151207 | 1119 | 13.016 | 11617.0 |
1016 | 2024-05-05 12:59:19 | crawdad | 1 | 69583 | 2 | 1.236 | 56296.9 |
1015 | 2024-05-04 08:37:07 | crawdad | 3 | 134027 | 78 | 6.596 | 20319.4 |
1014 | 2024-05-04 08:37:05 | crawdad | 2 | 107671 | 7 | 3.393 | 31733.3 |
1013 | 2024-05-02 01:07:21 | crawdad | 4 | 151207 | 1119 | 21.893 | 6906.6 |
1012 | 2024-05-01 06:52:25 | crawdad | 1 | 69583 | 2 | 1.313 | 52995.4 |
1011 | 2024-04-26 04:15:37 | crawdad | 4 | 151207 | 1119 | 17.796 | 8496.7 |
1010 | 2024-04-23 05:54:37 | crawdad | 1 | 69583 | 2 | 1.233 | 56433.9 |
1009 | 2024-04-19 00:20:22 | crawdad | 1 | 69583 | 2 | 2.733 | 25460.3 |
1008 | 2024-04-14 10:14:48 | crawdad | 3 | 134027 | 78 | 19.923 | 6727.2 |
1007 | 2024-04-13 16:30:09 | crawdad | 1 | 69583 | 2 | 1.610 | 43219.3 |
1006 | 2024-04-13 16:30:01 | crawdad | 2 | 107671 | 7 | 7.190 | 14975.1 |
1005 | 2024-04-13 16:29:57 | crawdad | 3 | 134027 | 78 | 8.200 | 16344.8 |
1004 | 2024-04-10 08:28:22 | crawdad | 4 | 151207 | 1119 | 13.736 | 11008.1 |
1003 | 2024-04-08 09:55:41 | crawdad | 4 | 151207 | 1119 | 40.720 | 3713.3 |
1002 | 2024-04-07 17:21:02 | crawdad | 4 | 151207 | 1119 | 27.280 | 5542.8 |
1001 | 2024-04-07 09:42:12 | crawdad | 4 | 151207 | 1119 | 25.830 | 5853.9 |
1000 | 2024-04-06 16:22:21 | crawdad | 4 | 151207 | 1119 | 30.923 | 4889.8 |
999 | 2024-04-06 08:06:09 | crawdad | 4 | 151207 | 1119 | 40.940 | 3693.4 |
998 | 2024-04-06 08:06:01 | crawdad | 1 | 69583 | 2 | 3.483 | 19977.9 |
997 | 2024-03-20 18:39:22 | crawdad | 2 | 107671 | 7 | 4.780 | 22525.3 |
996 | 2024-03-20 18:39:16 | crawdad | 3 | 134027 | 78 | 9.046 | 14816.2 |
995 | 2024-03-19 21:54:19 | crawdad | 1 | 69583 | 2 | 1.640 | 42428.7 |
994 | 2024-03-11 03:42:42 | crawdad | 4 | 151207 | 1119 | 12.560 | 12038.8 |
993 | 2024-03-11 03:42:46 | crawdad | 2 | 107671 | 7 | 7.470 | 14413.8 |
992 | 2024-03-06 23:27:19 | crawdad | 3 | 134027 | 78 | 16.533 | 8106.6 |
991 | 2024-03-06 05:34:18 | crawdad | 3 | 134027 | 78 | 20.563 | 6517.9 |
990 | 2024-03-04 21:12:07 | crawdad | 3 | 134027 | 78 | 21.953 | 6105.2 |
989 | 2024-03-04 21:11:58 | crawdad | 2 | 107671 | 7 | 8.593 | 12530.1 |
988 | 2024-03-04 21:10:00 | crawdad | 1 | 69583 | 2 | 2.703 | 25742.9 |
987 | 2024-03-04 12:44:42 | crawdad | 4 | 151207 | 1119 | 27.283 | 5542.2 |
986 | 2024-03-03 09:33:24 | crawdad | 4 | 151207 | 1119 | 12.876 | 11743.3 |
985 | 2024-03-02 14:22:09 | crawdad | 1 | 69583 | 2 | 3.953 | 17602.6 |
984 | 2024-02-26 23:08:49 | crawdad | 1 | 69583 | 2 | 1.376 | 50569.0 |
983 | 2024-02-26 22:39:22 | crawdad | 3 | 134027 | 78 | 14.876 | 9009.6 |
982 | 2024-02-26 22:39:21 | crawdad | 2 | 107671 | 7 | 3.750 | 28712.3 |
981 | 2024-02-22 06:16:16 | crawdad | 4 | 151207 | 1119 | 20.953 | 7216.5 |
980 | 2024-02-21 15:22:31 | crawdad | 4 | 151207 | 1119 | 14.563 | 10383.0 |
979 | 2024-02-20 19:09:23 | crawdad | 4 | 151207 | 1119 | 11.266 | 13421.5 |
978 | 2024-01-30 21:47:23 | crawdad | 3 | 134027 | 78 | 7.173 | 18684.9 |
977 | 2024-01-30 21:47:15 | crawdad | 2 | 107671 | 7 | 3.766 | 28590.3 |
976 | 2024-01-30 17:54:43 | crawdad | 1 | 69583 | 2 | 1.186 | 58670.3 |
975 | 2024-01-26 07:07:17 | crawdad | 4 | 151207 | 1119 | 13.326 | 11346.8 |
974 | 2024-01-26 06:25:27 | crawdad | 4 | 151207 | 1119 | 12.000 | 12600.6 |
973 | 2024-01-19 00:39:31 | crawdad | 2 | 107671 | 7 | 3.250 | 33129.5 |
972 | 2024-01-17 05:15:58 | crawdad | 4 | 151207 | 1119 | 13.953 | 10836.9 |
971 | 2024-01-10 12:33:18 | crawdad | 4 | 151207 | 1119 | 11.626 | 13005.9 |
970 | 2024-01-08 23:47:17 | crawdad | 1 | 69583 | 2 | 1.060 | 65644.3 |
969 | 2023-12-25 03:15:39 | crawdad | 1 | 69583 | 2 | 1.203 | 57841.2 |
968 | 2023-12-07 05:57:59 | crawdad | 1 | 69583 | 2 | 1.266 | 54962.9 |
967 | 2023-12-07 05:57:57 | crawdad | 1 | 69583 | 2 | 1.263 | 55093.4 |
966 | 2023-12-01 13:34:53 | crawdad | 1 | 69583 | 2 | 1.250 | 55666.4 |
965 | 2023-11-17 04:35:40 | crawdad | 4 | 151207 | 1119 | 10.186 | 14844.6 |
964 | 2023-11-03 05:26:27 | crawdad | 1 | 69583 | 2 | 1.093 | 63662.4 |
963 | 2023-10-29 11:03:27 | crawdad | 2 | 107671 | 7 | 3.406 | 31612.2 |
962 | 2023-10-02 00:35:37 | crawdad | 1 | 69583 | 2 | 1.186 | 58670.3 |
961 | 2023-08-25 23:19:05 | crawdad | 1 | 69583 | 2 | 1.076 | 64668.2 |
960 | 2023-08-18 03:29:39 | crawdad | 4 | 151207 | 1119 | 11.236 | 13457.4 |
959 | 2023-08-07 07:25:31 | crawdad | 2 | 107671 | 7 | 3.000 | 35890.3 |
958 | 2023-05-28 18:05:25 | crawdad | 1 | 69583 | 2 | 1.110 | 62687.4 |
957 | 2023-05-23 00:57:53 | crawdad | 1 | 69583 | 2 | 2.313 | 30083.4 |
956 | 2023-05-04 07:32:17 | crawdad | 4 | 151207 | 1119 | 9.766 | 15483.0 |
955 | 2023-04-19 06:12:19 | crawdad | 2 | 107671 | 7 | 2.890 | 37256.4 |
954 | 2023-03-25 09:11:59 | crawdad | 1 | 69583 | 2 | 1.063 | 65459.1 |
953 | 2023-02-09 05:05:51 | crawdad | 4 | 151207 | 1119 | 9.643 | 15680.5 |
952 | 2023-02-04 10:59:16 | crawdad | 1 | 69583 | 2 | 1.093 | 63662.4 |
951 | 2023-01-23 22:22:11 | crawdad | 2 | 107671 | 7 | 2.796 | 38508.9 |
950 | 2023-01-23 06:05:54 | crawdad | 1 | 69583 | 2 | 1.200 | 57985.8 |
949 | 2023-01-09 12:08:59 | crawdad | 1 | 69583 | 2 | 1.080 | 64428.7 |
948 | 2022-12-19 08:35:57 | crawdad | 1 | 69583 | 2 | 1.063 | 65459.1 |
947 | 2022-11-26 15:24:33 | crawdad | 1 | 69583 | 2 | 1.110 | 62687.4 |
946 | 2022-11-26 12:17:37 | crawdad | 4 | 151207 | 1119 | 10.750 | 14065.8 |
945 | 2022-11-26 12:17:14 | crawdad | 4 | 151207 | 1119 | 11.500 | 13148.4 |
944 | 2022-11-26 12:16:53 | crawdad | 4 | 151207 | 1119 | 10.266 | 14728.9 |
943 | 2022-11-21 21:35:51 | crawdad | 4 | 151207 | 1119 | 9.950 | 15196.7 |
942 | 2022-11-18 22:23:20 | crawdad | 1 | 69583 | 2 | 1.076 | 64668.2 |
941 | 2022-11-06 04:11:57 | crawdad | 1 | 69583 | 2 | 1.076 | 64668.2 |
940 | 2022-11-04 10:44:32 | crawdad | 2 | 107671 | 7 | 3.000 | 35890.3 |
939 | 2022-10-13 12:42:12 | crawdad | 1 | 69583 | 2 | 1.093 | 63662.4 |
938 | 2022-09-13 17:48:55 | crawdad | 1 | 69583 | 2 | 1.126 | 61796.6 |
937 | 2022-06-04 20:26:22 | crawdad | 1 | 69583 | 2 | 1.093 | 63662.4 |
936 | 2022-05-10 18:59:12 | crawdad | 2 | 107671 | 7 | 3.013 | 35735.5 |