History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hosts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
863 | 2024-04-03 19:43:50 | hosts | 2 | 53800 | 267 | 3.940 | 13654.8 |
862 | 2024-04-03 19:13:22 | hosts | 1 | 28756 | 16 | 1.033 | 27837.4 |
861 | 2024-04-03 09:11:07 | hosts | 2 | 53800 | 267 | 4.953 | 10862.1 |
860 | 2024-04-03 05:46:43 | hosts | 2 | 53800 | 267 | 3.716 | 14477.9 |
859 | 2024-04-03 05:22:06 | hosts | 1 | 28756 | 16 | 0.560 | 51350.0 |
858 | 2024-04-01 17:19:21 | hosts | 1 | 28756 | 16 | 1.126 | 25538.2 |
857 | 2024-03-27 04:27:23 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
856 | 2024-03-03 21:12:17 | hosts | 1 | 28756 | 16 | 0.530 | 54256.6 |
855 | 2024-03-03 08:31:28 | hosts | 2 | 53800 | 267 | 1.530 | 35163.4 |
854 | 2024-03-03 08:26:01 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
853 | 2024-03-02 14:22:52 | hosts | 1 | 28756 | 16 | 0.576 | 49923.6 |
852 | 2024-02-25 22:18:51 | hosts | 2 | 53800 | 267 | 1.796 | 29955.5 |
851 | 2024-02-25 22:16:49 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
850 | 2024-02-16 09:10:25 | hosts | 1 | 28756 | 16 | 0.546 | 52666.7 |
849 | 2024-02-09 15:31:49 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
848 | 2024-02-02 06:12:28 | hosts | 2 | 53800 | 267 | 1.343 | 40059.6 |
847 | 2024-02-01 11:12:27 | hosts | 2 | 53800 | 267 | 1.593 | 33772.8 |
846 | 2024-02-01 11:12:23 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
845 | 2024-01-26 20:32:33 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
844 | 2024-01-19 18:18:03 | hosts | 2 | 53800 | 267 | 1.483 | 36277.8 |
843 | 2024-01-02 04:55:06 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
842 | 2023-12-26 00:29:05 | hosts | 2 | 53800 | 267 | 1.406 | 38264.6 |
841 | 2023-12-19 00:06:10 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
840 | 2023-12-04 06:02:31 | hosts | 2 | 53800 | 267 | 1.530 | 35163.4 |
839 | 2023-12-02 13:38:47 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
838 | 2023-11-22 01:06:31 | hosts | 1 | 28756 | 16 | 0.470 | 61183.0 |
837 | 2023-11-18 14:30:31 | hosts | 1 | 28756 | 16 | 1.140 | 25224.6 |
836 | 2023-11-13 09:10:39 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
835 | 2023-11-12 08:13:00 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
834 | 2023-11-07 08:00:44 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
833 | 2023-10-31 04:47:03 | hosts | 2 | 53800 | 267 | 2.983 | 18035.5 |
832 | 2023-10-30 05:39:13 | hosts | 2 | 53800 | 267 | 1.373 | 39184.3 |
831 | 2023-10-28 00:25:54 | hosts | 1 | 28756 | 16 | 0.470 | 61183.0 |
830 | 2023-10-20 19:19:11 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
829 | 2023-10-17 22:53:27 | hosts | 1 | 28756 | 16 | 0.513 | 56054.6 |
828 | 2023-10-13 15:45:31 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
827 | 2023-10-04 11:48:18 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
826 | 2023-09-23 22:51:19 | hosts | 1 | 28756 | 16 | 0.470 | 61183.0 |
825 | 2023-09-22 12:18:03 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
824 | 2023-09-20 23:10:36 | hosts | 1 | 28756 | 16 | 0.470 | 61183.0 |
823 | 2023-09-16 06:13:44 | hosts | 1 | 28756 | 16 | 0.486 | 59168.7 |
822 | 2023-08-27 04:02:04 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
821 | 2023-08-26 06:42:06 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
820 | 2023-08-06 15:18:30 | hosts | 2 | 53800 | 267 | 1.373 | 39184.3 |
819 | 2023-07-27 16:40:50 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
818 | 2023-07-01 09:06:53 | hosts | 1 | 28756 | 16 | 0.440 | 65354.5 |
817 | 2023-06-06 23:58:56 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
816 | 2023-06-05 05:51:13 | hosts | 1 | 28756 | 16 | 0.420 | 68466.7 |
815 | 2023-06-04 15:56:56 | hosts | 1 | 28756 | 16 | 0.440 | 65354.5 |
814 | 2023-06-03 18:00:16 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
813 | 2023-06-02 14:06:15 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
812 | 2023-06-01 16:51:14 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
811 | 2023-05-30 21:23:27 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
810 | 2023-04-25 16:05:54 | hosts | 1 | 28756 | 16 | 0.576 | 49923.6 |
809 | 2023-04-23 03:16:05 | hosts | 1 | 28756 | 16 | 0.983 | 29253.3 |
808 | 2023-04-21 01:14:12 | hosts | 2 | 53800 | 267 | 1.373 | 39184.3 |
807 | 2023-04-09 08:09:26 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
806 | 2023-03-19 10:15:34 | hosts | 1 | 28756 | 16 | 0.486 | 59168.7 |
805 | 2023-01-30 18:05:39 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
804 | 2023-01-28 14:27:52 | hosts | 2 | 53800 | 267 | 1.343 | 40059.6 |
803 | 2023-01-14 11:16:13 | hosts | 1 | 28756 | 16 | 0.423 | 67981.1 |
802 | 2022-12-21 14:12:31 | hosts | 2 | 53800 | 267 | 1.356 | 39675.5 |
801 | 2022-11-25 21:22:18 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
800 | 2022-11-10 21:31:24 | hosts | 2 | 53800 | 267 | 1.736 | 30990.8 |
799 | 2022-10-07 15:08:47 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
798 | 2022-10-04 02:40:46 | hosts | 1 | 28756 | 16 | 0.440 | 65354.5 |
797 | 2022-07-20 17:07:10 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
796 | 2022-07-18 10:16:22 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
795 | 2022-06-17 05:02:57 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
794 | 2022-05-17 20:15:42 | hosts | 2 | 53800 | 267 | 1.393 | 38621.7 |
793 | 2022-04-15 09:26:55 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
792 | 2022-04-14 15:03:25 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
791 | 2022-04-13 22:08:07 | hosts | 1 | 28756 | 16 | 0.703 | 40904.7 |
790 | 2022-04-08 18:22:48 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
789 | 2022-04-07 20:59:02 | hosts | 1 | 28756 | 16 | 0.766 | 37540.5 |
788 | 2022-04-06 18:09:06 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
787 | 2022-04-05 23:38:37 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
786 | 2022-04-01 18:42:17 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
785 | 2022-03-21 18:36:38 | hosts | 1 | 28756 | 16 | 0.606 | 47452.1 |
784 | 2022-03-21 17:35:08 | hosts | 1 | 28756 | 16 | 0.486 | 59168.7 |
783 | 2022-03-20 20:10:45 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
782 | 2022-03-20 20:02:19 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
781 | 2022-03-15 21:51:58 | hosts | 1 | 28756 | 16 | 0.606 | 47452.1 |
780 | 2022-03-15 11:07:02 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
779 | 2022-03-14 12:32:44 | hosts | 1 | 28756 | 16 | 0.720 | 39938.9 |
778 | 2022-03-13 18:39:54 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
777 | 2022-03-12 08:45:35 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
776 | 2022-03-08 14:44:38 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
775 | 2022-02-05 23:50:05 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
774 | 2022-02-03 20:56:35 | hosts | 1 | 28756 | 16 | 0.470 | 61183.0 |
773 | 2022-02-02 21:03:39 | hosts | 1 | 28756 | 16 | 0.530 | 54256.6 |
772 | 2022-02-01 20:05:38 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
771 | 2022-01-31 19:43:43 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
770 | 2022-01-13 00:00:16 | hosts | 2 | 53800 | 267 | 1.360 | 39558.8 |
769 | 2021-12-26 04:22:56 | hosts | 1 | 28756 | 16 | 0.546 | 52666.7 |
768 | 2021-12-05 01:30:16 | hosts | 1 | 28756 | 16 | 1.186 | 24246.2 |
767 | 2021-12-02 17:22:46 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
766 | 2021-11-01 23:26:27 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
765 | 2021-10-30 12:27:46 | hosts | 1 | 28756 | 16 | 0.530 | 54256.6 |
764 | 2021-10-29 09:19:54 | hosts | 1 | 28756 | 16 | 0.513 | 56054.6 |