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 |
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 |
1678 | 2024-03-27 14:55:02 | aisle | 3 | 83667 | 1528 | 3.876 | 21585.9 |
1677 | 2024-03-27 03:51:00 | aisle | 3 | 83667 | 1528 | 4.703 | 17790.1 |
1676 | 2024-03-26 14:20:14 | aisle | 3 | 83667 | 1528 | 4.983 | 16790.5 |
1675 | 2024-03-26 06:58:51 | aisle | 3 | 83667 | 1528 | 4.080 | 20506.6 |
1674 | 2024-03-25 08:33:42 | aisle | 3 | 83667 | 1528 | 4.470 | 18717.4 |
1673 | 2024-03-25 07:51:03 | aisle | 1 | 28756 | 5 | 0.533 | 53951.2 |
1672 | 2024-03-24 12:51:23 | aisle | 3 | 83667 | 1528 | 6.766 | 12365.8 |
1671 | 2024-03-24 01:28:06 | aisle | 3 | 83667 | 1528 | 3.953 | 21165.4 |
1670 | 2024-03-23 12:34:21 | aisle | 3 | 83667 | 1528 | 5.000 | 16733.4 |
1669 | 2024-03-23 01:31:17 | aisle | 3 | 83667 | 1528 | 5.080 | 16469.9 |
1668 | 2024-03-22 16:36:20 | aisle | 3 | 83667 | 1528 | 15.313 | 5463.8 |
1667 | 2024-03-22 06:00:27 | aisle | 3 | 83667 | 1528 | 7.860 | 10644.7 |
1666 | 2024-03-21 15:58:16 | aisle | 3 | 83667 | 1528 | 5.250 | 15936.6 |
1665 | 2024-03-21 06:02:20 | aisle | 3 | 83667 | 1528 | 6.203 | 13488.2 |
1664 | 2024-03-20 15:14:52 | aisle | 3 | 83667 | 1528 | 3.563 | 23482.2 |
1663 | 2024-03-20 05:47:03 | aisle | 3 | 83667 | 1528 | 3.606 | 23202.2 |
1662 | 2024-03-19 03:03:45 | aisle | 3 | 83667 | 1528 | 10.110 | 8275.7 |
1661 | 2024-03-18 02:19:59 | aisle | 3 | 83667 | 1528 | 3.923 | 21327.3 |
1660 | 2024-03-16 15:34:08 | aisle | 3 | 83667 | 1528 | 9.846 | 8497.6 |
1659 | 2024-03-16 05:36:44 | aisle | 3 | 83667 | 1528 | 6.486 | 12899.6 |
1658 | 2024-03-15 15:22:57 | aisle | 3 | 83667 | 1528 | 3.483 | 24021.5 |
1657 | 2024-03-15 10:48:52 | aisle | 3 | 83667 | 1528 | 6.190 | 13516.5 |
1656 | 2024-03-15 02:21:27 | aisle | 3 | 83667 | 1528 | 6.080 | 13761.0 |
1655 | 2024-03-14 11:00:37 | aisle | 3 | 83667 | 1528 | 6.250 | 13386.7 |
1654 | 2024-03-14 00:49:07 | aisle | 3 | 83667 | 1528 | 6.093 | 13731.7 |
1653 | 2024-03-13 01:45:50 | aisle | 3 | 83667 | 1528 | 12.296 | 6804.4 |
1652 | 2024-03-12 13:11:32 | aisle | 3 | 83667 | 1528 | 3.593 | 23286.1 |
1651 | 2024-03-11 21:05:00 | aisle | 3 | 83667 | 1528 | 3.546 | 23594.8 |
1650 | 2024-03-11 09:58:17 | aisle | 3 | 83667 | 1528 | 7.390 | 11321.7 |
1649 | 2024-03-10 11:09:44 | aisle | 3 | 83667 | 1528 | 10.250 | 8162.6 |
1648 | 2024-03-07 13:28:30 | aisle | 3 | 83667 | 1528 | 4.016 | 20833.4 |
1647 | 2024-03-07 04:11:22 | aisle | 3 | 83667 | 1528 | 14.766 | 5666.2 |
1646 | 2024-03-06 04:07:32 | aisle | 3 | 83667 | 1528 | 7.720 | 10837.7 |
1645 | 2024-03-05 16:38:46 | aisle | 3 | 83667 | 1528 | 7.343 | 11394.1 |
1644 | 2024-03-05 07:16:51 | aisle | 3 | 83667 | 1528 | 12.486 | 6700.9 |