History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"janes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
827 | 2024-03-22 21:51:22 | janes | 1 | 28756 | 17 | 0.563 | 51076.4 |
826 | 2024-03-21 18:20:25 | janes | 1 | 28756 | 17 | 1.033 | 27837.4 |
825 | 2024-03-20 06:08:48 | janes | 1 | 28756 | 17 | 0.453 | 63479.0 |
824 | 2024-03-03 20:46:10 | janes | 1 | 28756 | 17 | 0.453 | 63479.0 |
823 | 2024-03-01 07:27:00 | janes | 1 | 28756 | 17 | 0.516 | 55728.7 |
822 | 2024-02-28 20:42:22 | janes | 1 | 28756 | 17 | 0.530 | 54256.6 |
821 | 2024-02-27 22:59:23 | janes | 2 | 53800 | 356 | 1.920 | 28020.8 |
820 | 2024-02-27 20:39:43 | janes | 1 | 28756 | 17 | 0.486 | 59168.7 |
819 | 2024-02-22 19:04:44 | janes | 1 | 28756 | 17 | 0.423 | 67981.1 |
818 | 2024-02-22 01:00:50 | janes | 1 | 28756 | 17 | 0.440 | 65354.5 |
817 | 2024-02-20 05:04:21 | janes | 1 | 28756 | 17 | 0.533 | 53951.2 |
816 | 2024-02-19 16:59:57 | janes | 1 | 28756 | 17 | 0.530 | 54256.6 |
815 | 2024-02-19 10:34:09 | janes | 1 | 28756 | 17 | 0.440 | 65354.5 |
814 | 2024-02-11 01:00:43 | janes | 1 | 28756 | 17 | 0.640 | 44931.3 |
813 | 2024-02-09 23:06:59 | janes | 1 | 28756 | 17 | 0.466 | 61708.2 |
812 | 2024-02-09 00:21:15 | janes | 1 | 28756 | 17 | 0.626 | 45936.1 |
811 | 2024-02-07 20:06:34 | janes | 1 | 28756 | 17 | 0.470 | 61183.0 |
810 | 2024-02-06 04:18:00 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
809 | 2024-02-05 01:17:54 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
808 | 2024-01-25 17:08:21 | janes | 1 | 28756 | 17 | 0.423 | 67981.1 |
807 | 2024-01-24 18:10:38 | janes | 1 | 28756 | 17 | 0.440 | 65354.5 |
806 | 2024-01-23 17:40:53 | janes | 1 | 28756 | 17 | 1.296 | 22188.3 |
805 | 2024-01-22 13:47:11 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
804 | 2024-01-22 02:58:53 | janes | 2 | 53800 | 356 | 1.360 | 39558.8 |
803 | 2024-01-18 07:23:39 | janes | 2 | 53800 | 356 | 1.593 | 33772.8 |
802 | 2023-12-31 09:48:10 | janes | 2 | 53800 | 356 | 1.373 | 39184.3 |
801 | 2023-12-26 19:13:10 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
800 | 2023-12-11 18:11:54 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
799 | 2023-12-10 21:36:46 | janes | 1 | 28756 | 17 | 0.516 | 55728.7 |
798 | 2023-12-09 21:38:34 | janes | 1 | 28756 | 17 | 0.513 | 56054.6 |
797 | 2023-11-30 10:00:20 | janes | 1 | 28756 | 17 | 0.453 | 63479.0 |
796 | 2023-11-26 19:14:35 | janes | 2 | 53800 | 356 | 1.626 | 33087.3 |
795 | 2023-11-22 05:19:48 | janes | 1 | 28756 | 17 | 0.466 | 61708.2 |
794 | 2023-11-21 11:37:52 | janes | 2 | 53800 | 356 | 1.530 | 35163.4 |
793 | 2023-11-18 00:50:08 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
792 | 2023-11-15 10:01:30 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
791 | 2023-11-09 04:00:21 | janes | 1 | 28756 | 17 | 0.423 | 67981.1 |
790 | 2023-11-01 18:13:49 | janes | 2 | 53800 | 356 | 1.576 | 34137.1 |
789 | 2023-10-30 18:59:26 | janes | 1 | 28756 | 17 | 0.470 | 61183.0 |
788 | 2023-10-22 03:20:57 | janes | 2 | 53800 | 356 | 1.343 | 40059.6 |
787 | 2023-10-21 23:09:55 | janes | 1 | 28756 | 17 | 0.453 | 63479.0 |
786 | 2023-10-21 04:27:22 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
785 | 2023-10-17 10:21:02 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
784 | 2023-10-17 00:24:09 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
783 | 2023-10-06 08:08:33 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
782 | 2023-09-25 18:37:08 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
781 | 2023-09-15 11:36:21 | janes | 1 | 28756 | 17 | 0.470 | 61183.0 |
780 | 2023-09-14 17:50:49 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
779 | 2023-09-13 19:32:46 | janes | 1 | 28756 | 17 | 0.516 | 55728.7 |
778 | 2023-08-11 08:20:45 | janes | 2 | 53800 | 356 | 1.360 | 39558.8 |
777 | 2023-07-11 19:56:59 | janes | 1 | 28756 | 17 | 0.843 | 34111.5 |
776 | 2023-06-28 20:51:28 | janes | 1 | 28756 | 17 | 0.486 | 59168.7 |
775 | 2023-06-10 12:51:26 | janes | 1 | 28756 | 17 | 0.420 | 68466.7 |
774 | 2023-04-19 23:46:35 | janes | 2 | 53800 | 356 | 1.373 | 39184.3 |
773 | 2023-04-07 16:24:30 | janes | 1 | 28756 | 17 | 0.423 | 67981.1 |
772 | 2023-04-04 06:27:42 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
771 | 2023-03-18 11:40:56 | janes | 2 | 53800 | 356 | 1.436 | 37465.2 |
770 | 2023-02-14 20:04:12 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
769 | 2023-02-14 12:06:03 | janes | 2 | 53800 | 356 | 1.500 | 35866.7 |
768 | 2023-01-22 09:06:56 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
767 | 2023-01-21 23:39:33 | janes | 2 | 53800 | 356 | 1.606 | 33499.4 |
766 | 2023-01-20 19:07:23 | janes | 2 | 53800 | 356 | 1.343 | 40059.6 |
765 | 2022-12-30 20:50:17 | janes | 2 | 53800 | 356 | 1.330 | 40451.1 |
764 | 2022-12-30 01:15:20 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
763 | 2022-12-29 03:44:57 | janes | 2 | 53800 | 356 | 1.640 | 32804.9 |
762 | 2022-12-26 13:05:42 | janes | 1 | 28756 | 17 | 0.440 | 65354.5 |
761 | 2022-12-26 05:47:46 | janes | 2 | 53800 | 356 | 1.673 | 32157.8 |
760 | 2022-12-21 13:26:42 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
759 | 2022-12-20 05:51:06 | janes | 1 | 28756 | 17 | 0.420 | 68466.7 |
758 | 2022-12-18 06:17:10 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
757 | 2022-12-17 06:18:49 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
756 | 2022-12-15 10:34:36 | janes | 1 | 28756 | 17 | 0.466 | 61708.2 |
755 | 2022-12-13 20:07:07 | janes | 1 | 28756 | 17 | 0.470 | 61183.0 |
754 | 2022-12-11 18:22:20 | janes | 1 | 28756 | 17 | 0.420 | 68466.7 |
753 | 2022-12-08 11:07:00 | janes | 1 | 28756 | 17 | 0.423 | 67981.1 |
752 | 2022-12-06 17:12:10 | janes | 1 | 28756 | 17 | 0.420 | 68466.7 |
751 | 2022-11-17 23:51:44 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
750 | 2022-11-10 01:49:20 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
749 | 2022-11-09 13:07:14 | janes | 2 | 53800 | 356 | 1.590 | 33836.5 |
748 | 2022-10-30 13:49:45 | janes | 2 | 53800 | 356 | 1.326 | 40573.2 |
747 | 2022-10-30 08:03:34 | janes | 2 | 53800 | 356 | 1.576 | 34137.1 |
746 | 2022-10-18 17:33:08 | janes | 2 | 53800 | 356 | 1.390 | 38705.0 |
745 | 2022-09-28 11:07:24 | janes | 2 | 53800 | 356 | 1.466 | 36698.5 |
744 | 2022-09-19 05:28:16 | janes | 1 | 28756 | 17 | 0.466 | 61708.2 |
743 | 2022-09-17 20:03:22 | janes | 1 | 28756 | 17 | 0.483 | 59536.2 |
742 | 2022-09-17 08:15:55 | janes | 2 | 53800 | 356 | 1.360 | 39558.8 |
741 | 2022-09-16 02:12:13 | janes | 2 | 53800 | 356 | 1.546 | 34799.5 |
740 | 2022-09-14 09:29:22 | janes | 2 | 53800 | 356 | 1.843 | 29191.5 |
739 | 2022-09-10 15:17:59 | janes | 1 | 28756 | 17 | 0.470 | 61183.0 |
738 | 2022-09-09 12:48:56 | janes | 2 | 53800 | 356 | 1.326 | 40573.2 |
737 | 2022-08-31 02:52:58 | janes | 1 | 28756 | 17 | 0.576 | 49923.6 |
736 | 2022-08-25 17:34:56 | janes | 2 | 53800 | 356 | 1.390 | 38705.0 |
735 | 2022-08-07 22:58:38 | janes | 2 | 53800 | 356 | 1.376 | 39098.8 |
734 | 2022-07-09 19:48:59 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
733 | 2022-06-29 07:49:34 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
732 | 2022-06-28 06:56:02 | janes | 1 | 28756 | 17 | 0.466 | 61708.2 |
731 | 2022-06-27 08:13:52 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |
730 | 2022-06-26 16:57:36 | janes | 1 | 28756 | 17 | 0.500 | 57512.0 |
729 | 2022-06-25 09:46:28 | janes | 1 | 28756 | 17 | 0.453 | 63479.0 |
728 | 2022-06-24 12:05:05 | janes | 1 | 28756 | 17 | 0.436 | 65954.1 |