History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dairy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1933 | 2024-05-01 22:01:00 | dairy | 1 | 28756 | 7 | 1.690 | 17015.4 |
1932 | 2024-05-01 08:05:22 | dairy | 1 | 28756 | 7 | 0.983 | 29253.3 |
1931 | 2024-04-30 19:17:43 | dairy | 1 | 28756 | 7 | 1.030 | 27918.4 |
1930 | 2024-04-27 12:19:20 | dairy | 1 | 28756 | 7 | 2.080 | 13825.0 |
1929 | 2024-04-23 00:04:29 | dairy | 3 | 83667 | 1337 | 3.530 | 23701.7 |
1928 | 2024-04-09 19:31:55 | dairy | 1 | 28756 | 7 | 0.533 | 53951.2 |
1927 | 2024-04-03 05:20:26 | dairy | 1 | 28756 | 7 | 0.513 | 56054.6 |
1926 | 2024-04-01 17:04:01 | dairy | 1 | 28756 | 7 | 1.486 | 19351.3 |
1925 | 2024-03-31 18:00:59 | dairy | 3 | 83667 | 1337 | 42.253 | 1980.1 |
1924 | 2024-03-31 09:14:51 | dairy | 3 | 83667 | 1337 | 4.486 | 18650.7 |
1923 | 2024-03-31 09:14:47 | dairy | 2 | 53800 | 93 | 1.796 | 29955.5 |
1922 | 2024-03-31 09:14:40 | dairy | 1 | 28756 | 7 | 1.140 | 25224.6 |
1921 | 2024-03-31 09:14:27 | dairy | 3 | 83667 | 1337 | 9.626 | 8691.8 |
1920 | 2024-03-31 09:14:26 | dairy | 2 | 53800 | 93 | 4.093 | 13144.4 |
1919 | 2024-03-31 09:14:13 | dairy | 1 | 28756 | 7 | 0.626 | 45936.1 |
1918 | 2024-03-29 02:11:53 | dairy | 1 | 28756 | 7 | 0.546 | 52666.7 |
1917 | 2024-03-25 02:31:13 | dairy | 1 | 28756 | 7 | 0.530 | 54256.6 |
1916 | 2024-03-04 03:37:48 | dairy | 2 | 53800 | 93 | 1.390 | 38705.0 |
1915 | 2024-03-04 03:37:22 | dairy | 3 | 83667 | 1337 | 6.500 | 12871.8 |
1914 | 2024-03-04 00:42:41 | dairy | 1 | 28756 | 7 | 0.466 | 61708.2 |
1913 | 2024-03-02 14:33:02 | dairy | 3 | 83667 | 1337 | 9.486 | 8820.1 |
1912 | 2024-03-02 14:33:08 | dairy | 1 | 28756 | 7 | 1.233 | 23322.0 |
1911 | 2024-03-02 14:33:04 | dairy | 2 | 53800 | 93 | 3.763 | 14297.1 |
1910 | 2024-03-01 07:18:16 | dairy | 1 | 28756 | 7 | 0.533 | 53951.2 |
1909 | 2024-02-29 03:46:44 | dairy | 2 | 53800 | 93 | 1.483 | 36277.8 |
1908 | 2024-02-29 03:46:24 | dairy | 3 | 83667 | 1337 | 4.096 | 20426.5 |
1907 | 2024-02-27 20:08:56 | dairy | 1 | 28756 | 7 | 0.530 | 54256.6 |
1906 | 2024-02-27 08:32:54 | dairy | 2 | 53800 | 93 | 1.766 | 30464.3 |
1905 | 2024-02-27 08:32:40 | dairy | 3 | 83667 | 1337 | 4.266 | 19612.5 |
1904 | 2024-02-26 14:13:09 | dairy | 3 | 83667 | 1337 | 7.220 | 11588.2 |
1903 | 2024-02-26 14:00:51 | dairy | 3 | 83667 | 1337 | 7.220 | 11588.2 |
1902 | 2024-02-05 04:21:49 | dairy | 1 | 28756 | 7 | 1.046 | 27491.4 |
1901 | 2024-02-03 00:01:59 | dairy | 1 | 28756 | 7 | 0.530 | 54256.6 |
1900 | 2024-01-29 02:13:57 | dairy | 1 | 28756 | 7 | 0.486 | 59168.7 |
1899 | 2024-01-29 01:09:19 | dairy | 1 | 28756 | 7 | 0.530 | 54256.6 |
1898 | 2024-01-28 19:17:41 | dairy | 1 | 28756 | 7 | 0.516 | 55728.7 |
1897 | 2024-01-24 05:58:51 | dairy | 3 | 83667 | 1337 | 3.390 | 24680.5 |
1896 | 2024-01-21 05:35:46 | dairy | 3 | 83667 | 1337 | 3.313 | 25254.2 |
1895 | 2024-01-17 07:39:25 | dairy | 1 | 28756 | 7 | 0.500 | 57512.0 |
1894 | 2024-01-14 00:23:20 | dairy | 3 | 83667 | 1337 | 4.123 | 20292.7 |
1893 | 2024-01-14 00:23:21 | dairy | 2 | 53800 | 93 | 1.720 | 31279.1 |
1892 | 2024-01-10 15:56:02 | dairy | 3 | 83667 | 1337 | 3.643 | 22966.5 |
1891 | 2024-01-10 15:56:03 | dairy | 2 | 53800 | 93 | 1.576 | 34137.1 |
1890 | 2024-01-09 05:17:59 | dairy | 1 | 28756 | 7 | 0.500 | 57512.0 |
1889 | 2024-01-06 15:16:57 | dairy | 3 | 83667 | 1337 | 3.860 | 21675.4 |
1888 | 2023-12-26 20:39:37 | dairy | 3 | 83667 | 1337 | 3.406 | 24564.6 |
1887 | 2023-12-26 20:39:35 | dairy | 2 | 53800 | 93 | 1.546 | 34799.5 |
1886 | 2023-12-14 20:16:30 | dairy | 3 | 83667 | 1337 | 3.513 | 23816.4 |
1885 | 2023-12-03 07:07:31 | dairy | 1 | 28756 | 7 | 0.470 | 61183.0 |
1884 | 2023-12-03 07:07:30 | dairy | 1 | 28756 | 7 | 0.466 | 61708.2 |
1883 | 2023-11-20 12:40:56 | dairy | 3 | 83667 | 1337 | 3.453 | 24230.2 |
1882 | 2023-11-20 12:40:54 | dairy | 2 | 53800 | 93 | 1.390 | 38705.0 |
1881 | 2023-11-20 01:14:48 | dairy | 1 | 28756 | 7 | 0.453 | 63479.0 |
1880 | 2023-11-16 04:56:16 | dairy | 1 | 28756 | 7 | 0.436 | 65954.1 |
1879 | 2023-11-13 00:19:34 | dairy | 1 | 28756 | 7 | 0.470 | 61183.0 |
1878 | 2023-11-10 22:29:17 | dairy | 1 | 28756 | 7 | 0.966 | 29768.1 |
1877 | 2023-11-01 17:21:54 | dairy | 1 | 28756 | 7 | 0.500 | 57512.0 |
1876 | 2023-10-28 09:55:22 | dairy | 1 | 28756 | 7 | 0.453 | 63479.0 |
1875 | 2023-10-25 03:11:50 | dairy | 1 | 28756 | 7 | 0.436 | 65954.1 |
1874 | 2023-10-21 15:49:39 | dairy | 1 | 28756 | 7 | 0.516 | 55728.7 |
1873 | 2023-10-19 14:18:26 | dairy | 1 | 28756 | 7 | 0.560 | 51350.0 |
1872 | 2023-10-13 16:17:28 | dairy | 1 | 28756 | 7 | 0.530 | 54256.6 |
1871 | 2023-10-12 16:51:13 | dairy | 3 | 83667 | 1337 | 3.843 | 21771.3 |
1870 | 2023-10-03 16:29:57 | dairy | 1 | 28756 | 7 | 0.500 | 57512.0 |
1869 | 2023-09-28 03:24:41 | dairy | 2 | 53800 | 93 | 1.640 | 32804.9 |
1868 | 2023-09-28 00:33:04 | dairy | 3 | 83667 | 1337 | 4.093 | 20441.5 |
1867 | 2023-09-24 10:28:37 | dairy | 3 | 83667 | 1337 | 3.640 | 22985.4 |
1866 | 2023-09-24 10:28:35 | dairy | 2 | 53800 | 93 | 1.483 | 36277.8 |
1865 | 2023-09-22 10:32:49 | dairy | 1 | 28756 | 7 | 0.453 | 63479.0 |
1864 | 2023-09-21 03:00:56 | dairy | 3 | 83667 | 1337 | 3.923 | 21327.3 |
1863 | 2023-09-19 11:01:11 | dairy | 1 | 28756 | 7 | 0.513 | 56054.6 |
1862 | 2023-09-09 19:41:17 | dairy | 1 | 28756 | 7 | 0.500 | 57512.0 |
1861 | 2023-08-31 00:42:28 | dairy | 1 | 28756 | 7 | 0.436 | 65954.1 |
1860 | 2023-08-17 06:10:02 | dairy | 3 | 83667 | 1337 | 3.326 | 25155.4 |
1859 | 2023-08-07 04:35:11 | dairy | 3 | 83667 | 1337 | 3.783 | 22116.6 |
1858 | 2023-07-26 06:39:56 | dairy | 3 | 83667 | 1337 | 3.453 | 24230.2 |
1857 | 2023-07-22 04:49:53 | dairy | 3 | 83667 | 1337 | 4.016 | 20833.4 |
1856 | 2023-07-15 22:51:08 | dairy | 1 | 28756 | 7 | 1.030 | 27918.4 |
1855 | 2023-07-09 09:00:54 | dairy | 3 | 83667 | 1337 | 4.000 | 20916.8 |
1854 | 2023-07-08 14:24:58 | dairy | 3 | 83667 | 1337 | 3.283 | 25484.9 |
1853 | 2023-07-07 01:18:08 | dairy | 3 | 83667 | 1337 | 3.530 | 23701.7 |
1852 | 2023-07-06 07:26:32 | dairy | 3 | 83667 | 1337 | 3.923 | 21327.3 |
1851 | 2023-07-04 16:24:21 | dairy | 3 | 83667 | 1337 | 3.843 | 21771.3 |
1850 | 2023-07-04 01:31:40 | dairy | 3 | 83667 | 1337 | 7.580 | 11037.9 |
1849 | 2023-07-03 03:19:21 | dairy | 3 | 83667 | 1337 | 4.126 | 20278.0 |
1848 | 2023-07-02 10:32:27 | dairy | 3 | 83667 | 1337 | 4.296 | 19475.6 |
1847 | 2023-07-01 16:05:27 | dairy | 3 | 83667 | 1337 | 3.906 | 21420.1 |
1846 | 2023-06-30 22:47:12 | dairy | 3 | 83667 | 1337 | 3.890 | 21508.2 |
1845 | 2023-06-30 03:29:30 | dairy | 3 | 83667 | 1337 | 3.423 | 24442.6 |
1844 | 2023-06-29 13:48:57 | dairy | 3 | 83667 | 1337 | 3.563 | 23482.2 |
1843 | 2023-06-28 20:54:02 | dairy | 3 | 83667 | 1337 | 3.873 | 21602.6 |
1842 | 2023-06-27 23:51:55 | dairy | 3 | 83667 | 1337 | 3.750 | 22311.2 |
1841 | 2023-06-27 04:48:20 | dairy | 3 | 83667 | 1337 | 3.406 | 24564.6 |
1840 | 2023-06-26 15:24:02 | dairy | 3 | 83667 | 1337 | 3.843 | 21771.3 |
1839 | 2023-06-25 18:18:52 | dairy | 3 | 83667 | 1337 | 3.763 | 22234.1 |
1838 | 2023-06-24 22:51:29 | dairy | 3 | 83667 | 1337 | 3.330 | 25125.2 |
1837 | 2023-06-24 03:21:42 | dairy | 3 | 83667 | 1337 | 3.780 | 22134.1 |
1836 | 2023-06-23 14:24:08 | dairy | 3 | 83667 | 1337 | 3.330 | 25125.2 |
1835 | 2023-06-22 14:51:00 | dairy | 3 | 83667 | 1337 | 4.063 | 20592.4 |
1834 | 2023-06-21 20:32:07 | dairy | 3 | 83667 | 1337 | 3.343 | 25027.5 |