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 |
941 | 2024-12-29 07:27:33 | hosts | 2 | 53800 | 267 | 6.790 | 7923.4 |
940 | 2024-12-25 09:10:16 | hosts | 1 | 28756 | 16 | 2.173 | 13233.3 |
939 | 2024-12-04 19:08:29 | hosts | 1 | 28756 | 16 | 0.440 | 65354.5 |
938 | 2024-11-27 14:54:17 | hosts | 2 | 53800 | 267 | 2.233 | 24093.1 |
937 | 2024-11-27 11:47:46 | hosts | 2 | 53800 | 267 | 7.736 | 6954.5 |
936 | 2024-11-27 10:14:36 | hosts | 2 | 53800 | 267 | 10.186 | 5281.8 |
935 | 2024-11-27 09:07:49 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
934 | 2024-11-25 07:56:58 | hosts | 1 | 28756 | 16 | 1.903 | 15110.9 |
933 | 2024-11-22 00:36:30 | hosts | 1 | 28756 | 16 | 2.533 | 11352.5 |
932 | 2024-11-07 08:38:08 | hosts | 1 | 28756 | 16 | 1.716 | 16757.6 |
931 | 2024-11-02 11:28:47 | hosts | 1 | 28756 | 16 | 0.436 | 65954.1 |
930 | 2024-10-28 05:34:28 | hosts | 2 | 53800 | 267 | 7.703 | 6984.3 |
929 | 2024-10-28 05:18:15 | hosts | 1 | 28756 | 16 | 4.373 | 6575.8 |
928 | 2024-10-26 04:12:20 | hosts | 1 | 28756 | 16 | 1.060 | 27128.3 |
927 | 2024-10-21 08:51:50 | hosts | 1 | 28756 | 16 | 2.780 | 10343.9 |
926 | 2024-10-20 16:07:20 | hosts | 2 | 53800 | 267 | 6.093 | 8829.8 |
925 | 2024-10-09 21:51:16 | hosts | 2 | 53800 | 267 | 12.253 | 4390.8 |
924 | 2024-10-08 15:52:28 | hosts | 2 | 53800 | 267 | 10.033 | 5362.3 |
923 | 2024-10-08 06:29:30 | hosts | 2 | 53800 | 267 | 11.156 | 4822.5 |
922 | 2024-10-08 06:29:25 | hosts | 1 | 28756 | 16 | 2.606 | 11034.5 |
921 | 2024-10-03 08:30:22 | hosts | 1 | 28756 | 16 | 2.843 | 10114.7 |
920 | 2024-09-28 01:20:03 | hosts | 1 | 28756 | 16 | 5.813 | 4946.8 |
919 | 2024-09-26 01:11:14 | hosts | 1 | 28756 | 16 | 1.906 | 15087.1 |
918 | 2024-09-09 02:07:27 | hosts | 1 | 28756 | 16 | 2.003 | 14356.5 |
917 | 2024-09-07 14:09:45 | hosts | 1 | 28756 | 16 | 1.876 | 15328.4 |
916 | 2024-09-04 10:36:41 | hosts | 2 | 53800 | 267 | 9.486 | 5671.5 |
915 | 2024-09-03 19:56:42 | hosts | 2 | 53800 | 267 | 15.783 | 3408.7 |
914 | 2024-09-02 22:11:24 | hosts | 1 | 28756 | 16 | 5.060 | 5683.0 |
913 | 2024-08-29 18:57:06 | hosts | 1 | 28756 | 16 | 4.703 | 6114.4 |
912 | 2024-08-28 22:03:55 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
911 | 2024-08-26 15:42:52 | hosts | 1 | 28756 | 16 | 2.016 | 14263.9 |
910 | 2024-08-08 23:34:51 | hosts | 1 | 28756 | 16 | 2.033 | 14144.6 |
909 | 2024-08-08 03:48:38 | hosts | 1 | 28756 | 16 | 0.623 | 46157.3 |
908 | 2024-08-02 10:58:45 | hosts | 2 | 53800 | 267 | 5.576 | 9648.5 |
907 | 2024-08-02 02:18:18 | hosts | 2 | 53800 | 267 | 3.373 | 15950.2 |
906 | 2024-08-02 02:18:04 | hosts | 1 | 28756 | 16 | 1.016 | 28303.1 |
905 | 2024-07-30 14:03:53 | hosts | 2 | 53800 | 267 | 2.983 | 18035.5 |
904 | 2024-07-29 17:02:22 | hosts | 2 | 53800 | 267 | 6.280 | 8566.9 |
903 | 2024-07-29 15:12:29 | hosts | 1 | 28756 | 16 | 0.483 | 59536.2 |
902 | 2024-07-28 12:44:55 | hosts | 1 | 28756 | 16 | 2.466 | 11661.0 |
901 | 2024-07-27 06:51:16 | hosts | 1 | 28756 | 16 | 2.266 | 12690.2 |
900 | 2024-07-24 20:11:46 | hosts | 1 | 28756 | 16 | 0.953 | 30174.2 |
899 | 2024-07-24 07:43:59 | hosts | 1 | 28756 | 16 | 1.000 | 28756.0 |
898 | 2024-07-23 02:36:48 | hosts | 1 | 28756 | 16 | 1.033 | 27837.4 |
897 | 2024-07-09 21:16:42 | hosts | 1 | 28756 | 16 | 2.406 | 11951.8 |
896 | 2024-07-07 15:05:39 | hosts | 2 | 53800 | 267 | 3.063 | 17564.5 |
895 | 2024-07-05 08:47:51 | hosts | 1 | 28756 | 16 | 2.860 | 10054.5 |
894 | 2024-07-05 05:25:42 | hosts | 1 | 28756 | 16 | 2.343 | 12273.2 |
893 | 2024-07-03 00:13:03 | hosts | 2 | 53800 | 267 | 3.423 | 15717.2 |
892 | 2024-07-03 00:12:56 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
891 | 2024-06-30 23:12:47 | hosts | 1 | 28756 | 16 | 1.656 | 17364.7 |
890 | 2024-06-29 10:19:21 | hosts | 1 | 28756 | 16 | 1.563 | 18398.0 |
889 | 2024-06-28 12:16:40 | hosts | 1 | 28756 | 16 | 2.393 | 12016.7 |
888 | 2024-06-28 02:27:08 | hosts | 1 | 28756 | 16 | 0.750 | 38341.3 |
887 | 2024-06-14 22:51:12 | hosts | 1 | 28756 | 16 | 1.016 | 28303.1 |
886 | 2024-06-14 22:50:36 | hosts | 1 | 28756 | 16 | 2.860 | 10054.5 |
885 | 2024-06-13 03:38:47 | hosts | 2 | 53800 | 267 | 6.050 | 8892.6 |
884 | 2024-06-12 03:16:01 | hosts | 2 | 53800 | 267 | 8.093 | 6647.7 |
883 | 2024-06-12 01:08:22 | hosts | 2 | 53800 | 267 | 6.220 | 8649.5 |
882 | 2024-06-12 01:05:19 | hosts | 2 | 53800 | 267 | 3.080 | 17467.5 |
881 | 2024-06-10 02:22:40 | hosts | 1 | 28756 | 16 | 2.266 | 12690.2 |
880 | 2024-06-10 00:32:02 | hosts | 1 | 28756 | 16 | 3.126 | 9199.0 |
879 | 2024-06-05 22:59:11 | hosts | 1 | 28756 | 16 | 0.533 | 53951.2 |
878 | 2024-06-03 14:09:47 | hosts | 1 | 28756 | 16 | 0.516 | 55728.7 |
877 | 2024-06-02 21:09:24 | hosts | 2 | 53800 | 267 | 6.826 | 7881.6 |
876 | 2024-06-02 21:09:20 | hosts | 1 | 28756 | 16 | 1.500 | 19170.7 |
875 | 2024-05-31 23:07:22 | hosts | 1 | 28756 | 16 | 1.843 | 15602.8 |
874 | 2024-05-31 23:00:36 | hosts | 2 | 53800 | 267 | 1.750 | 30742.9 |
873 | 2024-05-30 04:40:14 | hosts | 2 | 53800 | 267 | 8.813 | 6104.6 |
872 | 2024-05-30 04:20:15 | hosts | 1 | 28756 | 16 | 3.326 | 8645.8 |
871 | 2024-05-28 02:22:11 | hosts | 1 | 28756 | 16 | 2.063 | 13938.9 |
870 | 2024-05-04 06:42:55 | hosts | 1 | 28756 | 16 | 1.140 | 25224.6 |
869 | 2024-05-03 22:26:56 | hosts | 2 | 53800 | 267 | 1.830 | 29398.9 |
868 | 2024-05-03 21:18:21 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
867 | 2024-05-03 20:38:11 | hosts | 2 | 53800 | 267 | 1.623 | 33148.5 |
866 | 2024-05-03 19:41:36 | hosts | 1 | 28756 | 16 | 1.046 | 27491.4 |
865 | 2024-05-01 21:58:54 | hosts | 1 | 28756 | 16 | 1.250 | 23004.8 |
864 | 2024-04-28 10:33:44 | hosts | 1 | 28756 | 16 | 0.470 | 61183.0 |
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 |