History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"auld"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
730 | 2024-04-25 12:59:05 | auld | 2 | 29872 | 180 | 1.030 | 29001.9 |
729 | 2024-04-23 15:56:42 | auld | 2 | 29872 | 180 | 4.233 | 7056.9 |
728 | 2024-04-23 15:30:07 | auld | 2 | 29872 | 180 | 0.953 | 31345.2 |
727 | 2024-04-23 15:28:24 | auld | 1 | 13983 | 4 | 1.033 | 13536.3 |
726 | 2024-04-22 23:37:38 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
725 | 2024-04-22 23:36:43 | auld | 1 | 13983 | 4 | 0.266 | 52567.7 |
724 | 2024-04-05 23:44:27 | auld | 2 | 29872 | 180 | 4.593 | 6503.8 |
723 | 2024-04-05 17:45:12 | auld | 2 | 29872 | 180 | 0.953 | 31345.2 |
722 | 2024-04-04 23:33:29 | auld | 1 | 13983 | 4 | 0.296 | 47239.9 |
721 | 2024-04-03 06:39:11 | auld | 1 | 13983 | 4 | 0.596 | 23461.4 |
720 | 2024-03-31 14:56:35 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
719 | 2024-03-28 20:47:49 | auld | 1 | 13983 | 4 | 0.266 | 52567.7 |
718 | 2024-03-28 06:36:17 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
717 | 2024-03-18 14:11:18 | auld | 1 | 13983 | 4 | 0.563 | 24836.6 |
716 | 2024-03-16 04:53:40 | auld | 2 | 29872 | 180 | 2.453 | 12177.7 |
715 | 2024-03-06 19:06:55 | auld | 2 | 29872 | 180 | 0.856 | 34897.2 |
714 | 2024-03-05 21:06:53 | auld | 1 | 13983 | 4 | 0.233 | 60012.9 |
713 | 2024-03-03 23:34:56 | auld | 2 | 29872 | 180 | 1.796 | 16632.5 |
712 | 2024-03-03 22:12:31 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
711 | 2024-03-01 11:45:43 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
710 | 2024-02-25 18:58:53 | auld | 1 | 13983 | 4 | 0.263 | 53167.3 |
709 | 2024-02-11 14:13:36 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
708 | 2024-02-03 04:00:02 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
707 | 2024-02-02 18:40:15 | auld | 1 | 13983 | 4 | 0.266 | 52567.7 |
706 | 2024-01-28 18:29:43 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
705 | 2024-01-26 07:10:25 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
704 | 2023-12-31 05:13:24 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
703 | 2023-12-08 12:43:49 | auld | 2 | 29872 | 180 | 0.906 | 32971.3 |
702 | 2023-12-02 20:50:57 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
701 | 2023-11-29 23:22:22 | auld | 1 | 13983 | 4 | 0.233 | 60012.9 |
700 | 2023-11-29 11:24:36 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
699 | 2023-11-27 15:45:11 | auld | 2 | 29872 | 180 | 0.796 | 37527.6 |
698 | 2023-11-27 11:29:47 | auld | 2 | 29872 | 180 | 0.783 | 38150.7 |
697 | 2023-11-27 00:32:01 | auld | 2 | 29872 | 180 | 0.796 | 37527.6 |
696 | 2023-11-10 17:04:34 | auld | 1 | 13983 | 4 | 0.236 | 59250.0 |
695 | 2023-11-10 01:16:14 | auld | 1 | 13983 | 4 | 0.483 | 28950.3 |
694 | 2023-11-07 08:07:19 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
693 | 2023-10-27 11:59:42 | auld | 1 | 13983 | 4 | 0.266 | 52567.7 |
692 | 2023-10-26 10:07:37 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
691 | 2023-10-20 00:00:16 | auld | 1 | 13983 | 4 | 0.263 | 53167.3 |
690 | 2023-10-18 03:48:04 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
689 | 2023-10-11 02:37:39 | auld | 1 | 13983 | 4 | 0.266 | 52567.7 |
688 | 2023-10-03 17:46:11 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
687 | 2023-09-27 07:54:01 | auld | 2 | 29872 | 180 | 0.860 | 34734.9 |
686 | 2023-09-19 17:48:33 | auld | 1 | 13983 | 4 | 0.453 | 30867.5 |
685 | 2023-09-16 16:44:50 | auld | 2 | 29872 | 180 | 0.876 | 34100.5 |
684 | 2023-09-14 22:32:25 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
683 | 2023-09-10 16:47:42 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
682 | 2023-09-06 06:53:59 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
681 | 2023-08-27 15:55:11 | auld | 2 | 29872 | 180 | 0.936 | 31914.5 |
680 | 2023-08-23 18:11:31 | auld | 1 | 13983 | 4 | 0.263 | 53167.3 |
679 | 2023-06-29 13:46:32 | auld | 1 | 13983 | 4 | 0.236 | 59250.0 |
678 | 2023-06-26 09:48:31 | auld | 2 | 29872 | 180 | 0.780 | 38297.4 |
677 | 2023-06-14 16:24:33 | auld | 2 | 29872 | 180 | 0.763 | 39150.7 |
676 | 2023-05-31 08:28:32 | auld | 2 | 29872 | 180 | 0.750 | 39829.3 |
675 | 2023-05-23 22:27:52 | auld | 1 | 13983 | 4 | 0.500 | 27966.0 |
674 | 2023-05-15 21:44:34 | auld | 2 | 29872 | 180 | 0.783 | 38150.7 |
673 | 2023-04-28 20:35:15 | auld | 2 | 29872 | 180 | 0.783 | 38150.7 |
672 | 2023-04-07 13:06:47 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
671 | 2023-04-03 08:54:33 | auld | 2 | 29872 | 180 | 0.766 | 38997.4 |
670 | 2023-03-27 16:20:20 | auld | 2 | 29872 | 180 | 1.720 | 17367.4 |
669 | 2023-03-24 14:30:57 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
668 | 2023-02-23 17:55:22 | auld | 2 | 29872 | 180 | 0.780 | 38297.4 |
667 | 2023-02-21 06:41:07 | auld | 1 | 13983 | 4 | 0.236 | 59250.0 |
666 | 2023-02-17 20:25:29 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
665 | 2023-01-22 05:07:49 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
664 | 2022-12-04 21:35:41 | auld | 2 | 29872 | 180 | 0.763 | 39150.7 |
663 | 2022-11-19 04:51:50 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
662 | 2022-11-14 21:13:58 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
661 | 2022-09-14 02:20:22 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
660 | 2022-08-28 01:42:22 | auld | 1 | 13983 | 4 | 0.233 | 60012.9 |
659 | 2022-08-11 14:29:14 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
658 | 2022-08-06 11:45:21 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
657 | 2022-07-13 02:26:42 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
656 | 2022-07-10 19:34:49 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
655 | 2022-05-05 09:05:51 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
654 | 2022-04-19 09:34:18 | auld | 2 | 29872 | 180 | 1.000 | 29872.0 |
653 | 2022-04-15 00:42:23 | auld | 2 | 29872 | 180 | 0.936 | 31914.5 |
652 | 2022-03-11 04:06:03 | auld | 1 | 13983 | 4 | 0.266 | 52567.7 |
651 | 2022-01-31 16:25:32 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
650 | 2021-12-24 19:08:41 | auld | 2 | 29872 | 180 | 0.890 | 33564.0 |
649 | 2021-12-22 15:13:57 | auld | 2 | 29872 | 180 | 1.000 | 29872.0 |
648 | 2021-12-21 13:03:51 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
647 | 2021-11-15 18:17:39 | auld | 1 | 13983 | 4 | 0.326 | 42892.6 |
646 | 2021-11-14 17:12:27 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
645 | 2021-11-13 19:05:45 | auld | 1 | 13983 | 4 | 0.283 | 49409.9 |
644 | 2021-11-12 21:21:42 | auld | 1 | 13983 | 4 | 0.216 | 64736.1 |
643 | 2021-11-11 14:07:53 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
642 | 2021-10-31 00:54:31 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
641 | 2021-10-24 11:10:01 | auld | 1 | 13983 | 4 | 0.236 | 59250.0 |
640 | 2021-10-07 00:56:20 | auld | 2 | 29872 | 180 | 0.953 | 31345.2 |
639 | 2021-09-27 16:08:38 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
638 | 2021-09-26 22:21:43 | auld | 1 | 13983 | 4 | 0.263 | 53167.3 |
637 | 2021-09-21 20:49:26 | auld | 1 | 13983 | 4 | 0.250 | 55932.0 |
636 | 2021-09-14 14:52:27 | auld | 1 | 13983 | 4 | 0.266 | 52567.7 |
635 | 2021-09-08 17:20:38 | auld | 1 | 13983 | 4 | 0.236 | 59250.0 |
634 | 2021-08-17 03:36:03 | auld | 1 | 13983 | 4 | 0.233 | 60012.9 |
633 | 2021-08-16 02:44:13 | auld | 2 | 29872 | 180 | 0.766 | 38997.4 |
632 | 2021-08-14 23:21:55 | auld | 1 | 13983 | 4 | 0.220 | 63559.1 |
631 | 2021-08-12 18:27:57 | auld | 2 | 29872 | 180 | 0.893 | 33451.3 |