History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spear"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
808 | 2025-08-28 12:52:53 | spear | 1 | 28756 | 12 | 0.563 | 51076.4 |
807 | 2025-08-27 22:06:49 | spear | 1 | 28756 | 12 | 0.500 | 57512.0 |
806 | 2025-08-24 05:40:19 | spear | 1 | 28756 | 12 | 1.030 | 27918.4 |
805 | 2025-08-19 05:54:22 | spear | 1 | 28756 | 12 | 0.983 | 29253.3 |
804 | 2025-08-12 05:22:22 | spear | 1 | 28756 | 12 | 1.220 | 23570.5 |
803 | 2025-08-07 22:33:54 | spear | 1 | 28756 | 12 | 3.423 | 8400.8 |
802 | 2025-08-04 02:30:42 | spear | 1 | 28756 | 12 | 1.173 | 24514.9 |
801 | 2025-08-01 20:09:07 | spear | 1 | 28756 | 12 | 1.250 | 23004.8 |
800 | 2025-07-31 13:04:14 | spear | 1 | 28756 | 12 | 2.140 | 13437.4 |
799 | 2025-07-31 03:32:02 | spear | 1 | 28756 | 12 | 0.530 | 54256.6 |
798 | 2025-07-28 14:02:42 | spear | 1 | 28756 | 12 | 0.986 | 29164.3 |
797 | 2025-07-27 10:22:25 | spear | 2 | 53800 | 140 | 3.470 | 15504.3 |
796 | 2025-07-27 03:47:47 | spear | 2 | 53800 | 140 | 6.190 | 8691.4 |
795 | 2025-07-27 01:08:56 | spear | 1 | 28756 | 12 | 0.890 | 32310.1 |
794 | 2025-07-25 23:35:30 | spear | 2 | 53800 | 140 | 2.373 | 22671.7 |
793 | 2025-07-22 11:13:20 | spear | 1 | 28756 | 12 | 2.110 | 13628.4 |
792 | 2025-07-21 14:45:34 | spear | 2 | 53800 | 140 | 2.593 | 20748.2 |
791 | 2025-07-21 07:42:31 | spear | 1 | 28756 | 12 | 0.546 | 52666.7 |
790 | 2025-07-18 08:06:40 | spear | 1 | 28756 | 12 | 2.000 | 14378.0 |
789 | 2025-07-10 07:18:08 | spear | 1 | 28756 | 12 | 2.216 | 12976.5 |
788 | 2025-07-02 19:32:25 | spear | 2 | 53800 | 140 | 11.953 | 4501.0 |
787 | 2025-07-02 18:54:02 | spear | 1 | 28756 | 12 | 2.453 | 11722.8 |
786 | 2025-07-01 08:28:24 | spear | 1 | 28756 | 12 | 0.486 | 59168.7 |
785 | 2025-07-01 03:04:40 | spear | 1 | 28756 | 12 | 0.533 | 53951.2 |
784 | 2025-06-20 09:51:08 | spear | 1 | 28756 | 12 | 3.516 | 8178.6 |
783 | 2025-06-18 06:00:17 | spear | 1 | 28756 | 12 | 4.186 | 6869.6 |
782 | 2025-06-10 04:41:51 | spear | 1 | 28756 | 12 | 3.546 | 8109.4 |
781 | 2025-06-02 17:33:15 | spear | 1 | 28756 | 12 | 2.233 | 12877.7 |
780 | 2025-06-01 19:51:04 | spear | 1 | 28756 | 12 | 0.500 | 57512.0 |
779 | 2025-05-31 09:39:54 | spear | 1 | 28756 | 12 | 1.046 | 27491.4 |
778 | 2025-05-31 01:42:24 | spear | 1 | 28756 | 12 | 2.373 | 12118.0 |
777 | 2025-05-30 08:45:38 | spear | 2 | 53800 | 140 | 9.720 | 5535.0 |
776 | 2025-05-25 03:20:54 | spear | 1 | 28756 | 12 | 2.063 | 13938.9 |
775 | 2025-05-20 07:04:26 | spear | 1 | 28756 | 12 | 1.606 | 17905.4 |
774 | 2025-05-19 14:18:50 | spear | 1 | 28756 | 12 | 0.546 | 52666.7 |
773 | 2025-05-16 05:41:03 | spear | 1 | 28756 | 12 | 4.296 | 6693.7 |
772 | 2025-05-12 07:34:22 | spear | 2 | 53800 | 140 | 7.203 | 7469.1 |
771 | 2025-05-10 05:06:26 | spear | 1 | 28756 | 12 | 1.173 | 24514.9 |
770 | 2025-05-08 22:10:30 | spear | 1 | 28756 | 12 | 0.516 | 55728.7 |
769 | 2025-05-08 08:02:27 | spear | 2 | 53800 | 140 | 7.783 | 6912.5 |
768 | 2025-05-07 18:40:15 | spear | 2 | 53800 | 140 | 1.610 | 33416.1 |
767 | 2025-05-04 10:11:01 | spear | 2 | 53800 | 140 | 7.860 | 6844.8 |
766 | 2025-05-03 08:43:42 | spear | 1 | 28756 | 12 | 0.500 | 57512.0 |
765 | 2025-05-02 17:27:11 | spear | 1 | 28756 | 12 | 0.546 | 52666.7 |
764 | 2025-04-30 02:47:03 | spear | 1 | 28756 | 12 | 2.296 | 12524.4 |
763 | 2025-04-30 01:12:43 | spear | 1 | 28756 | 12 | 0.970 | 29645.4 |
762 | 2025-04-20 05:49:41 | spear | 1 | 28756 | 12 | 1.593 | 18051.5 |
761 | 2025-04-16 05:14:08 | spear | 1 | 28756 | 12 | 1.390 | 20687.8 |
760 | 2025-04-02 10:24:37 | spear | 2 | 53800 | 140 | 7.390 | 7280.1 |
759 | 2025-04-01 19:13:30 | spear | 1 | 28756 | 12 | 0.530 | 54256.6 |
758 | 2025-03-31 03:37:59 | spear | 2 | 53800 | 140 | 7.873 | 6833.5 |
757 | 2025-03-29 04:44:23 | spear | 1 | 28756 | 12 | 3.703 | 7765.6 |
756 | 2025-03-20 07:34:29 | spear | 1 | 28756 | 12 | 2.796 | 10284.7 |
755 | 2025-03-15 17:22:54 | spear | 2 | 53800 | 140 | 7.656 | 7027.2 |
754 | 2025-03-15 11:31:38 | spear | 2 | 53800 | 140 | 4.296 | 12523.3 |
753 | 2025-03-15 11:30:11 | spear | 1 | 28756 | 12 | 0.953 | 30174.2 |
752 | 2025-03-09 06:48:31 | spear | 1 | 28756 | 12 | 2.703 | 10638.5 |
751 | 2025-02-27 08:03:47 | spear | 2 | 53800 | 140 | 10.000 | 5380.0 |
750 | 2025-02-27 07:14:29 | spear | 1 | 28756 | 12 | 0.516 | 55728.7 |
749 | 2025-02-26 07:16:49 | spear | 2 | 53800 | 140 | 10.220 | 5264.2 |
748 | 2025-02-26 05:48:30 | spear | 1 | 28756 | 12 | 5.216 | 5513.0 |
747 | 2025-02-24 19:27:14 | spear | 1 | 28756 | 12 | 1.626 | 17685.1 |
746 | 2025-01-27 20:34:35 | spear | 2 | 53800 | 140 | 13.016 | 4133.4 |
745 | 2025-01-27 20:18:21 | spear | 1 | 28756 | 12 | 0.533 | 53951.2 |
744 | 2025-01-26 18:37:36 | spear | 1 | 28756 | 12 | 3.436 | 8369.0 |
743 | 2025-01-24 17:25:04 | spear | 1 | 28756 | 12 | 2.483 | 11581.2 |
742 | 2025-01-11 23:01:04 | spear | 1 | 28756 | 12 | 2.373 | 12118.0 |
741 | 2025-01-07 20:24:50 | spear | 1 | 28756 | 12 | 2.750 | 10456.7 |
740 | 2025-01-07 20:17:19 | spear | 2 | 53800 | 140 | 7.453 | 7218.6 |
739 | 2025-01-04 23:31:20 | spear | 1 | 28756 | 12 | 1.796 | 16011.1 |
738 | 2025-01-03 23:18:50 | spear | 1 | 28756 | 12 | 0.513 | 56054.6 |
737 | 2024-12-29 02:57:50 | spear | 2 | 53800 | 140 | 10.860 | 4954.0 |
736 | 2024-12-28 18:20:09 | spear | 2 | 53800 | 140 | 1.686 | 31909.8 |
735 | 2024-12-28 18:19:54 | spear | 1 | 28756 | 12 | 0.593 | 48492.4 |
734 | 2024-12-27 14:01:31 | spear | 1 | 28756 | 12 | 0.533 | 53951.2 |
733 | 2024-12-25 15:08:00 | spear | 1 | 28756 | 12 | 2.360 | 12184.7 |
732 | 2024-12-12 21:52:11 | spear | 1 | 28756 | 12 | 2.123 | 13545.0 |
731 | 2024-12-08 00:19:00 | spear | 1 | 28756 | 12 | 2.703 | 10638.5 |
730 | 2024-11-29 02:19:03 | spear | 2 | 53800 | 140 | 4.983 | 10796.7 |
729 | 2024-11-28 21:28:11 | spear | 2 | 53800 | 140 | 7.390 | 7280.1 |
728 | 2024-11-28 16:22:43 | spear | 2 | 53800 | 140 | 10.266 | 5240.6 |
727 | 2024-11-28 16:19:20 | spear | 1 | 28756 | 12 | 0.500 | 57512.0 |
726 | 2024-11-27 12:41:25 | spear | 1 | 28756 | 12 | 0.470 | 61183.0 |
725 | 2024-11-07 14:19:20 | spear | 2 | 53800 | 140 | 1.533 | 35094.6 |
724 | 2024-11-07 14:19:20 | spear | 1 | 28756 | 12 | 0.500 | 57512.0 |
723 | 2024-10-29 21:55:12 | spear | 2 | 53800 | 140 | 7.610 | 7069.6 |
722 | 2024-10-29 21:24:43 | spear | 2 | 53800 | 140 | 5.343 | 10069.2 |
721 | 2024-10-29 15:32:58 | spear | 2 | 53800 | 140 | 9.626 | 5589.0 |
720 | 2024-10-29 15:25:18 | spear | 1 | 28756 | 12 | 0.533 | 53951.2 |
719 | 2024-10-28 05:25:04 | spear | 1 | 28756 | 12 | 2.326 | 12362.9 |
718 | 2024-10-25 13:13:14 | spear | 1 | 28756 | 12 | 2.453 | 11722.8 |
717 | 2024-10-09 19:51:25 | spear | 1 | 28756 | 12 | 1.360 | 21144.1 |
716 | 2024-10-08 06:56:28 | spear | 2 | 53800 | 140 | 18.893 | 2847.6 |
715 | 2024-10-08 06:56:15 | spear | 1 | 28756 | 12 | 1.796 | 16011.1 |
714 | 2024-09-29 11:40:47 | spear | 2 | 53800 | 140 | 13.030 | 4128.9 |
713 | 2024-09-29 11:39:54 | spear | 1 | 28756 | 12 | 5.033 | 5713.5 |
712 | 2024-09-28 06:51:15 | spear | 2 | 53800 | 140 | 11.110 | 4842.5 |
711 | 2024-09-28 05:09:33 | spear | 1 | 28756 | 12 | 0.500 | 57512.0 |
710 | 2024-09-28 00:18:47 | spear | 1 | 28756 | 12 | 0.453 | 63479.0 |
709 | 2024-09-25 11:34:31 | spear | 1 | 28756 | 12 | 5.706 | 5039.6 |