History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doormats"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
915 | 2024-05-04 13:54:35 | doormats | 1 | 82945 | 2 | 1.453 | 57085.3 |
914 | 2024-04-30 12:01:41 | doormats | 1 | 82945 | 2 | 1.546 | 53651.4 |
913 | 2024-04-29 21:20:02 | doormats | 4 | 161609 | 719 | 19.936 | 8106.4 |
912 | 2024-04-29 00:24:07 | doormats | 4 | 161609 | 719 | 14.936 | 10820.1 |
911 | 2024-04-26 07:23:28 | doormats | 1 | 82945 | 2 | 1.533 | 54106.3 |
910 | 2024-04-19 12:29:37 | doormats | 2 | 121059 | 5 | 3.890 | 31120.6 |
909 | 2024-04-19 12:29:01 | doormats | 3 | 146162 | 62 | 7.890 | 18525.0 |
908 | 2024-04-16 10:32:06 | doormats | 3 | 146162 | 62 | 13.750 | 10630.0 |
907 | 2024-04-16 07:40:32 | doormats | 3 | 146162 | 62 | 8.110 | 18022.4 |
906 | 2024-04-16 07:40:35 | doormats | 2 | 121059 | 5 | 4.923 | 24590.5 |
905 | 2024-04-16 07:40:30 | doormats | 1 | 82945 | 2 | 1.470 | 56425.2 |
904 | 2024-04-14 22:30:54 | doormats | 2 | 121059 | 5 | 3.140 | 38553.8 |
903 | 2024-04-14 16:17:11 | doormats | 4 | 161609 | 719 | 27.186 | 5944.6 |
902 | 2024-04-10 21:12:25 | doormats | 4 | 161609 | 719 | 20.843 | 7753.6 |
901 | 2024-04-09 17:59:57 | doormats | 4 | 161609 | 719 | 22.640 | 7138.2 |
900 | 2024-04-08 20:59:04 | doormats | 4 | 161609 | 719 | 13.093 | 12343.2 |
899 | 2024-04-01 11:21:51 | doormats | 2 | 121059 | 5 | 3.750 | 32282.4 |
898 | 2024-04-01 11:21:48 | doormats | 1 | 82945 | 2 | 1.576 | 52630.1 |
897 | 2024-03-31 00:40:53 | doormats | 4 | 161609 | 719 | 27.516 | 5873.3 |
896 | 2024-03-30 22:32:40 | doormats | 3 | 146162 | 62 | 26.673 | 5479.8 |
895 | 2024-03-30 22:31:12 | doormats | 3 | 146162 | 62 | 11.640 | 12556.9 |
894 | 2024-03-30 20:30:01 | doormats | 4 | 161609 | 719 | 34.143 | 4733.3 |
893 | 2024-03-30 14:33:34 | doormats | 4 | 161609 | 719 | 43.813 | 3688.6 |
892 | 2024-03-30 13:19:19 | doormats | 4 | 161609 | 719 | 35.410 | 4563.9 |
891 | 2024-03-30 13:19:19 | doormats | 3 | 146162 | 62 | 7.890 | 18525.0 |
890 | 2024-03-30 13:19:18 | doormats | 2 | 121059 | 5 | 4.106 | 29483.4 |
889 | 2024-03-30 13:19:11 | doormats | 1 | 82945 | 2 | 1.593 | 52068.4 |
888 | 2024-03-18 07:35:36 | doormats | 1 | 82945 | 2 | 1.533 | 54106.3 |
887 | 2024-03-10 21:22:03 | doormats | 1 | 82945 | 2 | 1.580 | 52496.8 |
886 | 2024-03-06 23:42:09 | doormats | 4 | 161609 | 719 | 56.393 | 2865.8 |
885 | 2024-03-06 00:49:50 | doormats | 4 | 161609 | 719 | 27.720 | 5830.1 |
884 | 2024-03-04 23:46:48 | doormats | 1 | 82945 | 2 | 1.530 | 54212.4 |
883 | 2024-03-03 13:19:25 | doormats | 4 | 161609 | 719 | 12.923 | 12505.5 |
882 | 2024-02-29 17:24:25 | doormats | 4 | 161609 | 719 | 18.156 | 8901.1 |
881 | 2024-02-28 09:07:00 | doormats | 4 | 161609 | 719 | 38.236 | 4226.6 |
880 | 2024-02-28 04:43:52 | doormats | 1 | 82945 | 2 | 3.783 | 21925.7 |
879 | 2024-02-27 23:53:38 | doormats | 4 | 161609 | 719 | 14.533 | 11120.1 |
878 | 2024-02-26 10:40:22 | doormats | 4 | 161609 | 719 | 13.780 | 11727.8 |
877 | 2024-02-24 22:04:54 | doormats | 4 | 161609 | 719 | 10.876 | 14859.2 |
876 | 2024-02-24 19:07:41 | doormats | 4 | 161609 | 719 | 14.423 | 11205.0 |
875 | 2024-02-23 20:36:20 | doormats | 4 | 161609 | 719 | 14.140 | 11429.2 |
874 | 2024-02-05 10:44:58 | doormats | 3 | 146162 | 62 | 9.796 | 14920.6 |
873 | 2024-02-04 15:49:14 | doormats | 4 | 161609 | 719 | 13.970 | 11568.3 |
872 | 2024-02-04 08:21:35 | doormats | 4 | 161609 | 719 | 14.046 | 11505.7 |
871 | 2024-01-31 07:58:20 | doormats | 1 | 82945 | 2 | 1.423 | 58288.8 |
870 | 2024-01-30 13:27:27 | doormats | 2 | 121059 | 5 | 3.860 | 31362.4 |
869 | 2024-01-30 13:24:31 | doormats | 3 | 146162 | 62 | 6.766 | 21602.4 |
868 | 2024-01-30 13:24:07 | doormats | 2 | 121059 | 5 | 3.250 | 37248.9 |
867 | 2024-01-30 13:23:31 | doormats | 3 | 146162 | 62 | 6.936 | 21073.0 |
866 | 2024-01-29 14:48:07 | doormats | 2 | 121059 | 5 | 7.093 | 17067.4 |
865 | 2024-01-29 14:48:03 | doormats | 3 | 146162 | 62 | 7.516 | 19446.8 |
864 | 2024-01-29 14:47:59 | doormats | 1 | 82945 | 2 | 1.563 | 53067.8 |
863 | 2024-01-26 01:34:45 | doormats | 4 | 161609 | 719 | 12.986 | 12444.9 |
862 | 2024-01-23 15:07:17 | doormats | 4 | 161609 | 719 | 26.783 | 6034.0 |
861 | 2024-01-23 03:37:21 | doormats | 4 | 161609 | 719 | 17.596 | 9184.4 |
860 | 2024-01-23 02:32:56 | doormats | 4 | 161609 | 719 | 10.516 | 15367.9 |
859 | 2024-01-05 08:07:02 | doormats | 1 | 82945 | 2 | 1.453 | 57085.3 |
858 | 2023-12-27 05:35:20 | doormats | 1 | 82945 | 2 | 1.263 | 65673.0 |
857 | 2023-12-24 00:23:15 | doormats | 4 | 161609 | 719 | 11.830 | 13660.9 |
856 | 2023-12-19 07:49:49 | doormats | 1 | 82945 | 2 | 1.313 | 63172.1 |
855 | 2023-12-14 04:33:55 | doormats | 2 | 121059 | 5 | 3.106 | 38975.9 |
854 | 2023-12-09 12:19:18 | doormats | 4 | 161609 | 719 | 11.000 | 14691.7 |
853 | 2023-12-07 12:15:08 | doormats | 1 | 82945 | 2 | 1.470 | 56425.2 |
852 | 2023-12-06 16:48:02 | doormats | 4 | 161609 | 719 | 15.800 | 10228.4 |
851 | 2023-12-03 03:53:24 | doormats | 1 | 82945 | 2 | 1.283 | 64649.3 |
850 | 2023-11-22 02:48:47 | doormats | 4 | 161609 | 719 | 12.266 | 13175.4 |
849 | 2023-10-29 20:40:22 | doormats | 4 | 161609 | 719 | 11.846 | 13642.5 |
848 | 2023-10-27 03:04:46 | doormats | 1 | 82945 | 2 | 1.406 | 58993.6 |
847 | 2023-10-04 20:22:12 | doormats | 4 | 161609 | 719 | 10.406 | 15530.4 |
846 | 2023-09-30 23:57:18 | doormats | 4 | 161609 | 719 | 15.326 | 10544.8 |
845 | 2023-09-29 03:37:33 | doormats | 4 | 161609 | 719 | 11.563 | 13976.4 |
844 | 2023-09-29 02:55:33 | doormats | 4 | 161609 | 719 | 23.643 | 6835.4 |
843 | 2023-09-27 06:28:02 | doormats | 4 | 161609 | 719 | 12.640 | 12785.5 |
842 | 2023-09-14 05:05:10 | doormats | 4 | 161609 | 719 | 22.453 | 7197.7 |
841 | 2023-09-14 00:02:13 | doormats | 4 | 161609 | 719 | 11.733 | 13773.9 |
840 | 2023-09-13 22:48:54 | doormats | 2 | 121059 | 5 | 3.403 | 35574.2 |
839 | 2023-09-07 00:13:07 | doormats | 4 | 161609 | 719 | 10.236 | 15788.3 |
838 | 2023-09-06 07:50:32 | doormats | 4 | 161609 | 719 | 10.983 | 14714.5 |
837 | 2023-09-05 17:34:14 | doormats | 4 | 161609 | 719 | 11.560 | 13980.0 |
836 | 2023-08-21 04:24:04 | doormats | 1 | 82945 | 2 | 1.236 | 67107.6 |
835 | 2023-08-04 06:33:02 | doormats | 1 | 82945 | 2 | 1.280 | 64800.8 |
834 | 2023-07-04 21:01:26 | doormats | 4 | 161609 | 719 | 12.623 | 12802.7 |
833 | 2023-07-03 23:58:11 | doormats | 4 | 161609 | 719 | 12.656 | 12769.4 |
832 | 2023-07-02 20:25:43 | doormats | 4 | 161609 | 719 | 12.486 | 12943.2 |
831 | 2023-07-01 19:42:01 | doormats | 4 | 161609 | 719 | 12.703 | 12722.1 |
830 | 2023-06-27 19:56:41 | doormats | 4 | 161609 | 719 | 12.423 | 13008.9 |
829 | 2023-06-24 19:56:15 | doormats | 4 | 161609 | 719 | 10.860 | 14881.1 |
828 | 2023-06-22 20:19:09 | doormats | 4 | 161609 | 719 | 10.673 | 15141.9 |
827 | 2023-06-21 19:13:30 | doormats | 4 | 161609 | 719 | 13.140 | 12299.0 |
826 | 2023-06-20 20:39:15 | doormats | 4 | 161609 | 719 | 13.140 | 12299.0 |
825 | 2023-06-19 20:16:54 | doormats | 4 | 161609 | 719 | 12.406 | 13026.7 |
824 | 2023-06-18 20:44:32 | doormats | 4 | 161609 | 719 | 12.190 | 13257.5 |
823 | 2023-06-16 20:45:38 | doormats | 4 | 161609 | 719 | 13.673 | 11819.6 |
822 | 2023-06-15 11:03:55 | doormats | 4 | 161609 | 719 | 11.813 | 13680.6 |
821 | 2023-06-14 14:37:41 | doormats | 4 | 161609 | 719 | 12.143 | 13308.8 |
820 | 2023-06-13 21:57:15 | doormats | 4 | 161609 | 719 | 13.296 | 12154.7 |
819 | 2023-06-11 14:19:50 | doormats | 2 | 121059 | 5 | 3.486 | 34727.2 |
818 | 2023-05-22 08:49:56 | doormats | 1 | 82945 | 2 | 1.420 | 58412.0 |
817 | 2023-05-20 16:46:02 | doormats | 4 | 161609 | 719 | 10.376 | 15575.3 |
816 | 2023-04-12 02:09:22 | doormats | 1 | 82945 | 2 | 1.233 | 67270.9 |