History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefile"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
851 | 2024-05-31 22:50:18 | prefile | 3 | 134027 | 349 | 12.500 | 10722.2 |
850 | 2024-05-30 23:50:57 | prefile | 3 | 134027 | 349 | 7.563 | 17721.4 |
849 | 2024-05-29 23:43:38 | prefile | 3 | 134027 | 349 | 23.063 | 5811.3 |
848 | 2024-05-28 23:56:52 | prefile | 3 | 134027 | 349 | 23.126 | 5795.5 |
847 | 2024-05-28 15:25:08 | prefile | 3 | 134027 | 349 | 21.843 | 6135.9 |
846 | 2024-05-26 22:28:24 | prefile | 3 | 134027 | 349 | 12.750 | 10511.9 |
845 | 2024-05-25 16:02:22 | prefile | 3 | 134027 | 349 | 16.643 | 8053.1 |
844 | 2024-05-23 17:45:16 | prefile | 3 | 134027 | 349 | 18.113 | 7399.5 |
843 | 2024-05-22 18:13:29 | prefile | 3 | 134027 | 349 | 22.300 | 6010.2 |
842 | 2024-05-21 16:31:42 | prefile | 3 | 134027 | 349 | 8.360 | 16031.9 |
841 | 2024-05-19 22:25:06 | prefile | 3 | 134027 | 349 | 16.173 | 8287.1 |
840 | 2024-05-18 17:43:45 | prefile | 3 | 134027 | 349 | 12.250 | 10941.0 |
839 | 2024-05-16 11:11:35 | prefile | 2 | 107671 | 41 | 7.203 | 14948.1 |
838 | 2024-05-14 21:58:44 | prefile | 2 | 107671 | 41 | 11.843 | 9091.5 |
837 | 2024-05-14 21:02:12 | prefile | 1 | 69583 | 6 | 1.420 | 49002.1 |
836 | 2024-05-14 18:17:23 | prefile | 3 | 134027 | 349 | 6.670 | 20094.0 |
835 | 2024-05-14 03:40:59 | prefile | 2 | 107671 | 41 | 3.576 | 30109.3 |
834 | 2024-05-14 03:40:40 | prefile | 3 | 134027 | 349 | 6.983 | 19193.3 |
833 | 2024-05-13 19:59:08 | prefile | 3 | 134027 | 349 | 9.546 | 14040.1 |
832 | 2024-05-12 23:39:43 | prefile | 3 | 134027 | 349 | 15.690 | 8542.2 |
831 | 2024-05-12 00:01:58 | prefile | 3 | 134027 | 349 | 19.813 | 6764.6 |
830 | 2024-05-11 14:04:12 | prefile | 3 | 134027 | 349 | 20.846 | 6429.4 |
829 | 2024-05-11 02:51:11 | prefile | 3 | 134027 | 349 | 12.940 | 10357.6 |
828 | 2024-05-10 20:56:22 | prefile | 3 | 134027 | 349 | 14.033 | 9550.8 |
827 | 2024-05-09 20:12:11 | prefile | 2 | 107671 | 41 | 3.983 | 27032.6 |
826 | 2024-05-09 20:11:50 | prefile | 3 | 134027 | 349 | 8.406 | 15944.2 |
825 | 2024-05-09 11:57:20 | prefile | 3 | 134027 | 349 | 16.906 | 7927.8 |
824 | 2024-05-08 23:20:51 | prefile | 3 | 134027 | 349 | 13.156 | 10187.5 |
823 | 2024-05-08 19:43:08 | prefile | 3 | 134027 | 349 | 17.186 | 7798.6 |
822 | 2024-05-07 16:53:07 | prefile | 1 | 69583 | 6 | 2.470 | 28171.3 |
821 | 2024-04-27 23:35:47 | prefile | 1 | 69583 | 6 | 3.123 | 22280.8 |
820 | 2024-04-10 11:23:30 | prefile | 3 | 134027 | 349 | 12.080 | 11095.0 |
819 | 2024-04-10 08:24:53 | prefile | 3 | 134027 | 349 | 14.796 | 9058.3 |
818 | 2024-03-18 21:44:12 | prefile | 2 | 107671 | 41 | 7.016 | 15346.5 |
817 | 2024-03-18 21:43:49 | prefile | 3 | 134027 | 349 | 7.156 | 18729.3 |
816 | 2024-03-18 19:25:32 | prefile | 2 | 107671 | 41 | 6.533 | 16481.1 |
815 | 2024-03-18 19:24:05 | prefile | 3 | 134027 | 349 | 6.563 | 20421.6 |
814 | 2024-03-18 06:30:53 | prefile | 2 | 107671 | 41 | 6.313 | 17055.4 |
813 | 2024-03-18 06:29:48 | prefile | 3 | 134027 | 349 | 9.216 | 14542.9 |
812 | 2024-03-18 02:40:33 | prefile | 3 | 134027 | 349 | 7.533 | 17792.0 |
811 | 2024-03-13 17:15:42 | prefile | 3 | 134027 | 349 | 8.766 | 15289.4 |
810 | 2024-02-09 09:28:49 | prefile | 1 | 69583 | 6 | 1.060 | 65644.3 |
809 | 2024-01-29 12:53:56 | prefile | 2 | 107671 | 41 | 3.610 | 29825.8 |
808 | 2024-01-27 11:55:57 | prefile | 2 | 107671 | 41 | 3.623 | 29718.7 |
807 | 2024-01-22 09:29:56 | prefile | 3 | 134027 | 349 | 6.360 | 21073.4 |
806 | 2024-01-13 16:50:49 | prefile | 1 | 69583 | 6 | 1.156 | 60192.9 |
805 | 2024-01-02 04:32:12 | prefile | 3 | 134027 | 349 | 6.080 | 22043.9 |
804 | 2023-12-05 23:00:09 | prefile | 2 | 107671 | 41 | 3.453 | 31181.9 |
803 | 2023-11-30 17:39:10 | prefile | 3 | 134027 | 349 | 5.796 | 23124.1 |
802 | 2023-11-19 04:15:55 | prefile | 1 | 69583 | 6 | 1.170 | 59472.6 |
801 | 2023-11-15 19:50:08 | prefile | 1 | 69583 | 6 | 1.096 | 63488.1 |
800 | 2023-11-14 08:17:58 | prefile | 1 | 69583 | 6 | 1.156 | 60192.9 |
799 | 2023-11-09 10:54:14 | prefile | 1 | 69583 | 6 | 1.093 | 63662.4 |
798 | 2023-11-07 10:15:23 | prefile | 2 | 107671 | 41 | 3.233 | 33303.7 |
797 | 2023-11-05 07:14:05 | prefile | 1 | 69583 | 6 | 1.063 | 65459.1 |
796 | 2023-10-18 09:04:55 | prefile | 1 | 69583 | 6 | 1.170 | 59472.6 |
795 | 2023-10-10 11:48:08 | prefile | 1 | 69583 | 6 | 2.373 | 29322.8 |
794 | 2023-10-07 03:33:33 | prefile | 1 | 69583 | 6 | 1.186 | 58670.3 |
793 | 2023-09-29 05:03:11 | prefile | 1 | 69583 | 6 | 1.186 | 58670.3 |
792 | 2023-09-16 23:37:39 | prefile | 1 | 69583 | 6 | 1.190 | 58473.1 |
791 | 2023-09-02 20:58:07 | prefile | 3 | 134027 | 349 | 6.860 | 19537.5 |
790 | 2023-08-29 23:55:24 | prefile | 1 | 69583 | 6 | 1.093 | 63662.4 |
789 | 2023-08-29 21:06:04 | prefile | 3 | 134027 | 349 | 13.470 | 9950.0 |
788 | 2023-08-10 21:06:35 | prefile | 2 | 107671 | 41 | 2.986 | 36058.6 |
787 | 2023-06-20 03:28:26 | prefile | 1 | 69583 | 6 | 1.250 | 55666.4 |
786 | 2023-06-02 04:01:27 | prefile | 1 | 69583 | 6 | 1.063 | 65459.1 |
785 | 2023-05-17 00:50:15 | prefile | 3 | 134027 | 349 | 5.810 | 23068.3 |
784 | 2023-04-21 05:58:32 | prefile | 2 | 107671 | 41 | 2.846 | 37832.4 |
783 | 2023-03-30 10:43:07 | prefile | 3 | 134027 | 349 | 6.750 | 19855.9 |
782 | 2023-03-26 11:18:06 | prefile | 1 | 69583 | 6 | 1.063 | 65459.1 |
781 | 2023-03-01 05:34:42 | prefile | 1 | 69583 | 6 | 1.043 | 66714.3 |
780 | 2023-02-22 23:54:12 | prefile | 3 | 134027 | 349 | 5.733 | 23378.2 |
779 | 2023-02-15 04:48:00 | prefile | 3 | 134027 | 349 | 6.533 | 20515.4 |
778 | 2023-01-28 13:43:52 | prefile | 2 | 107671 | 41 | 2.813 | 38276.2 |
777 | 2023-01-09 23:41:51 | prefile | 1 | 69583 | 6 | 1.063 | 65459.1 |
776 | 2023-01-04 00:55:03 | prefile | 3 | 134027 | 349 | 5.813 | 23056.4 |
775 | 2022-12-31 16:12:38 | prefile | 3 | 134027 | 349 | 6.483 | 20673.6 |
774 | 2022-12-28 13:00:15 | prefile | 2 | 107671 | 41 | 3.186 | 33795.0 |
773 | 2022-12-26 20:21:49 | prefile | 3 | 134027 | 349 | 9.173 | 14611.0 |
772 | 2022-12-22 23:54:12 | prefile | 3 | 134027 | 349 | 5.720 | 23431.3 |
771 | 2022-12-09 08:32:00 | prefile | 3 | 134027 | 349 | 13.033 | 10283.7 |
770 | 2022-12-08 18:20:30 | prefile | 3 | 134027 | 349 | 10.313 | 12995.9 |
769 | 2022-12-04 17:09:08 | prefile | 3 | 134027 | 349 | 6.940 | 19312.2 |
768 | 2022-12-02 22:42:50 | prefile | 3 | 134027 | 349 | 5.706 | 23488.8 |
767 | 2022-11-25 07:10:37 | prefile | 3 | 134027 | 349 | 6.360 | 21073.4 |
766 | 2022-11-20 07:25:42 | prefile | 3 | 134027 | 349 | 6.860 | 19537.5 |
765 | 2022-11-16 00:51:51 | prefile | 1 | 69583 | 6 | 1.216 | 57222.9 |
764 | 2022-11-10 20:47:12 | prefile | 2 | 107671 | 41 | 2.843 | 37872.3 |
763 | 2022-10-12 02:05:47 | prefile | 1 | 69583 | 6 | 1.076 | 64668.2 |
762 | 2022-09-04 00:00:52 | prefile | 1 | 69583 | 6 | 1.063 | 65459.1 |
761 | 2022-09-03 16:22:57 | prefile | 3 | 134027 | 349 | 6.250 | 21444.3 |
760 | 2022-08-28 13:15:16 | prefile | 1 | 69583 | 6 | 1.080 | 64428.7 |
759 | 2022-07-25 14:55:49 | prefile | 3 | 134027 | 349 | 6.013 | 22289.5 |
758 | 2022-07-23 04:12:15 | prefile | 1 | 69583 | 6 | 1.063 | 65459.1 |
757 | 2022-07-15 04:18:56 | prefile | 3 | 134027 | 349 | 6.143 | 21817.8 |
756 | 2022-06-03 21:26:59 | prefile | 2 | 107671 | 41 | 2.826 | 38100.1 |
755 | 2022-05-31 21:35:03 | prefile | 1 | 69583 | 6 | 1.236 | 56296.9 |
754 | 2022-05-11 08:02:30 | prefile | 3 | 134027 | 349 | 6.046 | 22167.9 |
753 | 2022-05-11 07:06:39 | prefile | 3 | 134027 | 349 | 5.830 | 22989.2 |
752 | 2022-05-10 20:15:33 | prefile | 3 | 134027 | 349 | 6.516 | 20568.9 |