History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pats"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2034 | 2025-12-14 07:00:39 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 2033 | 2025-12-11 13:08:09 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 2032 | 2025-12-07 19:54:37 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2031 | 2025-11-29 17:46:36 | pats | 1 | 13983 | 47 | 0.670 | 20870.1 |
| 2030 | 2025-11-24 15:45:23 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2029 | 2025-11-24 02:25:04 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2028 | 2025-11-23 00:34:01 | pats | 2 | 29872 | 654 | 0.936 | 31914.5 |
| 2027 | 2025-11-21 21:04:04 | pats | 2 | 29872 | 654 | 1.373 | 21756.7 |
| 2026 | 2025-11-18 06:27:57 | pats | 1 | 13983 | 47 | 0.296 | 47239.9 |
| 2025 | 2025-11-16 00:29:45 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2024 | 2025-11-14 23:58:55 | pats | 1 | 13983 | 47 | 0.296 | 47239.9 |
| 2023 | 2025-11-14 09:19:02 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2022 | 2025-11-14 00:54:49 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2021 | 2025-11-13 16:23:03 | pats | 1 | 13983 | 47 | 0.236 | 59250.0 |
| 2020 | 2025-11-10 20:13:51 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2019 | 2025-11-04 00:26:23 | pats | 1 | 13983 | 47 | 0.220 | 63559.1 |
| 2018 | 2025-10-30 20:29:55 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2017 | 2025-10-25 02:40:04 | pats | 1 | 13983 | 47 | 0.236 | 59250.0 |
| 2016 | 2025-10-24 01:31:14 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 2015 | 2025-10-12 04:06:34 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2014 | 2025-10-10 15:06:53 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2013 | 2025-10-06 18:20:04 | pats | 1 | 13983 | 47 | 0.220 | 63559.1 |
| 2012 | 2025-10-06 15:54:06 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2011 | 2025-10-05 19:33:12 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2010 | 2025-10-02 20:12:51 | pats | 1 | 13983 | 47 | 0.236 | 59250.0 |
| 2009 | 2025-10-01 19:36:09 | pats | 2 | 29872 | 654 | 0.936 | 31914.5 |
| 2008 | 2025-09-26 03:24:04 | pats | 1 | 13983 | 47 | 0.220 | 63559.1 |
| 2007 | 2025-09-24 23:49:33 | pats | 1 | 13983 | 47 | 0.876 | 15962.3 |
| 2006 | 2025-09-24 23:49:29 | pats | 1 | 13983 | 47 | 0.500 | 27966.0 |
| 2005 | 2025-09-24 23:49:27 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 2004 | 2025-09-24 23:49:22 | pats | 1 | 13983 | 47 | 1.656 | 8443.8 |
| 2003 | 2025-09-19 06:57:47 | pats | 1 | 13983 | 47 | 0.300 | 46610.0 |
| 2002 | 2025-09-10 14:47:44 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 2001 | 2025-09-08 01:52:57 | pats | 2 | 29872 | 654 | 0.763 | 39150.7 |
| 2000 | 2025-09-06 15:58:45 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 1999 | 2025-09-01 05:33:54 | pats | 1 | 13983 | 47 | 0.263 | 53167.3 |
| 1998 | 2025-08-31 14:33:45 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 1997 | 2025-08-30 08:09:59 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 1996 | 2025-08-27 16:33:22 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 1995 | 2025-08-25 09:13:37 | pats | 1 | 13983 | 47 | 0.703 | 19890.5 |
| 1994 | 2025-08-24 03:52:51 | pats | 1 | 13983 | 47 | 0.546 | 25609.9 |
| 1993 | 2025-08-19 13:13:54 | pats | 1 | 13983 | 47 | 0.690 | 20265.2 |
| 1992 | 2025-08-17 23:16:56 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 1991 | 2025-08-07 09:20:39 | pats | 1 | 13983 | 47 | 0.733 | 19076.4 |
| 1990 | 2025-07-27 18:17:04 | pats | 1 | 13983 | 47 | 0.953 | 14672.6 |
| 1989 | 2025-07-27 09:18:21 | pats | 1 | 13983 | 47 | 0.673 | 20777.1 |
| 1988 | 2025-07-25 06:23:44 | pats | 1 | 13983 | 47 | 0.780 | 17926.9 |
| 1987 | 2025-07-24 10:53:29 | pats | 1 | 13983 | 47 | 1.373 | 10184.3 |
| 1986 | 2025-07-23 21:40:15 | pats | 1 | 13983 | 47 | 1.343 | 10411.8 |
| 1985 | 2025-07-23 00:59:37 | pats | 1 | 13983 | 47 | 0.673 | 20777.1 |
| 1984 | 2025-07-22 10:23:02 | pats | 1 | 13983 | 47 | 1.123 | 12451.5 |
| 1983 | 2025-07-19 06:24:36 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 1982 | 2025-07-16 12:39:02 | pats | 1 | 13983 | 47 | 0.690 | 20265.2 |
| 1981 | 2025-07-12 15:51:03 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 1980 | 2025-07-11 00:39:25 | pats | 2 | 29872 | 654 | 5.140 | 5811.7 |
| 1979 | 2025-07-07 09:31:43 | pats | 2 | 29872 | 654 | 4.673 | 6392.5 |
| 1978 | 2025-07-06 08:40:49 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 1977 | 2025-06-30 09:02:55 | pats | 1 | 13983 | 47 | 1.016 | 13762.8 |
| 1976 | 2025-06-26 17:09:40 | pats | 1 | 13983 | 47 | 1.673 | 8358.0 |
| 1975 | 2025-06-24 07:19:33 | pats | 1 | 13983 | 47 | 2.063 | 6778.0 |
| 1974 | 2025-06-23 15:46:43 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 1973 | 2025-06-11 23:28:16 | pats | 1 | 13983 | 47 | 1.736 | 8054.7 |
| 1972 | 2025-06-11 02:58:27 | pats | 2 | 29872 | 654 | 0.890 | 33564.0 |
| 1971 | 2025-06-08 08:35:40 | pats | 2 | 29872 | 654 | 4.356 | 6857.7 |
| 1970 | 2025-06-07 08:28:27 | pats | 2 | 29872 | 654 | 0.860 | 34734.9 |
| 1969 | 2025-06-07 04:04:15 | pats | 2 | 29872 | 654 | 1.716 | 17407.9 |
| 1968 | 2025-06-06 22:08:31 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 1967 | 2025-06-06 07:33:36 | pats | 1 | 13983 | 47 | 2.423 | 5770.9 |
| 1966 | 2025-06-05 16:21:36 | pats | 2 | 29872 | 654 | 4.376 | 6826.3 |
| 1965 | 2025-05-30 22:42:44 | pats | 1 | 13983 | 47 | 1.140 | 12265.8 |
| 1964 | 2025-05-29 15:29:46 | pats | 1 | 13983 | 47 | 1.076 | 12995.4 |
| 1963 | 2025-05-29 13:38:44 | pats | 1 | 13983 | 47 | 0.283 | 49409.9 |
| 1962 | 2025-05-29 04:21:40 | pats | 1 | 13983 | 47 | 2.046 | 6834.3 |
| 1961 | 2025-05-26 23:01:52 | pats | 1 | 13983 | 47 | 0.500 | 27966.0 |
| 1960 | 2025-05-26 21:39:01 | pats | 1 | 13983 | 47 | 1.280 | 10924.2 |
| 1959 | 2025-05-26 18:29:24 | pats | 1 | 13983 | 47 | 1.516 | 9223.6 |
| 1958 | 2025-05-21 12:11:26 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 1957 | 2025-05-17 23:44:10 | pats | 1 | 13983 | 47 | 0.846 | 16528.4 |
| 1956 | 2025-05-17 02:34:01 | pats | 2 | 29872 | 654 | 1.360 | 21964.7 |
| 1955 | 2025-05-15 11:14:43 | pats | 1 | 13983 | 47 | 0.530 | 26383.0 |
| 1954 | 2025-05-15 04:39:04 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 1953 | 2025-05-14 20:03:23 | pats | 2 | 29872 | 654 | 0.936 | 31914.5 |
| 1952 | 2025-05-09 04:17:59 | pats | 1 | 13983 | 47 | 0.263 | 53167.3 |
| 1951 | 2025-05-05 13:23:34 | pats | 2 | 29872 | 654 | 0.826 | 36164.6 |
| 1950 | 2025-05-04 21:15:52 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 1949 | 2025-05-04 12:55:41 | pats | 1 | 13983 | 47 | 0.983 | 14224.8 |
| 1948 | 2025-05-02 17:31:35 | pats | 2 | 29872 | 654 | 4.546 | 6571.1 |
| 1947 | 2025-05-02 12:45:16 | pats | 1 | 13983 | 47 | 0.660 | 21186.4 |
| 1946 | 2025-05-02 07:44:08 | pats | 2 | 29872 | 654 | 2.050 | 14571.7 |
| 1945 | 2025-05-01 04:13:09 | pats | 2 | 29872 | 654 | 4.906 | 6088.9 |
| 1944 | 2025-05-01 02:28:12 | pats | 2 | 29872 | 654 | 4.266 | 7002.3 |
| 1943 | 2025-04-30 09:36:46 | pats | 2 | 29872 | 654 | 4.486 | 6658.9 |
| 1942 | 2025-04-29 17:01:16 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 1941 | 2025-04-29 12:23:42 | pats | 2 | 29872 | 654 | 0.843 | 35435.3 |
| 1940 | 2025-04-27 15:29:15 | pats | 1 | 13983 | 47 | 0.796 | 17566.6 |
| 1939 | 2025-04-26 16:29:29 | pats | 1 | 13983 | 47 | 0.950 | 14718.9 |
| 1938 | 2025-04-24 22:26:36 | pats | 2 | 29872 | 654 | 3.610 | 8274.8 |
| 1937 | 2025-04-24 02:45:23 | pats | 2 | 29872 | 654 | 2.030 | 14715.3 |
| 1936 | 2025-04-23 06:55:45 | pats | 1 | 13983 | 47 | 0.670 | 20870.1 |
| 1935 | 2025-04-16 01:25:00 | pats | 2 | 29872 | 654 | 3.440 | 8683.7 |