History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"happen"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
823 | 2024-04-30 01:06:34 | happen | 1 | 48755 | 5 | 0.843 | 57835.1 |
822 | 2024-04-28 09:16:00 | happen | 1 | 48755 | 5 | 1.983 | 24586.5 |
821 | 2024-04-28 07:18:08 | happen | 1 | 48755 | 5 | 1.766 | 27607.6 |
820 | 2024-04-11 02:11:45 | happen | 3 | 112716 | 646 | 10.080 | 11182.1 |
819 | 2024-04-10 06:21:24 | happen | 1 | 48755 | 5 | 0.923 | 52822.3 |
818 | 2024-04-10 04:55:20 | happen | 2 | 82551 | 74 | 3.983 | 20725.8 |
817 | 2024-04-10 04:54:57 | happen | 3 | 112716 | 646 | 5.983 | 18839.4 |
816 | 2024-04-09 05:20:22 | happen | 3 | 112716 | 646 | 10.063 | 11201.0 |
815 | 2024-04-09 03:02:23 | happen | 3 | 112716 | 646 | 10.453 | 10783.1 |
814 | 2024-04-09 03:02:30 | happen | 1 | 48755 | 5 | 1.016 | 47987.2 |
813 | 2024-04-09 03:02:23 | happen | 2 | 82551 | 74 | 2.873 | 28733.4 |
812 | 2024-03-31 17:43:16 | happen | 1 | 48755 | 5 | 1.966 | 24799.1 |
811 | 2024-03-30 09:04:41 | happen | 1 | 48755 | 5 | 2.953 | 16510.3 |
810 | 2024-03-02 11:02:26 | happen | 2 | 82551 | 74 | 11.610 | 7110.3 |
809 | 2024-03-02 10:59:06 | happen | 3 | 112716 | 646 | 6.330 | 17806.6 |
808 | 2024-02-28 10:57:46 | happen | 2 | 82551 | 74 | 2.673 | 30883.3 |
807 | 2024-02-28 10:57:25 | happen | 3 | 112716 | 646 | 5.736 | 19650.6 |
806 | 2024-02-27 04:46:59 | happen | 2 | 82551 | 74 | 5.296 | 15587.4 |
805 | 2024-02-27 04:46:53 | happen | 3 | 112716 | 646 | 6.626 | 17011.2 |
804 | 2024-02-26 21:48:29 | happen | 2 | 82551 | 74 | 2.830 | 29170.0 |
803 | 2024-02-26 15:11:48 | happen | 2 | 82551 | 74 | 2.530 | 32628.9 |
802 | 2024-02-26 15:11:18 | happen | 3 | 112716 | 646 | 6.063 | 18590.8 |
801 | 2024-01-20 07:12:35 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
800 | 2024-01-14 02:38:29 | happen | 3 | 112716 | 646 | 5.750 | 19602.8 |
799 | 2024-01-14 02:38:28 | happen | 2 | 82551 | 74 | 2.703 | 30540.5 |
798 | 2024-01-11 14:05:18 | happen | 3 | 112716 | 646 | 4.750 | 23729.7 |
797 | 2024-01-10 07:58:01 | happen | 2 | 82551 | 74 | 2.296 | 35954.3 |
796 | 2023-12-29 11:25:17 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
795 | 2023-12-03 12:26:23 | happen | 1 | 48755 | 5 | 0.940 | 51867.0 |
794 | 2023-11-20 20:18:08 | happen | 2 | 82551 | 74 | 2.173 | 37989.4 |
793 | 2023-11-17 05:34:15 | happen | 1 | 48755 | 5 | 0.810 | 60191.4 |
792 | 2023-11-15 09:33:03 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
791 | 2023-11-04 12:02:24 | happen | 1 | 48755 | 5 | 0.843 | 57835.1 |
790 | 2023-10-22 21:37:30 | happen | 1 | 48755 | 5 | 0.970 | 50262.9 |
789 | 2023-10-21 10:25:41 | happen | 1 | 48755 | 5 | 0.826 | 59025.4 |
788 | 2023-10-19 04:34:32 | happen | 1 | 48755 | 5 | 0.780 | 62506.4 |
787 | 2023-10-19 00:41:06 | happen | 1 | 48755 | 5 | 0.783 | 62266.9 |
786 | 2023-10-15 13:18:18 | happen | 1 | 48755 | 5 | 0.733 | 66514.3 |
785 | 2023-10-05 00:12:48 | happen | 1 | 48755 | 5 | 0.783 | 62266.9 |
784 | 2023-09-26 14:18:56 | happen | 1 | 48755 | 5 | 0.876 | 55656.4 |
783 | 2023-09-26 07:49:14 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
782 | 2023-09-15 12:11:29 | happen | 1 | 48755 | 5 | 0.813 | 59969.2 |
781 | 2023-08-21 20:01:48 | happen | 2 | 82551 | 74 | 2.420 | 34112.0 |
780 | 2023-08-13 18:49:18 | happen | 1 | 48755 | 5 | 0.856 | 56956.8 |
779 | 2023-06-06 00:28:15 | happen | 1 | 48755 | 5 | 0.860 | 56691.9 |
778 | 2023-06-02 17:16:38 | happen | 1 | 48755 | 5 | 0.843 | 57835.1 |
777 | 2023-05-16 13:53:32 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
776 | 2023-05-07 02:50:18 | happen | 2 | 82551 | 74 | 2.406 | 34310.5 |
775 | 2023-03-12 07:10:16 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
774 | 2023-02-21 06:22:28 | happen | 1 | 48755 | 5 | 0.780 | 62506.4 |
773 | 2023-02-13 06:53:40 | happen | 2 | 82551 | 74 | 2.656 | 31080.9 |
772 | 2023-01-01 19:24:34 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
771 | 2022-11-25 06:35:02 | happen | 2 | 82551 | 74 | 2.126 | 38829.3 |
770 | 2022-10-31 16:50:15 | happen | 1 | 48755 | 5 | 0.763 | 63899.1 |
769 | 2022-09-23 03:32:13 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
768 | 2022-09-19 19:06:50 | happen | 1 | 48755 | 5 | 0.780 | 62506.4 |
767 | 2022-08-14 18:44:00 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
766 | 2022-07-29 02:57:07 | happen | 1 | 48755 | 5 | 0.736 | 66243.2 |
765 | 2022-07-18 06:36:40 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
764 | 2022-07-10 10:01:39 | happen | 1 | 48755 | 5 | 0.796 | 61250.0 |
763 | 2022-07-02 19:29:20 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
762 | 2022-06-15 21:44:49 | happen | 1 | 48755 | 5 | 0.796 | 61250.0 |
761 | 2022-05-06 09:09:43 | happen | 1 | 48755 | 5 | 0.783 | 62266.9 |
760 | 2022-04-24 05:40:45 | happen | 2 | 82551 | 74 | 2.186 | 37763.5 |
759 | 2022-03-27 17:26:26 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
758 | 2022-02-13 05:28:53 | happen | 1 | 48755 | 5 | 1.483 | 32875.9 |
757 | 2022-01-21 00:34:59 | happen | 1 | 48755 | 5 | 0.826 | 59025.4 |
756 | 2021-12-16 19:44:19 | happen | 1 | 48755 | 5 | 0.890 | 54780.9 |
755 | 2021-12-13 11:52:10 | happen | 1 | 48755 | 5 | 0.856 | 56956.8 |
754 | 2021-11-16 15:15:36 | happen | 1 | 48755 | 5 | 0.860 | 56691.9 |
753 | 2021-11-11 17:40:35 | happen | 1 | 48755 | 5 | 0.970 | 50262.9 |
752 | 2021-10-04 08:54:16 | happen | 1 | 48755 | 5 | 0.860 | 56691.9 |
751 | 2021-10-02 06:19:09 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
750 | 2021-09-09 11:03:20 | happen | 1 | 48755 | 5 | 0.876 | 55656.4 |
749 | 2021-08-28 16:02:38 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
748 | 2021-08-26 11:02:00 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
747 | 2021-06-12 01:47:56 | happen | 1 | 48755 | 5 | 0.766 | 63648.8 |
746 | 2021-06-08 11:25:30 | happen | 1 | 48755 | 5 | 0.830 | 58741.0 |
745 | 2021-06-07 17:27:06 | happen | 1 | 48755 | 5 | 1.686 | 28917.6 |
744 | 2021-05-13 15:10:12 | happen | 1 | 48755 | 5 | 0.796 | 61250.0 |
743 | 2021-05-12 16:07:19 | happen | 1 | 48755 | 5 | 0.876 | 55656.4 |
742 | 2021-04-11 06:50:38 | happen | 1 | 48755 | 5 | 0.796 | 61250.0 |
741 | 2021-03-09 11:04:46 | happen | 1 | 48755 | 5 | 0.796 | 61250.0 |
740 | 2021-02-18 07:46:43 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
739 | 2021-02-04 00:41:49 | happen | 1 | 48755 | 5 | 0.813 | 59969.2 |
738 | 2020-12-06 00:41:06 | happen | 1 | 48755 | 5 | 0.763 | 63899.1 |
737 | 2020-10-23 11:05:32 | happen | 1 | 48755 | 5 | 0.956 | 50999.0 |
736 | 2020-09-03 07:01:50 | happen | 1 | 48755 | 5 | 0.843 | 57835.1 |
735 | 2020-08-27 00:41:22 | happen | 1 | 48755 | 5 | 0.763 | 63899.1 |
734 | 2020-08-13 12:07:15 | happen | 1 | 48755 | 5 | 0.903 | 53992.2 |
733 | 2020-08-07 07:21:06 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
732 | 2020-05-26 05:56:55 | happen | 1 | 48755 | 5 | 0.750 | 65006.7 |
731 | 2020-05-05 11:40:26 | happen | 1 | 48755 | 5 | 0.843 | 57835.1 |
730 | 2020-03-27 16:45:14 | happen | 1 | 48755 | 5 | 0.796 | 61250.0 |
729 | 2020-03-24 23:00:36 | happen | 1 | 48755 | 5 | 0.873 | 55847.7 |
728 | 2020-03-23 21:01:30 | happen | 1 | 48755 | 5 | 1.830 | 26642.1 |
727 | 2020-03-22 01:39:14 | happen | 1 | 48755 | 5 | 1.860 | 26212.4 |
726 | 2020-03-18 17:11:29 | happen | 1 | 48755 | 5 | 0.813 | 59969.2 |
725 | 2020-02-23 02:33:57 | happen | 1 | 48755 | 5 | 0.936 | 52088.7 |
724 | 2020-02-23 00:22:52 | happen | 1 | 48755 | 5 | 1.906 | 25579.7 |