History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"missions"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
308 | 2024-05-01 18:45:44 | missions | 2 | 121059 | 33 | 4.233 | 28598.9 |
307 | 2024-05-01 15:17:46 | missions | 3 | 146162 | 218 | 11.516 | 12692.1 |
306 | 2024-05-01 05:28:39 | missions | 3 | 146162 | 218 | 10.110 | 14457.2 |
305 | 2024-04-30 18:17:43 | missions | 3 | 146162 | 218 | 18.140 | 8057.4 |
304 | 2024-04-30 13:01:55 | missions | 3 | 146162 | 218 | 19.580 | 7464.9 |
303 | 2024-04-30 13:01:57 | missions | 2 | 121059 | 33 | 10.860 | 11147.2 |
302 | 2024-04-30 13:01:49 | missions | 1 | 82945 | 5 | 4.750 | 17462.1 |
301 | 2024-04-29 03:05:40 | missions | 1 | 82945 | 5 | 1.580 | 52496.8 |
300 | 2024-03-29 21:25:54 | missions | 1 | 82945 | 5 | 5.296 | 15661.8 |
299 | 2024-03-15 04:12:22 | missions | 2 | 121059 | 33 | 11.626 | 10412.8 |
298 | 2024-03-15 04:09:48 | missions | 3 | 146162 | 218 | 24.063 | 6074.1 |
297 | 2024-03-15 04:04:15 | missions | 3 | 146162 | 218 | 6.843 | 21359.3 |
296 | 2024-03-14 03:27:45 | missions | 3 | 146162 | 218 | 19.343 | 7556.3 |
295 | 2024-03-14 01:24:06 | missions | 3 | 146162 | 218 | 15.970 | 9152.3 |
294 | 2024-03-13 15:50:34 | missions | 1 | 82945 | 5 | 1.513 | 54821.5 |
293 | 2024-03-12 20:54:59 | missions | 3 | 146162 | 218 | 7.580 | 19282.6 |
292 | 2024-03-12 20:54:52 | missions | 2 | 121059 | 33 | 3.953 | 30624.6 |
291 | 2024-03-12 20:54:50 | missions | 2 | 121059 | 33 | 4.080 | 29671.3 |
290 | 2024-03-12 20:54:37 | missions | 1 | 82945 | 5 | 1.500 | 55296.7 |
289 | 2024-03-12 20:54:14 | missions | 3 | 146162 | 218 | 7.013 | 20841.6 |
288 | 2024-03-12 06:21:00 | missions | 3 | 146162 | 218 | 11.673 | 12521.4 |
287 | 2024-03-07 09:22:04 | missions | 1 | 82945 | 5 | 4.923 | 16848.5 |
286 | 2024-02-28 10:54:31 | missions | 1 | 82945 | 5 | 2.813 | 29486.3 |
285 | 2024-02-25 22:30:38 | missions | 1 | 82945 | 5 | 1.623 | 51106.0 |
284 | 2024-02-13 18:15:52 | missions | 3 | 146162 | 218 | 24.456 | 5976.5 |
283 | 2024-02-12 16:28:02 | missions | 3 | 146162 | 218 | 25.983 | 5625.3 |
282 | 2024-02-12 16:28:05 | missions | 2 | 121059 | 33 | 12.813 | 9448.1 |
281 | 2024-02-12 11:43:22 | missions | 1 | 82945 | 5 | 1.453 | 57085.3 |
280 | 2024-02-04 05:15:11 | missions | 1 | 82945 | 5 | 1.780 | 46598.3 |
279 | 2024-01-23 12:44:26 | missions | 1 | 82945 | 5 | 1.606 | 51646.9 |
278 | 2024-01-12 17:32:41 | missions | 2 | 121059 | 33 | 3.656 | 33112.4 |
277 | 2024-01-12 09:54:41 | missions | 1 | 82945 | 5 | 1.410 | 58826.2 |
276 | 2024-01-11 09:20:39 | missions | 1 | 82945 | 5 | 1.576 | 52630.1 |
275 | 2023-12-01 07:00:33 | missions | 2 | 121059 | 33 | 3.703 | 32692.1 |
274 | 2023-11-29 00:11:44 | missions | 3 | 146162 | 218 | 6.343 | 23043.0 |
273 | 2023-11-19 18:47:12 | missions | 1 | 82945 | 5 | 1.466 | 56579.1 |
272 | 2023-11-05 01:50:54 | missions | 1 | 82945 | 5 | 1.500 | 55296.7 |
271 | 2023-11-04 09:08:58 | missions | 1 | 82945 | 5 | 1.236 | 67107.6 |
270 | 2023-10-23 11:55:59 | missions | 1 | 82945 | 5 | 2.126 | 39014.6 |
269 | 2023-10-21 18:21:46 | missions | 2 | 121059 | 33 | 3.920 | 30882.4 |
268 | 2023-10-13 19:42:44 | missions | 1 | 82945 | 5 | 2.046 | 40540.1 |
267 | 2023-10-13 04:10:37 | missions | 1 | 82945 | 5 | 1.500 | 55296.7 |
266 | 2023-09-30 00:09:27 | missions | 1 | 82945 | 5 | 1.313 | 63172.1 |
265 | 2023-08-27 16:35:54 | missions | 3 | 146162 | 218 | 6.283 | 23263.1 |
264 | 2023-08-27 09:21:55 | missions | 1 | 82945 | 5 | 1.263 | 65673.0 |
263 | 2023-07-31 16:54:16 | missions | 2 | 121059 | 33 | 3.466 | 34927.6 |
262 | 2023-06-26 04:32:15 | missions | 1 | 82945 | 5 | 1.376 | 60279.8 |
261 | 2023-05-29 21:22:34 | missions | 1 | 82945 | 5 | 1.250 | 66356.0 |
260 | 2023-05-13 16:34:44 | missions | 3 | 146162 | 218 | 6.140 | 23804.9 |
259 | 2023-05-08 12:05:57 | missions | 3 | 146162 | 218 | 6.450 | 22660.8 |
258 | 2023-04-09 04:20:08 | missions | 2 | 121059 | 33 | 3.140 | 38553.8 |
257 | 2023-03-28 00:52:27 | missions | 3 | 146162 | 218 | 6.063 | 24107.2 |
256 | 2023-03-23 19:16:25 | missions | 1 | 82945 | 5 | 1.280 | 64800.8 |
255 | 2023-03-07 04:59:22 | missions | 1 | 82945 | 5 | 1.376 | 60279.8 |
254 | 2023-02-18 03:20:32 | missions | 3 | 146162 | 218 | 7.063 | 20694.0 |
253 | 2023-01-24 04:18:01 | missions | 1 | 82945 | 5 | 1.390 | 59672.7 |
252 | 2023-01-15 03:12:42 | missions | 2 | 121059 | 33 | 3.046 | 39743.6 |
251 | 2023-01-08 05:03:12 | missions | 1 | 82945 | 5 | 1.360 | 60989.0 |
250 | 2022-12-09 22:58:03 | missions | 1 | 82945 | 5 | 1.250 | 66356.0 |
249 | 2022-11-28 08:28:15 | missions | 3 | 146162 | 218 | 6.390 | 22873.6 |
248 | 2022-11-15 06:59:31 | missions | 1 | 82945 | 5 | 1.453 | 57085.3 |
247 | 2022-11-11 11:51:25 | missions | 1 | 82945 | 5 | 1.266 | 65517.4 |
246 | 2022-11-08 01:20:15 | missions | 1 | 82945 | 5 | 1.360 | 60989.0 |
245 | 2022-10-19 11:30:15 | missions | 2 | 121059 | 33 | 3.576 | 33853.2 |
244 | 2022-10-08 22:47:32 | missions | 1 | 82945 | 5 | 1.530 | 54212.4 |
243 | 2022-09-18 12:56:01 | missions | 1 | 82945 | 5 | 1.280 | 64800.8 |
242 | 2022-09-09 11:48:07 | missions | 1 | 82945 | 5 | 1.390 | 59672.7 |
241 | 2022-08-15 09:07:24 | missions | 1 | 82945 | 5 | 1.266 | 65517.4 |
240 | 2022-08-15 07:22:13 | missions | 3 | 146162 | 218 | 7.033 | 20782.3 |
239 | 2022-08-14 01:52:15 | missions | 1 | 82945 | 5 | 1.280 | 64800.8 |
238 | 2022-08-06 22:56:14 | missions | 3 | 146162 | 218 | 6.076 | 24055.6 |
237 | 2022-08-06 05:50:32 | missions | 1 | 82945 | 5 | 1.296 | 64000.8 |
236 | 2022-07-22 08:22:43 | missions | 1 | 82945 | 5 | 1.533 | 54106.3 |
235 | 2022-07-04 11:16:02 | missions | 3 | 146162 | 218 | 6.153 | 23754.6 |
234 | 2022-05-23 15:07:11 | missions | 1 | 82945 | 5 | 2.626 | 31586.1 |
233 | 2022-05-21 10:48:35 | missions | 2 | 121059 | 33 | 3.140 | 38553.8 |
232 | 2022-03-31 12:41:00 | missions | 1 | 82945 | 5 | 1.563 | 53067.8 |
231 | 2022-02-09 07:04:21 | missions | 1 | 82945 | 5 | 1.440 | 57600.7 |
230 | 2022-01-09 23:14:08 | missions | 1 | 82945 | 5 | 1.606 | 51646.9 |
229 | 2021-12-17 00:41:08 | missions | 1 | 82945 | 5 | 1.296 | 64000.8 |
228 | 2021-12-16 10:17:04 | missions | 1 | 82945 | 5 | 1.393 | 59544.1 |
227 | 2021-12-14 17:11:37 | missions | 1 | 82945 | 5 | 1.970 | 42104.1 |
226 | 2021-11-26 19:25:59 | missions | 1 | 82945 | 5 | 1.516 | 54713.1 |
225 | 2021-10-04 05:04:58 | missions | 1 | 82945 | 5 | 1.283 | 64649.3 |
224 | 2021-09-09 18:48:45 | missions | 1 | 82945 | 5 | 1.516 | 54713.1 |
223 | 2021-09-01 20:48:20 | missions | 1 | 82945 | 5 | 1.420 | 58412.0 |
222 | 2021-08-30 14:45:56 | missions | 1 | 82945 | 5 | 1.436 | 57761.1 |
221 | 2021-07-13 13:22:49 | missions | 2 | 121059 | 33 | 3.140 | 38553.8 |
220 | 2021-06-08 20:30:56 | missions | 1 | 82945 | 5 | 1.250 | 66356.0 |
219 | 2021-05-02 10:03:56 | missions | 2 | 121059 | 33 | 6.560 | 18454.1 |
218 | 2021-04-19 06:01:20 | missions | 1 | 82945 | 5 | 1.250 | 66356.0 |
217 | 2021-03-31 15:44:26 | missions | 2 | 121059 | 33 | 4.016 | 30144.2 |
216 | 2021-03-22 01:15:51 | missions | 1 | 82945 | 5 | 1.326 | 62552.8 |
215 | 2021-03-09 20:32:53 | missions | 1 | 82945 | 5 | 1.500 | 55296.7 |
214 | 2021-02-19 00:15:40 | missions | 2 | 121059 | 33 | 3.233 | 37444.8 |
213 | 2021-01-04 00:17:53 | missions | 1 | 82945 | 5 | 1.686 | 49196.3 |
212 | 2020-12-06 09:32:49 | missions | 1 | 82945 | 5 | 1.283 | 64649.3 |
211 | 2020-11-12 04:21:35 | missions | 1 | 82945 | 5 | 1.296 | 64000.8 |
210 | 2020-10-31 22:32:53 | missions | 1 | 82945 | 5 | 1.406 | 58993.6 |
209 | 2020-10-29 22:25:35 | missions | 1 | 82945 | 5 | 1.266 | 65517.4 |