History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guests"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
773 | 2024-05-03 09:20:24 | guests | 1 | 48755 | 7 | 0.906 | 53813.5 |
772 | 2024-04-24 16:10:08 | guests | 1 | 48755 | 7 | 0.923 | 52822.3 |
771 | 2024-04-20 21:21:07 | guests | 1 | 48755 | 7 | 2.783 | 17518.9 |
770 | 2024-04-03 19:43:20 | guests | 3 | 112716 | 733 | 17.186 | 6558.6 |
769 | 2024-04-03 15:19:44 | guests | 3 | 112716 | 733 | 16.706 | 6747.0 |
768 | 2024-04-03 08:39:13 | guests | 3 | 112716 | 733 | 6.000 | 18786.0 |
767 | 2024-04-03 08:39:15 | guests | 2 | 82551 | 64 | 2.703 | 30540.5 |
766 | 2024-04-03 08:39:08 | guests | 1 | 48755 | 7 | 1.906 | 25579.7 |
765 | 2024-04-03 08:38:52 | guests | 3 | 112716 | 733 | 13.140 | 8578.1 |
764 | 2024-04-03 08:38:54 | guests | 2 | 82551 | 64 | 8.623 | 9573.4 |
763 | 2024-04-03 08:38:39 | guests | 1 | 48755 | 7 | 1.966 | 24799.1 |
762 | 2024-03-31 14:53:12 | guests | 1 | 48755 | 7 | 2.826 | 17252.3 |
761 | 2024-03-20 17:37:30 | guests | 2 | 82551 | 64 | 2.126 | 38829.3 |
760 | 2024-03-14 10:54:10 | guests | 3 | 112716 | 733 | 6.563 | 17174.5 |
759 | 2024-03-12 01:38:31 | guests | 3 | 112716 | 733 | 9.343 | 12064.2 |
758 | 2024-03-11 15:48:50 | guests | 3 | 112716 | 733 | 10.486 | 10749.2 |
757 | 2024-03-01 09:41:35 | guests | 1 | 48755 | 7 | 1.953 | 24964.2 |
756 | 2024-02-14 16:55:30 | guests | 3 | 112716 | 733 | 13.266 | 8496.6 |
755 | 2024-02-13 12:59:22 | guests | 3 | 112716 | 733 | 9.080 | 12413.7 |
754 | 2024-02-12 21:30:40 | guests | 3 | 112716 | 733 | 4.656 | 24208.8 |
753 | 2024-02-03 04:57:21 | guests | 1 | 48755 | 7 | 1.813 | 26891.9 |
752 | 2024-01-24 00:21:03 | guests | 3 | 112716 | 733 | 5.610 | 20092.0 |
751 | 2024-01-23 01:15:00 | guests | 3 | 112716 | 733 | 4.686 | 24053.8 |
750 | 2024-01-22 12:11:37 | guests | 1 | 48755 | 7 | 0.940 | 51867.0 |
749 | 2024-01-13 00:54:32 | guests | 3 | 112716 | 733 | 4.500 | 25048.0 |
748 | 2024-01-08 14:51:15 | guests | 3 | 112716 | 733 | 5.606 | 20106.3 |
747 | 2023-12-16 14:52:39 | guests | 1 | 48755 | 7 | 0.733 | 66514.3 |
746 | 2023-11-29 19:40:49 | guests | 2 | 82551 | 64 | 2.376 | 34743.7 |
745 | 2023-11-22 10:22:06 | guests | 1 | 48755 | 7 | 0.830 | 58741.0 |
744 | 2023-11-20 16:39:25 | guests | 1 | 48755 | 7 | 0.750 | 65006.7 |
743 | 2023-11-17 09:14:39 | guests | 1 | 48755 | 7 | 0.830 | 58741.0 |
742 | 2023-11-16 05:24:59 | guests | 3 | 112716 | 733 | 4.643 | 24276.5 |
741 | 2023-11-04 21:40:36 | guests | 1 | 48755 | 7 | 0.810 | 60191.4 |
740 | 2023-10-31 09:39:27 | guests | 1 | 48755 | 7 | 0.826 | 59025.4 |
739 | 2023-10-27 01:10:59 | guests | 1 | 48755 | 7 | 0.843 | 57835.1 |
738 | 2023-10-14 12:27:48 | guests | 1 | 48755 | 7 | 1.593 | 30605.8 |
737 | 2023-10-09 13:19:29 | guests | 1 | 48755 | 7 | 0.796 | 61250.0 |
736 | 2023-10-03 23:34:17 | guests | 3 | 112716 | 733 | 12.123 | 9297.7 |
735 | 2023-10-01 02:30:19 | guests | 3 | 112716 | 733 | 5.000 | 22543.2 |
734 | 2023-09-24 13:05:03 | guests | 1 | 48755 | 7 | 0.796 | 61250.0 |
733 | 2023-09-13 14:38:54 | guests | 1 | 48755 | 7 | 0.860 | 56691.9 |
732 | 2023-09-04 04:52:52 | guests | 1 | 48755 | 7 | 0.826 | 59025.4 |
731 | 2023-08-28 21:56:26 | guests | 2 | 82551 | 64 | 2.356 | 35038.6 |
730 | 2023-08-23 17:16:52 | guests | 1 | 48755 | 7 | 0.733 | 66514.3 |
729 | 2023-08-16 21:15:05 | guests | 3 | 112716 | 733 | 4.606 | 24471.6 |
728 | 2023-05-13 21:43:52 | guests | 1 | 48755 | 7 | 0.796 | 61250.0 |
727 | 2023-05-11 23:33:59 | guests | 2 | 82551 | 64 | 2.080 | 39688.0 |
726 | 2023-05-10 00:14:08 | guests | 1 | 48755 | 7 | 0.736 | 66243.2 |
725 | 2023-04-30 23:02:12 | guests | 3 | 112716 | 733 | 5.110 | 22057.9 |
724 | 2023-03-25 07:11:51 | guests | 1 | 48755 | 7 | 0.720 | 67715.3 |
723 | 2023-02-14 21:16:15 | guests | 2 | 82551 | 64 | 2.453 | 33653.1 |
722 | 2023-02-14 19:48:52 | guests | 3 | 112716 | 733 | 4.483 | 25143.0 |
721 | 2023-02-14 18:33:57 | guests | 2 | 82551 | 64 | 2.173 | 37989.4 |
720 | 2023-02-08 08:55:07 | guests | 3 | 112716 | 733 | 4.560 | 24718.4 |
719 | 2023-01-24 04:31:57 | guests | 1 | 48755 | 7 | 0.703 | 69352.8 |
718 | 2023-01-18 20:03:54 | guests | 3 | 112716 | 733 | 4.576 | 24632.0 |
717 | 2023-01-16 21:15:07 | guests | 1 | 48755 | 7 | 0.720 | 67715.3 |
716 | 2022-12-31 05:05:21 | guests | 3 | 112716 | 733 | 5.203 | 21663.7 |
715 | 2022-12-30 19:52:28 | guests | 2 | 82551 | 64 | 2.126 | 38829.3 |
714 | 2022-12-27 08:33:55 | guests | 3 | 112716 | 733 | 5.140 | 21929.2 |
713 | 2022-12-26 06:54:42 | guests | 3 | 112716 | 733 | 5.376 | 20966.5 |
712 | 2022-12-22 00:30:15 | guests | 3 | 112716 | 733 | 5.250 | 21469.7 |
711 | 2022-12-16 05:35:13 | guests | 3 | 112716 | 733 | 5.313 | 21215.1 |
710 | 2022-12-13 07:40:47 | guests | 1 | 48755 | 7 | 0.810 | 60191.4 |
709 | 2022-11-24 20:32:38 | guests | 2 | 82551 | 64 | 2.076 | 39764.5 |
708 | 2022-11-20 09:44:06 | guests | 3 | 112716 | 733 | 4.516 | 24959.3 |
707 | 2022-11-19 05:01:54 | guests | 1 | 48755 | 7 | 0.813 | 59969.2 |
706 | 2022-11-06 21:11:50 | guests | 1 | 48755 | 7 | 0.720 | 67715.3 |
705 | 2022-10-06 05:43:33 | guests | 1 | 48755 | 7 | 0.830 | 58741.0 |
704 | 2022-09-04 21:49:10 | guests | 3 | 112716 | 733 | 5.330 | 21147.5 |
703 | 2022-07-15 07:52:26 | guests | 2 | 82551 | 64 | 2.280 | 36206.6 |
702 | 2022-07-13 17:52:29 | guests | 3 | 112716 | 733 | 4.593 | 24540.8 |
701 | 2022-07-13 07:26:10 | guests | 3 | 112716 | 733 | 5.170 | 21801.9 |
700 | 2022-06-29 12:47:22 | guests | 1 | 48755 | 7 | 0.813 | 59969.2 |
699 | 2022-06-26 03:31:59 | guests | 1 | 48755 | 7 | 0.720 | 67715.3 |
698 | 2022-06-25 00:24:14 | guests | 3 | 112716 | 733 | 5.093 | 22131.6 |
697 | 2022-06-19 11:05:23 | guests | 1 | 48755 | 7 | 0.813 | 59969.2 |
696 | 2022-06-13 13:53:53 | guests | 2 | 82551 | 64 | 2.233 | 36968.7 |
695 | 2022-06-09 17:01:42 | guests | 3 | 112716 | 733 | 5.486 | 20546.1 |
694 | 2022-06-06 17:19:40 | guests | 1 | 48755 | 7 | 0.716 | 68093.6 |
693 | 2022-06-02 14:34:55 | guests | 3 | 112716 | 733 | 4.580 | 24610.5 |
692 | 2022-05-07 14:06:35 | guests | 1 | 48755 | 7 | 0.733 | 66514.3 |
691 | 2022-04-24 02:06:30 | guests | 2 | 82551 | 64 | 2.123 | 38884.1 |
690 | 2022-03-03 07:35:35 | guests | 1 | 48755 | 7 | 0.810 | 60191.4 |
689 | 2022-02-28 10:06:23 | guests | 1 | 48755 | 7 | 0.830 | 58741.0 |
688 | 2022-01-05 00:55:30 | guests | 3 | 112716 | 733 | 5.970 | 18880.4 |
687 | 2021-12-29 11:53:57 | guests | 3 | 112716 | 733 | 5.500 | 20493.8 |
686 | 2021-12-29 09:31:45 | guests | 2 | 82551 | 64 | 2.470 | 33421.5 |
685 | 2021-12-15 23:13:06 | guests | 1 | 48755 | 7 | 1.673 | 29142.3 |
684 | 2021-11-27 15:38:19 | guests | 1 | 48755 | 7 | 0.856 | 56956.8 |
683 | 2021-11-22 07:47:24 | guests | 3 | 112716 | 733 | 4.750 | 23729.7 |
682 | 2021-11-19 02:30:39 | guests | 3 | 112716 | 733 | 4.546 | 24794.5 |
681 | 2021-11-16 21:00:34 | guests | 1 | 48755 | 7 | 0.780 | 62506.4 |
680 | 2021-11-13 15:27:14 | guests | 3 | 112716 | 733 | 5.003 | 22529.7 |
679 | 2021-11-10 20:51:29 | guests | 3 | 112716 | 733 | 5.736 | 19650.6 |
678 | 2021-10-30 18:44:31 | guests | 3 | 112716 | 733 | 4.470 | 25216.1 |
677 | 2021-10-25 04:37:40 | guests | 1 | 48755 | 7 | 1.220 | 39963.1 |
676 | 2021-10-21 16:46:04 | guests | 3 | 112716 | 733 | 4.546 | 24794.5 |
675 | 2021-10-20 19:13:19 | guests | 3 | 112716 | 733 | 4.813 | 23419.1 |
674 | 2021-10-13 14:51:19 | guests | 2 | 82551 | 64 | 2.076 | 39764.5 |