History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cream"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2022 | 2026-04-16 14:16:07 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 2021 | 2026-04-06 08:37:38 | cream | 1 | 28756 | 9 | 1.080 | 26625.9 |
| 2020 | 2026-04-05 18:59:15 | cream | 1 | 28756 | 9 | 1.046 | 27491.4 |
| 2019 | 2026-04-03 18:07:53 | cream | 1 | 28756 | 9 | 2.363 | 12169.3 |
| 2018 | 2026-04-02 21:41:41 | cream | 1 | 28756 | 9 | 2.846 | 10104.0 |
| 2017 | 2026-04-02 20:44:57 | cream | 1 | 28756 | 9 | 3.360 | 8558.3 |
| 2016 | 2026-04-02 08:51:35 | cream | 1 | 28756 | 9 | 1.826 | 15748.1 |
| 2015 | 2026-03-30 23:48:40 | cream | 2 | 53800 | 100 | 8.250 | 6521.2 |
| 2014 | 2026-03-29 18:00:22 | cream | 1 | 28756 | 9 | 1.206 | 23844.1 |
| 2013 | 2026-03-29 14:41:27 | cream | 1 | 28756 | 9 | 1.030 | 27918.4 |
| 2012 | 2026-03-29 14:33:05 | cream | 1 | 28756 | 9 | 0.843 | 34111.5 |
| 2011 | 2026-03-29 14:27:29 | cream | 1 | 28756 | 9 | 1.170 | 24577.8 |
| 2010 | 2026-03-29 02:20:30 | cream | 2 | 53800 | 100 | 7.936 | 6779.2 |
| 2009 | 2026-03-28 03:10:55 | cream | 2 | 53800 | 100 | 12.173 | 4419.6 |
| 2008 | 2026-03-25 23:00:44 | cream | 3 | 83667 | 1100 | 14.800 | 5653.2 |
| 2007 | 2026-03-25 14:09:02 | cream | 3 | 83667 | 1100 | 15.093 | 5543.4 |
| 2006 | 2026-03-24 18:02:28 | cream | 2 | 53800 | 100 | 7.956 | 6762.2 |
| 2005 | 2026-03-22 19:28:08 | cream | 1 | 28756 | 9 | 2.750 | 10456.7 |
| 2004 | 2026-03-20 19:32:44 | cream | 3 | 83667 | 1100 | 9.420 | 8881.8 |
| 2003 | 2026-03-18 15:55:13 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 2002 | 2026-03-17 07:00:55 | cream | 1 | 28756 | 9 | 0.546 | 52666.7 |
| 2001 | 2026-03-16 23:04:56 | cream | 1 | 28756 | 9 | 1.093 | 26309.2 |
| 2000 | 2026-03-13 09:09:28 | cream | 1 | 28756 | 9 | 1.563 | 18398.0 |
| 1999 | 2026-03-09 19:35:30 | cream | 2 | 53800 | 100 | 5.643 | 9533.9 |
| 1998 | 2026-03-09 07:20:21 | cream | 1 | 28756 | 9 | 0.486 | 59168.7 |
| 1997 | 2026-03-07 22:55:27 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1996 | 2026-03-07 06:09:07 | cream | 1 | 28756 | 9 | 0.530 | 54256.6 |
| 1995 | 2026-03-05 05:31:46 | cream | 1 | 28756 | 9 | 0.546 | 52666.7 |
| 1994 | 2026-02-15 16:12:41 | cream | 1 | 28756 | 9 | 0.530 | 54256.6 |
| 1993 | 2026-02-12 13:17:56 | cream | 1 | 28756 | 9 | 1.360 | 21144.1 |
| 1992 | 2026-02-11 08:50:54 | cream | 1 | 28756 | 9 | 0.486 | 59168.7 |
| 1991 | 2026-02-01 04:55:41 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1990 | 2026-02-01 04:26:42 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1989 | 2026-02-01 04:12:06 | cream | 1 | 28756 | 9 | 0.610 | 47141.0 |
| 1988 | 2026-01-27 01:24:37 | cream | 3 | 83667 | 1100 | 5.093 | 16427.8 |
| 1987 | 2026-01-23 01:40:53 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1986 | 2026-01-21 19:36:49 | cream | 1 | 28756 | 9 | 0.546 | 52666.7 |
| 1985 | 2026-01-15 12:31:40 | cream | 1 | 28756 | 9 | 1.016 | 28303.1 |
| 1984 | 2026-01-11 11:14:58 | cream | 1 | 28756 | 9 | 3.920 | 7335.7 |
| 1983 | 2026-01-10 12:08:38 | cream | 3 | 83667 | 1100 | 7.250 | 11540.3 |
| 1982 | 2026-01-10 12:08:27 | cream | 3 | 83667 | 1100 | 6.766 | 12365.8 |
| 1981 | 2026-01-09 17:16:00 | cream | 3 | 83667 | 1100 | 19.220 | 4353.1 |
| 1980 | 2026-01-09 17:15:41 | cream | 3 | 83667 | 1100 | 11.873 | 7046.8 |
| 1979 | 2026-01-04 07:25:09 | cream | 3 | 83667 | 1100 | 7.016 | 11925.2 |
| 1978 | 2025-12-28 14:46:57 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1977 | 2025-12-22 01:35:19 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1976 | 2025-12-19 09:26:49 | cream | 1 | 28756 | 9 | 0.563 | 51076.4 |
| 1975 | 2025-12-18 23:12:25 | cream | 1 | 28756 | 9 | 1.046 | 27491.4 |
| 1974 | 2025-12-05 05:00:01 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1973 | 2025-12-02 07:59:20 | cream | 1 | 28756 | 9 | 2.580 | 11145.7 |
| 1972 | 2025-11-24 17:48:15 | cream | 3 | 83667 | 1100 | 4.236 | 19751.4 |
| 1971 | 2025-11-24 17:46:44 | cream | 2 | 53800 | 100 | 2.016 | 26686.5 |
| 1970 | 2025-11-24 10:18:05 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1969 | 2025-11-22 12:32:03 | cream | 2 | 53800 | 100 | 7.763 | 6930.3 |
| 1968 | 2025-11-21 18:13:28 | cream | 1 | 28756 | 9 | 0.533 | 53951.2 |
| 1967 | 2025-11-18 12:30:10 | cream | 1 | 28756 | 9 | 0.533 | 53951.2 |
| 1966 | 2025-11-14 23:51:23 | cream | 1 | 28756 | 9 | 0.610 | 47141.0 |
| 1965 | 2025-11-14 16:27:43 | cream | 1 | 28756 | 9 | 0.563 | 51076.4 |
| 1964 | 2025-11-13 22:25:35 | cream | 1 | 28756 | 9 | 1.050 | 27386.7 |
| 1963 | 2025-11-13 16:56:03 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1962 | 2025-11-12 20:34:19 | cream | 1 | 28756 | 9 | 0.750 | 38341.3 |
| 1961 | 2025-11-11 09:37:30 | cream | 1 | 28756 | 9 | 0.483 | 59536.2 |
| 1960 | 2025-11-11 02:09:46 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1959 | 2025-10-29 00:39:13 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1958 | 2025-10-27 22:10:41 | cream | 3 | 83667 | 1100 | 4.046 | 20678.9 |
| 1957 | 2025-10-24 12:15:14 | cream | 3 | 83667 | 1100 | 3.516 | 23796.1 |
| 1956 | 2025-10-20 13:59:32 | cream | 3 | 83667 | 1100 | 19.593 | 4270.2 |
| 1955 | 2025-10-20 13:59:14 | cream | 3 | 83667 | 1100 | 15.453 | 5414.3 |
| 1954 | 2025-10-20 13:58:55 | cream | 3 | 83667 | 1100 | 19.423 | 4307.6 |
| 1953 | 2025-10-20 13:58:43 | cream | 3 | 83667 | 1100 | 10.313 | 8112.8 |
| 1952 | 2025-10-20 13:58:43 | cream | 2 | 53800 | 100 | 1.796 | 29955.5 |
| 1951 | 2025-10-20 12:39:50 | cream | 1 | 28756 | 9 | 0.466 | 61708.2 |
| 1950 | 2025-10-03 13:30:06 | cream | 3 | 83667 | 1100 | 4.330 | 19322.6 |
| 1949 | 2025-09-25 23:05:14 | cream | 2 | 53800 | 100 | 4.046 | 13297.1 |
| 1948 | 2025-09-25 21:50:58 | cream | 1 | 28756 | 9 | 1.063 | 27051.7 |
| 1947 | 2025-09-25 01:27:41 | cream | 3 | 83667 | 1100 | 13.423 | 6233.1 |
| 1946 | 2025-09-25 01:26:45 | cream | 3 | 83667 | 1100 | 13.643 | 6132.6 |
| 1945 | 2025-09-25 01:25:33 | cream | 3 | 83667 | 1100 | 21.436 | 3903.1 |
| 1944 | 2025-09-25 01:24:49 | cream | 3 | 83667 | 1100 | 24.016 | 3483.8 |
| 1943 | 2025-09-21 17:00:28 | cream | 3 | 83667 | 1100 | 8.296 | 10085.2 |
| 1942 | 2025-09-19 03:19:35 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1941 | 2025-09-17 12:52:54 | cream | 3 | 83667 | 1100 | 3.546 | 23594.8 |
| 1940 | 2025-09-15 19:36:48 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1939 | 2025-09-14 03:46:05 | cream | 1 | 28756 | 9 | 0.450 | 63902.2 |
| 1938 | 2025-09-12 11:58:25 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1937 | 2025-09-11 14:28:00 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1936 | 2025-09-09 04:17:49 | cream | 1 | 28756 | 9 | 1.033 | 27837.4 |
| 1935 | 2025-09-05 21:38:38 | cream | 1 | 28756 | 9 | 0.486 | 59168.7 |
| 1934 | 2025-09-02 14:21:44 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1933 | 2025-08-30 06:48:25 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1932 | 2025-08-26 23:32:10 | cream | 1 | 28756 | 9 | 1.093 | 26309.2 |
| 1931 | 2025-08-25 02:27:03 | cream | 1 | 28756 | 9 | 1.343 | 21411.8 |
| 1930 | 2025-08-24 22:17:55 | cream | 1 | 28756 | 9 | 1.843 | 15602.8 |
| 1929 | 2025-08-20 07:15:42 | cream | 1 | 28756 | 9 | 0.470 | 61183.0 |
| 1928 | 2025-08-14 14:02:15 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1927 | 2025-08-11 06:59:12 | cream | 3 | 83667 | 1100 | 29.490 | 2837.1 |
| 1926 | 2025-08-09 01:02:09 | cream | 3 | 83667 | 1100 | 13.796 | 6064.6 |
| 1925 | 2025-08-08 20:11:10 | cream | 3 | 83667 | 1100 | 15.906 | 5260.1 |
| 1924 | 2025-08-08 19:37:25 | cream | 3 | 83667 | 1100 | 4.030 | 20761.0 |
| 1923 | 2025-08-08 18:37:00 | cream | 3 | 83667 | 1100 | 3.513 | 23816.4 |