History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"artists"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
819 | 2024-04-27 11:51:01 | artists | 1 | 69583 | 5 | 4.903 | 14191.9 |
818 | 2024-04-03 14:24:15 | artists | 1 | 69583 | 5 | 1.343 | 51811.6 |
817 | 2024-03-28 06:42:25 | artists | 1 | 69583 | 5 | 1.436 | 48456.1 |
816 | 2024-03-08 19:00:20 | artists | 3 | 134027 | 398 | 27.813 | 4818.9 |
815 | 2024-03-08 00:48:07 | artists | 3 | 134027 | 398 | 14.500 | 9243.2 |
814 | 2024-03-07 22:34:46 | artists | 2 | 107671 | 37 | 7.953 | 13538.4 |
813 | 2024-03-07 19:06:45 | artists | 3 | 134027 | 398 | 8.016 | 16719.9 |
812 | 2024-03-07 03:33:48 | artists | 3 | 134027 | 398 | 23.283 | 5756.4 |
811 | 2024-03-06 14:27:44 | artists | 3 | 134027 | 398 | 7.406 | 18097.1 |
810 | 2024-03-06 13:37:22 | artists | 2 | 107671 | 37 | 15.500 | 6946.5 |
809 | 2024-03-06 13:37:18 | artists | 3 | 134027 | 398 | 16.720 | 8016.0 |
808 | 2024-03-06 13:36:51 | artists | 1 | 69583 | 5 | 4.220 | 16488.9 |
807 | 2024-03-06 13:35:42 | artists | 2 | 107671 | 37 | 8.233 | 13078.0 |
806 | 2024-03-05 14:47:12 | artists | 2 | 107671 | 37 | 3.406 | 31612.2 |
805 | 2024-01-15 12:25:29 | artists | 1 | 69583 | 5 | 1.263 | 55093.4 |
804 | 2024-01-08 17:49:38 | artists | 3 | 134027 | 398 | 6.296 | 21287.6 |
803 | 2024-01-01 12:52:02 | artists | 1 | 69583 | 5 | 2.516 | 27656.2 |
802 | 2023-12-30 13:07:13 | artists | 3 | 134027 | 398 | 6.953 | 19276.1 |
801 | 2023-12-30 13:07:11 | artists | 2 | 107671 | 37 | 3.376 | 31893.1 |
800 | 2023-12-06 13:22:10 | artists | 1 | 69583 | 5 | 1.236 | 56296.9 |
799 | 2023-11-24 22:27:43 | artists | 2 | 107671 | 37 | 2.860 | 37647.2 |
798 | 2023-11-20 00:11:27 | artists | 1 | 69583 | 5 | 1.266 | 54962.9 |
797 | 2023-11-11 06:25:20 | artists | 1 | 69583 | 5 | 1.170 | 59472.6 |
796 | 2023-10-30 16:28:28 | artists | 1 | 69583 | 5 | 1.236 | 56296.9 |
795 | 2023-10-20 05:20:32 | artists | 1 | 69583 | 5 | 1.220 | 57035.2 |
794 | 2023-10-17 23:01:56 | artists | 1 | 69583 | 5 | 1.266 | 54962.9 |
793 | 2023-10-14 21:38:00 | artists | 3 | 134027 | 398 | 6.720 | 19944.5 |
792 | 2023-09-26 07:21:11 | artists | 1 | 69583 | 5 | 1.233 | 56433.9 |
791 | 2023-09-23 15:15:07 | artists | 1 | 69583 | 5 | 1.156 | 60192.9 |
790 | 2023-09-19 14:42:59 | artists | 1 | 69583 | 5 | 1.126 | 61796.6 |
789 | 2023-08-31 12:15:17 | artists | 1 | 69583 | 5 | 1.220 | 57035.2 |
788 | 2023-08-24 17:53:14 | artists | 2 | 107671 | 37 | 3.420 | 31482.7 |
787 | 2023-07-25 04:16:19 | artists | 3 | 134027 | 398 | 5.860 | 22871.5 |
786 | 2023-06-08 23:36:56 | artists | 1 | 69583 | 5 | 1.076 | 64668.2 |
785 | 2023-06-05 17:31:15 | artists | 1 | 69583 | 5 | 1.080 | 64428.7 |
784 | 2023-06-03 22:08:30 | artists | 1 | 69583 | 5 | 1.060 | 65644.3 |
783 | 2023-05-09 19:08:00 | artists | 2 | 107671 | 37 | 2.860 | 37647.2 |
782 | 2023-04-21 01:36:00 | artists | 1 | 69583 | 5 | 1.093 | 63662.4 |
781 | 2023-04-05 04:52:27 | artists | 3 | 134027 | 398 | 6.360 | 21073.4 |
780 | 2023-03-27 05:57:54 | artists | 1 | 69583 | 5 | 1.076 | 64668.2 |
779 | 2023-03-03 06:25:46 | artists | 1 | 69583 | 5 | 1.096 | 63488.1 |
778 | 2023-02-15 17:51:48 | artists | 2 | 107671 | 37 | 3.190 | 33752.7 |
777 | 2023-02-04 19:55:16 | artists | 3 | 134027 | 398 | 6.106 | 21950.0 |
776 | 2023-01-11 02:47:00 | artists | 1 | 69583 | 5 | 2.033 | 34226.8 |
775 | 2023-01-03 12:37:29 | artists | 3 | 134027 | 398 | 5.893 | 22743.4 |
774 | 2022-12-19 18:06:21 | artists | 3 | 134027 | 398 | 6.096 | 21986.1 |
773 | 2022-12-19 16:55:45 | artists | 3 | 134027 | 398 | 6.030 | 22226.7 |
772 | 2022-12-10 00:47:56 | artists | 3 | 134027 | 398 | 6.063 | 22105.7 |
771 | 2022-11-28 22:53:45 | artists | 2 | 107671 | 37 | 2.876 | 37437.8 |
770 | 2022-11-21 15:28:37 | artists | 1 | 69583 | 5 | 1.186 | 58670.3 |
769 | 2022-11-14 13:33:01 | artists | 3 | 134027 | 398 | 5.970 | 22450.1 |
768 | 2022-11-02 09:54:51 | artists | 3 | 134027 | 398 | 7.766 | 17258.2 |
767 | 2022-10-26 04:57:29 | artists | 3 | 134027 | 398 | 5.983 | 22401.3 |
766 | 2022-10-14 19:45:59 | artists | 1 | 69583 | 5 | 1.106 | 62914.1 |
765 | 2022-10-01 13:30:34 | artists | 3 | 134027 | 398 | 7.203 | 18607.1 |
764 | 2022-09-07 09:15:49 | artists | 3 | 134027 | 398 | 6.046 | 22167.9 |
763 | 2022-08-17 16:19:29 | artists | 1 | 69583 | 5 | 1.220 | 57035.2 |
762 | 2022-07-04 12:22:58 | artists | 2 | 107671 | 37 | 2.906 | 37051.3 |
761 | 2022-06-02 14:05:04 | artists | 1 | 69583 | 5 | 1.076 | 64668.2 |
760 | 2022-05-31 08:11:20 | artists | 1 | 69583 | 5 | 1.093 | 63662.4 |
759 | 2022-05-16 04:39:17 | artists | 1 | 69583 | 5 | 1.076 | 64668.2 |
758 | 2022-05-08 19:14:37 | artists | 1 | 69583 | 5 | 1.093 | 63662.4 |
757 | 2022-02-08 04:25:40 | artists | 1 | 69583 | 5 | 1.203 | 57841.2 |
756 | 2022-02-06 00:54:18 | artists | 1 | 69583 | 5 | 1.220 | 57035.2 |
755 | 2022-02-03 20:11:31 | artists | 1 | 69583 | 5 | 1.076 | 64668.2 |
754 | 2021-11-29 20:52:59 | artists | 1 | 69583 | 5 | 1.250 | 55666.4 |
753 | 2021-11-26 11:42:17 | artists | 1 | 69583 | 5 | 1.376 | 50569.0 |
752 | 2021-11-03 03:20:39 | artists | 1 | 69583 | 5 | 1.093 | 63662.4 |
751 | 2021-10-13 11:34:00 | artists | 1 | 69583 | 5 | 1.250 | 55666.4 |
750 | 2021-09-22 10:50:44 | artists | 1 | 69583 | 5 | 1.313 | 52995.4 |
749 | 2021-08-12 12:19:48 | artists | 1 | 69583 | 5 | 1.250 | 55666.4 |
748 | 2021-08-03 08:38:33 | artists | 1 | 69583 | 5 | 1.063 | 65459.1 |
747 | 2021-07-24 05:00:39 | artists | 1 | 69583 | 5 | 1.080 | 64428.7 |
746 | 2021-05-14 06:14:59 | artists | 1 | 69583 | 5 | 1.296 | 53690.6 |
745 | 2021-05-01 17:09:11 | artists | 1 | 69583 | 5 | 1.310 | 53116.8 |
744 | 2021-04-25 14:03:12 | artists | 1 | 69583 | 5 | 1.110 | 62687.4 |
743 | 2021-04-13 06:06:59 | artists | 1 | 69583 | 5 | 1.123 | 61961.7 |
742 | 2021-03-17 00:48:19 | artists | 1 | 69583 | 5 | 1.093 | 63662.4 |
741 | 2021-02-16 00:47:14 | artists | 1 | 69583 | 5 | 1.076 | 64668.2 |
740 | 2021-01-24 13:30:27 | artists | 1 | 69583 | 5 | 1.110 | 62687.4 |
739 | 2020-12-29 04:06:39 | artists | 1 | 69583 | 5 | 1.216 | 57222.9 |
738 | 2020-12-09 08:41:24 | artists | 3 | 134027 | 398 | 6.063 | 22105.7 |
737 | 2020-12-09 08:41:20 | artists | 2 | 107671 | 37 | 3.030 | 35535.0 |
736 | 2020-12-09 08:41:18 | artists | 1 | 69583 | 5 | 1.343 | 51811.6 |
735 | 2020-12-01 14:42:21 | artists | 1 | 69583 | 5 | 1.110 | 62687.4 |
734 | 2020-11-02 16:16:22 | artists | 1 | 69583 | 5 | 1.170 | 59472.6 |
733 | 2020-10-23 00:32:41 | artists | 1 | 69583 | 5 | 1.093 | 63662.4 |
732 | 2020-10-21 12:42:18 | artists | 1 | 69583 | 5 | 1.080 | 64428.7 |
731 | 2020-09-17 01:28:44 | artists | 1 | 69583 | 5 | 1.236 | 56296.9 |
730 | 2020-08-30 22:27:14 | artists | 1 | 69583 | 5 | 1.123 | 61961.7 |
729 | 2020-08-25 08:04:22 | artists | 1 | 69583 | 5 | 1.173 | 59320.5 |
728 | 2020-07-21 08:03:37 | artists | 1 | 69583 | 5 | 1.313 | 52995.4 |
727 | 2020-07-20 14:08:07 | artists | 1 | 69583 | 5 | 1.170 | 59472.6 |
726 | 2020-07-16 05:36:27 | artists | 1 | 69583 | 5 | 1.250 | 55666.4 |
725 | 2020-04-18 15:19:05 | artists | 1 | 69583 | 5 | 1.326 | 52475.9 |
724 | 2020-04-08 18:50:22 | artists | 1 | 69583 | 5 | 1.110 | 62687.4 |
723 | 2020-04-08 17:35:35 | artists | 1 | 69583 | 5 | 1.093 | 63662.4 |
722 | 2020-03-28 15:42:08 | artists | 1 | 69583 | 5 | 2.626 | 26497.7 |
721 | 2020-03-24 12:39:24 | artists | 1 | 69583 | 5 | 1.313 | 52995.4 |
720 | 2020-03-23 00:01:57 | artists | 1 | 69583 | 5 | 1.283 | 54234.6 |