History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ships"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2496 | 2024-04-18 23:14:41 | ships | 2 | 53800 | 213 | 1.360 | 39558.8 |
2495 | 2024-04-04 19:54:33 | ships | 1 | 28756 | 15 | 0.670 | 42919.4 |
2494 | 2024-04-02 22:37:47 | ships | 2 | 53800 | 213 | 4.016 | 13396.4 |
2493 | 2024-04-02 21:13:18 | ships | 1 | 28756 | 15 | 0.470 | 61183.0 |
2492 | 2024-03-31 01:16:53 | ships | 1 | 28756 | 15 | 1.000 | 28756.0 |
2491 | 2024-03-26 22:16:23 | ships | 1 | 28756 | 15 | 1.156 | 24875.4 |
2490 | 2024-03-16 00:20:41 | ships | 1 | 28756 | 15 | 0.516 | 55728.7 |
2489 | 2024-03-05 18:39:04 | ships | 1 | 28756 | 15 | 2.330 | 12341.6 |
2488 | 2024-02-29 13:19:03 | ships | 1 | 28756 | 15 | 0.533 | 53951.2 |
2487 | 2024-02-25 18:29:19 | ships | 1 | 28756 | 15 | 0.546 | 52666.7 |
2486 | 2024-02-19 22:42:19 | ships | 2 | 53800 | 213 | 4.313 | 12473.9 |
2485 | 2024-02-19 09:48:42 | ships | 2 | 53800 | 213 | 1.343 | 40059.6 |
2484 | 2024-01-26 02:34:49 | ships | 1 | 28756 | 15 | 0.486 | 59168.7 |
2483 | 2024-01-21 09:23:03 | ships | 2 | 53800 | 213 | 1.576 | 34137.1 |
2482 | 2024-01-11 07:00:39 | ships | 1 | 28756 | 15 | 0.500 | 57512.0 |
2481 | 2023-12-19 23:09:18 | ships | 1 | 28756 | 15 | 0.453 | 63479.0 |
2480 | 2023-12-15 19:01:25 | ships | 1 | 28756 | 15 | 0.470 | 61183.0 |
2479 | 2023-11-27 20:00:20 | ships | 1 | 28756 | 15 | 0.580 | 49579.3 |
2478 | 2023-11-26 14:07:07 | ships | 1 | 28756 | 15 | 0.436 | 65954.1 |
2477 | 2023-11-17 11:57:45 | ships | 2 | 53800 | 213 | 1.343 | 40059.6 |
2476 | 2023-11-14 09:55:21 | ships | 1 | 28756 | 15 | 0.453 | 63479.0 |
2475 | 2023-11-09 15:00:09 | ships | 2 | 53800 | 213 | 1.626 | 33087.3 |
2474 | 2023-11-09 06:43:43 | ships | 1 | 28756 | 15 | 0.453 | 63479.0 |
2473 | 2023-11-09 06:30:02 | ships | 2 | 53800 | 213 | 1.466 | 36698.5 |
2472 | 2023-11-07 18:04:23 | ships | 2 | 53800 | 213 | 1.360 | 39558.8 |
2471 | 2023-11-06 17:20:31 | ships | 2 | 53800 | 213 | 1.610 | 33416.1 |
2470 | 2023-11-05 17:21:09 | ships | 2 | 53800 | 213 | 1.356 | 39675.5 |
2469 | 2023-11-04 17:06:22 | ships | 2 | 53800 | 213 | 1.546 | 34799.5 |
2468 | 2023-11-03 17:53:57 | ships | 2 | 53800 | 213 | 1.550 | 34709.7 |
2467 | 2023-11-02 17:19:59 | ships | 2 | 53800 | 213 | 1.610 | 33416.1 |
2466 | 2023-11-01 16:05:19 | ships | 2 | 53800 | 213 | 1.656 | 32487.9 |
2465 | 2023-10-31 15:47:55 | ships | 2 | 53800 | 213 | 1.530 | 35163.4 |
2464 | 2023-10-30 15:40:52 | ships | 2 | 53800 | 213 | 1.580 | 34050.6 |
2463 | 2023-10-29 23:46:46 | ships | 2 | 53800 | 213 | 1.546 | 34799.5 |
2462 | 2023-10-29 15:43:17 | ships | 2 | 53800 | 213 | 1.423 | 37807.4 |
2461 | 2023-10-28 23:59:12 | ships | 2 | 53800 | 213 | 1.623 | 33148.5 |
2460 | 2023-10-28 16:06:08 | ships | 2 | 53800 | 213 | 1.453 | 37026.8 |
2459 | 2023-10-27 16:08:33 | ships | 2 | 53800 | 213 | 1.390 | 38705.0 |
2458 | 2023-10-27 14:39:58 | ships | 1 | 28756 | 15 | 0.486 | 59168.7 |
2457 | 2023-10-26 23:09:49 | ships | 2 | 53800 | 213 | 1.596 | 33709.3 |
2456 | 2023-10-26 15:51:22 | ships | 2 | 53800 | 213 | 1.470 | 36598.6 |
2455 | 2023-10-26 06:34:11 | ships | 2 | 53800 | 213 | 1.513 | 35558.5 |
2454 | 2023-10-25 17:40:23 | ships | 2 | 53800 | 213 | 1.593 | 33772.8 |
2453 | 2023-10-25 06:31:11 | ships | 2 | 53800 | 213 | 1.516 | 35488.1 |
2452 | 2023-10-24 17:39:12 | ships | 2 | 53800 | 213 | 2.703 | 19903.8 |
2451 | 2023-10-24 06:30:50 | ships | 2 | 53800 | 213 | 2.360 | 22796.6 |
2450 | 2023-10-23 19:11:02 | ships | 2 | 53800 | 213 | 1.643 | 32745.0 |
2449 | 2023-10-23 06:49:57 | ships | 2 | 53800 | 213 | 1.733 | 31044.4 |
2448 | 2023-10-22 20:17:56 | ships | 2 | 53800 | 213 | 1.563 | 34421.0 |
2447 | 2023-10-22 06:43:05 | ships | 2 | 53800 | 213 | 1.483 | 36277.8 |
2446 | 2023-10-21 18:53:45 | ships | 2 | 53800 | 213 | 1.436 | 37465.2 |
2445 | 2023-10-21 06:52:00 | ships | 2 | 53800 | 213 | 1.610 | 33416.1 |
2444 | 2023-10-20 08:46:53 | ships | 2 | 53800 | 213 | 1.546 | 34799.5 |
2443 | 2023-10-20 06:37:17 | ships | 2 | 53800 | 213 | 1.360 | 39558.8 |
2442 | 2023-10-19 16:49:31 | ships | 1 | 28756 | 15 | 0.516 | 55728.7 |
2441 | 2023-10-19 15:51:59 | ships | 2 | 53800 | 213 | 1.610 | 33416.1 |
2440 | 2023-10-18 16:01:31 | ships | 2 | 53800 | 213 | 1.423 | 37807.4 |
2439 | 2023-10-17 19:48:14 | ships | 1 | 28756 | 15 | 0.533 | 53951.2 |
2438 | 2023-10-17 16:13:49 | ships | 2 | 53800 | 213 | 1.550 | 34709.7 |
2437 | 2023-10-17 06:04:03 | ships | 2 | 53800 | 213 | 1.423 | 37807.4 |
2436 | 2023-10-16 23:35:58 | ships | 2 | 53800 | 213 | 1.546 | 34799.5 |
2435 | 2023-10-15 23:58:35 | ships | 2 | 53800 | 213 | 1.440 | 37361.1 |
2434 | 2023-10-15 00:21:03 | ships | 2 | 53800 | 213 | 1.686 | 31909.8 |
2433 | 2023-10-14 06:29:56 | ships | 2 | 53800 | 213 | 3.190 | 16865.2 |
2432 | 2023-10-13 07:04:15 | ships | 2 | 53800 | 213 | 1.690 | 31834.3 |
2431 | 2023-10-12 21:32:27 | ships | 2 | 53800 | 213 | 3.326 | 16175.6 |
2430 | 2023-10-12 06:50:23 | ships | 2 | 53800 | 213 | 1.423 | 37807.4 |
2429 | 2023-10-11 12:53:09 | ships | 2 | 53800 | 213 | 1.376 | 39098.8 |
2428 | 2023-10-11 08:00:28 | ships | 1 | 28756 | 15 | 0.513 | 56054.6 |
2427 | 2023-10-10 12:48:32 | ships | 2 | 53800 | 213 | 1.436 | 37465.2 |
2426 | 2023-10-09 12:44:21 | ships | 2 | 53800 | 213 | 1.356 | 39675.5 |
2425 | 2023-10-07 22:57:39 | ships | 2 | 53800 | 213 | 1.373 | 39184.3 |
2424 | 2023-10-07 11:23:43 | ships | 2 | 53800 | 213 | 1.406 | 38264.6 |
2423 | 2023-10-06 23:45:10 | ships | 2 | 53800 | 213 | 1.360 | 39558.8 |
2422 | 2023-10-06 01:35:41 | ships | 2 | 53800 | 213 | 3.123 | 17227.0 |
2421 | 2023-10-05 01:22:14 | ships | 2 | 53800 | 213 | 1.373 | 39184.3 |
2420 | 2023-10-04 07:53:59 | ships | 2 | 53800 | 213 | 1.423 | 37807.4 |
2419 | 2023-10-03 15:21:04 | ships | 1 | 28756 | 15 | 0.453 | 63479.0 |
2418 | 2023-10-03 08:19:18 | ships | 2 | 53800 | 213 | 1.656 | 32487.9 |
2417 | 2023-10-03 08:02:10 | ships | 2 | 53800 | 213 | 1.593 | 33772.8 |
2416 | 2023-10-02 16:49:02 | ships | 1 | 28756 | 15 | 0.890 | 32310.1 |
2415 | 2023-10-02 08:31:19 | ships | 2 | 53800 | 213 | 1.623 | 33148.5 |
2414 | 2023-09-30 14:13:00 | ships | 2 | 53800 | 213 | 1.406 | 38264.6 |
2413 | 2023-09-29 04:31:40 | ships | 2 | 53800 | 213 | 1.376 | 39098.8 |
2412 | 2023-09-28 09:16:43 | ships | 2 | 53800 | 213 | 1.406 | 38264.6 |
2411 | 2023-09-28 04:34:49 | ships | 2 | 53800 | 213 | 1.423 | 37807.4 |
2410 | 2023-09-27 11:51:43 | ships | 2 | 53800 | 213 | 1.546 | 34799.5 |
2409 | 2023-09-26 22:30:27 | ships | 2 | 53800 | 213 | 1.546 | 34799.5 |
2408 | 2023-09-25 22:27:18 | ships | 2 | 53800 | 213 | 1.563 | 34421.0 |
2407 | 2023-09-25 11:35:36 | ships | 1 | 28756 | 15 | 0.580 | 49579.3 |
2406 | 2023-09-24 22:12:05 | ships | 2 | 53800 | 213 | 1.406 | 38264.6 |
2405 | 2023-09-24 15:16:06 | ships | 2 | 53800 | 213 | 1.360 | 39558.8 |
2404 | 2023-09-23 15:04:24 | ships | 2 | 53800 | 213 | 1.533 | 35094.6 |
2403 | 2023-09-22 15:16:44 | ships | 2 | 53800 | 213 | 1.376 | 39098.8 |
2402 | 2023-09-21 22:21:03 | ships | 2 | 53800 | 213 | 1.420 | 37887.3 |
2401 | 2023-09-20 21:40:49 | ships | 2 | 53800 | 213 | 1.970 | 27309.6 |
2400 | 2023-09-19 22:02:08 | ships | 2 | 53800 | 213 | 1.373 | 39184.3 |
2399 | 2023-09-19 15:50:35 | ships | 1 | 28756 | 15 | 0.453 | 63479.0 |
2398 | 2023-09-19 15:26:31 | ships | 2 | 53800 | 213 | 1.703 | 31591.3 |
2397 | 2023-09-18 15:05:34 | ships | 2 | 53800 | 213 | 1.606 | 33499.4 |