History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hogan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1023 | 2024-12-31 12:51:49 | hogan | 1 | 28756 | 5 | 2.266 | 12690.2 |
1022 | 2024-12-30 11:33:05 | hogan | 3 | 83667 | 1001 | 22.313 | 3749.7 |
1021 | 2024-12-30 09:42:35 | hogan | 3 | 83667 | 1001 | 11.296 | 7406.8 |
1020 | 2024-12-30 09:42:38 | hogan | 2 | 53800 | 68 | 3.733 | 14412.0 |
1019 | 2024-12-30 09:41:27 | hogan | 1 | 28756 | 5 | 1.546 | 18600.3 |
1018 | 2024-12-29 06:25:35 | hogan | 1 | 28756 | 5 | 0.843 | 34111.5 |
1017 | 2024-12-28 19:31:14 | hogan | 2 | 53800 | 68 | 2.046 | 26295.2 |
1016 | 2024-12-28 19:31:11 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
1015 | 2024-12-12 16:12:27 | hogan | 1 | 28756 | 5 | 2.343 | 12273.2 |
1014 | 2024-12-10 00:06:19 | hogan | 1 | 28756 | 5 | 2.313 | 12432.3 |
1013 | 2024-12-10 00:02:46 | hogan | 3 | 83667 | 1001 | 22.720 | 3682.5 |
1012 | 2024-12-09 14:18:11 | hogan | 3 | 83667 | 1001 | 6.936 | 12062.7 |
1011 | 2024-12-05 13:27:54 | hogan | 3 | 83667 | 1001 | 12.970 | 6450.8 |
1010 | 2024-12-02 11:18:59 | hogan | 3 | 83667 | 1001 | 21.046 | 3975.4 |
1009 | 2024-11-30 08:20:39 | hogan | 3 | 83667 | 1001 | 27.220 | 3073.7 |
1008 | 2024-11-30 07:34:51 | hogan | 3 | 83667 | 1001 | 17.656 | 4738.7 |
1007 | 2024-11-30 07:34:50 | hogan | 2 | 53800 | 68 | 9.860 | 5456.4 |
1006 | 2024-11-30 07:23:59 | hogan | 1 | 28756 | 5 | 0.513 | 56054.6 |
1005 | 2024-11-28 20:56:09 | hogan | 1 | 28756 | 5 | 1.373 | 20943.9 |
1004 | 2024-11-28 05:39:47 | hogan | 1 | 28756 | 5 | 2.750 | 10456.7 |
1003 | 2024-11-16 03:17:11 | hogan | 3 | 83667 | 1001 | 9.860 | 8485.5 |
1002 | 2024-11-09 22:54:03 | hogan | 3 | 83667 | 1001 | 8.813 | 9493.6 |
1001 | 2024-11-09 22:54:05 | hogan | 2 | 53800 | 68 | 7.330 | 7339.7 |
1000 | 2024-11-09 19:27:53 | hogan | 1 | 28756 | 5 | 0.966 | 29768.1 |
999 | 2024-11-01 05:58:55 | hogan | 2 | 53800 | 68 | 3.923 | 13714.0 |
998 | 2024-11-01 04:54:31 | hogan | 3 | 83667 | 1001 | 15.406 | 5430.8 |
997 | 2024-10-31 01:04:49 | hogan | 3 | 83667 | 1001 | 3.830 | 21845.2 |
996 | 2024-10-30 17:33:22 | hogan | 3 | 83667 | 1001 | 20.016 | 4180.0 |
995 | 2024-10-30 17:33:18 | hogan | 2 | 53800 | 68 | 8.156 | 6596.4 |
994 | 2024-10-30 17:30:18 | hogan | 1 | 28756 | 5 | 1.203 | 23903.6 |
993 | 2024-10-29 04:52:50 | hogan | 1 | 28756 | 5 | 2.330 | 12341.6 |
992 | 2024-10-29 01:28:20 | hogan | 1 | 28756 | 5 | 0.516 | 55728.7 |
991 | 2024-10-21 11:15:34 | hogan | 1 | 28756 | 5 | 1.266 | 22714.1 |
990 | 2024-10-10 19:50:37 | hogan | 1 | 28756 | 5 | 2.156 | 13337.7 |
989 | 2024-10-10 16:08:30 | hogan | 3 | 83667 | 1001 | 8.500 | 9843.2 |
988 | 2024-10-01 22:38:50 | hogan | 2 | 53800 | 68 | 8.346 | 6446.2 |
987 | 2024-10-01 08:44:06 | hogan | 3 | 83667 | 1001 | 32.300 | 2590.3 |
986 | 2024-09-30 23:40:26 | hogan | 1 | 28756 | 5 | 2.876 | 9998.6 |
985 | 2024-09-30 21:45:19 | hogan | 3 | 83667 | 1001 | 27.986 | 2989.6 |
984 | 2024-09-30 13:01:08 | hogan | 3 | 83667 | 1001 | 3.623 | 23093.3 |
983 | 2024-09-30 13:01:06 | hogan | 2 | 53800 | 68 | 1.576 | 34137.1 |
982 | 2024-09-30 13:01:05 | hogan | 1 | 28756 | 5 | 0.456 | 63061.4 |
981 | 2024-09-28 19:35:23 | hogan | 1 | 28756 | 5 | 2.066 | 13918.7 |
980 | 2024-09-23 03:37:04 | hogan | 1 | 28756 | 5 | 3.076 | 9348.5 |
979 | 2024-09-10 00:22:57 | hogan | 1 | 28756 | 5 | 3.360 | 8558.3 |
978 | 2024-09-10 00:19:52 | hogan | 1 | 28756 | 5 | 3.126 | 9199.0 |
977 | 2024-09-09 03:11:11 | hogan | 1 | 28756 | 5 | 2.890 | 9950.2 |
976 | 2024-08-31 07:01:54 | hogan | 3 | 83667 | 1001 | 21.406 | 3908.6 |
975 | 2024-08-31 06:25:28 | hogan | 1 | 28756 | 5 | 4.143 | 6940.9 |
974 | 2024-08-31 05:09:38 | hogan | 3 | 83667 | 1001 | 32.770 | 2553.2 |
973 | 2024-08-30 17:27:16 | hogan | 1 | 28756 | 5 | 3.453 | 8327.8 |
972 | 2024-08-29 11:00:07 | hogan | 3 | 83667 | 1001 | 37.643 | 2222.6 |
971 | 2024-08-29 10:19:47 | hogan | 3 | 83667 | 1001 | 15.206 | 5502.2 |
970 | 2024-08-29 10:19:45 | hogan | 2 | 53800 | 68 | 5.890 | 9134.1 |
969 | 2024-08-29 10:19:36 | hogan | 1 | 28756 | 5 | 1.890 | 15214.8 |
968 | 2024-08-21 05:51:28 | hogan | 3 | 83667 | 1001 | 31.563 | 2650.8 |
967 | 2024-08-14 10:31:06 | hogan | 1 | 28756 | 5 | 9.813 | 2930.4 |
966 | 2024-08-10 01:48:00 | hogan | 2 | 53800 | 68 | 4.326 | 12436.4 |
965 | 2024-08-10 01:35:51 | hogan | 1 | 28756 | 5 | 0.546 | 52666.7 |
964 | 2024-08-07 03:36:58 | hogan | 1 | 28756 | 5 | 1.546 | 18600.3 |
963 | 2024-08-02 06:47:07 | hogan | 3 | 83667 | 1001 | 14.830 | 5641.7 |
962 | 2024-08-01 15:50:17 | hogan | 3 | 83667 | 1001 | 15.970 | 5239.0 |
961 | 2024-07-30 23:09:54 | hogan | 3 | 83667 | 1001 | 10.593 | 7898.3 |
960 | 2024-07-30 19:02:23 | hogan | 2 | 53800 | 68 | 6.030 | 8922.1 |
959 | 2024-07-30 18:20:05 | hogan | 1 | 28756 | 5 | 0.513 | 56054.6 |
958 | 2024-07-30 08:52:05 | hogan | 3 | 83667 | 1001 | 21.050 | 3974.7 |
957 | 2024-07-30 08:52:07 | hogan | 2 | 53800 | 68 | 2.970 | 18114.5 |
956 | 2024-07-30 07:57:31 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
955 | 2024-07-28 08:43:51 | hogan | 1 | 28756 | 5 | 2.423 | 11867.9 |
954 | 2024-07-28 05:59:40 | hogan | 1 | 28756 | 5 | 1.203 | 23903.6 |
953 | 2024-07-10 18:36:13 | hogan | 1 | 28756 | 5 | 2.703 | 10638.5 |
952 | 2024-07-07 09:07:26 | hogan | 1 | 28756 | 5 | 1.216 | 23648.0 |
951 | 2024-07-06 21:15:11 | hogan | 1 | 28756 | 5 | 1.750 | 16432.0 |
950 | 2024-07-05 23:17:42 | hogan | 1 | 28756 | 5 | 1.080 | 26625.9 |
949 | 2024-07-05 23:16:18 | hogan | 1 | 28756 | 5 | 2.000 | 14378.0 |
948 | 2024-06-30 21:31:07 | hogan | 1 | 28756 | 5 | 1.516 | 18968.3 |
947 | 2024-06-30 17:33:18 | hogan | 1 | 28756 | 5 | 1.906 | 15087.1 |
946 | 2024-06-30 10:12:45 | hogan | 2 | 53800 | 68 | 7.686 | 6999.7 |
945 | 2024-06-30 07:39:04 | hogan | 3 | 83667 | 1001 | 20.566 | 4068.2 |
944 | 2024-06-30 07:25:24 | hogan | 3 | 83667 | 1001 | 17.300 | 4836.2 |
943 | 2024-06-30 07:25:24 | hogan | 2 | 53800 | 68 | 4.080 | 13186.3 |
942 | 2024-06-30 07:15:20 | hogan | 1 | 28756 | 5 | 0.516 | 55728.7 |
941 | 2024-06-28 02:20:59 | hogan | 1 | 28756 | 5 | 1.483 | 19390.4 |
940 | 2024-06-28 01:27:40 | hogan | 2 | 53800 | 68 | 7.313 | 7356.8 |
939 | 2024-06-27 23:54:39 | hogan | 1 | 28756 | 5 | 1.530 | 18794.8 |
938 | 2024-06-16 20:19:49 | hogan | 1 | 28756 | 5 | 0.796 | 36125.6 |
937 | 2024-06-05 07:04:48 | hogan | 1 | 28756 | 5 | 0.513 | 56054.6 |
936 | 2024-06-03 14:19:56 | hogan | 2 | 53800 | 68 | 3.253 | 16538.6 |
935 | 2024-06-03 14:19:24 | hogan | 3 | 83667 | 1001 | 8.063 | 10376.7 |
934 | 2024-06-03 01:26:53 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
933 | 2024-06-02 00:47:05 | hogan | 2 | 53800 | 68 | 3.030 | 17755.8 |
932 | 2024-06-02 00:45:33 | hogan | 3 | 83667 | 1001 | 3.970 | 21074.8 |
931 | 2024-05-30 21:55:04 | hogan | 1 | 28756 | 5 | 0.513 | 56054.6 |
930 | 2024-05-30 17:54:31 | hogan | 3 | 83667 | 1001 | 16.500 | 5070.7 |
929 | 2024-05-28 11:36:23 | hogan | 1 | 28756 | 5 | 1.843 | 15602.8 |
928 | 2024-05-06 06:19:55 | hogan | 1 | 28756 | 5 | 0.500 | 57512.0 |
927 | 2024-04-30 22:36:02 | hogan | 2 | 53800 | 68 | 1.670 | 32215.6 |
926 | 2024-04-30 22:35:30 | hogan | 3 | 83667 | 1001 | 3.576 | 23396.8 |
925 | 2024-04-30 19:54:15 | hogan | 1 | 28756 | 5 | 0.530 | 54256.6 |
924 | 2024-04-30 06:14:09 | hogan | 1 | 28756 | 5 | 0.530 | 54256.6 |