History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1002 | 2024-04-03 03:24:40 | shier | 1 | 28756 | 16 | 1.283 | 22413.1 |
1001 | 2024-03-31 08:44:41 | shier | 2 | 53800 | 217 | 4.703 | 11439.5 |
1000 | 2024-03-31 08:41:55 | shier | 1 | 28756 | 16 | 0.563 | 51076.4 |
999 | 2024-03-28 14:48:47 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
998 | 2024-03-27 00:50:59 | shier | 1 | 28756 | 16 | 0.516 | 55728.7 |
997 | 2024-03-19 04:44:46 | shier | 1 | 28756 | 16 | 1.060 | 27128.3 |
996 | 2024-03-17 13:16:07 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
995 | 2024-03-13 18:08:08 | shier | 1 | 28756 | 16 | 1.736 | 16564.5 |
994 | 2024-03-03 21:18:13 | shier | 1 | 28756 | 16 | 0.530 | 54256.6 |
993 | 2024-03-03 04:19:18 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
992 | 2024-03-01 07:10:16 | shier | 1 | 28756 | 16 | 0.533 | 53951.2 |
991 | 2024-02-28 04:44:55 | shier | 1 | 28756 | 16 | 1.703 | 16885.5 |
990 | 2024-02-25 17:48:03 | shier | 1 | 28756 | 16 | 0.470 | 61183.0 |
989 | 2024-02-03 03:53:39 | shier | 1 | 28756 | 16 | 0.513 | 56054.6 |
988 | 2024-01-25 22:47:41 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
987 | 2024-01-21 11:19:30 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
986 | 2024-01-01 21:39:49 | shier | 1 | 28756 | 16 | 0.530 | 54256.6 |
985 | 2023-12-26 05:28:27 | shier | 1 | 28756 | 16 | 0.450 | 63902.2 |
984 | 2023-12-15 15:09:04 | shier | 2 | 53800 | 217 | 1.766 | 30464.3 |
983 | 2023-12-10 12:38:37 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
982 | 2023-12-06 20:12:04 | shier | 1 | 28756 | 16 | 0.486 | 59168.7 |
981 | 2023-12-01 08:30:13 | shier | 2 | 53800 | 217 | 1.563 | 34421.0 |
980 | 2023-11-28 15:47:40 | shier | 2 | 53800 | 217 | 1.376 | 39098.8 |
979 | 2023-11-22 11:09:12 | shier | 1 | 28756 | 16 | 0.513 | 56054.6 |
978 | 2023-11-21 18:25:58 | shier | 2 | 53800 | 217 | 1.513 | 35558.5 |
977 | 2023-11-14 01:24:55 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
976 | 2023-11-11 20:48:59 | shier | 2 | 53800 | 217 | 1.686 | 31909.8 |
975 | 2023-11-09 06:41:54 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
974 | 2023-10-27 15:07:02 | shier | 1 | 28756 | 16 | 0.513 | 56054.6 |
973 | 2023-10-21 08:30:10 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
972 | 2023-10-17 19:54:33 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
971 | 2023-10-11 11:55:55 | shier | 1 | 28756 | 16 | 0.516 | 55728.7 |
970 | 2023-10-11 01:30:37 | shier | 2 | 53800 | 217 | 1.500 | 35866.7 |
969 | 2023-10-09 06:46:15 | shier | 2 | 53800 | 217 | 1.783 | 30173.9 |
968 | 2023-10-03 15:28:26 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
967 | 2023-09-26 15:27:48 | shier | 2 | 53800 | 217 | 1.373 | 39184.3 |
966 | 2023-09-24 10:09:13 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
965 | 2023-09-20 13:51:32 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
964 | 2023-09-19 15:50:13 | shier | 1 | 28756 | 16 | 0.486 | 59168.7 |
963 | 2023-08-21 01:44:06 | shier | 1 | 28756 | 16 | 0.563 | 51076.4 |
962 | 2023-07-14 14:40:36 | shier | 1 | 28756 | 16 | 0.516 | 55728.7 |
961 | 2023-05-10 16:22:13 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
960 | 2023-04-17 06:15:43 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
959 | 2023-02-09 02:27:53 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
958 | 2023-01-28 12:19:36 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
957 | 2023-01-24 20:52:04 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
956 | 2022-12-07 02:34:46 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
955 | 2022-11-20 23:59:05 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
954 | 2022-11-19 04:15:30 | shier | 1 | 28756 | 16 | 0.466 | 61708.2 |
953 | 2022-11-16 18:36:58 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
952 | 2022-10-06 22:40:01 | shier | 1 | 28756 | 16 | 1.266 | 22714.1 |
951 | 2022-08-09 16:37:18 | shier | 1 | 28756 | 16 | 0.516 | 55728.7 |
950 | 2022-07-29 07:30:53 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
949 | 2022-07-12 14:12:52 | shier | 1 | 28756 | 16 | 0.470 | 61183.0 |
948 | 2022-07-11 21:05:41 | shier | 1 | 28756 | 16 | 0.576 | 49923.6 |
947 | 2022-07-09 12:50:23 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
946 | 2022-07-08 16:33:17 | shier | 1 | 28756 | 16 | 0.470 | 61183.0 |
945 | 2022-07-06 13:49:59 | shier | 1 | 28756 | 16 | 0.486 | 59168.7 |
944 | 2022-07-05 14:51:15 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
943 | 2022-07-03 13:04:07 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
942 | 2022-07-02 11:09:55 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
941 | 2022-07-01 14:40:45 | shier | 1 | 28756 | 16 | 0.450 | 63902.2 |
940 | 2022-06-30 22:56:04 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
939 | 2022-06-23 22:18:18 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
938 | 2022-03-30 00:41:15 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
937 | 2022-03-11 20:59:09 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
936 | 2022-03-11 06:25:00 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
935 | 2022-03-03 20:58:43 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
934 | 2022-02-07 15:23:27 | shier | 1 | 28756 | 16 | 0.436 | 65954.1 |
933 | 2022-02-06 09:37:07 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
932 | 2022-02-05 07:53:59 | shier | 1 | 28756 | 16 | 0.466 | 61708.2 |
931 | 2022-02-04 08:16:32 | shier | 1 | 28756 | 16 | 0.470 | 61183.0 |
930 | 2022-02-03 05:48:09 | shier | 1 | 28756 | 16 | 0.486 | 59168.7 |
929 | 2022-02-02 09:35:38 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
928 | 2022-02-01 05:34:09 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
927 | 2022-01-31 05:15:29 | shier | 1 | 28756 | 16 | 0.450 | 63902.2 |
926 | 2022-01-30 10:23:58 | shier | 1 | 28756 | 16 | 0.486 | 59168.7 |
925 | 2022-01-29 08:41:53 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
924 | 2022-01-04 22:11:30 | shier | 1 | 28756 | 16 | 0.576 | 49923.6 |
923 | 2022-01-03 20:09:57 | shier | 1 | 28756 | 16 | 0.533 | 53951.2 |
922 | 2022-01-03 09:55:17 | shier | 1 | 28756 | 16 | 0.483 | 59536.2 |
921 | 2022-01-02 19:40:23 | shier | 1 | 28756 | 16 | 0.500 | 57512.0 |
920 | 2022-01-01 01:45:27 | shier | 1 | 28756 | 16 | 0.530 | 54256.6 |
919 | 2021-12-31 14:51:54 | shier | 1 | 28756 | 16 | 0.533 | 53951.2 |
918 | 2021-12-31 06:45:43 | shier | 1 | 28756 | 16 | 0.560 | 51350.0 |
917 | 2021-12-30 14:38:05 | shier | 1 | 28756 | 16 | 1.280 | 22465.6 |
916 | 2021-12-29 19:33:41 | shier | 1 | 28756 | 16 | 0.530 | 54256.6 |
915 | 2021-12-29 08:16:18 | shier | 1 | 28756 | 16 | 0.466 | 61708.2 |
914 | 2021-12-28 19:09:30 | shier | 1 | 28756 | 16 | 0.470 | 61183.0 |
913 | 2021-12-28 03:21:12 | shier | 1 | 28756 | 16 | 0.470 | 61183.0 |
912 | 2021-12-27 18:04:18 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
911 | 2021-12-27 09:11:44 | shier | 1 | 28756 | 16 | 0.516 | 55728.7 |
910 | 2021-12-26 17:26:15 | shier | 1 | 28756 | 16 | 0.453 | 63479.0 |
909 | 2021-12-26 06:43:50 | shier | 1 | 28756 | 16 | 0.533 | 53951.2 |
908 | 2021-12-25 18:14:48 | shier | 1 | 28756 | 16 | 0.516 | 55728.7 |
907 | 2021-12-25 06:02:53 | shier | 1 | 28756 | 16 | 0.530 | 54256.6 |
906 | 2021-12-24 23:22:13 | shier | 1 | 28756 | 16 | 0.470 | 61183.0 |
905 | 2021-12-24 09:54:00 | shier | 1 | 28756 | 16 | 0.563 | 51076.4 |
904 | 2021-12-07 15:17:04 | shier | 1 | 28756 | 16 | 0.486 | 59168.7 |
903 | 2021-12-07 11:20:41 | shier | 1 | 28756 | 16 | 0.516 | 55728.7 |