History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1388 | 2024-04-11 01:19:27 | doit | 1 | 13983 | 10 | 0.266 | 52567.7 |
1387 | 2024-04-08 15:54:13 | doit | 1 | 13983 | 10 | 0.500 | 27966.0 |
1386 | 2024-04-02 18:06:24 | doit | 1 | 13983 | 10 | 0.860 | 16259.3 |
1385 | 2024-04-01 17:51:32 | doit | 2 | 29872 | 292 | 2.063 | 14479.9 |
1384 | 2024-04-01 16:08:43 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1383 | 2024-03-31 02:56:12 | doit | 1 | 13983 | 10 | 0.263 | 53167.3 |
1382 | 2024-03-28 19:17:39 | doit | 2 | 29872 | 292 | 2.110 | 14157.3 |
1381 | 2024-03-28 17:46:51 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1380 | 2024-03-02 18:19:47 | doit | 2 | 29872 | 292 | 1.076 | 27762.1 |
1379 | 2024-03-02 17:17:04 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1378 | 2024-03-02 13:11:19 | doit | 1 | 13983 | 10 | 0.280 | 49939.3 |
1377 | 2024-02-28 03:11:53 | doit | 2 | 29872 | 292 | 0.906 | 32971.3 |
1376 | 2024-02-26 22:57:35 | doit | 2 | 29872 | 292 | 0.920 | 32469.6 |
1375 | 2024-02-26 20:31:10 | doit | 1 | 13983 | 10 | 0.203 | 68881.8 |
1374 | 2024-02-14 21:11:00 | doit | 2 | 29872 | 292 | 0.733 | 40753.1 |
1373 | 2024-02-01 10:16:15 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1372 | 2024-01-28 16:27:47 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1371 | 2024-01-27 18:38:21 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1370 | 2024-01-08 23:54:13 | doit | 2 | 29872 | 292 | 0.890 | 33564.0 |
1369 | 2024-01-05 12:52:41 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1368 | 2024-01-05 07:31:15 | doit | 1 | 13983 | 10 | 0.236 | 59250.0 |
1367 | 2024-01-04 20:16:50 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1366 | 2024-01-03 16:37:44 | doit | 2 | 29872 | 292 | 1.190 | 25102.5 |
1365 | 2023-12-27 00:05:32 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1364 | 2023-12-20 12:34:30 | doit | 2 | 29872 | 292 | 0.766 | 38997.4 |
1363 | 2023-12-17 07:24:04 | doit | 2 | 29872 | 292 | 1.110 | 26911.7 |
1362 | 2023-12-01 15:47:40 | doit | 1 | 13983 | 10 | 0.236 | 59250.0 |
1361 | 2023-11-24 17:52:31 | doit | 2 | 29872 | 292 | 0.766 | 38997.4 |
1360 | 2023-11-18 01:07:31 | doit | 1 | 13983 | 10 | 0.203 | 68881.8 |
1359 | 2023-11-16 06:07:44 | doit | 2 | 29872 | 292 | 0.843 | 35435.3 |
1358 | 2023-11-11 21:13:25 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1357 | 2023-10-31 06:19:58 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1356 | 2023-10-21 20:50:02 | doit | 2 | 29872 | 292 | 1.030 | 29001.9 |
1355 | 2023-10-20 07:23:27 | doit | 1 | 13983 | 10 | 0.796 | 17566.6 |
1354 | 2023-10-17 00:10:37 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1353 | 2023-10-15 12:55:53 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1352 | 2023-10-11 05:05:13 | doit | 1 | 13983 | 10 | 0.266 | 52567.7 |
1351 | 2023-10-03 17:03:58 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1350 | 2023-09-26 05:08:21 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1349 | 2023-09-25 16:59:24 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1348 | 2023-09-23 23:21:25 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1347 | 2023-09-12 12:52:37 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1346 | 2023-08-17 22:30:11 | doit | 2 | 29872 | 292 | 0.843 | 35435.3 |
1345 | 2023-08-12 08:52:07 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1344 | 2023-06-22 04:22:38 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1343 | 2023-05-14 05:55:30 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1342 | 2023-04-28 11:11:25 | doit | 2 | 29872 | 292 | 0.856 | 34897.2 |
1341 | 2023-03-16 15:24:50 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1340 | 2023-03-07 12:48:27 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1339 | 2023-02-02 16:35:14 | doit | 2 | 29872 | 292 | 0.766 | 38997.4 |
1338 | 2022-12-29 08:05:01 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1337 | 2022-12-11 16:01:55 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1336 | 2022-11-22 15:39:59 | doit | 2 | 29872 | 292 | 0.953 | 31345.2 |
1335 | 2022-11-13 07:38:19 | doit | 2 | 29872 | 292 | 0.733 | 40753.1 |
1334 | 2022-09-17 00:31:03 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1333 | 2022-09-16 22:24:00 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1332 | 2022-09-12 19:30:42 | doit | 2 | 29872 | 292 | 0.813 | 36742.9 |
1331 | 2022-09-12 03:28:42 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1330 | 2022-09-03 18:40:04 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1329 | 2022-09-02 09:25:49 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1328 | 2022-08-31 16:41:24 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1327 | 2022-08-14 23:05:16 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1326 | 2022-08-06 21:06:02 | doit | 1 | 13983 | 10 | 0.236 | 59250.0 |
1325 | 2022-08-05 00:32:09 | doit | 2 | 29872 | 292 | 0.766 | 38997.4 |
1324 | 2022-07-29 07:14:54 | doit | 1 | 13983 | 10 | 0.236 | 59250.0 |
1323 | 2022-07-11 06:19:51 | doit | 2 | 29872 | 292 | 0.750 | 39829.3 |
1322 | 2022-07-03 08:11:48 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1321 | 2022-07-02 21:13:38 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1320 | 2022-06-20 06:18:35 | doit | 2 | 29872 | 292 | 0.736 | 40587.0 |
1319 | 2022-06-16 08:12:02 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1318 | 2022-05-22 15:51:17 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1317 | 2022-05-19 06:14:50 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1316 | 2022-05-08 17:54:30 | doit | 2 | 29872 | 292 | 0.813 | 36742.9 |
1315 | 2022-05-06 13:54:22 | doit | 2 | 29872 | 292 | 0.796 | 37527.6 |
1314 | 2022-04-24 20:36:23 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1313 | 2022-03-25 09:37:52 | doit | 2 | 29872 | 292 | 1.140 | 26203.5 |
1312 | 2022-03-25 01:56:07 | doit | 2 | 29872 | 292 | 0.936 | 31914.5 |
1311 | 2022-03-24 19:53:33 | doit | 2 | 29872 | 292 | 0.813 | 36742.9 |
1310 | 2022-03-23 12:08:09 | doit | 2 | 29872 | 292 | 1.156 | 25840.8 |
1309 | 2022-03-22 23:40:23 | doit | 2 | 29872 | 292 | 1.110 | 26911.7 |
1308 | 2022-03-19 16:03:16 | doit | 2 | 29872 | 292 | 0.843 | 35435.3 |
1307 | 2022-03-18 23:08:30 | doit | 2 | 29872 | 292 | 0.750 | 39829.3 |
1306 | 2022-03-18 03:12:19 | doit | 2 | 29872 | 292 | 0.796 | 37527.6 |
1305 | 2022-03-17 05:26:51 | doit | 2 | 29872 | 292 | 0.750 | 39829.3 |
1304 | 2022-03-16 14:36:48 | doit | 2 | 29872 | 292 | 1.106 | 27009.0 |
1303 | 2022-03-15 08:51:05 | doit | 2 | 29872 | 292 | 0.903 | 33080.8 |
1302 | 2022-03-14 10:16:41 | doit | 2 | 29872 | 292 | 1.093 | 27330.3 |
1301 | 2022-03-13 16:23:59 | doit | 2 | 29872 | 292 | 0.860 | 34734.9 |
1300 | 2022-03-12 06:29:21 | doit | 2 | 29872 | 292 | 0.766 | 38997.4 |
1299 | 2022-03-11 14:39:31 | doit | 2 | 29872 | 292 | 0.783 | 38150.7 |
1298 | 2022-03-11 02:51:56 | doit | 2 | 29872 | 292 | 0.890 | 33564.0 |
1297 | 2022-03-10 20:08:14 | doit | 2 | 29872 | 292 | 0.936 | 31914.5 |
1296 | 2022-03-10 11:06:03 | doit | 2 | 29872 | 292 | 1.030 | 29001.9 |
1295 | 2022-03-09 18:21:48 | doit | 2 | 29872 | 292 | 0.903 | 33080.8 |
1294 | 2022-03-08 20:54:04 | doit | 2 | 29872 | 292 | 0.920 | 32469.6 |
1293 | 2022-03-08 07:11:54 | doit | 2 | 29872 | 292 | 0.846 | 35309.7 |
1292 | 2022-03-07 21:56:40 | doit | 2 | 29872 | 292 | 0.953 | 31345.2 |
1291 | 2022-03-07 08:15:01 | doit | 2 | 29872 | 292 | 0.953 | 31345.2 |
1290 | 2022-03-06 18:12:50 | doit | 2 | 29872 | 292 | 0.860 | 34734.9 |
1289 | 2022-03-06 00:26:35 | doit | 2 | 29872 | 292 | 0.763 | 39150.7 |