History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"carter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1002 | 2024-04-27 14:58:00 | carter | 1 | 48755 | 21 | 2.126 | 22932.7 |
1001 | 2024-04-26 11:29:46 | carter | 1 | 48755 | 21 | 1.250 | 39004.0 |
1000 | 2024-04-11 13:41:40 | carter | 1 | 48755 | 21 | 0.813 | 59969.2 |
999 | 2024-04-06 01:45:47 | carter | 1 | 48755 | 21 | 2.576 | 18926.6 |
998 | 2024-03-06 22:14:33 | carter | 1 | 48755 | 21 | 3.060 | 15933.0 |
997 | 2024-03-01 18:22:55 | carter | 2 | 82551 | 273 | 3.000 | 27517.0 |
996 | 2024-02-26 01:53:50 | carter | 1 | 48755 | 21 | 0.986 | 49447.3 |
995 | 2024-01-16 20:31:06 | carter | 1 | 48755 | 21 | 0.780 | 62506.4 |
994 | 2024-01-02 04:08:30 | carter | 1 | 48755 | 21 | 0.783 | 62266.9 |
993 | 2023-12-29 17:33:05 | carter | 1 | 48755 | 21 | 0.763 | 63899.1 |
992 | 2023-12-24 01:20:39 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
991 | 2023-12-18 05:54:26 | carter | 2 | 82551 | 273 | 2.610 | 31628.7 |
990 | 2023-12-10 02:41:49 | carter | 2 | 82551 | 273 | 2.750 | 30018.5 |
989 | 2023-11-23 17:32:42 | carter | 2 | 82551 | 273 | 2.560 | 32246.5 |
988 | 2023-11-22 19:06:39 | carter | 2 | 82551 | 273 | 2.576 | 32046.2 |
987 | 2023-11-13 02:37:57 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
986 | 2023-11-11 21:29:58 | carter | 1 | 48755 | 21 | 0.893 | 54596.9 |
985 | 2023-11-11 05:04:16 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
984 | 2023-11-09 14:54:57 | carter | 1 | 48755 | 21 | 0.826 | 59025.4 |
983 | 2023-11-07 09:37:46 | carter | 1 | 48755 | 21 | 0.953 | 51159.5 |
982 | 2023-11-02 07:16:51 | carter | 1 | 48755 | 21 | 0.763 | 63899.1 |
981 | 2023-10-27 07:31:50 | carter | 1 | 48755 | 21 | 0.890 | 54780.9 |
980 | 2023-10-26 08:39:24 | carter | 1 | 48755 | 21 | 0.780 | 62506.4 |
979 | 2023-10-23 09:20:31 | carter | 1 | 48755 | 21 | 0.890 | 54780.9 |
978 | 2023-10-18 17:27:09 | carter | 1 | 48755 | 21 | 0.906 | 53813.5 |
977 | 2023-10-17 10:06:04 | carter | 2 | 82551 | 273 | 2.986 | 27646.0 |
976 | 2023-10-16 10:55:57 | carter | 2 | 82551 | 273 | 2.266 | 36430.3 |
975 | 2023-10-13 03:01:58 | carter | 1 | 48755 | 21 | 0.783 | 62266.9 |
974 | 2023-10-07 09:54:37 | carter | 1 | 48755 | 21 | 0.906 | 53813.5 |
973 | 2023-09-26 12:44:42 | carter | 1 | 48755 | 21 | 0.843 | 57835.1 |
972 | 2023-09-20 05:52:32 | carter | 1 | 48755 | 21 | 0.876 | 55656.4 |
971 | 2023-09-14 07:50:38 | carter | 1 | 48755 | 21 | 0.876 | 55656.4 |
970 | 2023-09-06 05:05:24 | carter | 1 | 48755 | 21 | 0.813 | 59969.2 |
969 | 2023-09-01 09:24:05 | carter | 1 | 48755 | 21 | 0.766 | 63648.8 |
968 | 2023-08-22 21:03:20 | carter | 2 | 82551 | 273 | 2.533 | 32590.2 |
967 | 2023-06-19 10:37:30 | carter | 1 | 48755 | 21 | 0.876 | 55656.4 |
966 | 2023-06-08 00:35:24 | carter | 1 | 48755 | 21 | 0.750 | 65006.7 |
965 | 2023-05-05 11:36:50 | carter | 2 | 82551 | 273 | 2.360 | 34979.2 |
964 | 2023-03-31 14:29:01 | carter | 1 | 48755 | 21 | 0.843 | 57835.1 |
963 | 2023-03-29 15:30:46 | carter | 1 | 48755 | 21 | 0.843 | 57835.1 |
962 | 2023-03-17 02:22:33 | carter | 1 | 48755 | 21 | 1.533 | 31803.7 |
961 | 2023-03-13 19:36:44 | carter | 1 | 48755 | 21 | 0.843 | 57835.1 |
960 | 2023-03-04 06:24:32 | carter | 1 | 48755 | 21 | 0.893 | 54596.9 |
959 | 2023-02-12 01:04:42 | carter | 2 | 82551 | 273 | 2.233 | 36968.7 |
958 | 2023-01-12 06:22:41 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
957 | 2022-12-05 13:44:43 | carter | 1 | 48755 | 21 | 0.750 | 65006.7 |
956 | 2022-12-02 05:34:34 | carter | 1 | 48755 | 21 | 0.766 | 63648.8 |
955 | 2022-11-25 14:43:41 | carter | 1 | 48755 | 21 | 1.766 | 27607.6 |
954 | 2022-11-23 23:45:25 | carter | 2 | 82551 | 273 | 2.233 | 36968.7 |
953 | 2022-10-30 18:19:28 | carter | 1 | 48755 | 21 | 0.763 | 63899.1 |
952 | 2022-08-28 21:29:08 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
951 | 2022-06-27 06:11:02 | carter | 2 | 82551 | 273 | 2.300 | 35891.7 |
950 | 2022-06-20 11:30:22 | carter | 1 | 48755 | 21 | 0.783 | 62266.9 |
949 | 2022-05-23 04:27:18 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
948 | 2022-05-19 18:23:29 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
947 | 2022-05-16 00:11:39 | carter | 1 | 48755 | 21 | 0.780 | 62506.4 |
946 | 2022-03-20 16:34:06 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
945 | 2022-03-14 23:18:19 | carter | 1 | 48755 | 21 | 1.080 | 45143.5 |
944 | 2022-02-15 02:21:18 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
943 | 2022-02-11 13:29:08 | carter | 1 | 48755 | 21 | 0.950 | 51321.1 |
942 | 2022-02-07 09:08:24 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
941 | 2022-02-06 23:08:09 | carter | 1 | 48755 | 21 | 0.940 | 51867.0 |
940 | 2022-02-06 16:55:31 | carter | 1 | 48755 | 21 | 0.873 | 55847.7 |
939 | 2022-02-06 10:40:56 | carter | 1 | 48755 | 21 | 0.876 | 55656.4 |
938 | 2022-02-05 19:00:25 | carter | 1 | 48755 | 21 | 0.890 | 54780.9 |
937 | 2022-02-05 15:55:59 | carter | 1 | 48755 | 21 | 0.876 | 55656.4 |
936 | 2022-02-05 02:14:40 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
935 | 2022-02-04 21:45:58 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
934 | 2022-02-04 17:05:29 | carter | 1 | 48755 | 21 | 0.766 | 63648.8 |
933 | 2022-02-04 10:08:25 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
932 | 2022-02-04 03:50:01 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
931 | 2022-02-03 16:44:10 | carter | 1 | 48755 | 21 | 1.000 | 48755.0 |
930 | 2022-02-03 13:21:52 | carter | 1 | 48755 | 21 | 0.890 | 54780.9 |
929 | 2022-02-03 07:06:37 | carter | 1 | 48755 | 21 | 0.873 | 55847.7 |
928 | 2022-02-03 02:01:04 | carter | 1 | 48755 | 21 | 0.890 | 54780.9 |
927 | 2022-02-02 22:14:42 | carter | 1 | 48755 | 21 | 0.783 | 62266.9 |
926 | 2022-02-02 18:09:30 | carter | 1 | 48755 | 21 | 1.046 | 46610.9 |
925 | 2022-02-02 06:06:27 | carter | 1 | 48755 | 21 | 1.016 | 47987.2 |
924 | 2022-02-02 01:25:13 | carter | 1 | 48755 | 21 | 0.813 | 59969.2 |
923 | 2022-02-01 18:49:16 | carter | 1 | 48755 | 21 | 0.906 | 53813.5 |
922 | 2022-02-01 10:30:10 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
921 | 2022-02-01 09:16:13 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
920 | 2022-01-31 23:19:25 | carter | 1 | 48755 | 21 | 0.890 | 54780.9 |
919 | 2022-01-31 09:36:26 | carter | 1 | 48755 | 21 | 0.813 | 59969.2 |
918 | 2022-01-31 06:32:42 | carter | 1 | 48755 | 21 | 0.906 | 53813.5 |
917 | 2022-01-31 02:05:43 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
916 | 2022-01-30 17:59:07 | carter | 1 | 48755 | 21 | 0.843 | 57835.1 |
915 | 2022-01-30 15:09:41 | carter | 1 | 48755 | 21 | 0.906 | 53813.5 |
914 | 2022-01-30 06:26:51 | carter | 1 | 48755 | 21 | 0.766 | 63648.8 |
913 | 2022-01-30 05:52:59 | carter | 1 | 48755 | 21 | 1.013 | 48129.3 |
912 | 2022-01-29 13:21:14 | carter | 1 | 48755 | 21 | 0.796 | 61250.0 |
911 | 2022-01-29 11:39:05 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
910 | 2022-01-13 16:59:02 | carter | 1 | 48755 | 21 | 0.876 | 55656.4 |
909 | 2022-01-12 17:10:27 | carter | 1 | 48755 | 21 | 0.813 | 59969.2 |
908 | 2022-01-11 20:43:38 | carter | 1 | 48755 | 21 | 0.860 | 56691.9 |
907 | 2022-01-10 22:21:17 | carter | 1 | 48755 | 21 | 0.906 | 53813.5 |
906 | 2022-01-01 03:14:46 | carter | 1 | 48755 | 21 | 0.923 | 52822.3 |
905 | 2021-12-31 16:18:39 | carter | 1 | 48755 | 21 | 1.016 | 47987.2 |
904 | 2021-12-31 07:13:23 | carter | 1 | 48755 | 21 | 1.813 | 26891.9 |
903 | 2021-12-30 14:56:35 | carter | 1 | 48755 | 21 | 0.890 | 54780.9 |