History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"red"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2333 | 2024-05-03 20:31:03 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2332 | 2024-04-29 02:01:34 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2331 | 2024-04-28 13:36:34 | red | 1 | 5146 | 38 | 0.453 | 11359.8 |
2330 | 2024-04-21 04:57:44 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2329 | 2024-04-20 07:47:06 | red | 2 | 14084 | 571 | 0.516 | 27294.6 |
2328 | 2024-04-18 08:55:13 | red | 1 | 5146 | 38 | 0.280 | 18378.6 |
2327 | 2024-04-09 07:01:28 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2326 | 2024-04-02 17:14:00 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2325 | 2024-03-31 20:19:23 | red | 1 | 5146 | 38 | 0.186 | 27666.7 |
2324 | 2024-03-31 00:50:07 | red | 2 | 14084 | 571 | 1.106 | 12734.2 |
2323 | 2024-03-19 05:56:35 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2322 | 2024-03-04 03:59:11 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2321 | 2024-03-02 16:28:04 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2320 | 2024-02-28 22:38:37 | red | 2 | 14084 | 571 | 0.393 | 35837.2 |
2319 | 2024-02-25 15:42:34 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2318 | 2024-02-18 08:06:23 | red | 2 | 14084 | 571 | 1.000 | 14084.0 |
2317 | 2024-02-18 01:54:29 | red | 1 | 5146 | 38 | 0.140 | 36757.1 |
2316 | 2024-02-15 14:30:28 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2315 | 2024-02-09 15:30:13 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2314 | 2024-01-28 23:51:00 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2313 | 2024-01-25 17:44:37 | red | 1 | 5146 | 38 | 0.190 | 27084.2 |
2312 | 2024-01-18 23:10:04 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2311 | 2024-01-13 17:16:07 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2310 | 2023-12-26 18:44:34 | red | 2 | 14084 | 571 | 0.466 | 30223.2 |
2309 | 2023-12-20 09:33:39 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2308 | 2023-11-24 18:59:31 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2307 | 2023-11-23 10:16:51 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2306 | 2023-11-22 05:17:38 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2305 | 2023-11-20 13:19:57 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2304 | 2023-11-17 22:58:12 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2303 | 2023-11-13 12:32:46 | red | 1 | 5146 | 38 | 0.063 | 81682.5 |
2302 | 2023-11-08 12:24:34 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2301 | 2023-11-07 10:59:16 | red | 1 | 5146 | 38 | 0.296 | 17385.1 |
2300 | 2023-10-27 03:02:34 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2299 | 2023-10-25 21:32:24 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2298 | 2023-10-20 04:26:14 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2297 | 2023-10-17 02:27:16 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2296 | 2023-10-11 20:32:38 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2295 | 2023-10-04 19:45:09 | red | 2 | 14084 | 571 | 0.346 | 40705.2 |
2294 | 2023-10-03 09:18:24 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2293 | 2023-09-21 15:14:52 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2292 | 2023-09-11 08:59:06 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2291 | 2023-08-23 14:28:02 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2290 | 2023-08-22 05:37:47 | red | 2 | 14084 | 571 | 0.500 | 28168.0 |
2289 | 2023-08-15 14:18:01 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2288 | 2023-08-10 12:39:24 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2287 | 2023-08-09 13:30:51 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2286 | 2023-07-27 16:32:03 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2285 | 2023-07-16 18:27:12 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2284 | 2023-06-27 01:58:28 | red | 2 | 14084 | 571 | 0.376 | 37457.4 |
2283 | 2023-06-20 07:03:56 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2282 | 2023-06-17 05:17:17 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2281 | 2023-06-06 05:30:33 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2280 | 2023-06-05 11:28:16 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2279 | 2023-06-04 08:12:06 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2278 | 2023-06-02 04:50:27 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2277 | 2023-06-01 11:56:17 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2276 | 2023-05-31 13:23:19 | red | 2 | 14084 | 571 | 0.326 | 43202.5 |
2275 | 2023-05-19 17:00:45 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2274 | 2023-05-07 09:50:35 | red | 2 | 14084 | 571 | 0.360 | 39122.2 |
2273 | 2023-05-01 19:32:18 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2272 | 2023-04-23 03:06:56 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2271 | 2023-04-01 11:25:28 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2270 | 2023-03-30 02:31:56 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2269 | 2023-02-11 14:45:26 | red | 2 | 14084 | 571 | 0.330 | 42678.8 |
2268 | 2023-02-04 01:00:23 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2267 | 2023-01-17 09:20:13 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2266 | 2023-01-16 15:40:36 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2265 | 2023-01-10 17:44:10 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2264 | 2023-01-01 10:31:55 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2263 | 2022-12-09 11:58:16 | red | 2 | 14084 | 571 | 0.406 | 34689.7 |
2262 | 2022-12-08 22:18:52 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2261 | 2022-12-03 10:13:56 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2260 | 2022-11-27 08:49:49 | red | 2 | 14084 | 571 | 0.403 | 34947.9 |
2259 | 2022-11-26 09:57:02 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2258 | 2022-11-26 07:40:54 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2257 | 2022-11-25 15:51:31 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2256 | 2022-11-25 13:18:52 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2255 | 2022-11-23 17:26:52 | red | 2 | 14084 | 571 | 0.420 | 33533.3 |
2254 | 2022-11-05 09:51:34 | red | 2 | 14084 | 571 | 0.373 | 37758.7 |
2253 | 2022-11-01 21:50:48 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2252 | 2022-10-30 11:48:16 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2251 | 2022-10-29 10:39:03 | red | 2 | 14084 | 571 | 0.423 | 33295.5 |
2250 | 2022-10-28 07:02:42 | red | 2 | 14084 | 571 | 0.373 | 37758.7 |
2249 | 2022-10-27 09:26:08 | red | 2 | 14084 | 571 | 0.326 | 43202.5 |
2248 | 2022-10-26 20:11:14 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2247 | 2022-10-25 07:14:56 | red | 2 | 14084 | 571 | 0.403 | 34947.9 |
2246 | 2022-10-24 12:55:49 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2245 | 2022-10-23 09:41:20 | red | 2 | 14084 | 571 | 0.393 | 35837.2 |
2244 | 2022-10-21 16:05:41 | red | 2 | 14084 | 571 | 0.453 | 31090.5 |
2243 | 2022-10-20 11:39:29 | red | 2 | 14084 | 571 | 0.423 | 33295.5 |
2242 | 2022-10-19 11:58:19 | red | 2 | 14084 | 571 | 0.733 | 19214.2 |
2241 | 2022-10-18 20:25:38 | red | 2 | 14084 | 571 | 0.376 | 37457.4 |
2240 | 2022-10-17 12:34:51 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2239 | 2022-10-16 16:14:59 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2238 | 2022-10-15 15:25:46 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2237 | 2022-10-14 17:53:40 | red | 2 | 14084 | 571 | 0.360 | 39122.2 |
2236 | 2022-10-14 15:42:57 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2235 | 2022-10-13 07:17:12 | red | 2 | 14084 | 571 | 0.406 | 34689.7 |
2234 | 2022-10-12 18:11:05 | red | 2 | 14084 | 571 | 0.406 | 34689.7 |