History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hay"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2019 | 2025-10-27 03:19:41 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 2018 | 2025-10-25 23:15:12 | hay | 2 | 14084 | 516 | 0.376 | 37457.4 |
| 2017 | 2025-10-25 17:14:54 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 2016 | 2025-10-25 06:52:18 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 2015 | 2025-10-25 03:27:01 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 2014 | 2025-10-24 20:34:28 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 2013 | 2025-10-23 04:48:09 | hay | 1 | 5146 | 35 | 0.576 | 8934.0 |
| 2012 | 2025-10-21 13:30:54 | hay | 1 | 5146 | 35 | 0.266 | 19345.9 |
| 2011 | 2025-10-18 13:30:38 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 2010 | 2025-10-18 00:29:55 | hay | 1 | 5146 | 35 | 0.080 | 64325.0 |
| 2009 | 2025-10-17 23:48:42 | hay | 2 | 14084 | 516 | 0.346 | 40705.2 |
| 2008 | 2025-10-17 09:33:10 | hay | 1 | 5146 | 35 | 0.080 | 64325.0 |
| 2007 | 2025-10-12 09:21:06 | hay | 2 | 14084 | 516 | 0.326 | 43202.5 |
| 2006 | 2025-10-12 08:11:25 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 2005 | 2025-10-11 12:04:18 | hay | 1 | 5146 | 35 | 0.186 | 27666.7 |
| 2004 | 2025-10-11 09:01:57 | hay | 1 | 5146 | 35 | 0.436 | 11802.8 |
| 2003 | 2025-10-11 09:01:21 | hay | 1 | 5146 | 35 | 0.406 | 12674.9 |
| 2002 | 2025-10-11 09:00:44 | hay | 1 | 5146 | 35 | 0.376 | 13686.2 |
| 2001 | 2025-10-09 01:04:45 | hay | 2 | 14084 | 516 | 0.406 | 34689.7 |
| 2000 | 2025-10-07 09:38:40 | hay | 2 | 14084 | 516 | 0.390 | 36112.8 |
| 1999 | 2025-10-06 23:22:06 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1998 | 2025-10-06 09:01:22 | hay | 2 | 14084 | 516 | 0.390 | 36112.8 |
| 1997 | 2025-10-05 22:27:49 | hay | 1 | 5146 | 35 | 0.110 | 46781.8 |
| 1996 | 2025-10-02 16:28:19 | hay | 1 | 5146 | 35 | 0.170 | 30270.6 |
| 1995 | 2025-10-02 05:23:45 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1994 | 2025-09-29 15:48:28 | hay | 2 | 14084 | 516 | 0.373 | 37758.7 |
| 1993 | 2025-09-26 05:57:34 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1992 | 2025-09-22 04:15:10 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1991 | 2025-09-21 06:42:42 | hay | 2 | 14084 | 516 | 0.390 | 36112.8 |
| 1990 | 2025-09-19 04:01:01 | hay | 1 | 5146 | 35 | 0.173 | 29745.7 |
| 1989 | 2025-09-18 21:45:52 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1988 | 2025-09-17 05:22:15 | hay | 1 | 5146 | 35 | 0.096 | 53604.2 |
| 1987 | 2025-09-15 20:14:11 | hay | 1 | 5146 | 35 | 0.186 | 27666.7 |
| 1986 | 2025-09-15 10:47:49 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1985 | 2025-09-14 10:41:19 | hay | 2 | 14084 | 516 | 0.780 | 18056.4 |
| 1984 | 2025-09-13 20:00:38 | hay | 1 | 5146 | 35 | 0.080 | 64325.0 |
| 1983 | 2025-09-13 14:20:55 | hay | 1 | 5146 | 35 | 0.096 | 53604.2 |
| 1982 | 2025-09-12 13:21:24 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1981 | 2025-09-12 12:39:53 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1980 | 2025-09-11 04:23:05 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1979 | 2025-09-09 04:58:28 | hay | 1 | 5146 | 35 | 0.080 | 64325.0 |
| 1978 | 2025-09-08 22:14:47 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1977 | 2025-09-08 03:11:56 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1976 | 2025-09-08 00:03:01 | hay | 2 | 14084 | 516 | 0.346 | 40705.2 |
| 1975 | 2025-09-05 22:07:37 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1974 | 2025-09-05 21:22:39 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1973 | 2025-09-05 19:56:31 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1972 | 2025-09-05 16:06:44 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1971 | 2025-09-05 02:04:50 | hay | 2 | 14084 | 516 | 0.343 | 41061.2 |
| 1970 | 2025-09-03 16:59:28 | hay | 1 | 5146 | 35 | 0.170 | 30270.6 |
| 1969 | 2025-09-02 15:23:04 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1968 | 2025-09-01 17:17:23 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1967 | 2025-08-31 23:31:39 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1966 | 2025-08-31 19:54:55 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1965 | 2025-08-30 15:26:29 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1964 | 2025-08-30 07:24:46 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1963 | 2025-08-28 13:57:19 | hay | 1 | 5146 | 35 | 0.096 | 53604.2 |
| 1962 | 2025-08-27 17:41:18 | hay | 2 | 14084 | 516 | 0.390 | 36112.8 |
| 1961 | 2025-08-27 14:56:19 | hay | 2 | 14084 | 516 | 0.453 | 31090.5 |
| 1960 | 2025-08-27 12:06:42 | hay | 1 | 5146 | 35 | 0.096 | 53604.2 |
| 1959 | 2025-08-27 08:28:48 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1958 | 2025-08-27 07:07:47 | hay | 1 | 5146 | 35 | 0.266 | 19345.9 |
| 1957 | 2025-08-27 01:28:33 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1956 | 2025-08-27 00:36:30 | hay | 1 | 5146 | 35 | 0.186 | 27666.7 |
| 1955 | 2025-08-26 21:21:50 | hay | 1 | 5146 | 35 | 0.090 | 57177.8 |
| 1954 | 2025-08-26 20:26:52 | hay | 1 | 5146 | 35 | 0.500 | 10292.0 |
| 1953 | 2025-08-26 13:16:09 | hay | 2 | 14084 | 516 | 0.470 | 29966.0 |
| 1952 | 2025-08-26 03:43:04 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1951 | 2025-08-25 19:37:55 | hay | 1 | 5146 | 35 | 0.080 | 64325.0 |
| 1950 | 2025-08-24 21:03:42 | hay | 1 | 5146 | 35 | 0.670 | 7680.6 |
| 1949 | 2025-08-24 18:56:04 | hay | 1 | 5146 | 35 | 0.516 | 9972.9 |
| 1948 | 2025-08-21 15:51:45 | hay | 1 | 5146 | 35 | 0.500 | 10292.0 |
| 1947 | 2025-08-21 13:55:37 | hay | 2 | 14084 | 516 | 0.843 | 16707.0 |
| 1946 | 2025-08-21 01:16:37 | hay | 2 | 14084 | 516 | 0.826 | 17050.8 |
| 1945 | 2025-08-20 13:38:17 | hay | 1 | 5146 | 35 | 0.076 | 67710.5 |
| 1944 | 2025-08-20 09:37:20 | hay | 2 | 14084 | 516 | 0.376 | 37457.4 |
| 1943 | 2025-08-20 07:57:39 | hay | 1 | 5146 | 35 | 0.190 | 27084.2 |
| 1942 | 2025-08-18 22:10:22 | hay | 1 | 5146 | 35 | 0.673 | 7646.4 |
| 1941 | 2025-08-09 11:31:34 | hay | 1 | 5146 | 35 | 0.686 | 7501.5 |
| 1940 | 2025-08-01 12:58:51 | hay | 2 | 14084 | 516 | 1.673 | 8418.4 |
| 1939 | 2025-08-01 10:15:51 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1938 | 2025-07-31 04:31:38 | hay | 1 | 5146 | 35 | 0.186 | 27666.7 |
| 1937 | 2025-07-30 22:02:51 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1936 | 2025-07-28 21:24:09 | hay | 2 | 14084 | 516 | 1.356 | 10386.4 |
| 1935 | 2025-07-28 01:38:37 | hay | 2 | 14084 | 516 | 1.110 | 12688.3 |
| 1934 | 2025-07-26 20:07:55 | hay | 2 | 14084 | 516 | 0.470 | 29966.0 |
| 1933 | 2025-07-26 15:39:59 | hay | 1 | 5146 | 35 | 0.280 | 18378.6 |
| 1932 | 2025-07-26 15:39:57 | hay | 1 | 5146 | 35 | 0.610 | 8436.1 |
| 1931 | 2025-07-26 04:58:50 | hay | 2 | 14084 | 516 | 2.560 | 5501.6 |
| 1930 | 2025-07-26 02:17:10 | hay | 2 | 14084 | 516 | 0.390 | 36112.8 |
| 1929 | 2025-07-25 00:42:57 | hay | 1 | 5146 | 35 | 0.203 | 25349.8 |
| 1928 | 2025-07-24 23:51:42 | hay | 1 | 5146 | 35 | 0.110 | 46781.8 |
| 1927 | 2025-07-24 17:24:56 | hay | 2 | 14084 | 516 | 1.203 | 11707.4 |
| 1926 | 2025-07-24 05:58:25 | hay | 1 | 5146 | 35 | 0.733 | 7020.5 |
| 1925 | 2025-07-24 05:18:52 | hay | 1 | 5146 | 35 | 0.326 | 15785.3 |
| 1924 | 2025-07-23 23:59:26 | hay | 1 | 5146 | 35 | 0.096 | 53604.2 |
| 1923 | 2025-07-22 19:02:42 | hay | 1 | 5146 | 35 | 0.640 | 8040.6 |
| 1922 | 2025-07-22 01:25:17 | hay | 2 | 14084 | 516 | 0.343 | 41061.2 |
| 1921 | 2025-07-21 03:27:54 | hay | 1 | 5146 | 35 | 0.093 | 55333.3 |
| 1920 | 2025-07-20 07:14:58 | hay | 2 | 14084 | 516 | 0.390 | 36112.8 |