History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"casts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
968 | 2024-04-26 15:36:07 | casts | 1 | 28756 | 26 | 0.483 | 59536.2 |
967 | 2024-04-24 22:38:40 | casts | 1 | 28756 | 26 | 0.703 | 40904.7 |
966 | 2024-04-24 16:24:02 | casts | 1 | 28756 | 26 | 1.780 | 16155.1 |
965 | 2024-04-03 02:55:06 | casts | 1 | 28756 | 26 | 1.733 | 16593.2 |
964 | 2024-03-31 03:26:26 | casts | 1 | 28756 | 26 | 1.326 | 21686.3 |
963 | 2024-03-27 02:19:41 | casts | 1 | 28756 | 26 | 1.186 | 24246.2 |
962 | 2024-03-06 09:58:44 | casts | 1 | 28756 | 26 | 0.576 | 49923.6 |
961 | 2024-02-28 16:49:55 | casts | 1 | 28756 | 26 | 1.533 | 18758.0 |
960 | 2024-02-25 18:11:23 | casts | 1 | 28756 | 26 | 0.546 | 52666.7 |
959 | 2024-02-06 06:02:33 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
958 | 2024-01-28 19:50:44 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
957 | 2024-01-27 12:34:19 | casts | 1 | 28756 | 26 | 1.046 | 27491.4 |
956 | 2024-01-25 21:34:25 | casts | 1 | 28756 | 26 | 0.546 | 52666.7 |
955 | 2024-01-21 15:05:41 | casts | 1 | 28756 | 26 | 0.483 | 59536.2 |
954 | 2024-01-06 03:10:12 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
953 | 2023-12-27 12:52:41 | casts | 2 | 53800 | 313 | 1.500 | 35866.7 |
952 | 2023-12-23 00:43:24 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
951 | 2023-12-19 07:54:07 | casts | 2 | 53800 | 313 | 1.890 | 28465.6 |
950 | 2023-12-16 07:38:29 | casts | 1 | 28756 | 26 | 0.546 | 52666.7 |
949 | 2023-12-03 13:48:29 | casts | 1 | 28756 | 26 | 0.516 | 55728.7 |
948 | 2023-12-03 08:11:22 | casts | 1 | 28756 | 26 | 0.580 | 49579.3 |
947 | 2023-11-16 19:58:53 | casts | 1 | 28756 | 26 | 0.483 | 59536.2 |
946 | 2023-11-13 09:04:11 | casts | 1 | 28756 | 26 | 0.516 | 55728.7 |
945 | 2023-11-12 03:28:16 | casts | 1 | 28756 | 26 | 0.440 | 65354.5 |
944 | 2023-11-01 03:03:39 | casts | 2 | 53800 | 313 | 1.550 | 34709.7 |
943 | 2023-10-31 22:45:48 | casts | 2 | 53800 | 313 | 1.656 | 32487.9 |
942 | 2023-10-29 07:31:38 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
941 | 2023-10-26 00:42:12 | casts | 1 | 28756 | 26 | 0.533 | 53951.2 |
940 | 2023-10-20 20:53:35 | casts | 1 | 28756 | 26 | 0.530 | 54256.6 |
939 | 2023-10-17 21:06:26 | casts | 1 | 28756 | 26 | 0.580 | 49579.3 |
938 | 2023-10-17 20:21:08 | casts | 2 | 53800 | 313 | 1.733 | 31044.4 |
937 | 2023-10-13 03:43:57 | casts | 1 | 28756 | 26 | 0.516 | 55728.7 |
936 | 2023-10-04 10:17:16 | casts | 1 | 28756 | 26 | 0.450 | 63902.2 |
935 | 2023-09-22 17:45:03 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
934 | 2023-09-12 01:57:28 | casts | 1 | 28756 | 26 | 0.906 | 31739.5 |
933 | 2023-08-23 02:42:29 | casts | 1 | 28756 | 26 | 0.530 | 54256.6 |
932 | 2023-08-21 03:47:04 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
931 | 2023-07-08 23:40:05 | casts | 1 | 28756 | 26 | 0.436 | 65954.1 |
930 | 2023-05-26 04:30:03 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
929 | 2023-05-21 07:11:09 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
928 | 2023-03-26 22:08:10 | casts | 1 | 28756 | 26 | 0.436 | 65954.1 |
927 | 2023-03-23 03:27:28 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
926 | 2023-02-18 14:07:05 | casts | 1 | 28756 | 26 | 0.436 | 65954.1 |
925 | 2023-01-07 21:02:40 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
924 | 2022-11-11 22:48:11 | casts | 1 | 28756 | 26 | 0.513 | 56054.6 |
923 | 2022-10-06 01:57:25 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
922 | 2022-08-16 01:04:29 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
921 | 2022-08-15 17:06:07 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
920 | 2022-08-09 00:14:10 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
919 | 2022-07-18 10:40:15 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
918 | 2022-07-18 08:11:27 | casts | 1 | 28756 | 26 | 0.513 | 56054.6 |
917 | 2022-07-16 12:18:53 | casts | 2 | 53800 | 313 | 1.466 | 36698.5 |
916 | 2022-07-10 10:50:35 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
915 | 2022-06-25 15:59:22 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
914 | 2022-06-16 20:40:37 | casts | 1 | 28756 | 26 | 0.533 | 53951.2 |
913 | 2022-06-12 02:09:13 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
912 | 2022-06-01 19:40:37 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
911 | 2022-05-24 14:49:58 | casts | 1 | 28756 | 26 | 0.516 | 55728.7 |
910 | 2022-05-22 09:58:53 | casts | 1 | 28756 | 26 | 0.450 | 63902.2 |
909 | 2022-05-02 12:40:35 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
908 | 2022-04-28 22:17:16 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
907 | 2022-02-06 00:05:32 | casts | 1 | 28756 | 26 | 0.530 | 54256.6 |
906 | 2022-01-25 13:08:23 | casts | 1 | 28756 | 26 | 0.456 | 63061.4 |
905 | 2021-11-25 16:10:52 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
904 | 2021-10-30 22:34:47 | casts | 1 | 28756 | 26 | 0.483 | 59536.2 |
903 | 2021-10-29 19:09:08 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
902 | 2021-10-25 03:51:13 | casts | 1 | 28756 | 26 | 0.513 | 56054.6 |
901 | 2021-10-11 09:22:23 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
900 | 2021-09-07 07:27:59 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
899 | 2021-08-20 16:52:12 | casts | 1 | 28756 | 26 | 0.483 | 59536.2 |
898 | 2021-07-21 20:57:23 | casts | 1 | 28756 | 26 | 0.483 | 59536.2 |
897 | 2021-05-25 22:41:44 | casts | 1 | 28756 | 26 | 0.546 | 52666.7 |
896 | 2021-04-19 01:42:08 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
895 | 2021-03-26 16:44:49 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
894 | 2021-03-03 07:15:12 | casts | 1 | 28756 | 26 | 0.436 | 65954.1 |
893 | 2021-02-15 13:39:27 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
892 | 2021-01-18 05:50:15 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
891 | 2020-12-14 11:43:58 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
890 | 2020-11-07 10:32:51 | casts | 1 | 28756 | 26 | 0.533 | 53951.2 |
889 | 2020-10-19 12:23:38 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
888 | 2020-09-09 02:33:28 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |
887 | 2020-08-06 07:28:47 | casts | 1 | 28756 | 26 | 0.470 | 61183.0 |
886 | 2020-08-05 02:39:02 | casts | 1 | 28756 | 26 | 0.436 | 65954.1 |
885 | 2020-08-01 19:25:02 | casts | 1 | 28756 | 26 | 0.546 | 52666.7 |
884 | 2020-07-23 14:52:42 | casts | 1 | 28756 | 26 | 0.533 | 53951.2 |
883 | 2020-07-22 21:55:23 | casts | 1 | 28756 | 26 | 0.483 | 59536.2 |
882 | 2020-07-21 13:57:47 | casts | 1 | 28756 | 26 | 0.466 | 61708.2 |
881 | 2020-04-22 16:51:23 | casts | 1 | 28756 | 26 | 0.513 | 56054.6 |
880 | 2020-04-15 05:08:27 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
879 | 2020-04-08 18:05:16 | casts | 1 | 28756 | 26 | 0.466 | 61708.2 |
878 | 2020-04-01 09:05:05 | casts | 1 | 28756 | 26 | 0.466 | 61708.2 |
877 | 2020-03-30 09:27:38 | casts | 1 | 28756 | 26 | 0.530 | 54256.6 |
876 | 2020-03-25 00:18:02 | casts | 1 | 28756 | 26 | 0.546 | 52666.7 |
875 | 2020-03-24 15:42:31 | casts | 1 | 28756 | 26 | 0.610 | 47141.0 |
874 | 2020-03-23 07:17:44 | casts | 1 | 28756 | 26 | 1.110 | 25906.3 |
873 | 2020-03-22 10:18:23 | casts | 1 | 28756 | 26 | 0.546 | 52666.7 |
872 | 2020-03-21 17:04:28 | casts | 1 | 28756 | 26 | 0.466 | 61708.2 |
871 | 2020-03-21 04:15:35 | casts | 1 | 28756 | 26 | 0.516 | 55728.7 |
870 | 2020-03-18 00:09:48 | casts | 1 | 28756 | 26 | 0.500 | 57512.0 |
869 | 2020-03-10 01:51:16 | casts | 1 | 28756 | 26 | 0.453 | 63479.0 |