History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1254 | 2024-04-27 09:46:21 | perch | 1 | 28756 | 6 | 0.783 | 36725.4 |
1253 | 2024-04-26 08:34:44 | perch | 1 | 28756 | 6 | 0.703 | 40904.7 |
1252 | 2024-04-24 23:56:36 | perch | 1 | 28756 | 6 | 0.530 | 54256.6 |
1251 | 2024-04-05 05:45:46 | perch | 1 | 28756 | 6 | 1.703 | 16885.5 |
1250 | 2024-04-03 03:43:36 | perch | 2 | 53800 | 95 | 1.983 | 27130.6 |
1249 | 2024-04-03 03:36:53 | perch | 1 | 28756 | 6 | 1.250 | 23004.8 |
1248 | 2024-04-02 22:45:23 | perch | 3 | 83667 | 887 | 4.733 | 17677.4 |
1247 | 2024-03-31 16:19:22 | perch | 3 | 83667 | 887 | 7.516 | 11131.9 |
1246 | 2024-03-31 09:52:18 | perch | 2 | 53800 | 95 | 3.686 | 14595.8 |
1245 | 2024-03-31 08:49:25 | perch | 3 | 83667 | 887 | 4.423 | 18916.3 |
1244 | 2024-03-31 08:49:15 | perch | 1 | 28756 | 6 | 0.513 | 56054.6 |
1243 | 2024-03-29 02:20:14 | perch | 1 | 28756 | 6 | 1.046 | 27491.4 |
1242 | 2024-03-25 22:16:46 | perch | 2 | 53800 | 95 | 1.643 | 32745.0 |
1241 | 2024-03-25 22:16:10 | perch | 3 | 83667 | 887 | 7.580 | 11037.9 |
1240 | 2024-03-25 02:27:33 | perch | 2 | 53800 | 95 | 3.406 | 15795.7 |
1239 | 2024-03-25 02:25:33 | perch | 3 | 83667 | 887 | 4.126 | 20278.0 |
1238 | 2024-03-24 05:57:01 | perch | 3 | 83667 | 887 | 3.343 | 25027.5 |
1237 | 2024-03-17 17:02:37 | perch | 2 | 53800 | 95 | 2.610 | 20613.0 |
1236 | 2024-03-07 01:09:09 | perch | 1 | 28756 | 6 | 0.466 | 61708.2 |
1235 | 2024-03-01 05:56:56 | perch | 1 | 28756 | 6 | 0.516 | 55728.7 |
1234 | 2024-02-28 01:03:06 | perch | 1 | 28756 | 6 | 0.546 | 52666.7 |
1233 | 2024-01-28 22:23:09 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1232 | 2024-01-28 17:38:59 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1231 | 2024-01-22 09:00:26 | perch | 3 | 83667 | 887 | 3.720 | 22491.1 |
1230 | 2024-01-16 23:14:32 | perch | 3 | 83667 | 887 | 3.326 | 25155.4 |
1229 | 2024-01-16 23:14:29 | perch | 2 | 53800 | 95 | 1.390 | 38705.0 |
1228 | 2024-01-15 16:42:57 | perch | 1 | 28756 | 6 | 0.440 | 65354.5 |
1227 | 2023-12-28 13:23:20 | perch | 3 | 83667 | 887 | 3.703 | 22594.4 |
1226 | 2023-12-28 13:23:18 | perch | 2 | 53800 | 95 | 1.420 | 37887.3 |
1225 | 2023-12-02 03:09:26 | perch | 2 | 53800 | 95 | 1.390 | 38705.0 |
1224 | 2023-12-01 08:19:13 | perch | 3 | 83667 | 887 | 3.436 | 24350.1 |
1223 | 2023-11-17 22:38:05 | perch | 1 | 28756 | 6 | 0.530 | 54256.6 |
1222 | 2023-11-13 09:17:25 | perch | 1 | 28756 | 6 | 0.483 | 59536.2 |
1221 | 2023-11-11 23:26:30 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1220 | 2023-11-04 23:10:00 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1219 | 2023-11-04 11:52:32 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1218 | 2023-10-24 07:07:22 | perch | 1 | 28756 | 6 | 0.436 | 65954.1 |
1217 | 2023-10-18 05:55:46 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1216 | 2023-10-12 00:52:31 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1215 | 2023-10-04 08:52:03 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1214 | 2023-09-29 12:40:20 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1213 | 2023-09-22 12:11:54 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1212 | 2023-08-31 23:24:07 | perch | 2 | 53800 | 95 | 1.356 | 39675.5 |
1211 | 2023-08-30 23:50:15 | perch | 1 | 28756 | 6 | 0.420 | 68466.7 |
1210 | 2023-08-29 18:31:09 | perch | 3 | 83667 | 887 | 3.703 | 22594.4 |
1209 | 2023-07-12 07:12:41 | perch | 1 | 28756 | 6 | 0.466 | 61708.2 |
1208 | 2023-06-02 11:52:45 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1207 | 2023-05-22 08:13:10 | perch | 3 | 83667 | 887 | 3.250 | 25743.7 |
1206 | 2023-05-19 10:47:17 | perch | 2 | 53800 | 95 | 1.563 | 34421.0 |
1205 | 2023-05-18 23:04:18 | perch | 3 | 83667 | 887 | 3.500 | 23904.9 |
1204 | 2023-05-14 13:16:01 | perch | 3 | 83667 | 887 | 3.546 | 23594.8 |
1203 | 2023-04-24 23:40:46 | perch | 2 | 53800 | 95 | 1.763 | 30516.2 |
1202 | 2023-03-26 14:11:02 | perch | 1 | 28756 | 6 | 0.420 | 68466.7 |
1201 | 2023-03-24 16:32:34 | perch | 1 | 28756 | 6 | 0.483 | 59536.2 |
1200 | 2023-03-19 08:03:48 | perch | 2 | 53800 | 95 | 1.403 | 38346.4 |
1199 | 2023-02-24 16:04:25 | perch | 2 | 53800 | 95 | 1.376 | 39098.8 |
1198 | 2023-02-20 20:19:10 | perch | 3 | 83667 | 887 | 3.250 | 25743.7 |
1197 | 2023-01-10 03:03:14 | perch | 1 | 28756 | 6 | 0.436 | 65954.1 |
1196 | 2022-12-06 13:21:05 | perch | 1 | 28756 | 6 | 0.440 | 65354.5 |
1195 | 2022-12-05 20:32:29 | perch | 2 | 53800 | 95 | 1.356 | 39675.5 |
1194 | 2022-12-01 16:04:08 | perch | 3 | 83667 | 887 | 3.313 | 25254.2 |
1193 | 2022-11-25 08:32:51 | perch | 1 | 28756 | 6 | 0.436 | 65954.1 |
1192 | 2022-10-15 06:48:14 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1191 | 2022-09-07 23:44:53 | perch | 1 | 28756 | 6 | 0.483 | 59536.2 |
1190 | 2022-08-03 00:50:32 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1189 | 2022-08-03 00:36:01 | perch | 1 | 28756 | 6 | 0.466 | 61708.2 |
1188 | 2022-07-20 06:06:10 | perch | 3 | 83667 | 887 | 3.296 | 25384.4 |
1187 | 2022-07-19 16:37:09 | perch | 2 | 53800 | 95 | 1.440 | 37361.1 |
1186 | 2022-07-17 09:38:02 | perch | 2 | 53800 | 95 | 1.470 | 36598.6 |
1185 | 2022-07-09 14:15:55 | perch | 3 | 83667 | 887 | 3.296 | 25384.4 |
1184 | 2022-06-06 00:41:26 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1183 | 2022-04-01 13:16:13 | perch | 1 | 28756 | 6 | 0.546 | 52666.7 |
1182 | 2022-02-25 17:27:28 | perch | 2 | 53800 | 95 | 1.406 | 38264.6 |
1181 | 2022-02-23 12:32:02 | perch | 2 | 53800 | 95 | 2.046 | 26295.2 |
1180 | 2022-02-18 01:40:55 | perch | 1 | 28756 | 6 | 0.466 | 61708.2 |
1179 | 2021-12-11 13:27:37 | perch | 1 | 28756 | 6 | 0.533 | 53951.2 |
1178 | 2021-12-07 07:13:01 | perch | 1 | 28756 | 6 | 0.483 | 59536.2 |
1177 | 2021-11-19 15:52:54 | perch | 2 | 53800 | 95 | 1.626 | 33087.3 |
1176 | 2021-10-20 20:15:15 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1175 | 2021-09-11 22:48:20 | perch | 2 | 53800 | 95 | 1.640 | 32804.9 |
1174 | 2021-09-10 19:09:09 | perch | 1 | 28756 | 6 | 0.436 | 65954.1 |
1173 | 2021-08-28 15:59:01 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1172 | 2021-08-24 04:12:34 | perch | 1 | 28756 | 6 | 0.516 | 55728.7 |
1171 | 2021-07-24 06:02:21 | perch | 1 | 28756 | 6 | 0.483 | 59536.2 |
1170 | 2021-06-21 04:27:08 | perch | 2 | 53800 | 95 | 1.686 | 31909.8 |
1169 | 2021-05-24 11:59:59 | perch | 1 | 28756 | 6 | 0.546 | 52666.7 |
1168 | 2021-05-14 06:47:45 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1167 | 2021-05-08 04:48:19 | perch | 3 | 83667 | 887 | 3.826 | 21868.0 |
1166 | 2021-05-03 11:04:38 | perch | 2 | 53800 | 95 | 1.593 | 33772.8 |
1165 | 2021-04-13 08:31:10 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1164 | 2021-03-17 01:56:54 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1163 | 2021-02-18 22:54:18 | perch | 1 | 28756 | 6 | 0.513 | 56054.6 |
1162 | 2021-02-02 07:20:51 | perch | 3 | 83667 | 887 | 3.453 | 24230.2 |
1161 | 2021-01-31 05:34:21 | perch | 3 | 83667 | 887 | 3.796 | 22040.8 |
1160 | 2021-01-26 19:20:07 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1159 | 2021-01-16 18:27:00 | perch | 2 | 53800 | 95 | 1.390 | 38705.0 |
1158 | 2020-12-29 04:09:14 | perch | 1 | 28756 | 6 | 0.453 | 63479.0 |
1157 | 2020-11-21 23:36:30 | perch | 2 | 53800 | 95 | 1.373 | 39184.3 |
1156 | 2020-11-15 00:26:08 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1155 | 2020-11-01 19:19:57 | perch | 2 | 53800 | 95 | 1.483 | 36277.8 |