History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lanai"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
812 | 2024-04-26 06:36:41 | lanai | 3 | 83667 | 1223 | 4.406 | 18989.3 |
811 | 2024-04-24 19:13:59 | lanai | 1 | 28756 | 2 | 0.516 | 55728.7 |
810 | 2024-04-24 12:59:59 | lanai | 3 | 83667 | 1223 | 10.016 | 8353.3 |
809 | 2024-04-22 23:53:52 | lanai | 2 | 53800 | 58 | 1.606 | 33499.4 |
808 | 2024-04-20 23:02:28 | lanai | 3 | 83667 | 1223 | 14.843 | 5636.8 |
807 | 2024-04-19 12:04:25 | lanai | 3 | 83667 | 1223 | 3.530 | 23701.7 |
806 | 2024-04-17 06:44:31 | lanai | 3 | 83667 | 1223 | 3.560 | 23502.0 |
805 | 2024-04-16 08:17:23 | lanai | 3 | 83667 | 1223 | 9.690 | 8634.4 |
804 | 2024-04-15 17:00:58 | lanai | 3 | 83667 | 1223 | 6.533 | 12806.8 |
803 | 2024-04-14 21:51:38 | lanai | 3 | 83667 | 1223 | 9.376 | 8923.5 |
802 | 2024-04-12 17:46:05 | lanai | 1 | 28756 | 2 | 0.763 | 37688.1 |
801 | 2024-04-05 23:29:41 | lanai | 1 | 28756 | 2 | 1.173 | 24514.9 |
800 | 2024-03-31 18:29:32 | lanai | 1 | 28756 | 2 | 0.560 | 51350.0 |
799 | 2024-03-29 18:00:52 | lanai | 1 | 28756 | 2 | 0.923 | 31154.9 |
798 | 2024-03-25 07:58:09 | lanai | 1 | 28756 | 2 | 0.516 | 55728.7 |
797 | 2024-03-22 00:50:52 | lanai | 1 | 28756 | 2 | 0.576 | 49923.6 |
796 | 2024-03-12 17:12:45 | lanai | 2 | 53800 | 58 | 3.500 | 15371.4 |
795 | 2024-03-12 17:11:57 | lanai | 3 | 83667 | 1223 | 3.986 | 20990.2 |
794 | 2024-03-12 08:47:10 | lanai | 3 | 83667 | 1223 | 5.143 | 16268.1 |
793 | 2024-03-07 03:47:03 | lanai | 1 | 28756 | 2 | 0.596 | 48248.3 |
792 | 2024-03-07 00:22:29 | lanai | 2 | 53800 | 58 | 1.640 | 32804.9 |
791 | 2024-03-07 00:22:25 | lanai | 3 | 83667 | 1223 | 3.923 | 21327.3 |
790 | 2024-03-06 21:28:35 | lanai | 1 | 28756 | 2 | 1.076 | 26724.9 |
789 | 2024-03-01 12:29:53 | lanai | 1 | 28756 | 2 | 0.436 | 65954.1 |
788 | 2024-02-28 07:34:47 | lanai | 1 | 28756 | 2 | 1.110 | 25906.3 |
787 | 2024-02-03 18:19:39 | lanai | 1 | 28756 | 2 | 0.500 | 57512.0 |
786 | 2024-01-29 06:15:31 | lanai | 1 | 28756 | 2 | 1.033 | 27837.4 |
785 | 2024-01-29 04:55:17 | lanai | 1 | 28756 | 2 | 0.986 | 29164.3 |
784 | 2024-01-19 11:31:11 | lanai | 2 | 53800 | 58 | 1.830 | 29398.9 |
783 | 2023-12-28 08:14:42 | lanai | 3 | 83667 | 1223 | 3.643 | 22966.5 |
782 | 2023-12-20 05:25:51 | lanai | 2 | 53800 | 58 | 1.563 | 34421.0 |
781 | 2023-12-19 21:08:24 | lanai | 3 | 83667 | 1223 | 4.533 | 18457.3 |
780 | 2023-12-17 05:38:19 | lanai | 1 | 28756 | 2 | 0.516 | 55728.7 |
779 | 2023-12-17 03:07:57 | lanai | 1 | 28756 | 2 | 0.596 | 48248.3 |
778 | 2023-12-16 12:34:35 | lanai | 3 | 83667 | 1223 | 7.123 | 11746.0 |
777 | 2023-12-07 11:10:06 | lanai | 1 | 28756 | 2 | 0.530 | 54256.6 |
776 | 2023-12-07 11:10:05 | lanai | 1 | 28756 | 2 | 0.530 | 54256.6 |
775 | 2023-11-29 21:32:29 | lanai | 3 | 83667 | 1223 | 4.236 | 19751.4 |
774 | 2023-11-27 06:34:38 | lanai | 2 | 53800 | 58 | 1.686 | 31909.8 |
773 | 2023-11-27 06:34:32 | lanai | 3 | 83667 | 1223 | 3.843 | 21771.3 |
772 | 2023-11-23 17:55:11 | lanai | 3 | 83667 | 1223 | 4.220 | 19826.3 |
771 | 2023-11-22 20:57:52 | lanai | 3 | 83667 | 1223 | 4.266 | 19612.5 |
770 | 2023-11-18 13:25:12 | lanai | 1 | 28756 | 2 | 0.530 | 54256.6 |
769 | 2023-11-12 03:04:36 | lanai | 1 | 28756 | 2 | 0.500 | 57512.0 |
768 | 2023-11-09 12:20:00 | lanai | 3 | 83667 | 1223 | 3.483 | 24021.5 |
767 | 2023-11-03 05:39:52 | lanai | 1 | 28756 | 2 | 0.500 | 57512.0 |
766 | 2023-10-29 10:35:59 | lanai | 2 | 53800 | 58 | 2.096 | 25667.9 |
765 | 2023-10-21 23:26:08 | lanai | 1 | 28756 | 2 | 0.456 | 63061.4 |
764 | 2023-10-18 15:51:09 | lanai | 1 | 28756 | 2 | 0.500 | 57512.0 |
763 | 2023-10-13 19:11:05 | lanai | 1 | 28756 | 2 | 0.453 | 63479.0 |
762 | 2023-10-06 08:08:37 | lanai | 1 | 28756 | 2 | 0.453 | 63479.0 |
761 | 2023-10-04 13:09:29 | lanai | 1 | 28756 | 2 | 0.513 | 56054.6 |
760 | 2023-09-28 23:52:32 | lanai | 1 | 28756 | 2 | 0.436 | 65954.1 |
759 | 2023-09-16 07:08:08 | lanai | 3 | 83667 | 1223 | 3.390 | 24680.5 |
758 | 2023-09-14 09:31:24 | lanai | 1 | 28756 | 2 | 0.453 | 63479.0 |
757 | 2023-08-27 22:56:33 | lanai | 1 | 28756 | 2 | 0.466 | 61708.2 |
756 | 2023-08-21 23:19:52 | lanai | 3 | 83667 | 1223 | 4.376 | 19119.5 |
755 | 2023-08-18 05:33:56 | lanai | 3 | 83667 | 1223 | 3.406 | 24564.6 |
754 | 2023-08-06 15:32:52 | lanai | 2 | 53800 | 58 | 1.516 | 35488.1 |
753 | 2023-08-01 17:25:11 | lanai | 1 | 28756 | 2 | 0.483 | 59536.2 |
752 | 2023-06-19 02:50:28 | lanai | 3 | 83667 | 1223 | 3.890 | 21508.2 |
751 | 2023-06-09 17:30:50 | lanai | 3 | 83667 | 1223 | 3.530 | 23701.7 |
750 | 2023-06-05 15:56:10 | lanai | 3 | 83667 | 1223 | 3.390 | 24680.5 |
749 | 2023-06-01 15:23:04 | lanai | 3 | 83667 | 1223 | 3.560 | 23502.0 |
748 | 2023-05-14 09:08:50 | lanai | 1 | 28756 | 2 | 0.483 | 59536.2 |
747 | 2023-04-29 20:57:01 | lanai | 1 | 28756 | 2 | 0.440 | 65354.5 |
746 | 2023-04-17 05:48:21 | lanai | 2 | 53800 | 58 | 1.390 | 38705.0 |
745 | 2023-03-13 02:59:53 | lanai | 3 | 83667 | 1223 | 3.970 | 21074.8 |
744 | 2023-02-23 00:23:48 | lanai | 1 | 28756 | 2 | 0.486 | 59168.7 |
743 | 2023-01-28 12:36:40 | lanai | 1 | 28756 | 2 | 0.453 | 63479.0 |
742 | 2023-01-24 21:11:02 | lanai | 1 | 28756 | 2 | 0.440 | 65354.5 |
741 | 2023-01-22 02:36:33 | lanai | 2 | 53800 | 58 | 1.390 | 38705.0 |
740 | 2023-01-20 03:55:08 | lanai | 3 | 83667 | 1223 | 3.533 | 23681.6 |
739 | 2022-12-22 08:09:06 | lanai | 1 | 28756 | 2 | 0.500 | 57512.0 |
738 | 2022-12-16 18:21:40 | lanai | 3 | 83667 | 1223 | 3.346 | 25005.1 |
737 | 2022-12-06 03:46:35 | lanai | 3 | 83667 | 1223 | 3.690 | 22674.0 |
736 | 2022-12-01 21:54:07 | lanai | 3 | 83667 | 1223 | 3.346 | 25005.1 |
735 | 2022-11-24 18:24:22 | lanai | 3 | 83667 | 1223 | 3.610 | 23176.5 |
734 | 2022-11-15 15:33:05 | lanai | 3 | 83667 | 1223 | 3.940 | 21235.3 |
733 | 2022-11-13 20:44:40 | lanai | 3 | 83667 | 1223 | 3.953 | 21165.4 |
732 | 2022-11-13 20:16:51 | lanai | 3 | 83667 | 1223 | 3.983 | 21006.0 |
731 | 2022-11-13 17:28:56 | lanai | 3 | 83667 | 1223 | 3.873 | 21602.6 |
730 | 2022-11-11 06:00:37 | lanai | 3 | 83667 | 1223 | 4.160 | 20112.3 |
729 | 2022-11-09 23:07:04 | lanai | 3 | 83667 | 1223 | 3.623 | 23093.3 |
728 | 2022-11-01 17:29:59 | lanai | 2 | 53800 | 58 | 1.483 | 36277.8 |
727 | 2022-10-30 06:34:08 | lanai | 3 | 83667 | 1223 | 4.690 | 17839.4 |
726 | 2022-10-29 05:11:29 | lanai | 3 | 83667 | 1223 | 3.736 | 22394.8 |
725 | 2022-10-28 03:59:11 | lanai | 3 | 83667 | 1223 | 3.766 | 22216.4 |
724 | 2022-10-27 07:25:40 | lanai | 3 | 83667 | 1223 | 3.716 | 22515.3 |
723 | 2022-10-26 14:45:33 | lanai | 3 | 83667 | 1223 | 4.046 | 20678.9 |
722 | 2022-10-25 04:29:22 | lanai | 3 | 83667 | 1223 | 3.500 | 23904.9 |
721 | 2022-10-24 09:10:02 | lanai | 3 | 83667 | 1223 | 4.390 | 19058.5 |
720 | 2022-10-23 04:53:46 | lanai | 3 | 83667 | 1223 | 4.030 | 20761.0 |
719 | 2022-10-22 04:22:08 | lanai | 3 | 83667 | 1223 | 3.766 | 22216.4 |
718 | 2022-10-21 09:43:00 | lanai | 3 | 83667 | 1223 | 4.313 | 19398.8 |
717 | 2022-10-20 08:39:55 | lanai | 3 | 83667 | 1223 | 3.500 | 23904.9 |
716 | 2022-10-19 08:16:42 | lanai | 3 | 83667 | 1223 | 3.843 | 21771.3 |
715 | 2022-10-18 12:33:48 | lanai | 3 | 83667 | 1223 | 4.203 | 19906.5 |
714 | 2022-10-17 18:17:37 | lanai | 3 | 83667 | 1223 | 3.936 | 21256.9 |
713 | 2022-10-16 12:25:02 | lanai | 3 | 83667 | 1223 | 7.890 | 10604.2 |