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 |
1507 | 2025-05-20 20:16:10 | doit | 1 | 13983 | 10 | 0.216 | 64736.1 |
1506 | 2025-05-18 18:35:41 | doit | 1 | 13983 | 10 | 0.670 | 20870.1 |
1505 | 2025-05-12 03:22:05 | doit | 1 | 13983 | 10 | 0.686 | 20383.4 |
1504 | 2025-05-08 11:40:11 | doit | 1 | 13983 | 10 | 1.733 | 8068.7 |
1503 | 2025-05-07 20:20:49 | doit | 1 | 13983 | 10 | 1.173 | 11920.7 |
1502 | 2025-05-05 04:05:09 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1501 | 2025-05-03 07:32:22 | doit | 1 | 13983 | 10 | 0.483 | 28950.3 |
1500 | 2025-05-02 01:08:02 | doit | 1 | 13983 | 10 | 2.030 | 6888.2 |
1499 | 2025-04-30 04:32:22 | doit | 1 | 13983 | 10 | 0.513 | 27257.3 |
1498 | 2025-04-28 05:46:12 | doit | 1 | 13983 | 10 | 1.563 | 8946.3 |
1497 | 2025-04-23 13:04:58 | doit | 1 | 13983 | 10 | 1.406 | 9945.2 |
1496 | 2025-04-19 19:53:15 | doit | 1 | 13983 | 10 | 0.266 | 52567.7 |
1495 | 2025-04-12 21:29:44 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1494 | 2025-04-11 14:00:38 | doit | 1 | 13983 | 10 | 0.486 | 28771.6 |
1493 | 2025-04-11 03:08:19 | doit | 1 | 13983 | 10 | 0.420 | 33292.9 |
1492 | 2025-04-09 11:24:57 | doit | 2 | 29872 | 292 | 2.936 | 10174.4 |
1491 | 2025-04-08 12:55:18 | doit | 2 | 29872 | 292 | 3.376 | 8848.3 |
1490 | 2025-04-07 11:14:11 | doit | 1 | 13983 | 10 | 0.453 | 30867.5 |
1489 | 2025-03-30 04:54:24 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1488 | 2025-03-28 06:51:09 | doit | 1 | 13983 | 10 | 0.640 | 21848.4 |
1487 | 2025-03-26 07:35:01 | doit | 2 | 29872 | 292 | 4.370 | 6835.7 |
1486 | 2025-03-24 07:12:39 | doit | 2 | 29872 | 292 | 2.360 | 12657.6 |
1485 | 2025-03-21 12:10:53 | doit | 2 | 29872 | 292 | 2.373 | 12588.3 |
1484 | 2025-03-19 20:58:06 | doit | 1 | 13983 | 10 | 1.390 | 10059.7 |
1483 | 2025-03-14 22:42:07 | doit | 1 | 13983 | 10 | 1.686 | 8293.6 |
1482 | 2025-03-06 23:14:10 | doit | 1 | 13983 | 10 | 1.530 | 9139.2 |
1481 | 2025-03-01 13:35:02 | doit | 1 | 13983 | 10 | 1.720 | 8129.7 |
1480 | 2025-02-27 21:27:52 | doit | 1 | 13983 | 10 | 0.266 | 52567.7 |
1479 | 2025-02-27 20:06:22 | doit | 1 | 13983 | 10 | 0.283 | 49409.9 |
1478 | 2025-02-24 14:54:22 | doit | 1 | 13983 | 10 | 1.390 | 10059.7 |
1477 | 2025-02-05 16:12:07 | doit | 2 | 29872 | 292 | 4.143 | 7210.2 |
1476 | 2025-02-05 15:28:18 | doit | 1 | 13983 | 10 | 0.610 | 22923.0 |
1475 | 2025-02-05 12:54:58 | doit | 2 | 29872 | 292 | 5.050 | 5915.2 |
1474 | 2025-02-04 23:26:41 | doit | 2 | 29872 | 292 | 3.860 | 7738.9 |
1473 | 2025-02-04 18:55:55 | doit | 2 | 29872 | 292 | 4.190 | 7129.4 |
1472 | 2025-02-04 18:47:47 | doit | 1 | 13983 | 10 | 0.470 | 29751.1 |
1471 | 2025-01-28 19:12:35 | doit | 1 | 13983 | 10 | 0.233 | 60012.9 |
1470 | 2025-01-26 05:38:46 | doit | 1 | 13983 | 10 | 1.450 | 9643.4 |
1469 | 2025-01-25 09:09:13 | doit | 1 | 13983 | 10 | 0.406 | 34440.9 |
1468 | 2025-01-05 16:37:30 | doit | 2 | 29872 | 292 | 8.843 | 3378.0 |
1467 | 2025-01-05 16:33:04 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1466 | 2024-12-29 07:53:15 | doit | 1 | 13983 | 10 | 0.220 | 63559.1 |
1465 | 2024-12-27 13:01:39 | doit | 1 | 13983 | 10 | 1.766 | 7917.9 |
1464 | 2024-12-27 05:37:13 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1463 | 2024-12-26 20:43:44 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1462 | 2024-12-24 02:00:12 | doit | 1 | 13983 | 10 | 0.876 | 15962.3 |
1461 | 2024-12-09 00:49:20 | doit | 2 | 29872 | 292 | 3.686 | 8104.2 |
1460 | 2024-12-07 00:25:59 | doit | 2 | 29872 | 292 | 8.843 | 3378.0 |
1459 | 2024-12-06 15:10:40 | doit | 2 | 29872 | 292 | 1.046 | 28558.3 |
1458 | 2024-12-06 13:00:56 | doit | 2 | 29872 | 292 | 4.030 | 7412.4 |
1457 | 2024-12-06 12:55:57 | doit | 1 | 13983 | 10 | 1.983 | 7051.4 |
1456 | 2024-11-30 12:22:45 | doit | 2 | 29872 | 292 | 2.250 | 13276.4 |
1455 | 2024-11-29 04:51:15 | doit | 1 | 13983 | 10 | 0.266 | 52567.7 |
1454 | 2024-11-27 01:07:28 | doit | 1 | 13983 | 10 | 1.343 | 10411.8 |
1453 | 2024-11-25 14:12:29 | doit | 1 | 13983 | 10 | 1.126 | 12418.3 |
1452 | 2024-11-21 18:12:44 | doit | 1 | 13983 | 10 | 1.233 | 11340.6 |
1451 | 2024-11-06 09:27:40 | doit | 2 | 29872 | 292 | 1.953 | 15295.4 |
1450 | 2024-11-06 07:39:45 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1449 | 2024-10-30 04:06:18 | doit | 2 | 29872 | 292 | 4.843 | 6168.1 |
1448 | 2024-10-29 20:54:55 | doit | 2 | 29872 | 292 | 7.830 | 3815.1 |
1447 | 2024-10-29 20:41:27 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1446 | 2024-10-28 01:48:58 | doit | 1 | 13983 | 10 | 0.283 | 49409.9 |
1445 | 2024-10-26 12:25:22 | doit | 1 | 13983 | 10 | 0.953 | 14672.6 |
1444 | 2024-10-23 09:21:25 | doit | 1 | 13983 | 10 | 0.686 | 20383.4 |
1443 | 2024-10-20 17:29:37 | doit | 1 | 13983 | 10 | 0.953 | 14672.6 |
1442 | 2024-10-19 01:26:30 | doit | 2 | 29872 | 292 | 2.206 | 13541.3 |
1441 | 2024-10-15 06:40:39 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1440 | 2024-10-07 09:07:53 | doit | 1 | 13983 | 10 | 0.766 | 18254.6 |
1439 | 2024-10-06 23:09:22 | doit | 2 | 29872 | 292 | 5.970 | 5003.7 |
1438 | 2024-10-06 21:39:44 | doit | 2 | 29872 | 292 | 5.076 | 5884.9 |
1437 | 2024-09-29 18:26:36 | doit | 2 | 29872 | 292 | 9.953 | 3001.3 |
1436 | 2024-09-29 18:01:31 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1435 | 2024-09-27 23:58:07 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1434 | 2024-09-26 05:36:46 | doit | 1 | 13983 | 10 | 2.220 | 6298.6 |
1433 | 2024-09-07 01:30:31 | doit | 1 | 13983 | 10 | 3.266 | 4281.4 |
1432 | 2024-08-31 04:08:38 | doit | 1 | 13983 | 10 | 1.736 | 8054.7 |
1431 | 2024-08-30 18:07:51 | doit | 2 | 29872 | 292 | 6.283 | 4754.4 |
1430 | 2024-08-30 16:41:17 | doit | 2 | 29872 | 292 | 8.483 | 3521.4 |
1429 | 2024-08-30 16:39:56 | doit | 1 | 13983 | 10 | 1.283 | 10898.7 |
1428 | 2024-08-28 17:31:50 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1427 | 2024-08-26 16:13:35 | doit | 1 | 13983 | 10 | 1.626 | 8599.6 |
1426 | 2024-08-23 03:25:50 | doit | 1 | 13983 | 10 | 0.983 | 14224.8 |
1425 | 2024-08-19 22:51:29 | doit | 2 | 29872 | 292 | 4.376 | 6826.3 |
1424 | 2024-08-16 02:38:29 | doit | 2 | 29872 | 292 | 4.826 | 6189.8 |
1423 | 2024-08-15 13:02:02 | doit | 2 | 29872 | 292 | 8.783 | 3401.1 |
1422 | 2024-08-12 12:21:55 | doit | 1 | 13983 | 10 | 1.110 | 12597.3 |
1421 | 2024-08-08 03:26:12 | doit | 2 | 29872 | 292 | 3.483 | 8576.5 |
1420 | 2024-08-07 20:22:07 | doit | 1 | 13983 | 10 | 1.250 | 11186.4 |
1419 | 2024-08-07 11:44:55 | doit | 2 | 29872 | 292 | 1.750 | 17069.7 |
1418 | 2024-07-31 17:53:31 | doit | 2 | 29872 | 292 | 2.750 | 10862.5 |
1417 | 2024-07-31 10:47:25 | doit | 2 | 29872 | 292 | 3.013 | 9914.4 |
1416 | 2024-07-31 01:37:45 | doit | 2 | 29872 | 292 | 4.860 | 6146.5 |
1415 | 2024-07-31 00:14:45 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1414 | 2024-07-29 04:57:21 | doit | 1 | 13983 | 10 | 0.250 | 55932.0 |
1413 | 2024-07-27 07:57:41 | doit | 1 | 13983 | 10 | 1.186 | 11790.1 |
1412 | 2024-07-08 06:09:35 | doit | 2 | 29872 | 292 | 2.890 | 10336.3 |
1411 | 2024-07-04 16:31:22 | doit | 1 | 13983 | 10 | 0.923 | 15149.5 |
1410 | 2024-07-04 16:28:06 | doit | 1 | 13983 | 10 | 0.280 | 49939.3 |
1409 | 2024-07-03 05:17:08 | doit | 1 | 13983 | 10 | 0.266 | 52567.7 |
1408 | 2024-07-01 22:48:27 | doit | 1 | 13983 | 10 | 0.283 | 49409.9 |