History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loans"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1370 | 2024-04-22 22:06:49 | loans | 2 | 53800 | 269 | 1.393 | 38621.7 |
1369 | 2024-04-15 01:29:23 | loans | 1 | 28756 | 13 | 1.140 | 25224.6 |
1368 | 2024-04-07 04:00:38 | loans | 1 | 28756 | 13 | 1.330 | 21621.1 |
1367 | 2024-04-02 20:47:21 | loans | 1 | 28756 | 13 | 0.470 | 61183.0 |
1366 | 2024-04-02 11:05:31 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1365 | 2024-03-30 22:28:38 | loans | 2 | 53800 | 269 | 3.890 | 13830.3 |
1364 | 2024-03-30 21:55:39 | loans | 1 | 28756 | 13 | 0.513 | 56054.6 |
1363 | 2024-03-27 07:04:35 | loans | 1 | 28756 | 13 | 0.516 | 55728.7 |
1362 | 2024-02-25 18:40:50 | loans | 1 | 28756 | 13 | 1.656 | 17364.7 |
1361 | 2024-02-24 09:37:46 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1360 | 2024-02-22 09:11:00 | loans | 2 | 53800 | 269 | 1.860 | 28924.7 |
1359 | 2024-01-25 23:52:37 | loans | 1 | 28756 | 13 | 0.516 | 55728.7 |
1358 | 2024-01-15 17:47:53 | loans | 2 | 53800 | 269 | 1.593 | 33772.8 |
1357 | 2024-01-04 21:16:15 | loans | 2 | 53800 | 269 | 1.436 | 37465.2 |
1356 | 2023-12-24 15:05:10 | loans | 1 | 28756 | 13 | 0.470 | 61183.0 |
1355 | 2023-12-23 13:39:09 | loans | 1 | 28756 | 13 | 0.546 | 52666.7 |
1354 | 2023-12-16 22:13:47 | loans | 2 | 53800 | 269 | 1.783 | 30173.9 |
1353 | 2023-12-03 10:16:07 | loans | 2 | 53800 | 269 | 1.500 | 35866.7 |
1352 | 2023-11-27 18:21:10 | loans | 1 | 28756 | 13 | 0.483 | 59536.2 |
1351 | 2023-11-25 04:42:24 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1350 | 2023-11-16 04:17:13 | loans | 2 | 53800 | 269 | 1.390 | 38705.0 |
1349 | 2023-11-14 17:52:20 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1348 | 2023-11-10 10:04:11 | loans | 1 | 28756 | 13 | 0.440 | 65354.5 |
1347 | 2023-10-27 01:50:47 | loans | 1 | 28756 | 13 | 0.546 | 52666.7 |
1346 | 2023-10-26 22:09:03 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1345 | 2023-10-19 22:03:00 | loans | 1 | 28756 | 13 | 0.563 | 51076.4 |
1344 | 2023-10-17 12:05:08 | loans | 1 | 28756 | 13 | 0.516 | 55728.7 |
1343 | 2023-10-13 14:07:21 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1342 | 2023-10-11 14:52:57 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1341 | 2023-10-03 16:09:25 | loans | 1 | 28756 | 13 | 0.483 | 59536.2 |
1340 | 2023-09-27 20:45:18 | loans | 2 | 53800 | 269 | 3.466 | 15522.2 |
1339 | 2023-09-23 12:13:42 | loans | 1 | 28756 | 13 | 0.516 | 55728.7 |
1338 | 2023-09-21 15:18:52 | loans | 1 | 28756 | 13 | 1.140 | 25224.6 |
1337 | 2023-09-16 20:29:01 | loans | 2 | 53800 | 269 | 1.390 | 38705.0 |
1336 | 2023-08-26 21:44:34 | loans | 2 | 53800 | 269 | 1.530 | 35163.4 |
1335 | 2023-08-16 20:35:54 | loans | 2 | 53800 | 269 | 2.843 | 18923.7 |
1334 | 2023-08-06 23:31:23 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1333 | 2023-07-10 13:03:07 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1332 | 2023-06-18 16:14:54 | loans | 2 | 53800 | 269 | 1.390 | 38705.0 |
1331 | 2023-05-06 21:05:12 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1330 | 2023-03-30 06:25:52 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1329 | 2023-03-14 15:18:59 | loans | 2 | 53800 | 269 | 1.393 | 38621.7 |
1328 | 2023-02-26 06:55:11 | loans | 1 | 28756 | 13 | 0.440 | 65354.5 |
1327 | 2022-12-24 11:36:34 | loans | 1 | 28756 | 13 | 0.483 | 59536.2 |
1326 | 2022-12-17 23:15:17 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1325 | 2022-12-17 05:44:58 | loans | 2 | 53800 | 269 | 1.390 | 38705.0 |
1324 | 2022-09-19 15:18:36 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1323 | 2022-09-18 11:29:15 | loans | 1 | 28756 | 13 | 0.470 | 61183.0 |
1322 | 2022-09-14 19:18:24 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1321 | 2022-09-12 00:46:23 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1320 | 2022-09-10 10:12:13 | loans | 1 | 28756 | 13 | 0.440 | 65354.5 |
1319 | 2022-09-10 08:46:45 | loans | 1 | 28756 | 13 | 0.440 | 65354.5 |
1318 | 2022-09-09 11:16:13 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1317 | 2022-09-04 02:15:01 | loans | 2 | 53800 | 269 | 1.516 | 35488.1 |
1316 | 2022-09-03 20:13:01 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1315 | 2022-09-01 11:53:49 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1314 | 2022-08-26 07:46:52 | loans | 1 | 28756 | 13 | 0.450 | 63902.2 |
1313 | 2022-08-26 01:19:42 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1312 | 2022-08-25 16:49:17 | loans | 2 | 53800 | 269 | 1.580 | 34050.6 |
1311 | 2022-08-15 02:20:19 | loans | 2 | 53800 | 269 | 1.390 | 38705.0 |
1310 | 2022-08-14 23:28:20 | loans | 1 | 28756 | 13 | 0.450 | 63902.2 |
1309 | 2022-08-10 14:20:42 | loans | 2 | 53800 | 269 | 1.410 | 38156.0 |
1308 | 2022-08-10 13:30:13 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1307 | 2022-08-06 18:08:23 | loans | 2 | 53800 | 269 | 1.393 | 38621.7 |
1306 | 2022-08-06 18:00:18 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1305 | 2022-08-06 05:28:07 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1304 | 2022-07-29 23:03:11 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1303 | 2022-07-17 17:30:34 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1302 | 2022-07-10 03:07:47 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1301 | 2022-07-09 21:23:26 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1300 | 2022-07-03 06:09:28 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1299 | 2022-07-02 15:04:59 | loans | 1 | 28756 | 13 | 0.470 | 61183.0 |
1298 | 2022-07-02 12:00:53 | loans | 2 | 53800 | 269 | 1.406 | 38264.6 |
1297 | 2022-06-25 17:00:04 | loans | 1 | 28756 | 13 | 0.953 | 30174.2 |
1296 | 2022-06-24 19:20:24 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1295 | 2022-06-16 06:13:56 | loans | 1 | 28756 | 13 | 0.436 | 65954.1 |
1294 | 2022-06-07 14:54:51 | loans | 2 | 53800 | 269 | 1.656 | 32487.9 |
1293 | 2022-06-07 08:03:20 | loans | 2 | 53800 | 269 | 1.406 | 38264.6 |
1292 | 2022-06-06 21:41:03 | loans | 2 | 53800 | 269 | 1.390 | 38705.0 |
1291 | 2022-06-05 23:03:26 | loans | 2 | 53800 | 269 | 1.796 | 29955.5 |
1290 | 2022-06-05 08:49:59 | loans | 2 | 53800 | 269 | 1.656 | 32487.9 |
1289 | 2022-06-04 13:10:27 | loans | 2 | 53800 | 269 | 1.750 | 30742.9 |
1288 | 2022-06-03 23:40:41 | loans | 2 | 53800 | 269 | 1.876 | 28678.0 |
1287 | 2022-06-03 03:49:24 | loans | 2 | 53800 | 269 | 1.546 | 34799.5 |
1286 | 2022-06-02 05:26:35 | loans | 2 | 53800 | 269 | 1.390 | 38705.0 |
1285 | 2022-05-22 13:35:14 | loans | 1 | 28756 | 13 | 0.453 | 63479.0 |
1284 | 2022-05-19 04:01:21 | loans | 1 | 28756 | 13 | 0.500 | 57512.0 |
1283 | 2022-04-30 18:28:04 | loans | 2 | 53800 | 269 | 1.563 | 34421.0 |
1282 | 2022-04-27 18:30:15 | loans | 2 | 53800 | 269 | 1.733 | 31044.4 |
1281 | 2022-04-27 00:44:13 | loans | 2 | 53800 | 269 | 1.440 | 37361.1 |
1280 | 2022-04-26 09:44:07 | loans | 2 | 53800 | 269 | 1.720 | 31279.1 |
1279 | 2022-04-25 18:22:38 | loans | 2 | 53800 | 269 | 2.000 | 26900.0 |
1278 | 2022-04-24 21:20:55 | loans | 2 | 53800 | 269 | 1.656 | 32487.9 |
1277 | 2022-04-23 10:11:54 | loans | 2 | 53800 | 269 | 1.423 | 37807.4 |
1276 | 2022-04-22 12:56:19 | loans | 2 | 53800 | 269 | 1.610 | 33416.1 |
1275 | 2022-04-21 22:21:36 | loans | 2 | 53800 | 269 | 1.560 | 34487.2 |
1274 | 2022-04-21 13:22:37 | loans | 1 | 28756 | 13 | 0.626 | 45936.1 |
1273 | 2022-04-21 05:40:51 | loans | 2 | 53800 | 269 | 1.466 | 36698.5 |
1272 | 2022-04-20 12:08:29 | loans | 2 | 53800 | 269 | 2.046 | 26295.2 |
1271 | 2022-04-19 12:12:33 | loans | 2 | 53800 | 269 | 1.576 | 34137.1 |