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 |
987 | 2025-05-22 05:40:52 | hosts | 1 | 28756 | 16 | 0.970 | 29645.4 |
986 | 2025-05-16 01:37:55 | hosts | 1 | 28756 | 16 | 0.970 | 29645.4 |
985 | 2025-05-15 13:57:48 | hosts | 1 | 28756 | 16 | 0.783 | 36725.4 |
984 | 2025-05-11 21:41:45 | hosts | 1 | 28756 | 16 | 1.360 | 21144.1 |
983 | 2025-05-08 07:53:22 | hosts | 1 | 28756 | 16 | 3.313 | 8679.7 |
982 | 2025-05-08 07:46:03 | hosts | 1 | 28756 | 16 | 1.500 | 19170.7 |
981 | 2025-05-06 07:26:35 | hosts | 2 | 53800 | 267 | 8.220 | 6545.0 |
980 | 2025-05-05 16:30:35 | hosts | 1 | 28756 | 16 | 0.500 | 57512.0 |
979 | 2025-05-04 23:54:20 | hosts | 2 | 53800 | 267 | 4.173 | 12892.4 |
978 | 2025-05-03 21:16:46 | hosts | 1 | 28756 | 16 | 2.173 | 13233.3 |
977 | 2025-05-03 08:28:48 | hosts | 2 | 53800 | 267 | 1.593 | 33772.8 |
976 | 2025-04-29 19:57:52 | hosts | 1 | 28756 | 16 | 2.110 | 13628.4 |
975 | 2025-04-28 13:34:41 | hosts | 1 | 28756 | 16 | 2.406 | 11951.8 |
974 | 2025-04-19 23:15:51 | hosts | 1 | 28756 | 16 | 2.516 | 11429.3 |
973 | 2025-04-10 21:23:53 | hosts | 2 | 53800 | 267 | 4.440 | 12117.1 |
972 | 2025-04-09 08:54:04 | hosts | 2 | 53800 | 267 | 8.296 | 6485.1 |
971 | 2025-04-08 08:47:43 | hosts | 1 | 28756 | 16 | 3.766 | 7635.7 |
970 | 2025-04-08 07:09:18 | hosts | 1 | 28756 | 16 | 2.313 | 12432.3 |
969 | 2025-04-05 00:14:02 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
968 | 2025-03-28 21:08:08 | hosts | 1 | 28756 | 16 | 2.326 | 12362.9 |
967 | 2025-03-27 15:33:57 | hosts | 1 | 28756 | 16 | 1.390 | 20687.8 |
966 | 2025-03-14 22:57:39 | hosts | 1 | 28756 | 16 | 2.296 | 12524.4 |
965 | 2025-03-08 01:06:06 | hosts | 1 | 28756 | 16 | 1.046 | 27491.4 |
964 | 2025-03-07 17:14:05 | hosts | 1 | 28756 | 16 | 2.453 | 11722.8 |
963 | 2025-03-05 08:41:03 | hosts | 1 | 28756 | 16 | 0.906 | 31739.5 |
962 | 2025-03-03 15:10:30 | hosts | 1 | 28756 | 16 | 2.296 | 12524.4 |
961 | 2025-02-28 10:05:47 | hosts | 2 | 53800 | 267 | 6.046 | 8898.4 |
960 | 2025-02-28 02:13:21 | hosts | 2 | 53800 | 267 | 9.066 | 5934.3 |
959 | 2025-02-27 04:51:06 | hosts | 1 | 28756 | 16 | 2.720 | 10572.1 |
958 | 2025-02-26 05:35:17 | hosts | 1 | 28756 | 16 | 2.343 | 12273.2 |
957 | 2025-02-23 17:55:54 | hosts | 1 | 28756 | 16 | 0.966 | 29768.1 |
956 | 2025-02-05 12:58:41 | hosts | 2 | 53800 | 267 | 3.673 | 14647.4 |
955 | 2025-02-05 12:58:38 | hosts | 1 | 28756 | 16 | 0.906 | 31739.5 |
954 | 2025-02-04 15:06:34 | hosts | 1 | 28756 | 16 | 1.360 | 21144.1 |
953 | 2025-02-02 23:54:06 | hosts | 1 | 28756 | 16 | 3.500 | 8216.0 |
952 | 2025-01-28 14:58:23 | hosts | 2 | 53800 | 267 | 4.346 | 12379.2 |
951 | 2025-01-28 12:02:12 | hosts | 2 | 53800 | 267 | 8.063 | 6672.5 |
950 | 2025-01-28 11:02:25 | hosts | 2 | 53800 | 267 | 5.343 | 10069.2 |
949 | 2025-01-27 04:36:17 | hosts | 1 | 28756 | 16 | 2.673 | 10757.9 |
948 | 2025-01-26 17:19:50 | hosts | 1 | 28756 | 16 | 0.453 | 63479.0 |
947 | 2025-01-24 17:01:41 | hosts | 1 | 28756 | 16 | 1.406 | 20452.3 |
946 | 2025-01-13 18:16:48 | hosts | 1 | 28756 | 16 | 1.000 | 28756.0 |
945 | 2025-01-06 11:59:28 | hosts | 2 | 53800 | 267 | 7.296 | 7373.9 |
944 | 2025-01-06 11:59:27 | hosts | 1 | 28756 | 16 | 2.500 | 11502.4 |
943 | 2025-01-03 21:35:35 | hosts | 1 | 28756 | 16 | 2.343 | 12273.2 |
942 | 2025-01-03 04:23:24 | hosts | 1 | 28756 | 16 | 1.563 | 18398.0 |
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 |