History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"names"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1796 | 2024-12-25 15:39:44 | names | 2 | 53800 | 347 | 5.140 | 10466.9 |
1795 | 2024-12-25 12:40:19 | names | 2 | 53800 | 347 | 8.830 | 6092.9 |
1794 | 2024-12-25 10:21:18 | names | 2 | 53800 | 347 | 8.186 | 6572.2 |
1793 | 2024-12-25 02:28:39 | names | 2 | 53800 | 347 | 7.206 | 7466.0 |
1792 | 2024-12-24 17:19:28 | names | 1 | 28756 | 20 | 1.203 | 23903.6 |
1791 | 2024-12-16 17:22:12 | names | 1 | 28756 | 20 | 3.920 | 7335.7 |
1790 | 2024-11-29 00:54:23 | names | 1 | 28756 | 20 | 1.906 | 15087.1 |
1789 | 2024-11-27 08:58:28 | names | 1 | 28756 | 20 | 2.123 | 13545.0 |
1788 | 2024-11-26 21:31:16 | names | 1 | 28756 | 20 | 2.813 | 10222.5 |
1787 | 2024-11-24 16:37:25 | names | 1 | 28756 | 20 | 2.063 | 13938.9 |
1786 | 2024-11-13 17:48:10 | names | 2 | 53800 | 347 | 6.313 | 8522.1 |
1785 | 2024-11-13 07:31:32 | names | 2 | 53800 | 347 | 8.203 | 6558.6 |
1784 | 2024-11-07 05:50:10 | names | 1 | 28756 | 20 | 1.516 | 18968.3 |
1783 | 2024-11-03 12:58:53 | names | 2 | 53800 | 347 | 4.046 | 13297.1 |
1782 | 2024-10-28 09:09:29 | names | 2 | 53800 | 347 | 10.513 | 5117.5 |
1781 | 2024-10-28 07:53:45 | names | 2 | 53800 | 347 | 9.920 | 5423.4 |
1780 | 2024-10-28 07:24:37 | names | 1 | 28756 | 20 | 0.483 | 59536.2 |
1779 | 2024-10-27 22:04:07 | names | 2 | 53800 | 347 | 8.626 | 6237.0 |
1778 | 2024-10-27 21:29:47 | names | 1 | 28756 | 20 | 1.233 | 23322.0 |
1777 | 2024-10-25 13:26:19 | names | 1 | 28756 | 20 | 1.533 | 18758.0 |
1776 | 2024-10-23 15:02:10 | names | 1 | 28756 | 20 | 2.000 | 14378.0 |
1775 | 2024-10-07 12:02:29 | names | 1 | 28756 | 20 | 3.813 | 7541.6 |
1774 | 2024-10-07 12:02:01 | names | 1 | 28756 | 20 | 1.953 | 14724.0 |
1773 | 2024-10-05 09:32:39 | names | 1 | 28756 | 20 | 4.673 | 6153.6 |
1772 | 2024-09-28 06:56:33 | names | 2 | 53800 | 347 | 11.940 | 4505.9 |
1771 | 2024-09-28 05:18:16 | names | 1 | 28756 | 20 | 0.483 | 59536.2 |
1770 | 2024-09-27 11:30:53 | names | 1 | 28756 | 20 | 2.610 | 11017.6 |
1769 | 2024-09-25 12:17:18 | names | 1 | 28756 | 20 | 2.076 | 13851.6 |
1768 | 2024-09-22 07:58:51 | names | 2 | 53800 | 347 | 7.593 | 7085.5 |
1767 | 2024-09-21 03:52:16 | names | 2 | 53800 | 347 | 6.890 | 7808.4 |
1766 | 2024-09-20 04:36:46 | names | 2 | 53800 | 347 | 11.923 | 4512.3 |
1765 | 2024-09-19 06:37:40 | names | 2 | 53800 | 347 | 9.093 | 5916.6 |
1764 | 2024-09-18 13:44:43 | names | 2 | 53800 | 347 | 2.626 | 20487.4 |
1763 | 2024-09-17 14:43:16 | names | 2 | 53800 | 347 | 11.030 | 4877.6 |
1762 | 2024-09-16 04:28:05 | names | 2 | 53800 | 347 | 6.216 | 8655.1 |
1761 | 2024-09-15 04:38:24 | names | 2 | 53800 | 347 | 12.596 | 4271.2 |
1760 | 2024-09-13 06:00:38 | names | 2 | 53800 | 347 | 7.686 | 6999.7 |
1759 | 2024-09-12 00:17:38 | names | 2 | 53800 | 347 | 11.096 | 4848.6 |
1758 | 2024-09-11 07:25:24 | names | 2 | 53800 | 347 | 9.126 | 5895.2 |
1757 | 2024-09-10 17:08:16 | names | 2 | 53800 | 347 | 6.720 | 8006.0 |
1756 | 2024-09-10 14:29:25 | names | 2 | 53800 | 347 | 6.703 | 8026.3 |
1755 | 2024-09-09 06:18:58 | names | 2 | 53800 | 347 | 12.313 | 4369.4 |
1754 | 2024-09-08 06:16:24 | names | 2 | 53800 | 347 | 10.393 | 5176.6 |
1753 | 2024-09-07 14:59:34 | names | 1 | 28756 | 20 | 3.843 | 7482.7 |
1752 | 2024-09-07 14:54:38 | names | 2 | 53800 | 347 | 9.690 | 5552.1 |
1751 | 2024-09-06 23:30:39 | names | 2 | 53800 | 347 | 9.453 | 5691.3 |
1750 | 2024-09-06 17:45:37 | names | 2 | 53800 | 347 | 16.296 | 3301.4 |
1749 | 2024-09-05 10:05:55 | names | 2 | 53800 | 347 | 6.283 | 8562.8 |
1748 | 2024-09-04 21:09:41 | names | 2 | 53800 | 347 | 7.983 | 6739.3 |
1747 | 2024-09-03 22:40:13 | names | 2 | 53800 | 347 | 8.516 | 6317.5 |
1746 | 2024-09-03 21:13:27 | names | 1 | 28756 | 20 | 2.453 | 11722.8 |
1745 | 2024-09-03 02:16:21 | names | 2 | 53800 | 347 | 11.360 | 4735.9 |
1744 | 2024-08-29 21:29:25 | names | 1 | 28756 | 20 | 4.266 | 6740.7 |
1743 | 2024-08-29 08:44:35 | names | 2 | 53800 | 347 | 11.186 | 4809.6 |
1742 | 2024-08-29 05:54:37 | names | 2 | 53800 | 347 | 18.953 | 2838.6 |
1741 | 2024-08-29 02:46:23 | names | 2 | 53800 | 347 | 12.983 | 4143.9 |
1740 | 2024-08-29 02:26:50 | names | 1 | 28756 | 20 | 4.610 | 6237.7 |
1739 | 2024-08-28 08:03:32 | names | 1 | 28756 | 20 | 5.236 | 5492.0 |
1738 | 2024-08-18 19:11:21 | names | 1 | 28756 | 20 | 4.346 | 6616.7 |
1737 | 2024-08-12 18:08:59 | names | 1 | 28756 | 20 | 1.860 | 15460.2 |
1736 | 2024-08-09 16:09:08 | names | 2 | 53800 | 347 | 8.000 | 6725.0 |
1735 | 2024-08-09 15:47:33 | names | 1 | 28756 | 20 | 2.893 | 9939.9 |
1734 | 2024-08-03 11:29:14 | names | 2 | 53800 | 347 | 3.080 | 17467.5 |
1733 | 2024-08-02 10:55:31 | names | 2 | 53800 | 347 | 8.936 | 6020.6 |
1732 | 2024-08-01 17:04:57 | names | 2 | 53800 | 347 | 3.703 | 14528.8 |
1731 | 2024-07-31 07:56:37 | names | 2 | 53800 | 347 | 6.106 | 8811.0 |
1730 | 2024-07-30 17:16:04 | names | 2 | 53800 | 347 | 6.656 | 8082.9 |
1729 | 2024-07-29 18:50:39 | names | 1 | 28756 | 20 | 3.280 | 8767.1 |
1728 | 2024-07-29 16:10:15 | names | 1 | 28756 | 20 | 1.203 | 23903.6 |
1727 | 2024-07-29 14:41:51 | names | 2 | 53800 | 347 | 2.280 | 23596.5 |
1726 | 2024-07-29 04:28:38 | names | 2 | 53800 | 347 | 8.780 | 6127.6 |
1725 | 2024-07-29 04:07:42 | names | 1 | 28756 | 20 | 2.763 | 10407.5 |
1724 | 2024-07-28 23:04:56 | names | 2 | 53800 | 347 | 3.140 | 17133.8 |
1723 | 2024-07-28 22:04:36 | names | 2 | 53800 | 347 | 3.220 | 16708.1 |
1722 | 2024-07-28 10:24:27 | names | 2 | 53800 | 347 | 5.703 | 9433.6 |
1721 | 2024-07-27 07:25:19 | names | 2 | 53800 | 347 | 2.203 | 24421.2 |
1720 | 2024-07-26 20:05:38 | names | 2 | 53800 | 347 | 4.096 | 13134.8 |
1719 | 2024-07-26 11:28:09 | names | 2 | 53800 | 347 | 2.640 | 20378.8 |
1718 | 2024-07-24 13:29:11 | names | 2 | 53800 | 347 | 5.800 | 9275.9 |
1717 | 2024-07-13 15:35:23 | names | 2 | 53800 | 347 | 4.000 | 13450.0 |
1716 | 2024-07-11 11:22:58 | names | 2 | 53800 | 347 | 6.000 | 8966.7 |
1715 | 2024-07-10 07:54:16 | names | 2 | 53800 | 347 | 7.313 | 7356.8 |
1714 | 2024-07-10 07:42:57 | names | 1 | 28756 | 20 | 1.233 | 23322.0 |
1713 | 2024-07-10 07:27:05 | names | 2 | 53800 | 347 | 6.783 | 7931.6 |
1712 | 2024-07-09 07:37:48 | names | 2 | 53800 | 347 | 4.936 | 10899.5 |
1711 | 2024-07-08 15:10:08 | names | 2 | 53800 | 347 | 4.203 | 12800.4 |
1710 | 2024-07-07 20:17:34 | names | 2 | 53800 | 347 | 5.970 | 9011.7 |
1709 | 2024-07-04 21:28:37 | names | 1 | 28756 | 20 | 1.656 | 17364.7 |
1708 | 2024-07-04 21:09:25 | names | 1 | 28756 | 20 | 2.766 | 10396.2 |
1707 | 2024-07-03 00:46:58 | names | 1 | 28756 | 20 | 1.796 | 16011.1 |
1706 | 2024-07-02 00:22:55 | names | 1 | 28756 | 20 | 2.450 | 11737.1 |
1705 | 2024-06-29 14:08:32 | names | 1 | 28756 | 20 | 0.830 | 34645.8 |
1704 | 2024-06-28 23:40:25 | names | 1 | 28756 | 20 | 2.733 | 10521.8 |
1703 | 2024-06-26 14:27:36 | names | 1 | 28756 | 20 | 1.906 | 15087.1 |
1702 | 2024-06-15 20:09:30 | names | 1 | 28756 | 20 | 2.516 | 11429.3 |
1701 | 2024-06-09 02:40:38 | names | 1 | 28756 | 20 | 0.826 | 34813.6 |
1700 | 2024-06-04 00:23:17 | names | 1 | 28756 | 20 | 1.673 | 17188.3 |
1699 | 2024-06-03 13:23:48 | names | 2 | 53800 | 347 | 3.046 | 17662.5 |
1698 | 2024-06-03 11:40:26 | names | 1 | 28756 | 20 | 1.640 | 17534.1 |
1697 | 2024-05-30 08:59:58 | names | 1 | 28756 | 20 | 2.436 | 11804.6 |