History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ledgers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1538 | 2024-04-29 14:26:37 | ledgers | 1 | 69583 | 8 | 2.766 | 25156.5 |
1537 | 2024-04-26 03:08:55 | ledgers | 2 | 107671 | 82 | 2.813 | 38276.2 |
1536 | 2024-04-25 05:06:04 | ledgers | 3 | 134027 | 736 | 31.283 | 4284.3 |
1535 | 2024-04-24 18:21:27 | ledgers | 3 | 134027 | 736 | 14.690 | 9123.7 |
1534 | 2024-04-23 05:29:15 | ledgers | 3 | 134027 | 736 | 24.580 | 5452.7 |
1533 | 2024-03-27 05:35:46 | ledgers | 1 | 69583 | 8 | 1.063 | 65459.1 |
1532 | 2024-03-18 22:43:49 | ledgers | 3 | 134027 | 736 | 24.533 | 5463.1 |
1531 | 2024-03-18 09:38:49 | ledgers | 3 | 134027 | 736 | 10.530 | 12728.1 |
1530 | 2024-03-18 00:13:59 | ledgers | 3 | 134027 | 736 | 15.093 | 8880.1 |
1529 | 2024-03-14 16:17:23 | ledgers | 3 | 134027 | 736 | 22.063 | 6074.7 |
1528 | 2024-03-14 13:01:37 | ledgers | 3 | 134027 | 736 | 5.673 | 23625.4 |
1527 | 2024-01-12 12:25:55 | ledgers | 1 | 69583 | 8 | 1.093 | 63662.4 |
1526 | 2024-01-01 01:10:56 | ledgers | 1 | 69583 | 8 | 1.236 | 56296.9 |
1525 | 2023-12-20 01:37:57 | ledgers | 1 | 69583 | 8 | 1.110 | 62687.4 |
1524 | 2023-12-15 13:32:07 | ledgers | 2 | 107671 | 82 | 3.220 | 33438.2 |
1523 | 2023-12-13 22:32:27 | ledgers | 2 | 107671 | 82 | 6.890 | 15627.1 |
1522 | 2023-12-13 22:32:25 | ledgers | 3 | 134027 | 736 | 6.923 | 19359.7 |
1521 | 2023-12-01 09:15:28 | ledgers | 1 | 69583 | 8 | 1.186 | 58670.3 |
1520 | 2023-11-28 14:29:28 | ledgers | 3 | 134027 | 736 | 5.780 | 23188.1 |
1519 | 2023-11-20 14:47:12 | ledgers | 1 | 69583 | 8 | 1.190 | 58473.1 |
1518 | 2023-11-19 19:22:40 | ledgers | 1 | 69583 | 8 | 1.060 | 65644.3 |
1517 | 2023-11-11 14:12:24 | ledgers | 1 | 69583 | 8 | 1.123 | 61961.7 |
1516 | 2023-11-11 08:02:21 | ledgers | 1 | 69583 | 8 | 1.046 | 66522.9 |
1515 | 2023-10-23 17:44:14 | ledgers | 1 | 69583 | 8 | 1.076 | 64668.2 |
1514 | 2023-10-15 21:39:55 | ledgers | 1 | 69583 | 8 | 2.220 | 31343.7 |
1513 | 2023-10-06 01:28:26 | ledgers | 1 | 69583 | 8 | 1.046 | 66522.9 |
1512 | 2023-09-29 08:18:55 | ledgers | 3 | 134027 | 736 | 7.690 | 17428.7 |
1511 | 2023-09-29 07:31:30 | ledgers | 1 | 69583 | 8 | 1.063 | 65459.1 |
1510 | 2023-09-25 11:14:47 | ledgers | 3 | 134027 | 736 | 6.653 | 20145.3 |
1509 | 2023-09-25 02:39:32 | ledgers | 1 | 69583 | 8 | 1.173 | 59320.5 |
1508 | 2023-09-13 05:00:33 | ledgers | 2 | 107671 | 82 | 2.843 | 37872.3 |
1507 | 2023-09-10 23:26:56 | ledgers | 1 | 69583 | 8 | 1.233 | 56433.9 |
1506 | 2023-08-28 18:42:17 | ledgers | 3 | 134027 | 736 | 5.956 | 22502.9 |
1505 | 2023-08-13 11:25:01 | ledgers | 3 | 134027 | 736 | 6.046 | 22167.9 |
1504 | 2023-08-12 14:06:34 | ledgers | 3 | 134027 | 736 | 13.143 | 10197.6 |
1503 | 2023-08-09 06:58:56 | ledgers | 3 | 134027 | 736 | 6.843 | 19586.0 |
1502 | 2023-08-08 11:03:31 | ledgers | 3 | 134027 | 736 | 7.280 | 18410.3 |
1501 | 2023-08-02 02:38:30 | ledgers | 1 | 69583 | 8 | 1.046 | 66522.9 |
1500 | 2023-07-15 12:55:02 | ledgers | 3 | 134027 | 736 | 7.310 | 18334.7 |
1499 | 2023-07-14 15:49:16 | ledgers | 3 | 134027 | 736 | 7.220 | 18563.3 |
1498 | 2023-06-23 10:11:57 | ledgers | 3 | 134027 | 736 | 5.706 | 23488.8 |
1497 | 2023-06-15 20:44:31 | ledgers | 3 | 134027 | 736 | 6.250 | 21444.3 |
1496 | 2023-06-14 23:56:24 | ledgers | 3 | 134027 | 736 | 6.000 | 22337.8 |
1495 | 2023-06-13 19:43:42 | ledgers | 3 | 134027 | 736 | 5.826 | 23005.0 |
1494 | 2023-06-12 05:24:09 | ledgers | 1 | 69583 | 8 | 1.046 | 66522.9 |
1493 | 2023-06-11 23:57:23 | ledgers | 3 | 134027 | 736 | 5.876 | 22809.2 |
1492 | 2023-06-08 22:16:51 | ledgers | 1 | 69583 | 8 | 1.170 | 59472.6 |
1491 | 2023-06-03 09:05:13 | ledgers | 2 | 107671 | 82 | 2.856 | 37699.9 |
1490 | 2023-05-14 15:18:31 | ledgers | 3 | 134027 | 736 | 6.263 | 21399.8 |
1489 | 2023-04-25 05:12:18 | ledgers | 1 | 69583 | 8 | 1.220 | 57035.2 |
1488 | 2023-03-13 11:14:56 | ledgers | 2 | 107671 | 82 | 2.766 | 38926.6 |
1487 | 2023-03-06 13:09:06 | ledgers | 1 | 69583 | 8 | 1.030 | 67556.3 |
1486 | 2023-03-02 07:16:30 | ledgers | 3 | 134027 | 736 | 8.470 | 15823.7 |
1485 | 2023-02-26 16:56:25 | ledgers | 3 | 134027 | 736 | 5.610 | 23890.7 |
1484 | 2023-02-21 03:18:41 | ledgers | 3 | 134027 | 736 | 6.483 | 20673.6 |
1483 | 2023-02-15 05:23:12 | ledgers | 1 | 69583 | 8 | 1.093 | 63662.4 |
1482 | 2022-12-17 11:22:52 | ledgers | 2 | 107671 | 82 | 2.763 | 38968.9 |
1481 | 2022-12-13 01:34:36 | ledgers | 1 | 69583 | 8 | 1.203 | 57841.2 |
1480 | 2022-12-01 18:45:59 | ledgers | 3 | 134027 | 736 | 5.983 | 22401.3 |
1479 | 2022-11-18 01:25:11 | ledgers | 1 | 69583 | 8 | 1.203 | 57841.2 |
1478 | 2022-08-18 10:57:39 | ledgers | 1 | 69583 | 8 | 1.076 | 64668.2 |
1477 | 2022-08-09 14:51:23 | ledgers | 2 | 107671 | 82 | 3.296 | 32667.2 |
1476 | 2022-07-25 06:57:35 | ledgers | 1 | 69583 | 8 | 1.093 | 63662.4 |
1475 | 2022-05-13 20:00:32 | ledgers | 3 | 134027 | 736 | 6.736 | 19897.1 |
1474 | 2022-04-28 23:03:05 | ledgers | 3 | 134027 | 736 | 7.190 | 18640.8 |
1473 | 2022-04-26 11:23:15 | ledgers | 3 | 134027 | 736 | 6.750 | 19855.9 |
1472 | 2022-04-20 05:03:19 | ledgers | 3 | 134027 | 736 | 5.800 | 23108.1 |
1471 | 2022-04-18 02:14:59 | ledgers | 3 | 134027 | 736 | 6.596 | 20319.4 |
1470 | 2022-04-09 02:10:08 | ledgers | 1 | 69583 | 8 | 1.076 | 64668.2 |
1469 | 2022-04-04 02:22:41 | ledgers | 3 | 134027 | 736 | 5.533 | 24223.2 |
1468 | 2022-04-03 06:22:19 | ledgers | 1 | 69583 | 8 | 1.093 | 63662.4 |
1467 | 2022-04-02 09:30:58 | ledgers | 3 | 134027 | 736 | 5.656 | 23696.4 |
1466 | 2022-03-29 22:17:50 | ledgers | 3 | 134027 | 736 | 6.610 | 20276.4 |
1465 | 2022-03-26 15:31:14 | ledgers | 3 | 134027 | 736 | 5.876 | 22809.2 |
1464 | 2022-03-22 21:51:29 | ledgers | 3 | 134027 | 736 | 6.640 | 20184.8 |
1463 | 2022-03-22 00:49:39 | ledgers | 3 | 134027 | 736 | 5.966 | 22465.1 |
1462 | 2022-03-12 18:33:16 | ledgers | 2 | 107671 | 82 | 3.346 | 32179.0 |
1461 | 2022-03-10 14:52:54 | ledgers | 2 | 107671 | 82 | 4.080 | 26390.0 |
1460 | 2022-02-14 09:10:19 | ledgers | 3 | 134027 | 736 | 6.733 | 19906.0 |
1459 | 2022-01-20 20:14:47 | ledgers | 3 | 134027 | 736 | 5.720 | 23431.3 |
1458 | 2022-01-08 12:24:00 | ledgers | 1 | 69583 | 8 | 1.233 | 56433.9 |
1457 | 2021-12-23 13:24:12 | ledgers | 3 | 134027 | 736 | 6.986 | 19185.1 |
1456 | 2021-12-19 13:36:06 | ledgers | 1 | 69583 | 8 | 1.250 | 55666.4 |
1455 | 2021-12-02 03:59:59 | ledgers | 2 | 107671 | 82 | 5.876 | 18323.9 |
1454 | 2021-11-08 18:05:52 | ledgers | 1 | 69583 | 8 | 1.173 | 59320.5 |
1453 | 2021-10-07 20:45:27 | ledgers | 3 | 134027 | 736 | 6.390 | 20974.5 |
1452 | 2021-09-26 07:18:16 | ledgers | 1 | 69583 | 8 | 1.123 | 61961.7 |
1451 | 2021-09-22 15:44:08 | ledgers | 2 | 107671 | 82 | 3.170 | 33965.6 |
1450 | 2021-09-17 23:31:05 | ledgers | 3 | 134027 | 736 | 6.763 | 19817.7 |
1449 | 2021-09-12 08:21:43 | ledgers | 1 | 69583 | 8 | 1.063 | 65459.1 |
1448 | 2021-08-24 16:18:55 | ledgers | 1 | 69583 | 8 | 1.076 | 64668.2 |
1447 | 2021-08-12 15:00:11 | ledgers | 3 | 134027 | 736 | 6.016 | 22278.4 |
1446 | 2021-08-12 05:39:13 | ledgers | 2 | 107671 | 82 | 2.766 | 38926.6 |
1445 | 2021-08-10 10:14:51 | ledgers | 3 | 134027 | 736 | 6.623 | 20236.6 |
1444 | 2021-08-10 00:50:02 | ledgers | 2 | 107671 | 82 | 2.826 | 38100.1 |
1443 | 2021-08-07 05:48:42 | ledgers | 1 | 69583 | 8 | 1.143 | 60877.5 |
1442 | 2021-07-26 16:12:51 | ledgers | 1 | 69583 | 8 | 1.220 | 57035.2 |
1441 | 2021-07-22 15:01:39 | ledgers | 2 | 107671 | 82 | 3.080 | 34958.1 |
1440 | 2021-07-17 17:26:25 | ledgers | 3 | 134027 | 736 | 5.890 | 22755.0 |
1439 | 2021-07-05 15:24:43 | ledgers | 3 | 134027 | 736 | 5.953 | 22514.2 |