History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
867 | 2025-07-15 21:29:24 | affect | 1 | 48755 | 3 | 0.890 | 54780.9 |
866 | 2025-07-15 14:53:26 | affect | 1 | 48755 | 3 | 4.500 | 10834.4 |
865 | 2025-07-14 16:17:50 | affect | 3 | 112716 | 174 | 28.203 | 3996.6 |
864 | 2025-07-14 05:55:37 | affect | 3 | 112716 | 174 | 15.386 | 7325.9 |
863 | 2025-07-10 16:37:28 | affect | 3 | 112716 | 174 | 32.720 | 3444.9 |
862 | 2025-07-10 15:15:42 | affect | 1 | 48755 | 3 | 3.906 | 12482.1 |
861 | 2025-07-07 19:36:40 | affect | 1 | 48755 | 3 | 0.876 | 55656.4 |
860 | 2025-07-07 05:24:21 | affect | 1 | 48755 | 3 | 5.906 | 8255.2 |
859 | 2025-06-29 15:56:37 | affect | 2 | 82551 | 15 | 11.376 | 7256.6 |
858 | 2025-06-29 06:54:04 | affect | 1 | 48755 | 3 | 4.360 | 11182.3 |
857 | 2025-06-25 07:02:28 | affect | 2 | 82551 | 15 | 16.830 | 4905.0 |
856 | 2025-06-22 15:33:51 | affect | 1 | 48755 | 3 | 4.423 | 11023.1 |
855 | 2025-06-20 11:11:59 | affect | 2 | 82551 | 15 | 3.860 | 21386.3 |
854 | 2025-06-20 08:52:46 | affect | 1 | 48755 | 3 | 2.546 | 19149.6 |
853 | 2025-06-19 16:23:37 | affect | 1 | 48755 | 3 | 1.763 | 27654.6 |
852 | 2025-06-18 09:35:40 | affect | 1 | 48755 | 3 | 1.983 | 24586.5 |
851 | 2025-06-17 01:55:45 | affect | 1 | 48755 | 3 | 4.406 | 11065.6 |
850 | 2025-06-10 10:14:14 | affect | 1 | 48755 | 3 | 4.016 | 12140.2 |
849 | 2025-06-08 04:15:12 | affect | 2 | 82551 | 15 | 10.860 | 7601.4 |
848 | 2025-06-07 00:46:59 | affect | 2 | 82551 | 15 | 2.673 | 30883.3 |
847 | 2025-06-04 05:18:53 | affect | 1 | 48755 | 3 | 4.046 | 12050.2 |
846 | 2025-06-04 02:04:04 | affect | 3 | 112716 | 174 | 13.890 | 8114.9 |
845 | 2025-06-03 01:17:20 | affect | 1 | 48755 | 3 | 3.703 | 13166.4 |
844 | 2025-06-02 22:19:08 | affect | 2 | 82551 | 15 | 2.390 | 34540.2 |
843 | 2025-05-31 10:24:48 | affect | 3 | 112716 | 174 | 25.550 | 4411.6 |
842 | 2025-05-29 10:04:37 | affect | 3 | 112716 | 174 | 21.810 | 5168.1 |
841 | 2025-05-29 06:40:54 | affect | 1 | 48755 | 3 | 4.186 | 11647.2 |
840 | 2025-05-29 04:57:03 | affect | 3 | 112716 | 174 | 22.250 | 5065.9 |
839 | 2025-05-27 02:31:34 | affect | 3 | 112716 | 174 | 26.563 | 4243.3 |
838 | 2025-05-26 13:26:18 | affect | 3 | 112716 | 174 | 19.986 | 5639.7 |
837 | 2025-05-25 06:46:46 | affect | 2 | 82551 | 15 | 2.563 | 32208.7 |
836 | 2025-05-21 12:02:21 | affect | 2 | 82551 | 15 | 2.580 | 31996.5 |
835 | 2025-05-20 07:25:20 | affect | 1 | 48755 | 3 | 6.750 | 7223.0 |
834 | 2025-05-13 15:54:15 | affect | 2 | 82551 | 15 | 14.763 | 5591.7 |
833 | 2025-05-11 17:26:05 | affect | 1 | 48755 | 3 | 0.893 | 54596.9 |
832 | 2025-05-11 09:47:11 | affect | 1 | 48755 | 3 | 3.936 | 12386.9 |
831 | 2025-05-10 14:07:00 | affect | 2 | 82551 | 15 | 7.656 | 10782.5 |
830 | 2025-05-09 10:00:48 | affect | 1 | 48755 | 3 | 0.920 | 52994.6 |
829 | 2025-05-08 13:11:41 | affect | 1 | 48755 | 3 | 4.346 | 11218.4 |
828 | 2025-04-30 05:34:15 | affect | 1 | 48755 | 3 | 4.266 | 11428.7 |
827 | 2025-04-28 06:59:29 | affect | 1 | 48755 | 3 | 2.140 | 22782.7 |
826 | 2025-04-26 17:46:51 | affect | 3 | 112716 | 174 | 26.440 | 4263.1 |
825 | 2025-04-22 06:08:05 | affect | 2 | 82551 | 15 | 2.690 | 30688.1 |
824 | 2025-04-20 06:16:47 | affect | 1 | 48755 | 3 | 4.673 | 10433.3 |
823 | 2025-04-17 10:06:10 | affect | 2 | 82551 | 15 | 7.906 | 10441.6 |
822 | 2025-04-15 18:20:22 | affect | 3 | 112716 | 174 | 7.826 | 14402.8 |
821 | 2025-04-15 11:03:17 | affect | 3 | 112716 | 174 | 29.006 | 3886.0 |
820 | 2025-04-14 02:15:27 | affect | 3 | 112716 | 174 | 25.843 | 4361.6 |
819 | 2025-04-12 01:54:45 | affect | 3 | 112716 | 174 | 29.660 | 3800.3 |
818 | 2025-04-11 10:03:39 | affect | 3 | 112716 | 174 | 14.030 | 8033.9 |
817 | 2025-04-11 05:11:17 | affect | 3 | 112716 | 174 | 25.846 | 4361.1 |
816 | 2025-04-09 15:15:06 | affect | 3 | 112716 | 174 | 14.720 | 7657.3 |
815 | 2025-04-08 09:59:41 | affect | 1 | 48755 | 3 | 0.780 | 62506.4 |
814 | 2025-04-08 09:24:41 | affect | 1 | 48755 | 3 | 1.266 | 38511.1 |
813 | 2025-04-07 13:41:32 | affect | 1 | 48755 | 3 | 1.606 | 30358.0 |
812 | 2025-04-06 12:52:22 | affect | 1 | 48755 | 3 | 2.500 | 19502.0 |
811 | 2025-04-01 02:42:22 | affect | 1 | 48755 | 3 | 2.190 | 22262.6 |
810 | 2025-03-25 15:40:15 | affect | 3 | 112716 | 174 | 14.376 | 7840.6 |
809 | 2025-03-20 07:00:32 | affect | 1 | 48755 | 3 | 2.563 | 19022.6 |
808 | 2025-03-14 12:04:08 | affect | 1 | 48755 | 3 | 0.736 | 66243.2 |
807 | 2025-03-12 20:36:18 | affect | 1 | 48755 | 3 | 1.296 | 37619.6 |
806 | 2025-03-10 05:16:37 | affect | 3 | 112716 | 174 | 19.500 | 5780.3 |
805 | 2025-03-08 07:53:17 | affect | 3 | 112716 | 174 | 43.690 | 2579.9 |
804 | 2025-03-07 06:54:47 | affect | 2 | 82551 | 15 | 13.266 | 6222.7 |
803 | 2025-03-07 06:54:31 | affect | 1 | 48755 | 3 | 3.860 | 12630.8 |
802 | 2025-03-07 04:55:56 | affect | 3 | 112716 | 174 | 20.376 | 5531.8 |
801 | 2025-03-04 02:48:28 | affect | 3 | 112716 | 174 | 27.440 | 4107.7 |
800 | 2025-03-03 15:15:14 | affect | 3 | 112716 | 174 | 26.363 | 4275.5 |
799 | 2025-03-03 15:15:10 | affect | 2 | 82551 | 15 | 7.466 | 11056.9 |
798 | 2025-03-01 04:09:44 | affect | 2 | 82551 | 15 | 8.376 | 9855.7 |
797 | 2025-03-01 04:08:58 | affect | 1 | 48755 | 3 | 3.940 | 12374.4 |
796 | 2025-02-20 14:09:55 | affect | 3 | 112716 | 174 | 27.096 | 4159.9 |
795 | 2025-02-15 08:14:05 | affect | 1 | 48755 | 3 | 2.140 | 22782.7 |
794 | 2025-02-12 17:40:27 | affect | 1 | 48755 | 3 | 3.330 | 14641.1 |
793 | 2025-02-01 00:39:04 | affect | 3 | 112716 | 174 | 34.800 | 3239.0 |
792 | 2025-01-31 17:41:05 | affect | 1 | 48755 | 3 | 4.403 | 11073.1 |
791 | 2025-01-31 04:25:37 | affect | 3 | 112716 | 174 | 20.940 | 5382.8 |
790 | 2025-01-29 20:09:58 | affect | 3 | 112716 | 174 | 30.360 | 3712.6 |
789 | 2025-01-29 11:29:34 | affect | 3 | 112716 | 174 | 36.876 | 3056.6 |
788 | 2025-01-26 19:53:00 | affect | 2 | 82551 | 15 | 11.330 | 7286.1 |
787 | 2025-01-24 21:31:03 | affect | 2 | 82551 | 15 | 12.173 | 6781.5 |
786 | 2025-01-24 17:53:31 | affect | 2 | 82551 | 15 | 11.470 | 7197.1 |
785 | 2025-01-19 16:17:22 | affect | 1 | 48755 | 3 | 2.186 | 22303.3 |
784 | 2025-01-13 19:29:56 | affect | 1 | 48755 | 3 | 3.970 | 12280.9 |
783 | 2025-01-06 06:17:17 | affect | 2 | 82551 | 15 | 6.490 | 12719.7 |
782 | 2025-01-06 06:17:11 | affect | 1 | 48755 | 3 | 2.846 | 17131.1 |
781 | 2025-01-01 17:08:55 | affect | 1 | 48755 | 3 | 5.220 | 9340.0 |
780 | 2024-12-16 12:56:22 | affect | 2 | 82551 | 15 | 2.656 | 31080.9 |
779 | 2024-12-16 12:56:10 | affect | 3 | 112716 | 174 | 5.690 | 19809.5 |
778 | 2024-12-15 16:51:19 | affect | 2 | 82551 | 15 | 3.266 | 25275.9 |
777 | 2024-12-15 16:32:29 | affect | 2 | 82551 | 15 | 15.593 | 5294.1 |
776 | 2024-12-15 16:32:19 | affect | 1 | 48755 | 3 | 3.936 | 12386.9 |
775 | 2024-12-15 03:02:47 | affect | 3 | 112716 | 174 | 26.860 | 4196.4 |
774 | 2024-12-15 02:29:05 | affect | 3 | 112716 | 174 | 35.693 | 3157.9 |
773 | 2024-12-13 17:46:49 | affect | 3 | 112716 | 174 | 41.970 | 2685.6 |
772 | 2024-12-12 02:33:59 | affect | 3 | 112716 | 174 | 30.906 | 3647.1 |
771 | 2024-12-08 22:10:10 | affect | 1 | 48755 | 3 | 3.923 | 12428.0 |
770 | 2024-12-06 13:56:18 | affect | 1 | 48755 | 3 | 1.800 | 27086.1 |
769 | 2024-11-29 21:41:34 | affect | 1 | 48755 | 3 | 3.953 | 12333.7 |
768 | 2024-11-14 03:28:48 | affect | 3 | 112716 | 174 | 25.456 | 4427.9 |