History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pill"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2037 | 2026-03-08 17:09:38 | pill | 1 | 13983 | 28 | 0.220 | 63559.1 |
| 2036 | 2026-03-07 02:16:54 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2035 | 2026-03-04 03:41:30 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2034 | 2026-02-22 03:18:39 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2033 | 2026-02-22 00:29:54 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 2032 | 2026-02-21 14:03:17 | pill | 1 | 13983 | 28 | 0.266 | 52567.7 |
| 2031 | 2026-02-20 21:01:18 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 2030 | 2026-02-20 20:09:50 | pill | 1 | 13983 | 28 | 0.500 | 27966.0 |
| 2029 | 2026-02-18 22:46:55 | pill | 1 | 13983 | 28 | 1.126 | 12418.3 |
| 2028 | 2026-02-18 12:09:21 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2027 | 2026-02-15 11:30:00 | pill | 1 | 13983 | 28 | 0.673 | 20777.1 |
| 2026 | 2026-02-14 20:46:31 | pill | 1 | 13983 | 28 | 0.266 | 52567.7 |
| 2025 | 2026-02-12 09:22:06 | pill | 1 | 13983 | 28 | 0.263 | 53167.3 |
| 2024 | 2026-02-12 09:19:27 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2023 | 2026-02-09 13:54:48 | pill | 2 | 29872 | 284 | 1.296 | 23049.4 |
| 2022 | 2026-02-08 19:08:44 | pill | 1 | 13983 | 28 | 0.343 | 40766.8 |
| 2021 | 2026-02-07 04:41:32 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2020 | 2026-02-06 18:40:26 | pill | 1 | 13983 | 28 | 0.263 | 53167.3 |
| 2019 | 2026-02-06 18:22:00 | pill | 1 | 13983 | 28 | 0.266 | 52567.7 |
| 2018 | 2026-02-06 14:38:30 | pill | 2 | 29872 | 284 | 1.830 | 16323.5 |
| 2017 | 2026-02-06 04:22:56 | pill | 1 | 13983 | 28 | 0.236 | 59250.0 |
| 2016 | 2026-02-05 12:13:58 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2015 | 2026-02-05 06:20:14 | pill | 2 | 29872 | 284 | 0.800 | 37340.0 |
| 2014 | 2026-02-04 18:37:44 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2013 | 2026-02-04 12:23:41 | pill | 1 | 13983 | 28 | 0.283 | 49409.9 |
| 2012 | 2026-02-04 05:54:26 | pill | 1 | 13983 | 28 | 0.283 | 49409.9 |
| 2011 | 2026-02-03 09:45:06 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 2010 | 2026-02-02 13:58:22 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2009 | 2026-02-02 01:35:07 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2008 | 2026-02-01 19:09:43 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2007 | 2026-02-01 03:40:54 | pill | 1 | 13983 | 28 | 0.263 | 53167.3 |
| 2006 | 2026-02-01 02:50:04 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2005 | 2026-02-01 01:31:23 | pill | 1 | 13983 | 28 | 0.266 | 52567.7 |
| 2004 | 2026-01-31 13:28:41 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2003 | 2026-01-30 15:40:06 | pill | 1 | 13983 | 28 | 0.640 | 21848.4 |
| 2002 | 2026-01-30 02:25:29 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 2001 | 2026-01-29 07:10:38 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 2000 | 2026-01-28 13:57:19 | pill | 1 | 13983 | 28 | 0.266 | 52567.7 |
| 1999 | 2026-01-28 10:35:35 | pill | 1 | 13983 | 28 | 0.236 | 59250.0 |
| 1998 | 2026-01-28 09:31:32 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1997 | 2026-01-28 09:09:13 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 1996 | 2026-01-28 09:07:58 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1995 | 2026-01-26 21:04:08 | pill | 1 | 13983 | 28 | 0.296 | 47239.9 |
| 1994 | 2026-01-19 12:38:44 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1993 | 2026-01-19 12:35:47 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1992 | 2026-01-16 08:25:26 | pill | 1 | 13983 | 28 | 0.906 | 15433.8 |
| 1991 | 2026-01-15 23:40:42 | pill | 1 | 13983 | 28 | 0.360 | 38841.7 |
| 1990 | 2026-01-06 18:45:05 | pill | 1 | 13983 | 28 | 0.280 | 49939.3 |
| 1989 | 2026-01-05 09:22:00 | pill | 1 | 13983 | 28 | 0.263 | 53167.3 |
| 1988 | 2025-12-28 22:35:46 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1987 | 2025-12-24 02:21:15 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 1986 | 2025-12-21 13:22:32 | pill | 1 | 13983 | 28 | 0.266 | 52567.7 |
| 1985 | 2025-12-19 14:22:07 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1984 | 2025-12-19 14:18:13 | pill | 1 | 13983 | 28 | 0.280 | 49939.3 |
| 1983 | 2025-12-19 10:28:50 | pill | 2 | 29872 | 284 | 3.420 | 8734.5 |
| 1982 | 2025-12-12 05:51:12 | pill | 1 | 13983 | 28 | 0.716 | 19529.3 |
| 1981 | 2025-12-10 17:28:31 | pill | 2 | 29872 | 284 | 0.780 | 38297.4 |
| 1980 | 2025-12-08 13:56:35 | pill | 2 | 29872 | 284 | 0.860 | 34734.9 |
| 1979 | 2025-12-06 05:42:37 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1978 | 2025-12-01 21:24:45 | pill | 2 | 29872 | 284 | 0.856 | 34897.2 |
| 1977 | 2025-12-01 15:24:39 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1976 | 2025-11-20 23:48:32 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1975 | 2025-11-19 21:22:05 | pill | 1 | 13983 | 28 | 0.813 | 17199.3 |
| 1974 | 2025-11-19 13:29:08 | pill | 2 | 29872 | 284 | 0.843 | 35435.3 |
| 1973 | 2025-11-18 06:30:53 | pill | 1 | 13983 | 28 | 0.236 | 59250.0 |
| 1972 | 2025-11-16 12:31:48 | pill | 2 | 29872 | 284 | 0.830 | 35990.4 |
| 1971 | 2025-11-15 23:16:47 | pill | 1 | 13983 | 28 | 0.516 | 27098.8 |
| 1970 | 2025-11-15 20:43:45 | pill | 1 | 13983 | 28 | 0.670 | 20870.1 |
| 1969 | 2025-11-14 09:28:56 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 1968 | 2025-11-13 16:32:06 | pill | 1 | 13983 | 28 | 0.233 | 60012.9 |
| 1967 | 2025-11-10 20:23:19 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1966 | 2025-11-05 13:54:14 | pill | 1 | 13983 | 28 | 0.263 | 53167.3 |
| 1965 | 2025-10-30 16:27:21 | pill | 2 | 29872 | 284 | 1.000 | 29872.0 |
| 1964 | 2025-10-30 01:21:35 | pill | 1 | 13983 | 28 | 0.263 | 53167.3 |
| 1963 | 2025-10-13 07:18:01 | pill | 1 | 13983 | 28 | 1.016 | 13762.8 |
| 1962 | 2025-10-11 11:33:18 | pill | 1 | 13983 | 28 | 0.236 | 59250.0 |
| 1961 | 2025-10-06 14:27:47 | pill | 1 | 13983 | 28 | 0.280 | 49939.3 |
| 1960 | 2025-09-26 10:32:56 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1959 | 2025-09-25 16:04:01 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1958 | 2025-09-20 21:22:21 | pill | 2 | 29872 | 284 | 0.813 | 36742.9 |
| 1957 | 2025-09-16 09:28:22 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1956 | 2025-09-13 17:39:56 | pill | 1 | 13983 | 28 | 0.266 | 52567.7 |
| 1955 | 2025-09-08 11:18:58 | pill | 2 | 29872 | 284 | 0.750 | 39829.3 |
| 1954 | 2025-09-06 05:30:56 | pill | 2 | 29872 | 284 | 0.750 | 39829.3 |
| 1953 | 2025-09-03 07:06:09 | pill | 1 | 13983 | 28 | 0.216 | 64736.1 |
| 1952 | 2025-08-27 10:04:19 | pill | 2 | 29872 | 284 | 0.750 | 39829.3 |
| 1951 | 2025-08-26 22:58:20 | pill | 1 | 13983 | 28 | 0.280 | 49939.3 |
| 1950 | 2025-08-26 22:25:34 | pill | 1 | 13983 | 28 | 0.236 | 59250.0 |
| 1949 | 2025-08-19 17:14:15 | pill | 1 | 13983 | 28 | 0.580 | 24108.6 |
| 1948 | 2025-08-17 10:12:15 | pill | 2 | 29872 | 284 | 2.796 | 10683.8 |
| 1947 | 2025-08-15 18:15:21 | pill | 2 | 29872 | 284 | 5.343 | 5590.9 |
| 1946 | 2025-08-11 20:38:12 | pill | 2 | 29872 | 284 | 2.563 | 11655.1 |
| 1945 | 2025-08-11 14:22:40 | pill | 2 | 29872 | 284 | 3.296 | 9063.1 |
| 1944 | 2025-08-09 11:48:47 | pill | 2 | 29872 | 284 | 4.313 | 6926.0 |
| 1943 | 2025-08-09 11:32:28 | pill | 1 | 13983 | 28 | 0.953 | 14672.6 |
| 1942 | 2025-08-06 13:04:44 | pill | 2 | 29872 | 284 | 1.830 | 16323.5 |
| 1941 | 2025-08-04 05:18:37 | pill | 1 | 13983 | 28 | 0.810 | 17263.0 |
| 1940 | 2025-08-04 01:28:03 | pill | 1 | 13983 | 28 | 0.250 | 55932.0 |
| 1939 | 2025-07-31 16:21:26 | pill | 1 | 13983 | 28 | 0.263 | 53167.3 |
| 1938 | 2025-07-31 13:17:01 | pill | 2 | 29872 | 284 | 4.563 | 6546.6 |