History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shaw"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
861 | 2024-03-02 18:32:37 | shaw | 2 | 29872 | 242 | 3.076 | 9711.3 |
860 | 2024-03-02 17:01:34 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
859 | 2024-03-02 12:55:08 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
858 | 2024-02-19 03:55:00 | shaw | 2 | 29872 | 242 | 3.186 | 9376.0 |
857 | 2024-02-18 06:42:11 | shaw | 2 | 29872 | 242 | 2.296 | 13010.5 |
856 | 2024-02-17 13:09:25 | shaw | 2 | 29872 | 242 | 0.830 | 35990.4 |
855 | 2024-01-24 19:42:54 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
854 | 2024-01-16 19:34:15 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
853 | 2023-12-11 08:45:36 | shaw | 2 | 29872 | 242 | 0.826 | 36164.6 |
852 | 2023-11-25 04:58:03 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
851 | 2023-11-21 21:00:03 | shaw | 2 | 29872 | 242 | 0.890 | 33564.0 |
850 | 2023-11-16 05:22:18 | shaw | 2 | 29872 | 242 | 0.750 | 39829.3 |
849 | 2023-11-11 03:12:36 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
848 | 2023-11-11 01:35:27 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
847 | 2023-11-09 06:51:17 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
846 | 2023-11-07 06:53:37 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
845 | 2023-11-02 00:38:04 | shaw | 2 | 29872 | 242 | 0.893 | 33451.3 |
844 | 2023-10-27 01:58:25 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
843 | 2023-10-26 14:30:48 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
842 | 2023-10-20 17:02:21 | shaw | 1 | 13983 | 23 | 0.263 | 53167.3 |
841 | 2023-10-17 19:51:44 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
840 | 2023-10-16 22:16:12 | shaw | 2 | 29872 | 242 | 0.920 | 32469.6 |
839 | 2023-10-16 08:12:09 | shaw | 2 | 29872 | 242 | 0.860 | 34734.9 |
838 | 2023-10-10 23:58:25 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
837 | 2023-10-06 15:59:35 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
836 | 2023-10-04 01:47:56 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
835 | 2023-09-27 03:39:57 | shaw | 2 | 29872 | 242 | 0.826 | 36164.6 |
834 | 2023-09-19 17:23:52 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
833 | 2023-09-11 19:10:50 | shaw | 2 | 29872 | 242 | 0.906 | 32971.3 |
832 | 2023-09-10 12:15:18 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
831 | 2023-08-31 03:38:58 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
830 | 2023-08-16 19:53:28 | shaw | 2 | 29872 | 242 | 0.843 | 35435.3 |
829 | 2023-07-18 23:48:24 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
828 | 2023-06-19 17:11:20 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
827 | 2023-06-04 10:25:03 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
826 | 2023-05-12 15:35:02 | shaw | 2 | 29872 | 242 | 0.736 | 40587.0 |
825 | 2023-05-03 23:48:18 | shaw | 2 | 29872 | 242 | 2.076 | 14389.2 |
824 | 2023-03-31 14:38:09 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
823 | 2023-03-28 14:08:40 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
822 | 2023-03-04 04:44:01 | shaw | 1 | 13983 | 23 | 0.236 | 59250.0 |
821 | 2023-02-10 17:26:52 | shaw | 2 | 29872 | 242 | 0.876 | 34100.5 |
820 | 2023-01-11 16:09:22 | shaw | 1 | 13983 | 23 | 0.440 | 31779.5 |
819 | 2022-11-26 09:14:41 | shaw | 2 | 29872 | 242 | 0.843 | 35435.3 |
818 | 2022-11-21 20:46:35 | shaw | 2 | 29872 | 242 | 0.766 | 38997.4 |
817 | 2022-11-11 19:45:27 | shaw | 1 | 13983 | 23 | 0.236 | 59250.0 |
816 | 2022-10-26 05:57:47 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
815 | 2022-08-16 02:06:58 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
814 | 2022-07-22 15:58:03 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
813 | 2022-07-18 08:39:33 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
812 | 2022-07-10 11:18:42 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
811 | 2022-06-25 16:26:52 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
810 | 2022-06-15 12:02:32 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
809 | 2022-04-24 10:22:52 | shaw | 2 | 29872 | 242 | 0.830 | 35990.4 |
808 | 2022-04-22 04:40:43 | shaw | 2 | 29872 | 242 | 1.106 | 27009.0 |
807 | 2022-03-28 08:55:16 | shaw | 1 | 13983 | 23 | 0.640 | 21848.4 |
806 | 2022-02-22 23:33:44 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
805 | 2022-01-10 11:12:44 | shaw | 2 | 29872 | 242 | 0.750 | 39829.3 |
804 | 2021-12-27 13:35:30 | shaw | 2 | 29872 | 242 | 0.890 | 33564.0 |
803 | 2021-12-25 11:17:20 | shaw | 2 | 29872 | 242 | 0.766 | 38997.4 |
802 | 2021-12-14 02:53:09 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
801 | 2021-12-09 23:51:03 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
800 | 2021-12-07 22:25:35 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
799 | 2021-10-30 10:25:08 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
798 | 2021-10-29 08:10:07 | shaw | 1 | 13983 | 23 | 0.436 | 32071.1 |
797 | 2021-10-28 13:33:50 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
796 | 2021-10-27 15:40:07 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
795 | 2021-10-15 05:50:54 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
794 | 2021-10-13 04:32:37 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
793 | 2021-10-03 11:45:34 | shaw | 2 | 29872 | 242 | 0.830 | 35990.4 |
792 | 2021-09-07 01:19:10 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
791 | 2021-09-06 20:02:26 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
790 | 2021-08-22 15:17:22 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
789 | 2021-07-20 01:21:37 | shaw | 2 | 29872 | 242 | 0.843 | 35435.3 |
788 | 2021-06-25 18:35:44 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
787 | 2021-06-05 19:54:36 | shaw | 1 | 13983 | 23 | 0.266 | 52567.7 |
786 | 2021-04-24 13:55:43 | shaw | 1 | 13983 | 23 | 0.513 | 27257.3 |
785 | 2021-04-01 13:34:40 | shaw | 2 | 29872 | 242 | 0.843 | 35435.3 |
784 | 2021-03-31 15:51:57 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
783 | 2021-03-31 00:57:41 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
782 | 2021-03-30 09:03:13 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
781 | 2021-03-29 18:52:25 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
780 | 2021-03-29 00:47:02 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
779 | 2021-03-27 15:06:44 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
778 | 2021-03-26 07:15:01 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
777 | 2021-03-25 15:10:46 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
776 | 2021-03-11 03:08:27 | shaw | 1 | 13983 | 23 | 0.436 | 32071.1 |
775 | 2021-03-06 05:44:10 | shaw | 2 | 29872 | 242 | 0.750 | 39829.3 |
774 | 2021-03-03 17:13:38 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
773 | 2021-02-22 13:24:52 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
772 | 2021-02-21 14:03:09 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
771 | 2021-02-20 14:00:40 | shaw | 1 | 13983 | 23 | 0.296 | 47239.9 |
770 | 2021-02-19 12:44:11 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
769 | 2021-02-19 07:50:40 | shaw | 1 | 13983 | 23 | 0.233 | 60012.9 |
768 | 2021-02-18 07:49:33 | shaw | 1 | 13983 | 23 | 0.203 | 68881.8 |
767 | 2021-02-16 07:11:14 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
766 | 2021-02-15 07:48:11 | shaw | 1 | 13983 | 23 | 0.250 | 55932.0 |
765 | 2021-02-14 07:48:01 | shaw | 1 | 13983 | 23 | 0.216 | 64736.1 |
764 | 2021-02-13 14:58:25 | shaw | 1 | 13983 | 23 | 0.220 | 63559.1 |
763 | 2021-01-29 21:30:22 | shaw | 2 | 29872 | 242 | 0.873 | 34217.6 |
762 | 2021-01-28 17:42:28 | shaw | 1 | 13983 | 23 | 0.236 | 59250.0 |