History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pattie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
804 | 2024-05-07 16:09:40 | pattie | 1 | 48755 | 8 | 2.263 | 21544.4 |
803 | 2024-05-01 20:42:21 | pattie | 3 | 112716 | 763 | 6.986 | 16134.6 |
802 | 2024-04-29 09:46:25 | pattie | 2 | 82551 | 80 | 4.623 | 17856.6 |
801 | 2024-04-29 09:46:00 | pattie | 3 | 112716 | 763 | 6.220 | 18121.5 |
800 | 2024-04-29 09:46:02 | pattie | 2 | 82551 | 80 | 2.940 | 28078.6 |
799 | 2024-04-29 09:45:51 | pattie | 1 | 48755 | 8 | 1.000 | 48755.0 |
798 | 2024-04-29 09:45:15 | pattie | 3 | 112716 | 763 | 9.096 | 12391.8 |
797 | 2024-04-29 05:09:06 | pattie | 3 | 112716 | 763 | 5.703 | 19764.3 |
796 | 2024-04-23 23:34:46 | pattie | 1 | 48755 | 8 | 0.923 | 52822.3 |
795 | 2024-04-06 08:42:10 | pattie | 1 | 48755 | 8 | 2.986 | 16327.9 |
794 | 2024-03-07 15:39:49 | pattie | 1 | 48755 | 8 | 1.453 | 33554.7 |
793 | 2024-02-28 09:36:15 | pattie | 1 | 48755 | 8 | 1.953 | 24964.2 |
792 | 2024-01-24 18:01:44 | pattie | 1 | 48755 | 8 | 0.856 | 56956.8 |
791 | 2023-12-20 15:50:40 | pattie | 3 | 112716 | 763 | 5.373 | 20978.2 |
790 | 2023-12-16 06:11:14 | pattie | 1 | 48755 | 8 | 0.860 | 56691.9 |
789 | 2023-12-13 06:43:07 | pattie | 1 | 48755 | 8 | 0.890 | 54780.9 |
788 | 2023-12-12 04:51:09 | pattie | 1 | 48755 | 8 | 0.766 | 63648.8 |
787 | 2023-12-07 14:54:02 | pattie | 2 | 82551 | 80 | 2.563 | 32208.7 |
786 | 2023-12-07 14:53:59 | pattie | 2 | 82551 | 80 | 2.626 | 31436.0 |
785 | 2023-12-06 22:42:16 | pattie | 3 | 112716 | 763 | 5.656 | 19928.6 |
784 | 2023-12-06 22:42:13 | pattie | 2 | 82551 | 80 | 2.593 | 31836.1 |
783 | 2023-11-19 10:13:19 | pattie | 1 | 48755 | 8 | 0.860 | 56691.9 |
782 | 2023-11-11 07:34:06 | pattie | 1 | 48755 | 8 | 0.843 | 57835.1 |
781 | 2023-11-04 19:08:25 | pattie | 1 | 48755 | 8 | 0.843 | 57835.1 |
780 | 2023-10-24 01:54:53 | pattie | 1 | 48755 | 8 | 0.783 | 62266.9 |
779 | 2023-10-18 10:15:11 | pattie | 1 | 48755 | 8 | 0.843 | 57835.1 |
778 | 2023-10-11 05:45:02 | pattie | 1 | 48755 | 8 | 0.920 | 52994.6 |
777 | 2023-10-07 01:26:17 | pattie | 1 | 48755 | 8 | 0.860 | 56691.9 |
776 | 2023-10-07 01:15:07 | pattie | 3 | 112716 | 763 | 6.673 | 16891.4 |
775 | 2023-10-01 03:52:38 | pattie | 3 | 112716 | 763 | 6.890 | 16359.4 |
774 | 2023-09-28 00:34:41 | pattie | 3 | 112716 | 763 | 9.736 | 11577.2 |
773 | 2023-09-26 17:40:39 | pattie | 1 | 48755 | 8 | 0.906 | 53813.5 |
772 | 2023-09-26 11:45:21 | pattie | 1 | 48755 | 8 | 0.843 | 57835.1 |
771 | 2023-09-20 11:36:46 | pattie | 3 | 112716 | 763 | 4.686 | 24053.8 |
770 | 2023-09-14 09:05:50 | pattie | 1 | 48755 | 8 | 0.890 | 54780.9 |
769 | 2023-08-20 07:43:39 | pattie | 1 | 48755 | 8 | 0.750 | 65006.7 |
768 | 2023-08-16 22:50:19 | pattie | 1 | 48755 | 8 | 0.890 | 54780.9 |
767 | 2023-08-10 18:41:34 | pattie | 3 | 112716 | 763 | 5.550 | 20309.2 |
766 | 2023-07-23 01:33:05 | pattie | 1 | 48755 | 8 | 0.780 | 62506.4 |
765 | 2023-06-28 08:49:38 | pattie | 3 | 112716 | 763 | 4.860 | 23192.6 |
764 | 2023-05-06 09:08:20 | pattie | 1 | 48755 | 8 | 0.733 | 66514.3 |
763 | 2023-04-22 19:32:37 | pattie | 1 | 48755 | 8 | 0.876 | 55656.4 |
762 | 2023-03-21 16:43:11 | pattie | 3 | 112716 | 763 | 4.703 | 23966.8 |
761 | 2023-02-11 10:32:44 | pattie | 1 | 48755 | 8 | 0.763 | 63899.1 |
760 | 2023-01-20 08:21:34 | pattie | 1 | 48755 | 8 | 0.873 | 55847.7 |
759 | 2022-12-21 05:07:05 | pattie | 3 | 112716 | 763 | 5.423 | 20784.8 |
758 | 2022-12-19 23:40:37 | pattie | 3 | 112716 | 763 | 4.720 | 23880.5 |
757 | 2022-12-08 20:12:05 | pattie | 1 | 48755 | 8 | 0.750 | 65006.7 |
756 | 2022-12-04 13:25:24 | pattie | 3 | 112716 | 763 | 5.360 | 21029.1 |
755 | 2022-11-21 19:44:16 | pattie | 3 | 112716 | 763 | 5.140 | 21929.2 |
754 | 2022-11-09 12:45:00 | pattie | 3 | 112716 | 763 | 4.813 | 23419.1 |
753 | 2022-11-07 22:52:32 | pattie | 3 | 112716 | 763 | 5.796 | 19447.2 |
752 | 2022-10-11 07:30:15 | pattie | 3 | 112716 | 763 | 6.203 | 18171.2 |
751 | 2022-10-02 13:37:57 | pattie | 1 | 48755 | 8 | 0.796 | 61250.0 |
750 | 2022-08-29 10:13:53 | pattie | 3 | 112716 | 763 | 4.826 | 23356.0 |
749 | 2022-08-17 13:10:51 | pattie | 3 | 112716 | 763 | 4.876 | 23116.5 |
748 | 2022-08-11 19:46:45 | pattie | 1 | 48755 | 8 | 0.750 | 65006.7 |
747 | 2022-06-15 14:25:13 | pattie | 1 | 48755 | 8 | 0.830 | 58741.0 |
746 | 2022-06-14 00:22:40 | pattie | 3 | 112716 | 763 | 5.106 | 22075.2 |
745 | 2022-05-21 04:35:28 | pattie | 3 | 112716 | 763 | 5.280 | 21347.7 |
744 | 2022-04-27 20:54:53 | pattie | 2 | 82551 | 80 | 2.606 | 31677.3 |
743 | 2022-04-27 04:23:29 | pattie | 2 | 82551 | 80 | 2.390 | 34540.2 |
742 | 2022-04-26 22:09:02 | pattie | 3 | 112716 | 763 | 5.656 | 19928.6 |
741 | 2022-04-26 16:57:27 | pattie | 2 | 82551 | 80 | 2.313 | 35690.0 |
740 | 2022-04-26 04:57:28 | pattie | 2 | 82551 | 80 | 2.440 | 33832.4 |
739 | 2022-04-25 13:44:51 | pattie | 2 | 82551 | 80 | 2.453 | 33653.1 |
738 | 2022-04-25 01:21:19 | pattie | 2 | 82551 | 80 | 2.233 | 36968.7 |
737 | 2022-04-24 17:17:43 | pattie | 2 | 82551 | 80 | 2.233 | 36968.7 |
736 | 2022-04-23 18:33:32 | pattie | 2 | 82551 | 80 | 2.190 | 37694.5 |
735 | 2022-04-22 23:38:53 | pattie | 2 | 82551 | 80 | 3.170 | 26041.3 |
734 | 2022-04-22 05:45:50 | pattie | 2 | 82551 | 80 | 2.440 | 33832.4 |
733 | 2022-04-21 14:36:24 | pattie | 2 | 82551 | 80 | 2.970 | 27794.9 |
732 | 2022-04-20 09:37:17 | pattie | 2 | 82551 | 80 | 2.906 | 28407.1 |
731 | 2022-04-19 20:32:45 | pattie | 2 | 82551 | 80 | 2.653 | 31116.1 |
730 | 2022-04-19 06:15:12 | pattie | 2 | 82551 | 80 | 2.266 | 36430.3 |
729 | 2022-04-18 04:15:56 | pattie | 2 | 82551 | 80 | 2.736 | 30172.1 |
728 | 2022-04-17 18:00:52 | pattie | 2 | 82551 | 80 | 2.250 | 36689.3 |
727 | 2022-04-16 15:50:55 | pattie | 2 | 82551 | 80 | 2.716 | 30394.3 |
726 | 2022-04-08 16:18:35 | pattie | 2 | 82551 | 80 | 2.546 | 32423.8 |
725 | 2022-04-08 00:16:57 | pattie | 2 | 82551 | 80 | 2.403 | 34353.3 |
724 | 2022-04-07 09:13:30 | pattie | 2 | 82551 | 80 | 2.893 | 28534.7 |
723 | 2022-04-06 15:30:59 | pattie | 2 | 82551 | 80 | 2.626 | 31436.0 |
722 | 2022-04-05 23:07:55 | pattie | 2 | 82551 | 80 | 2.563 | 32208.7 |
721 | 2022-04-05 11:02:39 | pattie | 2 | 82551 | 80 | 2.513 | 32849.6 |
720 | 2022-04-04 16:32:53 | pattie | 2 | 82551 | 80 | 3.126 | 26407.9 |
719 | 2022-04-03 18:36:17 | pattie | 2 | 82551 | 80 | 2.170 | 38041.9 |
718 | 2022-04-02 21:34:47 | pattie | 2 | 82551 | 80 | 2.140 | 38575.2 |
717 | 2022-04-01 22:41:05 | pattie | 2 | 82551 | 80 | 2.360 | 34979.2 |
716 | 2022-04-01 07:10:41 | pattie | 2 | 82551 | 80 | 2.470 | 33421.5 |
715 | 2022-03-31 22:50:49 | pattie | 1 | 48755 | 8 | 0.953 | 51159.5 |
714 | 2022-03-31 17:27:53 | pattie | 2 | 82551 | 80 | 2.343 | 35233.0 |
713 | 2022-03-30 19:12:54 | pattie | 2 | 82551 | 80 | 3.046 | 27101.4 |
712 | 2022-03-30 07:17:36 | pattie | 2 | 82551 | 80 | 2.453 | 33653.1 |
711 | 2022-03-29 16:34:34 | pattie | 2 | 82551 | 80 | 3.390 | 24351.3 |
710 | 2022-03-29 04:08:31 | pattie | 2 | 82551 | 80 | 2.546 | 32423.8 |
709 | 2022-03-28 05:01:18 | pattie | 2 | 82551 | 80 | 2.203 | 37472.1 |
708 | 2022-03-27 12:57:38 | pattie | 2 | 82551 | 80 | 2.250 | 36689.3 |
707 | 2022-03-26 18:12:49 | pattie | 2 | 82551 | 80 | 2.170 | 38041.9 |
706 | 2022-03-25 23:20:31 | pattie | 2 | 82551 | 80 | 2.330 | 35429.6 |
705 | 2022-03-19 20:45:52 | pattie | 2 | 82551 | 80 | 2.500 | 33020.4 |