History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"olive"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1239 | 2024-04-08 16:29:06 | olive | 1 | 28756 | 5 | 1.250 | 23004.8 |
| 1238 | 2024-04-03 06:07:46 | olive | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1237 | 2024-03-31 14:17:40 | olive | 1 | 28756 | 5 | 0.623 | 46157.3 |
| 1236 | 2024-03-29 08:40:51 | olive | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 1235 | 2024-03-08 19:07:42 | olive | 1 | 28756 | 5 | 1.156 | 24875.4 |
| 1234 | 2024-03-04 10:56:40 | olive | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1233 | 2024-03-04 10:55:49 | olive | 3 | 83667 | 1178 | 4.423 | 18916.3 |
| 1232 | 2024-03-03 23:45:19 | olive | 3 | 83667 | 1178 | 11.513 | 7267.2 |
| 1231 | 2024-03-03 23:45:24 | olive | 2 | 53800 | 87 | 5.546 | 9700.7 |
| 1230 | 2024-03-03 22:06:11 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1229 | 2024-03-01 12:20:42 | olive | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1228 | 2024-02-28 07:28:08 | olive | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1227 | 2024-02-06 22:28:41 | olive | 2 | 53800 | 87 | 1.390 | 38705.0 |
| 1226 | 2024-02-06 22:28:37 | olive | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1225 | 2024-01-29 03:18:59 | olive | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1224 | 2024-01-29 02:53:29 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1223 | 2024-01-22 09:28:25 | olive | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1222 | 2024-01-17 11:19:52 | olive | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1221 | 2024-01-12 01:44:25 | olive | 3 | 83667 | 1178 | 3.360 | 24900.9 |
| 1220 | 2024-01-07 14:31:47 | olive | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1219 | 2023-12-31 08:27:56 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1218 | 2023-12-16 04:14:56 | olive | 1 | 28756 | 5 | 0.580 | 49579.3 |
| 1217 | 2023-12-12 06:25:10 | olive | 3 | 83667 | 1178 | 3.830 | 21845.2 |
| 1216 | 2023-11-28 00:16:42 | olive | 2 | 53800 | 87 | 1.563 | 34421.0 |
| 1215 | 2023-11-25 19:42:56 | olive | 3 | 83667 | 1178 | 3.893 | 21491.7 |
| 1214 | 2023-11-22 17:38:36 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1213 | 2023-11-15 17:16:39 | olive | 3 | 83667 | 1178 | 3.516 | 23796.1 |
| 1212 | 2023-11-15 17:16:35 | olive | 2 | 53800 | 87 | 1.546 | 34799.5 |
| 1211 | 2023-11-14 08:11:35 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1210 | 2023-11-13 10:15:22 | olive | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1209 | 2023-11-09 19:03:00 | olive | 2 | 53800 | 87 | 2.360 | 22796.6 |
| 1208 | 2023-11-09 19:02:58 | olive | 3 | 83667 | 1178 | 3.953 | 21165.4 |
| 1207 | 2023-11-08 16:56:33 | olive | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1206 | 2023-11-03 18:02:55 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1205 | 2023-10-21 08:56:40 | olive | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 1204 | 2023-10-18 15:59:07 | olive | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1203 | 2023-10-12 05:40:36 | olive | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1202 | 2023-10-05 16:42:58 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1201 | 2023-09-28 02:11:58 | olive | 1 | 28756 | 5 | 1.093 | 26309.2 |
| 1200 | 2023-09-24 20:21:52 | olive | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1199 | 2023-09-24 10:12:18 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1198 | 2023-09-22 03:27:12 | olive | 1 | 28756 | 5 | 0.873 | 32939.3 |
| 1197 | 2023-09-03 19:14:23 | olive | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1196 | 2023-06-07 18:56:07 | olive | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1195 | 2023-05-18 07:07:11 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1194 | 2023-02-19 16:34:21 | olive | 1 | 28756 | 5 | 0.966 | 29768.1 |
| 1193 | 2023-02-12 11:49:19 | olive | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1192 | 2022-12-10 19:39:18 | olive | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1191 | 2022-10-26 08:38:22 | olive | 1 | 28756 | 5 | 0.550 | 52283.6 |
| 1190 | 2022-08-15 10:46:18 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1189 | 2022-08-14 03:44:01 | olive | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1188 | 2022-08-11 17:16:41 | olive | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1187 | 2022-07-02 23:19:51 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1186 | 2022-06-17 10:06:55 | olive | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1185 | 2022-03-29 17:14:18 | olive | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1184 | 2022-03-19 06:50:01 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1183 | 2022-03-15 20:18:11 | olive | 1 | 28756 | 5 | 0.906 | 31739.5 |
| 1182 | 2022-01-06 17:49:13 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1181 | 2021-11-28 17:17:14 | olive | 1 | 28756 | 5 | 1.060 | 27128.3 |
| 1180 | 2021-11-02 21:34:40 | olive | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1179 | 2021-10-31 19:41:03 | olive | 1 | 28756 | 5 | 0.673 | 42728.1 |
| 1178 | 2021-09-20 06:22:35 | olive | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1177 | 2021-09-18 02:57:05 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1176 | 2021-08-31 14:54:47 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1175 | 2021-08-19 02:00:32 | olive | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1174 | 2021-07-22 05:47:41 | olive | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 1173 | 2021-06-28 07:27:39 | olive | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1172 | 2021-05-15 03:02:43 | olive | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1171 | 2021-04-28 10:31:40 | olive | 3 | 83667 | 1178 | 5.030 | 16633.6 |
| 1170 | 2021-04-24 03:46:53 | olive | 3 | 83667 | 1178 | 4.250 | 19686.4 |
| 1169 | 2021-04-10 03:44:32 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1168 | 2021-02-12 09:33:23 | olive | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1167 | 2021-02-07 06:29:31 | olive | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1166 | 2021-01-28 19:16:05 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1165 | 2021-01-24 15:36:36 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1164 | 2021-01-11 13:13:44 | olive | 3 | 83667 | 1178 | 3.343 | 25027.5 |
| 1163 | 2020-12-26 11:03:55 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1162 | 2020-11-05 09:32:18 | olive | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1161 | 2020-11-03 04:06:11 | olive | 3 | 83667 | 1178 | 3.546 | 23594.8 |
| 1160 | 2020-10-27 06:28:26 | olive | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1159 | 2020-10-24 07:38:56 | olive | 3 | 83667 | 1178 | 3.436 | 24350.1 |
| 1158 | 2020-10-24 04:03:14 | olive | 3 | 83667 | 1178 | 3.343 | 25027.5 |
| 1157 | 2020-10-22 23:22:54 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1156 | 2020-10-22 14:10:57 | olive | 3 | 83667 | 1178 | 3.953 | 21165.4 |
| 1155 | 2020-10-18 20:25:18 | olive | 3 | 83667 | 1178 | 3.406 | 24564.6 |
| 1154 | 2020-10-16 14:46:27 | olive | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1153 | 2020-09-20 02:14:30 | olive | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1152 | 2020-08-24 04:08:33 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1151 | 2020-08-19 16:03:47 | olive | 3 | 83667 | 1178 | 3.703 | 22594.4 |
| 1150 | 2020-08-17 08:21:57 | olive | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1149 | 2020-08-08 07:34:41 | olive | 3 | 83667 | 1178 | 3.920 | 21343.6 |
| 1148 | 2020-08-01 12:23:39 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1147 | 2020-05-15 14:31:19 | olive | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1146 | 2020-04-30 01:03:30 | olive | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1145 | 2020-04-25 07:53:12 | olive | 3 | 83667 | 1178 | 3.313 | 25254.2 |
| 1144 | 2020-03-28 09:45:27 | olive | 3 | 83667 | 1178 | 4.406 | 18989.3 |
| 1143 | 2020-03-26 11:39:31 | olive | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1142 | 2020-03-25 14:32:02 | olive | 3 | 83667 | 1178 | 4.626 | 18086.3 |
| 1141 | 2020-03-24 23:54:18 | olive | 3 | 83667 | 1178 | 4.470 | 18717.4 |
| 1140 | 2020-03-24 08:59:33 | olive | 1 | 28756 | 5 | 0.576 | 49923.6 |