History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"analyte"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
821 | 2025-04-20 13:14:53 | analyte | 1 | 69583 | 5 | 3.123 | 22280.8 |
820 | 2025-04-20 03:15:46 | analyte | 3 | 134027 | 106 | 38.783 | 3455.8 |
819 | 2025-04-18 07:13:06 | analyte | 3 | 134027 | 106 | 32.130 | 4171.4 |
818 | 2025-04-17 21:06:38 | analyte | 2 | 107671 | 18 | 25.970 | 4146.0 |
817 | 2025-04-16 19:37:04 | analyte | 1 | 69583 | 5 | 1.233 | 56433.9 |
816 | 2025-04-10 08:27:56 | analyte | 3 | 134027 | 106 | 7.080 | 18930.4 |
815 | 2025-04-08 10:30:50 | analyte | 1 | 69583 | 5 | 4.173 | 16674.6 |
814 | 2025-04-01 05:44:26 | analyte | 1 | 69583 | 5 | 1.076 | 64668.2 |
813 | 2025-03-30 21:51:43 | analyte | 1 | 69583 | 5 | 4.096 | 16988.0 |
812 | 2025-03-28 22:21:52 | analyte | 3 | 134027 | 106 | 23.346 | 5740.9 |
811 | 2025-03-24 23:08:30 | analyte | 1 | 69583 | 5 | 6.360 | 10940.7 |
810 | 2025-03-21 01:02:29 | analyte | 2 | 107671 | 18 | 15.540 | 6928.6 |
809 | 2025-03-21 00:07:03 | analyte | 3 | 134027 | 106 | 36.093 | 3713.4 |
808 | 2025-03-19 14:56:00 | analyte | 1 | 69583 | 5 | 1.220 | 57035.2 |
807 | 2025-03-18 00:27:02 | analyte | 1 | 69583 | 5 | 6.110 | 11388.4 |
806 | 2025-03-16 08:20:12 | analyte | 1 | 69583 | 5 | 1.330 | 52318.0 |
805 | 2025-03-05 10:22:04 | analyte | 1 | 69583 | 5 | 6.186 | 11248.5 |
804 | 2025-03-05 05:56:35 | analyte | 1 | 69583 | 5 | 6.013 | 11572.1 |
803 | 2025-02-14 13:56:12 | analyte | 1 | 69583 | 5 | 5.576 | 12479.0 |
802 | 2025-02-06 12:56:00 | analyte | 1 | 69583 | 5 | 2.686 | 25905.8 |
801 | 2025-01-24 21:47:16 | analyte | 1 | 69583 | 5 | 5.626 | 12368.1 |
800 | 2025-01-06 14:58:25 | analyte | 1 | 69583 | 5 | 4.780 | 14557.1 |
799 | 2024-12-14 03:23:35 | analyte | 1 | 69583 | 5 | 4.656 | 14944.8 |
798 | 2024-12-08 22:52:35 | analyte | 3 | 134027 | 106 | 46.270 | 2896.6 |
797 | 2024-12-07 22:26:43 | analyte | 3 | 134027 | 106 | 35.830 | 3740.6 |
796 | 2024-12-07 07:08:27 | analyte | 1 | 69583 | 5 | 6.110 | 11388.4 |
795 | 2024-12-06 07:53:45 | analyte | 1 | 69583 | 5 | 5.750 | 12101.4 |
794 | 2024-12-05 22:35:09 | analyte | 2 | 107671 | 18 | 10.456 | 10297.5 |
793 | 2024-12-05 22:32:40 | analyte | 3 | 134027 | 106 | 7.843 | 17088.7 |
792 | 2024-12-04 19:14:27 | analyte | 3 | 134027 | 106 | 7.360 | 18210.2 |
791 | 2024-12-04 12:57:13 | analyte | 3 | 134027 | 106 | 14.096 | 9508.2 |
790 | 2024-11-24 05:43:20 | analyte | 1 | 69583 | 5 | 5.486 | 12683.7 |
789 | 2024-11-12 21:21:03 | analyte | 2 | 107671 | 18 | 13.236 | 8134.7 |
788 | 2024-11-06 11:01:07 | analyte | 2 | 107671 | 18 | 22.813 | 4719.7 |
787 | 2024-11-06 10:23:39 | analyte | 1 | 69583 | 5 | 2.703 | 25742.9 |
786 | 2024-11-06 04:54:09 | analyte | 1 | 69583 | 5 | 8.750 | 7952.3 |
785 | 2024-11-04 05:26:53 | analyte | 1 | 69583 | 5 | 5.856 | 11882.3 |
784 | 2024-10-29 14:17:00 | analyte | 3 | 134027 | 106 | 26.843 | 4993.0 |
783 | 2024-10-27 12:40:37 | analyte | 3 | 134027 | 106 | 29.843 | 4491.1 |
782 | 2024-10-25 13:39:01 | analyte | 3 | 134027 | 106 | 36.716 | 3650.4 |
781 | 2024-10-25 02:17:45 | analyte | 3 | 134027 | 106 | 34.283 | 3909.4 |
780 | 2024-10-25 02:17:42 | analyte | 2 | 107671 | 18 | 15.030 | 7163.7 |
779 | 2024-10-25 02:17:10 | analyte | 1 | 69583 | 5 | 5.750 | 12101.4 |
778 | 2024-10-06 23:51:25 | analyte | 1 | 69583 | 5 | 7.516 | 9258.0 |
777 | 2024-10-04 05:43:40 | analyte | 1 | 69583 | 5 | 8.656 | 8038.7 |
776 | 2024-09-28 12:52:30 | analyte | 1 | 69583 | 5 | 8.170 | 8516.9 |
775 | 2024-09-07 10:55:50 | analyte | 1 | 69583 | 5 | 12.453 | 5587.6 |
774 | 2024-09-05 03:28:15 | analyte | 1 | 69583 | 5 | 10.373 | 6708.1 |
773 | 2024-08-22 17:36:45 | analyte | 1 | 69583 | 5 | 4.750 | 14649.1 |
772 | 2024-08-18 11:00:56 | analyte | 1 | 69583 | 5 | 8.126 | 8563.0 |
771 | 2024-08-16 06:34:02 | analyte | 1 | 69583 | 5 | 18.143 | 3835.3 |
770 | 2024-08-15 03:59:47 | analyte | 3 | 134027 | 106 | 33.110 | 4047.9 |
769 | 2024-08-15 03:59:45 | analyte | 1 | 69583 | 5 | 7.623 | 9128.0 |
768 | 2024-08-09 03:34:01 | analyte | 1 | 69583 | 5 | 4.390 | 15850.3 |
767 | 2024-07-22 06:23:44 | analyte | 1 | 69583 | 5 | 4.060 | 17138.7 |
766 | 2024-07-17 17:47:29 | analyte | 2 | 107671 | 18 | 17.313 | 6219.1 |
765 | 2024-07-17 17:46:01 | analyte | 1 | 69583 | 5 | 3.560 | 19545.8 |
764 | 2024-07-17 05:40:49 | analyte | 2 | 107671 | 18 | 16.920 | 6363.5 |
763 | 2024-07-17 05:39:25 | analyte | 1 | 69583 | 5 | 1.736 | 40082.4 |
762 | 2024-07-16 20:51:54 | analyte | 1 | 69583 | 5 | 2.580 | 26970.2 |
761 | 2024-07-15 17:08:33 | analyte | 1 | 69583 | 5 | 3.406 | 20429.5 |
760 | 2024-07-14 18:49:51 | analyte | 3 | 134027 | 106 | 13.453 | 9962.6 |
759 | 2024-07-14 17:12:55 | analyte | 3 | 134027 | 106 | 29.080 | 4608.9 |
758 | 2024-07-14 02:25:24 | analyte | 3 | 134027 | 106 | 18.280 | 7331.9 |
757 | 2024-07-14 02:25:22 | analyte | 2 | 107671 | 18 | 18.906 | 5695.1 |
756 | 2024-07-14 02:24:40 | analyte | 1 | 69583 | 5 | 4.780 | 14557.1 |
755 | 2024-07-08 06:21:37 | analyte | 1 | 69583 | 5 | 2.530 | 27503.2 |
754 | 2024-06-25 06:40:38 | analyte | 1 | 69583 | 5 | 5.936 | 11722.2 |
753 | 2024-06-19 14:00:16 | analyte | 1 | 69583 | 5 | 6.640 | 10479.4 |
752 | 2024-06-15 23:58:22 | analyte | 1 | 69583 | 5 | 4.313 | 16133.3 |
751 | 2024-06-14 04:02:21 | analyte | 3 | 134027 | 106 | 26.550 | 5048.1 |
750 | 2024-06-05 23:11:20 | analyte | 2 | 107671 | 18 | 6.126 | 17576.1 |
749 | 2024-06-05 09:02:53 | analyte | 2 | 107671 | 18 | 12.860 | 8372.6 |
748 | 2024-06-05 09:02:09 | analyte | 3 | 134027 | 106 | 17.800 | 7529.6 |
747 | 2024-06-04 22:45:16 | analyte | 2 | 107671 | 18 | 13.673 | 7874.7 |
746 | 2024-06-04 21:11:20 | analyte | 3 | 134027 | 106 | 7.203 | 18607.1 |
745 | 2024-06-04 10:52:53 | analyte | 2 | 107671 | 18 | 13.813 | 7794.9 |
744 | 2024-06-04 10:48:09 | analyte | 3 | 134027 | 106 | 8.236 | 16273.3 |
743 | 2024-06-04 07:15:37 | analyte | 2 | 107671 | 18 | 3.356 | 32083.1 |
742 | 2024-06-04 07:01:33 | analyte | 3 | 134027 | 106 | 8.080 | 16587.5 |
741 | 2024-06-04 04:53:53 | analyte | 3 | 134027 | 106 | 7.640 | 17542.8 |
740 | 2024-06-02 16:34:37 | analyte | 1 | 69583 | 5 | 4.423 | 15732.1 |
739 | 2024-05-06 07:54:48 | analyte | 2 | 107671 | 18 | 7.750 | 13893.0 |
738 | 2024-05-04 12:24:49 | analyte | 2 | 107671 | 18 | 7.096 | 15173.5 |
737 | 2024-05-04 12:24:37 | analyte | 3 | 134027 | 106 | 7.313 | 18327.2 |
736 | 2024-05-02 00:20:23 | analyte | 1 | 69583 | 5 | 2.563 | 27149.0 |
735 | 2024-04-29 14:25:10 | analyte | 2 | 107671 | 18 | 5.906 | 18230.8 |
734 | 2024-04-29 14:24:54 | analyte | 3 | 134027 | 106 | 8.660 | 15476.6 |
733 | 2024-04-29 10:53:09 | analyte | 1 | 69583 | 5 | 5.576 | 12479.0 |
732 | 2024-04-28 12:03:41 | analyte | 3 | 134027 | 106 | 8.233 | 16279.2 |
731 | 2024-04-28 12:03:33 | analyte | 2 | 107671 | 18 | 3.390 | 31761.4 |
730 | 2024-04-27 00:10:35 | analyte | 2 | 107671 | 18 | 3.530 | 30501.7 |
729 | 2024-04-02 17:39:55 | analyte | 1 | 69583 | 5 | 2.936 | 23699.9 |
728 | 2024-04-02 05:46:53 | analyte | 1 | 69583 | 5 | 1.063 | 65459.1 |
727 | 2024-03-29 04:59:09 | analyte | 1 | 69583 | 5 | 4.110 | 16930.2 |
726 | 2024-03-15 09:47:42 | analyte | 1 | 69583 | 5 | 1.720 | 40455.2 |
725 | 2024-01-16 04:30:56 | analyte | 3 | 134027 | 106 | 6.393 | 20964.6 |
724 | 2023-12-24 18:06:59 | analyte | 1 | 69583 | 5 | 1.296 | 53690.6 |
723 | 2023-12-23 10:39:59 | analyte | 1 | 69583 | 5 | 1.263 | 55093.4 |
722 | 2023-12-19 20:34:47 | analyte | 2 | 107671 | 18 | 3.376 | 31893.1 |