History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crusted"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1048 | 2024-05-05 19:12:07 | crusted | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 1047 | 2024-05-03 16:35:03 | crusted | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 1046 | 2024-05-01 14:43:55 | crusted | 1 | 69583 | 5 | 1.593 | 43680.5 |
| 1045 | 2024-04-26 13:46:16 | crusted | 3 | 134027 | 664 | 19.220 | 6973.3 |
| 1044 | 2024-04-26 12:47:02 | crusted | 2 | 107671 | 74 | 12.890 | 8353.1 |
| 1043 | 2024-04-26 11:38:50 | crusted | 3 | 134027 | 664 | 12.080 | 11095.0 |
| 1042 | 2024-04-26 03:56:38 | crusted | 3 | 134027 | 664 | 7.673 | 17467.4 |
| 1041 | 2024-04-25 23:18:48 | crusted | 3 | 134027 | 664 | 12.580 | 10654.0 |
| 1040 | 2024-04-25 17:58:43 | crusted | 3 | 134027 | 664 | 13.313 | 10067.4 |
| 1039 | 2024-02-28 22:15:55 | crusted | 3 | 134027 | 664 | 8.373 | 16007.0 |
| 1038 | 2024-02-03 16:45:30 | crusted | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1037 | 2024-01-18 02:29:43 | crusted | 1 | 69583 | 5 | 1.673 | 41591.8 |
| 1036 | 2024-01-13 21:52:12 | crusted | 2 | 107671 | 74 | 3.513 | 30649.3 |
| 1035 | 2023-12-17 17:44:59 | crusted | 2 | 107671 | 74 | 2.953 | 36461.6 |
| 1034 | 2023-11-27 03:54:03 | crusted | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1033 | 2023-11-27 03:04:08 | crusted | 3 | 134027 | 664 | 7.030 | 19065.0 |
| 1032 | 2023-11-26 07:56:56 | crusted | 3 | 134027 | 664 | 6.250 | 21444.3 |
| 1031 | 2023-11-23 18:57:01 | crusted | 2 | 107671 | 74 | 3.220 | 33438.2 |
| 1030 | 2023-11-21 06:51:18 | crusted | 3 | 134027 | 664 | 5.890 | 22755.0 |
| 1029 | 2023-11-16 15:16:35 | crusted | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 1028 | 2023-11-12 05:31:25 | crusted | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1027 | 2023-11-09 16:48:12 | crusted | 3 | 134027 | 664 | 6.733 | 19906.0 |
| 1026 | 2023-10-27 07:44:46 | crusted | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 1025 | 2023-10-26 12:29:00 | crusted | 2 | 107671 | 74 | 3.783 | 28461.8 |
| 1024 | 2023-10-26 12:28:56 | crusted | 3 | 134027 | 664 | 7.143 | 18763.4 |
| 1023 | 2023-10-19 19:38:03 | crusted | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1022 | 2023-10-19 19:29:36 | crusted | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 1021 | 2023-10-14 08:02:36 | crusted | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1020 | 2023-09-30 01:15:33 | crusted | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1019 | 2023-09-24 05:01:35 | crusted | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1018 | 2023-09-13 11:56:12 | crusted | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1017 | 2023-08-22 16:31:52 | crusted | 3 | 134027 | 664 | 5.843 | 22938.0 |
| 1016 | 2023-08-04 04:37:22 | crusted | 3 | 134027 | 664 | 6.470 | 20715.1 |
| 1015 | 2023-07-08 13:38:40 | crusted | 1 | 69583 | 5 | 1.090 | 63837.6 |
| 1014 | 2023-06-28 12:16:44 | crusted | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1013 | 2023-05-05 05:09:29 | crusted | 3 | 134027 | 664 | 5.750 | 23309.0 |
| 1012 | 2023-04-28 23:52:43 | crusted | 3 | 134027 | 664 | 5.953 | 22514.2 |
| 1011 | 2023-04-07 15:14:26 | crusted | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1010 | 2023-04-04 19:11:28 | crusted | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 1009 | 2023-03-31 06:40:11 | crusted | 3 | 134027 | 664 | 7.266 | 18445.8 |
| 1008 | 2023-03-20 11:34:24 | crusted | 3 | 134027 | 664 | 5.703 | 23501.1 |
| 1007 | 2023-03-18 17:12:04 | crusted | 3 | 134027 | 664 | 6.720 | 19944.5 |
| 1006 | 2023-02-25 19:05:43 | crusted | 3 | 134027 | 664 | 6.406 | 20922.1 |
| 1005 | 2023-02-01 10:44:33 | crusted | 3 | 134027 | 664 | 7.126 | 18808.2 |
| 1004 | 2023-02-01 10:19:55 | crusted | 3 | 134027 | 664 | 5.893 | 22743.4 |
| 1003 | 2023-01-27 12:00:22 | crusted | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 1002 | 2023-01-25 01:18:58 | crusted | 3 | 134027 | 664 | 5.923 | 22628.2 |
| 1001 | 2023-01-22 22:14:17 | crusted | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 1000 | 2022-12-31 00:55:11 | crusted | 3 | 134027 | 664 | 6.626 | 20227.4 |
| 999 | 2022-12-26 20:32:12 | crusted | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 998 | 2022-12-19 23:41:46 | crusted | 3 | 134027 | 664 | 6.593 | 20328.7 |
| 997 | 2022-12-16 16:41:06 | crusted | 3 | 134027 | 664 | 7.126 | 18808.2 |
| 996 | 2022-12-10 20:50:42 | crusted | 3 | 134027 | 664 | 6.406 | 20922.1 |
| 995 | 2022-12-08 18:22:41 | crusted | 1 | 69583 | 5 | 2.453 | 28366.5 |
| 994 | 2022-11-26 16:27:07 | crusted | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 993 | 2022-11-13 13:49:38 | crusted | 3 | 134027 | 664 | 6.140 | 21828.5 |
| 992 | 2022-11-12 00:00:37 | crusted | 3 | 134027 | 664 | 6.233 | 21502.8 |
| 991 | 2022-11-08 17:40:53 | crusted | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 990 | 2022-11-08 11:58:25 | crusted | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 989 | 2022-11-02 17:25:02 | crusted | 3 | 134027 | 664 | 5.953 | 22514.2 |
| 988 | 2022-10-24 14:00:22 | crusted | 3 | 134027 | 664 | 7.080 | 18930.4 |
| 987 | 2022-09-23 04:28:41 | crusted | 3 | 134027 | 664 | 5.750 | 23309.0 |
| 986 | 2022-09-16 06:15:13 | crusted | 3 | 134027 | 664 | 5.686 | 23571.4 |
| 985 | 2022-09-11 00:24:09 | crusted | 3 | 134027 | 664 | 5.733 | 23378.2 |
| 984 | 2022-09-08 22:31:11 | crusted | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 983 | 2022-08-28 18:46:53 | crusted | 3 | 134027 | 664 | 5.720 | 23431.3 |
| 982 | 2022-07-30 09:08:15 | crusted | 3 | 134027 | 664 | 6.296 | 21287.6 |
| 981 | 2022-07-23 01:27:23 | crusted | 3 | 134027 | 664 | 6.016 | 22278.4 |
| 980 | 2022-07-21 03:37:51 | crusted | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 979 | 2022-07-20 07:43:02 | crusted | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 978 | 2022-06-26 20:33:35 | crusted | 3 | 134027 | 664 | 5.686 | 23571.4 |
| 977 | 2022-06-10 17:23:12 | crusted | 3 | 134027 | 664 | 6.030 | 22226.7 |
| 976 | 2022-06-10 07:05:22 | crusted | 3 | 134027 | 664 | 5.783 | 23176.0 |
| 975 | 2022-06-03 06:33:13 | crusted | 3 | 134027 | 664 | 6.593 | 20328.7 |
| 974 | 2022-06-02 08:07:54 | crusted | 3 | 134027 | 664 | 5.970 | 22450.1 |
| 973 | 2022-06-01 07:57:43 | crusted | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 972 | 2022-05-27 13:31:52 | crusted | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 971 | 2022-05-24 02:42:35 | crusted | 3 | 134027 | 664 | 5.860 | 22871.5 |
| 970 | 2022-05-20 16:54:14 | crusted | 3 | 134027 | 664 | 6.110 | 21935.7 |
| 969 | 2022-05-17 04:46:58 | crusted | 3 | 134027 | 664 | 7.826 | 17125.9 |
| 968 | 2022-05-10 15:35:51 | crusted | 1 | 69583 | 5 | 1.673 | 41591.8 |
| 967 | 2022-05-08 02:53:57 | crusted | 3 | 134027 | 664 | 5.796 | 23124.1 |
| 966 | 2022-05-06 05:53:23 | crusted | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 965 | 2022-03-20 14:52:12 | crusted | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 964 | 2022-02-16 04:50:51 | crusted | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 963 | 2022-01-17 17:46:01 | crusted | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 962 | 2022-01-17 02:55:30 | crusted | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 961 | 2022-01-16 12:27:52 | crusted | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 960 | 2022-01-16 02:49:59 | crusted | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 959 | 2022-01-15 18:46:13 | crusted | 1 | 69583 | 5 | 1.453 | 47889.2 |
| 958 | 2022-01-15 10:57:05 | crusted | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 957 | 2022-01-14 19:43:34 | crusted | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 956 | 2022-01-14 12:12:48 | crusted | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 955 | 2022-01-13 21:02:49 | crusted | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 954 | 2022-01-05 14:21:47 | crusted | 3 | 134027 | 664 | 6.500 | 20619.5 |
| 953 | 2021-12-28 17:01:09 | crusted | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 952 | 2021-12-17 12:34:55 | crusted | 1 | 69583 | 5 | 1.373 | 50679.5 |
| 951 | 2021-12-17 01:16:53 | crusted | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 950 | 2021-12-16 18:25:05 | crusted | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 949 | 2021-12-15 20:25:48 | crusted | 1 | 69583 | 5 | 1.080 | 64428.7 |