History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"day"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1989 | 2024-04-28 02:51:13 | day | 1 | 5146 | 32 | 0.186 | 27666.7 |
1988 | 2024-04-26 07:51:21 | day | 2 | 14084 | 490 | 0.390 | 36112.8 |
1987 | 2024-04-25 20:54:07 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1986 | 2024-04-24 23:24:53 | day | 1 | 5146 | 32 | 0.186 | 27666.7 |
1985 | 2024-04-18 09:35:28 | day | 1 | 5146 | 32 | 0.266 | 19345.9 |
1984 | 2024-04-11 15:51:31 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1983 | 2024-04-11 15:18:17 | day | 1 | 5146 | 32 | 0.466 | 11042.9 |
1982 | 2024-04-11 15:05:25 | day | 1 | 5146 | 32 | 0.296 | 17385.1 |
1981 | 2024-04-11 14:51:35 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1980 | 2024-04-03 08:16:01 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1979 | 2024-04-02 18:53:12 | day | 2 | 14084 | 490 | 0.456 | 30886.0 |
1978 | 2024-04-02 18:01:55 | day | 1 | 5146 | 32 | 0.326 | 15785.3 |
1977 | 2024-03-30 22:28:35 | day | 1 | 5146 | 32 | 0.313 | 16440.9 |
1976 | 2024-03-30 18:23:01 | day | 1 | 5146 | 32 | 0.206 | 24980.6 |
1975 | 2024-03-27 18:03:04 | day | 1 | 5146 | 32 | 0.216 | 23824.1 |
1974 | 2024-03-26 18:07:43 | day | 1 | 5146 | 32 | 0.096 | 53604.2 |
1973 | 2024-03-18 17:48:33 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1972 | 2024-03-15 03:06:36 | day | 1 | 5146 | 32 | 0.186 | 27666.7 |
1971 | 2024-03-02 16:47:32 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1970 | 2024-02-25 15:51:58 | day | 1 | 5146 | 32 | 0.110 | 46781.8 |
1969 | 2024-01-28 12:34:51 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1968 | 2024-01-24 17:37:48 | day | 1 | 5146 | 32 | 0.186 | 27666.7 |
1967 | 2023-12-25 13:30:43 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1966 | 2023-12-24 07:58:05 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1965 | 2023-12-08 01:41:37 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1964 | 2023-12-02 23:26:42 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1963 | 2023-12-02 23:26:42 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1962 | 2023-11-28 19:52:52 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1961 | 2023-11-18 16:50:35 | day | 2 | 14084 | 490 | 0.326 | 43202.5 |
1960 | 2023-11-15 18:55:32 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1959 | 2023-11-12 20:51:49 | day | 2 | 14084 | 490 | 0.330 | 42678.8 |
1958 | 2023-11-09 00:44:09 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1957 | 2023-11-07 18:20:10 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1956 | 2023-11-07 10:05:40 | day | 1 | 5146 | 32 | 0.090 | 57177.8 |
1955 | 2023-11-04 00:23:17 | day | 2 | 14084 | 490 | 0.373 | 37758.7 |
1954 | 2023-11-02 03:35:30 | day | 1 | 5146 | 32 | 0.096 | 53604.2 |
1953 | 2023-10-29 14:46:30 | day | 2 | 14084 | 490 | 0.453 | 31090.5 |
1952 | 2023-10-28 18:26:37 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1951 | 2023-10-26 05:59:21 | day | 1 | 5146 | 32 | 0.156 | 32987.2 |
1950 | 2023-10-25 22:40:12 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1949 | 2023-10-24 14:46:36 | day | 1 | 5146 | 32 | 0.110 | 46781.8 |
1948 | 2023-10-24 06:51:59 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1947 | 2023-10-22 21:46:12 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1946 | 2023-10-22 00:34:47 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1945 | 2023-10-20 14:56:11 | day | 2 | 14084 | 490 | 0.360 | 39122.2 |
1944 | 2023-10-19 21:31:47 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1943 | 2023-10-19 17:26:30 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1942 | 2023-10-17 05:47:10 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1941 | 2023-10-16 22:12:51 | day | 1 | 5146 | 32 | 0.096 | 53604.2 |
1940 | 2023-10-14 17:39:41 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1939 | 2023-10-12 05:17:53 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1938 | 2023-10-11 02:10:11 | day | 1 | 5146 | 32 | 0.186 | 27666.7 |
1937 | 2023-10-04 12:49:50 | day | 2 | 14084 | 490 | 0.343 | 41061.2 |
1936 | 2023-10-03 09:03:18 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1935 | 2023-10-03 02:16:23 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1934 | 2023-09-28 02:34:51 | day | 2 | 14084 | 490 | 0.376 | 37457.4 |
1933 | 2023-09-23 04:05:17 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1932 | 2023-09-19 19:28:59 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1931 | 2023-09-16 02:53:10 | day | 2 | 14084 | 490 | 0.330 | 42678.8 |
1930 | 2023-09-13 12:56:09 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1929 | 2023-09-10 15:59:52 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1928 | 2023-09-09 20:26:05 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1927 | 2023-09-08 08:40:18 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1926 | 2023-09-01 11:50:30 | day | 1 | 5146 | 32 | 0.096 | 53604.2 |
1925 | 2023-08-29 04:34:34 | day | 1 | 5146 | 32 | 0.110 | 46781.8 |
1924 | 2023-08-14 03:41:30 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1923 | 2023-08-12 17:07:57 | day | 2 | 14084 | 490 | 0.390 | 36112.8 |
1922 | 2023-08-08 22:08:21 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1921 | 2023-07-23 09:59:16 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1920 | 2023-07-17 03:14:20 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1919 | 2023-07-16 19:37:23 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1918 | 2023-07-15 06:29:23 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1917 | 2023-07-14 16:33:43 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1916 | 2023-05-25 17:35:11 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1915 | 2023-05-05 10:05:37 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1914 | 2023-04-27 14:01:51 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1913 | 2023-03-16 18:23:45 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1912 | 2023-03-13 18:59:56 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1911 | 2023-03-01 21:16:23 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1910 | 2023-02-23 01:32:15 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1909 | 2023-01-25 18:41:47 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1908 | 2023-01-23 07:04:48 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1907 | 2023-01-21 15:15:24 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1906 | 2023-01-19 05:01:42 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1905 | 2023-01-16 14:20:42 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1904 | 2023-01-11 19:07:09 | day | 1 | 5146 | 32 | 0.060 | 85766.7 |
1903 | 2023-01-09 10:41:23 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1902 | 2023-01-06 22:46:08 | day | 1 | 5146 | 32 | 0.096 | 53604.2 |
1901 | 2023-01-04 07:42:14 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1900 | 2023-01-02 01:52:32 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1899 | 2022-12-29 18:22:01 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1898 | 2022-12-27 02:38:53 | day | 1 | 5146 | 32 | 0.093 | 55333.3 |
1897 | 2022-11-24 14:38:04 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1896 | 2022-11-20 09:23:31 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1895 | 2022-11-16 19:54:24 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1894 | 2022-09-19 20:46:31 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1893 | 2022-09-18 15:24:09 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |
1892 | 2022-09-18 10:14:55 | day | 2 | 14084 | 490 | 0.330 | 42678.8 |
1891 | 2022-09-13 19:37:25 | day | 1 | 5146 | 32 | 0.080 | 64325.0 |
1890 | 2022-09-12 03:03:23 | day | 1 | 5146 | 32 | 0.076 | 67710.5 |