History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"recap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1003 | 2024-04-24 19:00:57 | recap | 1 | 28756 | 6 | 0.530 | 54256.6 |
1002 | 2024-04-20 16:12:45 | recap | 3 | 83667 | 968 | 10.783 | 7759.2 |
1001 | 2024-04-20 14:16:12 | recap | 1 | 28756 | 6 | 0.576 | 49923.6 |
1000 | 2024-04-20 13:50:27 | recap | 2 | 53800 | 84 | 1.720 | 31279.1 |
999 | 2024-04-20 13:48:26 | recap | 3 | 83667 | 968 | 3.860 | 21675.4 |
998 | 2024-04-20 13:45:17 | recap | 3 | 83667 | 968 | 4.156 | 20131.6 |
997 | 2024-04-20 13:44:10 | recap | 1 | 28756 | 6 | 0.546 | 52666.7 |
996 | 2024-04-20 13:39:20 | recap | 1 | 28756 | 6 | 0.516 | 55728.7 |
995 | 2024-04-05 20:28:49 | recap | 2 | 53800 | 84 | 6.186 | 8697.1 |
994 | 2024-04-05 20:23:19 | recap | 3 | 83667 | 968 | 4.783 | 17492.6 |
993 | 2024-04-03 06:55:51 | recap | 1 | 28756 | 6 | 0.453 | 63479.0 |
992 | 2024-04-03 00:36:35 | recap | 3 | 83667 | 968 | 8.406 | 9953.2 |
991 | 2024-04-02 08:28:01 | recap | 2 | 53800 | 84 | 1.813 | 29674.6 |
990 | 2024-04-02 08:27:14 | recap | 3 | 83667 | 968 | 4.310 | 19412.3 |
989 | 2024-03-31 14:35:08 | recap | 2 | 53800 | 84 | 5.360 | 10037.3 |
988 | 2024-03-31 14:35:01 | recap | 3 | 83667 | 968 | 4.936 | 16950.4 |
987 | 2024-03-31 14:34:31 | recap | 1 | 28756 | 6 | 0.593 | 48492.4 |
986 | 2024-03-28 20:40:43 | recap | 1 | 28756 | 6 | 1.046 | 27491.4 |
985 | 2024-03-15 23:26:43 | recap | 2 | 53800 | 84 | 1.983 | 27130.6 |
984 | 2024-03-04 20:31:17 | recap | 2 | 53800 | 84 | 3.406 | 15795.7 |
983 | 2024-03-04 20:31:15 | recap | 1 | 28756 | 6 | 0.580 | 49579.3 |
982 | 2024-03-04 20:30:48 | recap | 3 | 83667 | 968 | 5.453 | 15343.3 |
981 | 2024-03-03 23:24:15 | recap | 3 | 83667 | 968 | 9.390 | 8910.2 |
980 | 2024-03-03 23:24:10 | recap | 2 | 53800 | 84 | 4.890 | 11002.0 |
979 | 2024-03-03 22:19:03 | recap | 1 | 28756 | 6 | 0.516 | 55728.7 |
978 | 2024-03-01 07:50:25 | recap | 1 | 28756 | 6 | 0.513 | 56054.6 |
977 | 2024-02-28 23:19:35 | recap | 3 | 83667 | 968 | 4.220 | 19826.3 |
976 | 2024-02-27 16:35:11 | recap | 2 | 53800 | 84 | 1.640 | 32804.9 |
975 | 2024-02-27 16:34:51 | recap | 3 | 83667 | 968 | 4.330 | 19322.6 |
974 | 2024-02-26 07:44:41 | recap | 1 | 28756 | 6 | 0.466 | 61708.2 |
973 | 2024-02-25 13:23:15 | recap | 3 | 83667 | 968 | 3.406 | 24564.6 |
972 | 2024-02-05 01:45:50 | recap | 3 | 83667 | 968 | 7.843 | 10667.7 |
971 | 2024-02-02 19:48:59 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
970 | 2024-01-30 22:21:20 | recap | 2 | 53800 | 84 | 1.780 | 30224.7 |
969 | 2024-01-30 22:20:47 | recap | 3 | 83667 | 968 | 5.830 | 14351.1 |
968 | 2024-01-29 22:12:57 | recap | 3 | 83667 | 968 | 4.356 | 19207.3 |
967 | 2024-01-29 16:03:49 | recap | 3 | 83667 | 968 | 7.046 | 11874.4 |
966 | 2024-01-28 21:51:11 | recap | 1 | 28756 | 6 | 0.516 | 55728.7 |
965 | 2024-01-27 05:04:29 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
964 | 2024-01-19 09:02:09 | recap | 2 | 53800 | 84 | 1.420 | 37887.3 |
963 | 2024-01-18 13:14:27 | recap | 3 | 83667 | 968 | 3.610 | 23176.5 |
962 | 2024-01-18 13:14:29 | recap | 2 | 53800 | 84 | 1.576 | 34137.1 |
961 | 2024-01-06 16:36:23 | recap | 1 | 28756 | 6 | 0.546 | 52666.7 |
960 | 2023-12-28 08:18:49 | recap | 3 | 83667 | 968 | 4.003 | 20901.1 |
959 | 2023-12-28 08:18:50 | recap | 2 | 53800 | 84 | 1.800 | 29888.9 |
958 | 2023-12-14 02:16:41 | recap | 3 | 83667 | 968 | 3.326 | 25155.4 |
957 | 2023-12-12 15:35:07 | recap | 2 | 53800 | 84 | 1.766 | 30464.3 |
956 | 2023-12-03 09:41:55 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
955 | 2023-12-03 09:41:54 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
954 | 2023-11-17 22:56:06 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
953 | 2023-11-13 05:50:30 | recap | 1 | 28756 | 6 | 0.436 | 65954.1 |
952 | 2023-10-28 19:54:10 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
951 | 2023-10-28 09:00:33 | recap | 1 | 28756 | 6 | 0.483 | 59536.2 |
950 | 2023-10-28 03:25:57 | recap | 2 | 53800 | 84 | 1.673 | 32157.8 |
949 | 2023-10-20 06:54:39 | recap | 1 | 28756 | 6 | 0.483 | 59536.2 |
948 | 2023-10-18 16:54:54 | recap | 1 | 28756 | 6 | 0.516 | 55728.7 |
947 | 2023-10-16 23:07:47 | recap | 1 | 28756 | 6 | 0.470 | 61183.0 |
946 | 2023-10-14 02:43:15 | recap | 1 | 28756 | 6 | 0.436 | 65954.1 |
945 | 2023-10-07 16:23:56 | recap | 1 | 28756 | 6 | 0.453 | 63479.0 |
944 | 2023-09-26 13:50:04 | recap | 1 | 28756 | 6 | 0.453 | 63479.0 |
943 | 2023-09-24 03:28:52 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
942 | 2023-08-23 12:52:30 | recap | 1 | 28756 | 6 | 0.483 | 59536.2 |
941 | 2023-08-05 19:08:48 | recap | 2 | 53800 | 84 | 1.423 | 37807.4 |
940 | 2023-06-22 18:16:24 | recap | 1 | 28756 | 6 | 0.470 | 61183.0 |
939 | 2023-05-25 02:20:09 | recap | 1 | 28756 | 6 | 0.440 | 65354.5 |
938 | 2023-04-17 22:19:32 | recap | 2 | 53800 | 84 | 1.390 | 38705.0 |
937 | 2023-03-22 08:17:23 | recap | 1 | 28756 | 6 | 0.873 | 32939.3 |
936 | 2023-02-28 12:19:19 | recap | 1 | 28756 | 6 | 0.440 | 65354.5 |
935 | 2023-01-27 23:51:11 | recap | 2 | 53800 | 84 | 1.610 | 33416.1 |
934 | 2023-01-08 19:39:04 | recap | 1 | 28756 | 6 | 0.486 | 59168.7 |
933 | 2022-11-08 03:46:02 | recap | 1 | 28756 | 6 | 0.436 | 65954.1 |
932 | 2022-11-07 21:03:17 | recap | 2 | 53800 | 84 | 1.373 | 39184.3 |
931 | 2022-10-15 04:11:41 | recap | 1 | 28756 | 6 | 0.436 | 65954.1 |
930 | 2022-09-12 21:51:05 | recap | 3 | 83667 | 968 | 3.576 | 23396.8 |
929 | 2022-08-18 23:39:19 | recap | 3 | 83667 | 968 | 3.420 | 24464.0 |
928 | 2022-07-18 18:32:34 | recap | 1 | 28756 | 6 | 0.453 | 63479.0 |
927 | 2022-06-06 12:04:45 | recap | 1 | 28756 | 6 | 0.486 | 59168.7 |
926 | 2022-06-04 07:03:14 | recap | 1 | 28756 | 6 | 0.516 | 55728.7 |
925 | 2022-05-30 19:18:04 | recap | 1 | 28756 | 6 | 0.796 | 36125.6 |
924 | 2022-05-19 03:23:22 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
923 | 2022-05-16 21:01:56 | recap | 2 | 53800 | 84 | 1.733 | 31044.4 |
922 | 2022-04-04 02:10:07 | recap | 1 | 28756 | 6 | 0.453 | 63479.0 |
921 | 2022-02-11 23:50:46 | recap | 1 | 28756 | 6 | 0.436 | 65954.1 |
920 | 2021-12-20 07:58:13 | recap | 1 | 28756 | 6 | 0.546 | 52666.7 |
919 | 2021-12-16 16:53:27 | recap | 1 | 28756 | 6 | 0.513 | 56054.6 |
918 | 2021-12-05 16:09:08 | recap | 1 | 28756 | 6 | 0.516 | 55728.7 |
917 | 2021-10-19 03:51:35 | recap | 1 | 28756 | 6 | 0.453 | 63479.0 |
916 | 2021-09-09 21:09:01 | recap | 1 | 28756 | 6 | 0.500 | 57512.0 |
915 | 2021-09-06 20:15:32 | recap | 1 | 28756 | 6 | 0.470 | 61183.0 |
914 | 2021-09-04 15:17:42 | recap | 1 | 28756 | 6 | 0.436 | 65954.1 |
913 | 2021-09-03 05:35:32 | recap | 1 | 28756 | 6 | 0.450 | 63902.2 |
912 | 2021-09-01 01:50:06 | recap | 1 | 28756 | 6 | 0.453 | 63479.0 |
911 | 2021-08-18 01:39:33 | recap | 1 | 28756 | 6 | 0.450 | 63902.2 |
910 | 2021-07-15 18:27:13 | recap | 2 | 53800 | 84 | 1.483 | 36277.8 |
909 | 2021-06-08 22:59:36 | recap | 1 | 28756 | 6 | 0.530 | 54256.6 |
908 | 2021-05-22 21:29:48 | recap | 3 | 83667 | 968 | 3.703 | 22594.4 |
907 | 2021-05-05 02:33:17 | recap | 2 | 53800 | 84 | 1.720 | 31279.1 |
906 | 2021-05-03 20:44:58 | recap | 1 | 28756 | 6 | 0.530 | 54256.6 |
905 | 2021-04-11 05:48:35 | recap | 3 | 83667 | 968 | 3.376 | 24782.9 |
904 | 2021-04-03 04:21:20 | recap | 2 | 53800 | 84 | 1.470 | 36598.6 |