History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sticks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
800 | 2024-04-03 06:14:00 | sticks | 1 | 48755 | 15 | 0.953 | 51159.5 |
799 | 2024-03-06 03:26:30 | sticks | 1 | 48755 | 15 | 0.876 | 55656.4 |
798 | 2024-03-04 03:30:15 | sticks | 1 | 48755 | 15 | 2.063 | 23633.1 |
797 | 2024-02-21 03:39:25 | sticks | 1 | 48755 | 15 | 0.936 | 52088.7 |
796 | 2024-01-14 13:12:15 | sticks | 2 | 82551 | 122 | 2.530 | 32628.9 |
795 | 2024-01-03 08:24:56 | sticks | 2 | 82551 | 122 | 2.390 | 34540.2 |
794 | 2024-01-02 10:35:28 | sticks | 2 | 82551 | 122 | 2.360 | 34979.2 |
793 | 2023-12-05 12:36:39 | sticks | 1 | 48755 | 15 | 0.893 | 54596.9 |
792 | 2023-11-21 19:09:03 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
791 | 2023-11-17 03:22:05 | sticks | 1 | 48755 | 15 | 0.843 | 57835.1 |
790 | 2023-11-13 22:45:51 | sticks | 1 | 48755 | 15 | 0.826 | 59025.4 |
789 | 2023-11-13 09:29:39 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
788 | 2023-11-04 10:01:12 | sticks | 1 | 48755 | 15 | 0.846 | 57630.0 |
787 | 2023-10-22 14:12:22 | sticks | 1 | 48755 | 15 | 0.733 | 66514.3 |
786 | 2023-10-18 23:53:16 | sticks | 1 | 48755 | 15 | 0.766 | 63648.8 |
785 | 2023-10-14 02:29:55 | sticks | 1 | 48755 | 15 | 0.860 | 56691.9 |
784 | 2023-10-07 03:19:38 | sticks | 2 | 82551 | 122 | 2.140 | 38575.2 |
783 | 2023-09-29 08:57:17 | sticks | 1 | 48755 | 15 | 0.796 | 61250.0 |
782 | 2023-09-22 09:05:54 | sticks | 1 | 48755 | 15 | 0.873 | 55847.7 |
781 | 2023-09-19 14:00:48 | sticks | 1 | 48755 | 15 | 0.830 | 58741.0 |
780 | 2023-07-19 00:48:54 | sticks | 1 | 48755 | 15 | 0.763 | 63899.1 |
779 | 2023-07-18 22:59:49 | sticks | 2 | 82551 | 122 | 2.280 | 36206.6 |
778 | 2023-07-11 20:35:12 | sticks | 1 | 48755 | 15 | 0.796 | 61250.0 |
777 | 2023-04-16 15:38:49 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
776 | 2023-04-04 15:51:55 | sticks | 2 | 82551 | 122 | 2.123 | 38884.1 |
775 | 2023-03-28 07:12:30 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
774 | 2023-03-27 08:07:28 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
773 | 2023-02-06 19:13:36 | sticks | 1 | 48755 | 15 | 0.763 | 63899.1 |
772 | 2023-01-01 19:10:22 | sticks | 2 | 82551 | 122 | 2.250 | 36689.3 |
771 | 2022-12-05 10:51:27 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
770 | 2022-12-02 08:51:12 | sticks | 1 | 48755 | 15 | 0.843 | 57835.1 |
769 | 2022-09-06 13:24:05 | sticks | 2 | 82551 | 122 | 2.110 | 39123.7 |
768 | 2022-08-05 12:42:37 | sticks | 1 | 48755 | 15 | 0.893 | 54596.9 |
767 | 2022-07-31 16:06:38 | sticks | 1 | 48755 | 15 | 0.796 | 61250.0 |
766 | 2022-07-29 08:58:08 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
765 | 2022-07-29 05:02:43 | sticks | 1 | 48755 | 15 | 0.766 | 63648.8 |
764 | 2022-07-19 14:02:29 | sticks | 2 | 82551 | 122 | 2.110 | 39123.7 |
763 | 2022-07-18 00:00:22 | sticks | 1 | 48755 | 15 | 0.766 | 63648.8 |
762 | 2022-06-05 21:05:01 | sticks | 2 | 82551 | 122 | 2.186 | 37763.5 |
761 | 2022-05-05 07:20:47 | sticks | 2 | 82551 | 122 | 2.186 | 37763.5 |
760 | 2022-04-12 23:34:24 | sticks | 1 | 48755 | 15 | 0.903 | 53992.2 |
759 | 2022-04-11 21:45:17 | sticks | 1 | 48755 | 15 | 0.890 | 54780.9 |
758 | 2022-04-10 22:10:43 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
757 | 2022-03-28 04:54:39 | sticks | 1 | 48755 | 15 | 1.576 | 30935.9 |
756 | 2022-03-19 14:44:54 | sticks | 1 | 48755 | 15 | 0.843 | 57835.1 |
755 | 2022-03-17 12:04:05 | sticks | 1 | 48755 | 15 | 0.766 | 63648.8 |
754 | 2022-02-12 17:06:05 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
753 | 2022-02-11 10:51:11 | sticks | 1 | 48755 | 15 | 0.940 | 51867.0 |
752 | 2022-01-28 11:54:31 | sticks | 1 | 48755 | 15 | 0.766 | 63648.8 |
751 | 2022-01-27 06:59:34 | sticks | 1 | 48755 | 15 | 0.813 | 59969.2 |
750 | 2022-01-26 10:34:19 | sticks | 1 | 48755 | 15 | 0.890 | 54780.9 |
749 | 2022-01-25 11:35:56 | sticks | 1 | 48755 | 15 | 0.766 | 63648.8 |
748 | 2022-01-24 12:56:37 | sticks | 1 | 48755 | 15 | 1.186 | 41108.8 |
747 | 2022-01-12 00:29:19 | sticks | 2 | 82551 | 122 | 2.563 | 32208.7 |
746 | 2021-12-19 06:43:34 | sticks | 1 | 48755 | 15 | 0.783 | 62266.9 |
745 | 2021-12-11 18:12:43 | sticks | 1 | 48755 | 15 | 1.013 | 48129.3 |
744 | 2021-12-11 10:12:13 | sticks | 1 | 48755 | 15 | 0.780 | 62506.4 |
743 | 2021-12-11 01:43:23 | sticks | 1 | 48755 | 15 | 0.860 | 56691.9 |
742 | 2021-12-10 15:35:41 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
741 | 2021-12-10 08:19:26 | sticks | 2 | 82551 | 122 | 4.406 | 18736.0 |
740 | 2021-12-10 07:20:06 | sticks | 1 | 48755 | 15 | 0.780 | 62506.4 |
739 | 2021-12-09 17:23:23 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
738 | 2021-12-09 02:13:59 | sticks | 1 | 48755 | 15 | 0.813 | 59969.2 |
737 | 2021-12-08 15:54:41 | sticks | 1 | 48755 | 15 | 0.876 | 55656.4 |
736 | 2021-12-08 06:10:18 | sticks | 1 | 48755 | 15 | 0.766 | 63648.8 |
735 | 2021-12-07 11:11:51 | sticks | 1 | 48755 | 15 | 0.876 | 55656.4 |
734 | 2021-12-05 00:38:40 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
733 | 2021-12-04 14:59:55 | sticks | 1 | 48755 | 15 | 0.750 | 65006.7 |
732 | 2021-12-03 20:55:56 | sticks | 1 | 48755 | 15 | 0.810 | 60191.4 |
731 | 2021-12-03 11:29:10 | sticks | 1 | 48755 | 15 | 0.826 | 59025.4 |
730 | 2021-12-03 01:56:47 | sticks | 1 | 48755 | 15 | 0.923 | 52822.3 |
729 | 2021-12-02 16:33:42 | sticks | 1 | 48755 | 15 | 0.890 | 54780.9 |
728 | 2021-11-26 20:17:15 | sticks | 2 | 82551 | 122 | 2.530 | 32628.9 |
727 | 2021-11-26 07:24:14 | sticks | 2 | 82551 | 122 | 2.656 | 31080.9 |
726 | 2021-11-25 16:18:31 | sticks | 2 | 82551 | 122 | 2.216 | 37252.3 |
725 | 2021-11-25 04:36:04 | sticks | 2 | 82551 | 122 | 2.283 | 36159.0 |
724 | 2021-11-24 12:36:22 | sticks | 2 | 82551 | 122 | 2.376 | 34743.7 |
723 | 2021-11-24 03:17:50 | sticks | 2 | 82551 | 122 | 2.436 | 33887.9 |
722 | 2021-11-23 09:16:16 | sticks | 2 | 82551 | 122 | 4.876 | 16930.1 |
721 | 2021-11-22 21:33:04 | sticks | 2 | 82551 | 122 | 2.216 | 37252.3 |
720 | 2021-11-22 07:05:57 | sticks | 2 | 82551 | 122 | 2.436 | 33887.9 |
719 | 2021-11-21 18:59:24 | sticks | 2 | 82551 | 122 | 2.593 | 31836.1 |
718 | 2021-11-21 02:04:46 | sticks | 2 | 82551 | 122 | 2.546 | 32423.8 |
717 | 2021-11-15 23:03:51 | sticks | 2 | 82551 | 122 | 2.330 | 35429.6 |
716 | 2021-11-15 14:44:38 | sticks | 2 | 82551 | 122 | 2.373 | 34787.6 |
715 | 2021-11-14 23:12:59 | sticks | 2 | 82551 | 122 | 2.530 | 32628.9 |
714 | 2021-11-14 14:09:32 | sticks | 2 | 82551 | 122 | 2.126 | 38829.3 |
713 | 2021-11-13 22:49:55 | sticks | 2 | 82551 | 122 | 2.173 | 37989.4 |
712 | 2021-11-13 12:50:28 | sticks | 2 | 82551 | 122 | 3.546 | 23280.0 |
711 | 2021-11-12 22:49:03 | sticks | 2 | 82551 | 122 | 2.203 | 37472.1 |
710 | 2021-11-12 12:43:57 | sticks | 2 | 82551 | 122 | 2.233 | 36968.7 |
709 | 2021-11-11 20:00:33 | sticks | 2 | 82551 | 122 | 2.296 | 35954.3 |
708 | 2021-11-11 09:14:48 | sticks | 2 | 82551 | 122 | 2.690 | 30688.1 |
707 | 2021-11-07 11:59:11 | sticks | 2 | 82551 | 122 | 2.470 | 33421.5 |
706 | 2021-11-07 01:06:23 | sticks | 2 | 82551 | 122 | 2.466 | 33475.7 |
705 | 2021-11-06 12:47:01 | sticks | 2 | 82551 | 122 | 2.453 | 33653.1 |
704 | 2021-11-06 01:03:21 | sticks | 2 | 82551 | 122 | 2.373 | 34787.6 |
703 | 2021-11-05 13:39:33 | sticks | 2 | 82551 | 122 | 2.313 | 35690.0 |
702 | 2021-11-05 06:55:23 | sticks | 2 | 82551 | 122 | 2.533 | 32590.2 |
701 | 2021-11-04 18:47:06 | sticks | 2 | 82551 | 122 | 2.516 | 32810.4 |