History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"urn"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1000 | 2024-04-23 20:50:12 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
999 | 2024-04-15 00:04:49 | urn | 1 | 5146 | 12 | 0.296 | 17385.1 |
998 | 2024-04-02 17:25:11 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
997 | 2024-03-30 22:18:55 | urn | 1 | 5146 | 12 | 0.186 | 27666.7 |
996 | 2024-03-26 17:42:40 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
995 | 2024-03-02 16:21:40 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
994 | 2024-02-29 17:14:32 | urn | 1 | 5146 | 12 | 0.173 | 29745.7 |
993 | 2024-02-29 14:09:56 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
992 | 2024-02-25 15:37:21 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
991 | 2024-02-20 14:39:32 | urn | 1 | 5146 | 12 | 0.186 | 27666.7 |
990 | 2024-02-01 09:46:31 | urn | 1 | 5146 | 12 | 0.156 | 32987.2 |
989 | 2024-01-27 19:24:47 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
988 | 2024-01-27 04:03:46 | urn | 1 | 5146 | 12 | 0.110 | 46781.8 |
987 | 2024-01-25 17:18:57 | urn | 1 | 5146 | 12 | 0.173 | 29745.7 |
986 | 2024-01-20 01:55:08 | urn | 1 | 5146 | 12 | 0.170 | 30270.6 |
985 | 2023-12-14 12:27:05 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
984 | 2023-12-10 02:51:20 | urn | 2 | 14084 | 279 | 0.360 | 39122.2 |
983 | 2023-11-28 09:01:28 | urn | 2 | 14084 | 279 | 0.326 | 43202.5 |
982 | 2023-11-16 01:26:25 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
981 | 2023-11-11 01:12:29 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
980 | 2023-11-10 05:30:34 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
979 | 2023-11-09 04:11:57 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
978 | 2023-11-08 12:11:12 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
977 | 2023-11-06 14:45:57 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
976 | 2023-11-05 17:01:02 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
975 | 2023-10-27 11:58:22 | urn | 2 | 14084 | 279 | 0.330 | 42678.8 |
974 | 2023-10-25 20:19:54 | urn | 1 | 5146 | 12 | 0.186 | 27666.7 |
973 | 2023-10-20 17:52:41 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
972 | 2023-10-17 13:32:45 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
971 | 2023-10-12 10:54:35 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
970 | 2023-10-03 23:43:29 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
969 | 2023-10-03 00:25:03 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
968 | 2023-09-25 15:51:59 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
967 | 2023-09-02 00:26:55 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
966 | 2023-07-17 10:13:56 | urn | 1 | 5146 | 12 | 0.063 | 81682.5 |
965 | 2023-06-05 08:33:01 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
964 | 2023-03-29 11:19:37 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
963 | 2023-03-25 18:43:51 | urn | 1 | 5146 | 12 | 0.060 | 85766.7 |
962 | 2023-03-25 02:43:05 | urn | 1 | 5146 | 12 | 0.063 | 81682.5 |
961 | 2023-01-10 14:28:39 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
960 | 2022-12-29 17:16:34 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
959 | 2022-12-01 00:11:54 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
958 | 2022-11-27 17:16:49 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
957 | 2022-10-12 18:25:45 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
956 | 2022-09-19 18:35:29 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
955 | 2022-09-18 13:48:27 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
954 | 2022-09-09 11:53:46 | urn | 1 | 5146 | 12 | 0.063 | 81682.5 |
953 | 2022-09-03 18:01:34 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
952 | 2022-09-01 13:13:36 | urn | 1 | 5146 | 12 | 0.140 | 36757.1 |
951 | 2022-08-15 00:22:20 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
950 | 2022-08-06 19:52:04 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
949 | 2022-07-31 15:27:30 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
948 | 2022-07-30 00:50:13 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
947 | 2022-07-17 21:24:46 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
946 | 2022-07-17 18:41:47 | urn | 1 | 5146 | 12 | 0.063 | 81682.5 |
945 | 2022-07-03 07:24:35 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
944 | 2022-07-02 06:52:55 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
943 | 2022-06-25 18:42:45 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
942 | 2022-06-02 19:09:53 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
941 | 2022-06-02 03:06:48 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
940 | 2022-05-31 13:22:52 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
939 | 2022-05-03 09:48:45 | urn | 1 | 5146 | 12 | 0.110 | 46781.8 |
938 | 2022-03-23 08:41:15 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
937 | 2022-02-10 12:44:09 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
936 | 2022-01-28 19:32:39 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
935 | 2022-01-28 00:13:37 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
934 | 2022-01-27 07:08:20 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
933 | 2022-01-26 20:22:37 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
932 | 2022-01-26 12:12:30 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
931 | 2022-01-26 02:03:21 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
930 | 2022-01-25 13:05:59 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
929 | 2022-01-25 02:37:27 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
928 | 2022-01-24 18:52:12 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
927 | 2022-01-24 07:01:21 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
926 | 2022-01-23 17:13:12 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
925 | 2022-01-21 12:57:15 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
924 | 2022-01-19 17:47:31 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
923 | 2022-01-18 18:08:11 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
922 | 2022-01-17 03:47:57 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
921 | 2022-01-16 14:17:37 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
920 | 2022-01-16 04:54:14 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
919 | 2022-01-15 21:46:08 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
918 | 2022-01-15 12:23:17 | urn | 1 | 5146 | 12 | 0.080 | 64325.0 |
917 | 2022-01-15 06:18:49 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
916 | 2022-01-14 18:06:07 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
915 | 2022-01-13 13:30:51 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
914 | 2022-01-06 04:43:16 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
913 | 2022-01-05 15:18:43 | urn | 1 | 5146 | 12 | 0.186 | 27666.7 |
912 | 2022-01-05 06:38:59 | urn | 1 | 5146 | 12 | 0.106 | 48547.2 |
911 | 2022-01-04 15:53:40 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |
910 | 2021-12-06 08:11:01 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
909 | 2021-12-02 20:10:32 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
908 | 2021-12-01 21:22:22 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
907 | 2021-11-29 21:20:41 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
906 | 2021-11-29 07:56:36 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
905 | 2021-11-11 21:24:47 | urn | 1 | 5146 | 12 | 0.063 | 81682.5 |
904 | 2021-10-19 19:56:12 | urn | 1 | 5146 | 12 | 0.076 | 67710.5 |
903 | 2021-09-28 02:33:33 | urn | 2 | 14084 | 279 | 0.356 | 39561.8 |
902 | 2021-09-14 02:26:34 | urn | 1 | 5146 | 12 | 0.093 | 55333.3 |
901 | 2021-09-08 18:33:31 | urn | 1 | 5146 | 12 | 0.096 | 53604.2 |