History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"human"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1524 | 2024-05-08 17:48:40 | human | 1 | 28756 | 3 | 0.576 | 49923.6 |
1523 | 2024-05-06 08:48:15 | human | 1 | 28756 | 3 | 0.516 | 55728.7 |
1522 | 2024-05-05 11:42:45 | human | 3 | 83667 | 866 | 3.780 | 22134.1 |
1521 | 2024-05-05 11:26:45 | human | 3 | 83667 | 866 | 3.673 | 22778.9 |
1520 | 2024-05-01 06:19:36 | human | 1 | 28756 | 3 | 0.516 | 55728.7 |
1519 | 2024-04-30 04:57:49 | human | 1 | 28756 | 3 | 1.030 | 27918.4 |
1518 | 2024-04-28 06:43:47 | human | 3 | 83667 | 866 | 10.063 | 8314.3 |
1517 | 2024-04-28 06:43:39 | human | 2 | 53800 | 69 | 1.593 | 33772.8 |
1516 | 2024-04-27 08:49:48 | human | 2 | 53800 | 69 | 1.750 | 30742.9 |
1515 | 2024-04-27 08:04:04 | human | 1 | 28756 | 3 | 0.466 | 61708.2 |
1514 | 2024-04-24 05:39:42 | human | 3 | 83667 | 866 | 6.750 | 12395.1 |
1513 | 2024-04-14 17:58:41 | human | 1 | 28756 | 3 | 1.610 | 17860.9 |
1512 | 2024-04-08 05:20:14 | human | 2 | 53800 | 69 | 5.626 | 9562.7 |
1511 | 2024-04-08 05:19:50 | human | 3 | 83667 | 866 | 6.500 | 12871.8 |
1510 | 2024-04-07 16:20:25 | human | 3 | 83667 | 866 | 7.890 | 10604.2 |
1509 | 2024-04-07 02:06:35 | human | 3 | 83667 | 866 | 5.123 | 16331.6 |
1508 | 2024-04-06 05:51:35 | human | 1 | 28756 | 3 | 0.796 | 36125.6 |
1507 | 2024-04-01 17:44:20 | human | 2 | 53800 | 69 | 5.720 | 9405.6 |
1506 | 2024-03-31 17:58:08 | human | 3 | 83667 | 866 | 4.453 | 18788.9 |
1505 | 2024-03-31 17:58:08 | human | 2 | 53800 | 69 | 1.783 | 30173.9 |
1504 | 2024-03-31 16:29:05 | human | 1 | 28756 | 3 | 0.563 | 51076.4 |
1503 | 2024-03-28 19:52:38 | human | 3 | 83667 | 866 | 11.406 | 7335.3 |
1502 | 2024-03-28 19:47:49 | human | 3 | 83667 | 866 | 10.046 | 8328.4 |
1501 | 2024-03-28 19:47:49 | human | 2 | 53800 | 69 | 5.390 | 9981.4 |
1500 | 2024-03-28 19:28:50 | human | 1 | 28756 | 3 | 1.060 | 27128.3 |
1499 | 2024-03-24 14:54:26 | human | 2 | 53800 | 69 | 3.876 | 13880.3 |
1498 | 2024-03-24 14:54:18 | human | 2 | 53800 | 69 | 3.720 | 14462.4 |
1497 | 2024-03-08 23:09:42 | human | 2 | 53800 | 69 | 5.326 | 10101.4 |
1496 | 2024-03-08 23:09:46 | human | 1 | 28756 | 3 | 0.533 | 53951.2 |
1495 | 2024-03-08 23:09:15 | human | 3 | 83667 | 866 | 7.190 | 11636.6 |
1494 | 2024-03-07 09:13:37 | human | 3 | 83667 | 866 | 11.813 | 7082.6 |
1493 | 2024-03-07 09:13:38 | human | 2 | 53800 | 69 | 5.626 | 9562.7 |
1492 | 2024-03-07 04:47:06 | human | 1 | 28756 | 3 | 0.513 | 56054.6 |
1491 | 2024-03-01 13:32:09 | human | 2 | 53800 | 69 | 1.720 | 31279.1 |
1490 | 2024-03-01 13:32:06 | human | 3 | 83667 | 866 | 4.126 | 20278.0 |
1489 | 2024-03-01 13:32:05 | human | 1 | 28756 | 3 | 0.516 | 55728.7 |
1488 | 2024-02-27 08:29:02 | human | 2 | 53800 | 69 | 3.236 | 16625.5 |
1487 | 2024-02-27 08:27:46 | human | 3 | 83667 | 866 | 5.796 | 14435.3 |
1486 | 2024-02-25 18:49:54 | human | 3 | 83667 | 866 | 22.613 | 3700.0 |
1485 | 2024-02-25 18:49:56 | human | 2 | 53800 | 69 | 5.376 | 10007.4 |
1484 | 2024-02-25 18:49:11 | human | 1 | 28756 | 3 | 1.673 | 17188.3 |
1483 | 2024-02-03 23:12:31 | human | 2 | 53800 | 69 | 1.563 | 34421.0 |
1482 | 2024-02-03 23:12:15 | human | 1 | 28756 | 3 | 1.013 | 28387.0 |
1481 | 2024-01-29 05:39:23 | human | 1 | 28756 | 3 | 0.453 | 63479.0 |
1480 | 2024-01-26 05:45:09 | human | 1 | 28756 | 3 | 0.470 | 61183.0 |
1479 | 2024-01-22 08:43:28 | human | 1 | 28756 | 3 | 0.483 | 59536.2 |
1478 | 2024-01-12 10:12:59 | human | 1 | 28756 | 3 | 0.483 | 59536.2 |
1477 | 2024-01-05 05:36:54 | human | 3 | 83667 | 866 | 3.830 | 21845.2 |
1476 | 2024-01-05 05:36:53 | human | 2 | 53800 | 69 | 1.593 | 33772.8 |
1475 | 2024-01-02 05:41:14 | human | 3 | 83667 | 866 | 3.406 | 24564.6 |
1474 | 2024-01-02 05:41:13 | human | 2 | 53800 | 69 | 1.580 | 34050.6 |
1473 | 2023-12-04 06:24:05 | human | 3 | 83667 | 866 | 3.343 | 25027.5 |
1472 | 2023-12-04 06:24:03 | human | 2 | 53800 | 69 | 1.486 | 36204.6 |
1471 | 2023-12-03 09:32:57 | human | 2 | 53800 | 69 | 1.593 | 33772.8 |
1470 | 2023-12-03 09:32:55 | human | 2 | 53800 | 69 | 1.673 | 32157.8 |
1469 | 2023-12-02 10:15:10 | human | 2 | 53800 | 69 | 1.346 | 39970.3 |
1468 | 2023-11-18 11:17:52 | human | 1 | 28756 | 3 | 0.486 | 59168.7 |
1467 | 2023-11-14 10:31:21 | human | 1 | 28756 | 3 | 0.440 | 65354.5 |
1466 | 2023-11-14 00:42:00 | human | 1 | 28756 | 3 | 0.483 | 59536.2 |
1465 | 2023-11-11 09:22:35 | human | 1 | 28756 | 3 | 0.513 | 56054.6 |
1464 | 2023-10-30 05:42:26 | human | 2 | 53800 | 69 | 1.356 | 39675.5 |
1463 | 2023-10-29 16:50:00 | human | 3 | 83667 | 866 | 3.453 | 24230.2 |
1462 | 2023-10-28 00:26:31 | human | 1 | 28756 | 3 | 0.440 | 65354.5 |
1461 | 2023-10-24 16:14:35 | human | 3 | 83667 | 866 | 3.453 | 24230.2 |
1460 | 2023-10-22 16:59:36 | human | 3 | 83667 | 866 | 3.560 | 23502.0 |
1459 | 2023-10-20 19:19:12 | human | 1 | 28756 | 3 | 0.420 | 68466.7 |
1458 | 2023-10-20 12:55:04 | human | 3 | 83667 | 866 | 3.296 | 25384.4 |
1457 | 2023-10-17 22:53:39 | human | 1 | 28756 | 3 | 0.500 | 57512.0 |
1456 | 2023-10-15 05:45:28 | human | 3 | 83667 | 866 | 3.220 | 25983.5 |
1455 | 2023-10-13 18:05:13 | human | 2 | 53800 | 69 | 1.563 | 34421.0 |
1454 | 2023-10-10 15:46:08 | human | 1 | 28756 | 3 | 0.440 | 65354.5 |
1453 | 2023-10-04 11:48:40 | human | 1 | 28756 | 3 | 0.420 | 68466.7 |
1452 | 2023-09-25 21:54:00 | human | 1 | 28756 | 3 | 0.516 | 55728.7 |
1451 | 2023-09-24 02:58:23 | human | 1 | 28756 | 3 | 0.470 | 61183.0 |
1450 | 2023-09-05 16:53:22 | human | 1 | 28756 | 3 | 0.500 | 57512.0 |
1449 | 2023-08-31 06:17:13 | human | 3 | 83667 | 866 | 3.220 | 25983.5 |
1448 | 2023-08-30 19:30:53 | human | 2 | 53800 | 69 | 1.313 | 40974.9 |
1447 | 2023-08-10 13:40:38 | human | 1 | 28756 | 3 | 1.000 | 28756.0 |
1446 | 2023-08-01 01:54:56 | human | 1 | 28756 | 3 | 0.436 | 65954.1 |
1445 | 2023-07-11 21:58:39 | human | 1 | 28756 | 3 | 0.436 | 65954.1 |
1444 | 2023-06-11 01:27:52 | human | 1 | 28756 | 3 | 0.420 | 68466.7 |
1443 | 2023-05-18 03:52:57 | human | 1 | 28756 | 3 | 0.486 | 59168.7 |
1442 | 2023-05-15 21:00:36 | human | 2 | 53800 | 69 | 1.310 | 41068.7 |
1441 | 2023-05-06 21:05:04 | human | 1 | 28756 | 3 | 0.436 | 65954.1 |
1440 | 2023-04-23 16:34:06 | human | 1 | 28756 | 3 | 0.440 | 65354.5 |
1439 | 2023-03-28 12:21:09 | human | 1 | 28756 | 3 | 0.483 | 59536.2 |
1438 | 2023-03-28 03:23:29 | human | 1 | 28756 | 3 | 0.486 | 59168.7 |
1437 | 2023-03-16 22:23:17 | human | 1 | 28756 | 3 | 0.436 | 65954.1 |
1436 | 2023-02-23 22:09:38 | human | 2 | 53800 | 69 | 1.310 | 41068.7 |
1435 | 2023-02-02 11:25:51 | human | 1 | 28756 | 3 | 0.500 | 57512.0 |
1434 | 2023-01-22 03:25:39 | human | 1 | 28756 | 3 | 0.466 | 61708.2 |
1433 | 2023-01-15 00:39:04 | human | 1 | 28756 | 3 | 0.436 | 65954.1 |
1432 | 2023-01-11 05:37:15 | human | 1 | 28756 | 3 | 0.436 | 65954.1 |
1431 | 2022-12-17 15:48:18 | human | 1 | 28756 | 3 | 0.420 | 68466.7 |
1430 | 2022-12-08 00:13:50 | human | 1 | 28756 | 3 | 0.500 | 57512.0 |
1429 | 2022-12-05 06:20:41 | human | 2 | 53800 | 69 | 1.343 | 40059.6 |
1428 | 2022-10-31 01:55:26 | human | 1 | 28756 | 3 | 0.466 | 61708.2 |
1427 | 2022-10-31 00:46:59 | human | 1 | 28756 | 3 | 0.486 | 59168.7 |
1426 | 2022-10-24 08:04:44 | human | 1 | 28756 | 3 | 0.453 | 63479.0 |
1425 | 2022-10-21 20:44:53 | human | 1 | 28756 | 3 | 0.483 | 59536.2 |