History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"list"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2242 | 2024-04-30 21:35:45 | list | 2 | 29872 | 314 | 1.033 | 28917.7 |
2241 | 2024-04-29 21:44:26 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2240 | 2024-04-29 17:08:38 | list | 2 | 29872 | 314 | 0.906 | 32971.3 |
2239 | 2024-04-29 03:31:58 | list | 1 | 13983 | 21 | 0.970 | 14415.5 |
2238 | 2024-04-29 01:16:35 | list | 2 | 29872 | 314 | 0.923 | 32364.0 |
2237 | 2024-04-28 02:59:26 | list | 2 | 29872 | 314 | 2.420 | 12343.8 |
2236 | 2024-04-25 10:54:50 | list | 2 | 29872 | 314 | 2.950 | 10126.1 |
2235 | 2024-04-25 01:26:08 | list | 2 | 29872 | 314 | 4.533 | 6589.9 |
2234 | 2024-04-24 22:58:01 | list | 1 | 13983 | 21 | 0.563 | 24836.6 |
2233 | 2024-04-24 16:28:16 | list | 1 | 13983 | 21 | 0.390 | 35853.8 |
2232 | 2024-04-23 21:53:39 | list | 2 | 29872 | 314 | 2.046 | 14600.2 |
2231 | 2024-04-23 07:42:56 | list | 1 | 13983 | 21 | 0.483 | 28950.3 |
2230 | 2024-04-22 23:47:24 | list | 2 | 29872 | 314 | 0.856 | 34897.2 |
2229 | 2024-04-21 09:31:06 | list | 1 | 13983 | 21 | 1.123 | 12451.5 |
2228 | 2024-04-21 07:17:39 | list | 1 | 13983 | 21 | 0.513 | 27257.3 |
2227 | 2024-04-21 00:24:45 | list | 2 | 29872 | 314 | 3.440 | 8683.7 |
2226 | 2024-04-17 09:02:24 | list | 1 | 13983 | 21 | 0.216 | 64736.1 |
2225 | 2024-04-16 03:54:59 | list | 2 | 29872 | 314 | 1.033 | 28917.7 |
2224 | 2024-04-13 14:25:13 | list | 1 | 13983 | 21 | 0.263 | 53167.3 |
2223 | 2024-04-11 06:10:34 | list | 1 | 13983 | 21 | 0.233 | 60012.9 |
2222 | 2024-04-06 20:35:46 | list | 1 | 13983 | 21 | 0.390 | 35853.8 |
2221 | 2024-04-03 01:40:04 | list | 2 | 29872 | 314 | 3.170 | 9423.3 |
2220 | 2024-04-03 01:30:57 | list | 1 | 13983 | 21 | 0.280 | 49939.3 |
2219 | 2024-04-01 17:12:40 | list | 2 | 29872 | 314 | 1.060 | 28181.1 |
2218 | 2024-04-01 16:41:54 | list | 1 | 13983 | 21 | 0.830 | 16847.0 |
2217 | 2024-03-30 21:36:48 | list | 2 | 29872 | 314 | 1.563 | 19112.0 |
2216 | 2024-03-30 21:14:43 | list | 1 | 13983 | 21 | 0.813 | 17199.3 |
2215 | 2024-03-29 21:52:43 | list | 1 | 13983 | 21 | 0.296 | 47239.9 |
2214 | 2024-03-28 06:21:38 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2213 | 2024-03-17 20:53:37 | list | 1 | 13983 | 21 | 0.576 | 24276.0 |
2212 | 2024-03-05 09:19:17 | list | 1 | 13983 | 21 | 0.296 | 47239.9 |
2211 | 2024-03-03 19:54:22 | list | 1 | 13983 | 21 | 0.483 | 28950.3 |
2210 | 2024-03-02 14:36:44 | list | 2 | 29872 | 314 | 1.640 | 18214.6 |
2209 | 2024-03-02 13:40:58 | list | 1 | 13983 | 21 | 0.263 | 53167.3 |
2208 | 2024-02-29 19:56:40 | list | 1 | 13983 | 21 | 0.483 | 28950.3 |
2207 | 2024-02-25 16:24:44 | list | 1 | 13983 | 21 | 0.236 | 59250.0 |
2206 | 2024-02-25 15:56:24 | list | 1 | 13983 | 21 | 0.216 | 64736.1 |
2205 | 2024-02-19 05:36:38 | list | 1 | 13983 | 21 | 0.263 | 53167.3 |
2204 | 2024-02-17 21:00:16 | list | 2 | 29872 | 314 | 0.766 | 38997.4 |
2203 | 2024-02-02 17:26:47 | list | 1 | 13983 | 21 | 0.236 | 59250.0 |
2202 | 2024-01-28 16:34:31 | list | 1 | 13983 | 21 | 0.233 | 60012.9 |
2201 | 2024-01-26 13:33:33 | list | 1 | 13983 | 21 | 0.263 | 53167.3 |
2200 | 2024-01-24 00:29:49 | list | 1 | 13983 | 21 | 0.220 | 63559.1 |
2199 | 2024-01-13 04:23:06 | list | 2 | 29872 | 314 | 0.810 | 36879.0 |
2198 | 2024-01-11 18:30:53 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2197 | 2024-01-07 17:50:11 | list | 1 | 13983 | 21 | 0.233 | 60012.9 |
2196 | 2023-12-31 19:17:53 | list | 2 | 29872 | 314 | 0.766 | 38997.4 |
2195 | 2023-12-29 04:43:05 | list | 1 | 13983 | 21 | 0.236 | 59250.0 |
2194 | 2023-12-15 10:08:15 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2193 | 2023-12-02 17:03:28 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2192 | 2023-11-28 10:24:25 | list | 1 | 13983 | 21 | 0.200 | 69915.0 |
2191 | 2023-11-22 18:39:21 | list | 2 | 29872 | 314 | 0.986 | 30296.1 |
2190 | 2023-11-16 23:58:29 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2189 | 2023-11-12 17:26:12 | list | 2 | 29872 | 314 | 0.736 | 40587.0 |
2188 | 2023-11-09 20:52:19 | list | 2 | 29872 | 314 | 0.873 | 34217.6 |
2187 | 2023-11-08 12:03:42 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2186 | 2023-11-08 06:10:22 | list | 1 | 13983 | 21 | 0.220 | 63559.1 |
2185 | 2023-11-08 02:25:39 | list | 1 | 13983 | 21 | 0.216 | 64736.1 |
2184 | 2023-11-07 08:31:31 | list | 1 | 13983 | 21 | 0.220 | 63559.1 |
2183 | 2023-11-06 15:46:12 | list | 1 | 13983 | 21 | 0.220 | 63559.1 |
2182 | 2023-11-06 11:51:08 | list | 1 | 13983 | 21 | 0.516 | 27098.8 |
2181 | 2023-11-05 17:59:25 | list | 1 | 13983 | 21 | 0.203 | 68881.8 |
2180 | 2023-10-28 07:49:07 | list | 1 | 13983 | 21 | 0.220 | 63559.1 |
2179 | 2023-10-26 06:20:59 | list | 2 | 29872 | 314 | 0.856 | 34897.2 |
2178 | 2023-10-25 19:35:53 | list | 1 | 13983 | 21 | 0.266 | 52567.7 |
2177 | 2023-10-25 18:25:16 | list | 2 | 29872 | 314 | 0.843 | 35435.3 |
2176 | 2023-10-25 00:52:30 | list | 1 | 13983 | 21 | 0.216 | 64736.1 |
2175 | 2023-10-23 12:19:03 | list | 1 | 13983 | 21 | 0.203 | 68881.8 |
2174 | 2023-10-20 12:17:32 | list | 2 | 29872 | 314 | 0.750 | 39829.3 |
2173 | 2023-10-19 14:46:22 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2172 | 2023-10-17 05:02:04 | list | 2 | 29872 | 314 | 0.923 | 32364.0 |
2171 | 2023-10-16 18:26:03 | list | 1 | 13983 | 21 | 0.236 | 59250.0 |
2170 | 2023-10-12 04:03:07 | list | 2 | 29872 | 314 | 0.906 | 32971.3 |
2169 | 2023-10-10 16:59:04 | list | 2 | 29872 | 314 | 0.826 | 36164.6 |
2168 | 2023-10-10 01:30:45 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2167 | 2023-10-07 07:56:23 | list | 2 | 29872 | 314 | 0.750 | 39829.3 |
2166 | 2023-10-03 22:17:13 | list | 2 | 29872 | 314 | 0.860 | 34734.9 |
2165 | 2023-10-03 08:32:00 | list | 1 | 13983 | 21 | 0.216 | 64736.1 |
2164 | 2023-09-25 10:51:48 | list | 1 | 13983 | 21 | 0.233 | 60012.9 |
2163 | 2023-09-22 20:37:42 | list | 2 | 29872 | 314 | 0.750 | 39829.3 |
2162 | 2023-09-18 21:47:48 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2161 | 2023-09-15 19:04:41 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2160 | 2023-09-11 02:18:24 | list | 2 | 29872 | 314 | 0.750 | 39829.3 |
2159 | 2023-09-10 11:36:00 | list | 1 | 13983 | 21 | 0.203 | 68881.8 |
2158 | 2023-08-28 04:33:31 | list | 1 | 13983 | 21 | 0.220 | 63559.1 |
2157 | 2023-08-10 22:52:55 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2156 | 2023-07-26 20:51:05 | list | 1 | 13983 | 21 | 0.236 | 59250.0 |
2155 | 2023-07-26 10:42:15 | list | 1 | 13983 | 21 | 0.233 | 60012.9 |
2154 | 2023-07-23 16:09:25 | list | 1 | 13983 | 21 | 0.203 | 68881.8 |
2153 | 2023-07-23 09:41:34 | list | 1 | 13983 | 21 | 0.220 | 63559.1 |
2152 | 2023-07-21 05:07:11 | list | 2 | 29872 | 314 | 0.763 | 39150.7 |
2151 | 2023-07-19 16:36:16 | list | 1 | 13983 | 21 | 0.203 | 68881.8 |
2150 | 2023-07-17 17:55:58 | list | 2 | 29872 | 314 | 0.873 | 34217.6 |
2149 | 2023-07-16 19:21:55 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2148 | 2023-07-16 18:31:37 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2147 | 2023-07-11 08:39:47 | list | 2 | 29872 | 314 | 0.810 | 36879.0 |
2146 | 2023-06-19 02:51:08 | list | 1 | 13983 | 21 | 0.250 | 55932.0 |
2145 | 2023-06-10 12:18:30 | list | 1 | 13983 | 21 | 0.216 | 64736.1 |
2144 | 2023-05-30 21:15:14 | list | 1 | 13983 | 21 | 0.233 | 60012.9 |
2143 | 2023-05-27 15:25:40 | list | 2 | 29872 | 314 | 0.860 | 34734.9 |