History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bob"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2628 | 2025-05-15 22:04:26 | bob | 1 | 5146 | 30 | 0.110 | 46781.8 |
2627 | 2025-05-15 19:30:39 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2626 | 2025-05-15 11:07:07 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2625 | 2025-05-14 00:31:24 | bob | 1 | 5146 | 30 | 0.500 | 10292.0 |
2624 | 2025-05-12 11:15:30 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2623 | 2025-05-12 02:33:47 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2622 | 2025-05-10 16:32:10 | bob | 1 | 5146 | 30 | 0.486 | 10588.5 |
2621 | 2025-05-09 09:48:47 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2620 | 2025-05-08 19:52:11 | bob | 2 | 14084 | 412 | 1.796 | 7841.9 |
2619 | 2025-05-07 07:19:29 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |
2618 | 2025-05-06 03:12:24 | bob | 2 | 14084 | 412 | 0.843 | 16707.0 |
2617 | 2025-05-03 01:39:16 | bob | 1 | 5146 | 30 | 0.500 | 10292.0 |
2616 | 2025-05-01 17:29:31 | bob | 1 | 5146 | 30 | 0.080 | 64325.0 |
2615 | 2025-05-01 01:19:30 | bob | 1 | 5146 | 30 | 0.203 | 25349.8 |
2614 | 2025-04-30 12:50:46 | bob | 2 | 14084 | 412 | 2.906 | 4846.5 |
2613 | 2025-04-28 15:41:18 | bob | 1 | 5146 | 30 | 0.203 | 25349.8 |
2612 | 2025-04-26 22:46:59 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2611 | 2025-04-18 13:28:42 | bob | 2 | 14084 | 412 | 1.890 | 7451.9 |
2610 | 2025-04-16 16:30:53 | bob | 2 | 14084 | 412 | 1.670 | 8433.5 |
2609 | 2025-04-14 21:29:40 | bob | 1 | 5146 | 30 | 0.186 | 27666.7 |
2608 | 2025-04-14 18:24:32 | bob | 1 | 5146 | 30 | 0.673 | 7646.4 |
2607 | 2025-04-12 00:04:23 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2606 | 2025-04-10 23:46:53 | bob | 2 | 14084 | 412 | 1.716 | 8207.5 |
2605 | 2025-04-10 09:05:40 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2604 | 2025-04-06 02:04:44 | bob | 1 | 5146 | 30 | 0.203 | 25349.8 |
2603 | 2025-04-03 05:43:14 | bob | 1 | 5146 | 30 | 0.080 | 64325.0 |
2602 | 2025-03-31 02:21:05 | bob | 1 | 5146 | 30 | 0.110 | 46781.8 |
2601 | 2025-03-20 03:45:04 | bob | 2 | 14084 | 412 | 1.890 | 7451.9 |
2600 | 2025-03-19 00:09:20 | bob | 2 | 14084 | 412 | 0.356 | 39561.8 |
2599 | 2025-03-16 23:49:01 | bob | 2 | 14084 | 412 | 2.076 | 6784.2 |
2598 | 2025-03-16 00:17:55 | bob | 2 | 14084 | 412 | 2.423 | 5812.6 |
2597 | 2025-03-15 16:58:42 | bob | 2 | 14084 | 412 | 2.170 | 6490.3 |
2596 | 2025-03-14 19:40:58 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2595 | 2025-03-13 14:02:30 | bob | 1 | 5146 | 30 | 0.173 | 29745.7 |
2594 | 2025-03-13 00:22:28 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2593 | 2025-03-10 11:13:51 | bob | 2 | 14084 | 412 | 1.533 | 9187.2 |
2592 | 2025-03-10 10:40:59 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2591 | 2025-03-06 15:50:15 | bob | 1 | 5146 | 30 | 0.733 | 7020.5 |
2590 | 2025-03-05 07:09:31 | bob | 1 | 5146 | 30 | 0.203 | 25349.8 |
2589 | 2025-02-25 04:34:24 | bob | 2 | 14084 | 412 | 1.860 | 7572.0 |
2588 | 2025-02-25 00:58:41 | bob | 2 | 14084 | 412 | 2.406 | 5853.7 |
2587 | 2025-02-25 00:52:40 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2586 | 2025-02-23 17:12:53 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2585 | 2025-02-23 11:43:19 | bob | 1 | 5146 | 30 | 0.423 | 12165.5 |
2584 | 2025-02-04 21:39:57 | bob | 1 | 5146 | 30 | 0.296 | 17385.1 |
2583 | 2025-02-04 10:21:55 | bob | 2 | 14084 | 412 | 1.610 | 8747.8 |
2582 | 2025-02-04 10:15:45 | bob | 1 | 5146 | 30 | 0.610 | 8436.1 |
2581 | 2025-01-31 19:50:00 | bob | 2 | 14084 | 412 | 2.330 | 6044.6 |
2580 | 2025-01-25 22:55:49 | bob | 2 | 14084 | 412 | 1.640 | 8587.8 |
2579 | 2025-01-25 20:54:07 | bob | 2 | 14084 | 412 | 1.623 | 8677.8 |
2578 | 2025-01-25 20:44:55 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2577 | 2025-01-25 09:27:56 | bob | 1 | 5146 | 30 | 0.280 | 18378.6 |
2576 | 2025-01-24 15:19:46 | bob | 1 | 5146 | 30 | 0.313 | 16440.9 |
2575 | 2025-01-21 18:50:39 | bob | 1 | 5146 | 30 | 0.106 | 48547.2 |
2574 | 2025-01-05 08:51:41 | bob | 1 | 5146 | 30 | 0.610 | 8436.1 |
2573 | 2025-01-04 21:54:43 | bob | 1 | 5146 | 30 | 0.486 | 10588.5 |
2572 | 2024-12-27 13:20:38 | bob | 2 | 14084 | 412 | 1.656 | 8504.8 |
2571 | 2024-12-26 19:01:58 | bob | 1 | 5146 | 30 | 0.550 | 9356.4 |
2570 | 2024-12-26 17:50:28 | bob | 2 | 14084 | 412 | 1.843 | 7641.9 |
2569 | 2024-12-25 15:01:08 | bob | 2 | 14084 | 412 | 1.876 | 7507.5 |
2568 | 2024-12-25 14:38:47 | bob | 2 | 14084 | 412 | 2.000 | 7042.0 |
2567 | 2024-12-25 14:37:11 | bob | 1 | 5146 | 30 | 0.313 | 16440.9 |
2566 | 2024-12-06 03:59:03 | bob | 2 | 14084 | 412 | 1.890 | 7451.9 |
2565 | 2024-12-06 03:54:28 | bob | 1 | 5146 | 30 | 0.406 | 12674.9 |
2564 | 2024-12-01 20:28:14 | bob | 2 | 14084 | 412 | 0.966 | 14579.7 |
2563 | 2024-11-26 16:16:33 | bob | 1 | 5146 | 30 | 0.186 | 27666.7 |
2562 | 2024-11-26 16:15:45 | bob | 2 | 14084 | 412 | 0.876 | 16077.6 |
2561 | 2024-11-26 05:50:01 | bob | 1 | 5146 | 30 | 0.313 | 16440.9 |
2560 | 2024-11-25 14:12:50 | bob | 2 | 14084 | 412 | 0.436 | 32302.8 |
2559 | 2024-11-25 12:48:37 | bob | 2 | 14084 | 412 | 1.063 | 13249.3 |
2558 | 2024-11-25 12:35:43 | bob | 1 | 5146 | 30 | 0.080 | 64325.0 |
2557 | 2024-11-05 23:35:59 | bob | 2 | 14084 | 412 | 1.830 | 7696.2 |
2556 | 2024-11-05 23:32:07 | bob | 1 | 5146 | 30 | 0.080 | 64325.0 |
2555 | 2024-10-27 15:21:22 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2554 | 2024-10-26 18:34:20 | bob | 1 | 5146 | 30 | 0.686 | 7501.5 |
2553 | 2024-10-26 07:23:09 | bob | 1 | 5146 | 30 | 0.406 | 12674.9 |
2552 | 2024-10-25 15:43:31 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2551 | 2024-10-20 12:13:14 | bob | 1 | 5146 | 30 | 0.423 | 12165.5 |
2550 | 2024-10-06 23:24:03 | bob | 1 | 5146 | 30 | 0.466 | 11042.9 |
2549 | 2024-09-27 12:58:54 | bob | 1 | 5146 | 30 | 0.826 | 6230.0 |
2548 | 2024-09-26 15:26:42 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2547 | 2024-09-26 06:08:36 | bob | 1 | 5146 | 30 | 0.953 | 5399.8 |
2546 | 2024-09-17 08:47:07 | bob | 1 | 5146 | 30 | 0.436 | 11802.8 |
2545 | 2024-09-16 18:57:20 | bob | 1 | 5146 | 30 | 0.296 | 17385.1 |
2544 | 2024-09-06 23:43:39 | bob | 2 | 14084 | 412 | 1.530 | 9205.2 |
2543 | 2024-09-06 23:18:34 | bob | 1 | 5146 | 30 | 0.606 | 8491.7 |
2542 | 2024-09-01 00:52:50 | bob | 1 | 5146 | 30 | 1.403 | 3667.9 |
2541 | 2024-08-29 14:35:37 | bob | 1 | 5146 | 30 | 0.500 | 10292.0 |
2540 | 2024-08-28 11:50:31 | bob | 2 | 14084 | 412 | 1.596 | 8824.6 |
2539 | 2024-08-28 10:36:14 | bob | 2 | 14084 | 412 | 3.390 | 4154.6 |
2538 | 2024-08-28 09:42:20 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2537 | 2024-08-27 05:55:36 | bob | 1 | 5146 | 30 | 0.110 | 46781.8 |
2536 | 2024-08-19 23:06:44 | bob | 2 | 14084 | 412 | 0.390 | 36112.8 |
2535 | 2024-08-19 18:42:23 | bob | 1 | 5146 | 30 | 0.453 | 11359.8 |
2534 | 2024-08-07 22:09:44 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2533 | 2024-08-07 07:53:16 | bob | 1 | 5146 | 30 | 0.296 | 17385.1 |
2532 | 2024-08-06 21:29:35 | bob | 2 | 14084 | 412 | 0.966 | 14579.7 |
2531 | 2024-08-06 04:31:47 | bob | 1 | 5146 | 30 | 0.203 | 25349.8 |
2530 | 2024-08-02 03:31:59 | bob | 1 | 5146 | 30 | 0.423 | 12165.5 |
2529 | 2024-07-31 06:26:29 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |