History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"brad"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1116 | 2024-03-29 01:07:08 | brad | 2 | 29872 | 276 | 1.986 | 15041.3 |
1115 | 2024-03-28 23:50:51 | brad | 1 | 13983 | 22 | 0.826 | 16928.6 |
1114 | 2024-03-28 19:15:07 | brad | 2 | 29872 | 276 | 3.190 | 9364.3 |
1113 | 2024-03-28 17:49:08 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1112 | 2024-03-14 01:59:05 | brad | 1 | 13983 | 22 | 0.293 | 47723.5 |
1111 | 2024-03-02 12:56:08 | brad | 1 | 13983 | 22 | 0.516 | 27098.8 |
1110 | 2024-02-26 19:21:45 | brad | 1 | 13983 | 22 | 0.513 | 27257.3 |
1109 | 2024-02-05 15:34:54 | brad | 2 | 29872 | 276 | 1.033 | 28917.7 |
1108 | 2024-02-05 13:06:11 | brad | 2 | 29872 | 276 | 0.970 | 30795.9 |
1107 | 2024-02-04 02:36:35 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1106 | 2024-01-29 19:23:16 | brad | 1 | 13983 | 22 | 0.236 | 59250.0 |
1105 | 2024-01-27 18:52:01 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1104 | 2024-01-21 05:11:20 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1103 | 2024-01-14 02:53:36 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1102 | 2024-01-03 13:15:57 | brad | 2 | 29872 | 276 | 1.673 | 17855.3 |
1101 | 2023-12-29 07:37:48 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1100 | 2023-12-28 01:36:08 | brad | 1 | 13983 | 22 | 0.236 | 59250.0 |
1099 | 2023-12-27 06:59:08 | brad | 1 | 13983 | 22 | 0.266 | 52567.7 |
1098 | 2023-12-21 22:59:16 | brad | 2 | 29872 | 276 | 0.750 | 39829.3 |
1097 | 2023-12-16 18:14:54 | brad | 2 | 29872 | 276 | 0.750 | 39829.3 |
1096 | 2023-11-21 17:19:18 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1095 | 2023-11-19 01:11:34 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1094 | 2023-11-15 17:52:20 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1093 | 2023-11-15 00:11:00 | brad | 2 | 29872 | 276 | 0.830 | 35990.4 |
1092 | 2023-11-12 22:15:15 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1091 | 2023-11-12 10:46:05 | brad | 2 | 29872 | 276 | 0.826 | 36164.6 |
1090 | 2023-11-11 20:54:30 | brad | 1 | 13983 | 22 | 0.200 | 69915.0 |
1089 | 2023-11-02 07:29:02 | brad | 1 | 13983 | 22 | 0.253 | 55268.8 |
1088 | 2023-11-02 06:50:39 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1087 | 2023-10-31 05:44:56 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1086 | 2023-10-25 20:09:57 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1085 | 2023-10-21 12:08:02 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1084 | 2023-10-18 13:23:30 | brad | 1 | 13983 | 22 | 0.283 | 49409.9 |
1083 | 2023-10-16 07:28:11 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1082 | 2023-10-11 16:51:35 | brad | 1 | 13983 | 22 | 0.236 | 59250.0 |
1081 | 2023-10-04 08:47:03 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1080 | 2023-09-23 09:01:24 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1079 | 2023-09-15 00:54:57 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1078 | 2023-09-11 05:51:09 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1077 | 2023-08-30 00:40:22 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1076 | 2023-08-18 23:59:43 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1075 | 2023-08-14 20:16:20 | brad | 2 | 29872 | 276 | 0.860 | 34734.9 |
1074 | 2023-08-12 02:56:48 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1073 | 2023-08-01 10:50:38 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1072 | 2023-05-13 04:51:27 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1071 | 2023-04-27 05:46:32 | brad | 2 | 29872 | 276 | 0.750 | 39829.3 |
1070 | 2023-04-20 08:31:44 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1069 | 2023-03-26 23:37:48 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1068 | 2023-01-29 08:02:42 | brad | 2 | 29872 | 276 | 0.733 | 40753.1 |
1067 | 2023-01-07 22:58:56 | brad | 1 | 13983 | 22 | 0.360 | 38841.7 |
1066 | 2022-12-30 17:55:33 | brad | 1 | 13983 | 22 | 0.200 | 69915.0 |
1065 | 2022-12-26 18:42:41 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1064 | 2022-12-24 12:43:05 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1063 | 2022-12-18 22:46:47 | brad | 2 | 29872 | 276 | 0.826 | 36164.6 |
1062 | 2022-12-14 16:51:32 | brad | 2 | 29872 | 276 | 0.780 | 38297.4 |
1061 | 2022-11-25 21:13:01 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1060 | 2022-11-09 18:38:10 | brad | 2 | 29872 | 276 | 0.830 | 35990.4 |
1059 | 2022-09-24 03:45:06 | brad | 1 | 13983 | 22 | 0.360 | 38841.7 |
1058 | 2022-09-18 04:04:47 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1057 | 2022-09-11 18:21:27 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1056 | 2022-09-10 14:10:31 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1055 | 2022-09-03 11:11:37 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1054 | 2022-09-03 09:42:09 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1053 | 2022-08-26 06:14:03 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1052 | 2022-08-25 21:14:09 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1051 | 2022-08-23 09:09:02 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1050 | 2022-08-18 07:05:51 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1049 | 2022-08-10 12:26:02 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1048 | 2022-08-06 15:10:04 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1047 | 2022-07-29 20:19:46 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1046 | 2022-07-28 13:15:03 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1045 | 2022-07-17 21:07:41 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1044 | 2022-07-17 20:39:45 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1043 | 2022-07-03 03:41:35 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1042 | 2022-07-02 07:54:58 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1041 | 2022-06-16 03:53:23 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1040 | 2022-06-15 18:48:37 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1039 | 2022-06-15 14:29:23 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1038 | 2022-06-12 15:47:44 | brad | 2 | 29872 | 276 | 0.736 | 40587.0 |
1037 | 2022-06-08 15:55:53 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1036 | 2022-06-08 13:32:59 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1035 | 2022-06-07 04:15:59 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1034 | 2022-06-01 18:52:37 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1033 | 2022-06-01 11:28:40 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1032 | 2022-05-26 01:11:45 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1031 | 2022-05-25 14:48:49 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |
1030 | 2022-05-02 03:56:07 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1029 | 2022-05-01 12:54:11 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1028 | 2022-04-30 19:16:50 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1027 | 2022-04-30 04:56:09 | brad | 1 | 13983 | 22 | 0.216 | 64736.1 |
1026 | 2022-04-29 09:56:40 | brad | 1 | 13983 | 22 | 0.293 | 47723.5 |
1025 | 2022-04-28 22:57:47 | brad | 1 | 13983 | 22 | 0.310 | 45106.5 |
1024 | 2022-04-28 16:26:55 | brad | 1 | 13983 | 22 | 0.220 | 63559.1 |
1023 | 2022-04-28 13:10:51 | brad | 1 | 13983 | 22 | 0.470 | 29751.1 |
1022 | 2022-03-30 22:51:32 | brad | 1 | 13983 | 22 | 0.293 | 47723.5 |
1021 | 2022-03-30 10:55:03 | brad | 1 | 13983 | 22 | 0.203 | 68881.8 |
1020 | 2022-03-29 20:16:09 | brad | 1 | 13983 | 22 | 0.296 | 47239.9 |
1019 | 2022-03-29 07:49:28 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1018 | 2022-03-28 08:44:16 | brad | 1 | 13983 | 22 | 0.250 | 55932.0 |
1017 | 2022-03-27 16:37:48 | brad | 1 | 13983 | 22 | 0.233 | 60012.9 |