History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tickers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
813 | 2024-04-30 19:09:26 | tickers | 1 | 69583 | 17 | 1.310 | 53116.8 |
812 | 2024-04-29 09:41:23 | tickers | 1 | 69583 | 17 | 1.203 | 57841.2 |
811 | 2024-04-17 04:58:39 | tickers | 1 | 69583 | 17 | 1.156 | 60192.9 |
810 | 2024-03-17 19:57:08 | tickers | 2 | 107671 | 135 | 9.750 | 11043.2 |
809 | 2024-03-16 22:54:15 | tickers | 1 | 69583 | 17 | 1.250 | 55666.4 |
808 | 2024-03-16 22:54:02 | tickers | 2 | 107671 | 135 | 6.456 | 16677.7 |
807 | 2024-03-15 20:48:06 | tickers | 2 | 107671 | 135 | 3.500 | 30763.1 |
806 | 2024-02-18 00:48:01 | tickers | 1 | 69583 | 17 | 1.343 | 51811.6 |
805 | 2024-01-21 08:55:57 | tickers | 2 | 107671 | 135 | 3.236 | 33272.9 |
804 | 2024-01-16 03:25:04 | tickers | 2 | 107671 | 135 | 2.830 | 38046.3 |
803 | 2024-01-03 01:00:30 | tickers | 1 | 69583 | 17 | 1.126 | 61796.6 |
802 | 2023-12-31 21:55:06 | tickers | 1 | 69583 | 17 | 1.093 | 63662.4 |
801 | 2023-12-07 17:58:46 | tickers | 1 | 69583 | 17 | 1.250 | 55666.4 |
800 | 2023-12-07 17:58:44 | tickers | 1 | 69583 | 17 | 1.263 | 55093.4 |
799 | 2023-12-02 06:39:53 | tickers | 1 | 69583 | 17 | 1.220 | 57035.2 |
798 | 2023-11-30 19:39:45 | tickers | 2 | 107671 | 135 | 2.796 | 38508.9 |
797 | 2023-11-24 02:39:15 | tickers | 1 | 69583 | 17 | 1.080 | 64428.7 |
796 | 2023-11-18 09:03:54 | tickers | 1 | 69583 | 17 | 1.046 | 66522.9 |
795 | 2023-11-18 04:48:21 | tickers | 1 | 69583 | 17 | 1.203 | 57841.2 |
794 | 2023-11-17 13:20:13 | tickers | 1 | 69583 | 17 | 1.080 | 64428.7 |
793 | 2023-11-15 23:52:56 | tickers | 1 | 69583 | 17 | 1.093 | 63662.4 |
792 | 2023-11-11 17:12:17 | tickers | 1 | 69583 | 17 | 1.110 | 62687.4 |
791 | 2023-11-11 01:44:02 | tickers | 1 | 69583 | 17 | 1.236 | 56296.9 |
790 | 2023-10-23 12:52:09 | tickers | 1 | 69583 | 17 | 1.156 | 60192.9 |
789 | 2023-09-12 00:33:25 | tickers | 1 | 69583 | 17 | 1.203 | 57841.2 |
788 | 2023-08-29 22:33:36 | tickers | 2 | 107671 | 135 | 2.826 | 38100.1 |
787 | 2023-08-19 00:00:10 | tickers | 1 | 69583 | 17 | 1.220 | 57035.2 |
786 | 2023-07-18 05:05:01 | tickers | 1 | 69583 | 17 | 1.076 | 64668.2 |
785 | 2023-05-18 04:00:10 | tickers | 1 | 69583 | 17 | 1.030 | 67556.3 |
784 | 2023-05-15 04:29:06 | tickers | 2 | 107671 | 135 | 3.216 | 33479.8 |
783 | 2023-03-26 14:08:38 | tickers | 1 | 69583 | 17 | 1.110 | 62687.4 |
782 | 2023-03-12 09:37:58 | tickers | 1 | 69583 | 17 | 1.063 | 65459.1 |
781 | 2023-02-21 08:16:39 | tickers | 2 | 107671 | 135 | 2.783 | 38688.8 |
780 | 2023-01-01 01:47:32 | tickers | 1 | 69583 | 17 | 1.140 | 61037.7 |
779 | 2022-12-03 06:17:36 | tickers | 2 | 107671 | 135 | 3.983 | 27032.6 |
778 | 2022-12-01 16:32:45 | tickers | 1 | 69583 | 17 | 1.050 | 66269.5 |
777 | 2022-11-28 09:33:44 | tickers | 1 | 69583 | 17 | 1.076 | 64668.2 |
776 | 2022-09-20 22:21:57 | tickers | 1 | 69583 | 17 | 1.063 | 65459.1 |
775 | 2022-09-01 06:23:53 | tickers | 1 | 69583 | 17 | 1.250 | 55666.4 |
774 | 2022-08-15 03:50:42 | tickers | 1 | 69583 | 17 | 1.076 | 64668.2 |
773 | 2022-08-04 20:13:30 | tickers | 1 | 69583 | 17 | 1.096 | 63488.1 |
772 | 2022-07-29 11:16:13 | tickers | 1 | 69583 | 17 | 1.123 | 61961.7 |
771 | 2022-06-29 04:22:12 | tickers | 1 | 69583 | 17 | 1.080 | 64428.7 |
770 | 2022-06-28 22:25:38 | tickers | 1 | 69583 | 17 | 1.046 | 66522.9 |
769 | 2022-06-28 03:21:33 | tickers | 1 | 69583 | 17 | 1.250 | 55666.4 |
768 | 2022-06-27 05:28:27 | tickers | 1 | 69583 | 17 | 1.190 | 58473.1 |
767 | 2022-06-26 10:01:05 | tickers | 1 | 69583 | 17 | 1.126 | 61796.6 |
766 | 2022-06-25 03:06:56 | tickers | 1 | 69583 | 17 | 1.186 | 58670.3 |
765 | 2022-06-24 05:48:50 | tickers | 1 | 69583 | 17 | 1.046 | 66522.9 |
764 | 2022-06-23 03:02:11 | tickers | 1 | 69583 | 17 | 1.106 | 62914.1 |
763 | 2022-06-22 02:37:28 | tickers | 1 | 69583 | 17 | 2.860 | 24329.7 |
762 | 2022-06-21 07:43:13 | tickers | 1 | 69583 | 17 | 1.280 | 54361.7 |
761 | 2022-06-20 19:25:29 | tickers | 1 | 69583 | 17 | 1.156 | 60192.9 |
760 | 2022-06-20 13:53:31 | tickers | 1 | 69583 | 17 | 1.063 | 65459.1 |
759 | 2022-06-19 05:26:44 | tickers | 1 | 69583 | 17 | 1.063 | 65459.1 |
758 | 2022-06-18 06:28:00 | tickers | 1 | 69583 | 17 | 1.686 | 41271.1 |
757 | 2022-06-17 09:38:55 | tickers | 1 | 69583 | 17 | 1.080 | 64428.7 |
756 | 2022-06-16 17:53:05 | tickers | 1 | 69583 | 17 | 1.076 | 64668.2 |
755 | 2022-06-15 13:16:56 | tickers | 1 | 69583 | 17 | 1.206 | 57697.3 |
754 | 2022-06-13 18:23:19 | tickers | 1 | 69583 | 17 | 1.080 | 64428.7 |
753 | 2022-04-27 21:34:26 | tickers | 1 | 69583 | 17 | 1.326 | 52475.9 |
752 | 2022-04-26 18:28:59 | tickers | 1 | 69583 | 17 | 1.156 | 60192.9 |
751 | 2022-04-25 20:28:01 | tickers | 1 | 69583 | 17 | 1.170 | 59472.6 |
750 | 2022-04-23 20:32:09 | tickers | 1 | 69583 | 17 | 1.190 | 58473.1 |
749 | 2022-04-22 21:45:17 | tickers | 1 | 69583 | 17 | 1.843 | 37755.3 |
748 | 2022-04-21 21:22:15 | tickers | 1 | 69583 | 17 | 1.203 | 57841.2 |
747 | 2022-04-20 20:59:19 | tickers | 1 | 69583 | 17 | 1.313 | 52995.4 |
746 | 2022-04-19 21:09:35 | tickers | 1 | 69583 | 17 | 1.170 | 59472.6 |
745 | 2022-04-16 22:37:56 | tickers | 1 | 69583 | 17 | 1.046 | 66522.9 |
744 | 2022-04-15 18:36:23 | tickers | 1 | 69583 | 17 | 1.186 | 58670.3 |
743 | 2022-04-14 17:29:41 | tickers | 1 | 69583 | 17 | 1.190 | 58473.1 |
742 | 2022-04-11 17:18:27 | tickers | 2 | 107671 | 135 | 3.373 | 31921.4 |
741 | 2022-04-10 06:42:24 | tickers | 1 | 69583 | 17 | 1.170 | 59472.6 |
740 | 2022-03-11 10:18:54 | tickers | 1 | 69583 | 17 | 1.156 | 60192.9 |
739 | 2022-03-10 20:09:01 | tickers | 1 | 69583 | 17 | 1.220 | 57035.2 |
738 | 2022-03-09 18:43:27 | tickers | 1 | 69583 | 17 | 1.156 | 60192.9 |
737 | 2022-03-08 14:44:37 | tickers | 1 | 69583 | 17 | 1.376 | 50569.0 |
736 | 2022-03-07 18:34:30 | tickers | 1 | 69583 | 17 | 1.170 | 59472.6 |
735 | 2022-03-06 17:15:36 | tickers | 1 | 69583 | 17 | 1.093 | 63662.4 |
734 | 2022-03-06 00:46:21 | tickers | 1 | 69583 | 17 | 1.076 | 64668.2 |
733 | 2022-03-05 16:54:01 | tickers | 1 | 69583 | 17 | 1.060 | 65644.3 |
732 | 2022-03-04 16:55:48 | tickers | 1 | 69583 | 17 | 1.063 | 65459.1 |
731 | 2022-03-03 10:32:44 | tickers | 1 | 69583 | 17 | 1.280 | 54361.7 |
730 | 2022-03-02 20:46:07 | tickers | 1 | 69583 | 17 | 1.110 | 62687.4 |
729 | 2022-02-25 22:08:37 | tickers | 1 | 69583 | 17 | 1.296 | 53690.6 |
728 | 2022-01-06 11:24:41 | tickers | 1 | 69583 | 17 | 1.203 | 57841.2 |
727 | 2022-01-05 19:10:06 | tickers | 1 | 69583 | 17 | 1.236 | 56296.9 |
726 | 2022-01-05 09:44:19 | tickers | 1 | 69583 | 17 | 1.203 | 57841.2 |
725 | 2022-01-04 18:08:28 | tickers | 1 | 69583 | 17 | 1.076 | 64668.2 |
724 | 2022-01-03 20:11:25 | tickers | 1 | 69583 | 17 | 1.220 | 57035.2 |
723 | 2021-12-25 22:39:05 | tickers | 1 | 69583 | 17 | 1.080 | 64428.7 |
722 | 2021-12-24 23:07:22 | tickers | 1 | 69583 | 17 | 1.280 | 54361.7 |
721 | 2021-12-23 22:21:47 | tickers | 1 | 69583 | 17 | 1.203 | 57841.2 |
720 | 2021-12-22 21:22:16 | tickers | 1 | 69583 | 17 | 1.250 | 55666.4 |
719 | 2021-12-21 22:14:24 | tickers | 1 | 69583 | 17 | 1.156 | 60192.9 |
718 | 2021-12-20 20:17:32 | tickers | 1 | 69583 | 17 | 1.216 | 57222.9 |
717 | 2021-12-20 16:59:27 | tickers | 1 | 69583 | 17 | 1.186 | 58670.3 |
716 | 2021-12-19 17:02:05 | tickers | 1 | 69583 | 17 | 1.283 | 54234.6 |
715 | 2021-12-18 15:01:22 | tickers | 1 | 69583 | 17 | 1.233 | 56433.9 |
714 | 2021-12-17 05:10:53 | tickers | 1 | 69583 | 17 | 1.126 | 61796.6 |