History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jacky"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1374 | 2024-04-05 05:16:29 | jacky | 2 | 53800 | 90 | 4.530 | 11876.4 |
| 1373 | 2024-04-04 19:55:24 | jacky | 3 | 83667 | 901 | 14.643 | 5713.8 |
| 1372 | 2024-04-03 19:21:42 | jacky | 2 | 53800 | 90 | 3.830 | 14047.0 |
| 1371 | 2024-04-03 19:19:26 | jacky | 3 | 83667 | 901 | 4.856 | 17229.6 |
| 1370 | 2024-04-03 06:34:28 | jacky | 3 | 83667 | 901 | 10.016 | 8353.3 |
| 1369 | 2024-04-03 06:34:27 | jacky | 2 | 53800 | 90 | 3.986 | 13497.2 |
| 1368 | 2024-04-03 06:15:43 | jacky | 1 | 28756 | 5 | 1.140 | 25224.6 |
| 1367 | 2024-03-30 21:25:44 | jacky | 1 | 28756 | 5 | 1.106 | 26000.0 |
| 1366 | 2024-03-28 18:37:23 | jacky | 1 | 28756 | 5 | 1.076 | 26724.9 |
| 1365 | 2024-03-28 18:24:48 | jacky | 3 | 83667 | 901 | 4.033 | 20745.6 |
| 1364 | 2024-03-28 15:30:22 | jacky | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1363 | 2024-03-28 15:29:58 | jacky | 3 | 83667 | 901 | 3.313 | 25254.2 |
| 1362 | 2024-03-28 14:42:59 | jacky | 3 | 83667 | 901 | 5.126 | 16322.1 |
| 1361 | 2024-03-02 18:11:35 | jacky | 3 | 83667 | 901 | 4.550 | 18388.4 |
| 1360 | 2024-03-01 03:05:09 | jacky | 2 | 53800 | 90 | 1.593 | 33772.8 |
| 1359 | 2024-03-01 03:04:42 | jacky | 3 | 83667 | 901 | 4.936 | 16950.4 |
| 1358 | 2024-02-27 18:52:43 | jacky | 2 | 53800 | 90 | 2.906 | 18513.4 |
| 1357 | 2024-02-27 04:52:57 | jacky | 3 | 83667 | 901 | 9.156 | 9137.9 |
| 1356 | 2024-02-26 22:37:30 | jacky | 3 | 83667 | 901 | 4.266 | 19612.5 |
| 1355 | 2024-02-26 22:37:30 | jacky | 2 | 53800 | 90 | 1.763 | 30516.2 |
| 1354 | 2024-02-26 19:41:06 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1353 | 2024-01-10 15:38:22 | jacky | 3 | 83667 | 901 | 3.423 | 24442.6 |
| 1352 | 2024-01-10 15:38:20 | jacky | 2 | 53800 | 90 | 1.596 | 33709.3 |
| 1351 | 2024-01-01 07:54:26 | jacky | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1350 | 2023-12-30 17:41:48 | jacky | 3 | 83667 | 901 | 3.376 | 24782.9 |
| 1349 | 2023-12-23 08:01:58 | jacky | 3 | 83667 | 901 | 3.280 | 25508.2 |
| 1348 | 2023-12-23 08:01:53 | jacky | 2 | 53800 | 90 | 1.390 | 38705.0 |
| 1347 | 2023-12-04 09:33:33 | jacky | 3 | 83667 | 901 | 3.686 | 22698.6 |
| 1346 | 2023-12-04 09:33:28 | jacky | 3 | 83667 | 901 | 3.670 | 22797.5 |
| 1345 | 2023-12-03 05:16:51 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1344 | 2023-12-03 05:16:50 | jacky | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1343 | 2023-12-02 16:27:08 | jacky | 3 | 83667 | 901 | 3.173 | 26368.4 |
| 1342 | 2023-12-02 16:27:03 | jacky | 2 | 53800 | 90 | 1.606 | 33499.4 |
| 1341 | 2023-12-02 13:55:29 | jacky | 3 | 83667 | 901 | 3.203 | 26121.4 |
| 1340 | 2023-12-01 15:55:02 | jacky | 2 | 53800 | 90 | 1.780 | 30224.7 |
| 1339 | 2023-12-01 15:54:53 | jacky | 3 | 83667 | 901 | 6.030 | 13875.1 |
| 1338 | 2023-11-12 22:03:51 | jacky | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1337 | 2023-11-10 02:39:21 | jacky | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1336 | 2023-11-02 23:52:35 | jacky | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1335 | 2023-11-01 04:09:38 | jacky | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1334 | 2023-10-30 17:11:05 | jacky | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1333 | 2023-10-22 05:05:25 | jacky | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1332 | 2023-10-21 09:14:25 | jacky | 1 | 28756 | 5 | 0.456 | 63061.4 |
| 1331 | 2023-10-18 13:48:16 | jacky | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 1330 | 2023-10-12 02:39:33 | jacky | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1329 | 2023-10-05 03:21:51 | jacky | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1328 | 2023-09-28 16:09:45 | jacky | 3 | 83667 | 901 | 4.390 | 19058.5 |
| 1327 | 2023-09-28 12:42:25 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1326 | 2023-09-22 18:28:30 | jacky | 3 | 83667 | 901 | 3.296 | 25384.4 |
| 1325 | 2023-09-17 13:02:35 | jacky | 3 | 83667 | 901 | 3.486 | 24000.9 |
| 1324 | 2023-09-12 20:27:26 | jacky | 1 | 28756 | 5 | 1.000 | 28756.0 |
| 1323 | 2023-09-01 07:50:16 | jacky | 3 | 83667 | 901 | 3.126 | 26764.9 |
| 1322 | 2023-08-17 14:15:41 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1321 | 2023-07-07 03:34:17 | jacky | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1320 | 2023-05-18 14:19:16 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1319 | 2023-05-18 10:36:37 | jacky | 3 | 83667 | 901 | 3.393 | 24658.7 |
| 1318 | 2023-05-08 04:12:23 | jacky | 3 | 83667 | 901 | 3.266 | 25617.6 |
| 1317 | 2023-04-24 17:59:03 | jacky | 3 | 83667 | 901 | 3.750 | 22311.2 |
| 1316 | 2023-04-23 18:35:21 | jacky | 3 | 83667 | 901 | 3.626 | 23074.2 |
| 1315 | 2023-04-22 07:07:40 | jacky | 3 | 83667 | 901 | 3.766 | 22216.4 |
| 1314 | 2023-04-21 09:19:58 | jacky | 3 | 83667 | 901 | 3.670 | 22797.5 |
| 1313 | 2023-04-20 07:10:51 | jacky | 3 | 83667 | 901 | 3.313 | 25254.2 |
| 1312 | 2023-04-19 14:19:08 | jacky | 3 | 83667 | 901 | 3.313 | 25254.2 |
| 1311 | 2023-04-18 20:07:53 | jacky | 3 | 83667 | 901 | 3.686 | 22698.6 |
| 1310 | 2023-04-17 20:57:20 | jacky | 3 | 83667 | 901 | 7.686 | 10885.6 |
| 1309 | 2023-03-26 21:01:23 | jacky | 3 | 83667 | 901 | 3.626 | 23074.2 |
| 1308 | 2023-03-20 14:40:41 | jacky | 3 | 83667 | 901 | 3.393 | 24658.7 |
| 1307 | 2023-03-20 03:54:54 | jacky | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1306 | 2023-03-16 20:56:35 | jacky | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1305 | 2023-03-12 03:54:45 | jacky | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 1304 | 2023-02-24 00:49:28 | jacky | 3 | 83667 | 901 | 4.266 | 19612.5 |
| 1303 | 2023-02-19 13:45:10 | jacky | 3 | 83667 | 901 | 3.236 | 25855.1 |
| 1302 | 2023-01-20 07:09:09 | jacky | 3 | 83667 | 901 | 3.576 | 23396.8 |
| 1301 | 2023-01-01 17:53:47 | jacky | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1300 | 2022-12-06 16:48:21 | jacky | 3 | 83667 | 901 | 3.173 | 26368.4 |
| 1299 | 2022-11-22 00:57:53 | jacky | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1298 | 2022-09-22 19:44:35 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1297 | 2022-09-01 20:57:09 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1296 | 2022-07-29 04:59:08 | jacky | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1295 | 2022-07-25 18:42:46 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1294 | 2022-07-02 16:22:31 | jacky | 2 | 53800 | 90 | 1.330 | 40451.1 |
| 1293 | 2022-05-02 07:06:40 | jacky | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 1292 | 2022-04-03 18:07:47 | jacky | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1291 | 2022-04-03 18:00:24 | jacky | 3 | 83667 | 901 | 3.156 | 26510.5 |
| 1290 | 2022-01-23 11:18:57 | jacky | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1289 | 2021-12-20 00:35:23 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1288 | 2021-12-17 06:53:16 | jacky | 3 | 83667 | 901 | 3.783 | 22116.6 |
| 1287 | 2021-12-07 00:49:04 | jacky | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1286 | 2021-11-23 03:31:11 | jacky | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1285 | 2021-10-10 23:22:38 | jacky | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1284 | 2021-09-09 13:25:07 | jacky | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1283 | 2021-09-06 20:43:55 | jacky | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 1282 | 2021-08-20 05:15:50 | jacky | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1281 | 2021-07-05 20:19:39 | jacky | 3 | 83667 | 901 | 3.966 | 21096.1 |
| 1280 | 2021-06-11 13:01:24 | jacky | 3 | 83667 | 901 | 3.753 | 22293.4 |
| 1279 | 2021-06-08 14:04:56 | jacky | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1278 | 2021-05-26 04:42:05 | jacky | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1277 | 2021-04-18 00:37:11 | jacky | 3 | 83667 | 901 | 3.623 | 23093.3 |
| 1276 | 2021-03-16 14:08:12 | jacky | 3 | 83667 | 901 | 3.893 | 21491.7 |
| 1275 | 2021-03-09 13:57:18 | jacky | 1 | 28756 | 5 | 0.483 | 59536.2 |