History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sub"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
989 | 2024-04-27 07:08:13 | sub | 1 | 5146 | 24 | 0.343 | 15002.9 |
988 | 2024-04-24 23:04:07 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
987 | 2024-04-14 23:45:30 | sub | 1 | 5146 | 24 | 0.373 | 13796.2 |
986 | 2024-04-14 23:44:54 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
985 | 2024-04-02 17:45:42 | sub | 1 | 5146 | 24 | 0.310 | 16600.0 |
984 | 2024-04-01 18:13:17 | sub | 2 | 14084 | 340 | 0.923 | 15258.9 |
983 | 2024-04-01 16:12:50 | sub | 1 | 5146 | 24 | 0.280 | 18378.6 |
982 | 2024-03-30 18:27:41 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
981 | 2024-03-29 07:29:26 | sub | 1 | 5146 | 24 | 0.296 | 17385.1 |
980 | 2024-03-26 17:02:51 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
979 | 2024-03-25 16:23:12 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
978 | 2024-03-02 16:21:49 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
977 | 2024-02-29 18:38:19 | sub | 1 | 5146 | 24 | 0.250 | 20584.0 |
976 | 2024-02-25 15:33:47 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
975 | 2024-02-07 18:41:30 | sub | 2 | 14084 | 340 | 2.610 | 5396.2 |
974 | 2024-02-07 14:50:37 | sub | 2 | 14084 | 340 | 0.360 | 39122.2 |
973 | 2024-02-07 09:44:31 | sub | 2 | 14084 | 340 | 0.500 | 28168.0 |
972 | 2024-02-02 14:14:59 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
971 | 2024-01-26 09:46:41 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
970 | 2024-01-20 17:53:29 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
969 | 2023-12-25 12:59:36 | sub | 2 | 14084 | 340 | 0.376 | 37457.4 |
968 | 2023-12-23 22:23:39 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
967 | 2023-12-20 17:50:30 | sub | 1 | 5146 | 24 | 0.063 | 81682.5 |
966 | 2023-12-05 09:41:30 | sub | 2 | 14084 | 340 | 0.376 | 37457.4 |
965 | 2023-12-03 10:26:40 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
964 | 2023-12-03 10:26:39 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
963 | 2023-12-02 18:01:39 | sub | 2 | 14084 | 340 | 0.343 | 41061.2 |
962 | 2023-11-17 09:58:41 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
961 | 2023-11-13 08:42:05 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
960 | 2023-11-13 03:27:41 | sub | 2 | 14084 | 340 | 0.326 | 43202.5 |
959 | 2023-11-10 17:26:32 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
958 | 2023-10-31 22:05:19 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
957 | 2023-10-27 21:39:33 | sub | 1 | 5146 | 24 | 0.096 | 53604.2 |
956 | 2023-10-20 05:43:38 | sub | 2 | 14084 | 340 | 0.343 | 41061.2 |
955 | 2023-10-19 20:52:06 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
954 | 2023-10-17 06:42:11 | sub | 2 | 14084 | 340 | 0.360 | 39122.2 |
953 | 2023-10-16 23:55:19 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
952 | 2023-10-14 18:22:41 | sub | 2 | 14084 | 340 | 0.423 | 33295.5 |
951 | 2023-10-10 14:25:44 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
950 | 2023-10-04 04:55:25 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
949 | 2023-09-25 08:48:35 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
948 | 2023-09-22 15:30:04 | sub | 2 | 14084 | 340 | 0.373 | 37758.7 |
947 | 2023-09-16 23:01:57 | sub | 2 | 14084 | 340 | 0.376 | 37457.4 |
946 | 2023-09-10 17:02:02 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
945 | 2023-09-04 16:44:17 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
944 | 2023-08-28 06:14:31 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
943 | 2023-08-16 02:40:19 | sub | 2 | 14084 | 340 | 0.326 | 43202.5 |
942 | 2023-07-23 09:58:20 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
941 | 2023-06-08 06:33:59 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
940 | 2023-05-14 16:51:54 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
939 | 2023-04-28 12:31:21 | sub | 2 | 14084 | 340 | 0.326 | 43202.5 |
938 | 2023-03-30 02:35:21 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
937 | 2023-02-02 17:37:40 | sub | 2 | 14084 | 340 | 0.343 | 41061.2 |
936 | 2023-01-28 20:22:51 | sub | 1 | 5146 | 24 | 0.063 | 81682.5 |
935 | 2023-01-21 10:05:56 | sub | 2 | 14084 | 340 | 0.326 | 43202.5 |
934 | 2023-01-17 08:30:37 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
933 | 2023-01-14 04:22:57 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
932 | 2022-12-10 20:07:55 | sub | 2 | 14084 | 340 | 0.376 | 37457.4 |
931 | 2022-11-14 12:06:56 | sub | 2 | 14084 | 340 | 0.360 | 39122.2 |
930 | 2022-11-04 20:07:10 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
929 | 2022-10-10 21:46:10 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
928 | 2022-09-04 21:50:02 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
927 | 2022-09-02 13:03:25 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
926 | 2022-08-15 18:44:01 | sub | 2 | 14084 | 340 | 0.343 | 41061.2 |
925 | 2022-08-14 19:04:41 | sub | 1 | 5146 | 24 | 0.096 | 53604.2 |
924 | 2022-07-29 02:58:14 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
923 | 2022-07-19 10:38:28 | sub | 2 | 14084 | 340 | 0.313 | 44996.8 |
922 | 2022-07-18 19:49:37 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
921 | 2022-07-17 23:30:36 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
920 | 2022-07-03 03:29:53 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
919 | 2022-06-25 03:18:06 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
918 | 2022-06-24 06:16:12 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
917 | 2022-06-17 14:42:24 | sub | 2 | 14084 | 340 | 0.346 | 40705.2 |
916 | 2022-06-08 23:21:04 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
915 | 2022-06-07 12:07:42 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
914 | 2022-05-18 15:22:56 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
913 | 2022-05-11 16:55:32 | sub | 1 | 5146 | 24 | 0.110 | 46781.8 |
912 | 2022-05-11 05:37:47 | sub | 1 | 5146 | 24 | 0.096 | 53604.2 |
911 | 2022-05-10 20:39:56 | sub | 1 | 5146 | 24 | 0.173 | 29745.7 |
910 | 2022-05-10 14:26:40 | sub | 1 | 5146 | 24 | 0.123 | 41837.4 |
909 | 2022-05-10 08:59:03 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
908 | 2022-05-09 22:48:30 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
907 | 2022-05-08 13:41:17 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
906 | 2022-05-08 00:25:50 | sub | 1 | 5146 | 24 | 0.063 | 81682.5 |
905 | 2022-05-07 15:28:08 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
904 | 2022-05-07 01:32:32 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
903 | 2022-05-06 09:46:57 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
902 | 2022-05-05 17:12:22 | sub | 1 | 5146 | 24 | 0.090 | 57177.8 |
901 | 2022-05-05 10:47:07 | sub | 1 | 5146 | 24 | 0.096 | 53604.2 |
900 | 2022-05-04 23:03:08 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
899 | 2022-05-04 11:08:24 | sub | 1 | 5146 | 24 | 0.093 | 55333.3 |
898 | 2022-05-03 09:52:20 | sub | 1 | 5146 | 24 | 0.110 | 46781.8 |
897 | 2022-04-08 03:52:54 | sub | 1 | 5146 | 24 | 0.140 | 36757.1 |
896 | 2022-04-07 15:22:13 | sub | 1 | 5146 | 24 | 0.140 | 36757.1 |
895 | 2022-04-06 06:23:05 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
894 | 2022-04-05 19:19:21 | sub | 1 | 5146 | 24 | 0.170 | 30270.6 |
893 | 2022-04-04 23:40:18 | sub | 1 | 5146 | 24 | 0.080 | 64325.0 |
892 | 2022-04-04 11:11:42 | sub | 1 | 5146 | 24 | 0.096 | 53604.2 |
891 | 2022-04-03 13:03:46 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |
890 | 2022-04-02 17:08:03 | sub | 1 | 5146 | 24 | 0.076 | 67710.5 |