History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"billy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
835 | 2024-05-02 03:34:36 | billy | 1 | 28756 | 17 | 0.513 | 56054.6 |
834 | 2024-04-29 21:00:46 | billy | 1 | 28756 | 17 | 0.546 | 52666.7 |
833 | 2024-04-27 23:32:23 | billy | 2 | 53800 | 165 | 5.593 | 9619.2 |
832 | 2024-04-27 13:34:21 | billy | 1 | 28756 | 17 | 0.923 | 31154.9 |
831 | 2024-04-04 23:01:13 | billy | 1 | 28756 | 17 | 1.563 | 18398.0 |
830 | 2024-04-03 04:06:43 | billy | 1 | 28756 | 17 | 1.750 | 16432.0 |
829 | 2024-03-31 02:55:13 | billy | 1 | 28756 | 17 | 0.530 | 54256.6 |
828 | 2024-03-29 07:12:37 | billy | 2 | 53800 | 165 | 2.813 | 19125.5 |
827 | 2024-03-29 00:10:27 | billy | 2 | 53800 | 165 | 3.830 | 14047.0 |
826 | 2024-03-28 22:57:34 | billy | 1 | 28756 | 17 | 0.533 | 53951.2 |
825 | 2024-03-03 21:45:47 | billy | 1 | 28756 | 17 | 0.486 | 59168.7 |
824 | 2024-02-27 20:16:08 | billy | 1 | 28756 | 17 | 0.640 | 44931.3 |
823 | 2024-01-31 13:36:20 | billy | 1 | 28756 | 17 | 0.516 | 55728.7 |
822 | 2024-01-28 20:07:27 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
821 | 2024-01-24 06:06:21 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
820 | 2024-01-13 18:47:11 | billy | 1 | 28756 | 17 | 0.516 | 55728.7 |
819 | 2024-01-02 01:49:17 | billy | 2 | 53800 | 165 | 1.390 | 38705.0 |
818 | 2024-01-01 01:19:59 | billy | 2 | 53800 | 165 | 1.546 | 34799.5 |
817 | 2023-12-29 01:23:01 | billy | 1 | 28756 | 17 | 0.440 | 65354.5 |
816 | 2023-12-26 10:45:57 | billy | 2 | 53800 | 165 | 1.563 | 34421.0 |
815 | 2023-12-23 15:06:50 | billy | 2 | 53800 | 165 | 1.576 | 34137.1 |
814 | 2023-12-17 14:33:13 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
813 | 2023-12-16 09:03:54 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
812 | 2023-11-20 06:13:34 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
811 | 2023-11-13 22:33:01 | billy | 1 | 28756 | 17 | 0.486 | 59168.7 |
810 | 2023-11-13 00:42:22 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
809 | 2023-10-29 21:34:19 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
808 | 2023-10-20 10:55:47 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
807 | 2023-10-17 05:33:40 | billy | 1 | 28756 | 17 | 0.576 | 49923.6 |
806 | 2023-10-11 20:44:43 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
805 | 2023-10-03 16:58:57 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
804 | 2023-09-26 15:35:25 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
803 | 2023-09-23 02:53:25 | billy | 1 | 28756 | 17 | 1.000 | 28756.0 |
802 | 2023-09-07 12:22:21 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
801 | 2023-09-07 01:13:52 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
800 | 2023-09-03 22:14:55 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
799 | 2023-06-29 15:45:25 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
798 | 2023-06-10 19:55:50 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
797 | 2023-05-31 11:44:02 | billy | 1 | 28756 | 17 | 0.420 | 68466.7 |
796 | 2023-03-31 14:51:21 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
795 | 2023-03-31 13:46:55 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
794 | 2023-02-22 06:51:12 | billy | 1 | 28756 | 17 | 0.530 | 54256.6 |
793 | 2023-01-14 04:31:40 | billy | 1 | 28756 | 17 | 0.440 | 65354.5 |
792 | 2022-11-25 05:08:37 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
791 | 2022-11-15 23:16:27 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
790 | 2022-11-06 05:50:25 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
789 | 2022-09-18 00:37:16 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
788 | 2022-09-14 20:31:35 | billy | 1 | 28756 | 17 | 0.440 | 65354.5 |
787 | 2022-08-27 18:30:55 | billy | 1 | 28756 | 17 | 0.470 | 61183.0 |
786 | 2022-08-09 07:32:51 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
785 | 2022-07-18 06:36:09 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
784 | 2022-06-28 20:32:59 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
783 | 2022-06-26 16:56:16 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
782 | 2022-05-18 13:57:34 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
781 | 2022-04-29 05:52:46 | billy | 1 | 28756 | 17 | 0.470 | 61183.0 |
780 | 2022-03-01 16:21:04 | billy | 1 | 28756 | 17 | 0.593 | 48492.4 |
779 | 2022-02-06 17:12:14 | billy | 1 | 28756 | 17 | 1.063 | 27051.7 |
778 | 2022-02-06 07:19:37 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
777 | 2022-02-05 10:27:45 | billy | 1 | 28756 | 17 | 0.593 | 48492.4 |
776 | 2022-02-04 22:11:55 | billy | 1 | 28756 | 17 | 0.486 | 59168.7 |
775 | 2022-02-04 14:14:18 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
774 | 2022-02-04 00:18:07 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
773 | 2022-02-03 12:41:29 | billy | 1 | 28756 | 17 | 0.440 | 65354.5 |
772 | 2022-02-03 01:21:13 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
771 | 2022-02-02 18:26:04 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
770 | 2022-02-02 03:18:55 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
769 | 2022-02-01 18:52:56 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
768 | 2022-02-01 09:15:41 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
767 | 2022-01-31 23:49:12 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
766 | 2022-01-31 06:49:00 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
765 | 2022-01-30 17:16:20 | billy | 1 | 28756 | 17 | 0.440 | 65354.5 |
764 | 2022-01-30 03:51:03 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
763 | 2022-01-29 11:18:22 | billy | 1 | 28756 | 17 | 0.516 | 55728.7 |
762 | 2022-01-25 20:19:49 | billy | 1 | 28756 | 17 | 0.920 | 31256.5 |
761 | 2021-12-31 19:56:53 | billy | 1 | 28756 | 17 | 0.486 | 59168.7 |
760 | 2021-12-30 20:34:45 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
759 | 2021-12-29 18:42:58 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
758 | 2021-12-28 19:39:03 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
757 | 2021-12-27 17:49:18 | billy | 1 | 28756 | 17 | 1.046 | 27491.4 |
756 | 2021-12-26 17:30:21 | billy | 1 | 28756 | 17 | 1.016 | 28303.1 |
755 | 2021-12-25 12:27:05 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
754 | 2021-12-24 12:56:30 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
753 | 2021-12-23 23:16:25 | billy | 1 | 28756 | 17 | 0.563 | 51076.4 |
752 | 2021-12-23 11:48:25 | billy | 1 | 28756 | 17 | 0.563 | 51076.4 |
751 | 2021-12-23 03:16:37 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
750 | 2021-12-22 16:17:43 | billy | 1 | 28756 | 17 | 0.546 | 52666.7 |
749 | 2021-12-22 04:46:57 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
748 | 2021-12-21 19:43:58 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |
747 | 2021-12-21 09:54:11 | billy | 1 | 28756 | 17 | 0.516 | 55728.7 |
746 | 2021-12-20 22:58:39 | billy | 1 | 28756 | 17 | 0.673 | 42728.1 |
745 | 2021-12-20 16:35:15 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
744 | 2021-12-20 12:12:04 | billy | 1 | 28756 | 17 | 0.890 | 32310.1 |
743 | 2021-12-18 13:24:14 | billy | 1 | 28756 | 17 | 0.576 | 49923.6 |
742 | 2021-12-17 03:42:48 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
741 | 2021-12-16 21:00:45 | billy | 1 | 28756 | 17 | 0.453 | 63479.0 |
740 | 2021-12-16 08:01:09 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
739 | 2021-12-15 17:40:36 | billy | 1 | 28756 | 17 | 0.436 | 65954.1 |
738 | 2021-12-15 01:47:21 | billy | 1 | 28756 | 17 | 0.500 | 57512.0 |
737 | 2021-12-14 15:50:18 | billy | 1 | 28756 | 17 | 0.530 | 54256.6 |
736 | 2021-12-11 12:07:26 | billy | 1 | 28756 | 17 | 0.483 | 59536.2 |