History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"charier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
709 | 2024-05-08 04:31:42 | charier | 1 | 69583 | 5 | 1.343 | 51811.6 |
708 | 2024-04-28 02:11:19 | charier | 1 | 69583 | 5 | 1.923 | 36184.6 |
707 | 2024-04-25 20:47:15 | charier | 1 | 69583 | 5 | 2.733 | 25460.3 |
706 | 2024-04-25 06:20:32 | charier | 1 | 69583 | 5 | 1.140 | 61037.7 |
705 | 2024-04-24 04:09:48 | charier | 1 | 69583 | 5 | 1.360 | 51164.0 |
704 | 2024-04-20 18:30:30 | charier | 1 | 69583 | 5 | 1.610 | 43219.3 |
703 | 2024-04-17 21:27:45 | charier | 3 | 134027 | 870 | 25.860 | 5182.8 |
702 | 2024-04-17 15:28:57 | charier | 2 | 107671 | 100 | 11.860 | 9078.5 |
701 | 2024-04-17 04:21:00 | charier | 1 | 69583 | 5 | 1.313 | 52995.4 |
700 | 2024-04-14 16:21:09 | charier | 1 | 69583 | 5 | 1.500 | 46388.7 |
699 | 2024-04-13 21:22:23 | charier | 2 | 107671 | 100 | 3.750 | 28712.3 |
698 | 2024-04-13 21:15:52 | charier | 3 | 134027 | 870 | 7.406 | 18097.1 |
697 | 2024-04-13 09:20:28 | charier | 2 | 107671 | 100 | 3.266 | 32967.2 |
696 | 2024-04-13 07:28:25 | charier | 3 | 134027 | 870 | 10.093 | 13279.2 |
695 | 2024-04-12 23:29:37 | charier | 2 | 107671 | 100 | 4.783 | 22511.2 |
694 | 2024-04-12 23:29:06 | charier | 3 | 134027 | 870 | 7.576 | 17691.0 |
693 | 2024-04-12 22:47:24 | charier | 3 | 134027 | 870 | 7.283 | 18402.7 |
692 | 2024-04-12 21:31:11 | charier | 3 | 134027 | 870 | 16.236 | 8254.9 |
691 | 2024-04-11 10:26:04 | charier | 2 | 107671 | 100 | 3.203 | 33615.7 |
690 | 2024-04-11 10:25:13 | charier | 3 | 134027 | 870 | 6.843 | 19586.0 |
689 | 2024-04-11 06:40:47 | charier | 3 | 134027 | 870 | 6.266 | 21389.6 |
688 | 2024-04-06 17:52:21 | charier | 1 | 69583 | 5 | 2.546 | 27330.3 |
687 | 2024-03-03 23:54:09 | charier | 1 | 69583 | 5 | 1.466 | 47464.5 |
686 | 2024-02-25 05:32:52 | charier | 1 | 69583 | 5 | 1.076 | 64668.2 |
685 | 2024-02-22 17:52:04 | charier | 1 | 69583 | 5 | 2.046 | 34009.3 |
684 | 2024-01-06 18:59:59 | charier | 2 | 107671 | 100 | 3.343 | 32207.9 |
683 | 2023-12-31 13:25:52 | charier | 1 | 69583 | 5 | 1.170 | 59472.6 |
682 | 2023-12-29 22:57:25 | charier | 2 | 107671 | 100 | 6.093 | 17671.3 |
681 | 2023-12-29 22:57:24 | charier | 3 | 134027 | 870 | 6.843 | 19586.0 |
680 | 2023-12-12 21:11:59 | charier | 3 | 134027 | 870 | 6.703 | 19995.1 |
679 | 2023-12-12 21:11:53 | charier | 2 | 107671 | 100 | 3.190 | 33752.7 |
678 | 2023-12-08 09:28:18 | charier | 3 | 134027 | 870 | 5.860 | 22871.5 |
677 | 2023-12-08 09:28:11 | charier | 3 | 134027 | 870 | 6.296 | 21287.6 |
676 | 2023-12-08 03:56:06 | charier | 3 | 134027 | 870 | 6.093 | 21996.9 |
675 | 2023-12-08 03:55:59 | charier | 3 | 134027 | 870 | 6.140 | 21828.5 |
674 | 2023-12-08 03:49:44 | charier | 3 | 134027 | 870 | 6.453 | 20769.7 |
673 | 2023-12-08 03:43:08 | charier | 3 | 134027 | 870 | 6.440 | 20811.6 |
672 | 2023-12-08 01:44:42 | charier | 3 | 134027 | 870 | 6.953 | 19276.1 |
671 | 2023-11-15 12:33:00 | charier | 1 | 69583 | 5 | 1.093 | 63662.4 |
670 | 2023-11-14 09:06:35 | charier | 1 | 69583 | 5 | 1.093 | 63662.4 |
669 | 2023-11-11 00:51:03 | charier | 1 | 69583 | 5 | 1.046 | 66522.9 |
668 | 2023-11-05 15:27:51 | charier | 1 | 69583 | 5 | 1.080 | 64428.7 |
667 | 2023-10-26 08:45:21 | charier | 1 | 69583 | 5 | 1.220 | 57035.2 |
666 | 2023-10-24 02:58:37 | charier | 1 | 69583 | 5 | 1.156 | 60192.9 |
665 | 2023-10-19 08:52:27 | charier | 1 | 69583 | 5 | 1.080 | 64428.7 |
664 | 2023-10-19 04:56:57 | charier | 1 | 69583 | 5 | 1.296 | 53690.6 |
663 | 2023-10-16 21:04:57 | charier | 1 | 69583 | 5 | 2.640 | 26357.2 |
662 | 2023-10-14 17:29:10 | charier | 2 | 107671 | 100 | 3.686 | 29210.8 |
661 | 2023-10-06 17:53:57 | charier | 1 | 69583 | 5 | 1.063 | 65459.1 |
660 | 2023-09-28 03:51:04 | charier | 1 | 69583 | 5 | 1.060 | 65644.3 |
659 | 2023-09-25 14:52:36 | charier | 2 | 107671 | 100 | 3.313 | 32499.5 |
658 | 2023-09-17 11:20:04 | charier | 2 | 107671 | 100 | 3.453 | 31181.9 |
657 | 2023-09-12 16:05:58 | charier | 3 | 134027 | 870 | 6.843 | 19586.0 |
656 | 2023-09-11 13:27:51 | charier | 1 | 69583 | 5 | 1.190 | 58473.1 |
655 | 2023-09-11 03:50:42 | charier | 3 | 134027 | 870 | 7.453 | 17983.0 |
654 | 2023-09-10 17:25:28 | charier | 3 | 134027 | 870 | 7.376 | 18170.7 |
653 | 2023-09-09 07:21:26 | charier | 3 | 134027 | 870 | 7.000 | 19146.7 |
652 | 2023-09-07 18:13:50 | charier | 3 | 134027 | 870 | 6.080 | 22043.9 |
651 | 2023-09-05 05:21:03 | charier | 3 | 134027 | 870 | 5.750 | 23309.0 |
650 | 2023-09-03 22:18:33 | charier | 3 | 134027 | 870 | 5.640 | 23763.7 |
649 | 2023-09-02 23:43:29 | charier | 3 | 134027 | 870 | 5.983 | 22401.3 |
648 | 2023-09-01 23:01:13 | charier | 3 | 134027 | 870 | 6.013 | 22289.5 |
647 | 2023-08-19 15:08:45 | charier | 3 | 134027 | 870 | 6.423 | 20866.7 |
646 | 2023-08-16 02:33:46 | charier | 1 | 69583 | 5 | 1.313 | 52995.4 |
645 | 2023-08-12 10:33:07 | charier | 1 | 69583 | 5 | 1.063 | 65459.1 |
644 | 2023-07-25 07:53:15 | charier | 2 | 107671 | 100 | 3.190 | 33752.7 |
643 | 2023-07-06 02:56:18 | charier | 1 | 69583 | 5 | 1.220 | 57035.2 |
642 | 2023-07-06 01:40:36 | charier | 1 | 69583 | 5 | 1.190 | 58473.1 |
641 | 2023-07-03 11:21:39 | charier | 1 | 69583 | 5 | 1.063 | 65459.1 |
640 | 2023-06-29 22:39:45 | charier | 1 | 69583 | 5 | 1.190 | 58473.1 |
639 | 2023-05-22 09:00:51 | charier | 1 | 69583 | 5 | 1.080 | 64428.7 |
638 | 2023-05-15 12:53:06 | charier | 1 | 69583 | 5 | 1.063 | 65459.1 |
637 | 2023-05-13 09:28:48 | charier | 1 | 69583 | 5 | 1.216 | 57222.9 |
636 | 2023-05-07 20:52:52 | charier | 1 | 69583 | 5 | 1.093 | 63662.4 |
635 | 2023-05-04 15:28:48 | charier | 3 | 134027 | 870 | 5.656 | 23696.4 |
634 | 2023-04-07 01:28:23 | charier | 2 | 107671 | 100 | 2.780 | 38730.6 |
633 | 2023-04-02 07:04:51 | charier | 1 | 69583 | 5 | 1.186 | 58670.3 |
632 | 2023-04-02 00:59:33 | charier | 1 | 69583 | 5 | 1.063 | 65459.1 |
631 | 2023-03-23 15:26:37 | charier | 1 | 69583 | 5 | 1.203 | 57841.2 |
630 | 2023-03-20 11:54:11 | charier | 3 | 134027 | 870 | 6.033 | 22215.6 |
629 | 2023-03-20 08:50:01 | charier | 1 | 69583 | 5 | 1.233 | 56433.9 |
628 | 2023-03-18 01:49:26 | charier | 1 | 69583 | 5 | 1.063 | 65459.1 |
627 | 2023-03-14 02:03:54 | charier | 3 | 134027 | 870 | 5.826 | 23005.0 |
626 | 2023-03-11 13:42:50 | charier | 1 | 69583 | 5 | 1.046 | 66522.9 |
625 | 2023-03-05 13:55:54 | charier | 1 | 69583 | 5 | 1.076 | 64668.2 |
624 | 2023-02-06 07:25:04 | charier | 3 | 134027 | 870 | 5.640 | 23763.7 |
623 | 2023-01-28 05:06:15 | charier | 1 | 69583 | 5 | 1.060 | 65644.3 |
622 | 2023-01-23 01:22:28 | charier | 1 | 69583 | 5 | 1.173 | 59320.5 |
621 | 2023-01-13 10:57:48 | charier | 1 | 69583 | 5 | 1.250 | 55666.4 |
620 | 2023-01-10 07:00:43 | charier | 2 | 107671 | 100 | 2.733 | 39396.6 |
619 | 2022-12-31 12:22:01 | charier | 3 | 134027 | 870 | 6.063 | 22105.7 |
618 | 2022-12-30 17:49:40 | charier | 1 | 69583 | 5 | 1.156 | 60192.9 |
617 | 2022-12-20 18:18:03 | charier | 1 | 69583 | 5 | 1.186 | 58670.3 |
616 | 2022-12-08 21:25:32 | charier | 1 | 69583 | 5 | 1.203 | 57841.2 |
615 | 2022-11-29 07:49:42 | charier | 1 | 69583 | 5 | 1.173 | 59320.5 |
614 | 2022-10-26 22:39:56 | charier | 1 | 69583 | 5 | 1.030 | 67556.3 |
613 | 2022-10-22 17:00:37 | charier | 1 | 69583 | 5 | 1.140 | 61037.7 |
612 | 2022-10-13 00:23:14 | charier | 1 | 69583 | 5 | 1.063 | 65459.1 |
611 | 2022-10-12 21:26:31 | charier | 2 | 107671 | 100 | 2.860 | 37647.2 |
610 | 2022-09-19 04:55:15 | charier | 1 | 69583 | 5 | 1.093 | 63662.4 |