History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lily"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
829 | 2024-04-27 09:10:37 | lily | 1 | 13983 | 10 | 0.343 | 40766.8 |
828 | 2024-04-25 12:33:16 | lily | 1 | 13983 | 10 | 0.266 | 52567.7 |
827 | 2024-04-24 22:40:20 | lily | 1 | 13983 | 10 | 0.263 | 53167.3 |
826 | 2024-04-05 05:45:32 | lily | 2 | 29872 | 243 | 1.000 | 29872.0 |
825 | 2024-04-05 05:45:28 | lily | 1 | 13983 | 10 | 0.376 | 37188.8 |
824 | 2024-04-05 05:45:24 | lily | 2 | 29872 | 243 | 1.143 | 26134.7 |
823 | 2024-04-04 23:00:47 | lily | 2 | 29872 | 243 | 5.546 | 5386.2 |
822 | 2024-04-04 22:45:31 | lily | 1 | 13983 | 10 | 0.283 | 49409.9 |
821 | 2024-04-03 00:09:30 | lily | 2 | 29872 | 243 | 2.126 | 14050.8 |
820 | 2024-04-03 00:08:36 | lily | 1 | 13983 | 10 | 0.860 | 16259.3 |
819 | 2024-03-30 21:14:16 | lily | 1 | 13983 | 10 | 0.830 | 16847.0 |
818 | 2024-03-27 07:36:27 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
817 | 2024-03-05 19:32:40 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
816 | 2024-03-03 18:44:56 | lily | 1 | 13983 | 10 | 0.533 | 26234.5 |
815 | 2024-02-29 23:04:48 | lily | 1 | 13983 | 10 | 0.283 | 49409.9 |
814 | 2024-02-25 22:39:20 | lily | 1 | 13983 | 10 | 0.813 | 17199.3 |
813 | 2024-02-11 11:12:10 | lily | 2 | 29872 | 243 | 3.736 | 7995.7 |
812 | 2024-02-10 19:46:44 | lily | 2 | 29872 | 243 | 1.483 | 20143.0 |
811 | 2024-02-02 23:59:45 | lily | 1 | 13983 | 10 | 0.280 | 49939.3 |
810 | 2024-02-02 15:41:39 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
809 | 2024-01-29 14:44:55 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
808 | 2024-01-28 14:22:03 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
807 | 2024-01-26 16:18:53 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
806 | 2024-01-01 11:20:20 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
805 | 2023-12-14 22:01:10 | lily | 2 | 29872 | 243 | 0.750 | 39829.3 |
804 | 2023-11-25 12:38:41 | lily | 2 | 29872 | 243 | 0.763 | 39150.7 |
803 | 2023-11-16 06:18:50 | lily | 2 | 29872 | 243 | 0.750 | 39829.3 |
802 | 2023-11-11 19:14:42 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
801 | 2023-11-09 16:55:05 | lily | 1 | 13983 | 10 | 0.236 | 59250.0 |
800 | 2023-11-04 21:07:58 | lily | 2 | 29872 | 243 | 0.813 | 36742.9 |
799 | 2023-10-26 08:22:21 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
798 | 2023-10-25 14:24:24 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
797 | 2023-10-25 10:33:45 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
796 | 2023-10-20 07:18:58 | lily | 1 | 13983 | 10 | 0.283 | 49409.9 |
795 | 2023-10-17 04:37:06 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
794 | 2023-10-14 13:40:01 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
793 | 2023-10-12 02:49:46 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
792 | 2023-10-03 16:28:00 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
791 | 2023-09-22 20:19:02 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
790 | 2023-09-15 20:19:42 | lily | 1 | 13983 | 10 | 0.436 | 32071.1 |
789 | 2023-09-10 20:27:35 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
788 | 2023-08-20 23:13:59 | lily | 1 | 13983 | 10 | 0.203 | 68881.8 |
787 | 2023-08-16 23:27:04 | lily | 2 | 29872 | 243 | 1.750 | 17069.7 |
786 | 2023-08-13 10:48:34 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
785 | 2023-07-05 02:11:16 | lily | 1 | 13983 | 10 | 0.483 | 28950.3 |
784 | 2023-05-20 23:37:43 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
783 | 2023-05-01 01:35:44 | lily | 2 | 29872 | 243 | 0.763 | 39150.7 |
782 | 2023-04-01 07:30:00 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
781 | 2023-03-18 17:49:34 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
780 | 2023-02-06 14:51:47 | lily | 2 | 29872 | 243 | 0.860 | 34734.9 |
779 | 2023-01-06 05:31:32 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
778 | 2022-12-27 03:05:52 | lily | 1 | 13983 | 10 | 0.236 | 59250.0 |
777 | 2022-11-19 03:14:48 | lily | 2 | 29872 | 243 | 0.766 | 38997.4 |
776 | 2022-09-30 01:26:49 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
775 | 2022-09-19 09:07:12 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
774 | 2022-09-12 18:55:55 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
773 | 2022-08-23 06:16:55 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
772 | 2022-08-14 14:50:39 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
771 | 2022-08-07 02:13:54 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
770 | 2022-07-30 03:18:14 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
769 | 2022-07-28 21:50:45 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
768 | 2022-07-17 17:36:14 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
767 | 2022-06-23 10:55:40 | lily | 2 | 29872 | 243 | 0.923 | 32364.0 |
766 | 2022-05-27 18:40:16 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
765 | 2022-05-11 03:13:57 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
764 | 2022-04-22 15:09:24 | lily | 1 | 13983 | 10 | 0.390 | 35853.8 |
763 | 2022-02-16 10:39:58 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
762 | 2022-02-04 21:35:47 | lily | 2 | 29872 | 243 | 0.876 | 34100.5 |
761 | 2022-01-27 23:14:12 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
760 | 2021-11-19 02:23:27 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
759 | 2021-11-15 02:17:14 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
758 | 2021-10-06 22:40:24 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
757 | 2021-08-29 02:19:58 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
756 | 2021-08-15 13:39:10 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
755 | 2021-08-13 20:23:24 | lily | 1 | 13983 | 10 | 0.283 | 49409.9 |
754 | 2021-07-22 20:27:37 | lily | 1 | 13983 | 10 | 0.266 | 52567.7 |
753 | 2021-05-14 22:01:34 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
752 | 2021-05-12 10:22:47 | lily | 1 | 13983 | 10 | 0.263 | 53167.3 |
751 | 2021-04-11 05:56:50 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
750 | 2021-03-15 05:34:37 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
749 | 2021-02-12 01:26:04 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
748 | 2020-11-30 06:54:29 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
747 | 2020-11-10 08:26:12 | lily | 1 | 13983 | 10 | 0.236 | 59250.0 |
746 | 2020-10-31 00:27:41 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
745 | 2020-10-22 16:04:10 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
744 | 2020-09-20 20:04:48 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
743 | 2020-08-24 02:46:45 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
742 | 2020-08-10 13:45:58 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
741 | 2020-08-06 17:04:06 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
740 | 2020-08-06 05:29:52 | lily | 1 | 13983 | 10 | 0.233 | 60012.9 |
739 | 2020-08-01 06:56:55 | lily | 1 | 13983 | 10 | 0.216 | 64736.1 |
738 | 2020-07-28 23:42:59 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
737 | 2020-05-09 08:33:27 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
736 | 2020-04-25 14:47:47 | lily | 1 | 13983 | 10 | 0.220 | 63559.1 |
735 | 2020-03-25 16:43:59 | lily | 1 | 13983 | 10 | 0.263 | 53167.3 |
734 | 2020-03-24 10:53:58 | lily | 1 | 13983 | 10 | 0.236 | 59250.0 |
733 | 2020-03-23 10:13:26 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
732 | 2020-03-22 00:41:15 | lily | 1 | 13983 | 10 | 0.250 | 55932.0 |
731 | 2020-03-21 01:01:36 | lily | 1 | 13983 | 10 | 0.266 | 52567.7 |
730 | 2020-03-18 15:17:39 | lily | 1 | 13983 | 10 | 0.436 | 32071.1 |