History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aisle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1778 | 2024-05-10 05:27:07 | aisle | 3 | 83667 | 1528 | 3.826 | 21868.0 |
1777 | 2024-05-09 14:09:22 | aisle | 3 | 83667 | 1528 | 7.470 | 11200.4 |
1776 | 2024-05-09 05:40:48 | aisle | 3 | 83667 | 1528 | 14.750 | 5672.3 |
1775 | 2024-05-08 13:12:54 | aisle | 3 | 83667 | 1528 | 6.220 | 13451.3 |
1774 | 2024-05-08 05:29:18 | aisle | 3 | 83667 | 1528 | 4.453 | 18788.9 |
1773 | 2024-05-07 12:38:12 | aisle | 3 | 83667 | 1528 | 9.983 | 8380.9 |
1772 | 2024-05-07 05:41:38 | aisle | 3 | 83667 | 1528 | 5.200 | 16089.8 |
1771 | 2024-05-06 13:16:08 | aisle | 3 | 83667 | 1528 | 4.830 | 17322.4 |
1770 | 2024-05-06 13:03:15 | aisle | 3 | 83667 | 1528 | 4.390 | 19058.5 |
1769 | 2024-05-06 05:20:44 | aisle | 3 | 83667 | 1528 | 5.016 | 16680.0 |
1768 | 2024-05-05 11:03:42 | aisle | 3 | 83667 | 1528 | 4.953 | 16892.2 |
1767 | 2024-05-05 10:47:12 | aisle | 3 | 83667 | 1528 | 4.533 | 18457.3 |
1766 | 2024-05-05 10:46:36 | aisle | 3 | 83667 | 1528 | 6.030 | 13875.1 |
1765 | 2024-05-05 04:46:33 | aisle | 3 | 83667 | 1528 | 3.703 | 22594.4 |
1764 | 2024-05-05 03:39:24 | aisle | 3 | 83667 | 1528 | 3.690 | 22674.0 |
1763 | 2024-05-04 15:36:26 | aisle | 3 | 83667 | 1528 | 4.466 | 18734.2 |
1762 | 2024-05-04 06:42:24 | aisle | 3 | 83667 | 1528 | 4.890 | 17109.8 |
1761 | 2024-05-04 06:02:10 | aisle | 3 | 83667 | 1528 | 6.686 | 12513.8 |
1760 | 2024-05-04 05:45:09 | aisle | 3 | 83667 | 1528 | 4.920 | 17005.5 |
1759 | 2024-05-04 04:50:27 | aisle | 1 | 28756 | 5 | 0.530 | 54256.6 |
1758 | 2024-05-03 13:45:11 | aisle | 3 | 83667 | 1528 | 5.250 | 15936.6 |
1757 | 2024-05-03 05:32:34 | aisle | 3 | 83667 | 1528 | 9.970 | 8391.9 |
1756 | 2024-05-02 13:05:42 | aisle | 3 | 83667 | 1528 | 8.236 | 10158.7 |
1755 | 2024-05-02 05:22:05 | aisle | 3 | 83667 | 1528 | 12.016 | 6963.0 |
1754 | 2024-05-01 21:43:58 | aisle | 2 | 53800 | 80 | 1.936 | 27789.3 |
1753 | 2024-05-01 21:43:54 | aisle | 1 | 28756 | 5 | 1.093 | 26309.2 |
1752 | 2024-05-01 21:43:49 | aisle | 2 | 53800 | 80 | 1.670 | 32215.6 |
1751 | 2024-05-01 21:43:25 | aisle | 3 | 83667 | 1528 | 4.576 | 18283.9 |
1750 | 2024-05-01 15:45:59 | aisle | 3 | 83667 | 1528 | 6.500 | 12871.8 |
1749 | 2024-04-30 19:01:24 | aisle | 1 | 28756 | 5 | 0.546 | 52666.7 |
1748 | 2024-04-30 15:49:21 | aisle | 3 | 83667 | 1528 | 8.906 | 9394.5 |
1747 | 2024-04-30 11:28:20 | aisle | 3 | 83667 | 1528 | 10.500 | 7968.3 |
1746 | 2024-04-29 15:51:54 | aisle | 3 | 83667 | 1528 | 4.423 | 18916.3 |
1745 | 2024-04-29 13:20:25 | aisle | 1 | 28756 | 5 | 0.533 | 53951.2 |
1744 | 2024-04-28 18:51:40 | aisle | 1 | 28756 | 5 | 0.533 | 53951.2 |
1743 | 2024-04-28 16:21:21 | aisle | 3 | 83667 | 1528 | 4.016 | 20833.4 |
1742 | 2024-04-28 11:39:45 | aisle | 3 | 83667 | 1528 | 6.906 | 12115.1 |
1741 | 2024-04-27 07:39:29 | aisle | 1 | 28756 | 5 | 0.516 | 55728.7 |
1740 | 2024-04-27 05:06:48 | aisle | 3 | 83667 | 1528 | 9.266 | 9029.5 |
1739 | 2024-04-26 05:48:24 | aisle | 3 | 83667 | 1528 | 7.270 | 11508.5 |
1738 | 2024-04-25 11:02:26 | aisle | 3 | 83667 | 1528 | 9.513 | 8795.0 |
1737 | 2024-04-24 15:57:15 | aisle | 1 | 28756 | 5 | 0.563 | 51076.4 |
1736 | 2024-04-24 11:00:44 | aisle | 3 | 83667 | 1528 | 11.110 | 7530.8 |
1735 | 2024-04-23 11:04:24 | aisle | 3 | 83667 | 1528 | 11.456 | 7303.3 |
1734 | 2024-04-22 14:43:21 | aisle | 3 | 83667 | 1528 | 9.250 | 9045.1 |
1733 | 2024-04-21 14:18:41 | aisle | 3 | 83667 | 1528 | 11.453 | 7305.2 |
1732 | 2024-04-20 14:38:03 | aisle | 3 | 83667 | 1528 | 10.860 | 7704.1 |
1731 | 2024-04-20 11:26:18 | aisle | 3 | 83667 | 1528 | 10.923 | 7659.7 |
1730 | 2024-04-20 01:05:57 | aisle | 3 | 83667 | 1528 | 15.016 | 5571.9 |
1729 | 2024-04-19 18:00:46 | aisle | 3 | 83667 | 1528 | 12.110 | 6908.9 |
1728 | 2024-04-19 11:33:05 | aisle | 3 | 83667 | 1528 | 10.563 | 7920.8 |
1727 | 2024-04-19 01:09:43 | aisle | 3 | 83667 | 1528 | 9.313 | 8983.9 |
1726 | 2024-04-18 13:51:47 | aisle | 3 | 83667 | 1528 | 14.406 | 5807.8 |
1725 | 2024-04-18 02:34:07 | aisle | 3 | 83667 | 1528 | 12.860 | 6506.0 |
1724 | 2024-04-17 17:17:15 | aisle | 3 | 83667 | 1528 | 4.546 | 18404.5 |
1723 | 2024-04-17 02:55:42 | aisle | 3 | 83667 | 1528 | 3.610 | 23176.5 |
1722 | 2024-04-16 23:48:48 | aisle | 3 | 83667 | 1528 | 14.376 | 5819.9 |
1721 | 2024-04-16 11:24:11 | aisle | 3 | 83667 | 1528 | 16.766 | 4990.3 |
1720 | 2024-04-16 00:18:34 | aisle | 3 | 83667 | 1528 | 5.720 | 14627.1 |
1719 | 2024-04-15 07:32:19 | aisle | 3 | 83667 | 1528 | 17.033 | 4912.1 |
1718 | 2024-04-14 23:50:46 | aisle | 3 | 83667 | 1528 | 8.626 | 9699.4 |
1717 | 2024-04-14 23:25:20 | aisle | 1 | 28756 | 5 | 2.080 | 13825.0 |
1716 | 2024-04-14 23:24:12 | aisle | 1 | 28756 | 5 | 2.593 | 11089.9 |
1715 | 2024-04-14 11:58:53 | aisle | 3 | 83667 | 1528 | 14.123 | 5924.2 |
1714 | 2024-04-14 00:11:37 | aisle | 3 | 83667 | 1528 | 6.050 | 13829.3 |
1713 | 2024-04-13 10:29:06 | aisle | 3 | 83667 | 1528 | 3.670 | 22797.5 |
1712 | 2024-04-12 12:23:00 | aisle | 3 | 83667 | 1528 | 9.580 | 8733.5 |
1711 | 2024-04-12 11:26:34 | aisle | 3 | 83667 | 1528 | 10.046 | 8328.4 |
1710 | 2024-04-11 10:56:20 | aisle | 3 | 83667 | 1528 | 4.326 | 19340.5 |
1709 | 2024-04-10 07:56:06 | aisle | 3 | 83667 | 1528 | 12.393 | 6751.1 |
1708 | 2024-04-09 23:17:54 | aisle | 3 | 83667 | 1528 | 14.906 | 5613.0 |
1707 | 2024-04-09 01:57:00 | aisle | 3 | 83667 | 1528 | 5.000 | 16733.4 |
1706 | 2024-04-07 15:51:45 | aisle | 3 | 83667 | 1528 | 12.016 | 6963.0 |
1705 | 2024-04-07 09:41:59 | aisle | 3 | 83667 | 1528 | 9.503 | 8804.3 |
1704 | 2024-04-07 06:21:21 | aisle | 3 | 83667 | 1528 | 14.923 | 5606.6 |
1703 | 2024-04-06 15:37:42 | aisle | 3 | 83667 | 1528 | 8.296 | 10085.2 |
1702 | 2024-04-06 06:25:47 | aisle | 3 | 83667 | 1528 | 6.950 | 12038.4 |
1701 | 2024-04-05 15:40:01 | aisle | 3 | 83667 | 1528 | 8.326 | 10048.9 |
1700 | 2024-04-05 12:15:23 | aisle | 3 | 83667 | 1528 | 5.830 | 14351.1 |
1699 | 2024-04-04 23:53:05 | aisle | 3 | 83667 | 1528 | 10.093 | 8289.6 |
1698 | 2024-04-04 23:20:40 | aisle | 3 | 83667 | 1528 | 6.093 | 13731.7 |
1697 | 2024-04-04 22:57:03 | aisle | 1 | 28756 | 5 | 1.906 | 15087.1 |
1696 | 2024-04-03 19:16:51 | aisle | 3 | 83667 | 1528 | 4.936 | 16950.4 |
1695 | 2024-04-03 13:40:41 | aisle | 3 | 83667 | 1528 | 9.143 | 9150.9 |
1694 | 2024-04-03 11:25:43 | aisle | 2 | 53800 | 80 | 7.846 | 6857.0 |
1693 | 2024-04-03 11:23:19 | aisle | 1 | 28756 | 5 | 1.140 | 25224.6 |
1692 | 2024-04-02 23:13:18 | aisle | 3 | 83667 | 1528 | 5.140 | 16277.6 |
1691 | 2024-04-01 06:07:02 | aisle | 3 | 83667 | 1528 | 9.420 | 8881.8 |
1690 | 2024-03-31 09:26:15 | aisle | 3 | 83667 | 1528 | 7.906 | 10582.7 |
1689 | 2024-03-31 07:56:09 | aisle | 1 | 28756 | 5 | 0.500 | 57512.0 |
1688 | 2024-03-30 16:58:36 | aisle | 3 | 83667 | 1528 | 5.110 | 16373.2 |
1687 | 2024-03-30 09:13:41 | aisle | 3 | 83667 | 1528 | 5.016 | 16680.0 |
1686 | 2024-03-29 17:44:53 | aisle | 3 | 83667 | 1528 | 3.453 | 24230.2 |
1685 | 2024-03-29 09:22:47 | aisle | 3 | 83667 | 1528 | 4.076 | 20526.7 |
1684 | 2024-03-29 08:33:45 | aisle | 2 | 53800 | 80 | 2.030 | 26502.5 |
1683 | 2024-03-29 08:33:40 | aisle | 1 | 28756 | 5 | 1.736 | 16564.5 |
1682 | 2024-03-29 08:33:29 | aisle | 2 | 53800 | 80 | 2.093 | 25704.7 |
1681 | 2024-03-29 08:14:20 | aisle | 1 | 28756 | 5 | 1.170 | 24577.8 |
1680 | 2024-03-28 15:09:30 | aisle | 3 | 83667 | 1528 | 8.203 | 10199.6 |
1679 | 2024-03-28 03:47:55 | aisle | 3 | 83667 | 1528 | 3.983 | 21006.0 |