History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assai"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
813 | 2024-04-19 07:32:34 | assai | 3 | 83667 | 575 | 4.360 | 19189.7 |
812 | 2024-04-06 16:14:51 | assai | 3 | 83667 | 575 | 7.483 | 11180.9 |
811 | 2024-04-05 23:58:22 | assai | 2 | 53800 | 29 | 1.893 | 28420.5 |
810 | 2024-04-05 23:24:20 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
809 | 2024-04-03 04:05:05 | assai | 3 | 83667 | 575 | 9.453 | 8850.8 |
808 | 2024-04-02 22:17:28 | assai | 3 | 83667 | 575 | 7.313 | 11440.9 |
807 | 2024-03-31 13:51:25 | assai | 3 | 83667 | 575 | 14.360 | 5826.4 |
806 | 2024-03-31 13:51:26 | assai | 2 | 53800 | 29 | 1.966 | 27365.2 |
805 | 2024-03-31 13:49:13 | assai | 1 | 28756 | 4 | 1.720 | 16718.6 |
804 | 2024-03-29 03:43:06 | assai | 1 | 28756 | 4 | 1.080 | 26625.9 |
803 | 2024-03-06 19:29:55 | assai | 1 | 28756 | 4 | 0.593 | 48492.4 |
802 | 2024-03-06 11:44:09 | assai | 1 | 28756 | 4 | 0.546 | 52666.7 |
801 | 2024-03-03 02:53:14 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
800 | 2024-03-01 11:50:14 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
799 | 2024-02-28 06:02:03 | assai | 3 | 83667 | 575 | 8.843 | 9461.4 |
798 | 2024-02-28 02:42:05 | assai | 3 | 83667 | 575 | 10.826 | 7728.3 |
797 | 2024-02-28 02:42:04 | assai | 2 | 53800 | 29 | 1.906 | 28226.7 |
796 | 2024-02-28 02:38:17 | assai | 3 | 83667 | 575 | 4.966 | 16848.0 |
795 | 2024-02-28 02:38:17 | assai | 2 | 53800 | 29 | 1.970 | 27309.6 |
794 | 2024-02-28 02:37:19 | assai | 1 | 28756 | 4 | 0.763 | 37688.1 |
793 | 2024-02-03 18:19:07 | assai | 1 | 28756 | 4 | 0.530 | 54256.6 |
792 | 2024-02-01 05:02:56 | assai | 1 | 28756 | 4 | 0.563 | 51076.4 |
791 | 2024-01-29 03:07:23 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
790 | 2024-01-29 02:31:33 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
789 | 2024-01-11 03:36:47 | assai | 3 | 83667 | 575 | 4.660 | 17954.3 |
788 | 2023-12-28 21:01:20 | assai | 2 | 53800 | 29 | 1.626 | 33087.3 |
787 | 2023-12-18 19:25:29 | assai | 3 | 83667 | 575 | 3.343 | 25027.5 |
786 | 2023-12-18 19:25:28 | assai | 2 | 53800 | 29 | 1.563 | 34421.0 |
785 | 2023-12-10 05:20:54 | assai | 3 | 83667 | 575 | 3.376 | 24782.9 |
784 | 2023-11-29 22:50:53 | assai | 1 | 28756 | 4 | 0.516 | 55728.7 |
783 | 2023-11-27 05:44:24 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
782 | 2023-11-19 00:36:13 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
781 | 2023-11-17 18:03:58 | assai | 2 | 53800 | 29 | 1.890 | 28465.6 |
780 | 2023-11-17 18:03:55 | assai | 3 | 83667 | 575 | 4.486 | 18650.7 |
779 | 2023-11-11 22:11:52 | assai | 1 | 28756 | 4 | 0.516 | 55728.7 |
778 | 2023-11-06 21:51:32 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
777 | 2023-11-03 21:39:07 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
776 | 2023-10-24 05:37:00 | assai | 1 | 28756 | 4 | 0.546 | 52666.7 |
775 | 2023-10-21 12:17:20 | assai | 1 | 28756 | 4 | 0.486 | 59168.7 |
774 | 2023-10-18 15:15:44 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
773 | 2023-10-13 01:10:53 | assai | 1 | 28756 | 4 | 0.893 | 32201.6 |
772 | 2023-10-04 10:16:01 | assai | 1 | 28756 | 4 | 0.516 | 55728.7 |
771 | 2023-10-01 19:35:53 | assai | 2 | 53800 | 29 | 1.766 | 30464.3 |
770 | 2023-09-26 13:10:48 | assai | 1 | 28756 | 4 | 0.563 | 51076.4 |
769 | 2023-09-25 13:20:49 | assai | 1 | 28756 | 4 | 0.576 | 49923.6 |
768 | 2023-09-15 17:09:13 | assai | 2 | 53800 | 29 | 1.390 | 38705.0 |
767 | 2023-09-12 21:06:54 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
766 | 2023-09-10 15:31:39 | assai | 3 | 83667 | 575 | 5.813 | 14393.1 |
765 | 2023-09-10 08:05:49 | assai | 3 | 83667 | 575 | 3.686 | 22698.6 |
764 | 2023-09-07 02:35:28 | assai | 3 | 83667 | 575 | 4.296 | 19475.6 |
763 | 2023-08-22 12:24:25 | assai | 1 | 28756 | 4 | 0.483 | 59536.2 |
762 | 2023-07-26 11:31:38 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
761 | 2023-07-19 10:19:08 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
760 | 2023-07-12 01:39:57 | assai | 2 | 53800 | 29 | 1.610 | 33416.1 |
759 | 2023-06-29 17:35:46 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
758 | 2023-05-18 12:42:58 | assai | 3 | 83667 | 575 | 3.296 | 25384.4 |
757 | 2023-04-21 23:05:32 | assai | 3 | 83667 | 575 | 3.576 | 23396.8 |
756 | 2023-04-13 07:29:41 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
755 | 2023-04-07 21:37:50 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
754 | 2023-03-31 13:18:04 | assai | 1 | 28756 | 4 | 0.516 | 55728.7 |
753 | 2023-03-29 07:55:44 | assai | 2 | 53800 | 29 | 1.360 | 39558.8 |
752 | 2023-03-27 15:22:18 | assai | 3 | 83667 | 575 | 3.970 | 21074.8 |
751 | 2023-03-22 17:15:19 | assai | 3 | 83667 | 575 | 3.470 | 24111.5 |
750 | 2023-02-25 21:20:06 | assai | 3 | 83667 | 575 | 3.280 | 25508.2 |
749 | 2023-02-04 01:34:00 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
748 | 2023-01-14 06:51:50 | assai | 2 | 53800 | 29 | 1.373 | 39184.3 |
747 | 2022-12-29 22:21:44 | assai | 1 | 28756 | 4 | 0.483 | 59536.2 |
746 | 2022-12-26 09:11:38 | assai | 2 | 53800 | 29 | 1.360 | 39558.8 |
745 | 2022-12-13 09:40:41 | assai | 2 | 53800 | 29 | 1.376 | 39098.8 |
744 | 2022-12-06 16:02:45 | assai | 3 | 83667 | 575 | 3.283 | 25484.9 |
743 | 2022-12-03 03:31:44 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
742 | 2022-11-05 07:40:18 | assai | 2 | 53800 | 29 | 1.393 | 38621.7 |
741 | 2022-10-04 06:04:54 | assai | 2 | 53800 | 29 | 1.593 | 33772.8 |
740 | 2022-09-15 12:28:25 | assai | 1 | 28756 | 4 | 0.470 | 61183.0 |
739 | 2022-08-27 18:56:19 | assai | 2 | 53800 | 29 | 1.373 | 39184.3 |
738 | 2022-07-31 01:03:56 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
737 | 2022-07-29 09:01:25 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
736 | 2022-05-27 00:24:57 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
735 | 2022-04-14 07:49:24 | assai | 3 | 83667 | 575 | 3.313 | 25254.2 |
734 | 2022-04-04 14:40:16 | assai | 2 | 53800 | 29 | 1.436 | 37465.2 |
733 | 2022-03-27 15:31:25 | assai | 1 | 28756 | 4 | 0.513 | 56054.6 |
732 | 2022-03-25 12:27:20 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
731 | 2022-02-16 19:14:07 | assai | 1 | 28756 | 4 | 0.470 | 61183.0 |
730 | 2022-02-12 01:53:17 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
729 | 2022-02-08 19:45:29 | assai | 3 | 83667 | 575 | 3.936 | 21256.9 |
728 | 2022-01-11 11:53:09 | assai | 3 | 83667 | 575 | 4.280 | 19548.4 |
727 | 2022-01-01 05:45:38 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
726 | 2021-12-17 17:36:49 | assai | 3 | 83667 | 575 | 4.063 | 20592.4 |
725 | 2021-12-12 10:41:16 | assai | 1 | 28756 | 4 | 0.486 | 59168.7 |
724 | 2021-12-04 00:42:27 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
723 | 2021-11-19 22:00:56 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
722 | 2021-11-07 15:28:55 | assai | 1 | 28756 | 4 | 0.483 | 59536.2 |
721 | 2021-10-19 15:33:16 | assai | 1 | 28756 | 4 | 0.563 | 51076.4 |
720 | 2021-09-13 21:00:37 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
719 | 2021-08-29 11:24:47 | assai | 1 | 28756 | 4 | 0.436 | 65954.1 |
718 | 2021-08-27 07:06:40 | assai | 1 | 28756 | 4 | 0.453 | 63479.0 |
717 | 2021-08-08 00:25:37 | assai | 1 | 28756 | 4 | 0.500 | 57512.0 |
716 | 2021-05-03 20:34:24 | assai | 1 | 28756 | 4 | 0.546 | 52666.7 |
715 | 2021-04-30 04:35:34 | assai | 1 | 28756 | 4 | 0.486 | 59168.7 |
714 | 2021-02-14 18:09:17 | assai | 1 | 28756 | 4 | 0.530 | 54256.6 |