History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roads"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
847 | 2025-08-28 13:48:35 | roads | 2 | 53800 | 225 | 1.830 | 29398.9 |
846 | 2025-08-17 13:13:02 | roads | 1 | 28756 | 14 | 1.406 | 20452.3 |
845 | 2025-08-12 11:06:07 | roads | 1 | 28756 | 14 | 1.093 | 26309.2 |
844 | 2025-08-11 06:42:37 | roads | 1 | 28756 | 14 | 3.203 | 8977.8 |
843 | 2025-08-06 01:54:08 | roads | 2 | 53800 | 225 | 7.173 | 7500.3 |
842 | 2025-08-05 12:56:48 | roads | 2 | 53800 | 225 | 4.500 | 11955.6 |
841 | 2025-08-02 08:49:27 | roads | 2 | 53800 | 225 | 4.423 | 12163.7 |
840 | 2025-08-01 14:25:39 | roads | 1 | 28756 | 14 | 1.000 | 28756.0 |
839 | 2025-08-01 04:56:53 | roads | 1 | 28756 | 14 | 1.046 | 27491.4 |
838 | 2025-07-31 06:12:21 | roads | 1 | 28756 | 14 | 0.516 | 55728.7 |
837 | 2025-07-27 03:21:07 | roads | 2 | 53800 | 225 | 4.406 | 12210.6 |
836 | 2025-07-24 13:51:32 | roads | 2 | 53800 | 225 | 9.376 | 5738.1 |
835 | 2025-07-22 02:53:53 | roads | 1 | 28756 | 14 | 0.470 | 61183.0 |
834 | 2025-07-18 10:04:30 | roads | 1 | 28756 | 14 | 1.016 | 28303.1 |
833 | 2025-07-17 16:14:35 | roads | 1 | 28756 | 14 | 2.266 | 12690.2 |
832 | 2025-07-11 11:01:51 | roads | 1 | 28756 | 14 | 2.953 | 9737.9 |
831 | 2025-07-04 11:35:30 | roads | 2 | 53800 | 225 | 4.033 | 13339.9 |
830 | 2025-07-02 12:16:36 | roads | 1 | 28756 | 14 | 3.736 | 7697.0 |
829 | 2025-07-01 22:09:02 | roads | 1 | 28756 | 14 | 1.406 | 20452.3 |
828 | 2025-06-28 05:31:28 | roads | 1 | 28756 | 14 | 2.360 | 12184.7 |
827 | 2025-06-11 19:42:11 | roads | 1 | 28756 | 14 | 0.466 | 61708.2 |
826 | 2025-05-31 15:04:23 | roads | 1 | 28756 | 14 | 2.470 | 11642.1 |
825 | 2025-05-30 22:24:10 | roads | 1 | 28756 | 14 | 2.516 | 11429.3 |
824 | 2025-05-29 09:36:29 | roads | 1 | 28756 | 14 | 2.873 | 10009.0 |
823 | 2025-05-29 05:02:22 | roads | 1 | 28756 | 14 | 2.296 | 12524.4 |
822 | 2025-05-13 20:57:48 | roads | 2 | 53800 | 225 | 8.610 | 6248.5 |
821 | 2025-05-12 11:41:29 | roads | 1 | 28756 | 14 | 1.390 | 20687.8 |
820 | 2025-05-11 18:16:28 | roads | 1 | 28756 | 14 | 0.470 | 61183.0 |
819 | 2025-05-10 13:28:28 | roads | 2 | 53800 | 225 | 4.390 | 12255.1 |
818 | 2025-05-09 10:23:07 | roads | 1 | 28756 | 14 | 0.546 | 52666.7 |
817 | 2025-05-08 13:18:52 | roads | 1 | 28756 | 14 | 3.330 | 8635.4 |
816 | 2025-05-08 13:03:31 | roads | 2 | 53800 | 225 | 4.703 | 11439.5 |
815 | 2025-05-06 07:21:21 | roads | 2 | 53800 | 225 | 4.280 | 12570.1 |
814 | 2025-05-01 11:18:37 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
813 | 2025-04-29 21:32:59 | roads | 1 | 28756 | 14 | 2.140 | 13437.4 |
812 | 2025-04-29 11:18:45 | roads | 1 | 28756 | 14 | 0.906 | 31739.5 |
811 | 2025-04-27 11:30:48 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
810 | 2025-04-27 11:25:27 | roads | 1 | 28756 | 14 | 0.563 | 51076.4 |
809 | 2025-04-26 05:28:04 | roads | 1 | 28756 | 14 | 2.890 | 9950.2 |
808 | 2025-04-14 07:16:49 | roads | 1 | 28756 | 14 | 2.546 | 11294.6 |
807 | 2025-04-09 10:34:38 | roads | 2 | 53800 | 225 | 4.466 | 12046.6 |
806 | 2025-04-08 10:12:20 | roads | 1 | 28756 | 14 | 2.376 | 12102.7 |
805 | 2025-04-06 12:38:56 | roads | 1 | 28756 | 14 | 2.716 | 10587.6 |
804 | 2025-03-31 13:55:45 | roads | 1 | 28756 | 14 | 2.530 | 11366.0 |
803 | 2025-03-28 21:30:40 | roads | 1 | 28756 | 14 | 3.466 | 8296.6 |
802 | 2025-03-27 06:15:42 | roads | 1 | 28756 | 14 | 1.673 | 17188.3 |
801 | 2025-03-21 22:12:17 | roads | 1 | 28756 | 14 | 2.516 | 11429.3 |
800 | 2025-03-19 07:32:11 | roads | 1 | 28756 | 14 | 0.483 | 59536.2 |
799 | 2025-03-14 22:58:16 | roads | 1 | 28756 | 14 | 3.406 | 8442.7 |
798 | 2025-03-13 03:52:14 | roads | 1 | 28756 | 14 | 3.580 | 8032.4 |
797 | 2025-03-08 03:18:10 | roads | 2 | 53800 | 225 | 12.720 | 4229.6 |
796 | 2025-03-07 15:03:24 | roads | 2 | 53800 | 225 | 8.343 | 6448.5 |
795 | 2025-03-07 15:03:26 | roads | 1 | 28756 | 14 | 2.420 | 11882.6 |
794 | 2025-03-05 20:17:30 | roads | 1 | 28756 | 14 | 1.876 | 15328.4 |
793 | 2025-02-28 11:48:02 | roads | 2 | 53800 | 225 | 5.110 | 10528.4 |
792 | 2025-02-28 10:39:14 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
791 | 2025-02-25 18:07:41 | roads | 2 | 53800 | 225 | 10.170 | 5290.1 |
790 | 2025-02-25 08:15:37 | roads | 2 | 53800 | 225 | 8.280 | 6497.6 |
789 | 2025-02-25 08:03:54 | roads | 1 | 28756 | 14 | 1.610 | 17860.9 |
788 | 2025-02-24 22:25:18 | roads | 1 | 28756 | 14 | 1.500 | 19170.7 |
787 | 2025-02-06 03:04:13 | roads | 1 | 28756 | 14 | 0.576 | 49923.6 |
786 | 2025-01-28 10:30:03 | roads | 2 | 53800 | 225 | 2.186 | 24611.2 |
785 | 2025-01-28 10:29:54 | roads | 1 | 28756 | 14 | 1.030 | 27918.4 |
784 | 2025-01-26 01:02:59 | roads | 2 | 53800 | 225 | 9.530 | 5645.3 |
783 | 2025-01-26 00:34:46 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
782 | 2025-01-25 09:23:39 | roads | 1 | 28756 | 14 | 2.576 | 11163.0 |
781 | 2025-01-06 12:09:08 | roads | 1 | 28756 | 14 | 2.576 | 11163.0 |
780 | 2024-12-30 08:01:55 | roads | 2 | 53800 | 225 | 3.750 | 14346.7 |
779 | 2024-12-29 10:08:59 | roads | 2 | 53800 | 225 | 11.766 | 4572.5 |
778 | 2024-12-29 09:49:35 | roads | 1 | 28756 | 14 | 0.486 | 59168.7 |
777 | 2024-12-27 02:08:03 | roads | 2 | 53800 | 225 | 1.813 | 29674.6 |
776 | 2024-12-26 23:14:47 | roads | 2 | 53800 | 225 | 3.983 | 13507.4 |
775 | 2024-12-26 23:06:57 | roads | 1 | 28756 | 14 | 0.953 | 30174.2 |
774 | 2024-12-17 22:57:00 | roads | 1 | 28756 | 14 | 2.263 | 12707.0 |
773 | 2024-12-07 09:36:17 | roads | 2 | 53800 | 225 | 3.970 | 13551.6 |
772 | 2024-12-07 09:36:11 | roads | 1 | 28756 | 14 | 0.953 | 30174.2 |
771 | 2024-12-01 04:06:47 | roads | 1 | 28756 | 14 | 3.783 | 7601.4 |
770 | 2024-11-29 06:18:41 | roads | 2 | 53800 | 225 | 9.390 | 5729.5 |
769 | 2024-11-29 06:15:09 | roads | 1 | 28756 | 14 | 3.076 | 9348.5 |
768 | 2024-11-26 21:53:21 | roads | 2 | 53800 | 225 | 8.173 | 6582.7 |
767 | 2024-11-26 21:41:43 | roads | 1 | 28756 | 14 | 3.360 | 8558.3 |
766 | 2024-11-26 08:53:03 | roads | 1 | 28756 | 14 | 2.626 | 10950.5 |
765 | 2024-11-08 00:38:22 | roads | 2 | 53800 | 225 | 7.890 | 6818.8 |
764 | 2024-11-07 02:37:22 | roads | 2 | 53800 | 225 | 5.783 | 9303.1 |
763 | 2024-11-07 02:37:16 | roads | 1 | 28756 | 14 | 1.373 | 20943.9 |
762 | 2024-10-30 04:20:45 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
761 | 2024-10-27 21:31:21 | roads | 1 | 28756 | 14 | 1.096 | 26237.2 |
760 | 2024-10-27 06:14:18 | roads | 1 | 28756 | 14 | 1.890 | 15214.8 |
759 | 2024-10-23 17:43:04 | roads | 1 | 28756 | 14 | 2.486 | 11567.2 |
758 | 2024-10-07 20:51:43 | roads | 1 | 28756 | 14 | 2.016 | 14263.9 |
757 | 2024-09-30 00:42:58 | roads | 2 | 53800 | 225 | 5.343 | 10069.2 |
756 | 2024-09-30 00:01:26 | roads | 2 | 53800 | 225 | 1.703 | 31591.3 |
755 | 2024-09-30 00:01:07 | roads | 1 | 28756 | 14 | 0.483 | 59536.2 |
754 | 2024-09-27 16:46:23 | roads | 1 | 28756 | 14 | 1.266 | 22714.1 |
753 | 2024-09-27 01:42:04 | roads | 1 | 28756 | 14 | 6.043 | 4758.6 |
752 | 2024-09-25 02:21:27 | roads | 1 | 28756 | 14 | 2.923 | 9837.8 |
751 | 2024-09-22 19:06:21 | roads | 1 | 28756 | 14 | 3.940 | 7298.5 |
750 | 2024-08-30 21:50:26 | roads | 2 | 53800 | 225 | 11.406 | 4716.8 |
749 | 2024-08-30 21:21:03 | roads | 1 | 28756 | 14 | 0.513 | 56054.6 |
748 | 2024-08-29 18:09:05 | roads | 1 | 28756 | 14 | 1.280 | 22465.6 |