History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"item"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1161 | 2024-04-10 19:51:46 | item | 1 | 13983 | 4 | 0.516 | 27098.8 |
1160 | 2024-04-07 04:38:00 | item | 1 | 13983 | 4 | 0.813 | 17199.3 |
1159 | 2024-04-06 13:43:50 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1158 | 2024-04-05 00:57:04 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1157 | 2024-03-31 03:19:41 | item | 1 | 13983 | 4 | 0.513 | 27257.3 |
1156 | 2024-03-26 20:58:19 | item | 1 | 13983 | 4 | 0.533 | 26234.5 |
1155 | 2024-03-16 15:14:40 | item | 1 | 13983 | 4 | 0.263 | 53167.3 |
1154 | 2024-03-07 06:24:42 | item | 2 | 29872 | 105 | 0.966 | 30923.4 |
1153 | 2024-03-07 05:29:04 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1152 | 2024-03-05 21:18:01 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1151 | 2024-02-29 22:40:09 | item | 1 | 13983 | 4 | 0.266 | 52567.7 |
1150 | 2024-02-25 16:36:26 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1149 | 2024-02-03 19:41:23 | item | 1 | 13983 | 4 | 0.483 | 28950.3 |
1148 | 2024-02-03 00:31:57 | item | 1 | 13983 | 4 | 0.500 | 27966.0 |
1147 | 2024-01-28 15:16:51 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1146 | 2024-01-26 12:13:25 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1145 | 2024-01-01 12:56:12 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1144 | 2023-12-17 14:11:56 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1143 | 2023-12-10 00:44:26 | item | 2 | 29872 | 105 | 0.890 | 33564.0 |
1142 | 2023-12-04 20:48:54 | item | 2 | 29872 | 105 | 0.983 | 30388.6 |
1141 | 2023-11-17 15:48:19 | item | 2 | 29872 | 105 | 0.733 | 40753.1 |
1140 | 2023-11-11 04:26:02 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1139 | 2023-11-09 00:02:55 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1138 | 2023-11-07 10:09:17 | item | 1 | 13983 | 4 | 0.500 | 27966.0 |
1137 | 2023-11-05 17:57:24 | item | 2 | 29872 | 105 | 0.736 | 40587.0 |
1136 | 2023-11-05 17:18:21 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1135 | 2023-10-30 04:08:08 | item | 2 | 29872 | 105 | 0.750 | 39829.3 |
1134 | 2023-10-28 01:52:10 | item | 1 | 13983 | 4 | 0.423 | 33056.7 |
1133 | 2023-10-20 19:14:47 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1132 | 2023-10-17 04:04:40 | item | 1 | 13983 | 4 | 0.483 | 28950.3 |
1131 | 2023-10-14 03:54:23 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1130 | 2023-10-04 21:47:46 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1129 | 2023-10-04 12:16:54 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1128 | 2023-09-28 23:56:29 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1127 | 2023-09-12 15:39:28 | item | 1 | 13983 | 4 | 0.236 | 59250.0 |
1126 | 2023-09-06 01:47:24 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1125 | 2023-08-01 17:42:31 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1124 | 2023-05-20 06:40:01 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1123 | 2023-04-29 16:21:10 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1122 | 2023-03-18 22:14:14 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1121 | 2023-03-03 00:52:27 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1120 | 2023-02-20 21:30:16 | item | 1 | 13983 | 4 | 0.236 | 59250.0 |
1119 | 2023-02-07 00:29:11 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1118 | 2022-12-18 21:22:27 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1117 | 2022-11-25 07:35:07 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1116 | 2022-10-16 23:16:12 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1115 | 2022-09-17 18:07:07 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1114 | 2022-09-12 06:19:03 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1113 | 2022-09-01 16:41:18 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1112 | 2022-08-15 11:09:36 | item | 1 | 13983 | 4 | 0.236 | 59250.0 |
1111 | 2022-08-14 04:25:53 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1110 | 2022-06-26 16:06:01 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1109 | 2022-04-19 06:10:39 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1108 | 2022-04-17 05:01:58 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1107 | 2022-03-13 17:00:37 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1106 | 2022-01-12 19:52:37 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1105 | 2021-11-26 14:23:29 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1104 | 2021-11-15 00:10:03 | item | 1 | 13983 | 4 | 0.483 | 28950.3 |
1103 | 2021-10-04 19:43:19 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1102 | 2021-09-02 12:35:17 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1101 | 2021-08-31 06:30:16 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1100 | 2021-08-20 07:12:57 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1099 | 2021-08-18 05:09:35 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1098 | 2021-08-16 00:24:24 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1097 | 2021-06-27 08:40:00 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1096 | 2021-05-19 14:16:42 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1095 | 2021-03-20 16:59:44 | item | 2 | 29872 | 105 | 0.810 | 36879.0 |
1094 | 2021-02-23 09:54:31 | item | 2 | 29872 | 105 | 0.830 | 35990.4 |
1093 | 2021-02-16 16:47:05 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1092 | 2021-01-23 18:36:17 | item | 1 | 13983 | 4 | 0.236 | 59250.0 |
1091 | 2020-11-12 10:41:14 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1090 | 2020-10-17 20:41:17 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1089 | 2020-10-14 01:29:23 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1088 | 2020-09-27 19:49:51 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1087 | 2020-09-17 15:54:37 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1086 | 2020-08-25 02:56:10 | item | 1 | 13983 | 4 | 0.283 | 49409.9 |
1085 | 2020-08-15 07:33:25 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1084 | 2020-08-14 00:53:55 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1083 | 2020-08-11 20:07:39 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1082 | 2020-07-31 06:51:33 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1081 | 2020-05-22 08:39:38 | item | 1 | 13983 | 4 | 0.203 | 68881.8 |
1080 | 2020-05-13 15:23:45 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1079 | 2020-04-04 20:10:06 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1078 | 2020-03-26 21:10:42 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1077 | 2020-03-24 18:37:16 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1076 | 2020-03-24 04:01:04 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |
1075 | 2020-03-21 21:42:48 | item | 1 | 13983 | 4 | 0.263 | 53167.3 |
1074 | 2020-03-19 17:30:05 | item | 1 | 13983 | 4 | 0.216 | 64736.1 |
1073 | 2020-03-18 17:52:04 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1072 | 2020-03-17 22:11:31 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1071 | 2020-02-27 03:28:52 | item | 1 | 13983 | 4 | 0.516 | 27098.8 |
1070 | 2020-02-24 21:51:39 | item | 1 | 13983 | 4 | 0.483 | 28950.3 |
1069 | 2020-02-24 10:54:31 | item | 1 | 13983 | 4 | 0.266 | 52567.7 |
1068 | 2020-02-21 14:22:56 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1067 | 2020-02-18 00:25:04 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1066 | 2020-02-14 17:14:07 | item | 1 | 13983 | 4 | 0.266 | 52567.7 |
1065 | 2020-02-11 00:42:31 | item | 1 | 13983 | 4 | 0.220 | 63559.1 |
1064 | 2020-02-08 21:42:38 | item | 1 | 13983 | 4 | 0.546 | 25609.9 |
1063 | 2020-01-31 05:39:56 | item | 1 | 13983 | 4 | 0.250 | 55932.0 |
1062 | 2020-01-30 01:46:13 | item | 1 | 13983 | 4 | 0.233 | 60012.9 |