History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opener"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
839 | 2024-04-25 20:02:32 | opener | 2 | 82551 | 28 | 3.513 | 23498.7 |
838 | 2024-04-25 20:00:12 | opener | 1 | 48755 | 3 | 0.876 | 55656.4 |
837 | 2024-04-25 19:59:48 | opener | 3 | 112716 | 640 | 6.626 | 17011.2 |
836 | 2024-04-25 07:41:26 | opener | 3 | 112716 | 640 | 11.436 | 9856.2 |
835 | 2024-04-21 05:41:04 | opener | 1 | 48755 | 3 | 1.860 | 26212.4 |
834 | 2024-04-13 05:30:53 | opener | 1 | 48755 | 3 | 0.830 | 58741.0 |
833 | 2024-03-31 22:20:36 | opener | 3 | 112716 | 640 | 17.563 | 6417.8 |
832 | 2024-03-31 18:25:25 | opener | 1 | 48755 | 3 | 0.953 | 51159.5 |
831 | 2024-03-29 19:06:55 | opener | 3 | 112716 | 640 | 12.610 | 8938.6 |
830 | 2024-03-29 10:11:39 | opener | 2 | 82551 | 28 | 2.876 | 28703.4 |
829 | 2024-03-29 09:53:43 | opener | 2 | 82551 | 28 | 2.406 | 34310.5 |
828 | 2024-03-29 09:53:18 | opener | 3 | 112716 | 640 | 6.686 | 16858.5 |
827 | 2024-03-28 14:43:13 | opener | 1 | 48755 | 3 | 0.826 | 59025.4 |
826 | 2024-03-26 18:16:09 | opener | 2 | 82551 | 28 | 2.140 | 38575.2 |
825 | 2024-03-26 18:12:10 | opener | 1 | 48755 | 3 | 0.876 | 55656.4 |
824 | 2024-03-26 18:11:45 | opener | 3 | 112716 | 640 | 5.656 | 19928.6 |
823 | 2024-03-20 21:04:43 | opener | 3 | 112716 | 640 | 11.563 | 9748.0 |
822 | 2024-03-04 08:03:47 | opener | 3 | 112716 | 640 | 11.280 | 9992.6 |
821 | 2024-02-28 05:01:03 | opener | 3 | 112716 | 640 | 8.406 | 13409.0 |
820 | 2024-02-28 05:01:06 | opener | 2 | 82551 | 28 | 2.876 | 28703.4 |
819 | 2024-02-28 04:21:42 | opener | 1 | 48755 | 3 | 1.360 | 35849.3 |
818 | 2024-02-28 04:20:54 | opener | 2 | 82551 | 28 | 5.716 | 14442.1 |
817 | 2024-02-28 04:20:27 | opener | 3 | 112716 | 640 | 6.703 | 16815.8 |
816 | 2024-02-28 04:16:09 | opener | 2 | 82551 | 28 | 5.280 | 15634.7 |
815 | 2024-02-28 04:16:07 | opener | 3 | 112716 | 640 | 6.233 | 18083.7 |
814 | 2024-02-21 20:58:01 | opener | 1 | 48755 | 3 | 0.796 | 61250.0 |
813 | 2024-01-30 17:46:01 | opener | 1 | 48755 | 3 | 0.890 | 54780.9 |
812 | 2024-01-18 17:10:08 | opener | 2 | 82551 | 28 | 2.186 | 37763.5 |
811 | 2024-01-16 23:09:38 | opener | 2 | 82551 | 28 | 2.126 | 38829.3 |
810 | 2024-01-08 05:26:22 | opener | 1 | 48755 | 3 | 0.830 | 58741.0 |
809 | 2024-01-03 17:34:54 | opener | 3 | 112716 | 640 | 5.970 | 18880.4 |
808 | 2024-01-02 23:57:51 | opener | 3 | 112716 | 640 | 5.983 | 18839.4 |
807 | 2024-01-01 04:18:59 | opener | 3 | 112716 | 640 | 5.453 | 20670.5 |
806 | 2023-12-24 18:49:23 | opener | 1 | 48755 | 3 | 0.873 | 55847.7 |
805 | 2023-12-07 14:32:22 | opener | 1 | 48755 | 3 | 0.733 | 66514.3 |
804 | 2023-12-07 14:32:20 | opener | 1 | 48755 | 3 | 0.830 | 58741.0 |
803 | 2023-11-21 21:38:50 | opener | 1 | 48755 | 3 | 0.843 | 57835.1 |
802 | 2023-11-17 01:50:45 | opener | 1 | 48755 | 3 | 0.783 | 62266.9 |
801 | 2023-11-17 00:19:36 | opener | 1 | 48755 | 3 | 0.923 | 52822.3 |
800 | 2023-11-14 11:26:20 | opener | 3 | 112716 | 640 | 4.623 | 24381.6 |
799 | 2023-10-30 09:26:01 | opener | 1 | 48755 | 3 | 0.830 | 58741.0 |
798 | 2023-10-25 22:04:16 | opener | 1 | 48755 | 3 | 0.750 | 65006.7 |
797 | 2023-10-23 09:16:57 | opener | 1 | 48755 | 3 | 0.860 | 56691.9 |
796 | 2023-10-17 10:03:23 | opener | 3 | 112716 | 640 | 6.453 | 17467.2 |
795 | 2023-10-15 09:47:45 | opener | 3 | 112716 | 640 | 5.300 | 21267.2 |
794 | 2023-10-11 14:17:14 | opener | 1 | 48755 | 3 | 0.766 | 63648.8 |
793 | 2023-10-08 17:52:12 | opener | 1 | 48755 | 3 | 0.736 | 66243.2 |
792 | 2023-09-26 02:12:21 | opener | 1 | 48755 | 3 | 0.736 | 66243.2 |
791 | 2023-09-16 09:06:33 | opener | 1 | 48755 | 3 | 0.810 | 60191.4 |
790 | 2023-08-26 21:33:42 | opener | 3 | 112716 | 640 | 5.076 | 22205.7 |
789 | 2023-08-23 03:39:56 | opener | 1 | 48755 | 3 | 0.750 | 65006.7 |
788 | 2023-08-18 21:57:59 | opener | 1 | 48755 | 3 | 0.843 | 57835.1 |
787 | 2023-07-04 07:45:07 | opener | 3 | 112716 | 640 | 4.656 | 24208.8 |
786 | 2023-07-03 10:41:14 | opener | 3 | 112716 | 640 | 4.533 | 24865.7 |
785 | 2023-07-02 07:04:37 | opener | 3 | 112716 | 640 | 5.263 | 21416.7 |
784 | 2023-07-01 06:07:09 | opener | 3 | 112716 | 640 | 5.140 | 21929.2 |
783 | 2023-06-30 07:10:00 | opener | 3 | 112716 | 640 | 4.720 | 23880.5 |
782 | 2023-06-29 11:36:55 | opener | 3 | 112716 | 640 | 5.156 | 21861.1 |
781 | 2023-06-28 12:33:09 | opener | 3 | 112716 | 640 | 4.690 | 24033.3 |
780 | 2023-06-27 07:40:12 | opener | 3 | 112716 | 640 | 5.233 | 21539.5 |
779 | 2023-06-26 12:58:07 | opener | 3 | 112716 | 640 | 5.436 | 20735.1 |
778 | 2023-06-25 14:03:38 | opener | 3 | 112716 | 640 | 4.593 | 24540.8 |
777 | 2023-06-25 06:51:56 | opener | 3 | 112716 | 640 | 5.406 | 20850.2 |
776 | 2023-06-24 07:08:25 | opener | 3 | 112716 | 640 | 5.546 | 20323.8 |
775 | 2023-06-23 12:24:01 | opener | 3 | 112716 | 640 | 5.310 | 21227.1 |
774 | 2023-06-22 06:40:26 | opener | 3 | 112716 | 640 | 5.593 | 20153.0 |
773 | 2023-06-21 06:39:44 | opener | 3 | 112716 | 640 | 4.876 | 23116.5 |
772 | 2023-06-20 07:12:08 | opener | 3 | 112716 | 640 | 5.280 | 21347.7 |
771 | 2023-06-19 07:38:05 | opener | 3 | 112716 | 640 | 5.360 | 21029.1 |
770 | 2023-06-18 07:07:33 | opener | 3 | 112716 | 640 | 4.656 | 24208.8 |
769 | 2023-06-16 07:57:51 | opener | 3 | 112716 | 640 | 4.606 | 24471.6 |
768 | 2023-05-31 05:43:38 | opener | 1 | 48755 | 3 | 0.750 | 65006.7 |
767 | 2023-05-26 05:35:33 | opener | 1 | 48755 | 3 | 0.733 | 66514.3 |
766 | 2023-05-01 00:12:49 | opener | 1 | 48755 | 3 | 0.733 | 66514.3 |
765 | 2023-04-11 13:07:45 | opener | 1 | 48755 | 3 | 0.843 | 57835.1 |
764 | 2023-03-23 04:55:28 | opener | 1 | 48755 | 3 | 0.750 | 65006.7 |
763 | 2023-02-21 00:56:36 | opener | 3 | 112716 | 640 | 4.656 | 24208.8 |
762 | 2023-02-17 16:56:40 | opener | 1 | 48755 | 3 | 0.716 | 68093.6 |
761 | 2023-01-21 11:32:04 | opener | 3 | 112716 | 640 | 4.860 | 23192.6 |
760 | 2023-01-11 06:32:51 | opener | 1 | 48755 | 3 | 0.720 | 67715.3 |
759 | 2023-01-07 22:13:18 | opener | 1 | 48755 | 3 | 0.736 | 66243.2 |
758 | 2022-12-31 23:18:10 | opener | 3 | 112716 | 640 | 7.030 | 16033.6 |
757 | 2022-12-29 02:52:51 | opener | 1 | 48755 | 3 | 0.720 | 67715.3 |
756 | 2022-12-13 07:20:23 | opener | 3 | 112716 | 640 | 5.406 | 20850.2 |
755 | 2022-12-10 20:25:59 | opener | 1 | 48755 | 3 | 0.736 | 66243.2 |
754 | 2022-12-06 05:01:41 | opener | 3 | 112716 | 640 | 5.843 | 19290.8 |
753 | 2022-12-05 20:58:44 | opener | 3 | 112716 | 640 | 6.016 | 18736.0 |
752 | 2022-11-16 12:27:45 | opener | 3 | 112716 | 640 | 4.906 | 22975.1 |
751 | 2022-11-13 01:54:52 | opener | 1 | 48755 | 3 | 0.810 | 60191.4 |
750 | 2022-11-06 01:45:37 | opener | 3 | 112716 | 640 | 4.673 | 24120.7 |
749 | 2022-10-24 13:35:58 | opener | 1 | 48755 | 3 | 0.813 | 59969.2 |
748 | 2022-10-20 06:03:33 | opener | 3 | 112716 | 640 | 4.796 | 23502.1 |
747 | 2022-10-06 02:48:19 | opener | 1 | 48755 | 3 | 0.750 | 65006.7 |
746 | 2022-10-01 10:17:57 | opener | 3 | 112716 | 640 | 4.750 | 23729.7 |
745 | 2022-09-10 23:40:42 | opener | 1 | 48755 | 3 | 0.750 | 65006.7 |
744 | 2022-09-09 09:51:10 | opener | 1 | 48755 | 3 | 0.860 | 56691.9 |
743 | 2022-09-07 22:24:40 | opener | 1 | 48755 | 3 | 0.736 | 66243.2 |
742 | 2022-09-06 12:26:19 | opener | 3 | 112716 | 640 | 4.640 | 24292.2 |
741 | 2022-09-05 20:47:32 | opener | 1 | 48755 | 3 | 0.750 | 65006.7 |
740 | 2022-08-18 10:08:01 | opener | 3 | 112716 | 640 | 4.656 | 24208.8 |