History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hexose"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
810 | 2024-04-28 14:36:57 | hexose | 1 | 48755 | 3 | 0.813 | 59969.2 |
809 | 2024-04-19 09:14:38 | hexose | 1 | 48755 | 3 | 0.846 | 57630.0 |
808 | 2024-04-06 13:02:06 | hexose | 1 | 48755 | 3 | 0.953 | 51159.5 |
807 | 2024-03-31 22:52:39 | hexose | 1 | 48755 | 3 | 1.923 | 25353.6 |
806 | 2024-02-02 06:14:20 | hexose | 2 | 82551 | 22 | 2.436 | 33887.9 |
805 | 2024-02-02 06:14:04 | hexose | 3 | 112716 | 364 | 4.766 | 23650.0 |
804 | 2024-02-01 12:27:48 | hexose | 2 | 82551 | 22 | 2.093 | 39441.5 |
803 | 2024-02-01 12:27:32 | hexose | 3 | 112716 | 364 | 4.686 | 24053.8 |
802 | 2024-01-29 10:24:53 | hexose | 3 | 112716 | 364 | 5.720 | 19705.6 |
801 | 2024-01-20 10:56:39 | hexose | 3 | 112716 | 364 | 5.280 | 21347.7 |
800 | 2024-01-18 02:46:04 | hexose | 1 | 48755 | 3 | 0.830 | 58741.0 |
799 | 2024-01-07 18:41:38 | hexose | 1 | 48755 | 3 | 0.813 | 59969.2 |
798 | 2024-01-06 21:39:38 | hexose | 3 | 112716 | 364 | 4.843 | 23274.0 |
797 | 2024-01-06 21:39:37 | hexose | 2 | 82551 | 22 | 2.250 | 36689.3 |
796 | 2023-12-31 06:18:43 | hexose | 2 | 82551 | 22 | 2.313 | 35690.0 |
795 | 2023-12-31 06:18:40 | hexose | 3 | 112716 | 364 | 4.890 | 23050.3 |
794 | 2023-12-25 08:42:33 | hexose | 3 | 112716 | 364 | 5.576 | 20214.5 |
793 | 2023-12-10 03:33:37 | hexose | 1 | 48755 | 3 | 0.826 | 59025.4 |
792 | 2023-11-27 05:50:04 | hexose | 3 | 112716 | 364 | 4.736 | 23799.8 |
791 | 2023-11-14 09:10:37 | hexose | 1 | 48755 | 3 | 0.890 | 54780.9 |
790 | 2023-11-13 21:26:57 | hexose | 1 | 48755 | 3 | 0.736 | 66243.2 |
789 | 2023-11-12 10:41:38 | hexose | 1 | 48755 | 3 | 0.813 | 59969.2 |
788 | 2023-11-04 14:23:12 | hexose | 1 | 48755 | 3 | 0.720 | 67715.3 |
787 | 2023-10-30 08:59:47 | hexose | 1 | 48755 | 3 | 0.843 | 57835.1 |
786 | 2023-10-30 00:35:10 | hexose | 3 | 112716 | 364 | 4.830 | 23336.6 |
785 | 2023-10-20 07:01:39 | hexose | 1 | 48755 | 3 | 0.876 | 55656.4 |
784 | 2023-10-19 03:55:43 | hexose | 1 | 48755 | 3 | 0.733 | 66514.3 |
783 | 2023-10-14 23:34:57 | hexose | 1 | 48755 | 3 | 1.110 | 43923.4 |
782 | 2023-10-10 19:19:56 | hexose | 1 | 48755 | 3 | 0.920 | 52994.6 |
781 | 2023-10-08 17:26:05 | hexose | 1 | 48755 | 3 | 0.906 | 53813.5 |
780 | 2023-09-26 22:57:27 | hexose | 1 | 48755 | 3 | 0.873 | 55847.7 |
779 | 2023-09-14 19:56:56 | hexose | 1 | 48755 | 3 | 0.750 | 65006.7 |
778 | 2023-08-24 06:47:55 | hexose | 1 | 48755 | 3 | 0.750 | 65006.7 |
777 | 2023-08-07 17:57:29 | hexose | 3 | 112716 | 364 | 4.610 | 24450.3 |
776 | 2023-06-23 16:29:15 | hexose | 1 | 48755 | 3 | 0.843 | 57835.1 |
775 | 2023-05-31 13:12:55 | hexose | 3 | 112716 | 364 | 4.593 | 24540.8 |
774 | 2023-05-26 04:25:49 | hexose | 1 | 48755 | 3 | 0.733 | 66514.3 |
773 | 2023-04-18 18:19:36 | hexose | 3 | 112716 | 364 | 5.516 | 20434.4 |
772 | 2023-03-21 08:57:15 | hexose | 1 | 48755 | 3 | 0.720 | 67715.3 |
771 | 2023-03-20 21:38:45 | hexose | 1 | 48755 | 3 | 0.796 | 61250.0 |
770 | 2023-03-19 12:29:57 | hexose | 3 | 112716 | 364 | 4.516 | 24959.3 |
769 | 2023-01-26 05:30:25 | hexose | 3 | 112716 | 364 | 5.873 | 19192.2 |
768 | 2023-01-25 06:45:03 | hexose | 3 | 112716 | 364 | 4.546 | 24794.5 |
767 | 2023-01-24 05:07:27 | hexose | 3 | 112716 | 364 | 5.126 | 21989.1 |
766 | 2023-01-10 04:59:53 | hexose | 3 | 112716 | 364 | 4.516 | 24959.3 |
765 | 2023-01-07 20:24:44 | hexose | 1 | 48755 | 3 | 0.733 | 66514.3 |
764 | 2022-12-19 06:33:57 | hexose | 3 | 112716 | 364 | 8.440 | 13355.0 |
763 | 2022-12-12 01:37:30 | hexose | 3 | 112716 | 364 | 5.140 | 21929.2 |
762 | 2022-11-29 23:49:20 | hexose | 1 | 48755 | 3 | 0.826 | 59025.4 |
761 | 2022-11-26 16:55:43 | hexose | 1 | 48755 | 3 | 0.860 | 56691.9 |
760 | 2022-11-25 11:44:21 | hexose | 3 | 112716 | 364 | 4.530 | 24882.1 |
759 | 2022-11-08 07:37:42 | hexose | 3 | 112716 | 364 | 4.500 | 25048.0 |
758 | 2022-10-05 19:52:11 | hexose | 1 | 48755 | 3 | 0.733 | 66514.3 |
757 | 2022-07-27 03:45:26 | hexose | 1 | 48755 | 3 | 0.830 | 58741.0 |
756 | 2022-07-02 05:36:09 | hexose | 2 | 82551 | 22 | 2.170 | 38041.9 |
755 | 2022-06-24 11:06:20 | hexose | 3 | 112716 | 364 | 5.173 | 21789.3 |
754 | 2022-06-10 16:11:56 | hexose | 3 | 112716 | 364 | 4.830 | 23336.6 |
753 | 2022-06-08 11:11:02 | hexose | 3 | 112716 | 364 | 4.703 | 23966.8 |
752 | 2022-05-16 22:49:31 | hexose | 1 | 48755 | 3 | 0.840 | 58041.7 |
751 | 2022-05-09 09:31:53 | hexose | 3 | 112716 | 364 | 5.750 | 19602.8 |
750 | 2022-04-01 11:40:07 | hexose | 3 | 112716 | 364 | 6.266 | 17988.5 |
749 | 2022-03-29 03:17:52 | hexose | 1 | 48755 | 3 | 0.890 | 54780.9 |
748 | 2022-03-21 17:22:44 | hexose | 3 | 112716 | 364 | 6.110 | 18447.8 |
747 | 2022-03-05 15:19:38 | hexose | 3 | 112716 | 364 | 5.500 | 20493.8 |
746 | 2022-02-15 22:20:16 | hexose | 3 | 112716 | 364 | 5.233 | 21539.5 |
745 | 2022-02-15 16:33:16 | hexose | 1 | 48755 | 3 | 0.766 | 63648.8 |
744 | 2022-02-13 12:53:54 | hexose | 3 | 112716 | 364 | 4.750 | 23729.7 |
743 | 2022-01-27 14:39:23 | hexose | 3 | 112716 | 364 | 4.580 | 24610.5 |
742 | 2022-01-25 10:43:33 | hexose | 3 | 112716 | 364 | 4.890 | 23050.3 |
741 | 2022-01-11 07:11:26 | hexose | 3 | 112716 | 364 | 5.546 | 20323.8 |
740 | 2022-01-06 00:05:52 | hexose | 3 | 112716 | 364 | 5.143 | 21916.4 |
739 | 2022-01-03 21:01:01 | hexose | 3 | 112716 | 364 | 6.123 | 18408.6 |
738 | 2022-01-03 09:33:57 | hexose | 3 | 112716 | 364 | 5.250 | 21469.7 |
737 | 2022-01-02 10:03:39 | hexose | 3 | 112716 | 364 | 13.313 | 8466.6 |
736 | 2022-01-01 18:06:17 | hexose | 3 | 112716 | 364 | 5.530 | 20382.6 |
735 | 2021-12-23 17:27:53 | hexose | 3 | 112716 | 364 | 5.110 | 22057.9 |
734 | 2021-12-23 06:05:06 | hexose | 3 | 112716 | 364 | 4.830 | 23336.6 |
733 | 2021-12-22 21:54:53 | hexose | 3 | 112716 | 364 | 9.860 | 11431.6 |
732 | 2021-12-22 10:42:11 | hexose | 3 | 112716 | 364 | 5.593 | 20153.0 |
731 | 2021-12-21 17:28:23 | hexose | 3 | 112716 | 364 | 7.123 | 15824.2 |
730 | 2021-12-21 09:54:28 | hexose | 3 | 112716 | 364 | 5.343 | 21096.0 |
729 | 2021-12-21 06:02:55 | hexose | 3 | 112716 | 364 | 5.203 | 21663.7 |
728 | 2021-12-20 19:22:13 | hexose | 3 | 112716 | 364 | 5.593 | 20153.0 |
727 | 2021-12-20 07:34:59 | hexose | 3 | 112716 | 364 | 5.420 | 20796.3 |
726 | 2021-12-17 11:38:50 | hexose | 3 | 112716 | 364 | 5.580 | 20200.0 |
725 | 2021-12-16 23:53:57 | hexose | 3 | 112716 | 364 | 5.220 | 21593.1 |
724 | 2021-12-16 10:11:25 | hexose | 3 | 112716 | 364 | 7.046 | 15997.2 |
723 | 2021-12-15 21:27:43 | hexose | 3 | 112716 | 364 | 5.203 | 21663.7 |
722 | 2021-12-15 04:45:58 | hexose | 3 | 112716 | 364 | 11.546 | 9762.3 |
721 | 2021-12-14 19:23:54 | hexose | 1 | 48755 | 3 | 0.826 | 59025.4 |
720 | 2021-12-14 17:33:53 | hexose | 3 | 112716 | 364 | 4.703 | 23966.8 |
719 | 2021-12-14 10:41:24 | hexose | 3 | 112716 | 364 | 5.940 | 18975.8 |
718 | 2021-12-14 00:52:22 | hexose | 3 | 112716 | 364 | 5.610 | 20092.0 |
717 | 2021-12-13 12:42:34 | hexose | 3 | 112716 | 364 | 5.423 | 20784.8 |
716 | 2021-12-12 13:20:51 | hexose | 3 | 112716 | 364 | 4.766 | 23650.0 |
715 | 2021-12-12 00:00:45 | hexose | 3 | 112716 | 364 | 5.546 | 20323.8 |
714 | 2021-12-11 16:13:29 | hexose | 3 | 112716 | 364 | 5.796 | 19447.2 |
713 | 2021-12-11 06:34:12 | hexose | 3 | 112716 | 364 | 5.393 | 20900.4 |
712 | 2021-12-10 19:22:32 | hexose | 3 | 112716 | 364 | 4.860 | 23192.6 |
711 | 2021-12-10 06:59:14 | hexose | 3 | 112716 | 364 | 11.016 | 10232.0 |