History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bill"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
899 | 2024-05-05 06:29:23 | bill | 1 | 13983 | 28 | 0.530 | 26383.0 |
898 | 2024-05-04 00:26:26 | bill | 1 | 13983 | 28 | 0.563 | 24836.6 |
897 | 2024-05-02 00:39:23 | bill | 1 | 13983 | 28 | 0.263 | 53167.3 |
896 | 2024-04-28 01:46:05 | bill | 2 | 29872 | 274 | 0.923 | 32364.0 |
895 | 2024-04-05 05:45:16 | bill | 1 | 13983 | 28 | 0.280 | 49939.3 |
894 | 2024-04-01 16:10:49 | bill | 1 | 13983 | 28 | 0.280 | 49939.3 |
893 | 2024-03-30 19:51:30 | bill | 2 | 29872 | 274 | 2.046 | 14600.2 |
892 | 2024-03-28 19:05:34 | bill | 2 | 29872 | 274 | 2.406 | 12415.6 |
891 | 2024-03-28 17:55:46 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
890 | 2024-03-17 16:53:38 | bill | 1 | 13983 | 28 | 0.236 | 59250.0 |
889 | 2024-03-05 16:54:37 | bill | 1 | 13983 | 28 | 0.266 | 52567.7 |
888 | 2024-03-03 16:17:48 | bill | 2 | 29872 | 274 | 1.890 | 15805.3 |
887 | 2024-03-02 18:06:35 | bill | 2 | 29872 | 274 | 2.533 | 11793.1 |
886 | 2024-03-02 17:43:21 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
885 | 2024-03-02 13:25:57 | bill | 1 | 13983 | 28 | 0.546 | 25609.9 |
884 | 2024-02-29 12:59:42 | bill | 1 | 13983 | 28 | 0.266 | 52567.7 |
883 | 2024-02-26 08:43:05 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
882 | 2024-02-06 20:37:32 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
881 | 2024-02-04 16:45:06 | bill | 2 | 29872 | 274 | 1.016 | 29401.6 |
880 | 2024-02-04 12:43:21 | bill | 2 | 29872 | 274 | 2.000 | 14936.0 |
879 | 2024-02-04 12:13:42 | bill | 1 | 13983 | 28 | 0.266 | 52567.7 |
878 | 2024-01-27 06:48:41 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
877 | 2024-01-22 02:51:42 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
876 | 2024-01-05 01:10:28 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
875 | 2023-12-17 20:42:07 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
874 | 2023-12-17 10:59:40 | bill | 2 | 29872 | 274 | 0.733 | 40753.1 |
873 | 2023-12-16 07:51:55 | bill | 2 | 29872 | 274 | 0.766 | 38997.4 |
872 | 2023-12-10 13:47:03 | bill | 2 | 29872 | 274 | 0.733 | 40753.1 |
871 | 2023-12-10 12:36:11 | bill | 1 | 13983 | 28 | 0.203 | 68881.8 |
870 | 2023-12-04 18:47:07 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
869 | 2023-11-17 09:54:45 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
868 | 2023-11-11 20:43:41 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
867 | 2023-11-11 09:20:15 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
866 | 2023-11-03 09:18:38 | bill | 2 | 29872 | 274 | 0.830 | 35990.4 |
865 | 2023-10-29 06:41:12 | bill | 1 | 13983 | 28 | 0.236 | 59250.0 |
864 | 2023-10-20 07:12:42 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
863 | 2023-10-18 11:21:03 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
862 | 2023-10-13 21:44:32 | bill | 2 | 29872 | 274 | 0.843 | 35435.3 |
861 | 2023-10-10 10:58:08 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
860 | 2023-10-05 01:49:44 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
859 | 2023-09-25 09:58:17 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
858 | 2023-09-03 08:09:39 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
857 | 2023-08-31 11:06:59 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
856 | 2023-06-26 16:58:58 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
855 | 2023-05-31 04:57:20 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
854 | 2023-05-27 22:40:45 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
853 | 2023-03-27 14:21:50 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
852 | 2023-03-19 14:34:43 | bill | 1 | 13983 | 28 | 0.203 | 68881.8 |
851 | 2023-02-22 00:29:16 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
850 | 2023-01-06 20:09:06 | bill | 1 | 13983 | 28 | 0.203 | 68881.8 |
849 | 2022-11-25 05:08:08 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
848 | 2022-11-15 16:40:50 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
847 | 2022-10-03 18:22:18 | bill | 1 | 13983 | 28 | 0.203 | 68881.8 |
846 | 2022-09-18 21:40:04 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
845 | 2022-08-31 14:20:18 | bill | 1 | 13983 | 28 | 0.296 | 47239.9 |
844 | 2022-08-15 15:29:10 | bill | 1 | 13983 | 28 | 0.236 | 59250.0 |
843 | 2022-08-09 00:59:57 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
842 | 2022-08-06 06:30:48 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
841 | 2022-08-06 04:55:02 | bill | 1 | 13983 | 28 | 0.203 | 68881.8 |
840 | 2022-05-21 18:45:18 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
839 | 2022-04-28 23:15:24 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
838 | 2022-02-09 15:49:23 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
837 | 2022-02-07 12:14:38 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
836 | 2022-01-25 14:00:35 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
835 | 2021-12-01 07:37:25 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
834 | 2021-11-10 17:24:32 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
833 | 2021-11-07 06:34:14 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
832 | 2021-10-25 04:35:42 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
831 | 2021-10-12 20:34:47 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
830 | 2021-09-24 16:47:47 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
829 | 2021-09-06 16:17:23 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
828 | 2021-08-17 21:39:15 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
827 | 2021-08-15 17:25:05 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
826 | 2021-07-21 21:49:58 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
825 | 2021-07-13 05:06:48 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
824 | 2021-05-01 22:43:00 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
823 | 2021-04-30 12:21:51 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
822 | 2021-04-19 02:43:34 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
821 | 2021-04-01 08:57:02 | bill | 2 | 29872 | 274 | 0.860 | 34734.9 |
820 | 2021-03-06 01:43:16 | bill | 2 | 29872 | 274 | 0.766 | 38997.4 |
819 | 2021-02-08 23:24:08 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
818 | 2021-01-18 06:55:11 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
817 | 2021-01-14 15:57:00 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
816 | 2020-11-24 12:46:05 | bill | 2 | 29872 | 274 | 0.750 | 39829.3 |
815 | 2020-10-27 21:14:42 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
814 | 2020-10-27 20:46:23 | bill | 2 | 29872 | 274 | 0.763 | 39150.7 |
813 | 2020-10-20 13:17:36 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
812 | 2020-10-19 13:16:29 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
811 | 2020-10-18 11:04:55 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
810 | 2020-10-14 09:18:15 | bill | 2 | 29872 | 274 | 0.750 | 39829.3 |
809 | 2020-10-05 08:58:28 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
808 | 2020-10-01 20:24:48 | bill | 1 | 13983 | 28 | 0.236 | 59250.0 |
807 | 2020-10-01 08:06:56 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
806 | 2020-08-16 13:49:22 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
805 | 2020-08-13 16:15:58 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
804 | 2020-07-29 22:17:18 | bill | 1 | 13983 | 28 | 0.233 | 60012.9 |
803 | 2020-07-27 10:47:41 | bill | 1 | 13983 | 28 | 0.250 | 55932.0 |
802 | 2020-07-25 10:11:18 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |
801 | 2020-07-18 06:58:06 | bill | 1 | 13983 | 28 | 0.216 | 64736.1 |
800 | 2020-05-06 04:14:24 | bill | 1 | 13983 | 28 | 0.220 | 63559.1 |