History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hall"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1306 | 2024-04-02 18:27:44 | hall | 1 | 13983 | 27 | 0.983 | 14224.8 |
1305 | 2024-04-01 17:41:56 | hall | 2 | 29872 | 331 | 3.173 | 9414.4 |
1304 | 2024-04-01 16:17:11 | hall | 1 | 13983 | 27 | 0.453 | 30867.5 |
1303 | 2024-03-30 19:05:20 | hall | 1 | 13983 | 27 | 0.796 | 17566.6 |
1302 | 2024-03-28 17:54:40 | hall | 1 | 13983 | 27 | 0.266 | 52567.7 |
1301 | 2024-03-28 10:06:44 | hall | 1 | 13983 | 27 | 0.263 | 53167.3 |
1300 | 2024-03-27 22:21:05 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1299 | 2024-03-27 22:20:55 | hall | 2 | 29872 | 331 | 0.796 | 37527.6 |
1298 | 2024-03-02 17:43:50 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1297 | 2024-03-02 15:02:16 | hall | 2 | 29872 | 331 | 4.266 | 7002.3 |
1296 | 2024-03-02 13:24:11 | hall | 1 | 13983 | 27 | 0.516 | 27098.8 |
1295 | 2024-02-26 22:54:36 | hall | 2 | 29872 | 331 | 0.970 | 30795.9 |
1294 | 2024-02-26 19:30:05 | hall | 1 | 13983 | 27 | 0.283 | 49409.9 |
1293 | 2024-02-22 01:02:06 | hall | 2 | 29872 | 331 | 1.000 | 29872.0 |
1292 | 2024-02-20 23:27:01 | hall | 2 | 29872 | 331 | 0.920 | 32469.6 |
1291 | 2024-02-08 06:43:16 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1290 | 2024-01-28 16:22:17 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1289 | 2024-01-28 15:05:59 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1288 | 2024-01-12 06:57:31 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1287 | 2024-01-09 15:14:19 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1286 | 2024-01-04 01:30:50 | hall | 2 | 29872 | 331 | 0.766 | 38997.4 |
1285 | 2023-12-28 13:44:53 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1284 | 2023-12-20 13:59:17 | hall | 2 | 29872 | 331 | 0.750 | 39829.3 |
1283 | 2023-12-17 23:06:23 | hall | 2 | 29872 | 331 | 0.843 | 35435.3 |
1282 | 2023-11-19 17:35:13 | hall | 2 | 29872 | 331 | 0.860 | 34734.9 |
1281 | 2023-11-19 08:16:57 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1280 | 2023-11-17 01:57:47 | hall | 2 | 29872 | 331 | 0.750 | 39829.3 |
1279 | 2023-11-12 12:17:23 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1278 | 2023-11-11 21:55:08 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1277 | 2023-11-06 17:16:58 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1276 | 2023-10-31 07:22:16 | hall | 1 | 13983 | 27 | 0.296 | 47239.9 |
1275 | 2023-10-26 04:16:29 | hall | 1 | 13983 | 27 | 0.500 | 27966.0 |
1274 | 2023-10-24 01:29:43 | hall | 1 | 13983 | 27 | 0.236 | 59250.0 |
1273 | 2023-10-21 14:47:14 | hall | 1 | 13983 | 27 | 0.313 | 44674.1 |
1272 | 2023-10-18 18:50:17 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1271 | 2023-10-13 04:57:30 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1270 | 2023-10-03 16:27:19 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1269 | 2023-09-24 04:20:50 | hall | 1 | 13983 | 27 | 0.266 | 52567.7 |
1268 | 2023-09-23 11:07:22 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1267 | 2023-09-11 21:44:56 | hall | 2 | 29872 | 331 | 0.750 | 39829.3 |
1266 | 2023-08-27 15:31:57 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1265 | 2023-08-18 09:24:49 | hall | 2 | 29872 | 331 | 0.733 | 40753.1 |
1264 | 2023-08-15 12:26:57 | hall | 2 | 29872 | 331 | 0.766 | 38997.4 |
1263 | 2023-07-10 21:47:04 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1262 | 2023-06-30 00:51:13 | hall | 1 | 13983 | 27 | 0.266 | 52567.7 |
1261 | 2023-05-31 21:09:48 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1260 | 2023-04-30 16:55:15 | hall | 2 | 29872 | 331 | 0.766 | 38997.4 |
1259 | 2023-04-07 02:54:09 | hall | 1 | 13983 | 27 | 0.236 | 59250.0 |
1258 | 2023-03-31 12:27:00 | hall | 1 | 13983 | 27 | 0.233 | 60012.9 |
1257 | 2023-03-25 12:10:58 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1256 | 2023-02-13 13:25:57 | hall | 2 | 29872 | 331 | 0.873 | 34217.6 |
1255 | 2023-02-06 05:11:07 | hall | 2 | 29872 | 331 | 0.876 | 34100.5 |
1254 | 2023-01-09 15:31:42 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1253 | 2023-01-01 20:53:09 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1252 | 2022-12-25 10:25:29 | hall | 2 | 29872 | 331 | 0.750 | 39829.3 |
1251 | 2022-11-25 21:05:29 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1250 | 2022-11-18 11:20:42 | hall | 2 | 29872 | 331 | 0.766 | 38997.4 |
1249 | 2022-11-14 14:22:57 | hall | 2 | 29872 | 331 | 0.920 | 32469.6 |
1248 | 2022-11-09 10:22:47 | hall | 2 | 29872 | 331 | 0.860 | 34734.9 |
1247 | 2022-11-08 17:47:51 | hall | 2 | 29872 | 331 | 0.766 | 38997.4 |
1246 | 2022-11-08 03:03:18 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1245 | 2022-10-21 16:00:17 | hall | 2 | 29872 | 331 | 0.936 | 31914.5 |
1244 | 2022-10-21 11:49:34 | hall | 2 | 29872 | 331 | 0.783 | 38150.7 |
1243 | 2022-10-14 19:12:37 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1242 | 2022-09-29 18:12:50 | hall | 2 | 29872 | 331 | 0.750 | 39829.3 |
1241 | 2022-09-21 22:49:53 | hall | 1 | 13983 | 27 | 0.203 | 68881.8 |
1240 | 2022-09-19 23:51:45 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1239 | 2022-09-18 16:38:57 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1238 | 2022-09-17 18:51:33 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1237 | 2022-08-14 04:34:47 | hall | 1 | 13983 | 27 | 0.390 | 35853.8 |
1236 | 2022-08-07 03:40:46 | hall | 1 | 13983 | 27 | 0.266 | 52567.7 |
1235 | 2022-08-06 12:18:07 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1234 | 2022-07-30 04:21:52 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1233 | 2022-07-17 19:55:45 | hall | 1 | 13983 | 27 | 0.203 | 68881.8 |
1232 | 2022-07-11 09:25:59 | hall | 2 | 29872 | 331 | 0.826 | 36164.6 |
1231 | 2022-07-10 05:23:14 | hall | 1 | 13983 | 27 | 0.376 | 37188.8 |
1230 | 2022-07-03 11:27:26 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1229 | 2022-07-02 07:26:35 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1228 | 2022-06-25 22:59:42 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1227 | 2022-06-21 08:50:43 | hall | 2 | 29872 | 331 | 0.736 | 40587.0 |
1226 | 2022-06-16 11:26:48 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1225 | 2022-06-15 20:03:15 | hall | 1 | 13983 | 27 | 0.233 | 60012.9 |
1224 | 2022-06-15 18:33:20 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1223 | 2022-06-08 19:56:31 | hall | 1 | 13983 | 27 | 0.263 | 53167.3 |
1222 | 2022-06-08 13:18:46 | hall | 1 | 13983 | 27 | 0.216 | 64736.1 |
1221 | 2022-06-03 22:04:31 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1220 | 2022-06-01 09:44:40 | hall | 1 | 13983 | 27 | 0.233 | 60012.9 |
1219 | 2022-05-26 03:26:37 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1218 | 2022-05-25 14:33:46 | hall | 1 | 13983 | 27 | 0.280 | 49939.3 |
1217 | 2022-05-18 17:15:23 | hall | 1 | 13983 | 27 | 0.266 | 52567.7 |
1216 | 2022-05-18 06:29:36 | hall | 1 | 13983 | 27 | 0.220 | 63559.1 |
1215 | 2022-05-17 16:07:32 | hall | 1 | 13983 | 27 | 0.250 | 55932.0 |
1214 | 2022-05-16 22:26:35 | hall | 1 | 13983 | 27 | 0.296 | 47239.9 |
1213 | 2022-05-16 10:14:46 | hall | 1 | 13983 | 27 | 0.263 | 53167.3 |
1212 | 2022-05-15 20:49:07 | hall | 1 | 13983 | 27 | 0.263 | 53167.3 |
1211 | 2022-05-14 03:31:56 | hall | 1 | 13983 | 27 | 0.236 | 59250.0 |
1210 | 2022-05-13 20:30:42 | hall | 1 | 13983 | 27 | 0.283 | 49409.9 |
1209 | 2022-05-13 10:34:45 | hall | 1 | 13983 | 27 | 0.296 | 47239.9 |
1208 | 2022-05-13 01:18:22 | hall | 1 | 13983 | 27 | 0.330 | 42372.7 |
1207 | 2022-05-12 12:10:16 | hall | 1 | 13983 | 27 | 0.263 | 53167.3 |