History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"parts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1004 | 2024-05-04 01:09:26 | parts | 1 | 28756 | 25 | 1.203 | 23903.6 |
1003 | 2024-04-30 00:22:12 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
1002 | 2024-04-29 12:46:55 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
1001 | 2024-04-27 14:57:16 | parts | 1 | 28756 | 25 | 1.796 | 16011.1 |
1000 | 2024-04-27 10:33:37 | parts | 1 | 28756 | 25 | 1.170 | 24577.8 |
999 | 2024-04-03 02:49:36 | parts | 1 | 28756 | 25 | 1.750 | 16432.0 |
998 | 2024-03-31 02:27:53 | parts | 1 | 28756 | 25 | 0.563 | 51076.4 |
997 | 2024-03-27 10:25:50 | parts | 1 | 28756 | 25 | 0.546 | 52666.7 |
996 | 2024-03-27 02:42:26 | parts | 1 | 28756 | 25 | 1.720 | 16718.6 |
995 | 2024-03-14 06:41:18 | parts | 1 | 28756 | 25 | 0.436 | 65954.1 |
994 | 2024-03-10 20:05:40 | parts | 2 | 53800 | 382 | 3.030 | 17755.8 |
993 | 2024-03-10 06:58:08 | parts | 2 | 53800 | 382 | 3.513 | 15314.5 |
992 | 2024-03-03 21:04:31 | parts | 1 | 28756 | 25 | 0.563 | 51076.4 |
991 | 2024-03-01 10:41:42 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
990 | 2024-02-26 22:32:22 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
989 | 2024-02-25 18:11:24 | parts | 1 | 28756 | 25 | 0.543 | 52957.6 |
988 | 2024-02-25 16:32:41 | parts | 1 | 28756 | 25 | 0.576 | 49923.6 |
987 | 2024-02-24 22:33:16 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
986 | 2024-02-22 22:33:12 | parts | 1 | 28756 | 25 | 0.500 | 57512.0 |
985 | 2024-01-25 20:45:45 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
984 | 2024-01-22 12:33:06 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
983 | 2024-01-22 09:24:21 | parts | 2 | 53800 | 382 | 1.390 | 38705.0 |
982 | 2024-01-19 14:36:19 | parts | 1 | 28756 | 25 | 0.513 | 56054.6 |
981 | 2024-01-09 00:19:59 | parts | 1 | 28756 | 25 | 0.500 | 57512.0 |
980 | 2023-12-27 17:34:47 | parts | 2 | 53800 | 382 | 2.470 | 21781.4 |
979 | 2023-12-26 17:07:19 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
978 | 2023-12-14 13:56:03 | parts | 1 | 28756 | 25 | 0.513 | 56054.6 |
977 | 2023-12-07 07:27:38 | parts | 1 | 28756 | 25 | 0.530 | 54256.6 |
976 | 2023-11-17 11:15:06 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
975 | 2023-11-15 00:22:18 | parts | 1 | 28756 | 25 | 0.483 | 59536.2 |
974 | 2023-11-13 09:41:38 | parts | 2 | 53800 | 382 | 1.390 | 38705.0 |
973 | 2023-11-08 11:16:10 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
972 | 2023-11-08 08:46:32 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
971 | 2023-11-07 10:51:40 | parts | 1 | 28756 | 25 | 1.170 | 24577.8 |
970 | 2023-11-06 15:48:09 | parts | 1 | 28756 | 25 | 0.533 | 53951.2 |
969 | 2023-11-01 14:41:34 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
968 | 2023-10-27 09:45:27 | parts | 2 | 53800 | 382 | 1.436 | 37465.2 |
967 | 2023-10-25 20:14:51 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
966 | 2023-10-20 21:09:09 | parts | 2 | 53800 | 382 | 1.796 | 29955.5 |
965 | 2023-10-19 15:05:57 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
964 | 2023-10-17 21:22:12 | parts | 2 | 53800 | 382 | 1.406 | 38264.6 |
963 | 2023-10-16 18:56:02 | parts | 1 | 28756 | 25 | 0.483 | 59536.2 |
962 | 2023-10-13 04:00:54 | parts | 2 | 53800 | 382 | 1.780 | 30224.7 |
961 | 2023-10-10 09:48:17 | parts | 1 | 28756 | 25 | 0.563 | 51076.4 |
960 | 2023-10-04 10:32:53 | parts | 2 | 53800 | 382 | 1.623 | 33148.5 |
959 | 2023-10-03 08:57:04 | parts | 1 | 28756 | 25 | 0.483 | 59536.2 |
958 | 2023-09-25 14:37:11 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
957 | 2023-09-22 17:32:36 | parts | 2 | 53800 | 382 | 1.420 | 37887.3 |
956 | 2023-09-18 21:44:02 | parts | 1 | 28756 | 25 | 0.470 | 61183.0 |
955 | 2023-09-12 11:42:54 | parts | 2 | 53800 | 382 | 3.096 | 17377.3 |
954 | 2023-09-10 12:56:51 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
953 | 2023-08-25 15:58:47 | parts | 1 | 28756 | 25 | 0.470 | 61183.0 |
952 | 2023-08-14 20:00:21 | parts | 1 | 28756 | 25 | 0.470 | 61183.0 |
951 | 2023-07-23 10:13:43 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
950 | 2023-07-16 19:49:04 | parts | 1 | 28756 | 25 | 1.016 | 28303.1 |
949 | 2023-05-27 07:19:06 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
948 | 2023-05-07 17:53:41 | parts | 1 | 28756 | 25 | 0.513 | 56054.6 |
947 | 2023-03-21 16:08:24 | parts | 1 | 28756 | 25 | 0.890 | 32310.1 |
946 | 2023-03-12 12:15:42 | parts | 1 | 28756 | 25 | 0.686 | 41918.4 |
945 | 2023-01-25 09:18:50 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
944 | 2023-01-21 17:03:07 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
943 | 2023-01-17 08:36:57 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
942 | 2023-01-07 23:49:41 | parts | 1 | 28756 | 25 | 0.436 | 65954.1 |
941 | 2022-11-24 20:08:51 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
940 | 2022-10-07 09:49:31 | parts | 1 | 28756 | 25 | 0.436 | 65954.1 |
939 | 2022-10-05 21:31:24 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
938 | 2022-08-23 12:07:41 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
937 | 2022-07-29 09:59:47 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
936 | 2022-06-20 16:42:06 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
935 | 2022-06-19 22:11:17 | parts | 1 | 28756 | 25 | 0.466 | 61708.2 |
934 | 2022-06-16 23:02:26 | parts | 1 | 28756 | 25 | 0.466 | 61708.2 |
933 | 2022-05-30 23:25:16 | parts | 1 | 28756 | 25 | 0.436 | 65954.1 |
932 | 2022-05-24 04:35:41 | parts | 1 | 28756 | 25 | 0.470 | 61183.0 |
931 | 2022-05-21 23:55:51 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
930 | 2022-05-18 10:47:41 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
929 | 2022-03-23 04:01:57 | parts | 1 | 28756 | 25 | 0.563 | 51076.4 |
928 | 2022-03-04 23:30:56 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
927 | 2022-02-27 23:03:26 | parts | 1 | 28756 | 25 | 0.543 | 52957.6 |
926 | 2022-02-23 09:23:27 | parts | 1 | 28756 | 25 | 0.500 | 57512.0 |
925 | 2022-02-03 10:32:50 | parts | 1 | 28756 | 25 | 0.470 | 61183.0 |
924 | 2021-12-01 10:43:46 | parts | 1 | 28756 | 25 | 0.530 | 54256.6 |
923 | 2021-11-27 09:59:30 | parts | 1 | 28756 | 25 | 1.000 | 28756.0 |
922 | 2021-11-05 12:47:05 | parts | 1 | 28756 | 25 | 0.530 | 54256.6 |
921 | 2021-10-13 01:09:54 | parts | 1 | 28756 | 25 | 0.456 | 63061.4 |
920 | 2021-09-06 22:25:22 | parts | 1 | 28756 | 25 | 0.530 | 54256.6 |
919 | 2021-08-28 10:20:35 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
918 | 2021-08-22 11:23:41 | parts | 1 | 28756 | 25 | 0.906 | 31739.5 |
917 | 2021-08-12 17:00:50 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
916 | 2021-08-07 01:15:59 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
915 | 2021-07-04 01:36:51 | parts | 1 | 28756 | 25 | 0.483 | 59536.2 |
914 | 2021-06-02 22:20:55 | parts | 1 | 28756 | 25 | 0.516 | 55728.7 |
913 | 2021-05-27 16:21:09 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
912 | 2021-05-26 09:58:40 | parts | 1 | 28756 | 25 | 0.530 | 54256.6 |
911 | 2021-03-24 16:33:29 | parts | 1 | 28756 | 25 | 0.470 | 61183.0 |
910 | 2021-03-23 20:33:04 | parts | 1 | 28756 | 25 | 0.533 | 53951.2 |
909 | 2021-02-24 11:02:44 | parts | 1 | 28756 | 25 | 0.453 | 63479.0 |
908 | 2021-02-22 09:40:04 | parts | 1 | 28756 | 25 | 0.466 | 61708.2 |
907 | 2021-02-12 20:46:49 | parts | 1 | 28756 | 25 | 0.483 | 59536.2 |
906 | 2021-01-29 23:08:11 | parts | 1 | 28756 | 25 | 0.483 | 59536.2 |
905 | 2021-01-25 11:15:35 | parts | 2 | 53800 | 382 | 1.440 | 37361.1 |