History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1469 | 2025-05-09 05:09:35 | fid | 2 | 14084 | 397 | 0.766 | 18386.4 |
1468 | 2025-05-08 10:23:31 | fid | 2 | 14084 | 397 | 1.296 | 10867.3 |
1467 | 2025-05-08 05:30:53 | fid | 1 | 5146 | 28 | 1.046 | 4919.7 |
1466 | 2025-05-07 02:53:06 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1465 | 2025-05-02 17:15:56 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1464 | 2025-04-30 00:42:02 | fid | 2 | 14084 | 397 | 1.610 | 8747.8 |
1463 | 2025-04-29 22:25:01 | fid | 2 | 14084 | 397 | 2.110 | 6674.9 |
1462 | 2025-04-28 10:47:08 | fid | 1 | 5146 | 28 | 0.766 | 6718.0 |
1461 | 2025-04-28 09:34:35 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1460 | 2025-04-28 02:41:13 | fid | 1 | 5146 | 28 | 0.203 | 25349.8 |
1459 | 2025-04-28 02:37:59 | fid | 2 | 14084 | 397 | 3.016 | 4669.8 |
1458 | 2025-04-28 02:32:35 | fid | 1 | 5146 | 28 | 0.203 | 25349.8 |
1457 | 2025-04-28 02:29:29 | fid | 1 | 5146 | 28 | 0.610 | 8436.1 |
1456 | 2025-04-28 02:25:42 | fid | 1 | 5146 | 28 | 0.203 | 25349.8 |
1455 | 2025-04-28 02:05:21 | fid | 1 | 5146 | 28 | 0.216 | 23824.1 |
1454 | 2025-04-27 03:39:46 | fid | 1 | 5146 | 28 | 0.096 | 53604.2 |
1453 | 2025-04-13 10:17:41 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1452 | 2025-04-08 15:57:50 | fid | 1 | 5146 | 28 | 0.593 | 8677.9 |
1451 | 2025-04-06 02:56:38 | fid | 1 | 5146 | 28 | 0.096 | 53604.2 |
1450 | 2025-03-27 04:20:53 | fid | 1 | 5146 | 28 | 0.110 | 46781.8 |
1449 | 2025-03-18 18:43:43 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1448 | 2025-03-15 12:10:41 | fid | 1 | 5146 | 28 | 0.250 | 20584.0 |
1447 | 2025-03-14 19:49:45 | fid | 1 | 5146 | 28 | 0.500 | 10292.0 |
1446 | 2025-03-11 09:08:52 | fid | 2 | 14084 | 397 | 1.673 | 8418.4 |
1445 | 2025-03-10 04:35:31 | fid | 2 | 14084 | 397 | 1.563 | 9010.9 |
1444 | 2025-03-10 03:32:47 | fid | 2 | 14084 | 397 | 0.373 | 37758.7 |
1443 | 2025-03-09 11:00:09 | fid | 1 | 5146 | 28 | 0.110 | 46781.8 |
1442 | 2025-03-06 16:47:50 | fid | 1 | 5146 | 28 | 0.483 | 10654.2 |
1441 | 2025-02-24 23:10:32 | fid | 2 | 14084 | 397 | 2.126 | 6624.6 |
1440 | 2025-02-24 21:49:51 | fid | 2 | 14084 | 397 | 0.780 | 18056.4 |
1439 | 2025-02-24 21:49:46 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1438 | 2025-02-24 12:09:24 | fid | 2 | 14084 | 397 | 0.860 | 16376.7 |
1437 | 2025-02-24 12:08:04 | fid | 1 | 5146 | 28 | 0.533 | 9654.8 |
1436 | 2025-02-23 18:31:09 | fid | 1 | 5146 | 28 | 0.360 | 14294.4 |
1435 | 2025-02-23 08:10:57 | fid | 1 | 5146 | 28 | 0.110 | 46781.8 |
1434 | 2025-02-08 13:14:10 | fid | 2 | 14084 | 397 | 0.360 | 39122.2 |
1433 | 2025-02-04 10:37:10 | fid | 2 | 14084 | 397 | 1.140 | 12354.4 |
1432 | 2025-02-04 10:28:31 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1431 | 2025-01-29 07:26:38 | fid | 1 | 5146 | 28 | 0.593 | 8677.9 |
1430 | 2025-01-25 15:47:17 | fid | 2 | 14084 | 397 | 0.673 | 20927.2 |
1429 | 2025-01-25 15:35:59 | fid | 1 | 5146 | 28 | 0.110 | 46781.8 |
1428 | 2025-01-25 11:50:51 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1427 | 2025-01-25 09:18:44 | fid | 2 | 14084 | 397 | 1.670 | 8433.5 |
1426 | 2025-01-25 06:31:05 | fid | 2 | 14084 | 397 | 1.093 | 12885.6 |
1425 | 2025-01-25 01:41:46 | fid | 1 | 5146 | 28 | 0.110 | 46781.8 |
1424 | 2025-01-13 23:21:06 | fid | 1 | 5146 | 28 | 0.486 | 10588.5 |
1423 | 2025-01-05 05:53:14 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1422 | 2025-01-02 20:53:30 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1421 | 2024-12-26 12:47:08 | fid | 2 | 14084 | 397 | 0.406 | 34689.7 |
1420 | 2024-12-26 12:30:22 | fid | 1 | 5146 | 28 | 0.063 | 81682.5 |
1419 | 2024-12-26 06:32:04 | fid | 1 | 5146 | 28 | 0.766 | 6718.0 |
1418 | 2024-12-26 01:32:23 | fid | 2 | 14084 | 397 | 2.690 | 5235.7 |
1417 | 2024-12-25 16:43:54 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1416 | 2024-12-10 02:18:50 | fid | 1 | 5146 | 28 | 0.466 | 11042.9 |
1415 | 2024-12-09 23:35:07 | fid | 1 | 5146 | 28 | 0.500 | 10292.0 |
1414 | 2024-12-06 03:09:12 | fid | 2 | 14084 | 397 | 2.563 | 5495.1 |
1413 | 2024-12-06 02:41:12 | fid | 1 | 5146 | 28 | 0.080 | 64325.0 |
1412 | 2024-11-28 02:56:09 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1411 | 2024-11-26 15:09:33 | fid | 2 | 14084 | 397 | 3.093 | 4553.5 |
1410 | 2024-11-26 13:37:37 | fid | 1 | 5146 | 28 | 0.203 | 25349.8 |
1409 | 2024-11-26 12:03:13 | fid | 1 | 5146 | 28 | 0.076 | 67710.5 |
1408 | 2024-11-26 08:06:30 | fid | 2 | 14084 | 397 | 1.673 | 8418.4 |
1407 | 2024-11-26 06:03:09 | fid | 1 | 5146 | 28 | 0.140 | 36757.1 |
1406 | 2024-11-25 15:44:47 | fid | 1 | 5146 | 28 | 0.530 | 9709.4 |
1405 | 2024-11-06 02:52:10 | fid | 2 | 14084 | 397 | 2.593 | 5431.5 |
1404 | 2024-11-06 02:26:36 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1403 | 2024-10-27 06:58:57 | fid | 1 | 5146 | 28 | 0.170 | 30270.6 |
1402 | 2024-10-27 01:41:35 | fid | 1 | 5146 | 28 | 0.626 | 8220.4 |
1401 | 2024-10-26 12:13:13 | fid | 1 | 5146 | 28 | 0.106 | 48547.2 |
1400 | 2024-10-21 05:48:25 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1399 | 2024-10-19 21:00:55 | fid | 1 | 5146 | 28 | 0.203 | 25349.8 |
1398 | 2024-10-10 06:49:45 | fid | 1 | 5146 | 28 | 0.906 | 5679.9 |
1397 | 2024-10-07 02:36:02 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1396 | 2024-09-27 00:13:00 | fid | 1 | 5146 | 28 | 0.890 | 5782.0 |
1395 | 2024-09-26 22:55:10 | fid | 2 | 14084 | 397 | 1.123 | 12541.4 |
1394 | 2024-09-26 21:03:40 | fid | 1 | 5146 | 28 | 0.720 | 7147.2 |
1393 | 2024-09-26 18:44:57 | fid | 2 | 14084 | 397 | 1.466 | 9607.1 |
1392 | 2024-09-26 08:06:00 | fid | 1 | 5146 | 28 | 0.140 | 36757.1 |
1391 | 2024-09-06 20:15:55 | fid | 1 | 5146 | 28 | 1.186 | 4339.0 |
1390 | 2024-08-30 15:33:52 | fid | 1 | 5146 | 28 | 1.093 | 4708.1 |
1389 | 2024-08-27 21:35:30 | fid | 2 | 14084 | 397 | 0.546 | 25794.9 |
1388 | 2024-08-27 21:26:08 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1387 | 2024-08-27 19:20:32 | fid | 2 | 14084 | 397 | 0.390 | 36112.8 |
1386 | 2024-08-27 18:13:39 | fid | 1 | 5146 | 28 | 0.173 | 29745.7 |
1385 | 2024-08-27 05:38:08 | fid | 1 | 5146 | 28 | 0.843 | 6104.4 |
1384 | 2024-08-20 20:04:12 | fid | 1 | 5146 | 28 | 0.720 | 7147.2 |
1383 | 2024-08-20 00:19:37 | fid | 2 | 14084 | 397 | 4.093 | 3441.0 |
1382 | 2024-08-19 23:06:22 | fid | 2 | 14084 | 397 | 0.860 | 16376.7 |
1381 | 2024-08-08 09:13:54 | fid | 1 | 5146 | 28 | 0.423 | 12165.5 |
1380 | 2024-08-08 06:54:17 | fid | 2 | 14084 | 397 | 1.623 | 8677.8 |
1379 | 2024-08-07 21:33:46 | fid | 1 | 5146 | 28 | 0.653 | 7880.6 |
1378 | 2024-08-07 15:37:00 | fid | 2 | 14084 | 397 | 0.466 | 30223.2 |
1377 | 2024-08-02 03:00:48 | fid | 1 | 5146 | 28 | 0.453 | 11359.8 |
1376 | 2024-07-28 21:04:12 | fid | 2 | 14084 | 397 | 2.766 | 5091.8 |
1375 | 2024-07-28 20:50:00 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1374 | 2024-07-28 14:58:39 | fid | 2 | 14084 | 397 | 1.063 | 13249.3 |
1373 | 2024-07-28 14:55:31 | fid | 2 | 14084 | 397 | 1.283 | 10977.4 |
1372 | 2024-07-28 14:51:25 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |
1371 | 2024-07-28 00:33:39 | fid | 1 | 5146 | 28 | 0.186 | 27666.7 |
1370 | 2024-07-24 22:04:41 | fid | 1 | 5146 | 28 | 0.093 | 55333.3 |