History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"host"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2113 | 2024-03-28 23:28:15 | host | 2 | 29872 | 340 | 0.890 | 33564.0 |
2112 | 2024-03-27 23:36:55 | host | 2 | 29872 | 340 | 3.423 | 8726.8 |
2111 | 2024-03-27 22:23:22 | host | 2 | 29872 | 340 | 2.860 | 10444.8 |
2110 | 2024-03-26 23:27:36 | host | 2 | 29872 | 340 | 0.936 | 31914.5 |
2109 | 2024-03-18 23:54:44 | host | 1 | 13983 | 22 | 0.686 | 20383.4 |
2108 | 2024-03-11 00:29:59 | host | 2 | 29872 | 340 | 0.856 | 34897.2 |
2107 | 2024-03-10 00:25:44 | host | 2 | 29872 | 340 | 2.263 | 13200.2 |
2106 | 2024-03-09 01:03:24 | host | 2 | 29872 | 340 | 3.236 | 9231.1 |
2105 | 2024-03-08 00:21:05 | host | 2 | 29872 | 340 | 1.030 | 29001.9 |
2104 | 2024-03-07 06:45:45 | host | 2 | 29872 | 340 | 0.876 | 34100.5 |
2103 | 2024-03-07 00:36:37 | host | 2 | 29872 | 340 | 1.076 | 27762.1 |
2102 | 2024-03-06 00:15:59 | host | 2 | 29872 | 340 | 1.080 | 27659.3 |
2101 | 2024-03-05 00:30:35 | host | 2 | 29872 | 340 | 2.080 | 14361.5 |
2100 | 2024-03-05 00:01:12 | host | 1 | 13983 | 22 | 0.266 | 52567.7 |
2099 | 2024-03-02 13:54:51 | host | 1 | 13983 | 22 | 0.533 | 26234.5 |
2098 | 2024-03-02 01:34:39 | host | 2 | 29872 | 340 | 1.686 | 17717.7 |
2097 | 2024-03-01 01:31:26 | host | 2 | 29872 | 340 | 0.923 | 32364.0 |
2096 | 2024-02-29 21:13:41 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2095 | 2024-02-25 16:54:51 | host | 1 | 13983 | 22 | 0.283 | 49409.9 |
2094 | 2024-02-24 19:04:53 | host | 2 | 29872 | 340 | 0.830 | 35990.4 |
2093 | 2024-02-23 23:40:31 | host | 2 | 29872 | 340 | 1.030 | 29001.9 |
2092 | 2024-02-22 23:38:51 | host | 2 | 29872 | 340 | 2.750 | 10862.5 |
2091 | 2024-02-21 23:37:00 | host | 2 | 29872 | 340 | 0.733 | 40753.1 |
2090 | 2024-02-20 23:34:08 | host | 2 | 29872 | 340 | 1.846 | 16182.0 |
2089 | 2024-02-19 23:33:58 | host | 2 | 29872 | 340 | 1.046 | 28558.3 |
2088 | 2024-02-18 23:34:15 | host | 2 | 29872 | 340 | 3.190 | 9364.3 |
2087 | 2024-02-17 23:51:43 | host | 2 | 29872 | 340 | 0.906 | 32971.3 |
2086 | 2024-02-16 23:51:56 | host | 2 | 29872 | 340 | 0.796 | 37527.6 |
2085 | 2024-02-15 23:31:43 | host | 2 | 29872 | 340 | 1.000 | 29872.0 |
2084 | 2024-02-13 23:37:51 | host | 2 | 29872 | 340 | 2.000 | 14936.0 |
2083 | 2024-02-13 09:52:23 | host | 2 | 29872 | 340 | 1.703 | 17540.8 |
2082 | 2024-02-13 00:25:01 | host | 2 | 29872 | 340 | 0.750 | 39829.3 |
2081 | 2024-02-12 00:50:13 | host | 2 | 29872 | 340 | 2.640 | 11315.2 |
2080 | 2024-02-10 00:27:18 | host | 2 | 29872 | 340 | 1.000 | 29872.0 |
2079 | 2024-02-09 00:04:25 | host | 2 | 29872 | 340 | 1.030 | 29001.9 |
2078 | 2024-02-01 10:38:33 | host | 1 | 13983 | 22 | 0.543 | 25751.4 |
2077 | 2024-01-30 20:16:08 | host | 2 | 29872 | 340 | 1.016 | 29401.6 |
2076 | 2024-01-29 23:10:00 | host | 2 | 29872 | 340 | 0.953 | 31345.2 |
2075 | 2024-01-28 19:02:01 | host | 2 | 29872 | 340 | 0.750 | 39829.3 |
2074 | 2024-01-27 12:14:41 | host | 2 | 29872 | 340 | 0.826 | 36164.6 |
2073 | 2024-01-26 18:57:48 | host | 2 | 29872 | 340 | 0.906 | 32971.3 |
2072 | 2024-01-26 16:12:47 | host | 2 | 29872 | 340 | 0.876 | 34100.5 |
2071 | 2024-01-25 19:03:33 | host | 1 | 13983 | 22 | 0.266 | 52567.7 |
2070 | 2024-01-24 22:44:25 | host | 2 | 29872 | 340 | 0.840 | 35561.9 |
2069 | 2024-01-22 19:29:11 | host | 2 | 29872 | 340 | 1.063 | 28101.6 |
2068 | 2024-01-07 04:02:18 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2067 | 2023-12-29 16:17:11 | host | 1 | 13983 | 22 | 0.203 | 68881.8 |
2066 | 2023-12-09 15:13:00 | host | 1 | 13983 | 22 | 0.233 | 60012.9 |
2065 | 2023-12-08 01:31:26 | host | 1 | 13983 | 22 | 0.233 | 60012.9 |
2064 | 2023-12-08 01:31:25 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2063 | 2023-12-08 01:25:34 | host | 1 | 13983 | 22 | 0.560 | 24969.6 |
2062 | 2023-12-03 15:14:50 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2061 | 2023-12-03 15:14:49 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2060 | 2023-11-21 23:48:04 | host | 2 | 29872 | 340 | 0.860 | 34734.9 |
2059 | 2023-11-19 18:16:27 | host | 2 | 29872 | 340 | 0.860 | 34734.9 |
2058 | 2023-11-18 12:35:14 | host | 2 | 29872 | 340 | 0.783 | 38150.7 |
2057 | 2023-11-15 16:06:37 | host | 1 | 13983 | 22 | 0.216 | 64736.1 |
2056 | 2023-11-15 12:24:15 | host | 1 | 13983 | 22 | 0.220 | 63559.1 |
2055 | 2023-11-12 23:32:00 | host | 2 | 29872 | 340 | 0.906 | 32971.3 |
2054 | 2023-11-09 06:37:39 | host | 1 | 13983 | 22 | 0.220 | 63559.1 |
2053 | 2023-11-08 02:26:29 | host | 1 | 13983 | 22 | 0.203 | 68881.8 |
2052 | 2023-11-07 18:54:16 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2051 | 2023-11-07 08:08:56 | host | 1 | 13983 | 22 | 0.216 | 64736.1 |
2050 | 2023-11-02 07:39:05 | host | 2 | 29872 | 340 | 0.906 | 32971.3 |
2049 | 2023-10-27 00:35:56 | host | 1 | 13983 | 22 | 0.216 | 64736.1 |
2048 | 2023-10-23 16:24:44 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2047 | 2023-10-22 17:19:54 | host | 2 | 29872 | 340 | 0.766 | 38997.4 |
2046 | 2023-10-19 16:50:33 | host | 1 | 13983 | 22 | 0.233 | 60012.9 |
2045 | 2023-10-16 20:56:18 | host | 2 | 29872 | 340 | 0.970 | 30795.9 |
2044 | 2023-10-16 19:25:14 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2043 | 2023-10-15 15:07:32 | host | 2 | 29872 | 340 | 0.830 | 35990.4 |
2042 | 2023-10-10 22:40:14 | host | 1 | 13983 | 22 | 0.250 | 55932.0 |
2041 | 2023-10-06 01:09:59 | host | 2 | 29872 | 340 | 0.843 | 35435.3 |
2040 | 2023-10-03 10:38:23 | host | 1 | 13983 | 22 | 0.220 | 63559.1 |
2039 | 2023-09-23 22:51:12 | host | 2 | 29872 | 340 | 1.500 | 19914.7 |
2038 | 2023-09-23 16:13:59 | host | 1 | 13983 | 22 | 0.360 | 38841.7 |
2037 | 2023-09-21 09:14:45 | host | 1 | 13983 | 22 | 0.233 | 60012.9 |
2036 | 2023-09-19 00:00:18 | host | 1 | 13983 | 22 | 0.233 | 60012.9 |
2035 | 2023-09-14 13:21:16 | host | 2 | 29872 | 340 | 0.750 | 39829.3 |
2034 | 2023-09-10 14:25:38 | host | 1 | 13983 | 22 | 0.216 | 64736.1 |
2033 | 2023-09-05 08:18:06 | host | 2 | 29872 | 340 | 0.780 | 38297.4 |
2032 | 2023-09-03 10:59:42 | host | 2 | 29872 | 340 | 0.733 | 40753.1 |
2031 | 2023-09-02 08:30:12 | host | 2 | 29872 | 340 | 0.873 | 34217.6 |
2030 | 2023-09-01 23:00:41 | host | 2 | 29872 | 340 | 0.766 | 38997.4 |
2029 | 2023-08-26 22:48:39 | host | 2 | 29872 | 340 | 0.983 | 30388.6 |
2028 | 2023-08-20 00:53:13 | host | 2 | 29872 | 340 | 0.750 | 39829.3 |
2027 | 2023-08-14 01:54:08 | host | 2 | 29872 | 340 | 0.750 | 39829.3 |
2026 | 2023-08-06 20:53:34 | host | 2 | 29872 | 340 | 0.873 | 34217.6 |
2025 | 2023-08-02 23:31:17 | host | 2 | 29872 | 340 | 0.876 | 34100.5 |
2024 | 2023-07-16 00:08:02 | host | 1 | 13983 | 22 | 0.563 | 24836.6 |
2023 | 2023-06-19 00:06:35 | host | 2 | 29872 | 340 | 0.763 | 39150.7 |
2022 | 2023-06-18 00:06:59 | host | 2 | 29872 | 340 | 0.890 | 33564.0 |
2021 | 2023-06-14 03:03:29 | host | 1 | 13983 | 22 | 0.233 | 60012.9 |
2020 | 2023-06-05 16:56:15 | host | 2 | 29872 | 340 | 0.936 | 31914.5 |
2019 | 2023-06-01 16:52:36 | host | 2 | 29872 | 340 | 0.860 | 34734.9 |
2018 | 2023-05-05 09:51:51 | host | 2 | 29872 | 340 | 0.750 | 39829.3 |
2017 | 2023-04-24 04:56:22 | host | 2 | 29872 | 340 | 0.843 | 35435.3 |
2016 | 2023-04-23 19:30:15 | host | 2 | 29872 | 340 | 0.733 | 40753.1 |
2015 | 2023-04-22 04:54:18 | host | 2 | 29872 | 340 | 0.780 | 38297.4 |
2014 | 2023-04-21 15:05:18 | host | 2 | 29872 | 340 | 0.893 | 33451.3 |