History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"joes"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2078 | 2025-10-31 22:42:13 | joes | 2 | 29872 | 479 | 0.843 | 35435.3 |
| 2077 | 2025-10-28 03:44:35 | joes | 2 | 29872 | 479 | 2.140 | 13958.9 |
| 2076 | 2025-10-27 13:49:48 | joes | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 2075 | 2025-10-25 12:33:22 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2074 | 2025-10-25 09:58:17 | joes | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 2073 | 2025-10-19 13:18:31 | joes | 1 | 13983 | 24 | 1.216 | 11499.2 |
| 2072 | 2025-10-19 13:18:24 | joes | 1 | 13983 | 24 | 1.530 | 9139.2 |
| 2071 | 2025-10-19 13:18:15 | joes | 1 | 13983 | 24 | 1.203 | 11623.4 |
| 2070 | 2025-10-19 13:18:08 | joes | 1 | 13983 | 24 | 0.796 | 17566.6 |
| 2069 | 2025-10-19 11:13:03 | joes | 2 | 29872 | 479 | 2.173 | 13746.9 |
| 2068 | 2025-10-19 11:12:44 | joes | 2 | 29872 | 479 | 2.376 | 12572.4 |
| 2067 | 2025-10-19 11:12:16 | joes | 2 | 29872 | 479 | 6.406 | 4663.1 |
| 2066 | 2025-10-19 11:11:53 | joes | 2 | 29872 | 479 | 4.216 | 7085.4 |
| 2065 | 2025-10-19 08:31:49 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2064 | 2025-10-18 23:51:09 | joes | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 2063 | 2025-10-18 13:41:41 | joes | 2 | 29872 | 479 | 1.173 | 25466.3 |
| 2062 | 2025-10-04 00:49:23 | joes | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 2061 | 2025-09-29 18:40:19 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2060 | 2025-09-29 05:04:49 | joes | 1 | 13983 | 24 | 0.546 | 25609.9 |
| 2059 | 2025-09-28 18:32:01 | joes | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 2058 | 2025-09-28 00:00:25 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2057 | 2025-09-27 12:57:55 | joes | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 2056 | 2025-09-26 14:21:36 | joes | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 2055 | 2025-09-26 12:13:43 | joes | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 2054 | 2025-09-25 16:12:00 | joes | 1 | 13983 | 24 | 0.263 | 53167.3 |
| 2053 | 2025-09-25 09:50:28 | joes | 1 | 13983 | 24 | 0.356 | 39278.1 |
| 2052 | 2025-09-20 12:10:57 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2051 | 2025-09-19 21:52:53 | joes | 2 | 29872 | 479 | 1.780 | 16782.0 |
| 2050 | 2025-09-19 09:32:32 | joes | 1 | 13983 | 24 | 0.220 | 63559.1 |
| 2049 | 2025-09-16 16:58:02 | joes | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 2048 | 2025-09-11 21:56:04 | joes | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 2047 | 2025-09-09 00:30:11 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2046 | 2025-09-01 04:21:45 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2045 | 2025-08-31 20:05:10 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2044 | 2025-08-27 12:53:20 | joes | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 2043 | 2025-08-27 00:26:09 | joes | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 2042 | 2025-08-25 00:02:52 | joes | 1 | 13983 | 24 | 0.593 | 23580.1 |
| 2041 | 2025-08-19 10:36:42 | joes | 1 | 13983 | 24 | 0.890 | 15711.2 |
| 2040 | 2025-08-14 16:07:13 | joes | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 2039 | 2025-08-09 03:54:46 | joes | 1 | 13983 | 24 | 0.860 | 16259.3 |
| 2038 | 2025-07-31 12:08:04 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2037 | 2025-07-31 07:48:15 | joes | 1 | 13983 | 24 | 1.330 | 10513.5 |
| 2036 | 2025-07-27 21:23:21 | joes | 2 | 29872 | 479 | 2.013 | 14839.5 |
| 2035 | 2025-07-27 14:39:09 | joes | 1 | 13983 | 24 | 0.970 | 14415.5 |
| 2034 | 2025-07-27 06:36:41 | joes | 2 | 29872 | 479 | 2.000 | 14936.0 |
| 2033 | 2025-07-25 04:01:54 | joes | 2 | 29872 | 479 | 1.970 | 15163.5 |
| 2032 | 2025-07-25 01:01:51 | joes | 1 | 13983 | 24 | 0.266 | 52567.7 |
| 2031 | 2025-07-22 08:46:26 | joes | 1 | 13983 | 24 | 1.373 | 10184.3 |
| 2030 | 2025-07-20 03:52:56 | joes | 2 | 29872 | 479 | 1.983 | 15064.0 |
| 2029 | 2025-07-17 13:18:51 | joes | 1 | 13983 | 24 | 0.656 | 21315.5 |
| 2028 | 2025-07-17 10:45:58 | joes | 1 | 13983 | 24 | 1.140 | 12265.8 |
| 2027 | 2025-07-09 22:49:31 | joes | 2 | 29872 | 479 | 6.360 | 4696.9 |
| 2026 | 2025-07-09 03:20:01 | joes | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 2025 | 2025-07-06 02:36:16 | joes | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 2024 | 2025-07-02 13:26:04 | joes | 2 | 29872 | 479 | 2.080 | 14361.5 |
| 2023 | 2025-06-30 12:43:37 | joes | 1 | 13983 | 24 | 1.640 | 8526.2 |
| 2022 | 2025-06-30 11:14:20 | joes | 2 | 29872 | 479 | 5.733 | 5210.5 |
| 2021 | 2025-06-30 02:39:30 | joes | 1 | 13983 | 24 | 0.656 | 21315.5 |
| 2020 | 2025-06-29 07:46:07 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2019 | 2025-06-29 01:18:06 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 2018 | 2025-06-25 08:29:15 | joes | 1 | 13983 | 24 | 0.203 | 68881.8 |
| 2017 | 2025-06-25 03:44:27 | joes | 2 | 29872 | 479 | 2.736 | 10918.1 |
| 2016 | 2025-06-23 03:24:54 | joes | 2 | 29872 | 479 | 0.733 | 40753.1 |
| 2015 | 2025-06-21 22:58:03 | joes | 2 | 29872 | 479 | 2.030 | 14715.3 |
| 2014 | 2025-06-21 06:18:32 | joes | 2 | 29872 | 479 | 4.186 | 7136.2 |
| 2013 | 2025-06-20 12:28:39 | joes | 2 | 29872 | 479 | 2.453 | 12177.7 |
| 2012 | 2025-06-18 00:22:32 | joes | 2 | 29872 | 479 | 5.346 | 5587.7 |
| 2011 | 2025-06-13 11:19:26 | joes | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 2010 | 2025-06-08 03:49:56 | joes | 1 | 13983 | 24 | 1.860 | 7517.7 |
| 2009 | 2025-06-06 12:35:25 | joes | 1 | 13983 | 24 | 0.486 | 28771.6 |
| 2008 | 2025-05-31 01:18:25 | joes | 1 | 13983 | 24 | 1.390 | 10059.7 |
| 2007 | 2025-05-30 02:57:18 | joes | 1 | 13983 | 24 | 0.686 | 20383.4 |
| 2006 | 2025-05-29 11:57:08 | joes | 1 | 13983 | 24 | 1.533 | 9121.3 |
| 2005 | 2025-05-24 10:02:53 | joes | 2 | 29872 | 479 | 4.203 | 7107.3 |
| 2004 | 2025-05-16 00:48:56 | joes | 1 | 13983 | 24 | 1.153 | 12127.5 |
| 2003 | 2025-05-13 18:15:09 | joes | 2 | 29872 | 479 | 0.906 | 32971.3 |
| 2002 | 2025-05-13 15:13:05 | joes | 2 | 29872 | 479 | 1.356 | 22029.5 |
| 2001 | 2025-05-10 21:37:43 | joes | 2 | 29872 | 479 | 2.326 | 12842.6 |
| 2000 | 2025-05-10 08:42:42 | joes | 2 | 29872 | 479 | 6.593 | 4530.9 |
| 1999 | 2025-05-09 11:32:10 | joes | 1 | 13983 | 24 | 0.233 | 60012.9 |
| 1998 | 2025-05-08 22:17:42 | joes | 1 | 13983 | 24 | 0.280 | 49939.3 |
| 1997 | 2025-05-08 03:42:38 | joes | 1 | 13983 | 24 | 2.030 | 6888.2 |
| 1996 | 2025-05-06 18:20:30 | joes | 1 | 13983 | 24 | 1.250 | 11186.4 |
| 1995 | 2025-05-06 12:56:21 | joes | 1 | 13983 | 24 | 0.763 | 18326.3 |
| 1994 | 2025-05-04 11:55:48 | joes | 2 | 29872 | 479 | 4.206 | 7102.2 |
| 1993 | 2025-05-03 09:17:29 | joes | 1 | 13983 | 24 | 0.623 | 22444.6 |
| 1992 | 2025-04-30 01:58:16 | joes | 1 | 13983 | 24 | 0.640 | 21848.4 |
| 1991 | 2025-04-29 21:54:17 | joes | 2 | 29872 | 479 | 4.013 | 7443.8 |
| 1990 | 2025-04-29 13:06:59 | joes | 2 | 29872 | 479 | 4.346 | 6873.4 |
| 1989 | 2025-04-28 11:59:07 | joes | 1 | 13983 | 24 | 1.953 | 7159.8 |
| 1988 | 2025-04-28 08:07:00 | joes | 1 | 13983 | 24 | 1.123 | 12451.5 |
| 1987 | 2025-04-27 17:24:08 | joes | 2 | 29872 | 479 | 0.826 | 36164.6 |
| 1986 | 2025-04-27 17:17:09 | joes | 2 | 29872 | 479 | 0.876 | 34100.5 |
| 1985 | 2025-04-27 02:52:26 | joes | 1 | 13983 | 24 | 0.250 | 55932.0 |
| 1984 | 2025-04-27 02:30:38 | joes | 1 | 13983 | 24 | 0.216 | 64736.1 |
| 1983 | 2025-04-24 15:47:41 | joes | 1 | 13983 | 24 | 0.236 | 59250.0 |
| 1982 | 2025-04-22 22:15:12 | joes | 1 | 13983 | 24 | 1.393 | 10038.0 |
| 1981 | 2025-04-15 10:43:26 | joes | 2 | 29872 | 479 | 0.766 | 38997.4 |
| 1980 | 2025-04-14 10:06:57 | joes | 1 | 13983 | 24 | 0.953 | 14672.6 |
| 1979 | 2025-04-14 06:22:38 | joes | 2 | 29872 | 479 | 5.203 | 5741.3 |