History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mike"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1360 | 2024-03-26 19:26:00 | mike | 1 | 13983 | 21 | 0.533 | 26234.5 |
1359 | 2024-03-10 17:57:25 | mike | 1 | 13983 | 21 | 0.263 | 53167.3 |
1358 | 2024-03-05 10:30:42 | mike | 1 | 13983 | 21 | 0.266 | 52567.7 |
1357 | 2024-03-03 18:49:21 | mike | 1 | 13983 | 21 | 0.280 | 49939.3 |
1356 | 2024-03-02 13:01:34 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1355 | 2024-02-28 06:36:04 | mike | 2 | 29872 | 314 | 0.923 | 32364.0 |
1354 | 2024-02-25 16:24:43 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1353 | 2024-02-25 16:17:17 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1352 | 2024-02-19 19:49:07 | mike | 2 | 29872 | 314 | 0.970 | 30795.9 |
1351 | 2024-02-08 14:21:36 | mike | 1 | 13983 | 21 | 3.640 | 3841.5 |
1350 | 2024-02-02 17:34:15 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1349 | 2024-01-16 10:12:22 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1348 | 2024-01-09 08:50:38 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1347 | 2023-11-27 01:28:26 | mike | 2 | 29872 | 314 | 0.830 | 35990.4 |
1346 | 2023-11-11 23:00:54 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1345 | 2023-11-10 09:52:46 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1344 | 2023-11-09 02:00:47 | mike | 2 | 29872 | 314 | 0.906 | 32971.3 |
1343 | 2023-11-08 12:04:15 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1342 | 2023-11-07 23:10:56 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1341 | 2023-11-07 22:12:04 | mike | 2 | 29872 | 314 | 0.826 | 36164.6 |
1340 | 2023-11-07 07:34:26 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1339 | 2023-11-06 15:30:09 | mike | 1 | 13983 | 21 | 0.266 | 52567.7 |
1338 | 2023-10-27 04:42:30 | mike | 2 | 29872 | 314 | 0.766 | 38997.4 |
1337 | 2023-10-25 20:05:53 | mike | 1 | 13983 | 21 | 0.533 | 26234.5 |
1336 | 2023-10-19 16:00:05 | mike | 2 | 29872 | 314 | 0.923 | 32364.0 |
1335 | 2023-10-19 14:11:24 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1334 | 2023-10-16 19:51:17 | mike | 2 | 29872 | 314 | 0.750 | 39829.3 |
1333 | 2023-10-16 18:10:54 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1332 | 2023-10-11 04:06:07 | mike | 2 | 29872 | 314 | 0.986 | 30296.1 |
1331 | 2023-10-10 09:57:26 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1330 | 2023-10-04 06:52:45 | mike | 2 | 29872 | 314 | 0.890 | 33564.0 |
1329 | 2023-10-03 08:48:59 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1328 | 2023-09-25 13:55:17 | mike | 1 | 13983 | 21 | 0.313 | 44674.1 |
1327 | 2023-09-23 15:16:31 | mike | 2 | 29872 | 314 | 0.890 | 33564.0 |
1326 | 2023-09-18 23:07:24 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1325 | 2023-09-14 15:27:34 | mike | 1 | 13983 | 21 | 0.280 | 49939.3 |
1324 | 2023-09-12 08:02:01 | mike | 2 | 29872 | 314 | 0.813 | 36742.9 |
1323 | 2023-09-10 12:47:01 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1322 | 2023-09-01 08:22:12 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1321 | 2023-08-18 15:31:29 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1320 | 2023-07-23 10:10:54 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1319 | 2023-07-23 09:09:00 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1318 | 2023-07-16 19:46:50 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1317 | 2023-06-05 20:47:11 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1316 | 2023-04-11 15:28:24 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1315 | 2023-03-26 18:47:31 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1314 | 2023-03-12 12:07:23 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1313 | 2023-01-25 18:41:28 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1312 | 2023-01-23 07:04:30 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1311 | 2023-01-21 15:15:05 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1310 | 2023-01-19 05:01:25 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1309 | 2023-01-17 08:35:24 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1308 | 2023-01-16 14:19:42 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1307 | 2023-01-11 19:06:51 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1306 | 2023-01-10 18:55:44 | mike | 1 | 13983 | 21 | 0.200 | 69915.0 |
1305 | 2023-01-09 10:41:04 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1304 | 2023-01-06 22:45:14 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1303 | 2023-01-06 13:03:34 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1302 | 2023-01-04 07:41:57 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1301 | 2023-01-03 10:43:28 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1300 | 2023-01-01 04:29:00 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1299 | 2022-12-30 02:46:38 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1298 | 2022-11-24 18:53:02 | mike | 1 | 13983 | 21 | 0.516 | 27098.8 |
1297 | 2022-10-30 22:49:56 | mike | 1 | 13983 | 21 | 0.406 | 34440.9 |
1296 | 2022-10-29 21:11:50 | mike | 1 | 13983 | 21 | 0.406 | 34440.9 |
1295 | 2022-10-28 21:50:27 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1294 | 2022-10-27 20:50:19 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1293 | 2022-10-25 19:17:46 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1292 | 2022-10-24 23:50:05 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1291 | 2022-10-23 23:02:19 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1290 | 2022-10-22 20:53:02 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1289 | 2022-10-20 08:16:47 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1288 | 2022-10-20 02:09:47 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1287 | 2022-10-19 23:29:47 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1286 | 2022-10-13 22:21:51 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1285 | 2022-10-11 23:49:05 | mike | 1 | 13983 | 21 | 0.236 | 59250.0 |
1284 | 2022-10-09 00:02:01 | mike | 1 | 13983 | 21 | 0.390 | 35853.8 |
1283 | 2022-09-26 10:30:31 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1282 | 2022-09-19 21:32:34 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1281 | 2022-09-18 15:58:02 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1280 | 2022-09-17 19:17:27 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1279 | 2022-09-12 06:34:46 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1278 | 2022-09-03 12:29:50 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1277 | 2022-09-02 09:33:07 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1276 | 2022-09-01 21:57:36 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1275 | 2022-08-31 12:09:03 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1274 | 2022-08-29 08:16:30 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1273 | 2022-08-14 04:41:04 | mike | 1 | 13983 | 21 | 0.483 | 28950.3 |
1272 | 2022-08-10 14:34:27 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1271 | 2022-08-07 03:50:40 | mike | 1 | 13983 | 21 | 0.250 | 55932.0 |
1270 | 2022-07-30 04:30:53 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1269 | 2022-07-25 03:17:57 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1268 | 2022-07-17 19:21:15 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |
1267 | 2022-07-03 11:32:19 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1266 | 2022-06-17 03:45:00 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1265 | 2022-06-16 11:31:49 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1264 | 2022-06-13 00:58:40 | mike | 1 | 13983 | 21 | 0.216 | 64736.1 |
1263 | 2022-06-10 18:17:30 | mike | 1 | 13983 | 21 | 0.203 | 68881.8 |
1262 | 2022-06-04 03:06:05 | mike | 1 | 13983 | 21 | 0.220 | 63559.1 |
1261 | 2022-05-18 10:45:43 | mike | 1 | 13983 | 21 | 0.233 | 60012.9 |