History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doits"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
710 | 2024-04-27 17:08:07 | doits | 1 | 28756 | 9 | 0.563 | 51076.4 |
709 | 2024-04-27 12:00:49 | doits | 1 | 28756 | 9 | 1.796 | 16011.1 |
708 | 2024-04-17 18:52:50 | doits | 1 | 28756 | 9 | 1.860 | 15460.2 |
707 | 2024-04-13 04:04:09 | doits | 1 | 28756 | 9 | 0.530 | 54256.6 |
706 | 2024-04-12 19:16:37 | doits | 2 | 53800 | 263 | 1.626 | 33087.3 |
705 | 2024-04-12 19:16:33 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
704 | 2024-04-12 19:16:25 | doits | 2 | 53800 | 263 | 1.640 | 32804.9 |
703 | 2024-04-04 19:46:16 | doits | 2 | 53800 | 263 | 5.703 | 9433.6 |
702 | 2024-04-04 14:32:23 | doits | 2 | 53800 | 263 | 1.390 | 38705.0 |
701 | 2024-04-03 06:13:16 | doits | 1 | 28756 | 9 | 1.983 | 14501.3 |
700 | 2024-04-01 17:51:30 | doits | 1 | 28756 | 9 | 1.143 | 25158.4 |
699 | 2024-03-31 15:25:18 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
698 | 2024-03-30 06:41:35 | doits | 2 | 53800 | 263 | 3.750 | 14346.7 |
697 | 2024-03-29 00:11:04 | doits | 2 | 53800 | 263 | 3.750 | 14346.7 |
696 | 2024-03-28 22:56:02 | doits | 1 | 28756 | 9 | 1.046 | 27491.4 |
695 | 2024-03-18 04:07:48 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
694 | 2024-03-13 04:31:50 | doits | 1 | 28756 | 9 | 1.063 | 27051.7 |
693 | 2024-03-13 04:31:36 | doits | 2 | 53800 | 263 | 2.466 | 21816.7 |
692 | 2024-03-12 17:14:22 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
691 | 2024-03-04 01:43:42 | doits | 2 | 53800 | 263 | 1.873 | 28724.0 |
690 | 2024-03-04 01:43:32 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
689 | 2024-03-01 12:02:54 | doits | 1 | 28756 | 9 | 0.530 | 54256.6 |
688 | 2024-02-28 03:11:37 | doits | 2 | 53800 | 263 | 1.703 | 31591.3 |
687 | 2024-02-27 22:26:53 | doits | 2 | 53800 | 263 | 2.126 | 25305.7 |
686 | 2024-02-27 20:56:50 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
685 | 2024-02-11 07:22:54 | doits | 1 | 28756 | 9 | 1.110 | 25906.3 |
684 | 2024-02-03 01:23:31 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
683 | 2024-01-28 19:49:53 | doits | 1 | 28756 | 9 | 0.516 | 55728.7 |
682 | 2024-01-28 07:43:09 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
681 | 2024-01-23 14:47:39 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
680 | 2024-01-14 12:00:52 | doits | 2 | 53800 | 263 | 1.656 | 32487.9 |
679 | 2024-01-12 16:46:11 | doits | 2 | 53800 | 263 | 1.576 | 34137.1 |
678 | 2024-01-12 00:52:14 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
677 | 2024-01-09 19:45:58 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
676 | 2023-12-28 10:01:49 | doits | 2 | 53800 | 263 | 1.373 | 39184.3 |
675 | 2023-12-07 23:02:56 | doits | 1 | 28756 | 9 | 0.516 | 55728.7 |
674 | 2023-12-06 14:25:01 | doits | 2 | 53800 | 263 | 1.466 | 36698.5 |
673 | 2023-11-17 07:14:43 | doits | 1 | 28756 | 9 | 0.486 | 59168.7 |
672 | 2023-11-14 02:21:05 | doits | 1 | 28756 | 9 | 0.470 | 61183.0 |
671 | 2023-11-13 03:57:02 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
670 | 2023-11-03 15:36:30 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
669 | 2023-11-01 19:32:33 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
668 | 2023-10-21 05:01:53 | doits | 1 | 28756 | 9 | 1.656 | 17364.7 |
667 | 2023-10-19 21:58:46 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
666 | 2023-10-18 23:54:34 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
665 | 2023-10-12 08:38:49 | doits | 1 | 28756 | 9 | 0.486 | 59168.7 |
664 | 2023-10-11 04:55:56 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
663 | 2023-10-04 23:26:38 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
662 | 2023-09-24 23:15:38 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
661 | 2023-09-14 02:15:44 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
660 | 2023-09-02 22:47:46 | doits | 2 | 53800 | 263 | 1.546 | 34799.5 |
659 | 2023-08-27 23:45:12 | doits | 1 | 28756 | 9 | 0.873 | 32939.3 |
658 | 2023-07-06 12:23:09 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
657 | 2023-05-28 15:00:03 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
656 | 2023-05-19 15:20:00 | doits | 2 | 53800 | 263 | 1.343 | 40059.6 |
655 | 2023-03-29 23:55:47 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
654 | 2023-03-22 21:12:32 | doits | 1 | 28756 | 9 | 0.423 | 67981.1 |
653 | 2023-02-26 06:09:51 | doits | 2 | 53800 | 263 | 1.606 | 33499.4 |
652 | 2023-01-09 05:00:14 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
651 | 2022-12-21 04:40:59 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
650 | 2022-12-07 03:29:07 | doits | 2 | 53800 | 263 | 1.360 | 39558.8 |
649 | 2022-10-16 22:38:51 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
648 | 2022-09-18 12:23:56 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
647 | 2022-09-06 23:29:03 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
646 | 2022-08-23 14:43:51 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
645 | 2022-08-07 17:04:32 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
644 | 2022-06-25 21:20:23 | doits | 1 | 28756 | 9 | 0.423 | 67981.1 |
643 | 2022-06-04 11:10:32 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
642 | 2022-05-29 00:09:58 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
641 | 2022-04-07 15:59:40 | doits | 2 | 53800 | 263 | 1.576 | 34137.1 |
640 | 2022-02-21 02:33:43 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
639 | 2022-02-16 11:13:31 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
638 | 2022-02-14 06:31:03 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
637 | 2021-12-16 21:10:00 | doits | 2 | 53800 | 263 | 1.516 | 35488.1 |
636 | 2021-12-05 19:33:45 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
635 | 2021-11-19 16:37:45 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
634 | 2021-10-15 05:31:29 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
633 | 2021-09-04 20:06:06 | doits | 1 | 28756 | 9 | 0.670 | 42919.4 |
632 | 2021-08-20 09:45:41 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
631 | 2021-08-16 19:47:07 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
630 | 2021-07-28 00:02:44 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
629 | 2021-05-19 02:25:06 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
628 | 2021-05-16 03:15:24 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
627 | 2021-05-15 09:16:39 | doits | 1 | 28756 | 9 | 0.470 | 61183.0 |
626 | 2021-05-12 18:52:44 | doits | 1 | 28756 | 9 | 0.516 | 55728.7 |
625 | 2021-04-18 23:53:52 | doits | 1 | 28756 | 9 | 0.530 | 54256.6 |
624 | 2021-02-08 21:20:47 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
623 | 2021-02-03 15:48:48 | doits | 1 | 28756 | 9 | 0.513 | 56054.6 |
622 | 2021-01-03 14:07:08 | doits | 1 | 28756 | 9 | 0.440 | 65354.5 |
621 | 2020-12-30 08:05:22 | doits | 1 | 28756 | 9 | 0.483 | 59536.2 |
620 | 2020-11-19 16:45:09 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
619 | 2020-11-11 22:49:26 | doits | 1 | 28756 | 9 | 0.546 | 52666.7 |
618 | 2020-11-01 22:25:23 | doits | 1 | 28756 | 9 | 0.453 | 63479.0 |
617 | 2020-10-23 09:25:19 | doits | 1 | 28756 | 9 | 0.423 | 67981.1 |
616 | 2020-10-21 15:57:49 | doits | 1 | 28756 | 9 | 0.486 | 59168.7 |
615 | 2020-10-20 16:38:18 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
614 | 2020-09-06 21:00:34 | doits | 1 | 28756 | 9 | 0.436 | 65954.1 |
613 | 2020-09-06 14:00:13 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |
612 | 2020-09-03 11:53:44 | doits | 1 | 28756 | 9 | 0.466 | 61708.2 |
611 | 2020-08-18 08:17:33 | doits | 1 | 28756 | 9 | 0.500 | 57512.0 |