History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"advise"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
811 | 2024-04-06 11:32:59 | advise | 1 | 48755 | 6 | 3.106 | 15697.0 |
810 | 2024-03-30 16:04:58 | advise | 1 | 48755 | 6 | 0.843 | 57835.1 |
809 | 2024-03-20 21:04:55 | advise | 1 | 48755 | 6 | 1.546 | 31536.2 |
808 | 2024-02-27 23:29:30 | advise | 1 | 48755 | 6 | 1.626 | 29984.6 |
807 | 2024-01-30 21:32:20 | advise | 2 | 82551 | 22 | 2.423 | 34069.7 |
806 | 2024-01-30 21:28:43 | advise | 3 | 112716 | 396 | 5.623 | 20045.5 |
805 | 2024-01-30 00:41:32 | advise | 2 | 82551 | 22 | 4.906 | 16826.5 |
804 | 2024-01-30 00:40:07 | advise | 3 | 112716 | 396 | 5.236 | 21527.1 |
803 | 2024-01-25 17:33:11 | advise | 2 | 82551 | 22 | 2.206 | 37421.1 |
802 | 2024-01-25 17:32:55 | advise | 3 | 112716 | 396 | 8.016 | 14061.4 |
801 | 2024-01-16 02:06:00 | advise | 2 | 82551 | 22 | 2.343 | 35233.0 |
800 | 2024-01-16 02:05:57 | advise | 3 | 112716 | 396 | 4.843 | 23274.0 |
799 | 2024-01-04 03:13:11 | advise | 3 | 112716 | 396 | 4.843 | 23274.0 |
798 | 2023-12-30 04:22:53 | advise | 2 | 82551 | 22 | 4.813 | 17151.7 |
797 | 2023-12-30 04:22:52 | advise | 3 | 112716 | 396 | 5.330 | 21147.5 |
796 | 2023-12-13 00:50:43 | advise | 1 | 48755 | 6 | 0.813 | 59969.2 |
795 | 2023-12-12 12:16:19 | advise | 1 | 48755 | 6 | 0.873 | 55847.7 |
794 | 2023-12-05 08:30:34 | advise | 3 | 112716 | 396 | 5.796 | 19447.2 |
793 | 2023-12-05 08:30:32 | advise | 2 | 82551 | 22 | 2.580 | 31996.5 |
792 | 2023-11-26 01:07:11 | advise | 1 | 48755 | 6 | 0.843 | 57835.1 |
791 | 2023-11-19 23:11:12 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
790 | 2023-11-13 11:00:53 | advise | 1 | 48755 | 6 | 0.860 | 56691.9 |
789 | 2023-11-02 02:01:10 | advise | 1 | 48755 | 6 | 0.903 | 53992.2 |
788 | 2023-10-22 11:05:31 | advise | 1 | 48755 | 6 | 0.906 | 53813.5 |
787 | 2023-10-18 13:07:48 | advise | 1 | 48755 | 6 | 0.830 | 58741.0 |
786 | 2023-10-14 07:56:21 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
785 | 2023-10-07 19:57:36 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
784 | 2023-09-30 06:32:16 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
783 | 2023-09-24 03:03:46 | advise | 1 | 48755 | 6 | 0.763 | 63899.1 |
782 | 2023-09-15 11:18:06 | advise | 1 | 48755 | 6 | 0.736 | 66243.2 |
781 | 2023-08-10 02:46:02 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
780 | 2023-07-28 18:09:21 | advise | 1 | 48755 | 6 | 0.733 | 66514.3 |
779 | 2023-05-02 13:51:35 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
778 | 2023-04-26 14:55:11 | advise | 1 | 48755 | 6 | 0.860 | 56691.9 |
777 | 2023-03-31 12:42:06 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
776 | 2023-03-12 11:50:14 | advise | 1 | 48755 | 6 | 0.876 | 55656.4 |
775 | 2023-02-16 08:52:03 | advise | 1 | 48755 | 6 | 0.733 | 66514.3 |
774 | 2023-01-20 07:49:01 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
773 | 2022-12-13 23:30:13 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
772 | 2022-10-09 16:21:02 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
771 | 2022-10-01 03:48:38 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
770 | 2022-08-20 19:42:14 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
769 | 2022-06-30 17:09:14 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
768 | 2022-05-18 15:00:13 | advise | 1 | 48755 | 6 | 0.860 | 56691.9 |
767 | 2022-04-09 02:02:23 | advise | 1 | 48755 | 6 | 0.830 | 58741.0 |
766 | 2022-03-24 04:38:10 | advise | 1 | 48755 | 6 | 0.950 | 51321.1 |
765 | 2022-01-10 15:58:53 | advise | 1 | 48755 | 6 | 0.936 | 52088.7 |
764 | 2021-12-16 13:35:27 | advise | 1 | 48755 | 6 | 0.856 | 56956.8 |
763 | 2021-11-10 19:30:24 | advise | 1 | 48755 | 6 | 0.813 | 59969.2 |
762 | 2021-11-08 17:32:09 | advise | 1 | 48755 | 6 | 0.780 | 62506.4 |
761 | 2021-09-12 13:38:28 | advise | 1 | 48755 | 6 | 0.736 | 66243.2 |
760 | 2021-07-28 06:24:02 | advise | 2 | 82551 | 22 | 2.110 | 39123.7 |
759 | 2021-07-04 20:16:34 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
758 | 2021-06-21 08:05:38 | advise | 3 | 112716 | 396 | 4.720 | 23880.5 |
757 | 2021-06-12 09:01:22 | advise | 1 | 48755 | 6 | 0.796 | 61250.0 |
756 | 2021-05-19 13:54:37 | advise | 2 | 82551 | 22 | 2.580 | 31996.5 |
755 | 2021-04-18 19:49:05 | advise | 1 | 48755 | 6 | 0.920 | 52994.6 |
754 | 2021-03-21 15:12:15 | advise | 1 | 48755 | 6 | 0.830 | 58741.0 |
753 | 2021-03-15 07:30:17 | advise | 3 | 112716 | 396 | 4.716 | 23900.8 |
752 | 2021-03-11 18:57:13 | advise | 3 | 112716 | 396 | 9.843 | 11451.4 |
751 | 2021-03-09 07:22:36 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
750 | 2021-03-06 01:44:30 | advise | 1 | 48755 | 6 | 0.826 | 59025.4 |
749 | 2021-03-06 01:34:39 | advise | 1 | 48755 | 6 | 0.860 | 56691.9 |
748 | 2021-01-31 21:59:59 | advise | 2 | 82551 | 22 | 2.203 | 37472.1 |
747 | 2021-01-28 05:45:39 | advise | 3 | 112716 | 396 | 5.550 | 20309.2 |
746 | 2021-01-21 15:47:56 | advise | 3 | 112716 | 396 | 4.686 | 24053.8 |
745 | 2021-01-04 05:40:19 | advise | 2 | 82551 | 22 | 2.310 | 35736.4 |
744 | 2021-01-03 03:50:37 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
743 | 2020-12-08 15:24:37 | advise | 3 | 112716 | 396 | 4.766 | 23650.0 |
742 | 2020-12-06 12:32:27 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
741 | 2020-12-01 15:28:45 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
740 | 2020-11-12 11:37:40 | advise | 2 | 82551 | 22 | 2.140 | 38575.2 |
739 | 2020-11-04 04:52:00 | advise | 3 | 112716 | 396 | 5.576 | 20214.5 |
738 | 2020-11-02 12:18:53 | advise | 3 | 112716 | 396 | 4.780 | 23580.8 |
737 | 2020-11-02 12:18:51 | advise | 2 | 82551 | 22 | 2.220 | 37185.1 |
736 | 2020-11-02 12:18:50 | advise | 1 | 48755 | 6 | 0.893 | 54596.9 |
735 | 2020-10-24 21:32:40 | advise | 3 | 112716 | 396 | 5.016 | 22471.3 |
734 | 2020-10-16 01:54:23 | advise | 3 | 112716 | 396 | 4.736 | 23799.8 |
733 | 2020-10-12 05:29:14 | advise | 3 | 112716 | 396 | 5.156 | 21861.1 |
732 | 2020-10-11 10:10:51 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
731 | 2020-10-08 04:44:09 | advise | 3 | 112716 | 396 | 4.610 | 24450.3 |
730 | 2020-10-07 00:21:18 | advise | 3 | 112716 | 396 | 4.703 | 23966.8 |
729 | 2020-09-27 22:58:43 | advise | 1 | 48755 | 6 | 0.766 | 63648.8 |
728 | 2020-09-24 16:46:49 | advise | 1 | 48755 | 6 | 0.750 | 65006.7 |
727 | 2020-09-05 13:26:23 | advise | 3 | 112716 | 396 | 5.016 | 22471.3 |
726 | 2020-08-27 15:24:35 | advise | 1 | 48755 | 6 | 0.783 | 62266.9 |
725 | 2020-08-20 13:29:08 | advise | 3 | 112716 | 396 | 4.843 | 23274.0 |
724 | 2020-08-02 12:51:47 | advise | 3 | 112716 | 396 | 4.893 | 23036.2 |
723 | 2020-06-17 05:36:29 | advise | 1 | 48755 | 6 | 0.763 | 63899.1 |
722 | 2020-05-26 03:11:00 | advise | 1 | 48755 | 6 | 0.826 | 59025.4 |
721 | 2020-05-06 19:27:32 | advise | 3 | 112716 | 396 | 4.716 | 23900.8 |
720 | 2020-03-29 21:52:38 | advise | 1 | 48755 | 6 | 0.843 | 57835.1 |
719 | 2020-03-28 02:14:11 | advise | 1 | 48755 | 6 | 0.826 | 59025.4 |
718 | 2020-03-25 20:56:38 | advise | 1 | 48755 | 6 | 0.813 | 59969.2 |
717 | 2020-03-23 17:49:21 | advise | 1 | 48755 | 6 | 0.890 | 54780.9 |
716 | 2020-03-22 05:04:31 | advise | 1 | 48755 | 6 | 0.763 | 63899.1 |
715 | 2020-03-20 02:19:37 | advise | 1 | 48755 | 6 | 0.860 | 56691.9 |
714 | 2020-03-05 16:05:30 | advise | 2 | 82551 | 22 | 2.813 | 29346.2 |
713 | 2020-03-03 15:18:12 | advise | 3 | 112716 | 396 | 5.376 | 20966.5 |
712 | 2020-03-03 15:18:03 | advise | 2 | 82551 | 22 | 2.436 | 33887.9 |