History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
977 | 2024-04-21 16:54:14 | mates | 1 | 28756 | 39 | 0.546 | 52666.7 |
976 | 2024-04-14 08:10:10 | mates | 1 | 28756 | 39 | 0.610 | 47141.0 |
975 | 2024-04-03 03:41:29 | mates | 1 | 28756 | 39 | 1.716 | 16757.6 |
974 | 2024-03-30 22:28:31 | mates | 2 | 53800 | 504 | 6.343 | 8481.8 |
973 | 2024-03-30 21:56:39 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
972 | 2024-03-29 01:25:33 | mates | 2 | 53800 | 504 | 5.953 | 9037.5 |
971 | 2024-03-29 01:11:39 | mates | 1 | 28756 | 39 | 0.576 | 49923.6 |
970 | 2024-03-24 04:34:48 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
969 | 2024-03-22 03:18:35 | mates | 1 | 28756 | 39 | 1.126 | 25538.2 |
968 | 2024-03-03 20:45:43 | mates | 1 | 28756 | 39 | 0.563 | 51076.4 |
967 | 2024-02-27 22:55:51 | mates | 2 | 53800 | 504 | 1.860 | 28924.7 |
966 | 2024-02-27 20:43:35 | mates | 1 | 28756 | 39 | 0.530 | 54256.6 |
965 | 2024-02-20 13:19:14 | mates | 1 | 28756 | 39 | 1.093 | 26309.2 |
964 | 2024-02-02 18:55:03 | mates | 1 | 28756 | 39 | 0.513 | 56054.6 |
963 | 2024-01-26 04:22:37 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
962 | 2024-01-20 07:54:50 | mates | 2 | 53800 | 504 | 1.423 | 37807.4 |
961 | 2024-01-11 03:48:39 | mates | 2 | 53800 | 504 | 1.626 | 33087.3 |
960 | 2023-12-29 02:15:47 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
959 | 2023-12-16 20:20:42 | mates | 1 | 28756 | 39 | 0.576 | 49923.6 |
958 | 2023-12-12 03:46:55 | mates | 2 | 53800 | 504 | 1.626 | 33087.3 |
957 | 2023-11-24 17:44:25 | mates | 2 | 53800 | 504 | 1.593 | 33772.8 |
956 | 2023-11-24 05:01:14 | mates | 2 | 53800 | 504 | 1.420 | 37887.3 |
955 | 2023-11-14 23:08:33 | mates | 2 | 53800 | 504 | 1.393 | 38621.7 |
954 | 2023-11-14 17:14:00 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
953 | 2023-11-09 16:28:18 | mates | 1 | 28756 | 39 | 0.450 | 63902.2 |
952 | 2023-11-09 04:04:42 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
951 | 2023-11-06 15:45:18 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |
950 | 2023-11-05 04:35:22 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |
949 | 2023-10-30 12:34:18 | mates | 1 | 28756 | 39 | 0.596 | 48248.3 |
948 | 2023-10-28 09:09:57 | mates | 2 | 53800 | 504 | 1.610 | 33416.1 |
947 | 2023-10-21 12:07:30 | mates | 1 | 28756 | 39 | 0.483 | 59536.2 |
946 | 2023-10-18 11:26:14 | mates | 1 | 28756 | 39 | 0.440 | 65354.5 |
945 | 2023-10-15 11:47:05 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
944 | 2023-10-05 06:41:05 | mates | 1 | 28756 | 39 | 0.466 | 61708.2 |
943 | 2023-10-04 08:31:53 | mates | 1 | 28756 | 39 | 0.563 | 51076.4 |
942 | 2023-09-23 21:48:35 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
941 | 2023-09-23 11:42:08 | mates | 1 | 28756 | 39 | 0.440 | 65354.5 |
940 | 2023-08-07 19:56:01 | mates | 2 | 53800 | 504 | 1.406 | 38264.6 |
939 | 2023-08-01 16:16:35 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
938 | 2023-08-01 06:22:21 | mates | 1 | 28756 | 39 | 0.440 | 65354.5 |
937 | 2023-04-30 12:43:59 | mates | 1 | 28756 | 39 | 0.530 | 54256.6 |
936 | 2023-04-27 22:49:46 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
935 | 2023-04-11 11:44:32 | mates | 2 | 53800 | 504 | 1.436 | 37465.2 |
934 | 2023-02-23 06:59:20 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |
933 | 2023-01-23 03:06:45 | mates | 1 | 28756 | 39 | 0.420 | 68466.7 |
932 | 2023-01-18 04:50:57 | mates | 2 | 53800 | 504 | 1.563 | 34421.0 |
931 | 2022-12-22 02:29:33 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
930 | 2022-11-25 16:02:22 | mates | 1 | 28756 | 39 | 0.440 | 65354.5 |
929 | 2022-10-28 12:59:25 | mates | 2 | 53800 | 504 | 1.656 | 32487.9 |
928 | 2022-10-16 05:14:31 | mates | 1 | 28756 | 39 | 0.440 | 65354.5 |
927 | 2022-09-06 21:26:57 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
926 | 2022-09-01 21:52:57 | mates | 1 | 28756 | 39 | 1.140 | 25224.6 |
925 | 2022-08-05 18:40:48 | mates | 2 | 53800 | 504 | 1.593 | 33772.8 |
924 | 2022-07-03 14:37:53 | mates | 1 | 28756 | 39 | 0.483 | 59536.2 |
923 | 2022-06-25 23:50:36 | mates | 2 | 53800 | 504 | 1.390 | 38705.0 |
922 | 2022-05-27 20:30:27 | mates | 2 | 53800 | 504 | 1.390 | 38705.0 |
921 | 2022-04-15 20:48:23 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
920 | 2022-03-26 16:13:05 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |
919 | 2022-03-15 11:58:39 | mates | 1 | 28756 | 39 | 0.530 | 54256.6 |
918 | 2022-03-14 19:55:16 | mates | 1 | 28756 | 39 | 0.546 | 52666.7 |
917 | 2022-03-13 19:58:00 | mates | 1 | 28756 | 39 | 0.470 | 61183.0 |
916 | 2022-03-12 18:31:38 | mates | 1 | 28756 | 39 | 0.546 | 52666.7 |
915 | 2022-01-11 13:59:41 | mates | 1 | 28756 | 39 | 0.486 | 59168.7 |
914 | 2022-01-09 15:26:34 | mates | 1 | 28756 | 39 | 0.550 | 52283.6 |
913 | 2022-01-08 21:58:54 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
912 | 2022-01-07 16:28:03 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
911 | 2022-01-06 17:05:20 | mates | 1 | 28756 | 39 | 0.466 | 61708.2 |
910 | 2021-12-22 04:11:31 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
909 | 2021-12-18 22:38:56 | mates | 1 | 28756 | 39 | 0.530 | 54256.6 |
908 | 2021-11-09 15:35:41 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |
907 | 2021-09-27 05:01:02 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
906 | 2021-09-20 14:48:56 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
905 | 2021-09-19 12:43:42 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
904 | 2021-09-14 23:20:55 | mates | 1 | 28756 | 39 | 0.530 | 54256.6 |
903 | 2021-09-13 11:00:11 | mates | 1 | 28756 | 39 | 0.596 | 48248.3 |
902 | 2021-08-25 15:25:51 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |
901 | 2021-08-23 11:46:42 | mates | 1 | 28756 | 39 | 0.483 | 59536.2 |
900 | 2021-08-22 00:14:43 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
899 | 2021-08-19 23:31:06 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
898 | 2021-08-17 17:20:21 | mates | 1 | 28756 | 39 | 0.486 | 59168.7 |
897 | 2021-08-14 21:03:23 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
896 | 2021-07-04 00:05:47 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
895 | 2021-07-03 13:27:20 | mates | 1 | 28756 | 39 | 0.516 | 55728.7 |
894 | 2021-07-02 17:27:00 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
893 | 2021-07-02 00:03:52 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |
892 | 2021-06-28 02:13:26 | mates | 1 | 28756 | 39 | 0.533 | 53951.2 |
891 | 2021-06-28 02:06:08 | mates | 1 | 28756 | 39 | 0.500 | 57512.0 |
890 | 2021-06-25 05:34:48 | mates | 1 | 28756 | 39 | 0.486 | 59168.7 |
889 | 2021-06-17 06:32:18 | mates | 1 | 28756 | 39 | 0.513 | 56054.6 |
888 | 2021-06-14 23:00:59 | mates | 1 | 28756 | 39 | 0.546 | 52666.7 |
887 | 2021-06-09 01:31:48 | mates | 1 | 28756 | 39 | 0.483 | 59536.2 |
886 | 2021-05-17 09:07:00 | mates | 1 | 28756 | 39 | 0.483 | 59536.2 |
885 | 2021-04-18 03:44:24 | mates | 1 | 28756 | 39 | 0.563 | 51076.4 |
884 | 2021-04-17 09:05:42 | mates | 1 | 28756 | 39 | 0.483 | 59536.2 |
883 | 2021-04-10 05:40:13 | mates | 1 | 28756 | 39 | 0.483 | 59536.2 |
882 | 2021-04-02 21:06:23 | mates | 1 | 28756 | 39 | 1.030 | 27918.4 |
881 | 2021-03-13 17:05:39 | mates | 1 | 28756 | 39 | 0.440 | 65354.5 |
880 | 2021-03-12 20:21:31 | mates | 1 | 28756 | 39 | 0.530 | 54256.6 |
879 | 2021-03-12 00:48:17 | mates | 1 | 28756 | 39 | 0.436 | 65954.1 |
878 | 2021-03-10 16:23:13 | mates | 1 | 28756 | 39 | 0.453 | 63479.0 |