History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mission"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
406 | 2024-04-27 21:13:19 | mission | 1 | 69583 | 5 | 2.156 | 32274.1 |
405 | 2024-03-30 16:35:52 | mission | 1 | 69583 | 5 | 3.623 | 19205.9 |
404 | 2024-02-08 07:29:02 | mission | 2 | 107671 | 32 | 3.390 | 31761.4 |
403 | 2024-02-07 19:46:33 | mission | 2 | 107671 | 32 | 23.596 | 4563.1 |
402 | 2024-02-05 00:12:14 | mission | 3 | 134027 | 249 | 7.750 | 17293.8 |
401 | 2024-01-31 01:03:18 | mission | 3 | 134027 | 249 | 6.706 | 19986.1 |
400 | 2024-01-30 16:52:10 | mission | 1 | 69583 | 5 | 1.203 | 57841.2 |
399 | 2024-01-26 06:40:37 | mission | 3 | 134027 | 249 | 7.190 | 18640.8 |
398 | 2024-01-26 05:43:47 | mission | 3 | 134027 | 249 | 6.016 | 22278.4 |
397 | 2024-01-26 05:43:31 | mission | 2 | 107671 | 32 | 3.610 | 29825.8 |
396 | 2024-01-21 19:23:09 | mission | 1 | 69583 | 5 | 1.173 | 59320.5 |
395 | 2024-01-21 15:09:48 | mission | 2 | 107671 | 32 | 2.766 | 38926.6 |
394 | 2023-12-28 03:11:12 | mission | 1 | 69583 | 5 | 1.203 | 57841.2 |
393 | 2023-12-25 02:53:37 | mission | 1 | 69583 | 5 | 1.220 | 57035.2 |
392 | 2023-12-01 05:04:29 | mission | 3 | 134027 | 249 | 6.016 | 22278.4 |
391 | 2023-12-01 05:04:31 | mission | 2 | 107671 | 32 | 3.173 | 33933.5 |
390 | 2023-11-25 04:58:40 | mission | 1 | 69583 | 5 | 1.190 | 58473.1 |
389 | 2023-11-13 21:17:57 | mission | 1 | 69583 | 5 | 1.143 | 60877.5 |
388 | 2023-11-06 05:24:46 | mission | 1 | 69583 | 5 | 1.093 | 63662.4 |
387 | 2023-11-04 00:19:11 | mission | 2 | 107671 | 32 | 2.966 | 36301.8 |
386 | 2023-10-22 06:06:35 | mission | 1 | 69583 | 5 | 1.093 | 63662.4 |
385 | 2023-10-06 03:12:14 | mission | 1 | 69583 | 5 | 1.076 | 64668.2 |
384 | 2023-10-01 07:33:28 | mission | 1 | 69583 | 5 | 1.080 | 64428.7 |
383 | 2023-09-24 08:56:45 | mission | 1 | 69583 | 5 | 1.156 | 60192.9 |
382 | 2023-09-13 15:11:00 | mission | 1 | 69583 | 5 | 1.406 | 49490.0 |
381 | 2023-09-10 18:03:01 | mission | 1 | 69583 | 5 | 1.250 | 55666.4 |
380 | 2023-08-09 16:33:00 | mission | 2 | 107671 | 32 | 2.860 | 37647.2 |
379 | 2023-06-20 18:53:55 | mission | 1 | 69583 | 5 | 2.170 | 32065.9 |
378 | 2023-06-04 01:39:20 | mission | 1 | 69583 | 5 | 1.030 | 67556.3 |
377 | 2023-04-23 08:35:15 | mission | 2 | 107671 | 32 | 3.000 | 35890.3 |
376 | 2023-04-04 08:50:23 | mission | 1 | 69583 | 5 | 1.046 | 66522.9 |
375 | 2023-02-19 04:04:37 | mission | 1 | 69583 | 5 | 1.063 | 65459.1 |
374 | 2023-01-29 22:56:29 | mission | 2 | 107671 | 32 | 2.733 | 39396.6 |
373 | 2023-01-16 08:01:01 | mission | 1 | 69583 | 5 | 1.076 | 64668.2 |
372 | 2022-11-11 11:19:34 | mission | 2 | 107671 | 32 | 2.813 | 38276.2 |
371 | 2022-10-29 12:11:17 | mission | 1 | 69583 | 5 | 1.173 | 59320.5 |
370 | 2022-09-18 14:38:12 | mission | 1 | 69583 | 5 | 1.186 | 58670.3 |
369 | 2022-09-03 19:53:32 | mission | 1 | 69583 | 5 | 2.360 | 29484.3 |
368 | 2022-08-23 00:09:47 | mission | 1 | 69583 | 5 | 1.126 | 61796.6 |
367 | 2022-08-15 10:58:49 | mission | 1 | 69583 | 5 | 1.046 | 66522.9 |
366 | 2022-08-14 04:02:23 | mission | 1 | 69583 | 5 | 1.046 | 66522.9 |
365 | 2022-07-02 09:23:43 | mission | 1 | 69583 | 5 | 1.080 | 64428.7 |
364 | 2022-06-15 10:41:53 | mission | 1 | 69583 | 5 | 1.216 | 57222.9 |
363 | 2022-06-09 08:39:36 | mission | 2 | 107671 | 32 | 2.796 | 38508.9 |
362 | 2022-06-06 16:10:12 | mission | 1 | 69583 | 5 | 1.046 | 66522.9 |
361 | 2022-03-08 13:52:36 | mission | 1 | 69583 | 5 | 1.156 | 60192.9 |
360 | 2022-02-16 13:13:49 | mission | 1 | 69583 | 5 | 1.063 | 65459.1 |
359 | 2021-12-10 00:18:07 | mission | 1 | 69583 | 5 | 1.203 | 57841.2 |
358 | 2021-12-07 22:19:53 | mission | 1 | 69583 | 5 | 1.093 | 63662.4 |
357 | 2021-11-21 11:08:34 | mission | 1 | 69583 | 5 | 1.106 | 62914.1 |
356 | 2021-10-30 13:07:37 | mission | 3 | 134027 | 249 | 6.016 | 22278.4 |
355 | 2021-10-15 06:17:51 | mission | 1 | 69583 | 5 | 1.096 | 63488.1 |
354 | 2021-10-03 00:35:27 | mission | 1 | 69583 | 5 | 1.186 | 58670.3 |
353 | 2021-09-24 07:26:06 | mission | 1 | 69583 | 5 | 1.170 | 59472.6 |
352 | 2021-09-20 23:14:21 | mission | 1 | 69583 | 5 | 1.203 | 57841.2 |
351 | 2021-08-18 14:13:01 | mission | 1 | 69583 | 5 | 1.063 | 65459.1 |
350 | 2021-07-23 09:29:00 | mission | 3 | 134027 | 249 | 6.000 | 22337.8 |
349 | 2021-05-17 22:04:50 | mission | 1 | 69583 | 5 | 1.313 | 52995.4 |
348 | 2021-05-13 03:20:26 | mission | 3 | 134027 | 249 | 5.626 | 23822.8 |
347 | 2021-05-11 09:42:22 | mission | 1 | 69583 | 5 | 1.110 | 62687.4 |
346 | 2021-05-09 05:41:21 | mission | 3 | 134027 | 249 | 6.360 | 21073.4 |
345 | 2021-04-10 05:52:28 | mission | 1 | 69583 | 5 | 1.046 | 66522.9 |
344 | 2021-02-22 07:45:07 | mission | 1 | 69583 | 5 | 1.233 | 56433.9 |
343 | 2021-02-18 22:53:33 | mission | 3 | 134027 | 249 | 5.670 | 23637.9 |
342 | 2021-02-17 12:02:06 | mission | 1 | 69583 | 5 | 1.110 | 62687.4 |
341 | 2021-02-14 14:23:30 | mission | 1 | 69583 | 5 | 1.093 | 63662.4 |
340 | 2021-01-27 01:09:13 | mission | 3 | 134027 | 249 | 6.360 | 21073.4 |
339 | 2020-12-27 19:36:10 | mission | 3 | 134027 | 249 | 5.753 | 23296.9 |
338 | 2020-11-09 21:26:43 | mission | 1 | 69583 | 5 | 1.326 | 52475.9 |
337 | 2020-11-08 23:02:51 | mission | 2 | 107671 | 32 | 3.173 | 33933.5 |
336 | 2020-11-07 15:43:42 | mission | 3 | 134027 | 249 | 7.233 | 18529.9 |
335 | 2020-11-06 01:39:03 | mission | 2 | 107671 | 32 | 3.076 | 35003.6 |
334 | 2020-10-23 11:22:15 | mission | 1 | 69583 | 5 | 1.076 | 64668.2 |
333 | 2020-10-16 23:16:17 | mission | 1 | 69583 | 5 | 1.076 | 64668.2 |
332 | 2020-10-14 05:09:20 | mission | 3 | 134027 | 249 | 7.156 | 18729.3 |
331 | 2020-09-02 18:57:56 | mission | 3 | 134027 | 249 | 6.110 | 21935.7 |
330 | 2020-08-14 04:45:26 | mission | 1 | 69583 | 5 | 1.186 | 58670.3 |
329 | 2020-08-12 05:42:37 | mission | 3 | 134027 | 249 | 6.280 | 21341.9 |
328 | 2020-08-07 08:56:04 | mission | 1 | 69583 | 5 | 1.093 | 63662.4 |
327 | 2020-05-05 23:17:48 | mission | 1 | 69583 | 5 | 1.063 | 65459.1 |
326 | 2020-05-01 02:17:04 | mission | 3 | 134027 | 249 | 5.923 | 22628.2 |
325 | 2020-03-30 09:23:33 | mission | 1 | 69583 | 5 | 1.173 | 59320.5 |
324 | 2020-03-23 19:11:42 | mission | 1 | 69583 | 5 | 2.596 | 26803.9 |
323 | 2020-03-21 06:22:16 | mission | 1 | 69583 | 5 | 1.250 | 55666.4 |
322 | 2020-02-29 16:40:12 | mission | 1 | 69583 | 5 | 1.173 | 59320.5 |
321 | 2020-02-29 08:27:57 | mission | 1 | 69583 | 5 | 1.283 | 54234.6 |
320 | 2020-02-29 07:07:22 | mission | 1 | 69583 | 5 | 1.236 | 56296.9 |
319 | 2020-02-25 14:02:35 | mission | 1 | 69583 | 5 | 2.033 | 34226.8 |
318 | 2020-02-08 19:07:23 | mission | 1 | 69583 | 5 | 1.406 | 49490.0 |
317 | 2020-02-07 19:16:28 | mission | 1 | 69583 | 5 | 2.716 | 25619.7 |
316 | 2020-02-06 07:58:42 | mission | 3 | 134027 | 249 | 9.220 | 14536.6 |
315 | 2020-02-05 23:53:29 | mission | 1 | 69583 | 5 | 3.826 | 18186.9 |
314 | 2020-02-05 10:42:20 | mission | 1 | 69583 | 5 | 1.296 | 53690.6 |
313 | 2020-02-03 14:35:12 | mission | 1 | 69583 | 5 | 3.343 | 20814.5 |
312 | 2020-02-02 01:34:30 | mission | 1 | 69583 | 5 | 2.670 | 26061.0 |
311 | 2020-02-01 12:51:05 | mission | 3 | 134027 | 249 | 11.046 | 12133.5 |
310 | 2020-01-31 11:28:43 | mission | 3 | 134027 | 249 | 7.250 | 18486.5 |
309 | 2020-01-31 10:03:50 | mission | 1 | 69583 | 5 | 1.436 | 48456.1 |
308 | 2020-01-31 01:29:20 | mission | 3 | 134027 | 249 | 19.873 | 6744.2 |
307 | 2020-01-30 08:49:28 | mission | 3 | 134027 | 249 | 10.000 | 13402.7 |