History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trout"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1224 | 2024-03-27 01:13:39 | trout | 1 | 28756 | 8 | 0.516 | 55728.7 |
1223 | 2024-03-07 04:17:48 | trout | 1 | 28756 | 8 | 1.436 | 20025.1 |
1222 | 2024-03-05 19:06:04 | trout | 1 | 28756 | 8 | 1.640 | 17534.1 |
1221 | 2024-03-01 12:51:12 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1220 | 2024-02-25 18:20:43 | trout | 1 | 28756 | 8 | 0.546 | 52666.7 |
1219 | 2024-02-03 18:16:59 | trout | 1 | 28756 | 8 | 0.986 | 29164.3 |
1218 | 2024-01-29 08:40:51 | trout | 1 | 28756 | 8 | 0.513 | 56054.6 |
1217 | 2024-01-26 09:10:41 | trout | 1 | 28756 | 8 | 0.483 | 59536.2 |
1216 | 2024-01-18 11:59:16 | trout | 2 | 53800 | 110 | 1.766 | 30464.3 |
1215 | 2024-01-10 00:13:47 | trout | 1 | 28756 | 8 | 0.486 | 59168.7 |
1214 | 2023-12-27 18:24:19 | trout | 1 | 28756 | 8 | 0.500 | 57512.0 |
1213 | 2023-12-10 00:19:00 | trout | 2 | 53800 | 110 | 1.470 | 36598.6 |
1212 | 2023-12-03 13:46:00 | trout | 2 | 53800 | 110 | 1.563 | 34421.0 |
1211 | 2023-11-11 04:30:46 | trout | 1 | 28756 | 8 | 0.516 | 55728.7 |
1210 | 2023-11-10 15:37:00 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1209 | 2023-11-07 08:14:30 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1208 | 2023-10-28 22:04:21 | trout | 2 | 53800 | 110 | 3.343 | 16093.3 |
1207 | 2023-10-27 02:07:27 | trout | 1 | 28756 | 8 | 0.486 | 59168.7 |
1206 | 2023-10-20 17:16:04 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1205 | 2023-10-18 04:18:50 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1204 | 2023-10-16 05:49:41 | trout | 1 | 28756 | 8 | 0.530 | 54256.6 |
1203 | 2023-10-12 07:35:25 | trout | 1 | 28756 | 8 | 0.530 | 54256.6 |
1202 | 2023-10-04 09:03:20 | trout | 1 | 28756 | 8 | 0.423 | 67981.1 |
1201 | 2023-09-23 21:16:27 | trout | 1 | 28756 | 8 | 0.483 | 59536.2 |
1200 | 2023-09-14 05:21:17 | trout | 2 | 53800 | 110 | 1.393 | 38621.7 |
1199 | 2023-09-10 14:10:02 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1198 | 2023-09-03 15:01:24 | trout | 1 | 28756 | 8 | 0.516 | 55728.7 |
1197 | 2023-08-12 04:18:44 | trout | 1 | 28756 | 8 | 0.483 | 59536.2 |
1196 | 2023-08-06 12:52:04 | trout | 2 | 53800 | 110 | 1.360 | 39558.8 |
1195 | 2023-05-18 04:51:42 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1194 | 2023-05-13 13:22:52 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1193 | 2023-05-07 07:33:10 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1192 | 2023-04-17 01:46:07 | trout | 2 | 53800 | 110 | 1.343 | 40059.6 |
1191 | 2023-03-09 11:55:40 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1190 | 2023-01-23 20:49:40 | trout | 2 | 53800 | 110 | 1.373 | 39184.3 |
1189 | 2023-01-10 01:18:40 | trout | 1 | 28756 | 8 | 0.423 | 67981.1 |
1188 | 2022-12-30 18:42:27 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1187 | 2022-11-05 16:56:23 | trout | 2 | 53800 | 110 | 1.406 | 38264.6 |
1186 | 2022-09-19 12:12:22 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1185 | 2022-09-08 06:10:57 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1184 | 2022-09-01 06:16:16 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1183 | 2022-06-07 04:35:49 | trout | 2 | 53800 | 110 | 1.453 | 37026.8 |
1182 | 2022-04-30 21:41:36 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1181 | 2022-04-25 04:47:30 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1180 | 2022-01-22 02:34:14 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1179 | 2021-12-26 23:43:33 | trout | 1 | 28756 | 8 | 0.516 | 55728.7 |
1178 | 2021-12-04 07:00:31 | trout | 1 | 28756 | 8 | 0.483 | 59536.2 |
1177 | 2021-10-11 16:22:20 | trout | 1 | 28756 | 8 | 0.546 | 52666.7 |
1176 | 2021-09-13 09:22:08 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1175 | 2021-06-15 13:33:22 | trout | 1 | 28756 | 8 | 0.500 | 57512.0 |
1174 | 2021-06-09 06:47:17 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1173 | 2021-03-26 01:21:19 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1172 | 2021-03-10 06:48:33 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1171 | 2021-02-25 11:53:48 | trout | 2 | 53800 | 110 | 1.390 | 38705.0 |
1170 | 2021-01-09 06:12:28 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1169 | 2020-12-06 21:41:58 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1168 | 2020-10-30 14:58:22 | trout | 1 | 28756 | 8 | 0.606 | 47452.1 |
1167 | 2020-10-27 07:00:13 | trout | 1 | 28756 | 8 | 0.500 | 57512.0 |
1166 | 2020-10-25 04:22:56 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1165 | 2020-10-23 05:57:10 | trout | 1 | 28756 | 8 | 0.500 | 57512.0 |
1164 | 2020-10-13 23:11:30 | trout | 1 | 28756 | 8 | 0.530 | 54256.6 |
1163 | 2020-09-05 10:27:34 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1162 | 2020-08-18 22:52:28 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1161 | 2020-08-02 05:58:23 | trout | 1 | 28756 | 8 | 0.483 | 59536.2 |
1160 | 2020-07-29 23:17:21 | trout | 1 | 28756 | 8 | 0.580 | 49579.3 |
1159 | 2020-07-24 23:53:22 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1158 | 2020-07-23 06:17:25 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1157 | 2020-07-15 13:00:46 | trout | 1 | 28756 | 8 | 0.500 | 57512.0 |
1156 | 2020-06-02 11:16:31 | trout | 1 | 28756 | 8 | 0.500 | 57512.0 |
1155 | 2020-06-01 11:57:41 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1154 | 2020-05-29 10:14:07 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1153 | 2020-05-28 10:27:17 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1152 | 2020-05-27 09:52:36 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1151 | 2020-05-24 04:49:51 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1150 | 2020-05-23 05:27:21 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1149 | 2020-05-19 13:41:05 | trout | 1 | 28756 | 8 | 0.470 | 61183.0 |
1148 | 2020-05-16 08:01:22 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1147 | 2020-05-14 12:04:16 | trout | 1 | 28756 | 8 | 0.470 | 61183.0 |
1146 | 2020-05-12 10:27:38 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1145 | 2020-05-11 15:17:16 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1144 | 2020-05-11 11:10:57 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1143 | 2020-05-10 10:27:50 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1142 | 2020-05-09 10:24:23 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1141 | 2020-05-08 10:25:21 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1140 | 2020-05-07 09:45:53 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1139 | 2020-05-06 10:26:49 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1138 | 2020-05-05 09:52:06 | trout | 1 | 28756 | 8 | 0.530 | 54256.6 |
1137 | 2020-05-04 09:51:34 | trout | 1 | 28756 | 8 | 0.483 | 59536.2 |
1136 | 2020-05-03 09:50:52 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1135 | 2020-05-02 10:24:06 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1134 | 2020-05-01 09:49:25 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |
1133 | 2020-04-30 09:58:10 | trout | 1 | 28756 | 8 | 0.483 | 59536.2 |
1132 | 2020-04-29 10:03:25 | trout | 1 | 28756 | 8 | 0.440 | 65354.5 |
1131 | 2020-04-22 10:05:32 | trout | 1 | 28756 | 8 | 0.500 | 57512.0 |
1130 | 2020-04-21 14:55:54 | trout | 1 | 28756 | 8 | 0.516 | 55728.7 |
1129 | 2020-04-18 03:55:38 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1128 | 2020-04-17 04:40:49 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1127 | 2020-04-16 04:38:57 | trout | 1 | 28756 | 8 | 0.470 | 61183.0 |
1126 | 2020-04-15 03:56:02 | trout | 1 | 28756 | 8 | 0.436 | 65954.1 |
1125 | 2020-04-10 01:31:15 | trout | 1 | 28756 | 8 | 0.453 | 63479.0 |