History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oak"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1624 | 2025-01-05 14:02:28 | oak | 2 | 14084 | 498 | 1.063 | 13249.3 |
1623 | 2025-01-05 13:50:40 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1622 | 2024-12-29 20:15:13 | oak | 1 | 5146 | 10 | 0.123 | 41837.4 |
1621 | 2024-12-28 04:17:47 | oak | 2 | 14084 | 498 | 1.000 | 14084.0 |
1620 | 2024-12-28 02:31:40 | oak | 2 | 14084 | 498 | 1.923 | 7324.0 |
1619 | 2024-12-28 02:30:06 | oak | 1 | 5146 | 10 | 0.203 | 25349.8 |
1618 | 2024-12-26 07:04:28 | oak | 1 | 5146 | 10 | 0.220 | 23390.9 |
1617 | 2024-12-25 09:37:51 | oak | 1 | 5146 | 10 | 0.123 | 41837.4 |
1616 | 2024-12-09 13:40:01 | oak | 2 | 14084 | 498 | 3.940 | 3574.6 |
1615 | 2024-12-06 13:29:14 | oak | 2 | 14084 | 498 | 0.843 | 16707.0 |
1614 | 2024-12-06 12:29:34 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1613 | 2024-11-27 18:28:19 | oak | 2 | 14084 | 498 | 1.703 | 8270.1 |
1612 | 2024-11-27 18:10:33 | oak | 1 | 5146 | 10 | 0.110 | 46781.8 |
1611 | 2024-11-26 06:03:54 | oak | 1 | 5146 | 10 | 0.080 | 64325.0 |
1610 | 2024-11-25 04:42:21 | oak | 1 | 5146 | 10 | 0.110 | 46781.8 |
1609 | 2024-11-16 01:07:07 | oak | 2 | 14084 | 498 | 2.720 | 5177.9 |
1608 | 2024-11-06 09:34:16 | oak | 2 | 14084 | 498 | 2.343 | 6011.1 |
1607 | 2024-11-06 08:07:25 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1606 | 2024-10-29 02:53:49 | oak | 2 | 14084 | 498 | 1.796 | 7841.9 |
1605 | 2024-10-28 15:32:11 | oak | 2 | 14084 | 498 | 0.890 | 15824.7 |
1604 | 2024-10-28 15:18:36 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1603 | 2024-10-27 01:41:17 | oak | 1 | 5146 | 10 | 0.453 | 11359.8 |
1602 | 2024-10-26 03:39:53 | oak | 1 | 5146 | 10 | 0.436 | 11802.8 |
1601 | 2024-10-24 07:14:47 | oak | 1 | 5146 | 10 | 0.500 | 10292.0 |
1600 | 2024-10-21 16:34:32 | oak | 1 | 5146 | 10 | 0.110 | 46781.8 |
1599 | 2024-10-20 15:22:16 | oak | 1 | 5146 | 10 | 0.906 | 5679.9 |
1598 | 2024-10-07 03:38:22 | oak | 1 | 5146 | 10 | 0.610 | 8436.1 |
1597 | 2024-10-02 01:10:26 | oak | 1 | 5146 | 10 | 0.123 | 41837.4 |
1596 | 2024-09-30 23:39:42 | oak | 1 | 5146 | 10 | 0.826 | 6230.0 |
1595 | 2024-09-28 13:12:50 | oak | 2 | 14084 | 498 | 1.250 | 11267.2 |
1594 | 2024-09-28 13:10:14 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1593 | 2024-09-26 21:02:17 | oak | 1 | 5146 | 10 | 0.550 | 9356.4 |
1592 | 2024-09-26 00:29:24 | oak | 1 | 5146 | 10 | 0.670 | 7680.6 |
1591 | 2024-09-07 02:59:33 | oak | 2 | 14084 | 498 | 1.653 | 8520.3 |
1590 | 2024-09-07 02:25:11 | oak | 1 | 5146 | 10 | 0.076 | 67710.5 |
1589 | 2024-09-03 11:30:00 | oak | 2 | 14084 | 498 | 1.953 | 7211.5 |
1588 | 2024-08-30 12:45:03 | oak | 1 | 5146 | 10 | 1.373 | 3748.0 |
1587 | 2024-08-29 12:29:16 | oak | 2 | 14084 | 498 | 3.706 | 3800.3 |
1586 | 2024-08-29 12:03:19 | oak | 1 | 5146 | 10 | 0.080 | 64325.0 |
1585 | 2024-08-27 19:19:23 | oak | 2 | 14084 | 498 | 3.330 | 4229.4 |
1584 | 2024-08-27 18:20:04 | oak | 1 | 5146 | 10 | 0.470 | 10948.9 |
1583 | 2024-08-26 22:51:03 | oak | 1 | 5146 | 10 | 0.966 | 5327.1 |
1582 | 2024-08-22 23:34:35 | oak | 1 | 5146 | 10 | 0.360 | 14294.4 |
1581 | 2024-08-20 00:06:21 | oak | 2 | 14084 | 498 | 3.046 | 4623.8 |
1580 | 2024-08-07 19:42:40 | oak | 1 | 5146 | 10 | 0.626 | 8220.4 |
1579 | 2024-08-02 09:54:32 | oak | 2 | 14084 | 498 | 1.123 | 12541.4 |
1578 | 2024-08-02 03:48:55 | oak | 2 | 14084 | 498 | 1.406 | 10017.1 |
1577 | 2024-08-02 03:41:42 | oak | 1 | 5146 | 10 | 0.623 | 8260.0 |
1576 | 2024-07-29 23:02:53 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1575 | 2024-07-29 21:12:50 | oak | 1 | 5146 | 10 | 0.216 | 23824.1 |
1574 | 2024-07-29 21:12:39 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1573 | 2024-07-28 22:56:08 | oak | 1 | 5146 | 10 | 0.440 | 11695.5 |
1572 | 2024-07-28 10:45:01 | oak | 2 | 14084 | 498 | 1.686 | 8353.5 |
1571 | 2024-07-28 10:38:29 | oak | 1 | 5146 | 10 | 0.233 | 22085.8 |
1570 | 2024-07-27 19:21:34 | oak | 1 | 5146 | 10 | 0.233 | 22085.8 |
1569 | 2024-07-24 15:05:18 | oak | 1 | 5146 | 10 | 0.110 | 46781.8 |
1568 | 2024-07-23 16:41:49 | oak | 2 | 14084 | 498 | 2.140 | 6581.3 |
1567 | 2024-07-21 20:20:40 | oak | 1 | 5146 | 10 | 0.186 | 27666.7 |
1566 | 2024-07-20 18:54:55 | oak | 2 | 14084 | 498 | 1.700 | 8284.7 |
1565 | 2024-07-19 15:24:21 | oak | 1 | 5146 | 10 | 0.140 | 36757.1 |
1564 | 2024-07-18 16:51:25 | oak | 2 | 14084 | 498 | 0.626 | 22498.4 |
1563 | 2024-07-17 20:30:35 | oak | 2 | 14084 | 498 | 0.860 | 16376.7 |
1562 | 2024-07-15 23:18:47 | oak | 2 | 14084 | 498 | 1.546 | 9110.0 |
1561 | 2024-07-13 16:06:00 | oak | 2 | 14084 | 498 | 0.873 | 16132.9 |
1560 | 2024-07-13 13:24:11 | oak | 2 | 14084 | 498 | 2.373 | 5935.1 |
1559 | 2024-07-12 22:49:21 | oak | 2 | 14084 | 498 | 1.546 | 9110.0 |
1558 | 2024-07-11 22:22:08 | oak | 2 | 14084 | 498 | 1.186 | 11875.2 |
1557 | 2024-07-10 10:50:15 | oak | 2 | 14084 | 498 | 0.436 | 32302.8 |
1556 | 2024-07-09 11:56:01 | oak | 2 | 14084 | 498 | 1.156 | 12183.4 |
1555 | 2024-07-06 16:13:17 | oak | 1 | 5146 | 10 | 0.236 | 21805.1 |
1554 | 2024-07-03 03:25:06 | oak | 2 | 14084 | 498 | 1.533 | 9187.2 |
1553 | 2024-07-03 03:01:10 | oak | 1 | 5146 | 10 | 0.703 | 7320.1 |
1552 | 2024-07-01 17:10:03 | oak | 1 | 5146 | 10 | 0.203 | 25349.8 |
1551 | 2024-07-01 17:09:44 | oak | 1 | 5146 | 10 | 0.090 | 57177.8 |
1550 | 2024-07-01 16:56:15 | oak | 1 | 5146 | 10 | 0.266 | 19345.9 |
1549 | 2024-06-29 12:49:14 | oak | 1 | 5146 | 10 | 0.080 | 64325.0 |
1548 | 2024-06-28 17:02:50 | oak | 1 | 5146 | 10 | 0.110 | 46781.8 |
1547 | 2024-06-28 04:51:18 | oak | 1 | 5146 | 10 | 0.330 | 15593.9 |
1546 | 2024-06-28 04:03:31 | oak | 2 | 14084 | 498 | 1.360 | 10355.9 |
1545 | 2024-06-27 14:41:48 | oak | 1 | 5146 | 10 | 0.110 | 46781.8 |
1544 | 2024-06-20 07:46:12 | oak | 1 | 5146 | 10 | 0.220 | 23390.9 |
1543 | 2024-06-16 14:42:11 | oak | 1 | 5146 | 10 | 0.563 | 9140.3 |
1542 | 2024-06-14 19:09:08 | oak | 1 | 5146 | 10 | 0.216 | 23824.1 |
1541 | 2024-06-10 04:37:46 | oak | 1 | 5146 | 10 | 0.126 | 40841.3 |
1540 | 2024-06-04 02:33:52 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1539 | 2024-06-03 07:49:28 | oak | 1 | 5146 | 10 | 0.096 | 53604.2 |
1538 | 2024-06-02 21:38:27 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1537 | 2024-05-30 13:02:27 | oak | 2 | 14084 | 498 | 1.890 | 7451.9 |
1536 | 2024-05-30 07:43:56 | oak | 2 | 14084 | 498 | 1.690 | 8333.7 |
1535 | 2024-05-30 07:18:29 | oak | 1 | 5146 | 10 | 0.110 | 46781.8 |
1534 | 2024-05-29 18:14:55 | oak | 1 | 5146 | 10 | 0.483 | 10654.2 |
1533 | 2024-05-29 04:50:25 | oak | 1 | 5146 | 10 | 0.826 | 6230.0 |
1532 | 2024-05-28 10:07:57 | oak | 1 | 5146 | 10 | 0.220 | 23390.9 |
1531 | 2024-05-09 13:37:09 | oak | 1 | 5146 | 10 | 0.203 | 25349.8 |
1530 | 2024-05-05 02:33:21 | oak | 1 | 5146 | 10 | 0.076 | 67710.5 |
1529 | 2024-05-03 18:37:43 | oak | 1 | 5146 | 10 | 0.376 | 13686.2 |
1528 | 2024-04-30 09:12:33 | oak | 1 | 5146 | 10 | 0.203 | 25349.8 |
1527 | 2024-04-30 04:13:34 | oak | 1 | 5146 | 10 | 0.096 | 53604.2 |
1526 | 2024-04-29 15:22:32 | oak | 1 | 5146 | 10 | 0.093 | 55333.3 |
1525 | 2024-04-29 01:38:30 | oak | 1 | 5146 | 10 | 0.160 | 32162.5 |