History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
699 | 2024-04-22 12:18:04 | canty | 2 | 53800 | 168 | 1.906 | 28226.7 |
698 | 2024-04-21 01:37:41 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
697 | 2024-04-03 06:04:22 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
696 | 2024-03-31 03:26:27 | canty | 1 | 28756 | 12 | 1.390 | 20687.8 |
695 | 2024-03-28 18:53:44 | canty | 2 | 53800 | 168 | 1.936 | 27789.3 |
694 | 2024-03-28 18:12:41 | canty | 1 | 28756 | 12 | 0.533 | 53951.2 |
693 | 2024-03-28 08:38:49 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
692 | 2024-03-03 21:00:55 | canty | 1 | 28756 | 12 | 0.513 | 56054.6 |
691 | 2024-03-01 09:29:08 | canty | 1 | 28756 | 12 | 0.580 | 49579.3 |
690 | 2024-02-27 08:32:37 | canty | 2 | 53800 | 168 | 3.500 | 15371.4 |
689 | 2024-02-26 07:51:44 | canty | 2 | 53800 | 168 | 1.483 | 36277.8 |
688 | 2024-02-26 07:51:35 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
687 | 2024-02-12 17:17:50 | canty | 2 | 53800 | 168 | 1.436 | 37465.2 |
686 | 2024-01-28 19:50:31 | canty | 1 | 28756 | 12 | 0.483 | 59536.2 |
685 | 2024-01-26 23:08:41 | canty | 1 | 28756 | 12 | 0.516 | 55728.7 |
684 | 2024-01-09 12:33:11 | canty | 1 | 28756 | 12 | 0.483 | 59536.2 |
683 | 2024-01-08 23:27:24 | canty | 1 | 28756 | 12 | 0.483 | 59536.2 |
682 | 2023-12-29 23:14:05 | canty | 1 | 28756 | 12 | 0.533 | 53951.2 |
681 | 2023-12-21 07:52:21 | canty | 2 | 53800 | 168 | 1.610 | 33416.1 |
680 | 2023-12-18 09:19:45 | canty | 2 | 53800 | 168 | 1.720 | 31279.1 |
679 | 2023-12-08 11:25:51 | canty | 1 | 28756 | 12 | 0.470 | 61183.0 |
678 | 2023-12-08 11:25:50 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
677 | 2023-12-05 14:51:56 | canty | 2 | 53800 | 168 | 1.610 | 33416.1 |
676 | 2023-12-03 07:44:26 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
675 | 2023-12-03 07:44:25 | canty | 1 | 28756 | 12 | 0.516 | 55728.7 |
674 | 2023-11-23 13:59:47 | canty | 2 | 53800 | 168 | 1.423 | 37807.4 |
673 | 2023-11-23 06:22:33 | canty | 1 | 28756 | 12 | 0.516 | 55728.7 |
672 | 2023-11-12 03:30:01 | canty | 1 | 28756 | 12 | 0.516 | 55728.7 |
671 | 2023-11-09 14:55:33 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
670 | 2023-11-01 17:41:58 | canty | 1 | 28756 | 12 | 0.486 | 59168.7 |
669 | 2023-10-28 02:56:12 | canty | 1 | 28756 | 12 | 0.483 | 59536.2 |
668 | 2023-10-20 10:56:04 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
667 | 2023-10-17 22:32:12 | canty | 1 | 28756 | 12 | 0.546 | 52666.7 |
666 | 2023-10-14 00:25:57 | canty | 1 | 28756 | 12 | 0.530 | 54256.6 |
665 | 2023-10-04 14:28:28 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
664 | 2023-09-30 01:56:13 | canty | 2 | 53800 | 168 | 2.843 | 18923.7 |
663 | 2023-09-29 22:50:23 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
662 | 2023-09-24 19:23:42 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
661 | 2023-09-22 14:39:54 | canty | 2 | 53800 | 168 | 1.470 | 36598.6 |
660 | 2023-09-20 15:29:24 | canty | 1 | 28756 | 12 | 0.530 | 54256.6 |
659 | 2023-08-25 03:52:05 | canty | 1 | 28756 | 12 | 0.466 | 61708.2 |
658 | 2023-08-19 18:24:10 | canty | 1 | 28756 | 12 | 0.550 | 52283.6 |
657 | 2023-07-12 02:06:39 | canty | 2 | 53800 | 168 | 1.563 | 34421.0 |
656 | 2023-07-02 06:03:16 | canty | 2 | 53800 | 168 | 1.593 | 33772.8 |
655 | 2023-06-26 03:36:12 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
654 | 2023-05-25 12:12:01 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
653 | 2023-03-31 14:05:15 | canty | 2 | 53800 | 168 | 1.576 | 34137.1 |
652 | 2023-03-27 00:34:06 | canty | 1 | 28756 | 12 | 0.486 | 59168.7 |
651 | 2023-03-24 15:05:12 | canty | 2 | 53800 | 168 | 1.580 | 34050.6 |
650 | 2023-03-20 13:44:18 | canty | 1 | 28756 | 12 | 0.516 | 55728.7 |
649 | 2023-03-20 08:50:06 | canty | 1 | 28756 | 12 | 0.530 | 54256.6 |
648 | 2023-01-07 15:07:37 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
647 | 2022-12-23 02:55:14 | canty | 2 | 53800 | 168 | 1.390 | 38705.0 |
646 | 2022-12-08 19:23:36 | canty | 1 | 28756 | 12 | 0.436 | 65954.1 |
645 | 2022-10-01 05:44:06 | canty | 1 | 28756 | 12 | 0.533 | 53951.2 |
644 | 2022-09-14 09:20:34 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
643 | 2022-09-01 16:46:56 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
642 | 2022-09-01 02:57:54 | canty | 1 | 28756 | 12 | 0.450 | 63902.2 |
641 | 2022-08-28 06:01:41 | canty | 1 | 28756 | 12 | 0.470 | 61183.0 |
640 | 2022-08-19 12:33:25 | canty | 2 | 53800 | 168 | 1.670 | 32215.6 |
639 | 2022-08-14 20:12:38 | canty | 1 | 28756 | 12 | 0.466 | 61708.2 |
638 | 2022-08-06 13:24:27 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
637 | 2022-07-04 01:09:39 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
636 | 2022-05-23 03:48:44 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
635 | 2022-05-19 17:37:47 | canty | 1 | 28756 | 12 | 0.563 | 51076.4 |
634 | 2022-05-19 03:22:25 | canty | 1 | 28756 | 12 | 0.470 | 61183.0 |
633 | 2022-05-15 05:52:58 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
632 | 2022-03-13 04:25:16 | canty | 2 | 53800 | 168 | 1.486 | 36204.6 |
631 | 2022-02-15 01:38:13 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
630 | 2022-02-11 12:40:37 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
629 | 2022-02-05 08:48:11 | canty | 1 | 28756 | 12 | 0.533 | 53951.2 |
628 | 2021-12-08 17:59:59 | canty | 2 | 53800 | 168 | 1.466 | 36698.5 |
627 | 2021-12-01 09:03:15 | canty | 1 | 28756 | 12 | 0.546 | 52666.7 |
626 | 2021-11-29 06:59:03 | canty | 1 | 28756 | 12 | 0.483 | 59536.2 |
625 | 2021-11-10 12:01:29 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
624 | 2021-11-07 02:17:33 | canty | 1 | 28756 | 12 | 0.546 | 52666.7 |
623 | 2021-10-12 22:00:20 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
622 | 2021-10-10 19:21:27 | canty | 1 | 28756 | 12 | 0.576 | 49923.6 |
621 | 2021-10-03 14:55:56 | canty | 2 | 53800 | 168 | 1.406 | 38264.6 |
620 | 2021-09-06 17:39:11 | canty | 1 | 28756 | 12 | 0.513 | 56054.6 |
619 | 2021-08-22 07:13:45 | canty | 1 | 28756 | 12 | 0.513 | 56054.6 |
618 | 2021-08-04 00:02:58 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
617 | 2021-06-07 13:38:57 | canty | 1 | 28756 | 12 | 0.906 | 31739.5 |
616 | 2021-05-13 13:20:02 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |
615 | 2021-04-29 15:08:00 | canty | 1 | 28756 | 12 | 0.563 | 51076.4 |
614 | 2021-04-12 09:53:17 | canty | 1 | 28756 | 12 | 0.516 | 55728.7 |
613 | 2021-03-27 20:07:17 | canty | 2 | 53800 | 168 | 1.766 | 30464.3 |
612 | 2021-03-26 00:19:55 | canty | 2 | 53800 | 168 | 1.423 | 37807.4 |
611 | 2021-03-25 02:42:05 | canty | 2 | 53800 | 168 | 1.656 | 32487.9 |
610 | 2021-03-16 07:43:40 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
609 | 2021-02-28 19:47:20 | canty | 2 | 53800 | 168 | 1.406 | 38264.6 |
608 | 2021-02-27 21:40:29 | canty | 2 | 53800 | 168 | 1.983 | 27130.6 |
607 | 2021-02-17 22:17:59 | canty | 1 | 28756 | 12 | 0.516 | 55728.7 |
606 | 2021-02-03 15:42:13 | canty | 2 | 53800 | 168 | 1.423 | 37807.4 |
605 | 2021-01-29 18:54:08 | canty | 2 | 53800 | 168 | 1.436 | 37465.2 |
604 | 2021-01-25 08:51:40 | canty | 1 | 28756 | 12 | 0.453 | 63479.0 |
603 | 2021-01-25 04:55:36 | canty | 1 | 28756 | 12 | 0.483 | 59536.2 |
602 | 2021-01-01 12:11:00 | canty | 2 | 53800 | 168 | 1.423 | 37807.4 |
601 | 2020-11-05 19:24:13 | canty | 1 | 28756 | 12 | 0.483 | 59536.2 |
600 | 2020-11-05 11:40:27 | canty | 1 | 28756 | 12 | 0.500 | 57512.0 |