History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"color"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2386 | 2025-02-05 13:51:52 | color | 1 | 28756 | 6 | 2.390 | 12031.8 |
2385 | 2025-01-28 21:20:10 | color | 1 | 28756 | 6 | 0.440 | 65354.5 |
2384 | 2025-01-28 13:55:31 | color | 2 | 53800 | 124 | 8.623 | 6239.1 |
2383 | 2025-01-28 10:34:52 | color | 2 | 53800 | 124 | 8.640 | 6226.9 |
2382 | 2025-01-28 10:27:30 | color | 1 | 28756 | 6 | 0.453 | 63479.0 |
2381 | 2025-01-28 09:44:00 | color | 1 | 28756 | 6 | 0.453 | 63479.0 |
2380 | 2025-01-06 06:23:33 | color | 2 | 53800 | 124 | 4.080 | 13186.3 |
2379 | 2025-01-06 06:23:29 | color | 1 | 28756 | 6 | 1.920 | 14977.1 |
2378 | 2025-01-05 10:39:16 | color | 1 | 28756 | 6 | 0.923 | 31154.9 |
2377 | 2025-01-05 06:46:36 | color | 1 | 28756 | 6 | 3.250 | 8848.0 |
2376 | 2025-01-05 06:46:20 | color | 1 | 28756 | 6 | 1.453 | 19790.8 |
2375 | 2025-01-05 06:46:07 | color | 1 | 28756 | 6 | 2.470 | 11642.1 |
2374 | 2024-12-29 09:03:53 | color | 2 | 53800 | 124 | 8.330 | 6458.6 |
2373 | 2024-12-29 08:33:46 | color | 2 | 53800 | 124 | 7.516 | 7158.1 |
2372 | 2024-12-29 08:27:37 | color | 1 | 28756 | 6 | 0.530 | 54256.6 |
2371 | 2024-12-29 08:05:28 | color | 1 | 28756 | 6 | 0.550 | 52283.6 |
2370 | 2024-12-26 06:46:46 | color | 1 | 28756 | 6 | 0.970 | 29645.4 |
2369 | 2024-12-26 06:46:20 | color | 1 | 28756 | 6 | 3.486 | 8249.0 |
2368 | 2024-12-26 06:46:03 | color | 1 | 28756 | 6 | 2.170 | 13251.6 |
2367 | 2024-12-07 10:22:15 | color | 1 | 28756 | 6 | 3.436 | 8369.0 |
2366 | 2024-12-07 00:33:26 | color | 2 | 53800 | 124 | 8.890 | 6051.7 |
2365 | 2024-12-07 00:33:24 | color | 1 | 28756 | 6 | 1.843 | 15602.8 |
2364 | 2024-11-29 07:42:42 | color | 2 | 53800 | 124 | 12.080 | 4453.6 |
2363 | 2024-11-29 06:46:45 | color | 1 | 28756 | 6 | 0.516 | 55728.7 |
2362 | 2024-11-29 06:45:41 | color | 1 | 28756 | 6 | 0.483 | 59536.2 |
2361 | 2024-11-11 01:30:43 | color | 2 | 53800 | 124 | 4.563 | 11790.5 |
2360 | 2024-11-06 20:44:22 | color | 1 | 28756 | 6 | 3.393 | 8475.1 |
2359 | 2024-11-06 02:57:42 | color | 1 | 28756 | 6 | 3.450 | 8335.1 |
2358 | 2024-11-06 02:45:23 | color | 2 | 53800 | 124 | 10.330 | 5208.1 |
2357 | 2024-10-30 15:30:51 | color | 2 | 53800 | 124 | 3.890 | 13830.3 |
2356 | 2024-10-30 04:36:27 | color | 1 | 28756 | 6 | 0.483 | 59536.2 |
2355 | 2024-10-30 03:24:53 | color | 2 | 53800 | 124 | 7.330 | 7339.7 |
2354 | 2024-10-30 02:29:46 | color | 1 | 28756 | 6 | 0.530 | 54256.6 |
2353 | 2024-10-27 05:56:02 | color | 1 | 28756 | 6 | 3.923 | 7330.1 |
2352 | 2024-10-24 12:33:55 | color | 1 | 28756 | 6 | 2.406 | 11951.8 |
2351 | 2024-10-21 02:12:54 | color | 1 | 28756 | 6 | 2.610 | 11017.6 |
2350 | 2024-10-16 18:55:59 | color | 1 | 28756 | 6 | 3.653 | 7871.9 |
2349 | 2024-10-12 00:30:04 | color | 1 | 28756 | 6 | 2.453 | 11722.8 |
2348 | 2024-10-12 00:30:00 | color | 1 | 28756 | 6 | 1.500 | 19170.7 |
2347 | 2024-10-12 00:29:57 | color | 1 | 28756 | 6 | 1.560 | 18433.3 |
2346 | 2024-10-12 00:29:55 | color | 1 | 28756 | 6 | 2.313 | 12432.3 |
2345 | 2024-10-12 00:29:43 | color | 1 | 28756 | 6 | 1.796 | 16011.1 |
2344 | 2024-10-10 15:24:49 | color | 1 | 28756 | 6 | 1.266 | 22714.1 |
2343 | 2024-10-07 21:42:19 | color | 1 | 28756 | 6 | 1.283 | 22413.1 |
2342 | 2024-10-04 14:02:44 | color | 2 | 53800 | 124 | 12.360 | 4352.8 |
2341 | 2024-10-04 14:02:17 | color | 2 | 53800 | 124 | 7.376 | 7293.9 |
2340 | 2024-10-04 06:50:33 | color | 2 | 53800 | 124 | 12.313 | 4369.4 |
2339 | 2024-10-03 08:09:55 | color | 2 | 53800 | 124 | 17.826 | 3018.1 |
2338 | 2024-10-03 08:08:40 | color | 1 | 28756 | 6 | 2.030 | 14165.5 |
2337 | 2024-10-03 07:29:04 | color | 1 | 28756 | 6 | 5.013 | 5736.3 |
2336 | 2024-10-03 06:19:13 | color | 1 | 28756 | 6 | 2.923 | 9837.8 |
2335 | 2024-09-30 01:24:02 | color | 2 | 53800 | 124 | 18.033 | 2983.4 |
2334 | 2024-09-29 23:54:13 | color | 1 | 28756 | 6 | 0.453 | 63479.0 |
2333 | 2024-09-29 17:59:39 | color | 1 | 28756 | 6 | 0.516 | 55728.7 |
2332 | 2024-09-27 03:09:18 | color | 1 | 28756 | 6 | 3.610 | 7965.7 |
2331 | 2024-09-07 14:54:42 | color | 1 | 28756 | 6 | 3.563 | 8070.7 |
2330 | 2024-09-02 06:03:20 | color | 2 | 53800 | 124 | 18.360 | 2930.3 |
2329 | 2024-09-01 12:34:19 | color | 2 | 53800 | 124 | 8.156 | 6596.4 |
2328 | 2024-09-01 02:06:26 | color | 2 | 53800 | 124 | 10.936 | 4919.5 |
2327 | 2024-09-01 02:05:24 | color | 1 | 28756 | 6 | 2.593 | 11089.9 |
2326 | 2024-08-30 21:56:31 | color | 2 | 53800 | 124 | 15.580 | 3453.1 |
2325 | 2024-08-30 21:16:49 | color | 1 | 28756 | 6 | 0.516 | 55728.7 |
2324 | 2024-08-30 11:55:16 | color | 1 | 28756 | 6 | 3.253 | 8839.8 |
2323 | 2024-08-27 20:45:05 | color | 1 | 28756 | 6 | 3.123 | 9207.8 |
2322 | 2024-08-16 23:15:02 | color | 2 | 53800 | 124 | 17.030 | 3159.1 |
2321 | 2024-08-10 18:53:30 | color | 1 | 28756 | 6 | 0.983 | 29253.3 |
2320 | 2024-08-08 02:30:17 | color | 1 | 28756 | 6 | 2.483 | 11581.2 |
2319 | 2024-08-02 04:27:11 | color | 1 | 28756 | 6 | 1.593 | 18051.5 |
2318 | 2024-08-01 09:26:47 | color | 1 | 28756 | 6 | 1.970 | 14597.0 |
2317 | 2024-07-31 00:50:28 | color | 2 | 53800 | 124 | 11.343 | 4743.0 |
2316 | 2024-07-31 00:38:27 | color | 1 | 28756 | 6 | 0.466 | 61708.2 |
2315 | 2024-07-31 00:14:11 | color | 1 | 28756 | 6 | 0.530 | 54256.6 |
2314 | 2024-07-28 13:03:46 | color | 1 | 28756 | 6 | 2.046 | 14054.7 |
2313 | 2024-07-28 00:10:44 | color | 1 | 28756 | 6 | 1.376 | 20898.3 |
2312 | 2024-07-27 12:43:32 | color | 2 | 53800 | 124 | 3.860 | 13937.8 |
2311 | 2024-07-20 15:41:17 | color | 1 | 28756 | 6 | 2.140 | 13437.4 |
2310 | 2024-07-10 16:09:20 | color | 1 | 28756 | 6 | 2.356 | 12205.4 |
2309 | 2024-07-09 00:42:02 | color | 1 | 28756 | 6 | 2.000 | 14378.0 |
2308 | 2024-07-07 09:42:57 | color | 1 | 28756 | 6 | 2.516 | 11429.3 |
2307 | 2024-07-02 16:45:36 | color | 2 | 53800 | 124 | 6.326 | 8504.6 |
2306 | 2024-06-30 19:52:50 | color | 1 | 28756 | 6 | 1.110 | 25906.3 |
2305 | 2024-06-30 13:59:43 | color | 1 | 28756 | 6 | 0.986 | 29164.3 |
2304 | 2024-06-28 16:12:56 | color | 2 | 53800 | 124 | 9.033 | 5955.9 |
2303 | 2024-06-28 08:59:47 | color | 1 | 28756 | 6 | 0.533 | 53951.2 |
2302 | 2024-06-27 21:26:35 | color | 2 | 53800 | 124 | 5.313 | 10126.1 |
2301 | 2024-06-27 09:11:01 | color | 1 | 28756 | 6 | 1.750 | 16432.0 |
2300 | 2024-06-27 08:39:22 | color | 1 | 28756 | 6 | 0.830 | 34645.8 |
2299 | 2024-06-26 01:52:56 | color | 1 | 28756 | 6 | 0.983 | 29253.3 |
2298 | 2024-06-24 00:39:14 | color | 1 | 28756 | 6 | 1.843 | 15602.8 |
2297 | 2024-06-18 05:38:50 | color | 1 | 28756 | 6 | 1.890 | 15214.8 |
2296 | 2024-06-16 01:04:56 | color | 1 | 28756 | 6 | 1.970 | 14597.0 |
2295 | 2024-06-14 09:39:26 | color | 1 | 28756 | 6 | 1.533 | 18758.0 |
2294 | 2024-06-14 01:06:50 | color | 2 | 53800 | 124 | 3.453 | 15580.7 |
2293 | 2024-06-11 01:41:51 | color | 2 | 53800 | 124 | 2.436 | 22085.4 |
2292 | 2024-06-09 14:46:09 | color | 2 | 53800 | 124 | 6.296 | 8545.1 |
2291 | 2024-06-07 15:30:07 | color | 1 | 28756 | 6 | 2.313 | 12432.3 |
2290 | 2024-06-06 20:28:14 | color | 1 | 28756 | 6 | 1.093 | 26309.2 |
2289 | 2024-06-06 15:04:49 | color | 1 | 28756 | 6 | 0.936 | 30722.2 |
2288 | 2024-06-05 18:24:22 | color | 1 | 28756 | 6 | 0.530 | 54256.6 |
2287 | 2024-06-05 09:10:54 | color | 1 | 28756 | 6 | 0.546 | 52666.7 |