History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pooh"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
810 | 2024-04-18 16:33:30 | pooh | 2 | 29872 | 222 | 2.076 | 14389.2 |
809 | 2024-04-18 16:32:48 | pooh | 2 | 29872 | 222 | 1.750 | 17069.7 |
808 | 2024-04-12 08:24:04 | pooh | 1 | 13983 | 14 | 0.516 | 27098.8 |
807 | 2024-04-12 08:20:14 | pooh | 1 | 13983 | 14 | 0.560 | 24969.6 |
806 | 2024-04-10 12:00:30 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
805 | 2024-04-04 23:10:05 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
804 | 2024-03-30 23:31:34 | pooh | 2 | 29872 | 222 | 1.470 | 20321.1 |
803 | 2024-03-30 23:21:28 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
802 | 2024-03-05 19:48:13 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
801 | 2024-02-25 16:56:29 | pooh | 1 | 13983 | 14 | 0.280 | 49939.3 |
800 | 2024-01-26 03:23:13 | pooh | 1 | 13983 | 14 | 0.266 | 52567.7 |
799 | 2024-01-19 01:34:55 | pooh | 2 | 29872 | 222 | 0.966 | 30923.4 |
798 | 2023-12-31 17:52:28 | pooh | 2 | 29872 | 222 | 0.893 | 33451.3 |
797 | 2023-12-23 20:59:45 | pooh | 1 | 13983 | 14 | 0.236 | 59250.0 |
796 | 2023-12-01 23:48:26 | pooh | 2 | 29872 | 222 | 0.873 | 34217.6 |
795 | 2023-11-29 23:57:12 | pooh | 2 | 29872 | 222 | 0.733 | 40753.1 |
794 | 2023-11-24 17:06:36 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
793 | 2023-11-23 23:37:40 | pooh | 1 | 13983 | 14 | 0.233 | 60012.9 |
792 | 2023-11-20 16:33:44 | pooh | 1 | 13983 | 14 | 0.216 | 64736.1 |
791 | 2023-11-13 17:56:32 | pooh | 2 | 29872 | 222 | 0.830 | 35990.4 |
790 | 2023-11-10 14:48:19 | pooh | 1 | 13983 | 14 | 0.513 | 27257.3 |
789 | 2023-11-09 23:00:45 | pooh | 1 | 13983 | 14 | 0.203 | 68881.8 |
788 | 2023-10-29 04:34:07 | pooh | 2 | 29872 | 222 | 0.766 | 38997.4 |
787 | 2023-10-28 20:56:54 | pooh | 2 | 29872 | 222 | 0.940 | 31778.7 |
786 | 2023-10-26 18:51:41 | pooh | 1 | 13983 | 14 | 0.263 | 53167.3 |
785 | 2023-10-19 21:01:35 | pooh | 1 | 13983 | 14 | 0.263 | 53167.3 |
784 | 2023-10-17 07:09:57 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
783 | 2023-10-12 10:41:51 | pooh | 1 | 13983 | 14 | 0.216 | 64736.1 |
782 | 2023-10-11 16:34:30 | pooh | 1 | 13983 | 14 | 0.233 | 60012.9 |
781 | 2023-10-03 23:14:50 | pooh | 1 | 13983 | 14 | 0.283 | 49409.9 |
780 | 2023-09-24 06:59:37 | pooh | 1 | 13983 | 14 | 0.233 | 60012.9 |
779 | 2023-08-07 20:44:22 | pooh | 1 | 13983 | 14 | 0.220 | 63559.1 |
778 | 2023-08-05 22:22:08 | pooh | 2 | 29872 | 222 | 0.763 | 39150.7 |
777 | 2023-07-23 15:56:46 | pooh | 1 | 13983 | 14 | 0.266 | 52567.7 |
776 | 2023-07-23 15:35:56 | pooh | 1 | 13983 | 14 | 0.216 | 64736.1 |
775 | 2023-05-05 16:32:02 | pooh | 1 | 13983 | 14 | 0.420 | 33292.9 |
774 | 2023-04-13 16:08:42 | pooh | 2 | 29872 | 222 | 0.736 | 40587.0 |
773 | 2023-04-04 12:44:58 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
772 | 2023-03-01 12:58:04 | pooh | 1 | 13983 | 14 | 0.236 | 59250.0 |
771 | 2023-01-18 09:31:50 | pooh | 2 | 29872 | 222 | 0.843 | 35435.3 |
770 | 2022-12-25 17:14:30 | pooh | 1 | 13983 | 14 | 0.216 | 64736.1 |
769 | 2022-12-09 14:58:34 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
768 | 2022-10-28 12:45:04 | pooh | 2 | 29872 | 222 | 0.736 | 40587.0 |
767 | 2022-09-13 09:28:54 | pooh | 1 | 13983 | 14 | 0.220 | 63559.1 |
766 | 2022-08-25 18:39:49 | pooh | 1 | 13983 | 14 | 0.233 | 60012.9 |
765 | 2022-08-09 09:32:57 | pooh | 1 | 13983 | 14 | 0.203 | 68881.8 |
764 | 2022-07-18 06:44:21 | pooh | 1 | 13983 | 14 | 0.233 | 60012.9 |
763 | 2022-07-10 09:26:29 | pooh | 1 | 13983 | 14 | 0.220 | 63559.1 |
762 | 2022-06-25 14:32:11 | pooh | 1 | 13983 | 14 | 0.236 | 59250.0 |
761 | 2022-06-09 23:16:18 | pooh | 1 | 13983 | 14 | 0.216 | 64736.1 |
760 | 2022-06-01 18:45:04 | pooh | 1 | 13983 | 14 | 0.236 | 59250.0 |
759 | 2022-05-26 19:03:05 | pooh | 2 | 29872 | 222 | 0.753 | 39670.7 |
758 | 2022-04-18 01:02:39 | pooh | 1 | 13983 | 14 | 0.233 | 60012.9 |
757 | 2022-04-08 05:41:29 | pooh | 1 | 13983 | 14 | 0.216 | 64736.1 |
756 | 2022-01-13 18:09:31 | pooh | 1 | 13983 | 14 | 0.266 | 52567.7 |
755 | 2022-01-11 14:36:18 | pooh | 1 | 13983 | 14 | 0.250 | 55932.0 |
754 | 2022-01-02 20:38:40 | pooh | 2 | 29872 | 222 | 0.920 | 32469.6 |
753 | 2021-12-24 04:37:08 | pooh | 1 | 13983 | 14 | 0.263 | 53167.3 |
752 | 2021-12-06 06:32:31 | pooh | 2 | 29872 | 222 | 0.923 | 32364.0 |
751 | 2021-12-05 00:06:26 | pooh | 2 | 29872 | 222 | 0.873 | 34217.6 |
750 | 2021-12-04 14:34:32 | pooh | 2 | 29872 | 222 | 0.766 | 38997.4 |
749 | 2021-12-04 04:20:40 | pooh | 2 | 29872 | 222 | 1.000 | 29872.0 |
748 | 2021-12-03 10:40:06 | pooh | 2 | 29872 | 222 | 0.860 | 34734.9 |
747 | 2021-12-02 23:52:44 | pooh | 2 | 29872 | 222 | 0.813 | 36742.9 |
746 | 2021-12-02 14:19:49 | pooh | 2 | 29872 | 222 | 0.846 | 35309.7 |
745 | 2021-12-02 11:40:46 | pooh | 2 | 29872 | 222 | 1.733 | 17237.2 |
744 | 2021-12-01 12:50:33 | pooh | 2 | 29872 | 222 | 0.860 | 34734.9 |
743 | 2021-12-01 06:04:34 | pooh | 2 | 29872 | 222 | 0.876 | 34100.5 |
742 | 2021-11-30 22:53:33 | pooh | 2 | 29872 | 222 | 0.906 | 32971.3 |
741 | 2021-11-30 11:05:47 | pooh | 2 | 29872 | 222 | 0.953 | 31345.2 |
740 | 2021-11-29 19:32:57 | pooh | 2 | 29872 | 222 | 0.893 | 33451.3 |
739 | 2021-11-29 08:28:06 | pooh | 2 | 29872 | 222 | 0.783 | 38150.7 |
738 | 2021-11-28 23:15:40 | pooh | 2 | 29872 | 222 | 0.906 | 32971.3 |
737 | 2021-11-28 21:16:49 | pooh | 2 | 29872 | 222 | 0.906 | 32971.3 |
736 | 2021-11-28 08:20:29 | pooh | 2 | 29872 | 222 | 1.796 | 16632.5 |
735 | 2021-11-27 12:46:23 | pooh | 2 | 29872 | 222 | 0.810 | 36879.0 |
734 | 2021-11-26 23:59:28 | pooh | 2 | 29872 | 222 | 0.796 | 37527.6 |
733 | 2021-11-26 12:17:09 | pooh | 2 | 29872 | 222 | 0.826 | 36164.6 |
732 | 2021-11-25 20:38:31 | pooh | 2 | 29872 | 222 | 1.013 | 29488.6 |
731 | 2021-11-25 07:39:16 | pooh | 2 | 29872 | 222 | 0.843 | 35435.3 |
730 | 2021-11-22 01:45:45 | pooh | 2 | 29872 | 222 | 0.780 | 38297.4 |
729 | 2021-11-21 02:45:24 | pooh | 2 | 29872 | 222 | 0.903 | 33080.8 |
728 | 2021-11-18 11:07:10 | pooh | 2 | 29872 | 222 | 1.156 | 25840.8 |
727 | 2021-11-18 03:45:13 | pooh | 2 | 29872 | 222 | 0.920 | 32469.6 |
726 | 2021-11-17 13:57:02 | pooh | 2 | 29872 | 222 | 0.860 | 34734.9 |
725 | 2021-11-15 18:05:48 | pooh | 2 | 29872 | 222 | 0.796 | 37527.6 |
724 | 2021-11-15 03:34:03 | pooh | 2 | 29872 | 222 | 0.766 | 38997.4 |
723 | 2021-11-14 17:41:44 | pooh | 2 | 29872 | 222 | 0.783 | 38150.7 |
722 | 2021-11-14 02:30:46 | pooh | 2 | 29872 | 222 | 0.793 | 37669.6 |
721 | 2021-11-13 14:28:50 | pooh | 2 | 29872 | 222 | 0.893 | 33451.3 |
720 | 2021-11-12 23:10:59 | pooh | 2 | 29872 | 222 | 0.873 | 34217.6 |
719 | 2021-11-12 09:06:10 | pooh | 2 | 29872 | 222 | 0.940 | 31778.7 |
718 | 2021-11-11 12:07:12 | pooh | 2 | 29872 | 222 | 0.860 | 34734.9 |
717 | 2021-11-11 01:10:12 | pooh | 2 | 29872 | 222 | 0.906 | 32971.3 |
716 | 2021-11-10 19:06:12 | pooh | 2 | 29872 | 222 | 0.750 | 39829.3 |
715 | 2021-11-10 05:39:25 | pooh | 2 | 29872 | 222 | 0.750 | 39829.3 |
714 | 2021-11-09 19:20:20 | pooh | 2 | 29872 | 222 | 0.953 | 31345.2 |
713 | 2021-11-09 07:41:02 | pooh | 2 | 29872 | 222 | 0.750 | 39829.3 |
712 | 2021-11-08 08:16:23 | pooh | 2 | 29872 | 222 | 1.106 | 27009.0 |
711 | 2021-11-07 15:17:39 | pooh | 2 | 29872 | 222 | 0.856 | 34897.2 |