History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tartans"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
801 | 2024-04-26 23:13:51 | tartans | 1 | 69583 | 8 | 2.843 | 24475.2 |
800 | 2024-03-28 11:22:00 | tartans | 1 | 69583 | 8 | 1.216 | 57222.9 |
799 | 2024-03-01 22:33:51 | tartans | 3 | 134027 | 547 | 15.796 | 8484.9 |
798 | 2024-02-18 14:42:01 | tartans | 1 | 69583 | 8 | 1.280 | 54361.7 |
797 | 2024-02-14 07:50:03 | tartans | 1 | 69583 | 8 | 2.826 | 24622.4 |
796 | 2024-02-14 07:50:00 | tartans | 1 | 69583 | 8 | 1.406 | 49490.0 |
795 | 2024-02-06 03:36:11 | tartans | 3 | 134027 | 547 | 8.983 | 14920.1 |
794 | 2024-02-04 22:38:33 | tartans | 3 | 134027 | 547 | 13.986 | 9582.9 |
793 | 2024-02-04 13:21:50 | tartans | 3 | 134027 | 547 | 11.546 | 11608.1 |
792 | 2024-02-04 08:05:09 | tartans | 2 | 107671 | 45 | 9.000 | 11963.4 |
791 | 2024-02-04 07:19:54 | tartans | 3 | 134027 | 547 | 8.423 | 15912.0 |
790 | 2024-02-03 18:39:14 | tartans | 3 | 134027 | 547 | 6.326 | 21186.7 |
789 | 2024-02-01 23:57:57 | tartans | 3 | 134027 | 547 | 6.516 | 20568.9 |
788 | 2024-02-01 05:24:42 | tartans | 3 | 134027 | 547 | 6.360 | 21073.4 |
787 | 2024-01-29 19:14:10 | tartans | 2 | 107671 | 45 | 3.296 | 32667.2 |
786 | 2024-01-26 15:17:37 | tartans | 3 | 134027 | 547 | 7.266 | 18445.8 |
785 | 2024-01-26 15:10:45 | tartans | 3 | 134027 | 547 | 9.596 | 13967.0 |
784 | 2024-01-11 00:07:31 | tartans | 3 | 134027 | 547 | 6.343 | 21129.9 |
783 | 2024-01-08 19:48:20 | tartans | 3 | 134027 | 547 | 7.690 | 17428.7 |
782 | 2024-01-01 21:34:51 | tartans | 3 | 134027 | 547 | 6.563 | 20421.6 |
781 | 2023-12-31 21:34:26 | tartans | 3 | 134027 | 547 | 7.516 | 17832.2 |
780 | 2023-12-28 09:11:10 | tartans | 3 | 134027 | 547 | 6.093 | 21996.9 |
779 | 2023-12-23 02:34:45 | tartans | 3 | 134027 | 547 | 6.923 | 19359.7 |
778 | 2023-12-22 23:12:42 | tartans | 3 | 134027 | 547 | 6.143 | 21817.8 |
777 | 2023-12-21 23:03:30 | tartans | 3 | 134027 | 547 | 9.470 | 14152.8 |
776 | 2023-12-20 05:54:24 | tartans | 1 | 69583 | 8 | 1.216 | 57222.9 |
775 | 2023-12-19 21:01:12 | tartans | 3 | 134027 | 547 | 6.673 | 20085.0 |
774 | 2023-12-18 20:55:31 | tartans | 3 | 134027 | 547 | 6.906 | 19407.3 |
773 | 2023-12-10 22:05:36 | tartans | 3 | 134027 | 547 | 6.110 | 21935.7 |
772 | 2023-12-09 21:58:33 | tartans | 3 | 134027 | 547 | 6.533 | 20515.4 |
771 | 2023-12-08 20:55:30 | tartans | 3 | 134027 | 547 | 6.813 | 19672.2 |
770 | 2023-12-07 20:55:26 | tartans | 3 | 134027 | 547 | 9.030 | 14842.4 |
769 | 2023-12-07 17:39:22 | tartans | 1 | 69583 | 8 | 1.236 | 56296.9 |
768 | 2023-12-07 17:39:20 | tartans | 1 | 69583 | 8 | 1.233 | 56433.9 |
767 | 2023-12-06 20:52:51 | tartans | 3 | 134027 | 547 | 6.970 | 19229.1 |
766 | 2023-12-05 20:54:54 | tartans | 3 | 134027 | 547 | 6.923 | 19359.7 |
765 | 2023-12-05 02:09:32 | tartans | 1 | 69583 | 8 | 1.203 | 57841.2 |
764 | 2023-12-04 20:47:19 | tartans | 3 | 134027 | 547 | 6.953 | 19276.1 |
763 | 2023-12-03 20:47:44 | tartans | 3 | 134027 | 547 | 6.423 | 20866.7 |
762 | 2023-12-02 20:45:14 | tartans | 3 | 134027 | 547 | 12.126 | 11052.9 |
761 | 2023-12-02 16:03:49 | tartans | 1 | 69583 | 8 | 1.220 | 57035.2 |
760 | 2023-12-01 20:43:12 | tartans | 3 | 134027 | 547 | 6.453 | 20769.7 |
759 | 2023-11-30 21:26:18 | tartans | 1 | 69583 | 8 | 1.250 | 55666.4 |
758 | 2023-11-30 20:46:52 | tartans | 3 | 134027 | 547 | 6.750 | 19855.9 |
757 | 2023-11-29 20:39:26 | tartans | 3 | 134027 | 547 | 6.296 | 21287.6 |
756 | 2023-11-28 20:41:26 | tartans | 3 | 134027 | 547 | 6.966 | 19240.2 |
755 | 2023-11-27 20:24:17 | tartans | 3 | 134027 | 547 | 7.470 | 17942.0 |
754 | 2023-11-26 21:41:55 | tartans | 3 | 134027 | 547 | 6.706 | 19986.1 |
753 | 2023-11-25 21:37:43 | tartans | 3 | 134027 | 547 | 6.486 | 20664.0 |
752 | 2023-11-25 10:06:28 | tartans | 2 | 107671 | 45 | 3.440 | 31299.7 |
751 | 2023-11-24 19:47:32 | tartans | 3 | 134027 | 547 | 6.690 | 20033.9 |
750 | 2023-11-23 19:44:25 | tartans | 3 | 134027 | 547 | 6.063 | 22105.7 |
749 | 2023-11-22 20:45:17 | tartans | 3 | 134027 | 547 | 5.953 | 22514.2 |
748 | 2023-11-22 06:09:21 | tartans | 3 | 134027 | 547 | 6.813 | 19672.2 |
747 | 2023-11-21 20:42:34 | tartans | 3 | 134027 | 547 | 7.546 | 17761.3 |
746 | 2023-11-21 06:29:05 | tartans | 3 | 134027 | 547 | 6.516 | 20568.9 |
745 | 2023-11-20 20:41:57 | tartans | 3 | 134027 | 547 | 6.736 | 19897.1 |
744 | 2023-11-20 13:01:23 | tartans | 2 | 107671 | 45 | 3.110 | 34620.9 |
743 | 2023-11-19 23:10:16 | tartans | 3 | 134027 | 547 | 5.953 | 22514.2 |
742 | 2023-11-19 20:50:05 | tartans | 3 | 134027 | 547 | 7.376 | 18170.7 |
741 | 2023-11-19 20:40:04 | tartans | 3 | 134027 | 547 | 6.420 | 20876.5 |
740 | 2023-11-19 00:35:12 | tartans | 3 | 134027 | 547 | 5.953 | 22514.2 |
739 | 2023-11-18 20:39:17 | tartans | 3 | 134027 | 547 | 6.140 | 21828.5 |
738 | 2023-11-17 20:19:05 | tartans | 3 | 134027 | 547 | 11.033 | 12147.8 |
737 | 2023-11-17 19:00:06 | tartans | 3 | 134027 | 547 | 6.906 | 19407.3 |
736 | 2023-11-16 23:04:01 | tartans | 3 | 134027 | 547 | 6.873 | 19500.5 |
735 | 2023-11-16 20:24:40 | tartans | 3 | 134027 | 547 | 13.206 | 10148.9 |
734 | 2023-11-15 20:31:57 | tartans | 3 | 134027 | 547 | 6.046 | 22167.9 |
733 | 2023-11-15 20:09:39 | tartans | 3 | 134027 | 547 | 8.623 | 15543.0 |
732 | 2023-11-14 13:26:17 | tartans | 3 | 134027 | 547 | 6.046 | 22167.9 |
731 | 2023-11-13 10:22:45 | tartans | 2 | 107671 | 45 | 3.096 | 34777.5 |
730 | 2023-11-13 06:37:33 | tartans | 1 | 69583 | 8 | 1.076 | 64668.2 |
729 | 2023-11-12 18:55:35 | tartans | 3 | 134027 | 547 | 6.923 | 19359.7 |
728 | 2023-11-11 18:53:53 | tartans | 3 | 134027 | 547 | 6.296 | 21287.6 |
727 | 2023-11-10 18:51:54 | tartans | 3 | 134027 | 547 | 6.936 | 19323.4 |
726 | 2023-11-10 16:58:12 | tartans | 3 | 134027 | 547 | 7.610 | 17612.0 |
725 | 2023-11-09 18:51:16 | tartans | 3 | 134027 | 547 | 7.733 | 17331.8 |
724 | 2023-11-08 18:50:18 | tartans | 3 | 134027 | 547 | 6.750 | 19855.9 |
723 | 2023-11-08 06:18:29 | tartans | 2 | 107671 | 45 | 2.843 | 37872.3 |
722 | 2023-11-07 20:18:19 | tartans | 3 | 134027 | 547 | 6.780 | 19768.0 |
721 | 2023-11-06 20:34:11 | tartans | 3 | 134027 | 547 | 8.326 | 16097.4 |
720 | 2023-11-03 16:37:02 | tartans | 1 | 69583 | 8 | 1.220 | 57035.2 |
719 | 2023-11-01 02:15:50 | tartans | 2 | 107671 | 45 | 3.376 | 31893.1 |
718 | 2023-10-31 09:50:57 | tartans | 1 | 69583 | 8 | 1.170 | 59472.6 |
717 | 2023-10-27 09:07:31 | tartans | 3 | 134027 | 547 | 7.690 | 17428.7 |
716 | 2023-10-25 19:41:11 | tartans | 3 | 134027 | 547 | 8.016 | 16719.9 |
715 | 2023-10-25 00:24:58 | tartans | 3 | 134027 | 547 | 6.060 | 22116.7 |
714 | 2023-10-24 18:35:00 | tartans | 3 | 134027 | 547 | 7.610 | 17612.0 |
713 | 2023-10-24 09:25:15 | tartans | 3 | 134027 | 547 | 6.280 | 21341.9 |
712 | 2023-10-23 05:02:58 | tartans | 3 | 134027 | 547 | 6.653 | 20145.3 |
711 | 2023-10-22 04:35:09 | tartans | 3 | 134027 | 547 | 6.580 | 20368.8 |
710 | 2023-10-21 21:00:26 | tartans | 3 | 134027 | 547 | 7.250 | 18486.5 |
709 | 2023-10-21 03:17:07 | tartans | 3 | 134027 | 547 | 7.200 | 18614.9 |
708 | 2023-10-20 20:48:46 | tartans | 3 | 134027 | 547 | 7.860 | 17051.8 |
707 | 2023-10-20 08:20:27 | tartans | 3 | 134027 | 547 | 6.936 | 19323.4 |
706 | 2023-10-19 04:51:51 | tartans | 3 | 134027 | 547 | 6.546 | 20474.6 |
705 | 2023-10-18 15:33:16 | tartans | 3 | 134027 | 547 | 6.140 | 21828.5 |
704 | 2023-10-17 15:00:25 | tartans | 3 | 134027 | 547 | 6.953 | 19276.1 |
703 | 2023-10-15 12:47:07 | tartans | 3 | 134027 | 547 | 8.593 | 15597.2 |
702 | 2023-10-04 10:18:49 | tartans | 3 | 134027 | 547 | 7.483 | 17910.9 |