History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doodies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
734 | 2024-04-16 00:47:52 | doodies | 3 | 134027 | 656 | 17.343 | 7728.0 |
733 | 2024-04-15 21:37:02 | doodies | 2 | 107671 | 94 | 3.766 | 28590.3 |
732 | 2024-04-15 21:36:32 | doodies | 3 | 134027 | 656 | 6.593 | 20328.7 |
731 | 2024-04-15 08:25:33 | doodies | 3 | 134027 | 656 | 16.766 | 7994.0 |
730 | 2024-04-14 17:40:28 | doodies | 3 | 134027 | 656 | 14.453 | 9273.3 |
729 | 2024-04-01 01:54:14 | doodies | 1 | 69583 | 11 | 1.343 | 51811.6 |
728 | 2024-03-28 18:17:11 | doodies | 1 | 69583 | 11 | 1.280 | 54361.7 |
727 | 2024-02-17 01:56:52 | doodies | 2 | 107671 | 94 | 4.813 | 22370.9 |
726 | 2024-02-04 14:17:03 | doodies | 3 | 134027 | 656 | 7.343 | 18252.3 |
725 | 2024-02-04 13:07:30 | doodies | 3 | 134027 | 656 | 7.483 | 17910.9 |
724 | 2024-02-02 14:40:27 | doodies | 2 | 107671 | 94 | 3.063 | 35152.1 |
723 | 2024-01-30 13:44:51 | doodies | 3 | 134027 | 656 | 11.046 | 12133.5 |
722 | 2024-01-30 08:28:57 | doodies | 2 | 107671 | 94 | 7.033 | 15309.4 |
721 | 2024-01-30 08:24:17 | doodies | 3 | 134027 | 656 | 6.983 | 19193.3 |
720 | 2024-01-19 17:52:53 | doodies | 2 | 107671 | 94 | 5.126 | 21004.9 |
719 | 2024-01-19 08:47:27 | doodies | 1 | 69583 | 11 | 1.203 | 57841.2 |
718 | 2024-01-18 19:13:25 | doodies | 3 | 134027 | 656 | 6.186 | 21666.2 |
717 | 2024-01-09 08:21:36 | doodies | 2 | 107671 | 94 | 3.856 | 27923.0 |
716 | 2023-12-27 02:41:17 | doodies | 1 | 69583 | 11 | 1.080 | 64428.7 |
715 | 2023-12-23 13:34:33 | doodies | 1 | 69583 | 11 | 1.093 | 63662.4 |
714 | 2023-12-14 05:27:05 | doodies | 3 | 134027 | 656 | 5.703 | 23501.1 |
713 | 2023-12-02 21:51:08 | doodies | 1 | 69583 | 11 | 1.250 | 55666.4 |
712 | 2023-11-20 12:36:55 | doodies | 1 | 69583 | 11 | 1.406 | 49490.0 |
711 | 2023-11-17 13:39:17 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
710 | 2023-11-16 09:46:42 | doodies | 2 | 107671 | 94 | 2.763 | 38968.9 |
709 | 2023-11-13 07:37:49 | doodies | 1 | 69583 | 11 | 1.186 | 58670.3 |
708 | 2023-11-11 09:10:47 | doodies | 1 | 69583 | 11 | 1.063 | 65459.1 |
707 | 2023-11-06 19:10:39 | doodies | 1 | 69583 | 11 | 1.173 | 59320.5 |
706 | 2023-10-25 11:19:06 | doodies | 1 | 69583 | 11 | 2.440 | 28517.6 |
705 | 2023-10-14 04:12:44 | doodies | 1 | 69583 | 11 | 1.173 | 59320.5 |
704 | 2023-09-29 05:34:59 | doodies | 1 | 69583 | 11 | 1.080 | 64428.7 |
703 | 2023-09-13 18:12:56 | doodies | 1 | 69583 | 11 | 1.203 | 57841.2 |
702 | 2023-09-12 04:33:44 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
701 | 2023-09-12 02:45:37 | doodies | 3 | 134027 | 656 | 6.343 | 21129.9 |
700 | 2023-09-01 23:33:58 | doodies | 1 | 69583 | 11 | 1.203 | 57841.2 |
699 | 2023-08-18 02:43:19 | doodies | 2 | 107671 | 94 | 2.813 | 38276.2 |
698 | 2023-07-31 17:12:42 | doodies | 1 | 69583 | 11 | 1.250 | 55666.4 |
697 | 2023-07-30 14:08:20 | doodies | 1 | 69583 | 11 | 1.076 | 64668.2 |
696 | 2023-07-18 04:51:52 | doodies | 1 | 69583 | 11 | 1.060 | 65644.3 |
695 | 2023-07-15 19:19:16 | doodies | 1 | 69583 | 11 | 1.033 | 67360.1 |
694 | 2023-07-14 23:11:02 | doodies | 1 | 69583 | 11 | 1.076 | 64668.2 |
693 | 2023-07-14 01:50:41 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
692 | 2023-06-29 06:27:26 | doodies | 3 | 134027 | 656 | 5.686 | 23571.4 |
691 | 2023-06-06 12:45:42 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
690 | 2023-06-05 11:04:06 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
689 | 2023-06-04 12:58:01 | doodies | 3 | 134027 | 656 | 6.016 | 22278.4 |
688 | 2023-06-03 06:20:45 | doodies | 1 | 69583 | 11 | 1.033 | 67360.1 |
687 | 2023-05-20 21:21:25 | doodies | 1 | 69583 | 11 | 1.076 | 64668.2 |
686 | 2023-05-19 21:13:18 | doodies | 1 | 69583 | 11 | 1.156 | 60192.9 |
685 | 2023-05-18 21:46:07 | doodies | 1 | 69583 | 11 | 1.030 | 67556.3 |
684 | 2023-05-05 16:37:17 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
683 | 2023-05-04 16:24:51 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
682 | 2023-05-04 10:43:56 | doodies | 2 | 107671 | 94 | 2.780 | 38730.6 |
681 | 2023-05-03 16:15:08 | doodies | 1 | 69583 | 11 | 1.063 | 65459.1 |
680 | 2023-05-02 16:25:29 | doodies | 1 | 69583 | 11 | 1.063 | 65459.1 |
679 | 2023-04-24 13:44:55 | doodies | 1 | 69583 | 11 | 1.110 | 62687.4 |
678 | 2023-04-22 23:14:44 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
677 | 2023-04-21 23:11:46 | doodies | 1 | 69583 | 11 | 1.220 | 57035.2 |
676 | 2023-04-20 23:01:10 | doodies | 1 | 69583 | 11 | 1.093 | 63662.4 |
675 | 2023-04-19 22:53:58 | doodies | 1 | 69583 | 11 | 1.143 | 60877.5 |
674 | 2023-04-13 05:55:07 | doodies | 1 | 69583 | 11 | 1.170 | 59472.6 |
673 | 2023-04-12 05:54:32 | doodies | 1 | 69583 | 11 | 1.076 | 64668.2 |
672 | 2023-04-11 00:45:34 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
671 | 2023-04-10 01:32:03 | doodies | 1 | 69583 | 11 | 1.093 | 63662.4 |
670 | 2023-04-09 03:44:13 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
669 | 2023-04-08 04:07:51 | doodies | 1 | 69583 | 11 | 1.033 | 67360.1 |
668 | 2023-04-07 06:40:10 | doodies | 1 | 69583 | 11 | 1.203 | 57841.2 |
667 | 2023-03-28 19:00:11 | doodies | 1 | 69583 | 11 | 1.156 | 60192.9 |
666 | 2023-03-27 19:00:05 | doodies | 1 | 69583 | 11 | 1.436 | 48456.1 |
665 | 2023-03-27 16:58:52 | doodies | 1 | 69583 | 11 | 1.153 | 60349.5 |
664 | 2023-03-27 10:42:22 | doodies | 1 | 69583 | 11 | 1.216 | 57222.9 |
663 | 2023-03-26 18:57:25 | doodies | 1 | 69583 | 11 | 1.220 | 57035.2 |
662 | 2023-03-25 18:44:17 | doodies | 1 | 69583 | 11 | 2.376 | 29285.8 |
661 | 2023-03-25 16:49:16 | doodies | 1 | 69583 | 11 | 1.173 | 59320.5 |
660 | 2023-03-24 18:51:00 | doodies | 1 | 69583 | 11 | 1.126 | 61796.6 |
659 | 2023-03-23 18:50:55 | doodies | 1 | 69583 | 11 | 1.203 | 57841.2 |
658 | 2023-03-22 18:51:05 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
657 | 2023-03-21 18:43:30 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
656 | 2023-03-11 13:54:28 | doodies | 3 | 134027 | 656 | 5.593 | 23963.3 |
655 | 2023-03-06 11:14:46 | doodies | 1 | 69583 | 11 | 1.050 | 66269.5 |
654 | 2023-03-05 10:57:30 | doodies | 1 | 69583 | 11 | 1.093 | 63662.4 |
653 | 2023-03-04 11:17:42 | doodies | 1 | 69583 | 11 | 1.140 | 61037.7 |
652 | 2023-03-03 10:59:47 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
651 | 2023-02-25 02:39:15 | doodies | 1 | 69583 | 11 | 1.063 | 65459.1 |
650 | 2023-02-09 08:16:43 | doodies | 2 | 107671 | 94 | 3.156 | 34116.3 |
649 | 2023-01-10 18:32:03 | doodies | 1 | 69583 | 11 | 1.063 | 65459.1 |
648 | 2023-01-05 15:12:47 | doodies | 3 | 134027 | 656 | 5.766 | 23244.4 |
647 | 2022-12-16 13:31:36 | doodies | 3 | 134027 | 656 | 5.550 | 24149.0 |
646 | 2022-12-15 04:37:12 | doodies | 3 | 134027 | 656 | 5.970 | 22450.1 |
645 | 2022-12-15 01:34:38 | doodies | 3 | 134027 | 656 | 6.233 | 21502.8 |
644 | 2022-12-13 16:11:17 | doodies | 3 | 134027 | 656 | 5.563 | 24092.6 |
643 | 2022-11-23 14:40:06 | doodies | 2 | 107671 | 94 | 3.200 | 33647.2 |
642 | 2022-11-22 23:17:53 | doodies | 3 | 134027 | 656 | 5.796 | 23124.1 |
641 | 2022-11-21 23:48:29 | doodies | 3 | 134027 | 656 | 5.890 | 22755.0 |
640 | 2022-11-18 23:30:49 | doodies | 1 | 69583 | 11 | 1.046 | 66522.9 |
639 | 2022-11-17 08:57:51 | doodies | 3 | 134027 | 656 | 6.986 | 19185.1 |
638 | 2022-11-15 00:58:26 | doodies | 3 | 134027 | 656 | 5.576 | 24036.4 |
637 | 2022-11-07 14:58:15 | doodies | 3 | 134027 | 656 | 6.486 | 20664.0 |
636 | 2022-10-10 03:01:28 | doodies | 1 | 69583 | 11 | 1.076 | 64668.2 |
635 | 2022-10-05 22:37:31 | doodies | 3 | 134027 | 656 | 5.640 | 23763.7 |