History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1233 | 2024-04-27 09:39:08 | coat | 1 | 13983 | 20 | 0.326 | 42892.6 |
1232 | 2024-04-26 02:12:11 | coat | 1 | 13983 | 20 | 0.263 | 53167.3 |
1231 | 2024-04-19 03:44:54 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1230 | 2024-04-19 01:44:59 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1229 | 2024-04-09 19:43:43 | coat | 2 | 29872 | 382 | 0.893 | 33451.3 |
1228 | 2024-04-03 00:54:45 | coat | 2 | 29872 | 382 | 1.313 | 22751.0 |
1227 | 2024-04-03 00:47:41 | coat | 1 | 13983 | 20 | 0.576 | 24276.0 |
1226 | 2024-04-01 17:51:15 | coat | 2 | 29872 | 382 | 1.080 | 27659.3 |
1225 | 2024-04-01 16:08:45 | coat | 1 | 13983 | 20 | 0.263 | 53167.3 |
1224 | 2024-03-30 18:57:15 | coat | 1 | 13983 | 20 | 0.283 | 49409.9 |
1223 | 2024-03-27 19:26:48 | coat | 1 | 13983 | 20 | 0.283 | 49409.9 |
1222 | 2024-03-24 11:36:39 | coat | 1 | 13983 | 20 | 0.856 | 16335.3 |
1221 | 2024-03-09 19:24:40 | coat | 1 | 13983 | 20 | 0.810 | 17263.0 |
1220 | 2024-03-03 20:24:20 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1219 | 2024-03-02 14:47:38 | coat | 2 | 29872 | 382 | 3.000 | 9957.3 |
1218 | 2024-03-02 13:32:07 | coat | 1 | 13983 | 20 | 0.690 | 20265.2 |
1217 | 2024-02-25 17:08:38 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1216 | 2024-02-09 22:55:00 | coat | 1 | 13983 | 20 | 0.546 | 25609.9 |
1215 | 2024-02-02 15:10:51 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1214 | 2024-02-01 10:39:19 | coat | 1 | 13983 | 20 | 0.530 | 26383.0 |
1213 | 2024-01-24 17:42:06 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1212 | 2024-01-22 04:41:00 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1211 | 2024-01-02 03:13:51 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1210 | 2023-12-15 20:08:52 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1209 | 2023-12-10 20:15:23 | coat | 2 | 29872 | 382 | 0.876 | 34100.5 |
1208 | 2023-12-09 19:19:10 | coat | 2 | 29872 | 382 | 0.763 | 39150.7 |
1207 | 2023-12-06 16:21:23 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1206 | 2023-11-26 12:17:36 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1205 | 2023-11-26 06:08:59 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1204 | 2023-11-24 01:37:19 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1203 | 2023-11-19 09:24:24 | coat | 2 | 29872 | 382 | 2.533 | 11793.1 |
1202 | 2023-11-10 22:25:25 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1201 | 2023-11-09 01:28:14 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1200 | 2023-11-07 08:08:05 | coat | 1 | 13983 | 20 | 0.203 | 68881.8 |
1199 | 2023-10-31 23:06:52 | coat | 2 | 29872 | 382 | 0.763 | 39150.7 |
1198 | 2023-10-31 05:56:56 | coat | 2 | 29872 | 382 | 0.860 | 34734.9 |
1197 | 2023-10-29 10:09:40 | coat | 2 | 29872 | 382 | 0.763 | 39150.7 |
1196 | 2023-10-25 23:54:26 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1195 | 2023-10-24 14:33:44 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1194 | 2023-10-21 10:09:18 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1193 | 2023-10-20 21:16:00 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1192 | 2023-10-19 21:25:53 | coat | 1 | 13983 | 20 | 0.266 | 52567.7 |
1191 | 2023-10-17 17:13:07 | coat | 1 | 13983 | 20 | 0.200 | 69915.0 |
1190 | 2023-10-11 01:51:48 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1189 | 2023-10-03 17:03:04 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1188 | 2023-09-28 15:51:18 | coat | 2 | 29872 | 382 | 0.813 | 36742.9 |
1187 | 2023-09-25 16:52:55 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1186 | 2023-09-21 14:53:15 | coat | 1 | 13983 | 20 | 0.203 | 68881.8 |
1185 | 2023-09-19 20:59:48 | coat | 1 | 13983 | 20 | 0.236 | 59250.0 |
1184 | 2023-09-10 18:00:03 | coat | 2 | 29872 | 382 | 0.970 | 30795.9 |
1183 | 2023-09-07 05:45:26 | coat | 2 | 29872 | 382 | 0.766 | 38997.4 |
1182 | 2023-08-28 06:18:43 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1181 | 2023-08-27 18:38:34 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1180 | 2023-08-26 00:02:54 | coat | 2 | 29872 | 382 | 0.813 | 36742.9 |
1179 | 2023-08-19 16:03:18 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1178 | 2023-08-18 23:51:45 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1177 | 2023-08-10 08:01:02 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1176 | 2023-05-24 10:21:17 | coat | 2 | 29872 | 382 | 0.890 | 33564.0 |
1175 | 2023-05-24 09:33:33 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1174 | 2023-05-20 17:56:29 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1173 | 2023-05-18 06:46:54 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1172 | 2023-03-26 21:48:20 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1171 | 2023-03-16 07:41:18 | coat | 1 | 13983 | 20 | 0.203 | 68881.8 |
1170 | 2023-03-05 17:45:14 | coat | 2 | 29872 | 382 | 0.750 | 39829.3 |
1169 | 2023-03-01 22:55:57 | coat | 2 | 29872 | 382 | 0.733 | 40753.1 |
1168 | 2023-02-18 08:39:33 | coat | 1 | 13983 | 20 | 0.236 | 59250.0 |
1167 | 2023-01-03 04:52:27 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1166 | 2022-12-11 06:34:37 | coat | 2 | 29872 | 382 | 0.796 | 37527.6 |
1165 | 2022-12-03 03:59:34 | coat | 1 | 13983 | 20 | 0.466 | 30006.4 |
1164 | 2022-11-30 18:38:36 | coat | 1 | 13983 | 20 | 0.203 | 68881.8 |
1163 | 2022-11-25 08:11:40 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1162 | 2022-11-15 09:52:21 | coat | 1 | 13983 | 20 | 0.280 | 49939.3 |
1161 | 2022-09-25 21:37:24 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1160 | 2022-09-19 00:05:33 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1159 | 2022-09-10 12:30:36 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1158 | 2022-09-03 13:05:45 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1157 | 2022-08-26 09:23:06 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1156 | 2022-08-15 06:47:16 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1155 | 2022-08-14 06:47:09 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1154 | 2022-08-07 05:56:18 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1153 | 2022-08-05 23:14:11 | coat | 1 | 13983 | 20 | 0.266 | 52567.7 |
1152 | 2022-07-28 19:18:22 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1151 | 2022-07-27 20:57:03 | coat | 2 | 29872 | 382 | 0.780 | 38297.4 |
1150 | 2022-07-17 21:55:53 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1149 | 2022-07-10 07:17:56 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1148 | 2022-07-03 12:56:47 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1147 | 2022-06-25 05:42:53 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1146 | 2022-06-24 20:23:01 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1145 | 2022-06-16 12:56:37 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1144 | 2022-06-04 21:04:55 | coat | 1 | 13983 | 20 | 0.220 | 63559.1 |
1143 | 2022-05-12 22:10:40 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1142 | 2022-05-08 16:55:52 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1141 | 2022-05-06 13:48:39 | coat | 1 | 13983 | 20 | 0.233 | 60012.9 |
1140 | 2022-05-05 08:00:05 | coat | 1 | 13983 | 20 | 0.250 | 55932.0 |
1139 | 2022-05-04 07:05:22 | coat | 1 | 13983 | 20 | 0.266 | 52567.7 |
1138 | 2022-05-03 08:56:06 | coat | 1 | 13983 | 20 | 0.236 | 59250.0 |
1137 | 2022-02-22 11:48:31 | coat | 2 | 29872 | 382 | 1.050 | 28449.5 |
1136 | 2022-02-20 08:07:52 | coat | 2 | 29872 | 382 | 0.906 | 32971.3 |
1135 | 2022-02-08 05:48:57 | coat | 1 | 13983 | 20 | 0.216 | 64736.1 |
1134 | 2022-01-21 05:02:39 | coat | 1 | 13983 | 20 | 0.283 | 49409.9 |