History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trouts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
963 | 2024-04-27 15:41:55 | trouts | 1 | 48755 | 8 | 1.280 | 38089.8 |
962 | 2024-04-16 23:34:27 | trouts | 1 | 48755 | 8 | 1.080 | 45143.5 |
961 | 2024-04-04 23:25:21 | trouts | 1 | 48755 | 8 | 1.563 | 31193.2 |
960 | 2024-04-03 09:31:50 | trouts | 2 | 82551 | 106 | 3.483 | 23701.1 |
959 | 2024-04-03 09:31:46 | trouts | 1 | 48755 | 8 | 0.890 | 54780.9 |
958 | 2024-04-03 09:31:40 | trouts | 2 | 82551 | 106 | 2.690 | 30688.1 |
957 | 2024-04-03 09:31:38 | trouts | 1 | 48755 | 8 | 1.753 | 27812.3 |
956 | 2024-03-04 07:13:24 | trouts | 1 | 48755 | 8 | 2.060 | 23667.5 |
955 | 2024-02-25 21:17:10 | trouts | 1 | 48755 | 8 | 1.923 | 25353.6 |
954 | 2024-01-01 14:30:24 | trouts | 1 | 48755 | 8 | 0.860 | 56691.9 |
953 | 2023-12-16 12:17:20 | trouts | 1 | 48755 | 8 | 0.830 | 58741.0 |
952 | 2023-12-10 01:32:29 | trouts | 2 | 82551 | 106 | 2.500 | 33020.4 |
951 | 2023-12-02 19:30:32 | trouts | 2 | 82551 | 106 | 2.546 | 32423.8 |
950 | 2023-11-19 20:26:45 | trouts | 2 | 82551 | 106 | 2.860 | 28864.0 |
949 | 2023-11-16 18:28:15 | trouts | 1 | 48755 | 8 | 0.813 | 59969.2 |
948 | 2023-11-11 04:34:05 | trouts | 1 | 48755 | 8 | 0.750 | 65006.7 |
947 | 2023-11-10 15:33:52 | trouts | 1 | 48755 | 8 | 0.750 | 65006.7 |
946 | 2023-10-27 02:11:56 | trouts | 1 | 48755 | 8 | 0.736 | 66243.2 |
945 | 2023-10-24 20:46:25 | trouts | 1 | 48755 | 8 | 0.783 | 62266.9 |
944 | 2023-10-23 00:07:22 | trouts | 1 | 48755 | 8 | 0.783 | 62266.9 |
943 | 2023-10-20 17:17:58 | trouts | 1 | 48755 | 8 | 0.826 | 59025.4 |
942 | 2023-10-17 13:39:45 | trouts | 1 | 48755 | 8 | 0.906 | 53813.5 |
941 | 2023-10-12 02:11:37 | trouts | 1 | 48755 | 8 | 0.796 | 61250.0 |
940 | 2023-10-04 09:05:32 | trouts | 1 | 48755 | 8 | 0.843 | 57835.1 |
939 | 2023-09-23 21:15:13 | trouts | 1 | 48755 | 8 | 0.906 | 53813.5 |
938 | 2023-09-14 04:59:40 | trouts | 2 | 82551 | 106 | 2.576 | 32046.2 |
937 | 2023-09-10 14:08:52 | trouts | 1 | 48755 | 8 | 0.843 | 57835.1 |
936 | 2023-08-18 23:38:59 | trouts | 1 | 48755 | 8 | 0.890 | 54780.9 |
935 | 2023-06-21 12:21:40 | trouts | 1 | 48755 | 8 | 1.093 | 44606.6 |
934 | 2023-06-18 08:06:26 | trouts | 1 | 48755 | 8 | 0.856 | 56956.8 |
933 | 2023-05-20 20:40:49 | trouts | 1 | 48755 | 8 | 0.750 | 65006.7 |
932 | 2023-03-16 12:21:34 | trouts | 1 | 48755 | 8 | 0.736 | 66243.2 |
931 | 2023-02-20 10:48:06 | trouts | 1 | 48755 | 8 | 0.813 | 59969.2 |
930 | 2023-01-03 10:09:02 | trouts | 1 | 48755 | 8 | 0.813 | 59969.2 |
929 | 2022-10-23 15:02:45 | trouts | 1 | 48755 | 8 | 0.736 | 66243.2 |
928 | 2022-09-27 21:23:56 | trouts | 1 | 48755 | 8 | 0.733 | 66514.3 |
927 | 2022-06-22 07:46:18 | trouts | 1 | 48755 | 8 | 0.813 | 59969.2 |
926 | 2022-05-11 17:29:55 | trouts | 1 | 48755 | 8 | 1.186 | 41108.8 |
925 | 2022-02-20 18:05:19 | trouts | 1 | 48755 | 8 | 0.953 | 51159.5 |
924 | 2022-02-01 22:37:28 | trouts | 1 | 48755 | 8 | 0.843 | 57835.1 |
923 | 2021-11-23 20:58:33 | trouts | 1 | 48755 | 8 | 0.783 | 62266.9 |
922 | 2021-10-23 18:27:19 | trouts | 1 | 48755 | 8 | 0.846 | 57630.0 |
921 | 2021-10-21 22:03:31 | trouts | 1 | 48755 | 8 | 0.906 | 53813.5 |
920 | 2021-10-03 07:49:41 | trouts | 2 | 82551 | 106 | 2.390 | 34540.2 |
919 | 2021-09-21 18:32:24 | trouts | 1 | 48755 | 8 | 0.860 | 56691.9 |
918 | 2021-09-21 01:15:24 | trouts | 1 | 48755 | 8 | 0.826 | 59025.4 |
917 | 2021-09-21 00:02:13 | trouts | 2 | 82551 | 106 | 2.263 | 36478.6 |
916 | 2021-09-20 20:52:48 | trouts | 1 | 48755 | 8 | 0.860 | 56691.9 |
915 | 2021-09-20 03:40:23 | trouts | 1 | 48755 | 8 | 0.843 | 57835.1 |
914 | 2021-09-14 01:20:50 | trouts | 1 | 48755 | 8 | 0.750 | 65006.7 |
913 | 2021-07-16 10:49:18 | trouts | 1 | 48755 | 8 | 0.733 | 66514.3 |
912 | 2021-07-12 21:28:47 | trouts | 1 | 48755 | 8 | 0.813 | 59969.2 |
911 | 2021-05-26 23:06:47 | trouts | 1 | 48755 | 8 | 0.843 | 57835.1 |
910 | 2021-05-01 04:17:45 | trouts | 1 | 48755 | 8 | 0.830 | 58741.0 |
909 | 2021-04-09 06:24:46 | trouts | 1 | 48755 | 8 | 0.856 | 56956.8 |
908 | 2021-04-05 02:04:47 | trouts | 1 | 48755 | 8 | 0.873 | 55847.7 |
907 | 2021-03-30 13:26:04 | trouts | 1 | 48755 | 8 | 0.906 | 53813.5 |
906 | 2021-02-08 06:10:20 | trouts | 1 | 48755 | 8 | 0.750 | 65006.7 |
905 | 2020-12-27 09:11:10 | trouts | 1 | 48755 | 8 | 0.843 | 57835.1 |
904 | 2020-10-29 07:58:02 | trouts | 1 | 48755 | 8 | 0.750 | 65006.7 |
903 | 2020-10-22 13:23:18 | trouts | 1 | 48755 | 8 | 0.763 | 63899.1 |
902 | 2020-10-05 15:43:47 | trouts | 1 | 48755 | 8 | 0.733 | 66514.3 |
901 | 2020-10-01 10:26:36 | trouts | 1 | 48755 | 8 | 0.826 | 59025.4 |
900 | 2020-09-23 18:09:35 | trouts | 1 | 48755 | 8 | 0.766 | 63648.8 |
899 | 2020-09-07 01:17:36 | trouts | 1 | 48755 | 8 | 0.830 | 58741.0 |
898 | 2020-07-28 23:20:20 | trouts | 1 | 48755 | 8 | 0.796 | 61250.0 |
897 | 2020-06-12 14:24:19 | trouts | 1 | 48755 | 8 | 0.733 | 66514.3 |
896 | 2020-05-31 13:00:49 | trouts | 1 | 48755 | 8 | 0.876 | 55656.4 |
895 | 2020-05-30 12:20:33 | trouts | 1 | 48755 | 8 | 0.906 | 53813.5 |
894 | 2020-03-29 20:39:31 | trouts | 1 | 48755 | 8 | 0.766 | 63648.8 |
893 | 2020-03-27 21:42:53 | trouts | 1 | 48755 | 8 | 0.860 | 56691.9 |
892 | 2020-03-24 10:10:10 | trouts | 1 | 48755 | 8 | 0.903 | 53992.2 |
891 | 2020-03-24 01:24:21 | trouts | 1 | 48755 | 8 | 1.283 | 38000.8 |
890 | 2020-03-22 09:11:02 | trouts | 1 | 48755 | 8 | 0.876 | 55656.4 |
889 | 2020-03-19 20:17:04 | trouts | 1 | 48755 | 8 | 0.780 | 62506.4 |
888 | 2020-03-18 21:48:44 | trouts | 1 | 48755 | 8 | 0.830 | 58741.0 |
887 | 2020-03-05 04:09:47 | trouts | 1 | 48755 | 8 | 0.873 | 55847.7 |
886 | 2020-02-29 00:12:23 | trouts | 1 | 48755 | 8 | 0.856 | 56956.8 |
885 | 2020-02-28 16:26:49 | trouts | 1 | 48755 | 8 | 0.890 | 54780.9 |
884 | 2020-02-26 06:50:14 | trouts | 1 | 48755 | 8 | 0.936 | 52088.7 |
883 | 2020-02-21 08:55:22 | trouts | 1 | 48755 | 8 | 0.966 | 50471.0 |
882 | 2020-02-14 21:42:36 | trouts | 1 | 48755 | 8 | 0.873 | 55847.7 |
881 | 2020-02-10 09:03:55 | trouts | 1 | 48755 | 8 | 1.203 | 40527.8 |
880 | 2020-01-31 16:50:46 | trouts | 1 | 48755 | 8 | 0.796 | 61250.0 |
879 | 2020-01-31 16:21:03 | trouts | 1 | 48755 | 8 | 0.986 | 49447.3 |
878 | 2020-01-31 01:54:51 | trouts | 1 | 48755 | 8 | 2.656 | 18356.6 |
877 | 2020-01-30 22:27:38 | trouts | 1 | 48755 | 8 | 1.733 | 28133.3 |
876 | 2020-01-25 04:54:22 | trouts | 1 | 48755 | 8 | 0.860 | 56691.9 |
875 | 2020-01-22 03:28:32 | trouts | 1 | 48755 | 8 | 2.736 | 17819.8 |
874 | 2020-01-13 06:25:45 | trouts | 1 | 48755 | 8 | 0.890 | 54780.9 |
873 | 2020-01-12 21:26:31 | trouts | 1 | 48755 | 8 | 1.796 | 27146.4 |
872 | 2020-01-11 05:22:20 | trouts | 1 | 48755 | 8 | 0.826 | 59025.4 |
871 | 2020-01-04 18:34:41 | trouts | 1 | 48755 | 8 | 0.826 | 59025.4 |
870 | 2019-12-30 17:03:56 | trouts | 1 | 48755 | 8 | 0.890 | 54780.9 |
869 | 2019-12-29 11:42:50 | trouts | 1 | 48755 | 8 | 0.873 | 55847.7 |
868 | 2019-12-28 11:47:16 | trouts | 1 | 48755 | 8 | 1.686 | 28917.6 |
867 | 2019-12-28 00:47:11 | trouts | 1 | 48755 | 8 | 0.766 | 63648.8 |
866 | 2019-12-26 10:49:30 | trouts | 1 | 48755 | 8 | 0.783 | 62266.9 |
865 | 2019-12-26 10:29:16 | trouts | 1 | 48755 | 8 | 0.893 | 54596.9 |
864 | 2019-12-26 05:39:13 | trouts | 1 | 48755 | 8 | 0.983 | 49598.2 |