History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"valley"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2037 | 2025-10-25 23:54:51 | valley | 2 | 82551 | 75 | 2.500 | 33020.4 |
| 2036 | 2025-10-23 21:10:36 | valley | 1 | 48755 | 5 | 6.156 | 7919.9 |
| 2035 | 2025-10-20 04:16:34 | valley | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 2034 | 2025-10-18 02:04:01 | valley | 2 | 82551 | 75 | 2.203 | 37472.1 |
| 2033 | 2025-10-08 05:59:22 | valley | 2 | 82551 | 75 | 2.640 | 31269.3 |
| 2032 | 2025-10-07 02:37:07 | valley | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 2031 | 2025-10-01 09:02:58 | valley | 2 | 82551 | 75 | 2.626 | 31436.0 |
| 2030 | 2025-09-25 13:33:21 | valley | 1 | 48755 | 5 | 2.190 | 22262.6 |
| 2029 | 2025-09-25 13:33:18 | valley | 1 | 48755 | 5 | 4.233 | 11517.8 |
| 2028 | 2025-09-25 13:33:14 | valley | 1 | 48755 | 5 | 1.563 | 31193.2 |
| 2027 | 2025-09-25 13:33:09 | valley | 1 | 48755 | 5 | 3.143 | 15512.2 |
| 2026 | 2025-09-23 20:14:31 | valley | 2 | 82551 | 75 | 2.360 | 34979.2 |
| 2025 | 2025-09-22 15:28:37 | valley | 1 | 48755 | 5 | 1.170 | 41670.9 |
| 2024 | 2025-09-17 05:45:03 | valley | 3 | 112716 | 774 | 4.906 | 22975.1 |
| 2023 | 2025-09-16 21:03:13 | valley | 2 | 82551 | 75 | 2.533 | 32590.2 |
| 2022 | 2025-09-15 07:08:40 | valley | 3 | 112716 | 774 | 5.546 | 20323.8 |
| 2021 | 2025-09-14 09:41:21 | valley | 2 | 82551 | 75 | 2.576 | 32046.2 |
| 2020 | 2025-09-12 16:15:33 | valley | 3 | 112716 | 774 | 5.436 | 20735.1 |
| 2019 | 2025-09-10 04:19:11 | valley | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 2018 | 2025-09-09 23:29:01 | valley | 2 | 82551 | 75 | 2.436 | 33887.9 |
| 2017 | 2025-09-09 22:48:17 | valley | 3 | 112716 | 774 | 5.486 | 20546.1 |
| 2016 | 2025-09-09 22:47:47 | valley | 2 | 82551 | 75 | 2.140 | 38575.2 |
| 2015 | 2025-09-07 19:34:35 | valley | 2 | 82551 | 75 | 2.423 | 34069.7 |
| 2014 | 2025-09-07 14:15:53 | valley | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 2013 | 2025-09-07 08:05:03 | valley | 2 | 82551 | 75 | 2.250 | 36689.3 |
| 2012 | 2025-09-03 13:27:39 | valley | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 2011 | 2025-08-31 14:57:03 | valley | 3 | 112716 | 774 | 5.470 | 20606.2 |
| 2010 | 2025-08-30 22:29:51 | valley | 2 | 82551 | 75 | 2.436 | 33887.9 |
| 2009 | 2025-08-25 01:47:26 | valley | 1 | 48755 | 5 | 4.000 | 12188.8 |
| 2008 | 2025-08-24 23:07:04 | valley | 1 | 48755 | 5 | 6.343 | 7686.4 |
| 2007 | 2025-08-16 16:54:15 | valley | 3 | 112716 | 774 | 5.140 | 21929.2 |
| 2006 | 2025-08-15 15:17:45 | valley | 2 | 82551 | 75 | 6.360 | 12979.7 |
| 2005 | 2025-08-14 02:27:19 | valley | 3 | 112716 | 774 | 11.233 | 10034.4 |
| 2004 | 2025-08-12 08:34:11 | valley | 1 | 48755 | 5 | 1.953 | 24964.2 |
| 2003 | 2025-08-09 06:09:22 | valley | 1 | 48755 | 5 | 3.656 | 13335.6 |
| 2002 | 2025-08-09 05:05:14 | valley | 1 | 48755 | 5 | 1.626 | 29984.6 |
| 2001 | 2025-08-08 23:38:22 | valley | 1 | 48755 | 5 | 2.000 | 24377.5 |
| 2000 | 2025-08-05 03:25:33 | valley | 2 | 82551 | 75 | 11.360 | 7266.8 |
| 1999 | 2025-08-05 00:43:51 | valley | 2 | 82551 | 75 | 6.326 | 13049.5 |
| 1998 | 2025-08-04 01:15:20 | valley | 2 | 82551 | 75 | 3.906 | 21134.4 |
| 1997 | 2025-08-01 07:54:26 | valley | 1 | 48755 | 5 | 1.766 | 27607.6 |
| 1996 | 2025-07-30 08:55:05 | valley | 3 | 112716 | 774 | 13.766 | 8188.0 |
| 1995 | 2025-07-29 18:38:05 | valley | 2 | 82551 | 75 | 7.283 | 11334.8 |
| 1994 | 2025-07-28 01:20:20 | valley | 3 | 112716 | 774 | 13.266 | 8496.6 |
| 1993 | 2025-07-28 01:16:04 | valley | 2 | 82551 | 75 | 8.470 | 9746.3 |
| 1992 | 2025-07-27 22:37:28 | valley | 3 | 112716 | 774 | 13.750 | 8197.5 |
| 1991 | 2025-07-26 22:50:53 | valley | 3 | 112716 | 774 | 30.936 | 3643.5 |
| 1990 | 2025-07-25 00:12:20 | valley | 1 | 48755 | 5 | 1.686 | 28917.6 |
| 1989 | 2025-07-24 09:22:42 | valley | 3 | 112716 | 774 | 26.503 | 4253.0 |
| 1988 | 2025-07-24 01:26:38 | valley | 1 | 48755 | 5 | 2.986 | 16327.9 |
| 1987 | 2025-07-24 00:48:56 | valley | 1 | 48755 | 5 | 4.656 | 10471.4 |
| 1986 | 2025-07-23 12:22:46 | valley | 3 | 112716 | 774 | 19.783 | 5697.6 |
| 1985 | 2025-07-23 07:39:59 | valley | 1 | 48755 | 5 | 2.796 | 17437.4 |
| 1984 | 2025-07-19 07:08:38 | valley | 3 | 112716 | 774 | 5.813 | 19390.3 |
| 1983 | 2025-07-18 21:06:07 | valley | 2 | 82551 | 75 | 13.063 | 6319.5 |
| 1982 | 2025-07-18 05:35:21 | valley | 1 | 48755 | 5 | 2.450 | 19900.0 |
| 1981 | 2025-07-18 00:36:10 | valley | 1 | 48755 | 5 | 3.030 | 16090.8 |
| 1980 | 2025-07-17 14:27:09 | valley | 3 | 112716 | 774 | 15.546 | 7250.5 |
| 1979 | 2025-07-16 22:50:05 | valley | 3 | 112716 | 774 | 13.643 | 8261.8 |
| 1978 | 2025-07-15 17:59:23 | valley | 1 | 48755 | 5 | 1.046 | 46610.9 |
| 1977 | 2025-07-15 10:20:37 | valley | 3 | 112716 | 774 | 27.063 | 4164.9 |
| 1976 | 2025-07-13 04:20:50 | valley | 2 | 82551 | 75 | 2.470 | 33421.5 |
| 1975 | 2025-07-11 10:07:42 | valley | 2 | 82551 | 75 | 18.626 | 4432.0 |
| 1974 | 2025-07-10 14:31:06 | valley | 3 | 112716 | 774 | 18.160 | 6206.8 |
| 1973 | 2025-07-10 10:27:44 | valley | 2 | 82551 | 75 | 2.110 | 39123.7 |
| 1972 | 2025-07-07 19:12:38 | valley | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 1971 | 2025-07-07 13:21:09 | valley | 3 | 112716 | 774 | 28.736 | 3922.5 |
| 1970 | 2025-07-06 21:16:59 | valley | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 1969 | 2025-07-05 15:57:10 | valley | 3 | 112716 | 774 | 36.976 | 3048.4 |
| 1968 | 2025-07-04 23:22:45 | valley | 1 | 48755 | 5 | 4.140 | 11776.6 |
| 1967 | 2025-07-04 16:44:43 | valley | 2 | 82551 | 75 | 4.076 | 20252.9 |
| 1966 | 2025-07-04 11:29:09 | valley | 1 | 48755 | 5 | 2.126 | 22932.7 |
| 1965 | 2025-07-03 00:52:14 | valley | 2 | 82551 | 75 | 15.843 | 5210.6 |
| 1964 | 2025-07-02 05:03:18 | valley | 1 | 48755 | 5 | 5.376 | 9069.0 |
| 1963 | 2025-06-27 06:49:02 | valley | 1 | 48755 | 5 | 5.783 | 8430.7 |
| 1962 | 2025-06-26 18:27:25 | valley | 2 | 82551 | 75 | 12.436 | 6638.1 |
| 1961 | 2025-06-25 04:46:14 | valley | 3 | 112716 | 774 | 20.220 | 5574.5 |
| 1960 | 2025-06-21 20:06:29 | valley | 1 | 48755 | 5 | 2.576 | 18926.6 |
| 1959 | 2025-06-20 14:05:57 | valley | 1 | 48755 | 5 | 5.856 | 8325.6 |
| 1958 | 2025-06-20 02:23:01 | valley | 1 | 48755 | 5 | 6.170 | 7901.9 |
| 1957 | 2025-06-20 00:22:25 | valley | 1 | 48755 | 5 | 4.500 | 10834.4 |
| 1956 | 2025-06-16 22:30:50 | valley | 1 | 48755 | 5 | 3.966 | 12293.2 |
| 1955 | 2025-06-16 06:08:45 | valley | 1 | 48755 | 5 | 3.923 | 12428.0 |
| 1954 | 2025-06-10 15:50:23 | valley | 1 | 48755 | 5 | 4.460 | 10931.6 |
| 1953 | 2025-06-10 10:46:58 | valley | 2 | 82551 | 75 | 9.596 | 8602.6 |
| 1952 | 2025-06-08 05:36:49 | valley | 1 | 48755 | 5 | 2.106 | 23150.5 |
| 1951 | 2025-06-06 14:23:22 | valley | 2 | 82551 | 75 | 6.670 | 12376.5 |
| 1950 | 2025-06-05 23:35:43 | valley | 1 | 48755 | 5 | 4.546 | 10724.8 |
| 1949 | 2025-06-04 18:49:01 | valley | 2 | 82551 | 75 | 13.030 | 6335.5 |
| 1948 | 2025-06-04 03:08:17 | valley | 1 | 48755 | 5 | 2.673 | 18239.8 |
| 1947 | 2025-06-03 23:07:52 | valley | 1 | 48755 | 5 | 2.593 | 18802.5 |
| 1946 | 2025-06-03 23:06:20 | valley | 3 | 112716 | 774 | 24.253 | 4647.5 |
| 1945 | 2025-06-02 17:43:46 | valley | 3 | 112716 | 774 | 6.466 | 17432.1 |
| 1944 | 2025-06-02 15:24:15 | valley | 3 | 112716 | 774 | 32.676 | 3449.5 |
| 1943 | 2025-06-02 12:43:55 | valley | 3 | 112716 | 774 | 17.963 | 6274.9 |
| 1942 | 2025-06-02 09:06:39 | valley | 1 | 48755 | 5 | 4.406 | 11065.6 |
| 1941 | 2025-06-02 06:07:52 | valley | 3 | 112716 | 774 | 29.690 | 3796.4 |
| 1940 | 2025-06-02 04:43:00 | valley | 1 | 48755 | 5 | 3.343 | 14584.2 |
| 1939 | 2025-06-01 10:10:23 | valley | 3 | 112716 | 774 | 5.596 | 20142.2 |
| 1938 | 2025-05-30 14:09:02 | valley | 2 | 82551 | 75 | 13.876 | 5949.2 |