History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rifle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1805 | 2024-04-27 04:44:20 | rifle | 1 | 28756 | 9 | 1.123 | 25606.4 |
1804 | 2024-04-14 06:09:46 | rifle | 1 | 28756 | 9 | 0.563 | 51076.4 |
1803 | 2024-04-02 23:49:40 | rifle | 1 | 28756 | 9 | 2.390 | 12031.8 |
1802 | 2024-03-31 17:58:26 | rifle | 3 | 83667 | 1285 | 4.423 | 18916.3 |
1801 | 2024-03-31 02:14:15 | rifle | 1 | 28756 | 9 | 0.546 | 52666.7 |
1800 | 2024-03-30 20:09:24 | rifle | 3 | 83667 | 1285 | 14.860 | 5630.3 |
1799 | 2024-03-30 01:24:23 | rifle | 3 | 83667 | 1285 | 8.876 | 9426.2 |
1798 | 2024-03-29 08:12:23 | rifle | 1 | 28756 | 9 | 0.500 | 57512.0 |
1797 | 2024-03-29 07:00:33 | rifle | 3 | 83667 | 1285 | 11.220 | 7457.0 |
1796 | 2024-03-28 09:56:49 | rifle | 3 | 83667 | 1285 | 11.483 | 7286.2 |
1795 | 2024-03-25 23:25:18 | rifle | 3 | 83667 | 1285 | 4.703 | 17790.1 |
1794 | 2024-03-24 23:30:02 | rifle | 3 | 83667 | 1285 | 7.563 | 11062.7 |
1793 | 2024-03-23 23:29:49 | rifle | 3 | 83667 | 1285 | 4.000 | 20916.8 |
1792 | 2024-03-22 23:23:51 | rifle | 3 | 83667 | 1285 | 4.076 | 20526.7 |
1791 | 2024-03-21 23:34:30 | rifle | 3 | 83667 | 1285 | 9.596 | 8718.9 |
1790 | 2024-03-20 23:23:56 | rifle | 3 | 83667 | 1285 | 9.780 | 8554.9 |
1789 | 2024-03-19 23:20:21 | rifle | 3 | 83667 | 1285 | 7.983 | 10480.6 |
1788 | 2024-03-18 23:28:39 | rifle | 3 | 83667 | 1285 | 4.920 | 17005.5 |
1787 | 2024-03-18 01:45:20 | rifle | 3 | 83667 | 1285 | 9.703 | 8622.8 |
1786 | 2024-03-17 01:57:28 | rifle | 3 | 83667 | 1285 | 4.750 | 17614.1 |
1785 | 2024-03-16 01:37:17 | rifle | 3 | 83667 | 1285 | 11.736 | 7129.1 |
1784 | 2024-03-15 18:48:59 | rifle | 3 | 83667 | 1285 | 3.420 | 24464.0 |
1783 | 2024-03-15 01:26:57 | rifle | 3 | 83667 | 1285 | 6.093 | 13731.7 |
1782 | 2024-03-14 01:41:10 | rifle | 3 | 83667 | 1285 | 15.860 | 5275.3 |
1781 | 2024-03-11 01:12:31 | rifle | 3 | 83667 | 1285 | 4.593 | 18216.2 |
1780 | 2024-03-10 20:45:17 | rifle | 3 | 83667 | 1285 | 3.390 | 24680.5 |
1779 | 2024-03-10 01:10:39 | rifle | 3 | 83667 | 1285 | 9.706 | 8620.1 |
1778 | 2024-03-09 02:06:18 | rifle | 3 | 83667 | 1285 | 15.970 | 5239.0 |
1777 | 2024-03-09 01:43:28 | rifle | 3 | 83667 | 1285 | 14.436 | 5795.7 |
1776 | 2024-03-08 01:20:51 | rifle | 3 | 83667 | 1285 | 6.640 | 12600.5 |
1775 | 2024-03-07 01:22:19 | rifle | 3 | 83667 | 1285 | 3.750 | 22311.2 |
1774 | 2024-03-06 01:13:38 | rifle | 3 | 83667 | 1285 | 4.313 | 19398.8 |
1773 | 2024-03-05 16:40:04 | rifle | 2 | 53800 | 96 | 1.750 | 30742.9 |
1772 | 2024-03-05 16:39:44 | rifle | 3 | 83667 | 1285 | 3.763 | 22234.1 |
1771 | 2024-03-05 03:34:30 | rifle | 3 | 83667 | 1285 | 11.706 | 7147.4 |
1770 | 2024-03-05 01:32:28 | rifle | 3 | 83667 | 1285 | 14.626 | 5720.4 |
1769 | 2024-03-03 21:45:03 | rifle | 1 | 28756 | 9 | 0.516 | 55728.7 |
1768 | 2024-03-02 00:04:09 | rifle | 3 | 83667 | 1285 | 4.516 | 18526.8 |
1767 | 2024-03-01 00:00:33 | rifle | 3 | 83667 | 1285 | 4.030 | 20761.0 |
1766 | 2024-02-29 01:29:25 | rifle | 3 | 83667 | 1285 | 4.203 | 19906.5 |
1765 | 2024-02-28 02:06:21 | rifle | 2 | 53800 | 96 | 1.656 | 32487.9 |
1764 | 2024-02-28 02:06:19 | rifle | 1 | 28756 | 9 | 0.516 | 55728.7 |
1763 | 2024-02-28 01:28:58 | rifle | 3 | 83667 | 1285 | 3.656 | 22884.8 |
1762 | 2024-02-26 01:21:48 | rifle | 3 | 83667 | 1285 | 4.783 | 17492.6 |
1761 | 2024-02-25 01:43:43 | rifle | 3 | 83667 | 1285 | 3.453 | 24230.2 |
1760 | 2024-02-23 23:36:56 | rifle | 3 | 83667 | 1285 | 7.720 | 10837.7 |
1759 | 2024-02-22 23:35:01 | rifle | 3 | 83667 | 1285 | 9.156 | 9137.9 |
1758 | 2024-02-21 23:33:31 | rifle | 3 | 83667 | 1285 | 7.860 | 10644.7 |
1757 | 2024-02-20 23:29:42 | rifle | 3 | 83667 | 1285 | 5.423 | 15428.2 |
1756 | 2024-02-19 23:29:54 | rifle | 3 | 83667 | 1285 | 4.640 | 18031.7 |
1755 | 2024-02-18 23:30:20 | rifle | 3 | 83667 | 1285 | 4.610 | 18149.0 |
1754 | 2024-02-17 23:47:40 | rifle | 3 | 83667 | 1285 | 3.783 | 22116.6 |
1753 | 2024-02-16 23:48:23 | rifle | 3 | 83667 | 1285 | 4.736 | 17666.2 |
1752 | 2024-02-15 23:27:13 | rifle | 3 | 83667 | 1285 | 3.890 | 21508.2 |
1751 | 2024-02-13 23:40:36 | rifle | 3 | 83667 | 1285 | 12.406 | 6744.1 |
1750 | 2024-02-12 23:20:49 | rifle | 3 | 83667 | 1285 | 3.623 | 23093.3 |
1749 | 2024-02-11 23:14:30 | rifle | 3 | 83667 | 1285 | 6.186 | 13525.2 |
1748 | 2024-02-10 23:59:14 | rifle | 3 | 83667 | 1285 | 12.843 | 6514.6 |
1747 | 2024-02-09 23:12:07 | rifle | 3 | 83667 | 1285 | 3.970 | 21074.8 |
1746 | 2024-02-08 23:10:11 | rifle | 3 | 83667 | 1285 | 4.763 | 17566.0 |
1745 | 2024-02-03 00:02:04 | rifle | 2 | 53800 | 96 | 1.906 | 28226.7 |
1744 | 2024-02-02 01:42:20 | rifle | 2 | 53800 | 96 | 1.403 | 38346.4 |
1743 | 2024-02-02 01:42:00 | rifle | 3 | 83667 | 1285 | 3.406 | 24564.6 |
1742 | 2024-02-01 09:26:19 | rifle | 2 | 53800 | 96 | 1.813 | 29674.6 |
1741 | 2024-02-01 09:25:51 | rifle | 3 | 83667 | 1285 | 3.500 | 23904.9 |
1740 | 2024-01-29 17:49:08 | rifle | 3 | 83667 | 1285 | 4.126 | 20278.0 |
1739 | 2024-01-29 01:40:37 | rifle | 1 | 28756 | 9 | 0.453 | 63479.0 |
1738 | 2024-01-25 17:32:09 | rifle | 3 | 83667 | 1285 | 3.843 | 21771.3 |
1737 | 2024-01-24 16:19:15 | rifle | 3 | 83667 | 1285 | 3.343 | 25027.5 |
1736 | 2024-01-24 12:47:02 | rifle | 3 | 83667 | 1285 | 3.813 | 21942.6 |
1735 | 2024-01-23 22:04:32 | rifle | 3 | 83667 | 1285 | 3.503 | 23884.4 |
1734 | 2024-01-22 14:58:56 | rifle | 3 | 83667 | 1285 | 3.330 | 25125.2 |
1733 | 2024-01-21 20:21:08 | rifle | 3 | 83667 | 1285 | 3.873 | 21602.6 |
1732 | 2024-01-20 18:16:13 | rifle | 3 | 83667 | 1285 | 3.720 | 22491.1 |
1731 | 2024-01-19 02:42:49 | rifle | 3 | 83667 | 1285 | 7.360 | 11367.8 |
1730 | 2024-01-18 16:07:22 | rifle | 3 | 83667 | 1285 | 3.500 | 23904.9 |
1729 | 2024-01-17 23:50:34 | rifle | 3 | 83667 | 1285 | 3.953 | 21165.4 |
1728 | 2024-01-15 21:35:32 | rifle | 2 | 53800 | 96 | 1.423 | 37807.4 |
1727 | 2024-01-10 11:04:45 | rifle | 1 | 28756 | 9 | 0.466 | 61708.2 |
1726 | 2023-12-24 03:30:53 | rifle | 3 | 83667 | 1285 | 3.453 | 24230.2 |
1725 | 2023-12-17 13:13:18 | rifle | 1 | 28756 | 9 | 0.500 | 57512.0 |
1724 | 2023-12-06 20:58:12 | rifle | 2 | 53800 | 96 | 2.970 | 18114.5 |
1723 | 2023-12-06 19:34:47 | rifle | 2 | 53800 | 96 | 1.373 | 39184.3 |
1722 | 2023-12-05 19:18:06 | rifle | 3 | 83667 | 1285 | 3.936 | 21256.9 |
1721 | 2023-11-29 14:40:19 | rifle | 3 | 83667 | 1285 | 4.860 | 17215.4 |
1720 | 2023-11-28 20:16:18 | rifle | 3 | 83667 | 1285 | 3.656 | 22884.8 |
1719 | 2023-11-22 06:21:34 | rifle | 1 | 28756 | 9 | 0.516 | 55728.7 |
1718 | 2023-11-18 00:28:44 | rifle | 1 | 28756 | 9 | 0.453 | 63479.0 |
1717 | 2023-11-17 00:15:21 | rifle | 3 | 83667 | 1285 | 3.406 | 24564.6 |
1716 | 2023-11-13 04:05:32 | rifle | 1 | 28756 | 9 | 0.533 | 53951.2 |
1715 | 2023-11-11 20:45:21 | rifle | 1 | 28756 | 9 | 0.920 | 31256.5 |
1714 | 2023-11-10 08:00:12 | rifle | 3 | 83667 | 1285 | 3.470 | 24111.5 |
1713 | 2023-11-10 08:00:08 | rifle | 2 | 53800 | 96 | 1.376 | 39098.8 |
1712 | 2023-11-08 15:04:54 | rifle | 1 | 28756 | 9 | 0.470 | 61183.0 |
1711 | 2023-11-04 09:28:22 | rifle | 1 | 28756 | 9 | 0.453 | 63479.0 |
1710 | 2023-11-03 19:46:14 | rifle | 1 | 28756 | 9 | 0.516 | 55728.7 |
1709 | 2023-10-24 10:48:56 | rifle | 2 | 53800 | 96 | 1.406 | 38264.6 |
1708 | 2023-10-21 09:16:38 | rifle | 1 | 28756 | 9 | 0.500 | 57512.0 |
1707 | 2023-10-18 23:08:53 | rifle | 1 | 28756 | 9 | 0.500 | 57512.0 |
1706 | 2023-10-16 23:43:23 | rifle | 1 | 28756 | 9 | 0.516 | 55728.7 |