History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"twain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
666 | 2024-04-27 22:23:44 | twain | 2 | 53800 | 78 | 1.703 | 31591.3 |
665 | 2024-04-23 23:56:35 | twain | 1 | 28756 | 8 | 0.563 | 51076.4 |
664 | 2024-04-03 06:06:33 | twain | 1 | 28756 | 8 | 0.483 | 59536.2 |
663 | 2024-03-31 10:03:54 | twain | 3 | 83667 | 937 | 11.953 | 6999.7 |
662 | 2024-03-31 10:03:59 | twain | 2 | 53800 | 78 | 4.266 | 12611.3 |
661 | 2024-03-31 08:30:35 | twain | 1 | 28756 | 8 | 0.516 | 55728.7 |
660 | 2024-03-28 08:28:05 | twain | 2 | 53800 | 78 | 1.860 | 28924.7 |
659 | 2024-03-28 08:28:03 | twain | 1 | 28756 | 8 | 1.060 | 27128.3 |
658 | 2024-03-28 08:27:30 | twain | 3 | 83667 | 937 | 3.623 | 23093.3 |
657 | 2024-03-28 06:28:58 | twain | 3 | 83667 | 937 | 3.593 | 23286.1 |
656 | 2024-03-27 05:02:43 | twain | 1 | 28756 | 8 | 0.483 | 59536.2 |
655 | 2024-03-04 01:08:26 | twain | 3 | 83667 | 937 | 3.843 | 21771.3 |
654 | 2024-03-04 01:08:24 | twain | 2 | 53800 | 78 | 1.593 | 33772.8 |
653 | 2024-03-04 01:08:00 | twain | 1 | 28756 | 8 | 0.483 | 59536.2 |
652 | 2024-03-01 10:42:04 | twain | 1 | 28756 | 8 | 0.580 | 49579.3 |
651 | 2024-03-01 00:36:02 | twain | 1 | 28756 | 8 | 0.530 | 54256.6 |
650 | 2024-02-25 22:58:55 | twain | 3 | 83667 | 937 | 12.813 | 6529.9 |
649 | 2024-02-25 22:58:55 | twain | 2 | 53800 | 78 | 1.720 | 31279.1 |
648 | 2024-02-25 22:57:50 | twain | 1 | 28756 | 8 | 1.110 | 25906.3 |
647 | 2024-02-03 00:16:11 | twain | 1 | 28756 | 8 | 1.013 | 28387.0 |
646 | 2024-01-28 18:51:35 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
645 | 2024-01-26 20:47:01 | twain | 1 | 28756 | 8 | 0.580 | 49579.3 |
644 | 2024-01-14 18:31:40 | twain | 3 | 83667 | 937 | 3.203 | 26121.4 |
643 | 2024-01-12 01:35:20 | twain | 1 | 28756 | 8 | 0.530 | 54256.6 |
642 | 2024-01-10 05:55:25 | twain | 1 | 28756 | 8 | 0.470 | 61183.0 |
641 | 2023-12-14 03:13:07 | twain | 2 | 53800 | 78 | 3.576 | 15044.7 |
640 | 2023-12-03 17:30:19 | twain | 2 | 53800 | 78 | 1.686 | 31909.8 |
639 | 2023-12-03 17:30:17 | twain | 2 | 53800 | 78 | 1.686 | 31909.8 |
638 | 2023-12-03 14:38:51 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
637 | 2023-12-03 14:38:50 | twain | 1 | 28756 | 8 | 0.450 | 63902.2 |
636 | 2023-11-20 08:21:52 | twain | 1 | 28756 | 8 | 0.486 | 59168.7 |
635 | 2023-11-18 16:11:05 | twain | 1 | 28756 | 8 | 0.983 | 29253.3 |
634 | 2023-11-07 01:22:34 | twain | 1 | 28756 | 8 | 0.453 | 63479.0 |
633 | 2023-10-28 19:56:58 | twain | 1 | 28756 | 8 | 0.500 | 57512.0 |
632 | 2023-10-26 04:12:50 | twain | 3 | 83667 | 937 | 3.300 | 25353.6 |
631 | 2023-10-25 08:07:35 | twain | 3 | 83667 | 937 | 3.906 | 21420.1 |
630 | 2023-10-24 10:08:56 | twain | 1 | 28756 | 8 | 0.440 | 65354.5 |
629 | 2023-10-20 13:43:10 | twain | 1 | 28756 | 8 | 2.313 | 12432.3 |
628 | 2023-10-11 03:04:22 | twain | 1 | 28756 | 8 | 0.470 | 61183.0 |
627 | 2023-10-07 14:00:15 | twain | 1 | 28756 | 8 | 0.500 | 57512.0 |
626 | 2023-10-03 12:22:48 | twain | 3 | 83667 | 937 | 3.736 | 22394.8 |
625 | 2023-10-02 15:37:05 | twain | 3 | 83667 | 937 | 3.546 | 23594.8 |
624 | 2023-10-01 08:06:17 | twain | 3 | 83667 | 937 | 3.953 | 21165.4 |
623 | 2023-09-28 18:46:00 | twain | 2 | 53800 | 78 | 1.626 | 33087.3 |
622 | 2023-09-28 18:45:54 | twain | 3 | 83667 | 937 | 4.016 | 20833.4 |
621 | 2023-09-24 09:02:19 | twain | 1 | 28756 | 8 | 0.453 | 63479.0 |
620 | 2023-09-23 19:13:37 | twain | 1 | 28756 | 8 | 0.466 | 61708.2 |
619 | 2023-08-28 06:38:00 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
618 | 2023-08-28 04:26:37 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
617 | 2023-08-11 22:34:07 | twain | 3 | 83667 | 937 | 3.720 | 22491.1 |
616 | 2023-08-04 01:47:03 | twain | 3 | 83667 | 937 | 3.216 | 26015.9 |
615 | 2023-06-01 20:12:45 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
614 | 2023-04-26 09:20:51 | twain | 1 | 28756 | 8 | 0.483 | 59536.2 |
613 | 2023-04-19 04:34:02 | twain | 3 | 83667 | 937 | 3.233 | 25879.1 |
612 | 2023-03-26 08:57:22 | twain | 1 | 28756 | 8 | 0.423 | 67981.1 |
611 | 2023-01-20 05:07:30 | twain | 3 | 83667 | 937 | 3.173 | 26368.4 |
610 | 2023-01-10 02:50:30 | twain | 1 | 28756 | 8 | 0.420 | 68466.7 |
609 | 2022-12-26 09:06:39 | twain | 1 | 28756 | 8 | 0.470 | 61183.0 |
608 | 2022-12-22 16:52:41 | twain | 1 | 28756 | 8 | 0.483 | 59536.2 |
607 | 2022-10-31 07:43:31 | twain | 3 | 83667 | 937 | 3.300 | 25353.6 |
606 | 2022-10-12 21:22:13 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
605 | 2022-09-01 02:24:32 | twain | 1 | 28756 | 8 | 0.500 | 57512.0 |
604 | 2022-08-05 23:42:38 | twain | 1 | 28756 | 8 | 0.470 | 61183.0 |
603 | 2022-06-02 04:17:40 | twain | 1 | 28756 | 8 | 0.420 | 68466.7 |
602 | 2022-05-26 22:34:10 | twain | 3 | 83667 | 937 | 3.233 | 25879.1 |
601 | 2022-03-14 23:56:31 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
600 | 2022-02-14 06:08:42 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
599 | 2022-01-19 15:50:40 | twain | 3 | 83667 | 937 | 3.326 | 25155.4 |
598 | 2021-12-19 17:30:48 | twain | 3 | 83667 | 937 | 3.250 | 25743.7 |
597 | 2021-12-14 23:46:10 | twain | 3 | 83667 | 937 | 8.030 | 10419.3 |
596 | 2021-12-12 01:18:29 | twain | 1 | 28756 | 8 | 0.486 | 59168.7 |
595 | 2021-11-14 11:14:40 | twain | 1 | 28756 | 8 | 0.500 | 57512.0 |
594 | 2021-11-10 14:48:01 | twain | 3 | 83667 | 937 | 5.093 | 16427.8 |
593 | 2021-11-08 21:46:07 | twain | 3 | 83667 | 937 | 3.220 | 25983.5 |
592 | 2021-10-19 06:38:34 | twain | 1 | 28756 | 8 | 0.420 | 68466.7 |
591 | 2021-09-06 23:55:39 | twain | 1 | 28756 | 8 | 0.530 | 54256.6 |
590 | 2021-09-04 18:27:08 | twain | 1 | 28756 | 8 | 0.470 | 61183.0 |
589 | 2021-08-20 08:41:14 | twain | 1 | 28756 | 8 | 0.420 | 68466.7 |
588 | 2021-08-08 04:01:19 | twain | 3 | 83667 | 937 | 3.360 | 24900.9 |
587 | 2021-07-30 16:23:32 | twain | 1 | 28756 | 8 | 0.420 | 68466.7 |
586 | 2021-07-29 16:22:31 | twain | 3 | 83667 | 937 | 3.143 | 26620.1 |
585 | 2021-07-22 02:15:55 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
584 | 2021-06-29 22:10:22 | twain | 3 | 83667 | 937 | 4.076 | 20526.7 |
583 | 2021-06-27 16:05:08 | twain | 1 | 28756 | 8 | 0.483 | 59536.2 |
582 | 2021-06-27 01:28:53 | twain | 3 | 83667 | 937 | 3.220 | 25983.5 |
581 | 2021-06-06 09:35:11 | twain | 3 | 83667 | 937 | 3.626 | 23074.2 |
580 | 2021-06-05 06:39:41 | twain | 3 | 83667 | 937 | 4.033 | 20745.6 |
579 | 2021-06-04 03:17:50 | twain | 3 | 83667 | 937 | 7.690 | 10880.0 |
578 | 2021-05-06 03:37:23 | twain | 3 | 83667 | 937 | 3.233 | 25879.1 |
577 | 2021-04-19 07:46:08 | twain | 1 | 28756 | 8 | 0.436 | 65954.1 |
576 | 2021-02-26 16:55:41 | twain | 3 | 83667 | 937 | 3.406 | 24564.6 |
575 | 2021-02-24 00:10:39 | twain | 1 | 28756 | 8 | 0.500 | 57512.0 |
574 | 2021-01-23 23:36:07 | twain | 1 | 28756 | 8 | 0.500 | 57512.0 |
573 | 2021-01-01 22:37:30 | twain | 1 | 28756 | 8 | 0.440 | 65354.5 |
572 | 2020-12-25 15:28:03 | twain | 1 | 28756 | 8 | 0.423 | 67981.1 |
571 | 2020-11-14 19:48:12 | twain | 1 | 28756 | 8 | 0.500 | 57512.0 |
570 | 2020-11-13 17:10:32 | twain | 3 | 83667 | 937 | 3.203 | 26121.4 |
569 | 2020-11-11 12:36:27 | twain | 1 | 28756 | 8 | 0.453 | 63479.0 |
568 | 2020-11-03 14:19:40 | twain | 3 | 83667 | 937 | 3.360 | 24900.9 |
567 | 2020-10-27 00:47:07 | twain | 1 | 28756 | 8 | 0.466 | 61708.2 |