History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assays"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
847 | 2024-05-01 12:03:44 | assays | 1 | 48755 | 4 | 1.923 | 25353.6 |
846 | 2024-04-27 00:59:08 | assays | 1 | 48755 | 4 | 3.250 | 15001.5 |
845 | 2024-04-08 04:54:21 | assays | 2 | 82551 | 31 | 5.563 | 14839.3 |
844 | 2024-04-05 23:59:34 | assays | 1 | 48755 | 4 | 1.843 | 26454.2 |
843 | 2024-03-31 14:00:35 | assays | 1 | 48755 | 4 | 1.686 | 28917.6 |
842 | 2024-03-31 13:51:52 | assays | 1 | 48755 | 4 | 1.606 | 30358.0 |
841 | 2024-03-30 19:44:54 | assays | 3 | 112716 | 428 | 15.220 | 7405.8 |
840 | 2024-03-30 01:02:57 | assays | 3 | 112716 | 428 | 17.076 | 6600.8 |
839 | 2024-03-30 01:02:58 | assays | 2 | 82551 | 31 | 9.406 | 8776.4 |
838 | 2024-03-29 08:42:10 | assays | 3 | 112716 | 428 | 14.923 | 7553.2 |
837 | 2024-03-29 08:42:22 | assays | 1 | 48755 | 4 | 0.953 | 51159.5 |
836 | 2024-03-29 08:42:11 | assays | 2 | 82551 | 31 | 5.890 | 14015.4 |
835 | 2024-03-29 08:42:05 | assays | 1 | 48755 | 4 | 3.140 | 15527.1 |
834 | 2024-03-25 20:09:14 | assays | 1 | 48755 | 4 | 1.123 | 43415.0 |
833 | 2024-03-06 19:37:39 | assays | 1 | 48755 | 4 | 0.983 | 49598.2 |
832 | 2024-02-29 03:51:10 | assays | 2 | 82551 | 31 | 3.296 | 25045.8 |
831 | 2024-02-29 03:50:41 | assays | 3 | 112716 | 428 | 8.720 | 12926.1 |
830 | 2024-02-28 13:13:01 | assays | 2 | 82551 | 31 | 5.813 | 14201.1 |
829 | 2024-02-28 12:57:35 | assays | 3 | 112716 | 428 | 10.500 | 10734.9 |
828 | 2024-02-28 02:39:29 | assays | 1 | 48755 | 4 | 0.970 | 50262.9 |
827 | 2024-02-28 02:30:38 | assays | 3 | 112716 | 428 | 5.893 | 19127.1 |
826 | 2024-02-28 02:30:40 | assays | 2 | 82551 | 31 | 4.593 | 17973.2 |
825 | 2024-02-28 02:30:37 | assays | 1 | 48755 | 4 | 1.153 | 42285.3 |
824 | 2024-01-08 20:54:09 | assays | 1 | 48755 | 4 | 0.813 | 59969.2 |
823 | 2024-01-06 20:53:37 | assays | 3 | 112716 | 428 | 4.686 | 24053.8 |
822 | 2024-01-06 20:53:35 | assays | 2 | 82551 | 31 | 2.190 | 37694.5 |
821 | 2023-12-14 10:09:38 | assays | 1 | 48755 | 4 | 0.906 | 53813.5 |
820 | 2023-12-10 05:52:01 | assays | 2 | 82551 | 31 | 2.156 | 38289.0 |
819 | 2023-11-19 11:57:34 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
818 | 2023-11-14 18:06:00 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
817 | 2023-11-05 17:51:52 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
816 | 2023-10-29 19:17:49 | assays | 1 | 48755 | 4 | 0.860 | 56691.9 |
815 | 2023-10-23 04:31:02 | assays | 1 | 48755 | 4 | 0.843 | 57835.1 |
814 | 2023-10-20 16:27:02 | assays | 1 | 48755 | 4 | 0.920 | 52994.6 |
813 | 2023-10-15 14:10:17 | assays | 1 | 48755 | 4 | 0.763 | 63899.1 |
812 | 2023-10-08 07:49:36 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
811 | 2023-09-26 10:22:09 | assays | 1 | 48755 | 4 | 0.860 | 56691.9 |
810 | 2023-09-12 20:34:55 | assays | 1 | 48755 | 4 | 0.800 | 60943.8 |
809 | 2023-09-09 14:58:10 | assays | 2 | 82551 | 31 | 2.453 | 33653.1 |
808 | 2023-08-23 23:52:58 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
807 | 2023-08-18 04:38:16 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
806 | 2023-06-02 05:41:36 | assays | 2 | 82551 | 31 | 2.106 | 39198.0 |
805 | 2023-05-23 11:08:13 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
804 | 2023-05-07 17:58:57 | assays | 1 | 48755 | 4 | 0.860 | 56691.9 |
803 | 2023-03-18 17:46:47 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
802 | 2023-03-10 04:47:39 | assays | 2 | 82551 | 31 | 4.280 | 19287.6 |
801 | 2023-01-25 09:24:27 | assays | 1 | 48755 | 4 | 0.846 | 57630.0 |
800 | 2023-01-21 17:12:44 | assays | 1 | 48755 | 4 | 0.843 | 57835.1 |
799 | 2023-01-04 17:18:49 | assays | 1 | 48755 | 4 | 0.733 | 66514.3 |
798 | 2022-12-15 23:25:02 | assays | 2 | 82551 | 31 | 2.373 | 34787.6 |
797 | 2022-12-14 03:59:20 | assays | 2 | 82551 | 31 | 2.576 | 32046.2 |
796 | 2022-11-23 20:54:06 | assays | 2 | 82551 | 31 | 2.373 | 34787.6 |
795 | 2022-11-15 18:33:12 | assays | 2 | 82551 | 31 | 2.156 | 38289.0 |
794 | 2022-10-07 09:42:29 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
793 | 2022-10-06 20:17:26 | assays | 2 | 82551 | 31 | 2.373 | 34787.6 |
792 | 2022-10-03 20:50:27 | assays | 1 | 48755 | 4 | 0.846 | 57630.0 |
791 | 2022-09-26 20:20:55 | assays | 1 | 48755 | 4 | 0.780 | 62506.4 |
790 | 2022-09-19 03:45:09 | assays | 1 | 48755 | 4 | 0.856 | 56956.8 |
789 | 2022-09-09 11:23:03 | assays | 2 | 82551 | 31 | 2.110 | 39123.7 |
788 | 2022-08-14 12:58:30 | assays | 1 | 48755 | 4 | 0.796 | 61250.0 |
787 | 2022-08-05 06:23:45 | assays | 2 | 82551 | 31 | 2.140 | 38575.2 |
786 | 2022-07-28 20:08:55 | assays | 1 | 48755 | 4 | 1.093 | 44606.6 |
785 | 2022-07-10 08:36:24 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
784 | 2022-07-02 18:24:29 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
783 | 2022-06-15 21:34:34 | assays | 1 | 48755 | 4 | 0.873 | 55847.7 |
782 | 2022-06-13 06:30:27 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
781 | 2022-05-09 21:12:01 | assays | 1 | 48755 | 4 | 0.860 | 56691.9 |
780 | 2022-05-07 16:57:44 | assays | 1 | 48755 | 4 | 0.763 | 63899.1 |
779 | 2022-02-26 02:47:08 | assays | 1 | 48755 | 4 | 0.823 | 59240.6 |
778 | 2022-02-22 16:51:38 | assays | 1 | 48755 | 4 | 1.143 | 42655.3 |
777 | 2022-01-22 09:12:28 | assays | 1 | 48755 | 4 | 1.033 | 47197.5 |
776 | 2021-11-17 21:57:41 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
775 | 2021-11-15 20:50:09 | assays | 1 | 48755 | 4 | 0.843 | 57835.1 |
774 | 2021-11-13 19:06:49 | assays | 1 | 48755 | 4 | 0.830 | 58741.0 |
773 | 2021-09-27 06:00:10 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
772 | 2021-09-07 23:15:57 | assays | 1 | 48755 | 4 | 0.763 | 63899.1 |
771 | 2021-08-18 09:02:54 | assays | 1 | 48755 | 4 | 0.780 | 62506.4 |
770 | 2021-08-15 01:46:23 | assays | 1 | 48755 | 4 | 0.826 | 59025.4 |
769 | 2021-05-14 09:59:51 | assays | 1 | 48755 | 4 | 0.783 | 62266.9 |
768 | 2021-03-22 11:48:11 | assays | 1 | 48755 | 4 | 1.530 | 31866.0 |
767 | 2021-03-14 20:01:05 | assays | 3 | 112716 | 428 | 5.330 | 21147.5 |
766 | 2021-02-24 22:41:09 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
765 | 2021-02-17 23:57:24 | assays | 3 | 112716 | 428 | 4.876 | 23116.5 |
764 | 2021-02-11 05:13:06 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
763 | 2021-02-06 09:30:24 | assays | 1 | 48755 | 4 | 0.890 | 54780.9 |
762 | 2021-02-06 09:02:53 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
761 | 2021-02-06 08:37:32 | assays | 1 | 48755 | 4 | 0.843 | 57835.1 |
760 | 2021-02-06 08:14:09 | assays | 1 | 48755 | 4 | 0.763 | 63899.1 |
759 | 2021-01-31 23:42:58 | assays | 1 | 48755 | 4 | 0.766 | 63648.8 |
758 | 2021-01-31 18:05:14 | assays | 1 | 48755 | 4 | 0.903 | 53992.2 |
757 | 2021-01-04 08:22:37 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
756 | 2020-11-13 22:19:22 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
755 | 2020-11-04 08:25:59 | assays | 1 | 48755 | 4 | 0.860 | 56691.9 |
754 | 2020-11-02 02:22:48 | assays | 1 | 48755 | 4 | 0.860 | 56691.9 |
753 | 2020-10-19 00:50:09 | assays | 1 | 48755 | 4 | 0.763 | 63899.1 |
752 | 2020-10-17 14:17:10 | assays | 1 | 48755 | 4 | 0.763 | 63899.1 |
751 | 2020-07-31 19:33:59 | assays | 1 | 48755 | 4 | 0.796 | 61250.0 |
750 | 2020-07-29 05:13:08 | assays | 1 | 48755 | 4 | 0.783 | 62266.9 |
749 | 2020-07-28 16:20:41 | assays | 1 | 48755 | 4 | 0.906 | 53813.5 |
748 | 2020-04-29 08:22:58 | assays | 1 | 48755 | 4 | 0.796 | 61250.0 |