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 |
1350 | 2024-12-28 05:46:58 | perch | 1 | 28756 | 6 | 1.220 | 23570.5 |
1349 | 2024-12-28 02:32:33 | perch | 2 | 53800 | 95 | 2.500 | 21520.0 |
1348 | 2024-12-28 02:04:32 | perch | 3 | 83667 | 887 | 18.533 | 4514.5 |
1347 | 2024-12-27 22:27:05 | perch | 2 | 53800 | 95 | 12.843 | 4189.1 |
1346 | 2024-12-27 20:27:25 | perch | 2 | 53800 | 95 | 8.110 | 6633.8 |
1345 | 2024-12-27 17:45:00 | perch | 3 | 83667 | 887 | 10.936 | 7650.6 |
1344 | 2024-12-27 17:22:18 | perch | 3 | 83667 | 887 | 10.000 | 8366.7 |
1343 | 2024-12-27 17:22:18 | perch | 2 | 53800 | 95 | 8.483 | 6342.1 |
1342 | 2024-12-27 17:19:15 | perch | 1 | 28756 | 6 | 2.326 | 12362.9 |
1341 | 2024-12-26 19:01:05 | perch | 1 | 28756 | 6 | 1.423 | 20208.0 |
1340 | 2024-12-23 20:24:44 | perch | 3 | 83667 | 887 | 17.500 | 4781.0 |
1339 | 2024-12-22 22:08:00 | perch | 2 | 53800 | 95 | 2.283 | 23565.5 |
1338 | 2024-12-07 00:57:46 | perch | 1 | 28756 | 6 | 1.250 | 23004.8 |
1337 | 2024-11-28 22:20:56 | perch | 3 | 83667 | 887 | 13.953 | 5996.3 |
1336 | 2024-11-28 01:57:55 | perch | 1 | 28756 | 6 | 0.563 | 51076.4 |
1335 | 2024-11-27 20:41:19 | perch | 2 | 53800 | 95 | 11.266 | 4775.4 |
1334 | 2024-11-27 19:50:16 | perch | 3 | 83667 | 887 | 18.360 | 4557.0 |
1333 | 2024-11-27 17:18:18 | perch | 3 | 83667 | 887 | 19.096 | 4381.4 |
1332 | 2024-11-27 15:26:45 | perch | 3 | 83667 | 887 | 4.060 | 20607.6 |
1331 | 2024-11-27 15:26:46 | perch | 2 | 53800 | 95 | 1.703 | 31591.3 |
1330 | 2024-11-27 15:26:37 | perch | 1 | 28756 | 6 | 0.513 | 56054.6 |
1329 | 2024-11-26 16:12:05 | perch | 2 | 53800 | 95 | 6.720 | 8006.0 |
1328 | 2024-11-26 15:23:55 | perch | 2 | 53800 | 95 | 8.053 | 6680.7 |
1327 | 2024-11-26 15:23:10 | perch | 1 | 28756 | 6 | 1.390 | 20687.8 |
1326 | 2024-11-06 22:35:46 | perch | 1 | 28756 | 6 | 2.280 | 12612.3 |
1325 | 2024-10-29 02:21:45 | perch | 3 | 83667 | 887 | 10.016 | 8353.3 |
1324 | 2024-10-29 00:41:23 | perch | 1 | 28756 | 6 | 1.733 | 16593.2 |
1323 | 2024-10-28 21:32:53 | perch | 2 | 53800 | 95 | 8.750 | 6148.6 |
1322 | 2024-10-28 15:27:22 | perch | 3 | 83667 | 887 | 15.003 | 5576.7 |
1321 | 2024-10-28 13:51:29 | perch | 3 | 83667 | 887 | 18.626 | 4491.9 |
1320 | 2024-10-28 12:12:15 | perch | 3 | 83667 | 887 | 23.503 | 3559.8 |
1319 | 2024-10-28 12:12:17 | perch | 2 | 53800 | 95 | 4.063 | 13241.4 |
1318 | 2024-10-28 11:36:43 | perch | 1 | 28756 | 6 | 0.436 | 65954.1 |
1317 | 2024-10-26 12:01:07 | perch | 1 | 28756 | 6 | 2.483 | 11581.2 |
1316 | 2024-10-25 12:12:12 | perch | 1 | 28756 | 6 | 1.013 | 28387.0 |
1315 | 2024-10-25 12:09:26 | perch | 1 | 28756 | 6 | 2.313 | 12432.3 |
1314 | 2024-10-07 21:50:24 | perch | 1 | 28756 | 6 | 3.533 | 8139.3 |
1313 | 2024-09-29 07:26:25 | perch | 2 | 53800 | 95 | 9.720 | 5535.0 |
1312 | 2024-09-29 01:11:54 | perch | 3 | 83667 | 887 | 32.220 | 2596.7 |
1311 | 2024-09-28 20:17:54 | perch | 1 | 28756 | 6 | 3.420 | 8408.2 |
1310 | 2024-09-28 14:29:27 | perch | 2 | 53800 | 95 | 18.483 | 2910.8 |
1309 | 2024-09-28 14:17:35 | perch | 3 | 83667 | 887 | 41.423 | 2019.8 |
1308 | 2024-09-28 11:59:07 | perch | 3 | 83667 | 887 | 29.626 | 2824.1 |
1307 | 2024-09-28 06:01:13 | perch | 3 | 83667 | 887 | 31.736 | 2636.3 |
1306 | 2024-09-28 06:01:13 | perch | 2 | 53800 | 95 | 14.546 | 3698.6 |
1305 | 2024-09-28 05:46:23 | perch | 1 | 28756 | 6 | 0.533 | 53951.2 |
1304 | 2024-09-26 07:52:38 | perch | 1 | 28756 | 6 | 2.966 | 9695.2 |
1303 | 2024-09-07 10:22:21 | perch | 1 | 28756 | 6 | 3.753 | 7662.1 |
1302 | 2024-08-29 19:08:53 | perch | 1 | 28756 | 6 | 4.703 | 6114.4 |
1301 | 2024-08-29 17:13:55 | perch | 1 | 28756 | 6 | 5.186 | 5544.9 |
1300 | 2024-08-29 02:35:30 | perch | 2 | 53800 | 95 | 18.546 | 2900.9 |
1299 | 2024-08-29 00:29:47 | perch | 2 | 53800 | 95 | 6.063 | 8873.5 |
1298 | 2024-08-28 22:54:26 | perch | 3 | 83667 | 887 | 34.643 | 2415.1 |
1297 | 2024-08-28 22:54:19 | perch | 2 | 53800 | 95 | 7.170 | 7503.5 |
1296 | 2024-08-28 22:34:04 | perch | 1 | 28756 | 6 | 0.943 | 30494.2 |
1295 | 2024-08-27 05:19:10 | perch | 1 | 28756 | 6 | 1.780 | 16155.1 |
1294 | 2024-08-25 21:53:21 | perch | 3 | 83667 | 887 | 32.223 | 2596.5 |
1293 | 2024-08-24 21:28:45 | perch | 3 | 83667 | 887 | 34.656 | 2414.2 |
1292 | 2024-08-20 22:30:30 | perch | 3 | 83667 | 887 | 26.936 | 3106.1 |
1291 | 2024-08-20 04:46:22 | perch | 2 | 53800 | 95 | 9.253 | 5814.3 |
1290 | 2024-08-19 10:39:37 | perch | 3 | 83667 | 887 | 28.533 | 2932.3 |
1289 | 2024-08-19 03:24:34 | perch | 3 | 83667 | 887 | 5.953 | 14054.6 |
1288 | 2024-08-19 03:24:36 | perch | 2 | 53800 | 95 | 3.046 | 17662.5 |
1287 | 2024-08-10 10:49:25 | perch | 1 | 28756 | 6 | 1.533 | 18758.0 |
1286 | 2024-08-08 02:08:01 | perch | 1 | 28756 | 6 | 1.186 | 24246.2 |
1285 | 2024-08-07 05:22:08 | perch | 1 | 28756 | 6 | 0.953 | 30174.2 |
1284 | 2024-08-01 19:15:39 | perch | 1 | 28756 | 6 | 2.440 | 11785.2 |
1283 | 2024-07-30 13:32:09 | perch | 1 | 28756 | 6 | 1.983 | 14501.3 |
1282 | 2024-07-29 22:30:52 | perch | 1 | 28756 | 6 | 0.530 | 54256.6 |
1281 | 2024-07-27 08:01:57 | perch | 1 | 28756 | 6 | 1.563 | 18398.0 |
1280 | 2024-07-23 08:52:26 | perch | 1 | 28756 | 6 | 1.563 | 18398.0 |
1279 | 2024-07-23 06:40:15 | perch | 1 | 28756 | 6 | 2.436 | 11804.6 |
1278 | 2024-07-10 23:20:58 | perch | 1 | 28756 | 6 | 1.000 | 28756.0 |
1277 | 2024-07-09 18:57:25 | perch | 1 | 28756 | 6 | 1.186 | 24246.2 |
1276 | 2024-07-05 19:04:43 | perch | 1 | 28756 | 6 | 3.220 | 8930.4 |
1275 | 2024-06-30 12:39:49 | perch | 2 | 53800 | 95 | 3.623 | 14849.6 |
1274 | 2024-06-30 12:37:35 | perch | 1 | 28756 | 6 | 1.733 | 16593.2 |
1273 | 2024-06-29 20:50:41 | perch | 2 | 53800 | 95 | 8.406 | 6400.2 |
1272 | 2024-06-29 14:50:39 | perch | 2 | 53800 | 95 | 3.046 | 17662.5 |
1271 | 2024-06-29 14:43:23 | perch | 1 | 28756 | 6 | 0.780 | 36866.7 |
1270 | 2024-06-28 20:04:15 | perch | 1 | 28756 | 6 | 2.516 | 11429.3 |
1269 | 2024-06-27 13:50:20 | perch | 1 | 28756 | 6 | 1.016 | 28303.1 |
1268 | 2024-06-24 11:41:39 | perch | 3 | 83667 | 887 | 10.906 | 7671.6 |
1267 | 2024-06-23 16:09:10 | perch | 3 | 83667 | 887 | 7.983 | 10480.6 |
1266 | 2024-06-23 15:41:33 | perch | 3 | 83667 | 887 | 14.560 | 5746.4 |
1265 | 2024-06-23 14:42:55 | perch | 3 | 83667 | 887 | 15.250 | 5486.4 |
1264 | 2024-06-23 14:42:56 | perch | 2 | 53800 | 95 | 5.970 | 9011.7 |
1263 | 2024-06-23 14:42:27 | perch | 1 | 28756 | 6 | 2.550 | 11276.9 |
1262 | 2024-06-10 00:31:35 | perch | 1 | 28756 | 6 | 2.376 | 12102.7 |
1261 | 2024-06-03 06:18:03 | perch | 1 | 28756 | 6 | 0.513 | 56054.6 |
1260 | 2024-05-31 08:41:40 | perch | 1 | 28756 | 6 | 0.530 | 54256.6 |
1259 | 2024-05-29 21:00:27 | perch | 1 | 28756 | 6 | 1.860 | 15460.2 |
1258 | 2024-05-28 05:32:02 | perch | 1 | 28756 | 6 | 2.233 | 12877.7 |
1257 | 2024-05-05 23:29:34 | perch | 1 | 28756 | 6 | 0.516 | 55728.7 |
1256 | 2024-05-04 08:23:51 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
1255 | 2024-04-30 22:39:34 | perch | 1 | 28756 | 6 | 0.500 | 57512.0 |
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 |