History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sally"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
867 | 2024-05-04 02:15:55 | sally | 1 | 28756 | 14 | 0.546 | 52666.7 |
866 | 2024-04-30 10:23:35 | sally | 1 | 28756 | 14 | 2.063 | 13938.9 |
865 | 2024-04-29 11:39:12 | sally | 1 | 28756 | 14 | 2.966 | 9695.2 |
864 | 2024-04-27 23:22:06 | sally | 1 | 28756 | 14 | 1.826 | 15748.1 |
863 | 2024-04-26 16:54:26 | sally | 1 | 28756 | 14 | 0.643 | 44721.6 |
862 | 2024-04-22 15:12:56 | sally | 1 | 28756 | 14 | 1.186 | 24246.2 |
861 | 2024-04-04 23:01:22 | sally | 1 | 28756 | 14 | 0.950 | 30269.5 |
860 | 2024-04-03 04:06:15 | sally | 1 | 28756 | 14 | 1.190 | 24164.7 |
859 | 2024-03-31 03:04:33 | sally | 1 | 28756 | 14 | 1.766 | 16283.1 |
858 | 2024-03-29 04:35:21 | sally | 2 | 53800 | 209 | 3.376 | 15936.0 |
857 | 2024-03-28 23:00:47 | sally | 1 | 28756 | 14 | 1.106 | 26000.0 |
856 | 2024-03-28 23:00:37 | sally | 2 | 53800 | 209 | 3.376 | 15936.0 |
855 | 2024-03-28 23:00:28 | sally | 1 | 28756 | 14 | 0.593 | 48492.4 |
854 | 2024-03-24 03:28:36 | sally | 1 | 28756 | 14 | 1.236 | 23265.4 |
853 | 2024-03-12 16:49:54 | sally | 1 | 28756 | 14 | 0.546 | 52666.7 |
852 | 2024-03-05 21:20:34 | sally | 2 | 53800 | 209 | 1.576 | 34137.1 |
851 | 2024-03-03 21:14:22 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
850 | 2024-03-02 04:23:33 | sally | 1 | 28756 | 14 | 0.576 | 49923.6 |
849 | 2024-02-27 23:55:30 | sally | 2 | 53800 | 209 | 1.846 | 29144.1 |
848 | 2024-02-27 23:07:32 | sally | 2 | 53800 | 209 | 1.923 | 27977.1 |
847 | 2024-02-27 20:34:54 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
846 | 2024-02-02 19:52:43 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
845 | 2024-02-01 23:44:50 | sally | 1 | 28756 | 14 | 0.550 | 52283.6 |
844 | 2024-01-07 13:08:11 | sally | 2 | 53800 | 209 | 1.466 | 36698.5 |
843 | 2023-12-24 00:26:29 | sally | 2 | 53800 | 209 | 1.796 | 29955.5 |
842 | 2023-12-09 09:26:16 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
841 | 2023-11-25 05:47:47 | sally | 2 | 53800 | 209 | 1.500 | 35866.7 |
840 | 2023-11-15 20:52:44 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
839 | 2023-11-12 14:24:27 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
838 | 2023-11-12 10:00:28 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
837 | 2023-11-03 11:07:06 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
836 | 2023-10-26 04:50:01 | sally | 1 | 28756 | 14 | 0.546 | 52666.7 |
835 | 2023-10-24 10:00:51 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
834 | 2023-10-19 06:08:36 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
833 | 2023-10-11 02:22:46 | sally | 1 | 28756 | 14 | 0.546 | 52666.7 |
832 | 2023-10-03 16:34:38 | sally | 1 | 28756 | 14 | 0.450 | 63902.2 |
831 | 2023-09-23 20:40:22 | sally | 1 | 28756 | 14 | 0.456 | 63061.4 |
830 | 2023-09-21 07:20:24 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
829 | 2023-09-12 05:14:44 | sally | 2 | 53800 | 209 | 1.690 | 31834.3 |
828 | 2023-09-10 12:39:28 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
827 | 2023-08-25 17:26:25 | sally | 2 | 53800 | 209 | 1.720 | 31279.1 |
826 | 2023-08-02 10:02:24 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
825 | 2023-07-15 19:14:26 | sally | 1 | 28756 | 14 | 0.546 | 52666.7 |
824 | 2023-07-07 18:32:37 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
823 | 2023-07-03 08:35:53 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
822 | 2023-05-11 20:57:57 | sally | 2 | 53800 | 209 | 1.453 | 37026.8 |
821 | 2023-05-11 19:52:45 | sally | 2 | 53800 | 209 | 1.423 | 37807.4 |
820 | 2023-05-10 21:01:19 | sally | 1 | 28756 | 14 | 0.950 | 30269.5 |
819 | 2023-04-28 16:44:44 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
818 | 2023-04-19 21:46:39 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
817 | 2023-04-03 13:32:52 | sally | 2 | 53800 | 209 | 1.673 | 32157.8 |
816 | 2023-03-21 01:34:43 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
815 | 2023-02-25 18:27:21 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
814 | 2023-02-18 14:05:33 | sally | 2 | 53800 | 209 | 1.406 | 38264.6 |
813 | 2023-01-25 13:33:48 | sally | 1 | 28756 | 14 | 0.483 | 59536.2 |
812 | 2023-01-20 02:52:57 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
811 | 2023-01-05 02:29:23 | sally | 1 | 28756 | 14 | 0.533 | 53951.2 |
810 | 2022-12-11 08:33:47 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
809 | 2022-12-01 10:26:32 | sally | 2 | 53800 | 209 | 1.423 | 37807.4 |
808 | 2022-11-21 14:21:38 | sally | 1 | 28756 | 14 | 0.626 | 45936.1 |
807 | 2022-10-25 00:36:13 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
806 | 2022-10-05 13:49:35 | sally | 1 | 28756 | 14 | 0.533 | 53951.2 |
805 | 2022-10-02 08:41:12 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
804 | 2022-09-11 09:32:14 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
803 | 2022-08-28 22:24:42 | sally | 1 | 28756 | 14 | 0.500 | 57512.0 |
802 | 2022-08-21 14:21:24 | sally | 1 | 28756 | 14 | 0.533 | 53951.2 |
801 | 2022-08-18 15:13:50 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
800 | 2022-08-07 04:04:34 | sally | 1 | 28756 | 14 | 0.483 | 59536.2 |
799 | 2022-07-26 09:05:22 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
798 | 2022-07-23 23:06:53 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
797 | 2022-07-08 18:39:46 | sally | 2 | 53800 | 209 | 1.423 | 37807.4 |
796 | 2022-06-30 10:43:30 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
795 | 2022-06-19 03:29:53 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
794 | 2022-06-04 19:56:38 | sally | 1 | 28756 | 14 | 0.450 | 63902.2 |
793 | 2022-06-02 12:56:46 | sally | 1 | 28756 | 14 | 0.483 | 59536.2 |
792 | 2022-05-31 07:22:38 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
791 | 2022-05-12 23:27:12 | sally | 1 | 28756 | 14 | 0.733 | 39230.6 |
790 | 2022-04-17 17:25:34 | sally | 1 | 28756 | 14 | 0.483 | 59536.2 |
789 | 2022-03-25 04:47:33 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
788 | 2022-03-10 07:36:30 | sally | 1 | 28756 | 14 | 0.466 | 61708.2 |
787 | 2022-03-06 22:57:51 | sally | 1 | 28756 | 14 | 0.466 | 61708.2 |
786 | 2022-02-03 19:43:29 | sally | 1 | 28756 | 14 | 0.513 | 56054.6 |
785 | 2022-02-01 16:00:45 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
784 | 2021-12-18 06:17:17 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
783 | 2021-11-29 23:58:18 | sally | 1 | 28756 | 14 | 0.466 | 61708.2 |
782 | 2021-11-25 22:20:37 | sally | 1 | 28756 | 14 | 0.466 | 61708.2 |
781 | 2021-11-23 13:35:20 | sally | 1 | 28756 | 14 | 0.516 | 55728.7 |
780 | 2021-10-07 06:50:02 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
779 | 2021-09-07 08:22:51 | sally | 1 | 28756 | 14 | 0.456 | 63061.4 |
778 | 2021-08-30 07:36:57 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
777 | 2021-08-22 21:41:06 | sally | 1 | 28756 | 14 | 0.466 | 61708.2 |
776 | 2021-06-13 13:51:32 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
775 | 2021-05-29 15:17:48 | sally | 1 | 28756 | 14 | 0.546 | 52666.7 |
774 | 2021-05-21 13:08:00 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
773 | 2021-04-22 01:03:45 | sally | 1 | 28756 | 14 | 0.530 | 54256.6 |
772 | 2021-03-24 11:08:12 | sally | 1 | 28756 | 14 | 0.466 | 61708.2 |
771 | 2021-03-23 15:49:49 | sally | 1 | 28756 | 14 | 0.453 | 63479.0 |
770 | 2021-02-26 20:32:40 | sally | 1 | 28756 | 14 | 0.483 | 59536.2 |
769 | 2021-02-14 11:18:06 | sally | 1 | 28756 | 14 | 0.470 | 61183.0 |
768 | 2021-02-12 13:37:38 | sally | 1 | 28756 | 14 | 0.456 | 63061.4 |