History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
729 | 2024-04-26 04:30:25 | canid | 1 | 28756 | 7 | 0.546 | 52666.7 |
728 | 2024-04-03 06:53:46 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
727 | 2024-03-31 07:00:45 | canid | 1 | 28756 | 7 | 1.780 | 16155.1 |
726 | 2024-03-30 19:48:34 | canid | 2 | 53800 | 128 | 3.903 | 13784.3 |
725 | 2024-03-30 18:38:31 | canid | 2 | 53800 | 128 | 3.483 | 15446.5 |
724 | 2024-03-29 21:30:46 | canid | 2 | 53800 | 128 | 3.923 | 13714.0 |
723 | 2024-03-29 21:30:40 | canid | 1 | 28756 | 7 | 0.780 | 36866.7 |
722 | 2024-03-03 22:48:34 | canid | 1 | 28756 | 7 | 1.826 | 15748.1 |
721 | 2024-03-01 09:28:10 | canid | 1 | 28756 | 7 | 0.593 | 48492.4 |
720 | 2024-02-28 20:18:19 | canid | 1 | 28756 | 7 | 1.080 | 26625.9 |
719 | 2024-02-18 16:31:25 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
718 | 2024-01-29 04:26:05 | canid | 1 | 28756 | 7 | 0.456 | 63061.4 |
717 | 2024-01-28 21:41:31 | canid | 1 | 28756 | 7 | 0.516 | 55728.7 |
716 | 2024-01-22 14:04:16 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
715 | 2024-01-17 02:20:56 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
714 | 2024-01-11 16:55:53 | canid | 1 | 28756 | 7 | 0.440 | 65354.5 |
713 | 2023-12-30 21:27:22 | canid | 2 | 53800 | 128 | 1.690 | 31834.3 |
712 | 2023-12-24 17:43:03 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
711 | 2023-12-23 13:26:01 | canid | 2 | 53800 | 128 | 1.406 | 38264.6 |
710 | 2023-12-17 05:27:37 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
709 | 2023-12-03 06:48:49 | canid | 2 | 53800 | 128 | 1.546 | 34799.5 |
708 | 2023-12-03 06:48:47 | canid | 2 | 53800 | 128 | 1.440 | 37361.1 |
707 | 2023-12-03 00:20:01 | canid | 2 | 53800 | 128 | 1.420 | 37887.3 |
706 | 2023-11-23 13:11:44 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
705 | 2023-11-19 04:22:32 | canid | 1 | 28756 | 7 | 0.516 | 55728.7 |
704 | 2023-11-17 12:48:22 | canid | 2 | 53800 | 128 | 1.486 | 36204.6 |
703 | 2023-11-13 03:23:13 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
702 | 2023-11-12 22:00:29 | canid | 1 | 28756 | 7 | 0.516 | 55728.7 |
701 | 2023-11-10 11:33:31 | canid | 1 | 28756 | 7 | 0.450 | 63902.2 |
700 | 2023-11-03 12:42:36 | canid | 1 | 28756 | 7 | 0.513 | 56054.6 |
699 | 2023-10-21 14:38:09 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
698 | 2023-10-18 19:53:07 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
697 | 2023-10-12 09:42:26 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
696 | 2023-10-05 06:39:19 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
695 | 2023-10-03 19:31:27 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
694 | 2023-10-01 19:25:20 | canid | 1 | 28756 | 7 | 0.530 | 54256.6 |
693 | 2023-09-26 14:16:37 | canid | 1 | 28756 | 7 | 0.533 | 53951.2 |
692 | 2023-09-15 11:17:16 | canid | 1 | 28756 | 7 | 0.456 | 63061.4 |
691 | 2023-09-02 01:38:32 | canid | 2 | 53800 | 128 | 1.486 | 36204.6 |
690 | 2023-08-30 11:24:49 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
689 | 2023-08-16 06:50:47 | canid | 1 | 28756 | 7 | 0.530 | 54256.6 |
688 | 2023-08-09 17:06:36 | canid | 1 | 28756 | 7 | 0.436 | 65954.1 |
687 | 2023-06-21 06:04:14 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
686 | 2023-06-02 01:01:24 | canid | 1 | 28756 | 7 | 0.513 | 56054.6 |
685 | 2023-05-21 17:03:46 | canid | 2 | 53800 | 128 | 1.423 | 37807.4 |
684 | 2023-03-27 00:32:28 | canid | 1 | 28756 | 7 | 0.440 | 65354.5 |
683 | 2023-03-24 22:26:22 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
682 | 2023-03-18 23:35:09 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
681 | 2023-03-03 22:45:59 | canid | 2 | 53800 | 128 | 1.423 | 37807.4 |
680 | 2023-01-09 13:33:51 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
679 | 2022-12-13 22:26:37 | canid | 1 | 28756 | 7 | 0.513 | 56054.6 |
678 | 2022-12-10 17:53:53 | canid | 1 | 28756 | 7 | 0.440 | 65354.5 |
677 | 2022-12-10 04:26:13 | canid | 2 | 53800 | 128 | 1.686 | 31909.8 |
676 | 2022-10-14 08:19:34 | canid | 1 | 28756 | 7 | 0.483 | 59536.2 |
675 | 2022-09-14 11:36:48 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
674 | 2022-09-03 00:39:52 | canid | 1 | 28756 | 7 | 0.516 | 55728.7 |
673 | 2022-09-01 18:11:47 | canid | 1 | 28756 | 7 | 0.640 | 44931.3 |
672 | 2022-08-30 19:04:48 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
671 | 2022-08-28 07:20:27 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
670 | 2022-08-14 20:42:26 | canid | 1 | 28756 | 7 | 0.450 | 63902.2 |
669 | 2022-08-06 13:58:10 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
668 | 2022-07-26 09:36:21 | canid | 2 | 53800 | 128 | 1.423 | 37807.4 |
667 | 2022-07-24 02:28:11 | canid | 2 | 53800 | 128 | 1.436 | 37465.2 |
666 | 2022-07-21 19:01:07 | canid | 2 | 53800 | 128 | 1.406 | 38264.6 |
665 | 2022-07-14 19:15:47 | canid | 2 | 53800 | 128 | 1.533 | 35094.6 |
664 | 2022-06-06 19:29:27 | canid | 2 | 53800 | 128 | 1.406 | 38264.6 |
663 | 2022-05-27 10:52:16 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
662 | 2022-05-25 03:56:20 | canid | 1 | 28756 | 7 | 0.466 | 61708.2 |
661 | 2022-05-14 20:08:32 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
660 | 2022-03-31 00:37:04 | canid | 2 | 53800 | 128 | 1.420 | 37887.3 |
659 | 2022-02-25 11:00:33 | canid | 2 | 53800 | 128 | 1.686 | 31909.8 |
658 | 2022-02-10 20:46:55 | canid | 1 | 28756 | 7 | 0.560 | 51350.0 |
657 | 2022-02-06 14:43:36 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
656 | 2021-12-30 06:11:11 | canid | 1 | 28756 | 7 | 0.516 | 55728.7 |
655 | 2021-12-19 03:57:57 | canid | 1 | 28756 | 7 | 0.466 | 61708.2 |
654 | 2021-11-11 17:20:46 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
653 | 2021-11-02 08:52:05 | canid | 1 | 28756 | 7 | 0.546 | 52666.7 |
652 | 2021-10-07 18:36:02 | canid | 1 | 28756 | 7 | 0.533 | 53951.2 |
651 | 2021-10-05 16:29:25 | canid | 1 | 28756 | 7 | 1.220 | 23570.5 |
650 | 2021-09-16 12:48:36 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
649 | 2021-08-02 13:28:38 | canid | 1 | 28756 | 7 | 0.483 | 59536.2 |
648 | 2021-06-01 05:44:54 | canid | 1 | 28756 | 7 | 0.530 | 54256.6 |
647 | 2021-05-06 22:59:09 | canid | 1 | 28756 | 7 | 0.483 | 59536.2 |
646 | 2021-04-28 05:36:34 | canid | 1 | 28756 | 7 | 0.516 | 55728.7 |
645 | 2021-04-05 04:56:33 | canid | 1 | 28756 | 7 | 0.530 | 54256.6 |
644 | 2021-02-18 23:33:16 | canid | 1 | 28756 | 7 | 0.486 | 59168.7 |
643 | 2021-01-23 15:17:09 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
642 | 2021-01-19 21:36:36 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
641 | 2020-12-20 11:08:42 | canid | 1 | 28756 | 7 | 0.530 | 54256.6 |
640 | 2020-11-03 17:25:27 | canid | 1 | 28756 | 7 | 0.750 | 38341.3 |
639 | 2020-10-28 09:58:39 | canid | 1 | 28756 | 7 | 0.486 | 59168.7 |
638 | 2020-10-23 01:26:01 | canid | 1 | 28756 | 7 | 0.513 | 56054.6 |
637 | 2020-10-21 19:23:29 | canid | 1 | 28756 | 7 | 0.456 | 63061.4 |
636 | 2020-10-07 18:20:28 | canid | 1 | 28756 | 7 | 0.546 | 52666.7 |
635 | 2020-09-13 22:03:54 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
634 | 2020-08-24 21:39:00 | canid | 1 | 28756 | 7 | 0.530 | 54256.6 |
633 | 2020-08-23 17:24:09 | canid | 1 | 28756 | 7 | 0.470 | 61183.0 |
632 | 2020-08-05 18:17:56 | canid | 1 | 28756 | 7 | 0.500 | 57512.0 |
631 | 2020-08-03 01:51:33 | canid | 1 | 28756 | 7 | 0.453 | 63479.0 |
630 | 2020-07-25 14:31:51 | canid | 1 | 28756 | 7 | 0.530 | 54256.6 |