History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"readings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
814 | 2025-08-28 11:53:03 | readings | 1 | 82945 | 6 | 1.560 | 53169.9 |
813 | 2025-08-27 08:19:18 | readings | 1 | 82945 | 6 | 1.513 | 54821.5 |
812 | 2025-08-24 13:05:01 | readings | 1 | 82945 | 6 | 7.406 | 11199.7 |
811 | 2025-08-22 06:43:52 | readings | 1 | 82945 | 6 | 1.483 | 55930.5 |
810 | 2025-08-14 19:30:16 | readings | 1 | 82945 | 6 | 1.326 | 62552.8 |
809 | 2025-08-12 15:54:09 | readings | 1 | 82945 | 6 | 5.433 | 15266.9 |
808 | 2025-08-11 11:50:45 | readings | 1 | 82945 | 6 | 4.140 | 20035.0 |
807 | 2025-08-10 03:57:06 | readings | 1 | 82945 | 6 | 3.796 | 21850.6 |
806 | 2025-08-09 07:49:06 | readings | 3 | 146162 | 548 | 27.893 | 5240.1 |
805 | 2025-08-09 03:55:55 | readings | 3 | 146162 | 548 | 44.626 | 3275.3 |
804 | 2025-08-08 21:27:16 | readings | 3 | 146162 | 548 | 7.686 | 19016.7 |
803 | 2025-08-08 06:18:21 | readings | 3 | 146162 | 548 | 7.610 | 19206.6 |
802 | 2025-08-07 14:37:42 | readings | 3 | 146162 | 548 | 18.610 | 7853.9 |
801 | 2025-08-07 09:39:11 | readings | 3 | 146162 | 548 | 28.923 | 5053.5 |
800 | 2025-08-07 03:18:57 | readings | 3 | 146162 | 548 | 21.520 | 6791.9 |
799 | 2025-08-05 00:26:16 | readings | 3 | 146162 | 548 | 17.690 | 8262.4 |
798 | 2025-08-04 14:13:26 | readings | 1 | 82945 | 6 | 5.233 | 15850.4 |
797 | 2025-08-01 15:27:36 | readings | 1 | 82945 | 6 | 3.733 | 22219.4 |
796 | 2025-08-01 12:45:13 | readings | 1 | 82945 | 6 | 6.610 | 12548.4 |
795 | 2025-07-25 07:49:55 | readings | 1 | 82945 | 6 | 6.890 | 12038.5 |
794 | 2025-07-24 18:01:20 | readings | 1 | 82945 | 6 | 4.000 | 20736.3 |
793 | 2025-07-23 03:47:38 | readings | 1 | 82945 | 6 | 7.623 | 10880.9 |
792 | 2025-07-22 18:17:30 | readings | 1 | 82945 | 6 | 4.516 | 18366.9 |
791 | 2025-07-21 07:25:46 | readings | 1 | 82945 | 6 | 1.406 | 58993.6 |
790 | 2025-07-16 05:16:28 | readings | 1 | 82945 | 6 | 7.170 | 11568.3 |
789 | 2025-07-03 05:08:08 | readings | 1 | 82945 | 6 | 9.220 | 8996.2 |
788 | 2025-06-25 16:07:12 | readings | 1 | 82945 | 6 | 1.563 | 53067.8 |
787 | 2025-06-21 03:27:18 | readings | 2 | 121059 | 63 | 10.923 | 11082.9 |
786 | 2025-06-20 09:08:17 | readings | 1 | 82945 | 6 | 4.250 | 19516.5 |
785 | 2025-06-17 11:54:36 | readings | 1 | 82945 | 6 | 1.420 | 58412.0 |
784 | 2025-06-12 19:40:53 | readings | 1 | 82945 | 6 | 3.766 | 22024.7 |
783 | 2025-06-10 13:24:03 | readings | 1 | 82945 | 6 | 9.013 | 9202.8 |
782 | 2025-06-07 13:12:14 | readings | 1 | 82945 | 6 | 4.030 | 20581.9 |
781 | 2025-06-06 01:34:00 | readings | 1 | 82945 | 6 | 9.013 | 9202.8 |
780 | 2025-06-04 13:19:15 | readings | 1 | 82945 | 6 | 8.203 | 10111.5 |
779 | 2025-06-03 13:33:32 | readings | 1 | 82945 | 6 | 1.546 | 53651.4 |
778 | 2025-06-03 04:12:56 | readings | 1 | 82945 | 6 | 1.483 | 55930.5 |
777 | 2025-06-02 02:29:04 | readings | 2 | 121059 | 63 | 30.890 | 3919.0 |
776 | 2025-06-01 09:24:49 | readings | 2 | 121059 | 63 | 12.220 | 9906.6 |
775 | 2025-05-29 12:30:25 | readings | 1 | 82945 | 6 | 3.766 | 22024.7 |
774 | 2025-05-28 18:31:31 | readings | 2 | 121059 | 63 | 5.406 | 22393.5 |
773 | 2025-05-20 11:40:38 | readings | 1 | 82945 | 6 | 3.513 | 23610.9 |
772 | 2025-05-19 11:20:06 | readings | 1 | 82945 | 6 | 2.970 | 27927.6 |
771 | 2025-05-18 08:18:04 | readings | 1 | 82945 | 6 | 6.970 | 11900.3 |
770 | 2025-05-14 01:14:44 | readings | 3 | 146162 | 548 | 27.676 | 5281.2 |
769 | 2025-05-13 04:59:36 | readings | 1 | 82945 | 6 | 1.533 | 54106.3 |
768 | 2025-05-12 03:39:17 | readings | 3 | 146162 | 548 | 36.610 | 3992.4 |
767 | 2025-05-11 20:52:08 | readings | 3 | 146162 | 548 | 22.716 | 6434.3 |
766 | 2025-05-10 17:06:17 | readings | 1 | 82945 | 6 | 4.623 | 17941.8 |
765 | 2025-05-10 07:14:00 | readings | 3 | 146162 | 548 | 31.656 | 4617.2 |
764 | 2025-05-07 11:11:20 | readings | 1 | 82945 | 6 | 3.940 | 21052.0 |
763 | 2025-05-05 12:36:11 | readings | 3 | 146162 | 548 | 39.860 | 3666.9 |
762 | 2025-05-05 04:01:34 | readings | 2 | 121059 | 63 | 19.296 | 6273.8 |
761 | 2025-05-04 13:11:06 | readings | 1 | 82945 | 6 | 7.580 | 10942.6 |
760 | 2025-05-03 04:42:54 | readings | 1 | 82945 | 6 | 7.106 | 11672.5 |
759 | 2025-04-23 15:00:04 | readings | 1 | 82945 | 6 | 1.580 | 52496.8 |
758 | 2025-04-20 18:19:49 | readings | 1 | 82945 | 6 | 1.516 | 54713.1 |
757 | 2025-04-18 15:19:01 | readings | 2 | 121059 | 63 | 12.080 | 10021.4 |
756 | 2025-04-18 11:29:27 | readings | 1 | 82945 | 6 | 3.360 | 24686.0 |
755 | 2025-04-18 01:33:04 | readings | 2 | 121059 | 63 | 11.530 | 10499.5 |
754 | 2025-04-17 23:51:13 | readings | 3 | 146162 | 548 | 19.860 | 7359.6 |
753 | 2025-04-16 17:48:41 | readings | 1 | 82945 | 6 | 1.513 | 54821.5 |
752 | 2025-04-16 02:46:36 | readings | 2 | 121059 | 63 | 9.593 | 12619.5 |
751 | 2025-04-11 03:57:34 | readings | 3 | 146162 | 548 | 28.330 | 5159.3 |
750 | 2025-04-10 00:47:40 | readings | 3 | 146162 | 548 | 36.013 | 4058.6 |
749 | 2025-04-09 08:20:26 | readings | 3 | 146162 | 548 | 40.613 | 3598.9 |
748 | 2025-04-07 06:33:28 | readings | 3 | 146162 | 548 | 33.560 | 4355.2 |
747 | 2025-04-04 13:00:08 | readings | 1 | 82945 | 6 | 4.203 | 19734.7 |
746 | 2025-04-04 12:31:41 | readings | 3 | 146162 | 548 | 42.176 | 3465.5 |
745 | 2025-04-03 03:54:36 | readings | 1 | 82945 | 6 | 1.466 | 56579.1 |
744 | 2025-03-23 16:02:45 | readings | 1 | 82945 | 6 | 7.250 | 11440.7 |
743 | 2025-03-17 15:49:20 | readings | 1 | 82945 | 6 | 3.890 | 21322.6 |
742 | 2025-03-17 03:57:27 | readings | 1 | 82945 | 6 | 3.953 | 20982.8 |
741 | 2025-03-15 02:07:58 | readings | 1 | 82945 | 6 | 10.986 | 7550.1 |
740 | 2025-03-14 07:53:45 | readings | 1 | 82945 | 6 | 4.686 | 17700.6 |
739 | 2025-03-10 12:02:36 | readings | 1 | 82945 | 6 | 3.653 | 22706.0 |
738 | 2025-03-09 08:05:18 | readings | 3 | 146162 | 548 | 28.110 | 5199.6 |
737 | 2025-03-03 20:43:56 | readings | 1 | 82945 | 6 | 6.263 | 13243.7 |
736 | 2025-03-01 23:43:22 | readings | 3 | 146162 | 548 | 40.220 | 3634.1 |
735 | 2025-03-01 12:32:57 | readings | 3 | 146162 | 548 | 38.973 | 3750.3 |
734 | 2025-02-28 21:09:04 | readings | 3 | 146162 | 548 | 50.156 | 2914.1 |
733 | 2025-02-27 22:11:59 | readings | 3 | 146162 | 548 | 50.956 | 2868.4 |
732 | 2025-02-27 13:52:45 | readings | 3 | 146162 | 548 | 45.660 | 3201.1 |
731 | 2025-02-27 10:07:15 | readings | 3 | 146162 | 548 | 7.173 | 20376.7 |
730 | 2025-02-21 19:51:02 | readings | 2 | 121059 | 63 | 20.123 | 6016.0 |
729 | 2025-02-21 19:49:51 | readings | 1 | 82945 | 6 | 4.670 | 17761.2 |
728 | 2025-02-20 23:27:09 | readings | 1 | 82945 | 6 | 6.326 | 13111.8 |
727 | 2025-02-09 00:23:51 | readings | 1 | 82945 | 6 | 7.533 | 11010.9 |
726 | 2025-02-06 09:18:51 | readings | 1 | 82945 | 6 | 5.686 | 14587.6 |
725 | 2025-02-04 14:46:33 | readings | 1 | 82945 | 6 | 3.076 | 26965.2 |
724 | 2025-02-01 10:06:33 | readings | 1 | 82945 | 6 | 7.686 | 10791.7 |
723 | 2025-01-24 17:15:35 | readings | 3 | 146162 | 548 | 39.583 | 3692.5 |
722 | 2025-01-24 05:12:19 | readings | 3 | 146162 | 548 | 39.860 | 3666.9 |
721 | 2025-01-22 22:30:24 | readings | 3 | 146162 | 548 | 38.500 | 3796.4 |
720 | 2025-01-22 18:26:06 | readings | 3 | 146162 | 548 | 39.160 | 3732.4 |
719 | 2025-01-22 03:33:49 | readings | 3 | 146162 | 548 | 51.050 | 2863.1 |
718 | 2025-01-18 13:02:48 | readings | 1 | 82945 | 6 | 6.983 | 11878.1 |
717 | 2025-01-18 03:33:39 | readings | 1 | 82945 | 6 | 3.640 | 22787.1 |
716 | 2025-01-15 08:15:10 | readings | 1 | 82945 | 6 | 6.046 | 13719.0 |
715 | 2025-01-11 05:49:01 | readings | 1 | 82945 | 6 | 3.450 | 24042.0 |