History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pale"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2017 | 2025-10-23 23:14:02 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 2016 | 2025-10-23 04:03:09 | pale | 1 | 13983 | 38 | 1.360 | 10281.6 |
| 2015 | 2025-10-22 20:35:16 | pale | 1 | 13983 | 38 | 1.313 | 10649.7 |
| 2014 | 2025-10-22 19:24:45 | pale | 1 | 13983 | 38 | 1.220 | 11461.5 |
| 2013 | 2025-10-22 13:17:46 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 2012 | 2025-10-22 13:11:30 | pale | 1 | 13983 | 38 | 1.376 | 10162.1 |
| 2011 | 2025-10-21 14:09:11 | pale | 2 | 29872 | 521 | 4.486 | 6658.9 |
| 2010 | 2025-10-20 03:43:29 | pale | 1 | 13983 | 38 | 0.500 | 27966.0 |
| 2009 | 2025-10-17 23:51:23 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 2008 | 2025-10-17 08:52:14 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 2007 | 2025-10-13 06:33:09 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 2006 | 2025-10-11 02:59:42 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 2005 | 2025-10-10 11:21:34 | pale | 1 | 13983 | 38 | 0.283 | 49409.9 |
| 2004 | 2025-10-06 14:27:09 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 2003 | 2025-10-05 00:15:06 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 2002 | 2025-10-04 08:38:02 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 2001 | 2025-10-04 00:28:33 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 2000 | 2025-09-28 11:18:07 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1999 | 2025-09-26 21:12:28 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1998 | 2025-09-26 07:43:48 | pale | 1 | 13983 | 38 | 0.236 | 59250.0 |
| 1997 | 2025-09-26 03:20:43 | pale | 1 | 13983 | 38 | 0.330 | 42372.7 |
| 1996 | 2025-09-24 23:07:37 | pale | 1 | 13983 | 38 | 0.560 | 24969.6 |
| 1995 | 2025-09-24 23:07:32 | pale | 1 | 13983 | 38 | 1.610 | 8685.1 |
| 1994 | 2025-09-24 23:07:24 | pale | 1 | 13983 | 38 | 1.283 | 10898.7 |
| 1993 | 2025-09-24 23:07:15 | pale | 1 | 13983 | 38 | 1.143 | 12233.6 |
| 1992 | 2025-09-24 12:27:19 | pale | 1 | 13983 | 38 | 0.516 | 27098.8 |
| 1991 | 2025-09-19 21:14:39 | pale | 2 | 29872 | 521 | 0.796 | 37527.6 |
| 1990 | 2025-09-18 19:10:13 | pale | 1 | 13983 | 38 | 0.470 | 29751.1 |
| 1989 | 2025-09-17 22:48:14 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1988 | 2025-09-17 22:14:47 | pale | 1 | 13983 | 38 | 0.280 | 49939.3 |
| 1987 | 2025-09-17 13:09:09 | pale | 1 | 13983 | 38 | 0.236 | 59250.0 |
| 1986 | 2025-09-14 14:27:24 | pale | 1 | 13983 | 38 | 0.513 | 27257.3 |
| 1985 | 2025-09-12 20:55:25 | pale | 1 | 13983 | 38 | 0.516 | 27098.8 |
| 1984 | 2025-09-11 06:27:47 | pale | 1 | 13983 | 38 | 0.530 | 26383.0 |
| 1983 | 2025-09-08 05:38:32 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1982 | 2025-09-08 01:33:48 | pale | 2 | 29872 | 521 | 0.906 | 32971.3 |
| 1981 | 2025-09-07 23:33:49 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1980 | 2025-09-07 06:05:27 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1979 | 2025-09-05 22:27:12 | pale | 1 | 13983 | 38 | 0.500 | 27966.0 |
| 1978 | 2025-09-04 16:33:59 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1977 | 2025-09-03 08:56:05 | pale | 1 | 13983 | 38 | 1.126 | 12418.3 |
| 1976 | 2025-09-01 22:13:42 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1975 | 2025-09-01 21:34:15 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1974 | 2025-09-01 09:11:33 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1973 | 2025-08-30 14:05:50 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1972 | 2025-08-29 04:50:50 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1971 | 2025-08-29 01:34:16 | pale | 1 | 13983 | 38 | 0.263 | 53167.3 |
| 1970 | 2025-08-28 11:06:55 | pale | 1 | 13983 | 38 | 0.236 | 59250.0 |
| 1969 | 2025-08-27 15:26:59 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1968 | 2025-08-27 02:26:14 | pale | 1 | 13983 | 38 | 0.280 | 49939.3 |
| 1967 | 2025-08-26 23:48:24 | pale | 1 | 13983 | 38 | 0.376 | 37188.8 |
| 1966 | 2025-08-26 10:18:31 | pale | 1 | 13983 | 38 | 0.263 | 53167.3 |
| 1965 | 2025-08-23 14:14:00 | pale | 1 | 13983 | 38 | 1.720 | 8129.7 |
| 1964 | 2025-08-22 10:18:30 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1963 | 2025-08-22 05:26:44 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1962 | 2025-08-20 01:22:35 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1961 | 2025-08-18 06:43:17 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1960 | 2025-08-17 23:43:16 | pale | 1 | 13983 | 38 | 0.516 | 27098.8 |
| 1959 | 2025-08-17 03:31:39 | pale | 1 | 13983 | 38 | 0.670 | 20870.1 |
| 1958 | 2025-08-16 21:56:25 | pale | 1 | 13983 | 38 | 1.343 | 10411.8 |
| 1957 | 2025-08-15 17:42:38 | pale | 1 | 13983 | 38 | 0.300 | 46610.0 |
| 1956 | 2025-08-09 14:18:44 | pale | 1 | 13983 | 38 | 1.156 | 12096.0 |
| 1955 | 2025-08-09 08:52:59 | pale | 1 | 13983 | 38 | 0.673 | 20777.1 |
| 1954 | 2025-08-09 07:45:53 | pale | 1 | 13983 | 38 | 1.393 | 10038.0 |
| 1953 | 2025-08-06 15:31:10 | pale | 1 | 13983 | 38 | 0.643 | 21746.5 |
| 1952 | 2025-08-05 20:53:53 | pale | 2 | 29872 | 521 | 2.220 | 13455.9 |
| 1951 | 2025-08-04 07:34:06 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1950 | 2025-08-03 18:18:30 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1949 | 2025-08-03 13:51:53 | pale | 2 | 29872 | 521 | 1.016 | 29401.6 |
| 1948 | 2025-08-03 11:41:02 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1947 | 2025-08-02 22:38:30 | pale | 1 | 13983 | 38 | 0.673 | 20777.1 |
| 1946 | 2025-08-02 17:18:46 | pale | 1 | 13983 | 38 | 0.703 | 19890.5 |
| 1945 | 2025-08-02 12:51:33 | pale | 1 | 13983 | 38 | 1.220 | 11461.5 |
| 1944 | 2025-08-01 22:51:20 | pale | 2 | 29872 | 521 | 1.860 | 16060.2 |
| 1943 | 2025-08-01 07:58:47 | pale | 1 | 13983 | 38 | 0.283 | 49409.9 |
| 1942 | 2025-07-28 11:33:09 | pale | 1 | 13983 | 38 | 0.343 | 40766.8 |
| 1941 | 2025-07-27 01:02:11 | pale | 1 | 13983 | 38 | 0.936 | 14939.1 |
| 1940 | 2025-07-24 20:44:32 | pale | 1 | 13983 | 38 | 0.830 | 16847.0 |
| 1939 | 2025-07-22 15:56:23 | pale | 1 | 13983 | 38 | 2.000 | 6991.5 |
| 1938 | 2025-07-22 00:29:25 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1937 | 2025-07-19 21:32:13 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1936 | 2025-07-18 08:58:39 | pale | 2 | 29872 | 521 | 4.873 | 6130.1 |
| 1935 | 2025-07-17 21:04:08 | pale | 1 | 13983 | 38 | 1.126 | 12418.3 |
| 1934 | 2025-07-17 16:06:56 | pale | 1 | 13983 | 38 | 2.310 | 6053.2 |
| 1933 | 2025-07-17 13:48:53 | pale | 1 | 13983 | 38 | 0.876 | 15962.3 |
| 1932 | 2025-07-17 05:13:22 | pale | 1 | 13983 | 38 | 0.483 | 28950.3 |
| 1931 | 2025-07-15 20:08:27 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1930 | 2025-07-13 16:26:13 | pale | 1 | 13983 | 38 | 0.873 | 16017.2 |
| 1929 | 2025-07-13 05:44:32 | pale | 1 | 13983 | 38 | 0.500 | 27966.0 |
| 1928 | 2025-07-09 08:43:17 | pale | 1 | 13983 | 38 | 0.280 | 49939.3 |
| 1927 | 2025-07-09 06:23:59 | pale | 1 | 13983 | 38 | 0.686 | 20383.4 |
| 1926 | 2025-07-08 08:20:05 | pale | 1 | 13983 | 38 | 2.030 | 6888.2 |
| 1925 | 2025-07-08 00:52:21 | pale | 1 | 13983 | 38 | 0.686 | 20383.4 |
| 1924 | 2025-07-06 13:34:53 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1923 | 2025-07-01 06:06:05 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1922 | 2025-06-30 17:09:36 | pale | 1 | 13983 | 38 | 1.673 | 8358.0 |
| 1921 | 2025-06-30 08:52:17 | pale | 1 | 13983 | 38 | 0.690 | 20265.2 |
| 1920 | 2025-06-29 21:22:35 | pale | 1 | 13983 | 38 | 1.626 | 8599.6 |
| 1919 | 2025-06-29 00:22:20 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1918 | 2025-06-28 11:18:34 | pale | 1 | 13983 | 38 | 1.390 | 10059.7 |