History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jerid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1405 | 2024-03-22 16:22:19 | jerid | 3 | 83667 | 1098 | 10.280 | 8138.8 |
1404 | 2024-03-22 16:22:19 | jerid | 2 | 53800 | 61 | 4.156 | 12945.1 |
1403 | 2024-03-22 16:21:51 | jerid | 1 | 28756 | 3 | 1.673 | 17188.3 |
1402 | 2024-03-17 09:40:43 | jerid | 1 | 28756 | 3 | 0.500 | 57512.0 |
1401 | 2024-03-07 04:05:04 | jerid | 1 | 28756 | 3 | 1.063 | 27051.7 |
1400 | 2024-03-01 12:42:22 | jerid | 1 | 28756 | 3 | 1.310 | 21951.1 |
1399 | 2024-02-28 20:27:47 | jerid | 1 | 28756 | 3 | 0.530 | 54256.6 |
1398 | 2024-02-21 12:36:33 | jerid | 1 | 28756 | 3 | 0.550 | 52283.6 |
1397 | 2024-02-07 05:12:30 | jerid | 3 | 83667 | 1098 | 3.500 | 23904.9 |
1396 | 2024-02-03 19:23:47 | jerid | 1 | 28756 | 3 | 0.406 | 70827.6 |
1395 | 2024-02-02 19:37:44 | jerid | 2 | 53800 | 61 | 1.673 | 32157.8 |
1394 | 2024-02-02 19:37:16 | jerid | 3 | 83667 | 1098 | 3.703 | 22594.4 |
1393 | 2024-02-02 10:10:37 | jerid | 3 | 83667 | 1098 | 3.140 | 26645.5 |
1392 | 2024-01-29 07:34:29 | jerid | 1 | 28756 | 3 | 0.466 | 61708.2 |
1391 | 2024-01-29 04:44:19 | jerid | 1 | 28756 | 3 | 0.983 | 29253.3 |
1390 | 2024-01-25 07:03:47 | jerid | 1 | 28756 | 3 | 0.483 | 59536.2 |
1389 | 2024-01-20 20:53:28 | jerid | 1 | 28756 | 3 | 0.486 | 59168.7 |
1388 | 2024-01-11 16:47:25 | jerid | 1 | 28756 | 3 | 0.486 | 59168.7 |
1387 | 2024-01-10 03:50:42 | jerid | 3 | 83667 | 1098 | 3.253 | 25720.0 |
1386 | 2024-01-06 11:17:28 | jerid | 3 | 83667 | 1098 | 3.466 | 24139.4 |
1385 | 2023-12-30 20:56:19 | jerid | 2 | 53800 | 61 | 1.483 | 36277.8 |
1384 | 2023-12-21 18:32:57 | jerid | 2 | 53800 | 61 | 1.670 | 32215.6 |
1383 | 2023-12-21 07:59:53 | jerid | 3 | 83667 | 1098 | 3.516 | 23796.1 |
1382 | 2023-12-19 22:45:58 | jerid | 3 | 83667 | 1098 | 3.216 | 26015.9 |
1381 | 2023-12-13 20:46:08 | jerid | 1 | 28756 | 3 | 0.440 | 65354.5 |
1380 | 2023-12-08 10:17:32 | jerid | 3 | 83667 | 1098 | 3.766 | 22216.4 |
1379 | 2023-12-08 05:49:00 | jerid | 1 | 28756 | 3 | 0.470 | 61183.0 |
1378 | 2023-12-08 05:48:59 | jerid | 1 | 28756 | 3 | 0.470 | 61183.0 |
1377 | 2023-12-05 03:10:03 | jerid | 3 | 83667 | 1098 | 3.813 | 21942.6 |
1376 | 2023-11-24 22:10:12 | jerid | 1 | 28756 | 3 | 0.483 | 59536.2 |
1375 | 2023-11-24 04:15:25 | jerid | 3 | 83667 | 1098 | 4.076 | 20526.7 |
1374 | 2023-11-23 01:01:41 | jerid | 1 | 28756 | 3 | 0.440 | 65354.5 |
1373 | 2023-11-19 04:17:28 | jerid | 3 | 83667 | 1098 | 3.406 | 24564.6 |
1372 | 2023-11-14 19:21:13 | jerid | 1 | 28756 | 3 | 0.516 | 55728.7 |
1371 | 2023-11-13 10:33:00 | jerid | 2 | 53800 | 61 | 1.500 | 35866.7 |
1370 | 2023-11-12 01:43:17 | jerid | 1 | 28756 | 3 | 0.423 | 67981.1 |
1369 | 2023-11-11 15:04:51 | jerid | 3 | 83667 | 1098 | 3.546 | 23594.8 |
1368 | 2023-11-10 23:15:59 | jerid | 3 | 83667 | 1098 | 3.296 | 25384.4 |
1367 | 2023-11-04 02:59:14 | jerid | 1 | 28756 | 3 | 0.936 | 30722.2 |
1366 | 2023-10-21 09:26:24 | jerid | 1 | 28756 | 3 | 0.420 | 68466.7 |
1365 | 2023-10-18 16:41:31 | jerid | 1 | 28756 | 3 | 0.440 | 65354.5 |
1364 | 2023-10-16 10:50:51 | jerid | 1 | 28756 | 3 | 0.420 | 68466.7 |
1363 | 2023-10-05 03:25:53 | jerid | 1 | 28756 | 3 | 0.623 | 46157.3 |
1362 | 2023-09-25 21:00:30 | jerid | 1 | 28756 | 3 | 0.483 | 59536.2 |
1361 | 2023-09-13 11:55:23 | jerid | 1 | 28756 | 3 | 0.423 | 67981.1 |
1360 | 2023-09-08 11:30:38 | jerid | 1 | 28756 | 3 | 0.736 | 39070.7 |
1359 | 2023-08-24 05:24:41 | jerid | 1 | 28756 | 3 | 0.423 | 67981.1 |
1358 | 2023-08-14 17:16:56 | jerid | 3 | 83667 | 1098 | 4.733 | 17677.4 |
1357 | 2023-08-10 13:11:18 | jerid | 3 | 83667 | 1098 | 3.263 | 25641.1 |
1356 | 2023-08-01 15:20:55 | jerid | 3 | 83667 | 1098 | 3.703 | 22594.4 |
1355 | 2023-07-12 21:28:16 | jerid | 3 | 83667 | 1098 | 3.703 | 22594.4 |
1354 | 2023-07-11 18:13:37 | jerid | 3 | 83667 | 1098 | 3.940 | 21235.3 |
1353 | 2023-07-10 17:52:19 | jerid | 3 | 83667 | 1098 | 3.313 | 25254.2 |
1352 | 2023-07-09 06:14:49 | jerid | 3 | 83667 | 1098 | 3.810 | 21959.8 |
1351 | 2023-07-09 00:10:04 | jerid | 3 | 83667 | 1098 | 3.266 | 25617.6 |
1350 | 2023-07-08 09:06:59 | jerid | 3 | 83667 | 1098 | 3.170 | 26393.4 |
1349 | 2023-07-07 02:41:02 | jerid | 3 | 83667 | 1098 | 3.186 | 26260.8 |
1348 | 2023-07-06 14:35:25 | jerid | 3 | 83667 | 1098 | 3.550 | 23568.2 |
1347 | 2023-07-05 01:04:14 | jerid | 3 | 83667 | 1098 | 3.593 | 23286.1 |
1346 | 2023-07-04 08:39:12 | jerid | 3 | 83667 | 1098 | 3.703 | 22594.4 |
1345 | 2023-07-03 19:29:34 | jerid | 3 | 83667 | 1098 | 3.216 | 26015.9 |
1344 | 2023-07-03 00:59:59 | jerid | 3 | 83667 | 1098 | 3.360 | 24900.9 |
1343 | 2023-07-02 07:52:22 | jerid | 3 | 83667 | 1098 | 3.640 | 22985.4 |
1342 | 2023-07-01 20:56:50 | jerid | 3 | 83667 | 1098 | 3.343 | 25027.5 |
1341 | 2023-07-01 03:37:15 | jerid | 3 | 83667 | 1098 | 3.936 | 21256.9 |
1340 | 2023-06-30 12:16:38 | jerid | 3 | 83667 | 1098 | 6.623 | 12632.8 |
1339 | 2023-06-30 07:40:38 | jerid | 3 | 83667 | 1098 | 3.236 | 25855.1 |
1338 | 2023-06-29 19:29:20 | jerid | 3 | 83667 | 1098 | 3.216 | 26015.9 |
1337 | 2023-06-29 01:44:48 | jerid | 3 | 83667 | 1098 | 3.216 | 26015.9 |
1336 | 2023-06-28 12:57:17 | jerid | 3 | 83667 | 1098 | 3.563 | 23482.2 |
1335 | 2023-06-27 20:38:15 | jerid | 3 | 83667 | 1098 | 3.203 | 26121.4 |
1334 | 2023-06-27 02:12:34 | jerid | 3 | 83667 | 1098 | 3.236 | 25855.1 |
1333 | 2023-06-26 13:41:59 | jerid | 3 | 83667 | 1098 | 3.266 | 25617.6 |
1332 | 2023-06-25 13:37:00 | jerid | 3 | 83667 | 1098 | 3.563 | 23482.2 |
1331 | 2023-06-24 21:41:56 | jerid | 3 | 83667 | 1098 | 3.203 | 26121.4 |
1330 | 2023-06-24 07:51:20 | jerid | 3 | 83667 | 1098 | 3.390 | 24680.5 |
1329 | 2023-06-23 12:40:29 | jerid | 3 | 83667 | 1098 | 3.686 | 22698.6 |
1328 | 2023-06-22 08:14:13 | jerid | 3 | 83667 | 1098 | 3.673 | 22778.9 |
1327 | 2023-06-21 17:52:48 | jerid | 3 | 83667 | 1098 | 3.330 | 25125.2 |
1326 | 2023-06-21 00:59:10 | jerid | 3 | 83667 | 1098 | 3.313 | 25254.2 |
1325 | 2023-06-20 07:50:18 | jerid | 3 | 83667 | 1098 | 3.516 | 23796.1 |
1324 | 2023-06-19 21:13:13 | jerid | 3 | 83667 | 1098 | 3.233 | 25879.1 |
1323 | 2023-06-19 02:13:07 | jerid | 3 | 83667 | 1098 | 3.220 | 25983.5 |
1322 | 2023-06-18 08:12:16 | jerid | 3 | 83667 | 1098 | 3.373 | 24804.9 |
1321 | 2023-06-17 02:07:01 | jerid | 3 | 83667 | 1098 | 3.360 | 24900.9 |
1320 | 2023-06-16 14:02:06 | jerid | 1 | 28756 | 3 | 0.466 | 61708.2 |
1319 | 2023-06-16 10:16:34 | jerid | 3 | 83667 | 1098 | 3.280 | 25508.2 |
1318 | 2023-06-15 11:54:14 | jerid | 3 | 83667 | 1098 | 3.203 | 26121.4 |
1317 | 2023-06-15 08:02:01 | jerid | 3 | 83667 | 1098 | 3.656 | 22884.8 |
1316 | 2023-06-14 16:00:47 | jerid | 3 | 83667 | 1098 | 3.830 | 21845.2 |
1315 | 2023-06-13 15:43:34 | jerid | 3 | 83667 | 1098 | 3.170 | 26393.4 |
1314 | 2023-06-13 00:50:32 | jerid | 3 | 83667 | 1098 | 3.220 | 25983.5 |
1313 | 2023-06-11 00:56:10 | jerid | 3 | 83667 | 1098 | 3.750 | 22311.2 |
1312 | 2023-06-09 22:05:25 | jerid | 3 | 83667 | 1098 | 3.263 | 25641.1 |
1311 | 2023-05-20 21:42:49 | jerid | 3 | 83667 | 1098 | 3.203 | 26121.4 |
1310 | 2023-05-19 21:48:49 | jerid | 3 | 83667 | 1098 | 3.830 | 21845.2 |
1309 | 2023-05-18 22:12:31 | jerid | 3 | 83667 | 1098 | 3.436 | 24350.1 |
1308 | 2023-05-10 13:12:32 | jerid | 1 | 28756 | 3 | 0.470 | 61183.0 |
1307 | 2023-05-09 13:45:58 | jerid | 3 | 83667 | 1098 | 3.500 | 23904.9 |
1306 | 2023-05-07 01:24:36 | jerid | 1 | 28756 | 3 | 0.420 | 68466.7 |