History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phage"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
784 | 2024-04-30 20:18:03 | phage | 1 | 28756 | 6 | 0.690 | 41675.4 |
783 | 2024-04-29 15:42:57 | phage | 1 | 28756 | 6 | 0.530 | 54256.6 |
782 | 2024-04-27 18:50:07 | phage | 1 | 28756 | 6 | 0.533 | 53951.2 |
781 | 2024-04-27 08:38:00 | phage | 2 | 53800 | 82 | 1.580 | 34050.6 |
780 | 2024-04-25 20:08:13 | phage | 3 | 83667 | 1342 | 4.690 | 17839.4 |
779 | 2024-04-24 18:16:33 | phage | 3 | 83667 | 1342 | 3.750 | 22311.2 |
778 | 2024-04-23 21:26:07 | phage | 3 | 83667 | 1342 | 4.970 | 16834.4 |
777 | 2024-04-09 13:49:06 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
776 | 2024-04-03 06:41:09 | phage | 1 | 28756 | 6 | 1.173 | 24514.9 |
775 | 2024-03-31 03:45:12 | phage | 1 | 28756 | 6 | 0.486 | 59168.7 |
774 | 2024-03-29 02:20:38 | phage | 1 | 28756 | 6 | 0.530 | 54256.6 |
773 | 2024-03-28 02:25:03 | phage | 1 | 28756 | 6 | 0.516 | 55728.7 |
772 | 2024-03-24 02:14:44 | phage | 3 | 83667 | 1342 | 3.233 | 25879.1 |
771 | 2024-03-05 18:11:33 | phage | 3 | 83667 | 1342 | 11.063 | 7562.8 |
770 | 2024-03-04 12:24:17 | phage | 2 | 53800 | 82 | 1.500 | 35866.7 |
769 | 2024-03-04 12:24:10 | phage | 1 | 28756 | 6 | 0.626 | 45936.1 |
768 | 2024-03-04 12:23:44 | phage | 3 | 83667 | 1342 | 5.970 | 14014.6 |
767 | 2024-03-03 23:50:15 | phage | 3 | 83667 | 1342 | 14.156 | 5910.4 |
766 | 2024-03-03 23:50:16 | phage | 2 | 53800 | 82 | 3.000 | 17933.3 |
765 | 2024-03-03 22:02:27 | phage | 1 | 28756 | 6 | 0.423 | 67981.1 |
764 | 2024-03-01 02:34:08 | phage | 1 | 28756 | 6 | 0.983 | 29253.3 |
763 | 2024-02-27 19:49:57 | phage | 1 | 28756 | 6 | 0.530 | 54256.6 |
762 | 2024-02-02 19:00:43 | phage | 1 | 28756 | 6 | 0.500 | 57512.0 |
761 | 2024-01-22 15:37:54 | phage | 3 | 83667 | 1342 | 3.250 | 25743.7 |
760 | 2024-01-19 10:08:32 | phage | 2 | 53800 | 82 | 1.360 | 39558.8 |
759 | 2024-01-13 17:28:04 | phage | 3 | 83667 | 1342 | 3.250 | 25743.7 |
758 | 2023-12-26 22:50:03 | phage | 1 | 28756 | 6 | 0.440 | 65354.5 |
757 | 2023-12-21 18:56:24 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
756 | 2023-12-18 15:59:33 | phage | 3 | 83667 | 1342 | 3.393 | 24658.7 |
755 | 2023-12-18 15:59:31 | phage | 2 | 53800 | 82 | 1.546 | 34799.5 |
754 | 2023-12-09 09:21:28 | phage | 2 | 53800 | 82 | 1.423 | 37807.4 |
753 | 2023-12-05 06:24:06 | phage | 2 | 53800 | 82 | 1.610 | 33416.1 |
752 | 2023-12-05 06:24:03 | phage | 3 | 83667 | 1342 | 4.203 | 19906.5 |
751 | 2023-11-29 05:46:38 | phage | 3 | 83667 | 1342 | 3.406 | 24564.6 |
750 | 2023-11-28 20:42:25 | phage | 1 | 28756 | 6 | 0.516 | 55728.7 |
749 | 2023-11-20 21:38:33 | phage | 3 | 83667 | 1342 | 4.063 | 20592.4 |
748 | 2023-11-20 21:38:31 | phage | 2 | 53800 | 82 | 1.563 | 34421.0 |
747 | 2023-11-12 16:55:20 | phage | 1 | 28756 | 6 | 0.876 | 32826.5 |
746 | 2023-11-12 13:35:49 | phage | 1 | 28756 | 6 | 0.483 | 59536.2 |
745 | 2023-11-09 04:34:12 | phage | 1 | 28756 | 6 | 0.436 | 65954.1 |
744 | 2023-11-01 16:00:53 | phage | 1 | 28756 | 6 | 0.466 | 61708.2 |
743 | 2023-10-28 09:27:02 | phage | 2 | 53800 | 82 | 3.596 | 14961.1 |
742 | 2023-10-22 10:58:36 | phage | 1 | 28756 | 6 | 0.530 | 54256.6 |
741 | 2023-10-18 21:47:17 | phage | 1 | 28756 | 6 | 0.560 | 51350.0 |
740 | 2023-10-15 16:54:21 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
739 | 2023-10-11 11:50:55 | phage | 1 | 28756 | 6 | 0.420 | 68466.7 |
738 | 2023-10-07 11:18:11 | phage | 1 | 28756 | 6 | 0.516 | 55728.7 |
737 | 2023-10-03 14:59:37 | phage | 3 | 83667 | 1342 | 4.410 | 18972.1 |
736 | 2023-10-01 14:19:14 | phage | 3 | 83667 | 1342 | 4.346 | 19251.5 |
735 | 2023-09-27 08:15:10 | phage | 3 | 83667 | 1342 | 3.750 | 22311.2 |
734 | 2023-09-27 08:15:12 | phage | 2 | 53800 | 82 | 1.640 | 32804.9 |
733 | 2023-09-26 18:31:48 | phage | 1 | 28756 | 6 | 0.563 | 51076.4 |
732 | 2023-09-12 19:12:12 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
731 | 2023-08-27 18:12:43 | phage | 3 | 83667 | 1342 | 3.373 | 24804.9 |
730 | 2023-08-11 12:13:46 | phage | 1 | 28756 | 6 | 0.440 | 65354.5 |
729 | 2023-08-06 01:09:48 | phage | 2 | 53800 | 82 | 1.406 | 38264.6 |
728 | 2023-08-02 02:41:25 | phage | 1 | 28756 | 6 | 0.500 | 57512.0 |
727 | 2023-07-01 19:47:46 | phage | 3 | 83667 | 1342 | 3.843 | 21771.3 |
726 | 2023-05-11 13:06:37 | phage | 3 | 83667 | 1342 | 4.720 | 17726.1 |
725 | 2023-05-10 03:33:55 | phage | 1 | 28756 | 6 | 0.486 | 59168.7 |
724 | 2023-04-16 11:52:32 | phage | 2 | 53800 | 82 | 1.420 | 37887.3 |
723 | 2023-04-13 16:47:42 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
722 | 2023-03-06 11:05:43 | phage | 1 | 28756 | 6 | 0.423 | 67981.1 |
721 | 2023-02-16 12:01:07 | phage | 3 | 83667 | 1342 | 3.190 | 26227.9 |
720 | 2023-01-23 16:40:03 | phage | 2 | 53800 | 82 | 1.343 | 40059.6 |
719 | 2022-12-29 20:55:25 | phage | 1 | 28756 | 6 | 0.486 | 59168.7 |
718 | 2022-12-24 17:19:02 | phage | 1 | 28756 | 6 | 0.500 | 57512.0 |
717 | 2022-12-03 22:13:52 | phage | 3 | 83667 | 1342 | 3.173 | 26368.4 |
716 | 2022-11-27 06:34:11 | phage | 3 | 83667 | 1342 | 3.233 | 25879.1 |
715 | 2022-11-04 01:05:30 | phage | 2 | 53800 | 82 | 1.610 | 33416.1 |
714 | 2022-09-20 01:45:23 | phage | 1 | 28756 | 6 | 0.423 | 67981.1 |
713 | 2022-08-20 22:15:50 | phage | 1 | 28756 | 6 | 0.470 | 61183.0 |
712 | 2022-08-06 09:46:49 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
711 | 2022-07-28 15:02:48 | phage | 1 | 28756 | 6 | 0.500 | 57512.0 |
710 | 2022-06-05 18:28:35 | phage | 2 | 53800 | 82 | 1.343 | 40059.6 |
709 | 2022-05-02 23:24:19 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
708 | 2022-04-20 08:12:31 | phage | 1 | 28756 | 6 | 0.483 | 59536.2 |
707 | 2022-04-16 22:44:26 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
706 | 2022-04-11 05:52:25 | phage | 3 | 83667 | 1342 | 3.343 | 25027.5 |
705 | 2022-01-24 22:40:08 | phage | 2 | 53800 | 82 | 1.530 | 35163.4 |
704 | 2022-01-21 23:10:06 | phage | 1 | 28756 | 6 | 0.436 | 65954.1 |
703 | 2021-12-25 18:37:36 | phage | 1 | 28756 | 6 | 0.516 | 55728.7 |
702 | 2021-12-23 04:45:32 | phage | 3 | 83667 | 1342 | 3.970 | 21074.8 |
701 | 2021-12-20 10:51:45 | phage | 3 | 83667 | 1342 | 3.686 | 22698.6 |
700 | 2021-12-19 10:50:16 | phage | 3 | 83667 | 1342 | 3.890 | 21508.2 |
699 | 2021-12-18 10:47:42 | phage | 3 | 83667 | 1342 | 3.343 | 25027.5 |
698 | 2021-12-17 10:44:29 | phage | 3 | 83667 | 1342 | 3.796 | 22040.8 |
697 | 2021-12-15 10:39:51 | phage | 3 | 83667 | 1342 | 3.700 | 22612.7 |
696 | 2021-12-05 00:44:09 | phage | 3 | 83667 | 1342 | 3.263 | 25641.1 |
695 | 2021-11-28 16:19:41 | phage | 3 | 83667 | 1342 | 4.123 | 20292.7 |
694 | 2021-11-27 13:29:03 | phage | 3 | 83667 | 1342 | 4.080 | 20506.6 |
693 | 2021-11-19 16:04:27 | phage | 1 | 28756 | 6 | 0.453 | 63479.0 |
692 | 2021-11-09 04:18:19 | phage | 3 | 83667 | 1342 | 3.423 | 24442.6 |
691 | 2021-11-03 20:24:46 | phage | 2 | 53800 | 82 | 1.593 | 33772.8 |
690 | 2021-10-29 16:11:00 | phage | 3 | 83667 | 1342 | 3.200 | 26145.9 |
689 | 2021-10-22 01:33:27 | phage | 3 | 83667 | 1342 | 3.310 | 25277.0 |
688 | 2021-10-07 10:37:38 | phage | 1 | 28756 | 6 | 0.483 | 59536.2 |
687 | 2021-10-05 11:18:19 | phage | 3 | 83667 | 1342 | 3.860 | 21675.4 |
686 | 2021-10-05 07:58:50 | phage | 1 | 28756 | 6 | 0.440 | 65354.5 |
685 | 2021-09-12 03:52:38 | phage | 1 | 28756 | 6 | 0.436 | 65954.1 |