History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trace"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1032 | 2024-05-07 23:07:09 | trace | 1 | 28756 | 15 | 1.220 | 23570.5 |
1031 | 2024-05-05 04:25:50 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
1030 | 2024-04-30 09:58:51 | trace | 1 | 28756 | 15 | 1.093 | 26309.2 |
1029 | 2024-04-29 20:49:14 | trace | 1 | 28756 | 15 | 0.470 | 61183.0 |
1028 | 2024-04-28 07:39:38 | trace | 1 | 28756 | 15 | 0.530 | 54256.6 |
1027 | 2024-04-12 19:37:30 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
1026 | 2024-04-03 00:35:55 | trace | 1 | 28756 | 15 | 0.610 | 47141.0 |
1025 | 2024-03-31 02:06:56 | trace | 1 | 28756 | 15 | 0.546 | 52666.7 |
1024 | 2024-03-28 23:41:47 | trace | 2 | 53800 | 186 | 4.190 | 12840.1 |
1023 | 2024-03-28 23:26:52 | trace | 1 | 28756 | 15 | 1.186 | 24246.2 |
1022 | 2024-03-03 20:52:18 | trace | 1 | 28756 | 15 | 0.513 | 56054.6 |
1021 | 2024-03-01 00:32:21 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
1020 | 2024-02-27 20:21:02 | trace | 1 | 28756 | 15 | 0.626 | 45936.1 |
1019 | 2024-02-02 18:42:15 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
1018 | 2024-01-28 18:50:21 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
1017 | 2024-01-14 14:20:24 | trace | 1 | 28756 | 15 | 0.486 | 59168.7 |
1016 | 2024-01-04 21:40:22 | trace | 2 | 53800 | 186 | 1.640 | 32804.9 |
1015 | 2023-12-21 23:30:55 | trace | 1 | 28756 | 15 | 0.466 | 61708.2 |
1014 | 2023-12-20 00:26:32 | trace | 1 | 28756 | 15 | 0.453 | 63479.0 |
1013 | 2023-12-12 01:08:23 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
1012 | 2023-12-11 06:49:04 | trace | 2 | 53800 | 186 | 1.406 | 38264.6 |
1011 | 2023-12-10 18:38:28 | trace | 2 | 53800 | 186 | 1.406 | 38264.6 |
1010 | 2023-12-04 00:43:19 | trace | 2 | 53800 | 186 | 1.826 | 29463.3 |
1009 | 2023-11-25 22:17:08 | trace | 1 | 28756 | 15 | 0.550 | 52283.6 |
1008 | 2023-11-12 00:02:36 | trace | 1 | 28756 | 15 | 0.780 | 36866.7 |
1007 | 2023-11-11 05:30:11 | trace | 1 | 28756 | 15 | 0.453 | 63479.0 |
1006 | 2023-11-11 01:47:40 | trace | 1 | 28756 | 15 | 0.470 | 61183.0 |
1005 | 2023-11-10 20:23:19 | trace | 2 | 53800 | 186 | 1.453 | 37026.8 |
1004 | 2023-10-31 10:56:09 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
1003 | 2023-10-21 09:32:08 | trace | 1 | 28756 | 15 | 0.466 | 61708.2 |
1002 | 2023-10-18 19:26:43 | trace | 1 | 28756 | 15 | 0.456 | 63061.4 |
1001 | 2023-10-16 22:56:59 | trace | 1 | 28756 | 15 | 0.843 | 34111.5 |
1000 | 2023-10-14 22:13:06 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
999 | 2023-10-03 16:11:26 | trace | 1 | 28756 | 15 | 0.546 | 52666.7 |
998 | 2023-09-24 16:07:34 | trace | 1 | 28756 | 15 | 0.466 | 61708.2 |
997 | 2023-08-30 00:30:57 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
996 | 2023-06-19 12:30:36 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
995 | 2023-06-02 12:54:24 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
994 | 2023-03-26 14:48:05 | trace | 1 | 28756 | 15 | 0.466 | 61708.2 |
993 | 2023-02-21 16:51:58 | trace | 1 | 28756 | 15 | 0.516 | 55728.7 |
992 | 2023-01-27 02:43:13 | trace | 2 | 53800 | 186 | 1.610 | 33416.1 |
991 | 2023-01-10 01:41:11 | trace | 1 | 28756 | 15 | 0.420 | 68466.7 |
990 | 2022-12-12 15:22:11 | trace | 2 | 53800 | 186 | 1.593 | 33772.8 |
989 | 2022-11-02 05:38:31 | trace | 2 | 53800 | 186 | 1.750 | 30742.9 |
988 | 2022-10-28 13:13:34 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
987 | 2022-10-12 11:35:51 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
986 | 2022-08-15 02:50:46 | trace | 1 | 28756 | 15 | 0.453 | 63479.0 |
985 | 2022-07-29 10:20:01 | trace | 1 | 28756 | 15 | 1.016 | 28303.1 |
984 | 2022-07-17 20:11:21 | trace | 1 | 28756 | 15 | 0.440 | 65354.5 |
983 | 2022-07-05 04:58:12 | trace | 1 | 28756 | 15 | 0.513 | 56054.6 |
982 | 2022-06-02 06:52:22 | trace | 1 | 28756 | 15 | 0.453 | 63479.0 |
981 | 2022-03-25 14:37:11 | trace | 1 | 28756 | 15 | 0.656 | 43835.4 |
980 | 2022-03-23 11:07:37 | trace | 1 | 28756 | 15 | 0.640 | 44931.3 |
979 | 2022-03-21 08:15:22 | trace | 1 | 28756 | 15 | 0.673 | 42728.1 |
978 | 2022-03-17 21:37:38 | trace | 1 | 28756 | 15 | 0.470 | 61183.0 |
977 | 2022-03-11 12:41:16 | trace | 1 | 28756 | 15 | 0.450 | 63902.2 |
976 | 2022-03-10 22:17:19 | trace | 1 | 28756 | 15 | 0.546 | 52666.7 |
975 | 2022-03-09 20:50:10 | trace | 1 | 28756 | 15 | 0.530 | 54256.6 |
974 | 2022-03-08 16:52:28 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
973 | 2022-03-07 20:38:02 | trace | 1 | 28756 | 15 | 0.486 | 59168.7 |
972 | 2022-03-06 19:23:30 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
971 | 2022-03-05 19:11:19 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
970 | 2022-03-04 19:03:15 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
969 | 2022-03-03 12:41:38 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
968 | 2022-03-02 22:54:31 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
967 | 2022-02-22 00:07:09 | trace | 1 | 28756 | 15 | 0.546 | 52666.7 |
966 | 2022-02-18 23:39:35 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
965 | 2022-02-12 04:38:30 | trace | 1 | 28756 | 15 | 0.530 | 54256.6 |
964 | 2022-02-10 08:40:26 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
963 | 2022-02-10 02:46:09 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
962 | 2022-02-09 17:38:11 | trace | 1 | 28756 | 15 | 0.576 | 49923.6 |
961 | 2022-02-07 19:40:10 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
960 | 2022-01-21 18:34:35 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
959 | 2022-01-20 16:53:09 | trace | 1 | 28756 | 15 | 0.440 | 65354.5 |
958 | 2022-01-19 23:24:50 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
957 | 2022-01-18 23:44:50 | trace | 1 | 28756 | 15 | 0.470 | 61183.0 |
956 | 2022-01-09 11:31:32 | trace | 1 | 28756 | 15 | 0.533 | 53951.2 |
955 | 2022-01-08 18:02:02 | trace | 1 | 28756 | 15 | 0.470 | 61183.0 |
954 | 2022-01-07 12:24:15 | trace | 1 | 28756 | 15 | 0.516 | 55728.7 |
953 | 2021-12-29 09:53:59 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
952 | 2021-12-28 05:52:57 | trace | 1 | 28756 | 15 | 0.453 | 63479.0 |
951 | 2021-12-17 07:06:10 | trace | 2 | 53800 | 186 | 1.500 | 35866.7 |
950 | 2021-12-15 05:25:34 | trace | 2 | 53800 | 186 | 1.436 | 37465.2 |
949 | 2021-12-14 10:09:14 | trace | 1 | 28756 | 15 | 0.546 | 52666.7 |
948 | 2021-12-14 10:04:32 | trace | 1 | 28756 | 15 | 0.546 | 52666.7 |
947 | 2021-12-14 04:09:49 | trace | 1 | 28756 | 15 | 0.483 | 59536.2 |
946 | 2021-12-13 18:31:23 | trace | 1 | 28756 | 15 | 0.516 | 55728.7 |
945 | 2021-12-13 17:59:27 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
944 | 2021-12-13 15:23:31 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
943 | 2021-12-13 07:03:05 | trace | 1 | 28756 | 15 | 0.516 | 55728.7 |
942 | 2021-12-13 00:05:27 | trace | 1 | 28756 | 15 | 0.516 | 55728.7 |
941 | 2021-12-12 15:54:33 | trace | 1 | 28756 | 15 | 0.470 | 61183.0 |
940 | 2021-12-12 12:55:15 | trace | 1 | 28756 | 15 | 0.516 | 55728.7 |
939 | 2021-12-12 09:29:15 | trace | 1 | 28756 | 15 | 0.436 | 65954.1 |
938 | 2021-12-12 05:58:04 | trace | 1 | 28756 | 15 | 0.453 | 63479.0 |
937 | 2021-12-12 03:26:59 | trace | 1 | 28756 | 15 | 0.486 | 59168.7 |
936 | 2021-12-04 10:20:57 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
935 | 2021-12-04 03:43:26 | trace | 1 | 28756 | 15 | 0.500 | 57512.0 |
934 | 2021-12-03 19:04:57 | trace | 1 | 28756 | 15 | 0.533 | 53951.2 |
933 | 2021-12-02 00:46:37 | trace | 1 | 28756 | 15 | 0.513 | 56054.6 |