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 |
| 2065 | 2026-02-08 14:06:25 | pats | 1 | 13983 | 47 | 2.060 | 6787.9 |
| 2064 | 2026-02-07 07:39:20 | pats | 2 | 29872 | 654 | 1.080 | 27659.3 |
| 2063 | 2026-02-07 01:11:34 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 2062 | 2026-02-03 06:50:19 | pats | 2 | 29872 | 654 | 0.796 | 37527.6 |
| 2061 | 2026-01-29 10:43:10 | pats | 2 | 29872 | 654 | 1.076 | 27762.1 |
| 2060 | 2026-01-26 21:52:06 | pats | 1 | 13983 | 47 | 0.453 | 30867.5 |
| 2059 | 2026-01-26 18:19:18 | pats | 1 | 13983 | 47 | 0.283 | 49409.9 |
| 2058 | 2026-01-26 00:32:57 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2057 | 2026-01-23 05:32:10 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2056 | 2026-01-21 08:04:29 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2055 | 2026-01-19 08:46:21 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2054 | 2026-01-18 14:03:48 | pats | 1 | 13983 | 47 | 0.296 | 47239.9 |
| 2053 | 2026-01-10 07:59:58 | pats | 1 | 13983 | 47 | 0.263 | 53167.3 |
| 2052 | 2026-01-07 22:18:45 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 2051 | 2026-01-07 22:09:48 | pats | 1 | 13983 | 47 | 0.796 | 17566.6 |
| 2050 | 2026-01-07 10:25:13 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 2049 | 2026-01-07 10:24:22 | pats | 1 | 13983 | 47 | 0.250 | 55932.0 |
| 2048 | 2026-01-06 18:26:20 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 2047 | 2026-01-06 07:35:18 | pats | 1 | 13983 | 47 | 0.266 | 52567.7 |
| 2046 | 2026-01-06 03:00:40 | pats | 1 | 13983 | 47 | 0.296 | 47239.9 |
| 2045 | 2025-12-29 11:35:49 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2044 | 2025-12-28 22:20:37 | pats | 1 | 13983 | 47 | 0.516 | 27098.8 |
| 2043 | 2025-12-28 13:02:02 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2042 | 2025-12-26 01:27:00 | pats | 1 | 13983 | 47 | 0.546 | 25609.9 |
| 2041 | 2025-12-25 13:11:26 | pats | 2 | 29872 | 654 | 0.983 | 30388.6 |
| 2040 | 2025-12-25 06:50:31 | pats | 2 | 29872 | 654 | 0.953 | 31345.2 |
| 2039 | 2025-12-23 23:31:55 | pats | 2 | 29872 | 654 | 0.860 | 34734.9 |
| 2038 | 2025-12-17 12:34:49 | pats | 1 | 13983 | 47 | 0.233 | 60012.9 |
| 2037 | 2025-12-17 11:20:32 | pats | 1 | 13983 | 47 | 0.263 | 53167.3 |
| 2036 | 2025-12-17 11:20:00 | pats | 1 | 13983 | 47 | 0.280 | 49939.3 |
| 2035 | 2025-12-15 21:51:24 | pats | 1 | 13983 | 47 | 0.563 | 24836.6 |
| 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 |