History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stained"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
833 | 2024-04-27 06:23:14 | stained | 1 | 69583 | 5 | 3.453 | 20151.5 |
832 | 2024-01-24 06:51:11 | stained | 1 | 69583 | 5 | 1.216 | 57222.9 |
831 | 2024-01-09 11:48:54 | stained | 1 | 69583 | 5 | 1.296 | 53690.6 |
830 | 2023-12-28 02:30:02 | stained | 2 | 107671 | 90 | 2.843 | 37872.3 |
829 | 2023-12-23 20:28:47 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
828 | 2023-11-26 20:11:30 | stained | 1 | 69583 | 5 | 1.296 | 53690.6 |
827 | 2023-11-19 23:59:11 | stained | 1 | 69583 | 5 | 1.220 | 57035.2 |
826 | 2023-11-19 02:50:12 | stained | 1 | 69583 | 5 | 1.173 | 59320.5 |
825 | 2023-11-06 08:44:20 | stained | 1 | 69583 | 5 | 1.186 | 58670.3 |
824 | 2023-11-05 21:58:33 | stained | 1 | 69583 | 5 | 1.250 | 55666.4 |
823 | 2023-10-18 15:41:59 | stained | 1 | 69583 | 5 | 1.156 | 60192.9 |
822 | 2023-10-03 18:03:14 | stained | 1 | 69583 | 5 | 1.080 | 64428.7 |
821 | 2023-10-01 05:27:09 | stained | 2 | 107671 | 90 | 2.936 | 36672.7 |
820 | 2023-09-25 23:18:47 | stained | 1 | 69583 | 5 | 1.063 | 65459.1 |
819 | 2023-09-24 16:04:53 | stained | 1 | 69583 | 5 | 1.106 | 62914.1 |
818 | 2023-09-19 15:41:18 | stained | 3 | 134027 | 842 | 7.390 | 18136.3 |
817 | 2023-09-18 17:31:02 | stained | 3 | 134027 | 842 | 6.906 | 19407.3 |
816 | 2023-09-06 04:05:50 | stained | 1 | 69583 | 5 | 1.046 | 66522.9 |
815 | 2023-07-10 20:36:12 | stained | 2 | 107671 | 90 | 3.203 | 33615.7 |
814 | 2023-06-24 08:33:28 | stained | 1 | 69583 | 5 | 1.076 | 64668.2 |
813 | 2023-06-11 05:47:43 | stained | 1 | 69583 | 5 | 1.126 | 61796.6 |
812 | 2023-04-01 05:57:40 | stained | 2 | 107671 | 90 | 2.843 | 37872.3 |
811 | 2023-03-28 06:46:09 | stained | 1 | 69583 | 5 | 1.266 | 54962.9 |
810 | 2023-03-12 03:56:04 | stained | 1 | 69583 | 5 | 1.203 | 57841.2 |
809 | 2023-01-11 15:06:47 | stained | 1 | 69583 | 5 | 1.250 | 55666.4 |
808 | 2022-12-29 00:58:48 | stained | 2 | 107671 | 90 | 3.280 | 32826.5 |
807 | 2022-11-20 13:07:40 | stained | 1 | 69583 | 5 | 1.203 | 57841.2 |
806 | 2022-10-14 15:48:42 | stained | 1 | 69583 | 5 | 1.080 | 64428.7 |
805 | 2022-08-31 15:29:30 | stained | 2 | 107671 | 90 | 3.313 | 32499.5 |
804 | 2022-07-20 10:54:01 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
803 | 2022-07-16 17:42:16 | stained | 1 | 69583 | 5 | 1.080 | 64428.7 |
802 | 2022-06-04 19:07:20 | stained | 1 | 69583 | 5 | 1.080 | 64428.7 |
801 | 2022-03-19 11:20:32 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
800 | 2022-03-16 00:39:49 | stained | 1 | 69583 | 5 | 1.143 | 60877.5 |
799 | 2022-02-16 19:48:43 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
798 | 2021-12-04 00:46:23 | stained | 1 | 69583 | 5 | 1.203 | 57841.2 |
797 | 2021-12-02 08:35:26 | stained | 1 | 69583 | 5 | 1.106 | 62914.1 |
796 | 2021-12-01 23:37:40 | stained | 1 | 69583 | 5 | 1.126 | 61796.6 |
795 | 2021-10-11 09:39:21 | stained | 1 | 69583 | 5 | 1.250 | 55666.4 |
794 | 2021-09-29 04:53:36 | stained | 1 | 69583 | 5 | 1.096 | 63488.1 |
793 | 2021-09-24 13:07:49 | stained | 1 | 69583 | 5 | 1.233 | 56433.9 |
792 | 2021-09-20 06:55:07 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
791 | 2021-08-25 23:34:02 | stained | 1 | 69583 | 5 | 1.076 | 64668.2 |
790 | 2021-05-25 09:01:20 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
789 | 2021-05-25 04:00:31 | stained | 1 | 69583 | 5 | 1.236 | 56296.9 |
788 | 2021-05-02 23:58:29 | stained | 1 | 69583 | 5 | 1.296 | 53690.6 |
787 | 2021-04-28 22:22:43 | stained | 1 | 69583 | 5 | 1.096 | 63488.1 |
786 | 2021-03-28 14:38:24 | stained | 1 | 69583 | 5 | 1.110 | 62687.4 |
785 | 2021-02-19 15:11:43 | stained | 1 | 69583 | 5 | 1.250 | 55666.4 |
784 | 2021-02-19 14:43:36 | stained | 1 | 69583 | 5 | 1.110 | 62687.4 |
783 | 2021-01-29 11:23:10 | stained | 1 | 69583 | 5 | 1.126 | 61796.6 |
782 | 2021-01-12 00:16:24 | stained | 1 | 69583 | 5 | 1.220 | 57035.2 |
781 | 2021-01-03 03:54:41 | stained | 3 | 134027 | 842 | 6.233 | 21502.8 |
780 | 2020-11-15 23:27:08 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
779 | 2020-11-11 12:53:08 | stained | 3 | 134027 | 842 | 6.186 | 21666.2 |
778 | 2020-10-29 14:28:43 | stained | 1 | 69583 | 5 | 1.236 | 56296.9 |
777 | 2020-10-22 13:13:39 | stained | 1 | 69583 | 5 | 1.250 | 55666.4 |
776 | 2020-09-29 22:31:43 | stained | 1 | 69583 | 5 | 1.076 | 64668.2 |
775 | 2020-09-07 06:12:44 | stained | 1 | 69583 | 5 | 1.076 | 64668.2 |
774 | 2020-08-10 21:50:30 | stained | 1 | 69583 | 5 | 1.110 | 62687.4 |
773 | 2020-08-08 00:02:58 | stained | 1 | 69583 | 5 | 1.076 | 64668.2 |
772 | 2020-07-29 12:30:44 | stained | 1 | 69583 | 5 | 1.156 | 60192.9 |
771 | 2020-07-23 22:42:50 | stained | 1 | 69583 | 5 | 1.106 | 62914.1 |
770 | 2020-05-06 15:15:35 | stained | 1 | 69583 | 5 | 1.110 | 62687.4 |
769 | 2020-05-02 03:53:33 | stained | 1 | 69583 | 5 | 1.140 | 61037.7 |
768 | 2020-03-28 18:47:05 | stained | 1 | 69583 | 5 | 1.296 | 53690.6 |
767 | 2020-03-27 03:32:08 | stained | 3 | 134027 | 842 | 9.563 | 14015.2 |
766 | 2020-03-27 00:58:03 | stained | 3 | 134027 | 842 | 13.626 | 9836.1 |
765 | 2020-03-26 23:03:55 | stained | 3 | 134027 | 842 | 6.750 | 19855.9 |
764 | 2020-03-26 11:02:12 | stained | 1 | 69583 | 5 | 1.173 | 59320.5 |
763 | 2020-03-26 02:07:46 | stained | 3 | 134027 | 842 | 10.576 | 12672.7 |
762 | 2020-03-24 05:47:24 | stained | 1 | 69583 | 5 | 1.263 | 55093.4 |
761 | 2020-03-20 11:56:23 | stained | 1 | 69583 | 5 | 1.360 | 51164.0 |
760 | 2020-03-05 23:07:28 | stained | 3 | 134027 | 842 | 6.736 | 19897.1 |
759 | 2020-02-26 08:00:10 | stained | 1 | 69583 | 5 | 1.093 | 63662.4 |
758 | 2020-02-20 00:32:07 | stained | 1 | 69583 | 5 | 1.283 | 54234.6 |
757 | 2020-02-19 18:16:32 | stained | 3 | 134027 | 842 | 8.250 | 16245.7 |
756 | 2020-02-19 08:28:53 | stained | 3 | 134027 | 842 | 12.736 | 10523.5 |
755 | 2020-02-18 12:21:32 | stained | 3 | 134027 | 842 | 7.503 | 17863.1 |
754 | 2020-02-14 12:42:37 | stained | 1 | 69583 | 5 | 1.796 | 38743.3 |
753 | 2020-02-11 02:47:14 | stained | 1 | 69583 | 5 | 1.606 | 43326.9 |
752 | 2020-02-10 17:17:27 | stained | 1 | 69583 | 5 | 1.330 | 52318.0 |
751 | 2020-02-04 04:33:54 | stained | 1 | 69583 | 5 | 1.080 | 64428.7 |
750 | 2020-02-03 15:47:49 | stained | 1 | 69583 | 5 | 1.280 | 54361.7 |
749 | 2020-02-02 02:34:05 | stained | 1 | 69583 | 5 | 4.110 | 16930.2 |
748 | 2020-02-01 05:59:38 | stained | 1 | 69583 | 5 | 1.313 | 52995.4 |
747 | 2020-01-27 17:42:26 | stained | 1 | 69583 | 5 | 1.423 | 48898.8 |
746 | 2020-01-24 16:29:07 | stained | 3 | 134027 | 842 | 8.283 | 16181.0 |
745 | 2020-01-24 11:30:12 | stained | 1 | 69583 | 5 | 3.050 | 22814.1 |
744 | 2020-01-24 10:51:23 | stained | 3 | 134027 | 842 | 16.643 | 8053.1 |
743 | 2020-01-24 10:17:28 | stained | 3 | 134027 | 842 | 9.343 | 14345.2 |
742 | 2020-01-24 07:21:12 | stained | 3 | 134027 | 842 | 14.483 | 9254.1 |
741 | 2020-01-24 07:13:31 | stained | 3 | 134027 | 842 | 16.203 | 8271.7 |
740 | 2020-01-24 07:04:31 | stained | 3 | 134027 | 842 | 11.716 | 11439.7 |
739 | 2020-01-24 03:48:41 | stained | 3 | 134027 | 842 | 20.296 | 6603.6 |
738 | 2020-01-16 16:15:18 | stained | 1 | 69583 | 5 | 2.720 | 25582.0 |
737 | 2020-01-14 15:53:32 | stained | 1 | 69583 | 5 | 2.860 | 24329.7 |
736 | 2020-01-12 15:54:42 | stained | 1 | 69583 | 5 | 1.360 | 51164.0 |
735 | 2020-01-07 22:28:54 | stained | 1 | 69583 | 5 | 1.373 | 50679.5 |
734 | 2019-12-27 16:25:32 | stained | 1 | 69583 | 5 | 1.170 | 59472.6 |