History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"road"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1701 | 2025-07-19 01:13:18 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1700 | 2025-07-17 13:45:31 | road | 1 | 13983 | 15 | 1.500 | 9322.0 |
1699 | 2025-07-07 14:48:56 | road | 1 | 13983 | 15 | 1.030 | 13575.7 |
1698 | 2025-07-03 01:06:55 | road | 1 | 13983 | 15 | 1.593 | 8777.8 |
1697 | 2025-07-02 04:03:43 | road | 2 | 29872 | 264 | 6.220 | 4802.6 |
1696 | 2025-06-30 14:46:05 | road | 2 | 29872 | 264 | 3.656 | 8170.7 |
1695 | 2025-06-30 06:40:11 | road | 2 | 29872 | 264 | 4.610 | 6479.8 |
1694 | 2025-06-29 23:04:44 | road | 1 | 13983 | 15 | 0.690 | 20265.2 |
1693 | 2025-06-29 22:19:05 | road | 2 | 29872 | 264 | 1.890 | 15805.3 |
1692 | 2025-06-28 16:56:28 | road | 2 | 29872 | 264 | 2.313 | 12914.8 |
1691 | 2025-06-27 15:44:38 | road | 1 | 13983 | 15 | 1.576 | 8872.5 |
1690 | 2025-06-23 00:13:17 | road | 2 | 29872 | 264 | 1.063 | 28101.6 |
1689 | 2025-06-18 00:40:49 | road | 1 | 13983 | 15 | 0.986 | 14181.5 |
1688 | 2025-06-12 09:35:36 | road | 1 | 13983 | 15 | 1.450 | 9643.4 |
1687 | 2025-06-12 02:32:47 | road | 1 | 13983 | 15 | 1.156 | 12096.0 |
1686 | 2025-06-11 10:33:48 | road | 2 | 29872 | 264 | 3.263 | 9154.8 |
1685 | 2025-06-10 16:12:19 | road | 2 | 29872 | 264 | 4.830 | 6184.7 |
1684 | 2025-06-08 13:36:50 | road | 2 | 29872 | 264 | 2.220 | 13455.9 |
1683 | 2025-06-06 13:57:48 | road | 1 | 13983 | 15 | 1.016 | 13762.8 |
1682 | 2025-06-06 03:32:01 | road | 2 | 29872 | 264 | 4.296 | 6953.4 |
1681 | 2025-06-05 16:42:25 | road | 1 | 13983 | 15 | 0.263 | 53167.3 |
1680 | 2025-05-31 04:21:47 | road | 1 | 13983 | 15 | 0.923 | 15149.5 |
1679 | 2025-05-29 22:04:29 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1678 | 2025-05-29 05:26:27 | road | 2 | 29872 | 264 | 2.203 | 13559.7 |
1677 | 2025-05-28 23:17:19 | road | 1 | 13983 | 15 | 1.123 | 12451.5 |
1676 | 2025-05-27 22:59:41 | road | 2 | 29872 | 264 | 0.890 | 33564.0 |
1675 | 2025-05-18 06:01:38 | road | 1 | 13983 | 15 | 1.626 | 8599.6 |
1674 | 2025-05-16 01:15:39 | road | 1 | 13983 | 15 | 1.013 | 13803.6 |
1673 | 2025-05-14 21:38:48 | road | 1 | 13983 | 15 | 0.266 | 52567.7 |
1672 | 2025-05-12 09:25:09 | road | 1 | 13983 | 15 | 1.140 | 12265.8 |
1671 | 2025-05-11 09:06:10 | road | 1 | 13983 | 15 | 0.686 | 20383.4 |
1670 | 2025-05-09 11:35:14 | road | 1 | 13983 | 15 | 0.220 | 63559.1 |
1669 | 2025-05-09 05:08:44 | road | 1 | 13983 | 15 | 0.233 | 60012.9 |
1668 | 2025-05-05 05:40:43 | road | 1 | 13983 | 15 | 1.736 | 8054.7 |
1667 | 2025-05-04 10:36:13 | road | 2 | 29872 | 264 | 3.500 | 8534.9 |
1666 | 2025-05-02 13:35:20 | road | 2 | 29872 | 264 | 7.020 | 4255.3 |
1665 | 2025-05-02 00:27:19 | road | 1 | 13983 | 15 | 1.030 | 13575.7 |
1664 | 2025-04-30 14:08:57 | road | 2 | 29872 | 264 | 2.573 | 11609.8 |
1663 | 2025-04-28 22:04:21 | road | 1 | 13983 | 15 | 0.266 | 52567.7 |
1662 | 2025-04-27 21:14:31 | road | 1 | 13983 | 15 | 1.000 | 13983.0 |
1661 | 2025-04-27 20:56:18 | road | 1 | 13983 | 15 | 0.296 | 47239.9 |
1660 | 2025-04-27 20:39:27 | road | 1 | 13983 | 15 | 0.720 | 19420.8 |
1659 | 2025-04-27 06:42:07 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1658 | 2025-04-23 21:26:13 | road | 2 | 29872 | 264 | 4.970 | 6010.5 |
1657 | 2025-04-17 05:22:02 | road | 1 | 13983 | 15 | 0.263 | 53167.3 |
1656 | 2025-04-15 18:43:38 | road | 1 | 13983 | 15 | 0.266 | 52567.7 |
1655 | 2025-04-14 01:06:04 | road | 1 | 13983 | 15 | 0.733 | 19076.4 |
1654 | 2025-04-11 09:35:39 | road | 1 | 13983 | 15 | 1.123 | 12451.5 |
1653 | 2025-04-06 13:27:49 | road | 1 | 13983 | 15 | 1.220 | 11461.5 |
1652 | 2025-03-25 17:01:19 | road | 1 | 13983 | 15 | 1.356 | 10311.9 |
1651 | 2025-03-19 22:31:35 | road | 1 | 13983 | 15 | 0.970 | 14415.5 |
1650 | 2025-03-14 21:54:31 | road | 1 | 13983 | 15 | 0.280 | 49939.3 |
1649 | 2025-03-12 04:05:18 | road | 1 | 13983 | 15 | 0.950 | 14718.9 |
1648 | 2025-03-08 16:44:30 | road | 1 | 13983 | 15 | 0.283 | 49409.9 |
1647 | 2025-03-07 00:49:27 | road | 2 | 29872 | 264 | 2.233 | 13377.5 |
1646 | 2025-03-07 00:46:59 | road | 1 | 13983 | 15 | 1.033 | 13536.3 |
1645 | 2025-03-05 09:04:24 | road | 1 | 13983 | 15 | 0.983 | 14224.8 |
1644 | 2025-02-25 08:39:39 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1643 | 2025-02-25 00:32:38 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1642 | 2025-02-23 03:00:03 | road | 1 | 13983 | 15 | 1.593 | 8777.8 |
1641 | 2025-02-07 04:02:32 | road | 2 | 29872 | 264 | 4.626 | 6457.4 |
1640 | 2025-02-05 19:52:21 | road | 1 | 13983 | 15 | 1.016 | 13762.8 |
1639 | 2025-02-05 06:36:48 | road | 2 | 29872 | 264 | 4.203 | 7107.3 |
1638 | 2025-02-04 23:41:23 | road | 2 | 29872 | 264 | 1.156 | 25840.8 |
1637 | 2025-02-04 20:05:16 | road | 2 | 29872 | 264 | 4.673 | 6392.5 |
1636 | 2025-02-04 19:40:56 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1635 | 2025-01-26 06:14:27 | road | 1 | 13983 | 15 | 0.453 | 30867.5 |
1634 | 2025-01-25 19:01:50 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1633 | 2025-01-24 01:53:21 | road | 1 | 13983 | 15 | 1.686 | 8293.6 |
1632 | 2025-01-13 00:21:56 | road | 1 | 13983 | 15 | 0.703 | 19890.5 |
1631 | 2025-01-06 02:48:46 | road | 2 | 29872 | 264 | 6.220 | 4802.6 |
1630 | 2025-01-06 00:30:19 | road | 2 | 29872 | 264 | 0.860 | 34734.9 |
1629 | 2025-01-05 13:56:04 | road | 2 | 29872 | 264 | 4.373 | 6831.0 |
1628 | 2025-01-05 13:35:37 | road | 1 | 13983 | 15 | 0.236 | 59250.0 |
1627 | 2025-01-02 17:53:25 | road | 2 | 29872 | 264 | 3.670 | 8139.5 |
1626 | 2024-12-30 10:19:55 | road | 2 | 29872 | 264 | 1.406 | 21246.1 |
1625 | 2024-12-27 05:46:48 | road | 1 | 13983 | 15 | 1.000 | 13983.0 |
1624 | 2024-12-26 12:59:11 | road | 1 | 13983 | 15 | 0.673 | 20777.1 |
1623 | 2024-12-25 01:23:54 | road | 1 | 13983 | 15 | 1.376 | 10162.1 |
1622 | 2024-12-21 20:18:41 | road | 1 | 13983 | 15 | 1.516 | 9223.6 |
1621 | 2024-12-06 19:34:37 | road | 2 | 29872 | 264 | 2.546 | 11732.9 |
1620 | 2024-12-06 13:13:35 | road | 2 | 29872 | 264 | 4.610 | 6479.8 |
1619 | 2024-12-06 12:40:19 | road | 1 | 13983 | 15 | 0.936 | 14939.1 |
1618 | 2024-11-27 01:43:51 | road | 1 | 13983 | 15 | 1.750 | 7990.3 |
1617 | 2024-11-26 12:43:53 | road | 1 | 13983 | 15 | 0.280 | 49939.3 |
1616 | 2024-11-24 22:26:15 | road | 1 | 13983 | 15 | 0.453 | 30867.5 |
1615 | 2024-11-08 10:32:43 | road | 2 | 29872 | 264 | 5.250 | 5689.9 |
1614 | 2024-11-06 17:57:56 | road | 2 | 29872 | 264 | 3.236 | 9231.1 |
1613 | 2024-11-06 15:03:50 | road | 2 | 29872 | 264 | 2.296 | 13010.5 |
1612 | 2024-11-06 09:27:28 | road | 2 | 29872 | 264 | 4.393 | 6799.9 |
1611 | 2024-11-06 08:03:31 | road | 1 | 13983 | 15 | 0.216 | 64736.1 |
1610 | 2024-10-30 23:33:23 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1609 | 2024-10-27 21:35:26 | road | 1 | 13983 | 15 | 0.670 | 20870.1 |
1608 | 2024-10-27 13:27:06 | road | 1 | 13983 | 15 | 0.250 | 55932.0 |
1607 | 2024-10-25 22:25:11 | road | 1 | 13983 | 15 | 0.940 | 14875.5 |
1606 | 2024-10-23 22:17:29 | road | 1 | 13983 | 15 | 1.406 | 9945.2 |
1605 | 2024-10-20 12:26:05 | road | 1 | 13983 | 15 | 1.280 | 10924.2 |
1604 | 2024-10-16 08:46:56 | road | 1 | 13983 | 15 | 1.376 | 10162.1 |
1603 | 2024-10-08 13:52:05 | road | 1 | 13983 | 15 | 1.893 | 7386.7 |
1602 | 2024-10-07 11:57:18 | road | 2 | 29872 | 264 | 6.843 | 4365.3 |