History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
836 | 2024-04-20 21:18:04 | loper | 2 | 53800 | 268 | 2.453 | 21932.3 |
835 | 2024-04-05 16:58:04 | loper | 1 | 28756 | 20 | 0.546 | 52666.7 |
834 | 2024-04-05 12:16:21 | loper | 1 | 28756 | 20 | 0.580 | 49579.3 |
833 | 2024-04-04 20:55:26 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
832 | 2024-04-03 03:53:28 | loper | 1 | 28756 | 20 | 1.750 | 16432.0 |
831 | 2024-03-31 12:45:28 | loper | 2 | 53800 | 268 | 3.533 | 15227.9 |
830 | 2024-03-31 02:53:03 | loper | 1 | 28756 | 20 | 0.516 | 55728.7 |
829 | 2024-03-29 09:46:04 | loper | 1 | 28756 | 20 | 0.483 | 59536.2 |
828 | 2024-03-20 18:50:51 | loper | 1 | 28756 | 20 | 1.110 | 25906.3 |
827 | 2024-03-20 18:50:25 | loper | 2 | 53800 | 268 | 1.843 | 29191.5 |
826 | 2024-03-05 09:04:30 | loper | 1 | 28756 | 20 | 0.516 | 55728.7 |
825 | 2024-03-04 03:57:57 | loper | 2 | 53800 | 268 | 2.280 | 23596.5 |
824 | 2024-03-03 23:04:14 | loper | 2 | 53800 | 268 | 5.720 | 9405.6 |
823 | 2024-03-03 22:33:42 | loper | 1 | 28756 | 20 | 0.580 | 49579.3 |
822 | 2024-03-02 01:40:57 | loper | 1 | 28756 | 20 | 1.670 | 17219.2 |
821 | 2024-02-28 10:33:38 | loper | 2 | 53800 | 268 | 3.923 | 13714.0 |
820 | 2024-02-28 07:06:48 | loper | 2 | 53800 | 268 | 1.830 | 29398.9 |
819 | 2024-02-28 07:06:34 | loper | 1 | 28756 | 20 | 0.563 | 51076.4 |
818 | 2024-02-19 13:55:40 | loper | 2 | 53800 | 268 | 4.313 | 12473.9 |
817 | 2024-02-13 10:10:38 | loper | 1 | 28756 | 20 | 0.516 | 55728.7 |
816 | 2024-01-29 03:19:14 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
815 | 2024-01-19 14:39:25 | loper | 1 | 28756 | 20 | 0.516 | 55728.7 |
814 | 2024-01-17 02:35:37 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
813 | 2023-12-24 16:19:27 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
812 | 2023-12-18 11:46:16 | loper | 1 | 28756 | 20 | 0.483 | 59536.2 |
811 | 2023-12-03 19:03:43 | loper | 1 | 28756 | 20 | 1.110 | 25906.3 |
810 | 2023-12-03 19:03:41 | loper | 1 | 28756 | 20 | 1.110 | 25906.3 |
809 | 2023-12-03 00:52:36 | loper | 2 | 53800 | 268 | 1.580 | 34050.6 |
808 | 2023-11-25 22:52:22 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
807 | 2023-11-18 10:47:36 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
806 | 2023-11-15 10:14:27 | loper | 2 | 53800 | 268 | 1.610 | 33416.1 |
805 | 2023-11-11 22:01:30 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
804 | 2023-11-11 14:26:23 | loper | 2 | 53800 | 268 | 1.576 | 34137.1 |
803 | 2023-11-08 00:26:12 | loper | 2 | 53800 | 268 | 1.403 | 38346.4 |
802 | 2023-11-06 15:57:04 | loper | 1 | 28756 | 20 | 0.483 | 59536.2 |
801 | 2023-11-03 23:17:40 | loper | 1 | 28756 | 20 | 0.893 | 32201.6 |
800 | 2023-10-21 08:56:39 | loper | 1 | 28756 | 20 | 0.530 | 54256.6 |
799 | 2023-10-19 06:38:48 | loper | 1 | 28756 | 20 | 0.483 | 59536.2 |
798 | 2023-10-11 10:22:36 | loper | 1 | 28756 | 20 | 0.516 | 55728.7 |
797 | 2023-10-11 06:59:21 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
796 | 2023-10-05 16:43:40 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
795 | 2023-09-23 07:48:28 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
794 | 2023-09-20 14:13:24 | loper | 1 | 28756 | 20 | 0.530 | 54256.6 |
793 | 2023-08-31 13:21:26 | loper | 2 | 53800 | 268 | 1.360 | 39558.8 |
792 | 2023-08-13 11:22:27 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
791 | 2023-08-06 07:35:33 | loper | 1 | 28756 | 20 | 0.486 | 59168.7 |
790 | 2023-08-06 05:33:12 | loper | 1 | 28756 | 20 | 0.440 | 65354.5 |
789 | 2023-06-18 07:22:06 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
788 | 2023-06-15 14:20:52 | loper | 1 | 28756 | 20 | 0.440 | 65354.5 |
787 | 2023-05-16 01:01:11 | loper | 2 | 53800 | 268 | 1.563 | 34421.0 |
786 | 2023-05-04 22:09:47 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
785 | 2023-04-29 18:36:08 | loper | 1 | 28756 | 20 | 0.486 | 59168.7 |
784 | 2023-04-27 08:13:49 | loper | 1 | 28756 | 20 | 0.466 | 61708.2 |
783 | 2023-04-25 01:45:56 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
782 | 2023-03-07 22:45:38 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
781 | 2023-03-05 08:47:37 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
780 | 2023-02-26 22:32:20 | loper | 1 | 28756 | 20 | 0.470 | 61183.0 |
779 | 2023-02-22 19:18:03 | loper | 2 | 53800 | 268 | 1.360 | 39558.8 |
778 | 2023-01-15 11:11:54 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
777 | 2023-01-13 05:46:58 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
776 | 2023-01-05 06:12:35 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
775 | 2022-12-25 06:15:51 | loper | 1 | 28756 | 20 | 0.486 | 59168.7 |
774 | 2022-12-05 07:09:33 | loper | 2 | 53800 | 268 | 1.533 | 35094.6 |
773 | 2022-12-01 11:51:38 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
772 | 2022-11-29 01:14:33 | loper | 1 | 28756 | 20 | 0.516 | 55728.7 |
771 | 2022-10-15 11:30:36 | loper | 1 | 28756 | 20 | 0.456 | 63061.4 |
770 | 2022-10-12 17:16:39 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
769 | 2022-09-21 13:56:40 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
768 | 2022-09-19 05:47:16 | loper | 1 | 28756 | 20 | 0.873 | 32939.3 |
767 | 2022-09-11 09:29:09 | loper | 1 | 28756 | 20 | 0.440 | 65354.5 |
766 | 2022-09-02 05:35:06 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
765 | 2022-09-01 00:45:20 | loper | 1 | 28756 | 20 | 0.450 | 63902.2 |
764 | 2022-08-30 04:17:02 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
763 | 2022-08-15 22:48:35 | loper | 1 | 28756 | 20 | 0.440 | 65354.5 |
762 | 2022-08-14 13:30:31 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
761 | 2022-07-30 08:46:58 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
760 | 2022-07-28 20:33:29 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
759 | 2022-07-11 22:07:37 | loper | 1 | 28756 | 20 | 0.420 | 68466.7 |
758 | 2022-07-10 09:02:22 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
757 | 2022-07-09 13:34:02 | loper | 1 | 28756 | 20 | 0.486 | 59168.7 |
756 | 2022-07-02 18:41:41 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
755 | 2022-06-08 04:48:18 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
754 | 2022-05-24 17:48:23 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
753 | 2022-05-22 02:05:23 | loper | 1 | 28756 | 20 | 0.483 | 59536.2 |
752 | 2022-04-20 10:42:42 | loper | 1 | 28756 | 20 | 0.513 | 56054.6 |
751 | 2022-04-18 20:30:06 | loper | 2 | 53800 | 268 | 1.623 | 33148.5 |
750 | 2022-04-05 21:41:54 | loper | 1 | 28756 | 20 | 1.003 | 28670.0 |
749 | 2022-04-03 08:47:37 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
748 | 2022-02-28 04:34:27 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
747 | 2022-01-20 13:45:38 | loper | 1 | 28756 | 20 | 0.500 | 57512.0 |
746 | 2021-12-26 09:05:28 | loper | 2 | 53800 | 268 | 1.686 | 31909.8 |
745 | 2021-11-23 08:53:31 | loper | 1 | 28756 | 20 | 0.533 | 53951.2 |
744 | 2021-11-12 06:37:32 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
743 | 2021-11-12 00:59:59 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
742 | 2021-10-20 18:27:42 | loper | 1 | 28756 | 20 | 0.436 | 65954.1 |
741 | 2021-09-29 15:30:19 | loper | 1 | 28756 | 20 | 0.470 | 61183.0 |
740 | 2021-08-30 07:10:10 | loper | 1 | 28756 | 20 | 0.453 | 63479.0 |
739 | 2021-08-20 08:33:44 | loper | 1 | 28756 | 20 | 0.513 | 56054.6 |
738 | 2021-08-15 01:19:29 | loper | 1 | 28756 | 20 | 0.483 | 59536.2 |
737 | 2021-06-23 04:23:18 | loper | 2 | 53800 | 268 | 1.436 | 37465.2 |