History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"part"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1094 | 2024-04-08 15:28:06 | part | 1 | 13983 | 28 | 0.516 | 27098.8 |
1093 | 2024-04-05 11:51:53 | part | 1 | 13983 | 28 | 0.890 | 15711.2 |
1092 | 2024-04-05 11:51:33 | part | 2 | 29872 | 404 | 1.160 | 25751.7 |
1091 | 2024-04-01 16:21:45 | part | 1 | 13983 | 28 | 0.280 | 49939.3 |
1090 | 2024-03-31 00:49:32 | part | 2 | 29872 | 404 | 3.313 | 9016.6 |
1089 | 2024-03-30 23:12:56 | part | 1 | 13983 | 28 | 0.530 | 26383.0 |
1088 | 2024-03-09 04:22:28 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1087 | 2024-03-02 12:45:14 | part | 1 | 13983 | 28 | 0.283 | 49409.9 |
1086 | 2024-02-17 16:21:41 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1085 | 2024-01-23 00:21:38 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1084 | 2024-01-07 09:16:25 | part | 2 | 29872 | 404 | 0.920 | 32469.6 |
1083 | 2023-12-27 18:32:35 | part | 1 | 13983 | 28 | 0.266 | 52567.7 |
1082 | 2023-12-12 13:25:02 | part | 2 | 29872 | 404 | 0.750 | 39829.3 |
1081 | 2023-11-27 08:13:28 | part | 2 | 29872 | 404 | 0.890 | 33564.0 |
1080 | 2023-11-10 23:29:31 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1079 | 2023-11-10 07:44:15 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1078 | 2023-11-08 03:09:48 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1077 | 2023-10-30 00:31:47 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1076 | 2023-10-27 00:22:42 | part | 2 | 29872 | 404 | 0.843 | 35435.3 |
1075 | 2023-10-26 00:03:26 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1074 | 2023-10-24 22:00:32 | part | 2 | 29872 | 404 | 0.766 | 38997.4 |
1073 | 2023-10-19 18:44:17 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1072 | 2023-10-17 17:04:02 | part | 2 | 29872 | 404 | 0.876 | 34100.5 |
1071 | 2023-10-16 18:47:48 | part | 1 | 13983 | 28 | 0.266 | 52567.7 |
1070 | 2023-10-16 13:56:38 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1069 | 2023-10-15 15:18:21 | part | 2 | 29872 | 404 | 0.876 | 34100.5 |
1068 | 2023-10-10 17:38:02 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1067 | 2023-10-03 22:45:44 | part | 2 | 29872 | 404 | 0.936 | 31914.5 |
1066 | 2023-10-03 08:33:16 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1065 | 2023-09-28 00:42:04 | part | 2 | 29872 | 404 | 0.890 | 33564.0 |
1064 | 2023-09-20 16:29:54 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1063 | 2023-09-19 18:59:51 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1062 | 2023-09-03 07:28:16 | part | 1 | 13983 | 28 | 0.236 | 59250.0 |
1061 | 2023-08-13 16:10:35 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1060 | 2023-08-13 10:23:01 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1059 | 2023-07-21 15:10:14 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1058 | 2023-05-13 15:34:54 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1057 | 2023-04-13 15:51:03 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1056 | 2023-03-27 14:01:46 | part | 1 | 13983 | 28 | 0.203 | 68881.8 |
1055 | 2023-03-09 10:58:15 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1054 | 2023-02-22 22:46:47 | part | 2 | 29872 | 404 | 0.890 | 33564.0 |
1053 | 2023-02-16 23:26:45 | part | 2 | 29872 | 404 | 0.750 | 39829.3 |
1052 | 2023-02-10 16:06:32 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1051 | 2023-02-09 13:55:45 | part | 1 | 13983 | 28 | 0.263 | 53167.3 |
1050 | 2023-01-08 14:06:41 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1049 | 2023-01-02 08:15:57 | part | 2 | 29872 | 404 | 0.733 | 40753.1 |
1048 | 2022-12-30 13:35:12 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1047 | 2022-12-23 01:08:16 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1046 | 2022-11-26 21:52:03 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1045 | 2022-11-24 00:52:15 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1044 | 2022-11-12 03:38:56 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1043 | 2022-09-24 18:43:37 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1042 | 2022-09-21 04:13:42 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1041 | 2022-09-17 20:49:37 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1040 | 2022-09-01 07:31:09 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1039 | 2022-08-27 02:57:11 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1038 | 2022-08-26 09:47:23 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1037 | 2022-08-17 17:26:53 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1036 | 2022-08-16 04:20:45 | part | 1 | 13983 | 28 | 0.236 | 59250.0 |
1035 | 2022-08-09 11:51:39 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1034 | 2022-07-29 10:04:26 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1033 | 2022-07-16 07:37:08 | part | 1 | 13983 | 28 | 0.236 | 59250.0 |
1032 | 2022-07-01 10:22:14 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1031 | 2022-06-04 05:08:36 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1030 | 2022-05-23 03:02:26 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1029 | 2022-05-07 16:12:44 | part | 1 | 13983 | 28 | 0.263 | 53167.3 |
1028 | 2022-04-28 05:50:30 | part | 1 | 13983 | 28 | 0.236 | 59250.0 |
1027 | 2022-04-27 14:26:43 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1026 | 2022-04-27 01:33:34 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1025 | 2022-04-26 11:44:24 | part | 1 | 13983 | 28 | 0.280 | 49939.3 |
1024 | 2022-04-26 04:11:49 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1023 | 2022-04-25 13:46:49 | part | 1 | 13983 | 28 | 0.236 | 59250.0 |
1022 | 2022-04-24 22:30:29 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1021 | 2022-04-24 04:03:24 | part | 1 | 13983 | 28 | 0.266 | 52567.7 |
1020 | 2022-04-23 10:59:56 | part | 1 | 13983 | 28 | 0.266 | 52567.7 |
1019 | 2022-04-22 13:23:33 | part | 1 | 13983 | 28 | 0.236 | 59250.0 |
1018 | 2022-04-21 19:25:29 | part | 1 | 13983 | 28 | 0.330 | 42372.7 |
1017 | 2022-04-21 06:29:47 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1016 | 2022-04-20 14:03:52 | part | 1 | 13983 | 28 | 0.283 | 49409.9 |
1015 | 2022-04-19 19:08:28 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1014 | 2022-04-19 04:37:23 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1013 | 2022-04-18 03:33:56 | part | 1 | 13983 | 28 | 0.266 | 52567.7 |
1012 | 2022-04-17 18:21:00 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1011 | 2022-04-16 23:13:32 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
1010 | 2022-04-15 06:07:36 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1009 | 2022-03-25 18:58:20 | part | 1 | 13983 | 28 | 0.266 | 52567.7 |
1008 | 2022-03-23 15:22:47 | part | 1 | 13983 | 28 | 0.280 | 49939.3 |
1007 | 2022-03-18 01:55:21 | part | 1 | 13983 | 28 | 0.220 | 63559.1 |
1006 | 2022-03-17 20:03:41 | part | 1 | 13983 | 28 | 0.360 | 38841.7 |
1005 | 2022-03-15 23:23:59 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1004 | 2022-03-04 03:54:34 | part | 1 | 13983 | 28 | 0.296 | 47239.9 |
1003 | 2022-02-25 20:40:01 | part | 1 | 13983 | 28 | 0.216 | 64736.1 |
1002 | 2022-02-24 09:16:22 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1001 | 2022-01-13 09:01:52 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
1000 | 2022-01-12 09:12:07 | part | 1 | 13983 | 28 | 0.423 | 33056.7 |
999 | 2022-01-11 12:48:41 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |
998 | 2022-01-10 14:27:02 | part | 1 | 13983 | 28 | 0.266 | 52567.7 |
997 | 2021-12-31 17:22:57 | part | 1 | 13983 | 28 | 0.343 | 40766.8 |
996 | 2021-12-31 06:32:03 | part | 1 | 13983 | 28 | 0.250 | 55932.0 |
995 | 2021-12-30 17:19:58 | part | 1 | 13983 | 28 | 0.233 | 60012.9 |