History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"captain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
540 | 2024-05-04 00:12:12 | captain | 1 | 69583 | 3 | 1.656 | 42018.7 |
539 | 2024-04-28 13:51:04 | captain | 1 | 69583 | 3 | 1.326 | 52475.9 |
538 | 2024-04-24 10:19:38 | captain | 1 | 69583 | 3 | 3.016 | 23071.3 |
537 | 2024-03-30 06:41:01 | captain | 1 | 69583 | 3 | 3.436 | 20251.2 |
536 | 2024-03-29 02:39:05 | captain | 1 | 69583 | 3 | 1.250 | 55666.4 |
535 | 2024-03-05 15:10:48 | captain | 1 | 69583 | 3 | 1.203 | 57841.2 |
534 | 2024-03-02 07:46:07 | captain | 1 | 69583 | 3 | 1.546 | 45008.4 |
533 | 2024-01-05 23:15:28 | captain | 1 | 69583 | 3 | 1.296 | 53690.6 |
532 | 2023-12-31 12:50:28 | captain | 3 | 134027 | 191 | 6.000 | 22337.8 |
531 | 2023-12-31 12:50:25 | captain | 2 | 107671 | 22 | 3.016 | 35699.9 |
530 | 2023-12-15 23:19:11 | captain | 3 | 134027 | 191 | 6.750 | 19855.9 |
529 | 2023-12-15 23:19:09 | captain | 2 | 107671 | 22 | 3.376 | 31893.1 |
528 | 2023-12-04 21:29:05 | captain | 3 | 134027 | 191 | 6.843 | 19586.0 |
527 | 2023-12-04 21:29:06 | captain | 2 | 107671 | 22 | 3.440 | 31299.7 |
526 | 2023-11-14 15:39:45 | captain | 1 | 69583 | 3 | 1.156 | 60192.9 |
525 | 2023-11-11 11:16:24 | captain | 1 | 69583 | 3 | 1.266 | 54962.9 |
524 | 2023-10-30 14:55:47 | captain | 1 | 69583 | 3 | 2.516 | 27656.2 |
523 | 2023-10-28 01:57:31 | captain | 1 | 69583 | 3 | 2.783 | 25002.9 |
522 | 2023-10-28 00:04:16 | captain | 1 | 69583 | 3 | 1.110 | 62687.4 |
521 | 2023-10-20 16:38:40 | captain | 1 | 69583 | 3 | 1.236 | 56296.9 |
520 | 2023-10-18 09:52:46 | captain | 1 | 69583 | 3 | 1.250 | 55666.4 |
519 | 2023-10-14 07:55:22 | captain | 1 | 69583 | 3 | 1.110 | 62687.4 |
518 | 2023-10-04 14:45:54 | captain | 1 | 69583 | 3 | 1.250 | 55666.4 |
517 | 2023-09-23 06:57:32 | captain | 1 | 69583 | 3 | 1.233 | 56433.9 |
516 | 2023-09-12 05:31:32 | captain | 1 | 69583 | 3 | 1.156 | 60192.9 |
515 | 2023-08-22 03:40:09 | captain | 1 | 69583 | 3 | 1.236 | 56296.9 |
514 | 2023-07-18 11:12:28 | captain | 1 | 69583 | 3 | 1.186 | 58670.3 |
513 | 2023-05-22 17:33:55 | captain | 1 | 69583 | 3 | 1.093 | 63662.4 |
512 | 2023-04-10 16:39:46 | captain | 1 | 69583 | 3 | 1.093 | 63662.4 |
511 | 2023-03-18 01:45:17 | captain | 1 | 69583 | 3 | 1.093 | 63662.4 |
510 | 2023-01-06 02:22:51 | captain | 1 | 69583 | 3 | 1.096 | 63488.1 |
509 | 2023-01-05 12:14:14 | captain | 1 | 69583 | 3 | 1.076 | 64668.2 |
508 | 2022-09-28 19:20:59 | captain | 1 | 69583 | 3 | 1.233 | 56433.9 |
507 | 2022-09-21 20:07:36 | captain | 1 | 69583 | 3 | 1.126 | 61796.6 |
506 | 2022-09-06 21:43:09 | captain | 1 | 69583 | 3 | 1.203 | 57841.2 |
505 | 2022-09-01 21:01:39 | captain | 1 | 69583 | 3 | 1.093 | 63662.4 |
504 | 2022-06-08 10:39:00 | captain | 1 | 69583 | 3 | 1.140 | 61037.7 |
503 | 2022-06-04 19:32:24 | captain | 1 | 69583 | 3 | 1.093 | 63662.4 |
502 | 2022-05-11 10:55:45 | captain | 1 | 69583 | 3 | 1.200 | 57985.8 |
501 | 2022-02-21 14:10:58 | captain | 1 | 69583 | 3 | 1.533 | 45390.1 |
500 | 2022-02-01 15:37:30 | captain | 1 | 69583 | 3 | 1.326 | 52475.9 |
499 | 2021-11-27 17:30:57 | captain | 1 | 69583 | 3 | 1.220 | 57035.2 |
498 | 2021-11-16 20:35:44 | captain | 1 | 69583 | 3 | 1.140 | 61037.7 |
497 | 2021-10-25 17:16:45 | captain | 1 | 69583 | 3 | 1.360 | 51164.0 |
496 | 2021-08-13 23:16:47 | captain | 1 | 69583 | 3 | 1.110 | 62687.4 |
495 | 2021-06-06 14:48:13 | captain | 1 | 69583 | 3 | 1.250 | 55666.4 |
494 | 2021-05-13 05:58:53 | captain | 1 | 69583 | 3 | 1.343 | 51811.6 |
493 | 2021-05-12 14:34:20 | captain | 1 | 69583 | 3 | 1.313 | 52995.4 |
492 | 2021-04-11 10:19:36 | captain | 1 | 69583 | 3 | 2.500 | 27833.2 |
491 | 2021-02-18 12:37:11 | captain | 1 | 69583 | 3 | 1.110 | 62687.4 |
490 | 2021-02-09 13:23:47 | captain | 1 | 69583 | 3 | 2.313 | 30083.4 |
489 | 2020-11-30 12:01:19 | captain | 1 | 69583 | 3 | 1.170 | 59472.6 |
488 | 2020-11-22 09:14:08 | captain | 1 | 69583 | 3 | 1.186 | 58670.3 |
487 | 2020-11-07 20:25:28 | captain | 1 | 69583 | 3 | 1.160 | 59985.3 |
486 | 2020-10-25 03:46:03 | captain | 1 | 69583 | 3 | 1.110 | 62687.4 |
485 | 2020-10-21 06:07:56 | captain | 1 | 69583 | 3 | 1.173 | 59320.5 |
484 | 2020-10-11 06:37:08 | captain | 1 | 69583 | 3 | 1.173 | 59320.5 |
483 | 2020-08-28 07:20:01 | captain | 1 | 69583 | 3 | 1.156 | 60192.9 |
482 | 2020-08-17 08:14:21 | captain | 1 | 69583 | 3 | 1.156 | 60192.9 |
481 | 2020-08-14 10:16:32 | captain | 1 | 69583 | 3 | 1.190 | 58473.1 |
480 | 2020-08-09 23:37:59 | captain | 1 | 69583 | 3 | 1.110 | 62687.4 |
479 | 2020-08-03 00:20:10 | captain | 1 | 69583 | 3 | 1.170 | 59472.6 |
478 | 2020-07-14 18:53:05 | captain | 1 | 69583 | 3 | 1.203 | 57841.2 |
477 | 2020-05-08 03:08:14 | captain | 1 | 69583 | 3 | 1.126 | 61796.6 |
476 | 2020-05-04 17:06:26 | captain | 1 | 69583 | 3 | 1.250 | 55666.4 |
475 | 2020-03-28 18:09:40 | captain | 1 | 69583 | 3 | 1.280 | 54361.7 |
474 | 2020-03-24 01:51:40 | captain | 1 | 69583 | 3 | 1.533 | 45390.1 |
473 | 2020-03-23 08:55:26 | captain | 1 | 69583 | 3 | 1.250 | 55666.4 |
472 | 2020-03-20 10:20:38 | captain | 1 | 69583 | 3 | 1.123 | 61961.7 |
471 | 2020-02-28 06:31:44 | captain | 1 | 69583 | 3 | 1.233 | 56433.9 |
470 | 2020-02-26 01:02:58 | captain | 3 | 134027 | 191 | 11.656 | 11498.5 |
469 | 2020-02-26 00:06:19 | captain | 1 | 69583 | 3 | 1.220 | 57035.2 |
468 | 2020-02-25 01:55:19 | captain | 3 | 134027 | 191 | 7.316 | 18319.7 |
467 | 2020-02-24 08:24:01 | captain | 1 | 69583 | 3 | 1.343 | 51811.6 |
466 | 2020-02-17 05:10:37 | captain | 1 | 69583 | 3 | 1.373 | 50679.5 |
465 | 2020-02-14 18:59:53 | captain | 3 | 134027 | 191 | 8.076 | 16595.7 |
464 | 2020-02-13 05:22:48 | captain | 1 | 69583 | 3 | 1.296 | 53690.6 |
463 | 2020-02-07 02:33:26 | captain | 1 | 69583 | 3 | 1.360 | 51164.0 |
462 | 2020-02-06 14:12:58 | captain | 1 | 69583 | 3 | 1.390 | 50059.7 |
461 | 2020-02-04 18:50:01 | captain | 1 | 69583 | 3 | 1.423 | 48898.8 |
460 | 2020-02-02 11:23:01 | captain | 1 | 69583 | 3 | 2.030 | 34277.3 |
459 | 2020-02-01 02:57:35 | captain | 1 | 69583 | 3 | 1.203 | 57841.2 |
458 | 2020-01-31 08:32:45 | captain | 3 | 134027 | 191 | 16.533 | 8106.6 |
457 | 2020-01-30 14:35:19 | captain | 3 | 134027 | 191 | 6.420 | 20876.5 |
456 | 2020-01-29 07:47:05 | captain | 3 | 134027 | 191 | 8.686 | 15430.2 |
455 | 2020-01-28 18:36:12 | captain | 1 | 69583 | 3 | 2.873 | 24219.6 |
454 | 2020-01-24 00:43:08 | captain | 1 | 69583 | 3 | 1.986 | 35036.8 |
453 | 2020-01-22 03:45:23 | captain | 3 | 134027 | 191 | 14.330 | 9352.9 |
452 | 2020-01-21 23:14:21 | captain | 3 | 134027 | 191 | 8.296 | 16155.6 |
451 | 2020-01-15 18:39:48 | captain | 1 | 69583 | 3 | 1.216 | 57222.9 |
450 | 2020-01-15 15:56:27 | captain | 1 | 69583 | 3 | 2.813 | 24736.2 |
449 | 2020-01-15 05:05:01 | captain | 3 | 134027 | 191 | 7.393 | 18128.9 |
448 | 2020-01-12 04:53:47 | captain | 1 | 69583 | 3 | 1.423 | 48898.8 |
447 | 2020-01-07 22:25:21 | captain | 1 | 69583 | 3 | 1.420 | 49002.1 |
446 | 2020-01-05 02:47:14 | captain | 3 | 134027 | 191 | 9.266 | 14464.4 |
445 | 2020-01-01 23:00:21 | captain | 3 | 134027 | 191 | 7.876 | 17017.1 |
444 | 2019-12-28 21:09:13 | captain | 1 | 69583 | 3 | 1.186 | 58670.3 |
443 | 2019-12-27 19:21:53 | captain | 3 | 134027 | 191 | 6.313 | 21230.3 |
442 | 2019-12-27 13:09:11 | captain | 3 | 134027 | 191 | 6.813 | 19672.2 |
441 | 2019-12-27 02:27:44 | captain | 1 | 69583 | 3 | 2.736 | 25432.4 |