History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
813 | 2025-09-17 13:45:17 | spots | 1 | 28756 | 15 | 0.530 | 54256.6 |
812 | 2025-09-15 10:03:45 | spots | 1 | 28756 | 15 | 0.513 | 56054.6 |
811 | 2025-09-15 09:32:29 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
810 | 2025-09-12 13:36:08 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
809 | 2025-09-08 21:25:14 | spots | 2 | 53800 | 237 | 2.140 | 25140.2 |
808 | 2025-09-06 18:20:12 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
807 | 2025-09-05 01:40:18 | spots | 1 | 28756 | 15 | 0.530 | 54256.6 |
806 | 2025-09-03 18:07:30 | spots | 1 | 28756 | 15 | 0.513 | 56054.6 |
805 | 2025-09-03 16:11:29 | spots | 1 | 28756 | 15 | 0.530 | 54256.6 |
804 | 2025-09-03 10:15:47 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
803 | 2025-09-03 00:03:24 | spots | 1 | 28756 | 15 | 0.546 | 52666.7 |
802 | 2025-08-29 17:29:30 | spots | 2 | 53800 | 237 | 1.610 | 33416.1 |
801 | 2025-08-29 06:39:32 | spots | 2 | 53800 | 237 | 1.403 | 38346.4 |
800 | 2025-08-28 16:45:40 | spots | 2 | 53800 | 237 | 1.813 | 29674.6 |
799 | 2025-08-28 14:01:36 | spots | 2 | 53800 | 237 | 1.563 | 34421.0 |
798 | 2025-08-27 21:14:31 | spots | 2 | 53800 | 237 | 1.560 | 34487.2 |
797 | 2025-08-27 11:53:49 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
796 | 2025-08-27 08:58:04 | spots | 2 | 53800 | 237 | 1.703 | 31591.3 |
795 | 2025-08-27 06:43:24 | spots | 2 | 53800 | 237 | 1.643 | 32745.0 |
794 | 2025-08-27 00:36:49 | spots | 2 | 53800 | 237 | 1.436 | 37465.2 |
793 | 2025-08-25 11:11:13 | spots | 2 | 53800 | 237 | 5.393 | 9975.9 |
792 | 2025-08-25 04:48:49 | spots | 1 | 28756 | 15 | 1.906 | 15087.1 |
791 | 2025-08-24 15:01:29 | spots | 1 | 28756 | 15 | 1.063 | 27051.7 |
790 | 2025-08-17 23:42:57 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
789 | 2025-08-12 17:07:50 | spots | 1 | 28756 | 15 | 1.233 | 23322.0 |
788 | 2025-08-01 03:30:10 | spots | 1 | 28756 | 15 | 1.220 | 23570.5 |
787 | 2025-07-31 16:03:37 | spots | 1 | 28756 | 15 | 0.843 | 34111.5 |
786 | 2025-07-30 02:47:08 | spots | 1 | 28756 | 15 | 1.920 | 14977.1 |
785 | 2025-07-29 14:23:52 | spots | 1 | 28756 | 15 | 1.733 | 16593.2 |
784 | 2025-07-27 12:13:43 | spots | 1 | 28756 | 15 | 0.936 | 30722.2 |
783 | 2025-07-24 21:09:16 | spots | 1 | 28756 | 15 | 1.013 | 28387.0 |
782 | 2025-07-24 03:45:30 | spots | 2 | 53800 | 237 | 8.203 | 6558.6 |
781 | 2025-07-22 15:01:13 | spots | 1 | 28756 | 15 | 2.466 | 11661.0 |
780 | 2025-07-21 23:37:54 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
779 | 2025-07-14 11:28:52 | spots | 1 | 28756 | 15 | 1.706 | 16855.8 |
778 | 2025-07-11 16:07:22 | spots | 1 | 28756 | 15 | 3.660 | 7856.8 |
777 | 2025-07-07 22:11:58 | spots | 1 | 28756 | 15 | 2.846 | 10104.0 |
776 | 2025-07-03 11:45:52 | spots | 1 | 28756 | 15 | 2.360 | 12184.7 |
775 | 2025-07-01 09:25:40 | spots | 1 | 28756 | 15 | 0.766 | 37540.5 |
774 | 2025-06-14 10:29:47 | spots | 1 | 28756 | 15 | 1.610 | 17860.9 |
773 | 2025-06-11 21:29:37 | spots | 2 | 53800 | 237 | 6.640 | 8102.4 |
772 | 2025-06-11 14:01:49 | spots | 1 | 28756 | 15 | 0.716 | 40162.0 |
771 | 2025-06-11 04:36:27 | spots | 1 | 28756 | 15 | 1.736 | 16564.5 |
770 | 2025-06-03 15:41:47 | spots | 1 | 28756 | 15 | 2.266 | 12690.2 |
769 | 2025-06-02 11:48:38 | spots | 1 | 28756 | 15 | 2.330 | 12341.6 |
768 | 2025-06-01 14:19:56 | spots | 2 | 53800 | 237 | 7.706 | 6981.6 |
767 | 2025-06-01 14:11:26 | spots | 2 | 53800 | 237 | 1.736 | 30990.8 |
766 | 2025-06-01 09:41:59 | spots | 1 | 28756 | 15 | 4.096 | 7020.5 |
765 | 2025-05-31 14:55:00 | spots | 1 | 28756 | 15 | 3.470 | 8287.0 |
764 | 2025-05-30 20:51:44 | spots | 1 | 28756 | 15 | 1.296 | 22188.3 |
763 | 2025-05-28 11:40:12 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
762 | 2025-05-27 21:29:59 | spots | 1 | 28756 | 15 | 0.596 | 48248.3 |
761 | 2025-05-26 18:45:13 | spots | 1 | 28756 | 15 | 2.906 | 9895.4 |
760 | 2025-05-18 20:18:26 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
759 | 2025-05-12 14:20:21 | spots | 2 | 53800 | 237 | 3.986 | 13497.2 |
758 | 2025-05-11 05:03:24 | spots | 1 | 28756 | 15 | 0.513 | 56054.6 |
757 | 2025-05-08 21:53:35 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
756 | 2025-05-08 15:04:29 | spots | 1 | 28756 | 15 | 1.843 | 15602.8 |
755 | 2025-05-06 17:25:45 | spots | 2 | 53800 | 237 | 4.923 | 10928.3 |
754 | 2025-05-05 10:36:23 | spots | 2 | 53800 | 237 | 1.466 | 36698.5 |
753 | 2025-05-04 08:32:00 | spots | 1 | 28756 | 15 | 3.780 | 7607.4 |
752 | 2025-05-02 11:54:57 | spots | 1 | 28756 | 15 | 3.626 | 7930.5 |
751 | 2025-05-01 11:26:49 | spots | 1 | 28756 | 15 | 0.530 | 54256.6 |
750 | 2025-04-30 19:58:48 | spots | 1 | 28756 | 15 | 0.546 | 52666.7 |
749 | 2025-04-30 19:37:12 | spots | 1 | 28756 | 15 | 0.516 | 55728.7 |
748 | 2025-04-14 09:52:14 | spots | 1 | 28756 | 15 | 2.533 | 11352.5 |
747 | 2025-04-12 10:07:25 | spots | 2 | 53800 | 237 | 8.296 | 6485.1 |
746 | 2025-04-12 01:31:54 | spots | 2 | 53800 | 237 | 10.203 | 5273.0 |
745 | 2025-04-11 15:20:55 | spots | 2 | 53800 | 237 | 9.016 | 5967.2 |
744 | 2025-04-11 14:52:12 | spots | 2 | 53800 | 237 | 5.046 | 10661.9 |
743 | 2025-04-11 14:22:06 | spots | 1 | 28756 | 15 | 1.686 | 17055.8 |
742 | 2025-04-10 04:42:55 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
741 | 2025-04-10 04:41:02 | spots | 2 | 53800 | 237 | 1.623 | 33148.5 |
740 | 2025-04-06 15:01:48 | spots | 1 | 28756 | 15 | 2.576 | 11163.0 |
739 | 2025-04-03 05:52:01 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
738 | 2025-04-03 05:35:42 | spots | 1 | 28756 | 15 | 0.533 | 53951.2 |
737 | 2025-04-03 05:15:42 | spots | 1 | 28756 | 15 | 0.516 | 55728.7 |
736 | 2025-04-01 22:39:41 | spots | 1 | 28756 | 15 | 1.360 | 21144.1 |
735 | 2025-04-01 22:25:49 | spots | 1 | 28756 | 15 | 1.393 | 20643.2 |
734 | 2025-04-01 22:18:38 | spots | 1 | 28756 | 15 | 4.106 | 7003.4 |
733 | 2025-04-01 21:57:47 | spots | 1 | 28756 | 15 | 1.330 | 21621.1 |
732 | 2025-04-01 21:51:31 | spots | 1 | 28756 | 15 | 2.500 | 11502.4 |
731 | 2025-03-31 14:43:52 | spots | 1 | 28756 | 15 | 1.360 | 21144.1 |
730 | 2025-03-29 17:34:22 | spots | 1 | 28756 | 15 | 2.750 | 10456.7 |
729 | 2025-03-14 23:02:19 | spots | 1 | 28756 | 15 | 1.343 | 21411.8 |
728 | 2025-03-11 08:45:12 | spots | 2 | 53800 | 237 | 7.640 | 7041.9 |
727 | 2025-03-11 08:34:53 | spots | 2 | 53800 | 237 | 3.610 | 14903.0 |
726 | 2025-03-11 06:07:13 | spots | 2 | 53800 | 237 | 7.376 | 7293.9 |
725 | 2025-03-11 06:06:59 | spots | 1 | 28756 | 15 | 2.656 | 10826.8 |
724 | 2025-03-10 08:41:49 | spots | 1 | 28756 | 15 | 2.580 | 11145.7 |
723 | 2025-03-07 04:00:21 | spots | 1 | 28756 | 15 | 2.530 | 11366.0 |
722 | 2025-03-06 19:19:27 | spots | 1 | 28756 | 15 | 1.596 | 18017.5 |
721 | 2025-03-04 07:40:33 | spots | 1 | 28756 | 15 | 1.013 | 28387.0 |
720 | 2025-03-01 09:02:47 | spots | 1 | 28756 | 15 | 1.203 | 23903.6 |
719 | 2025-02-26 05:32:05 | spots | 1 | 28756 | 15 | 3.673 | 7829.0 |
718 | 2025-02-19 07:03:45 | spots | 1 | 28756 | 15 | 1.263 | 22768.0 |
717 | 2025-02-18 12:38:43 | spots | 2 | 53800 | 237 | 4.126 | 13039.3 |
716 | 2025-02-16 13:02:25 | spots | 1 | 28756 | 15 | 2.436 | 11804.6 |
715 | 2025-02-04 17:59:00 | spots | 1 | 28756 | 15 | 1.563 | 18398.0 |
714 | 2025-01-29 14:24:03 | spots | 1 | 28756 | 15 | 0.533 | 53951.2 |