History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gannets"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
814 | 2024-04-13 15:58:56 | gannets | 2 | 107671 | 49 | 3.156 | 34116.3 |
813 | 2024-04-13 15:43:24 | gannets | 3 | 134027 | 592 | 7.280 | 18410.3 |
812 | 2024-04-13 08:27:57 | gannets | 2 | 107671 | 49 | 2.826 | 38100.1 |
811 | 2024-04-13 08:27:25 | gannets | 3 | 134027 | 592 | 6.470 | 20715.1 |
810 | 2024-04-12 14:19:33 | gannets | 1 | 69583 | 4 | 1.406 | 49490.0 |
809 | 2024-04-11 01:35:43 | gannets | 3 | 134027 | 592 | 7.533 | 17792.0 |
808 | 2024-04-10 10:06:29 | gannets | 2 | 107671 | 49 | 7.953 | 13538.4 |
807 | 2024-04-10 05:05:29 | gannets | 3 | 134027 | 592 | 8.250 | 16245.7 |
806 | 2024-04-09 03:04:00 | gannets | 3 | 134027 | 592 | 7.703 | 17399.3 |
805 | 2024-04-09 03:04:00 | gannets | 2 | 107671 | 49 | 3.753 | 28689.3 |
804 | 2024-04-09 01:02:16 | gannets | 1 | 69583 | 4 | 1.376 | 50569.0 |
803 | 2024-04-05 06:25:06 | gannets | 1 | 69583 | 4 | 1.783 | 39025.8 |
802 | 2024-04-01 16:31:09 | gannets | 1 | 69583 | 4 | 1.346 | 51696.1 |
801 | 2024-03-30 04:58:56 | gannets | 1 | 69583 | 4 | 1.796 | 38743.3 |
800 | 2024-03-18 22:31:57 | gannets | 3 | 134027 | 592 | 14.736 | 9095.2 |
799 | 2024-03-14 14:13:42 | gannets | 3 | 134027 | 592 | 15.783 | 8491.9 |
798 | 2024-03-13 18:01:54 | gannets | 2 | 107671 | 49 | 7.673 | 14032.5 |
797 | 2024-03-12 18:37:43 | gannets | 3 | 134027 | 592 | 18.080 | 7413.0 |
796 | 2024-03-11 21:39:37 | gannets | 3 | 134027 | 592 | 11.593 | 11561.0 |
795 | 2024-03-11 03:32:41 | gannets | 2 | 107671 | 49 | 4.716 | 22831.0 |
794 | 2024-03-11 03:32:11 | gannets | 3 | 134027 | 592 | 9.126 | 14686.3 |
793 | 2024-03-09 00:11:27 | gannets | 3 | 134027 | 592 | 8.283 | 16181.0 |
792 | 2024-03-09 00:11:26 | gannets | 2 | 107671 | 49 | 7.780 | 13839.5 |
791 | 2024-03-08 22:06:43 | gannets | 1 | 69583 | 4 | 1.296 | 53690.6 |
790 | 2024-02-07 01:52:25 | gannets | 1 | 69583 | 4 | 1.233 | 56433.9 |
789 | 2024-02-02 21:40:07 | gannets | 2 | 107671 | 49 | 3.280 | 32826.5 |
788 | 2024-02-02 20:59:43 | gannets | 3 | 134027 | 592 | 6.970 | 19229.1 |
787 | 2024-02-01 06:28:20 | gannets | 2 | 107671 | 49 | 3.330 | 32333.6 |
786 | 2024-02-01 06:26:39 | gannets | 3 | 134027 | 592 | 7.436 | 18024.1 |
785 | 2024-02-01 01:10:04 | gannets | 3 | 134027 | 592 | 10.033 | 13358.6 |
784 | 2024-02-01 01:10:00 | gannets | 2 | 107671 | 49 | 3.406 | 31612.2 |
783 | 2024-02-01 01:09:55 | gannets | 1 | 69583 | 4 | 2.356 | 29534.4 |
782 | 2024-01-12 20:43:50 | gannets | 3 | 134027 | 592 | 6.576 | 20381.2 |
781 | 2024-01-12 20:43:49 | gannets | 2 | 107671 | 49 | 3.423 | 31455.2 |
780 | 2024-01-07 02:49:40 | gannets | 1 | 69583 | 4 | 1.076 | 64668.2 |
779 | 2024-01-03 05:11:22 | gannets | 1 | 69583 | 4 | 1.220 | 57035.2 |
778 | 2024-01-01 17:39:15 | gannets | 1 | 69583 | 4 | 1.140 | 61037.7 |
777 | 2024-01-01 05:09:45 | gannets | 1 | 69583 | 4 | 1.093 | 63662.4 |
776 | 2023-11-22 12:54:50 | gannets | 1 | 69583 | 4 | 1.266 | 54962.9 |
775 | 2023-11-01 11:42:03 | gannets | 1 | 69583 | 4 | 1.096 | 63488.1 |
774 | 2023-10-31 15:07:04 | gannets | 1 | 69583 | 4 | 1.530 | 45479.1 |
773 | 2023-10-24 10:04:14 | gannets | 1 | 69583 | 4 | 1.173 | 59320.5 |
772 | 2023-10-23 08:33:45 | gannets | 3 | 134027 | 592 | 6.626 | 20227.4 |
771 | 2023-10-17 20:36:21 | gannets | 1 | 69583 | 4 | 1.156 | 60192.9 |
770 | 2023-09-29 17:59:10 | gannets | 1 | 69583 | 4 | 1.126 | 61796.6 |
769 | 2023-09-07 19:04:53 | gannets | 1 | 69583 | 4 | 1.250 | 55666.4 |
768 | 2023-09-03 14:22:51 | gannets | 3 | 134027 | 592 | 6.986 | 19185.1 |
767 | 2023-09-02 16:57:21 | gannets | 3 | 134027 | 592 | 5.796 | 23124.1 |
766 | 2023-08-31 14:44:53 | gannets | 3 | 134027 | 592 | 5.626 | 23822.8 |
765 | 2023-08-30 22:44:54 | gannets | 3 | 134027 | 592 | 5.983 | 22401.3 |
764 | 2023-08-19 07:22:28 | gannets | 1 | 69583 | 4 | 1.143 | 60877.5 |
763 | 2023-07-17 10:59:38 | gannets | 1 | 69583 | 4 | 1.110 | 62687.4 |
762 | 2023-06-23 08:21:09 | gannets | 3 | 134027 | 592 | 6.576 | 20381.2 |
761 | 2023-06-20 04:12:21 | gannets | 3 | 134027 | 592 | 5.670 | 23637.9 |
760 | 2023-06-15 21:11:28 | gannets | 3 | 134027 | 592 | 5.750 | 23309.0 |
759 | 2023-06-13 20:09:44 | gannets | 3 | 134027 | 592 | 6.733 | 19906.0 |
758 | 2023-05-25 03:40:42 | gannets | 1 | 69583 | 4 | 1.140 | 61037.7 |
757 | 2023-05-21 19:44:21 | gannets | 1 | 69583 | 4 | 1.156 | 60192.9 |
756 | 2023-05-21 08:15:03 | gannets | 1 | 69583 | 4 | 1.076 | 64668.2 |
755 | 2023-03-16 22:33:19 | gannets | 1 | 69583 | 4 | 1.156 | 60192.9 |
754 | 2023-02-05 00:50:32 | gannets | 1 | 69583 | 4 | 1.233 | 56433.9 |
753 | 2023-01-05 00:27:10 | gannets | 1 | 69583 | 4 | 1.046 | 66522.9 |
752 | 2022-10-22 06:26:54 | gannets | 1 | 69583 | 4 | 1.280 | 54361.7 |
751 | 2022-09-30 17:54:00 | gannets | 1 | 69583 | 4 | 1.093 | 63662.4 |
750 | 2022-09-04 19:36:14 | gannets | 1 | 69583 | 4 | 1.063 | 65459.1 |
749 | 2022-08-08 03:55:24 | gannets | 1 | 69583 | 4 | 1.220 | 57035.2 |
748 | 2022-07-02 08:35:31 | gannets | 1 | 69583 | 4 | 1.060 | 65644.3 |
747 | 2022-05-23 07:43:11 | gannets | 1 | 69583 | 4 | 1.173 | 59320.5 |
746 | 2022-05-15 20:42:31 | gannets | 1 | 69583 | 4 | 1.076 | 64668.2 |
745 | 2022-05-13 17:47:24 | gannets | 1 | 69583 | 4 | 1.390 | 50059.7 |
744 | 2022-05-11 12:04:38 | gannets | 3 | 134027 | 592 | 7.376 | 18170.7 |
743 | 2022-05-10 22:36:26 | gannets | 3 | 134027 | 592 | 6.953 | 19276.1 |
742 | 2022-05-10 14:26:38 | gannets | 3 | 134027 | 592 | 6.483 | 20673.6 |
741 | 2022-05-10 03:19:46 | gannets | 3 | 134027 | 592 | 7.596 | 17644.4 |
740 | 2022-05-09 10:45:25 | gannets | 3 | 134027 | 592 | 6.813 | 19672.2 |
739 | 2022-05-08 06:17:30 | gannets | 3 | 134027 | 592 | 7.953 | 16852.4 |
738 | 2022-05-07 14:58:33 | gannets | 3 | 134027 | 592 | 6.190 | 21652.2 |
737 | 2022-05-03 07:10:08 | gannets | 3 | 134027 | 592 | 5.653 | 23709.0 |
736 | 2022-05-02 08:20:00 | gannets | 3 | 134027 | 592 | 5.733 | 23378.2 |
735 | 2022-05-01 15:23:15 | gannets | 3 | 134027 | 592 | 6.106 | 21950.0 |
734 | 2022-04-30 16:43:25 | gannets | 3 | 134027 | 592 | 5.736 | 23365.9 |
733 | 2022-04-30 04:10:15 | gannets | 3 | 134027 | 592 | 6.656 | 20136.3 |
732 | 2022-04-29 14:30:26 | gannets | 3 | 134027 | 592 | 6.830 | 19623.3 |
731 | 2022-04-29 02:42:12 | gannets | 3 | 134027 | 592 | 7.516 | 17832.2 |
730 | 2022-04-28 17:47:48 | gannets | 3 | 134027 | 592 | 7.376 | 18170.7 |
729 | 2022-04-28 04:10:00 | gannets | 3 | 134027 | 592 | 6.550 | 20462.1 |
728 | 2022-04-27 12:25:50 | gannets | 3 | 134027 | 592 | 7.500 | 17870.3 |
727 | 2022-04-26 15:30:40 | gannets | 3 | 134027 | 592 | 7.560 | 17728.4 |
726 | 2022-04-26 03:37:13 | gannets | 3 | 134027 | 592 | 6.216 | 21561.6 |
725 | 2022-04-25 20:07:30 | gannets | 1 | 69583 | 4 | 1.313 | 52995.4 |
724 | 2022-04-25 13:26:12 | gannets | 3 | 134027 | 592 | 6.686 | 20045.9 |
723 | 2022-04-24 21:19:19 | gannets | 3 | 134027 | 592 | 5.673 | 23625.4 |
722 | 2022-04-24 02:47:35 | gannets | 3 | 134027 | 592 | 6.576 | 20381.2 |
721 | 2022-04-23 10:39:52 | gannets | 3 | 134027 | 592 | 5.686 | 23571.4 |
720 | 2022-04-22 13:59:14 | gannets | 3 | 134027 | 592 | 7.670 | 17474.2 |
719 | 2022-04-21 18:24:32 | gannets | 3 | 134027 | 592 | 6.546 | 20474.6 |
718 | 2022-04-21 05:01:56 | gannets | 3 | 134027 | 592 | 7.296 | 18369.9 |
717 | 2022-04-20 07:21:03 | gannets | 3 | 134027 | 592 | 6.080 | 22043.9 |
716 | 2022-04-19 18:29:56 | gannets | 3 | 134027 | 592 | 5.830 | 22989.2 |
715 | 2022-04-19 04:49:12 | gannets | 3 | 134027 | 592 | 7.296 | 18369.9 |