History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"woof"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
727 | 2024-04-27 11:02:08 | woof | 1 | 13983 | 14 | 0.546 | 25609.9 |
726 | 2024-04-02 18:50:54 | woof | 2 | 29872 | 170 | 2.033 | 14693.6 |
725 | 2024-04-02 18:13:44 | woof | 1 | 13983 | 14 | 0.503 | 27799.2 |
724 | 2024-04-01 16:01:37 | woof | 1 | 13983 | 14 | 0.546 | 25609.9 |
723 | 2024-03-30 20:46:47 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
722 | 2024-03-26 23:29:07 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
721 | 2024-03-21 07:34:12 | woof | 2 | 29872 | 170 | 2.110 | 14157.3 |
720 | 2024-03-21 07:34:08 | woof | 2 | 29872 | 170 | 2.110 | 14157.3 |
719 | 2024-03-03 20:05:23 | woof | 2 | 29872 | 170 | 0.750 | 39829.3 |
718 | 2024-03-02 14:26:48 | woof | 2 | 29872 | 170 | 1.190 | 25102.5 |
717 | 2024-03-02 13:51:55 | woof | 1 | 13983 | 14 | 0.280 | 49939.3 |
716 | 2024-02-25 16:31:11 | woof | 1 | 13983 | 14 | 0.530 | 26383.0 |
715 | 2024-02-01 10:27:19 | woof | 1 | 13983 | 14 | 0.500 | 27966.0 |
714 | 2024-01-28 13:53:23 | woof | 1 | 13983 | 14 | 0.220 | 63559.1 |
713 | 2024-01-09 09:29:33 | woof | 1 | 13983 | 14 | 0.203 | 68881.8 |
712 | 2023-12-29 02:23:16 | woof | 2 | 29872 | 170 | 0.860 | 34734.9 |
711 | 2023-12-03 12:55:09 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
710 | 2023-12-03 12:55:08 | woof | 1 | 13983 | 14 | 0.266 | 52567.7 |
709 | 2023-11-30 18:21:06 | woof | 2 | 29872 | 170 | 0.733 | 40753.1 |
708 | 2023-11-26 15:51:40 | woof | 2 | 29872 | 170 | 0.876 | 34100.5 |
707 | 2023-11-21 13:17:58 | woof | 1 | 13983 | 14 | 0.203 | 68881.8 |
706 | 2023-11-13 20:11:47 | woof | 2 | 29872 | 170 | 0.810 | 36879.0 |
705 | 2023-11-09 18:43:49 | woof | 1 | 13983 | 14 | 0.220 | 63559.1 |
704 | 2023-11-02 07:34:28 | woof | 1 | 13983 | 14 | 0.483 | 28950.3 |
703 | 2023-10-26 18:54:38 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
702 | 2023-10-24 11:58:33 | woof | 1 | 13983 | 14 | 0.220 | 63559.1 |
701 | 2023-10-20 06:49:51 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
700 | 2023-10-17 07:11:37 | woof | 1 | 13983 | 14 | 0.266 | 52567.7 |
699 | 2023-10-13 19:03:27 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
698 | 2023-10-04 00:42:50 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
697 | 2023-09-23 23:46:55 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
696 | 2023-09-11 11:30:11 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
695 | 2023-09-11 03:21:45 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
694 | 2023-08-29 22:03:35 | woof | 2 | 29872 | 170 | 0.720 | 41488.9 |
693 | 2023-08-24 18:13:05 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
692 | 2023-08-06 15:07:37 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
691 | 2023-06-26 08:16:26 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
690 | 2023-05-27 15:48:56 | woof | 1 | 13983 | 14 | 0.203 | 68881.8 |
689 | 2023-05-15 19:53:38 | woof | 2 | 29872 | 170 | 0.750 | 39829.3 |
688 | 2023-03-24 12:56:51 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
687 | 2023-02-25 01:24:48 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
686 | 2023-02-23 16:33:29 | woof | 2 | 29872 | 170 | 0.876 | 34100.5 |
685 | 2023-02-04 04:54:41 | woof | 2 | 29872 | 170 | 0.846 | 35309.7 |
684 | 2023-01-08 17:55:22 | woof | 1 | 13983 | 14 | 0.203 | 68881.8 |
683 | 2022-12-23 22:30:05 | woof | 1 | 13983 | 14 | 0.220 | 63559.1 |
682 | 2022-12-05 02:02:00 | woof | 2 | 29872 | 170 | 0.890 | 33564.0 |
681 | 2022-11-26 14:27:04 | woof | 2 | 29872 | 170 | 0.813 | 36742.9 |
680 | 2022-11-24 21:20:31 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
679 | 2022-11-06 23:18:35 | woof | 2 | 29872 | 170 | 0.813 | 36742.9 |
678 | 2022-10-21 09:22:36 | woof | 1 | 13983 | 14 | 0.266 | 52567.7 |
677 | 2022-10-17 19:13:47 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
676 | 2022-10-10 10:51:27 | woof | 2 | 29872 | 170 | 0.703 | 42492.2 |
675 | 2022-10-08 14:51:21 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
674 | 2022-10-05 19:09:41 | woof | 2 | 29872 | 170 | 0.813 | 36742.9 |
673 | 2022-09-19 05:03:17 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
672 | 2022-09-13 10:07:14 | woof | 2 | 29872 | 170 | 0.843 | 35435.3 |
671 | 2022-09-12 05:39:51 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
670 | 2022-09-10 15:58:40 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
669 | 2022-09-03 18:52:42 | woof | 1 | 13983 | 14 | 0.203 | 68881.8 |
668 | 2022-09-02 18:28:18 | woof | 2 | 29872 | 170 | 0.716 | 41720.7 |
667 | 2022-08-14 02:29:10 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
666 | 2022-08-08 01:46:17 | woof | 2 | 29872 | 170 | 0.860 | 34734.9 |
665 | 2022-08-06 22:09:21 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
664 | 2022-07-03 08:45:43 | woof | 1 | 13983 | 14 | 0.203 | 68881.8 |
663 | 2022-07-02 09:23:11 | woof | 1 | 13983 | 14 | 0.220 | 63559.1 |
662 | 2022-06-16 08:44:19 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
661 | 2022-06-16 06:14:10 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
660 | 2022-06-15 19:51:27 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
659 | 2022-06-08 16:03:47 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
658 | 2022-06-01 12:26:27 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
657 | 2022-05-25 15:52:16 | woof | 1 | 13983 | 14 | 0.266 | 52567.7 |
656 | 2022-05-22 18:03:23 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
655 | 2022-05-20 13:57:34 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
654 | 2022-04-09 12:38:19 | woof | 2 | 29872 | 170 | 0.733 | 40753.1 |
653 | 2022-03-04 04:53:49 | woof | 1 | 13983 | 14 | 0.220 | 63559.1 |
652 | 2022-02-04 14:43:01 | woof | 1 | 13983 | 14 | 0.500 | 27966.0 |
651 | 2022-02-04 03:46:17 | woof | 1 | 13983 | 14 | 0.220 | 63559.1 |
650 | 2022-02-02 00:46:35 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
649 | 2022-01-04 11:30:18 | woof | 1 | 13983 | 14 | 0.313 | 44674.1 |
648 | 2022-01-03 20:06:42 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
647 | 2022-01-03 12:22:46 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
646 | 2022-01-01 02:10:44 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
645 | 2021-12-31 15:17:05 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
644 | 2021-12-31 07:10:20 | woof | 1 | 13983 | 14 | 0.263 | 53167.3 |
643 | 2021-12-30 15:02:49 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
642 | 2021-12-29 19:58:12 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
641 | 2021-12-29 08:40:44 | woof | 1 | 13983 | 14 | 0.216 | 64736.1 |
640 | 2021-12-28 19:34:23 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
639 | 2021-12-28 03:46:08 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
638 | 2021-12-27 18:29:12 | woof | 1 | 13983 | 14 | 0.500 | 27966.0 |
637 | 2021-12-27 09:36:20 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
636 | 2021-12-26 17:50:46 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
635 | 2021-12-26 07:08:03 | woof | 1 | 13983 | 14 | 0.266 | 52567.7 |
634 | 2021-12-25 18:39:50 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
633 | 2021-12-25 06:27:40 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
632 | 2021-12-24 23:47:02 | woof | 1 | 13983 | 14 | 0.233 | 60012.9 |
631 | 2021-12-24 10:18:38 | woof | 1 | 13983 | 14 | 0.250 | 55932.0 |
630 | 2021-11-25 23:46:36 | woof | 1 | 13983 | 14 | 0.236 | 59250.0 |
629 | 2021-11-23 20:56:54 | woof | 1 | 13983 | 14 | 0.296 | 47239.9 |
628 | 2021-10-30 15:42:43 | woof | 1 | 13983 | 14 | 0.203 | 68881.8 |