History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
893 | 2024-04-27 16:54:44 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
892 | 2024-04-27 09:22:04 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
891 | 2024-04-25 20:57:32 | subs | 1 | 13983 | 27 | 0.313 | 44674.1 |
890 | 2024-04-19 18:58:45 | subs | 1 | 13983 | 27 | 0.533 | 26234.5 |
889 | 2024-04-03 12:49:33 | subs | 1 | 13983 | 27 | 0.580 | 24108.6 |
888 | 2024-04-03 00:12:38 | subs | 1 | 13983 | 27 | 0.313 | 44674.1 |
887 | 2024-04-01 17:41:39 | subs | 2 | 29872 | 343 | 3.156 | 9465.1 |
886 | 2024-04-01 16:22:01 | subs | 1 | 13983 | 27 | 0.313 | 44674.1 |
885 | 2024-03-31 00:48:30 | subs | 2 | 29872 | 343 | 1.156 | 25840.8 |
884 | 2024-03-30 23:33:18 | subs | 1 | 13983 | 27 | 0.546 | 25609.9 |
883 | 2024-03-17 22:32:18 | subs | 1 | 13983 | 27 | 0.283 | 49409.9 |
882 | 2024-03-03 20:31:11 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
881 | 2024-03-02 15:40:29 | subs | 2 | 29872 | 343 | 2.046 | 14600.2 |
880 | 2024-03-02 14:13:33 | subs | 2 | 29872 | 343 | 1.970 | 15163.5 |
879 | 2024-03-02 14:08:57 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
878 | 2024-02-27 20:59:36 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
877 | 2024-02-12 07:56:47 | subs | 1 | 13983 | 27 | 1.483 | 9428.9 |
876 | 2024-01-28 13:14:03 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
875 | 2024-01-25 19:04:53 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
874 | 2024-01-24 22:55:51 | subs | 1 | 13983 | 27 | 0.216 | 64736.1 |
873 | 2024-01-07 15:06:54 | subs | 2 | 29872 | 343 | 0.763 | 39150.7 |
872 | 2023-12-29 15:12:24 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
871 | 2023-12-21 20:32:58 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
870 | 2023-12-11 15:35:44 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
869 | 2023-12-11 15:35:40 | subs | 2 | 29872 | 343 | 0.906 | 32971.3 |
868 | 2023-11-21 19:14:24 | subs | 1 | 13983 | 27 | 0.216 | 64736.1 |
867 | 2023-11-21 02:29:50 | subs | 2 | 29872 | 343 | 0.796 | 37527.6 |
866 | 2023-11-15 20:23:54 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
865 | 2023-11-11 03:38:37 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
864 | 2023-10-29 04:40:08 | subs | 2 | 29872 | 343 | 0.860 | 34734.9 |
863 | 2023-10-28 23:31:18 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
862 | 2023-10-27 03:53:19 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
861 | 2023-10-21 14:04:26 | subs | 2 | 29872 | 343 | 0.750 | 39829.3 |
860 | 2023-10-19 21:15:17 | subs | 1 | 13983 | 27 | 0.203 | 68881.8 |
859 | 2023-10-17 04:08:24 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
858 | 2023-10-16 23:55:16 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
857 | 2023-10-11 10:38:35 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
856 | 2023-10-09 01:46:06 | subs | 1 | 13983 | 27 | 0.216 | 64736.1 |
855 | 2023-10-03 23:53:23 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
854 | 2023-09-22 22:52:23 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
853 | 2023-09-22 14:33:15 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
852 | 2023-08-05 19:48:21 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
851 | 2023-07-16 19:42:57 | subs | 1 | 13983 | 27 | 0.203 | 68881.8 |
850 | 2023-06-22 22:56:59 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
849 | 2023-05-03 05:15:14 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
848 | 2023-03-04 04:45:05 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
847 | 2023-02-25 09:39:49 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
846 | 2022-12-22 07:50:13 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
845 | 2022-11-11 19:45:35 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
844 | 2022-09-10 21:30:09 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
843 | 2022-09-06 20:36:30 | subs | 1 | 13983 | 27 | 0.216 | 64736.1 |
842 | 2022-08-15 01:53:45 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
841 | 2022-07-22 16:23:38 | subs | 1 | 13983 | 27 | 0.203 | 68881.8 |
840 | 2022-06-24 20:55:22 | subs | 1 | 13983 | 27 | 0.216 | 64736.1 |
839 | 2022-06-17 03:06:18 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
838 | 2022-06-09 00:36:27 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
837 | 2022-06-08 18:17:31 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
836 | 2022-04-11 11:11:30 | subs | 1 | 13983 | 27 | 0.296 | 47239.9 |
835 | 2022-03-31 20:07:21 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
834 | 2022-02-14 17:53:18 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
833 | 2022-01-24 12:11:30 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
832 | 2022-01-22 07:53:27 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
831 | 2022-01-05 21:22:25 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
830 | 2022-01-02 17:07:17 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
829 | 2022-01-02 08:27:25 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
828 | 2022-01-01 13:14:04 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
827 | 2021-12-23 18:52:16 | subs | 1 | 13983 | 27 | 0.233 | 60012.9 |
826 | 2021-12-23 08:26:19 | subs | 1 | 13983 | 27 | 0.280 | 49939.3 |
825 | 2021-12-23 00:33:48 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
824 | 2021-12-22 13:45:41 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
823 | 2021-12-22 06:15:11 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
822 | 2021-12-21 19:10:27 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
821 | 2021-12-21 10:23:35 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
820 | 2021-12-20 21:08:27 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
819 | 2021-12-20 13:37:34 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
818 | 2021-12-20 12:30:19 | subs | 1 | 13983 | 27 | 0.530 | 26383.0 |
817 | 2021-12-20 02:50:54 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
816 | 2021-12-19 19:01:32 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
815 | 2021-11-23 21:59:36 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
814 | 2021-11-15 15:51:13 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
813 | 2021-11-14 22:37:12 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
812 | 2021-11-14 11:09:35 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
811 | 2021-11-13 15:51:30 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
810 | 2021-11-12 22:05:06 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
809 | 2021-11-12 10:06:55 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
808 | 2021-11-11 14:52:44 | subs | 1 | 13983 | 27 | 0.216 | 64736.1 |
807 | 2021-11-11 06:53:17 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
806 | 2021-11-10 21:10:54 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
805 | 2021-11-10 19:19:43 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
804 | 2021-10-30 20:36:12 | subs | 1 | 13983 | 27 | 0.216 | 64736.1 |
803 | 2021-10-30 08:08:44 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
802 | 2021-10-29 17:07:04 | subs | 1 | 13983 | 27 | 0.236 | 59250.0 |
801 | 2021-10-28 22:53:38 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
800 | 2021-10-27 23:50:04 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
799 | 2021-09-21 20:55:20 | subs | 1 | 13983 | 27 | 0.250 | 55932.0 |
798 | 2021-09-16 12:49:01 | subs | 1 | 13983 | 27 | 0.266 | 52567.7 |
797 | 2021-09-14 11:09:59 | subs | 1 | 13983 | 27 | 0.263 | 53167.3 |
796 | 2021-09-10 01:44:48 | subs | 1 | 13983 | 27 | 0.236 | 59250.0 |
795 | 2021-08-27 19:51:28 | subs | 1 | 13983 | 27 | 0.220 | 63559.1 |
794 | 2021-06-09 04:00:32 | subs | 1 | 13983 | 27 | 0.516 | 27098.8 |