History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crane"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
841 | 2024-04-27 17:05:29 | crane | 1 | 28756 | 11 | 0.486 | 59168.7 |
840 | 2024-04-24 09:28:41 | crane | 1 | 28756 | 11 | 1.016 | 28303.1 |
839 | 2024-04-22 21:06:52 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
838 | 2024-04-09 16:14:06 | crane | 1 | 28756 | 11 | 0.513 | 56054.6 |
837 | 2024-04-03 06:06:54 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
836 | 2024-03-31 05:55:10 | crane | 2 | 53800 | 231 | 3.936 | 13668.7 |
835 | 2024-03-31 03:44:51 | crane | 1 | 28756 | 11 | 0.543 | 52957.6 |
834 | 2024-03-29 09:12:20 | crane | 1 | 28756 | 11 | 1.140 | 25224.6 |
833 | 2024-03-03 21:23:51 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
832 | 2024-02-28 01:26:29 | crane | 2 | 53800 | 231 | 3.576 | 15044.7 |
831 | 2024-02-28 01:26:24 | crane | 1 | 28756 | 11 | 0.530 | 54256.6 |
830 | 2024-02-12 19:05:56 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
829 | 2024-01-31 14:15:39 | crane | 1 | 28756 | 11 | 0.546 | 52666.7 |
828 | 2024-01-28 20:32:05 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
827 | 2024-01-09 13:30:55 | crane | 1 | 28756 | 11 | 0.610 | 47141.0 |
826 | 2024-01-01 19:37:49 | crane | 2 | 53800 | 231 | 1.420 | 37887.3 |
825 | 2023-12-26 09:24:21 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
824 | 2023-12-16 20:09:51 | crane | 2 | 53800 | 231 | 1.670 | 32215.6 |
823 | 2023-12-12 13:20:44 | crane | 1 | 28756 | 11 | 0.513 | 56054.6 |
822 | 2023-12-08 12:51:34 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
821 | 2023-12-08 12:51:33 | crane | 1 | 28756 | 11 | 0.623 | 46157.3 |
820 | 2023-11-28 01:42:15 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
819 | 2023-11-20 19:08:49 | crane | 1 | 28756 | 11 | 0.486 | 59168.7 |
818 | 2023-11-13 11:42:52 | crane | 1 | 28756 | 11 | 0.436 | 65954.1 |
817 | 2023-11-12 05:38:47 | crane | 1 | 28756 | 11 | 0.440 | 65354.5 |
816 | 2023-11-03 22:42:56 | crane | 2 | 53800 | 231 | 1.516 | 35488.1 |
815 | 2023-11-01 10:52:22 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
814 | 2023-10-26 03:58:46 | crane | 2 | 53800 | 231 | 1.623 | 33148.5 |
813 | 2023-10-19 19:23:38 | crane | 1 | 28756 | 11 | 0.486 | 59168.7 |
812 | 2023-10-18 15:46:16 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
811 | 2023-10-14 23:14:16 | crane | 1 | 28756 | 11 | 0.440 | 65354.5 |
810 | 2023-10-06 08:21:16 | crane | 2 | 53800 | 231 | 1.406 | 38264.6 |
809 | 2023-10-03 11:06:50 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
808 | 2023-09-29 23:18:52 | crane | 1 | 28756 | 11 | 0.563 | 51076.4 |
807 | 2023-09-27 04:50:08 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
806 | 2023-09-13 08:41:53 | crane | 1 | 28756 | 11 | 0.470 | 61183.0 |
805 | 2023-09-12 03:11:48 | crane | 1 | 28756 | 11 | 0.486 | 59168.7 |
804 | 2023-09-11 22:17:04 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
803 | 2023-08-07 00:14:48 | crane | 1 | 28756 | 11 | 0.466 | 61708.2 |
802 | 2023-08-06 10:13:27 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
801 | 2023-07-11 23:44:09 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
800 | 2023-06-30 11:50:29 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
799 | 2023-06-26 04:14:39 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
798 | 2023-04-12 01:14:28 | crane | 1 | 28756 | 11 | 0.423 | 67981.1 |
797 | 2023-03-31 13:28:12 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
796 | 2023-03-20 09:28:10 | crane | 1 | 28756 | 11 | 0.440 | 65354.5 |
795 | 2023-02-06 21:32:01 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
794 | 2022-12-08 20:37:50 | crane | 1 | 28756 | 11 | 0.860 | 33437.2 |
793 | 2022-12-04 22:29:48 | crane | 1 | 28756 | 11 | 0.486 | 59168.7 |
792 | 2022-09-01 03:45:56 | crane | 1 | 28756 | 11 | 0.560 | 51350.0 |
791 | 2022-08-28 11:32:22 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
790 | 2022-08-06 04:26:36 | crane | 1 | 28756 | 11 | 0.443 | 64912.0 |
789 | 2022-06-30 01:40:47 | crane | 2 | 53800 | 231 | 1.390 | 38705.0 |
788 | 2022-06-07 11:39:01 | crane | 1 | 28756 | 11 | 0.436 | 65954.1 |
787 | 2022-05-23 04:29:20 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
786 | 2022-05-19 18:24:49 | crane | 1 | 28756 | 11 | 0.436 | 65954.1 |
785 | 2022-04-02 06:13:16 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
784 | 2022-02-15 02:23:22 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
783 | 2022-02-11 13:31:55 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
782 | 2022-01-21 20:12:34 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
781 | 2022-01-21 09:44:54 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
780 | 2022-01-20 22:26:35 | crane | 1 | 28756 | 11 | 0.513 | 56054.6 |
779 | 2022-01-20 13:46:32 | crane | 1 | 28756 | 11 | 1.016 | 28303.1 |
778 | 2022-01-20 02:59:27 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
777 | 2022-01-19 17:59:47 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
776 | 2022-01-19 08:19:52 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
775 | 2022-01-18 18:02:17 | crane | 1 | 28756 | 11 | 0.780 | 36866.7 |
774 | 2022-01-18 02:13:01 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
773 | 2022-01-06 00:25:09 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
772 | 2022-01-03 21:15:06 | crane | 1 | 28756 | 11 | 0.533 | 53951.2 |
771 | 2021-12-17 12:46:55 | crane | 1 | 28756 | 11 | 0.470 | 61183.0 |
770 | 2021-12-17 02:01:58 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
769 | 2021-12-16 18:38:10 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
768 | 2021-12-16 05:03:28 | crane | 1 | 28756 | 11 | 0.533 | 53951.2 |
767 | 2021-12-15 16:00:51 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
766 | 2021-12-15 00:00:48 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
765 | 2021-12-14 12:59:26 | crane | 1 | 28756 | 11 | 1.063 | 27051.7 |
764 | 2021-11-15 15:17:51 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
763 | 2021-11-15 07:04:02 | crane | 1 | 28756 | 11 | 0.483 | 59536.2 |
762 | 2021-11-15 02:02:13 | crane | 1 | 28756 | 11 | 0.436 | 65954.1 |
761 | 2021-11-14 14:44:28 | crane | 1 | 28756 | 11 | 0.530 | 54256.6 |
760 | 2021-11-14 06:28:10 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
759 | 2021-11-13 16:16:49 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
758 | 2021-11-13 08:01:11 | crane | 1 | 28756 | 11 | 0.906 | 31739.5 |
757 | 2021-11-12 18:51:10 | crane | 1 | 28756 | 11 | 0.506 | 56830.0 |
756 | 2021-11-12 05:22:31 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
755 | 2021-11-11 11:58:01 | crane | 1 | 28756 | 11 | 0.530 | 54256.6 |
754 | 2021-11-10 13:00:05 | crane | 1 | 28756 | 11 | 0.860 | 33437.2 |
753 | 2021-11-07 14:33:07 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |
752 | 2021-11-07 03:03:57 | crane | 1 | 28756 | 11 | 0.470 | 61183.0 |
751 | 2021-11-07 02:45:32 | crane | 1 | 28756 | 11 | 0.436 | 65954.1 |
750 | 2021-11-06 19:33:55 | crane | 1 | 28756 | 11 | 0.516 | 55728.7 |
749 | 2021-11-06 09:31:02 | crane | 1 | 28756 | 11 | 0.953 | 30174.2 |
748 | 2021-11-05 22:05:22 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
747 | 2021-11-05 12:15:50 | crane | 1 | 28756 | 11 | 0.470 | 61183.0 |
746 | 2021-11-05 03:56:52 | crane | 1 | 28756 | 11 | 0.440 | 65354.5 |
745 | 2021-11-04 18:01:07 | crane | 1 | 28756 | 11 | 0.436 | 65954.1 |
744 | 2021-11-02 04:20:01 | crane | 1 | 28756 | 11 | 0.436 | 65954.1 |
743 | 2021-10-14 16:33:02 | crane | 1 | 28756 | 11 | 0.453 | 63479.0 |
742 | 2021-10-13 19:46:32 | crane | 1 | 28756 | 11 | 0.500 | 57512.0 |