History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sumach"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
786 | 2024-04-27 06:45:50 | sumach | 1 | 48755 | 4 | 3.283 | 14850.7 |
785 | 2024-04-07 11:00:59 | sumach | 1 | 48755 | 4 | 2.313 | 21078.7 |
784 | 2024-03-31 01:23:48 | sumach | 2 | 82551 | 14 | 10.546 | 7827.7 |
783 | 2024-03-30 19:37:58 | sumach | 3 | 112716 | 243 | 11.123 | 10133.6 |
782 | 2024-03-30 14:52:28 | sumach | 1 | 48755 | 4 | 1.516 | 32160.3 |
781 | 2024-03-30 13:32:25 | sumach | 2 | 82551 | 14 | 2.690 | 30688.1 |
780 | 2024-03-30 13:32:13 | sumach | 3 | 112716 | 243 | 5.686 | 19823.4 |
779 | 2024-03-29 09:13:19 | sumach | 1 | 48755 | 4 | 0.983 | 49598.2 |
778 | 2024-03-28 19:04:12 | sumach | 2 | 82551 | 14 | 6.360 | 12979.7 |
777 | 2024-03-28 08:05:31 | sumach | 2 | 82551 | 14 | 3.533 | 23365.7 |
776 | 2024-03-28 08:05:31 | sumach | 1 | 48755 | 4 | 0.923 | 52822.3 |
775 | 2024-03-28 08:05:18 | sumach | 3 | 112716 | 243 | 5.513 | 20445.5 |
774 | 2024-03-28 05:27:45 | sumach | 3 | 112716 | 243 | 5.576 | 20214.5 |
773 | 2024-02-28 05:04:21 | sumach | 1 | 48755 | 4 | 1.953 | 24964.2 |
772 | 2024-02-28 04:54:11 | sumach | 1 | 48755 | 4 | 2.110 | 23106.6 |
771 | 2024-02-03 23:11:39 | sumach | 2 | 82551 | 14 | 2.250 | 36689.3 |
770 | 2024-02-03 23:11:35 | sumach | 3 | 112716 | 243 | 5.000 | 22543.2 |
769 | 2024-02-03 23:11:31 | sumach | 1 | 48755 | 4 | 0.763 | 63899.1 |
768 | 2024-01-14 07:15:27 | sumach | 3 | 112716 | 243 | 5.156 | 21861.1 |
767 | 2024-01-05 17:16:54 | sumach | 1 | 48755 | 4 | 0.890 | 54780.9 |
766 | 2024-01-05 16:18:04 | sumach | 3 | 112716 | 243 | 4.906 | 22975.1 |
765 | 2023-12-21 06:45:11 | sumach | 1 | 48755 | 4 | 0.750 | 65006.7 |
764 | 2023-12-18 22:53:37 | sumach | 2 | 82551 | 14 | 2.563 | 32208.7 |
763 | 2023-12-15 09:13:48 | sumach | 2 | 82551 | 14 | 2.690 | 30688.1 |
762 | 2023-12-12 05:14:59 | sumach | 2 | 82551 | 14 | 2.500 | 33020.4 |
761 | 2023-11-18 12:40:24 | sumach | 3 | 112716 | 243 | 6.486 | 17378.4 |
760 | 2023-11-17 04:39:16 | sumach | 1 | 48755 | 4 | 0.750 | 65006.7 |
759 | 2023-11-12 10:47:41 | sumach | 1 | 48755 | 4 | 0.750 | 65006.7 |
758 | 2023-11-11 15:19:33 | sumach | 2 | 82551 | 14 | 4.690 | 17601.5 |
757 | 2023-10-30 06:07:58 | sumach | 1 | 48755 | 4 | 0.876 | 55656.4 |
756 | 2023-10-28 14:36:10 | sumach | 3 | 112716 | 243 | 6.360 | 17722.6 |
755 | 2023-10-24 20:23:49 | sumach | 3 | 112716 | 243 | 5.470 | 20606.2 |
754 | 2023-10-24 20:23:38 | sumach | 3 | 112716 | 243 | 10.186 | 11065.8 |
753 | 2023-10-23 08:52:05 | sumach | 3 | 112716 | 243 | 6.050 | 18630.7 |
752 | 2023-10-22 10:13:18 | sumach | 3 | 112716 | 243 | 12.766 | 8829.4 |
751 | 2023-10-21 10:08:14 | sumach | 1 | 48755 | 4 | 0.750 | 65006.7 |
750 | 2023-10-20 08:33:59 | sumach | 3 | 112716 | 243 | 5.876 | 19182.4 |
749 | 2023-10-18 21:52:12 | sumach | 1 | 48755 | 4 | 0.860 | 56691.9 |
748 | 2023-10-18 17:12:33 | sumach | 3 | 112716 | 243 | 5.280 | 21347.7 |
747 | 2023-10-14 07:45:43 | sumach | 1 | 48755 | 4 | 0.826 | 59025.4 |
746 | 2023-10-11 09:30:16 | sumach | 3 | 112716 | 243 | 5.593 | 20153.0 |
745 | 2023-10-07 11:24:32 | sumach | 2 | 82551 | 14 | 2.156 | 38289.0 |
744 | 2023-10-07 11:22:45 | sumach | 1 | 48755 | 4 | 0.890 | 54780.9 |
743 | 2023-10-03 11:58:47 | sumach | 3 | 112716 | 243 | 5.670 | 19879.4 |
742 | 2023-10-01 18:57:59 | sumach | 3 | 112716 | 243 | 4.936 | 22835.5 |
741 | 2023-10-01 18:57:51 | sumach | 2 | 82551 | 14 | 2.140 | 38575.2 |
740 | 2023-09-29 08:18:52 | sumach | 1 | 48755 | 4 | 0.890 | 54780.9 |
739 | 2023-09-27 15:51:42 | sumach | 3 | 112716 | 243 | 5.830 | 19333.8 |
738 | 2023-09-27 15:51:43 | sumach | 2 | 82551 | 14 | 2.640 | 31269.3 |
737 | 2023-09-15 19:03:05 | sumach | 1 | 48755 | 4 | 0.860 | 56691.9 |
736 | 2023-08-23 05:10:07 | sumach | 1 | 48755 | 4 | 0.780 | 62506.4 |
735 | 2023-07-22 20:12:39 | sumach | 3 | 112716 | 243 | 4.970 | 22679.3 |
734 | 2023-05-27 02:07:59 | sumach | 1 | 48755 | 4 | 0.766 | 63648.8 |
733 | 2023-04-16 14:07:46 | sumach | 3 | 112716 | 243 | 5.280 | 21347.7 |
732 | 2023-04-04 02:37:38 | sumach | 3 | 112716 | 243 | 4.673 | 24120.7 |
731 | 2023-03-21 18:27:04 | sumach | 1 | 48755 | 4 | 0.860 | 56691.9 |
730 | 2023-01-08 05:50:18 | sumach | 1 | 48755 | 4 | 0.750 | 65006.7 |
729 | 2023-01-03 05:08:40 | sumach | 3 | 112716 | 243 | 4.720 | 23880.5 |
728 | 2022-10-26 15:07:22 | sumach | 3 | 112716 | 243 | 4.766 | 23650.0 |
727 | 2022-10-07 19:35:44 | sumach | 1 | 48755 | 4 | 0.873 | 55847.7 |
726 | 2022-09-08 17:51:44 | sumach | 3 | 112716 | 243 | 4.720 | 23880.5 |
725 | 2022-07-19 13:18:27 | sumach | 1 | 48755 | 4 | 0.766 | 63648.8 |
724 | 2022-07-02 18:21:19 | sumach | 2 | 82551 | 14 | 3.360 | 24568.8 |
723 | 2022-05-29 22:02:43 | sumach | 1 | 48755 | 4 | 0.763 | 63899.1 |
722 | 2022-02-11 01:48:04 | sumach | 1 | 48755 | 4 | 0.846 | 57630.0 |
721 | 2022-02-08 21:56:36 | sumach | 1 | 48755 | 4 | 0.780 | 62506.4 |
720 | 2021-12-15 05:51:52 | sumach | 1 | 48755 | 4 | 0.780 | 62506.4 |
719 | 2021-06-13 15:24:31 | sumach | 3 | 112716 | 243 | 5.393 | 20900.4 |
718 | 2021-05-20 12:32:04 | sumach | 1 | 48755 | 4 | 0.783 | 62266.9 |
717 | 2021-05-12 09:49:53 | sumach | 3 | 112716 | 243 | 5.436 | 20735.1 |
716 | 2021-04-20 16:12:14 | sumach | 1 | 48755 | 4 | 0.940 | 51867.0 |
715 | 2021-04-16 22:19:03 | sumach | 3 | 112716 | 243 | 12.046 | 9357.1 |
714 | 2021-02-01 17:47:21 | sumach | 1 | 48755 | 4 | 0.780 | 62506.4 |
713 | 2021-01-05 20:17:42 | sumach | 3 | 112716 | 243 | 4.686 | 24053.8 |
712 | 2021-01-05 09:51:48 | sumach | 1 | 48755 | 4 | 0.826 | 59025.4 |
711 | 2021-01-03 07:31:24 | sumach | 3 | 112716 | 243 | 4.720 | 23880.5 |
710 | 2020-12-08 11:49:27 | sumach | 3 | 112716 | 243 | 4.766 | 23650.0 |
709 | 2020-11-19 08:03:16 | sumach | 3 | 112716 | 243 | 5.813 | 19390.3 |
708 | 2020-11-16 15:55:40 | sumach | 1 | 48755 | 4 | 0.830 | 58741.0 |
707 | 2020-11-09 07:10:10 | sumach | 3 | 112716 | 243 | 5.546 | 20323.8 |
706 | 2020-11-01 17:20:27 | sumach | 1 | 48755 | 4 | 0.813 | 59969.2 |
705 | 2020-10-30 04:50:57 | sumach | 2 | 82551 | 14 | 2.296 | 35954.3 |
704 | 2020-09-27 03:17:50 | sumach | 3 | 112716 | 243 | 5.436 | 20735.1 |
703 | 2020-09-05 10:49:29 | sumach | 1 | 48755 | 4 | 0.750 | 65006.7 |
702 | 2020-08-20 10:21:17 | sumach | 1 | 48755 | 4 | 0.796 | 61250.0 |
701 | 2020-07-30 17:23:52 | sumach | 1 | 48755 | 4 | 0.813 | 59969.2 |
700 | 2020-07-24 06:16:30 | sumach | 1 | 48755 | 4 | 0.796 | 61250.0 |
699 | 2020-07-23 19:51:56 | sumach | 3 | 112716 | 243 | 5.470 | 20606.2 |
698 | 2020-07-20 04:27:37 | sumach | 1 | 48755 | 4 | 0.876 | 55656.4 |
697 | 2020-07-15 05:34:27 | sumach | 1 | 48755 | 4 | 1.393 | 35000.0 |
696 | 2020-06-17 10:12:57 | sumach | 1 | 48755 | 4 | 0.766 | 63648.8 |
695 | 2020-06-14 03:45:42 | sumach | 1 | 48755 | 4 | 0.890 | 54780.9 |
694 | 2020-06-13 03:03:22 | sumach | 1 | 48755 | 4 | 0.796 | 61250.0 |
693 | 2020-06-10 08:26:16 | sumach | 1 | 48755 | 4 | 0.826 | 59025.4 |
692 | 2020-06-09 09:01:23 | sumach | 1 | 48755 | 4 | 0.890 | 54780.9 |
691 | 2020-06-08 09:11:22 | sumach | 1 | 48755 | 4 | 0.780 | 62506.4 |
690 | 2020-06-02 02:18:34 | sumach | 1 | 48755 | 4 | 0.750 | 65006.7 |
689 | 2020-06-01 02:40:52 | sumach | 1 | 48755 | 4 | 0.830 | 58741.0 |
688 | 2020-05-16 15:53:56 | sumach | 1 | 48755 | 4 | 0.766 | 63648.8 |
687 | 2020-05-14 04:39:43 | sumach | 1 | 48755 | 4 | 0.830 | 58741.0 |