History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"barca"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3591 | 2024-05-01 15:26:45 | barca | 3 | 83667 | 1266 | 9.346 | 8952.2 |
3590 | 2024-05-01 00:16:23 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3589 | 2024-04-30 20:38:11 | barca | 3 | 83667 | 1266 | 3.343 | 25027.5 |
3588 | 2024-04-30 01:21:08 | barca | 3 | 83667 | 1266 | 7.030 | 11901.4 |
3587 | 2024-04-30 01:21:02 | barca | 2 | 53800 | 96 | 3.813 | 14109.6 |
3586 | 2024-04-30 01:19:17 | barca | 1 | 28756 | 3 | 1.716 | 16757.6 |
3585 | 2024-04-25 22:57:31 | barca | 3 | 83667 | 1266 | 4.580 | 18267.9 |
3584 | 2024-04-25 22:38:45 | barca | 1 | 28756 | 3 | 1.110 | 25906.3 |
3583 | 2024-04-24 04:57:45 | barca | 1 | 28756 | 3 | 0.610 | 47141.0 |
3582 | 2024-04-22 04:53:58 | barca | 1 | 28756 | 3 | 1.983 | 14501.3 |
3581 | 2024-04-22 04:53:56 | barca | 1 | 28756 | 3 | 0.860 | 33437.2 |
3580 | 2024-04-06 19:52:20 | barca | 3 | 83667 | 1266 | 17.330 | 4827.9 |
3579 | 2024-04-06 12:47:20 | barca | 1 | 28756 | 3 | 1.156 | 24875.4 |
3578 | 2024-04-03 12:03:13 | barca | 2 | 53800 | 96 | 3.033 | 17738.2 |
3577 | 2024-03-31 16:13:03 | barca | 1 | 28756 | 3 | 0.563 | 51076.4 |
3576 | 2024-03-28 20:06:39 | barca | 3 | 83667 | 1266 | 3.813 | 21942.6 |
3575 | 2024-03-28 20:06:38 | barca | 2 | 53800 | 96 | 1.546 | 34799.5 |
3574 | 2024-03-28 20:06:31 | barca | 1 | 28756 | 3 | 0.533 | 53951.2 |
3573 | 2024-03-25 02:08:50 | barca | 1 | 28756 | 3 | 0.576 | 49923.6 |
3572 | 2024-03-07 05:15:30 | barca | 1 | 28756 | 3 | 0.513 | 56054.6 |
3571 | 2024-03-06 23:21:20 | barca | 3 | 83667 | 1266 | 14.123 | 5924.2 |
3570 | 2024-03-06 21:48:32 | barca | 2 | 53800 | 96 | 5.470 | 9835.5 |
3569 | 2024-03-06 10:58:11 | barca | 2 | 53800 | 96 | 3.170 | 16971.6 |
3568 | 2024-03-06 10:57:36 | barca | 3 | 83667 | 1266 | 8.016 | 10437.5 |
3567 | 2024-03-06 10:57:37 | barca | 2 | 53800 | 96 | 2.060 | 26116.5 |
3566 | 2024-03-06 10:57:12 | barca | 1 | 28756 | 3 | 1.140 | 25224.6 |
3565 | 2024-03-06 10:56:38 | barca | 3 | 83667 | 1266 | 4.813 | 17383.5 |
3564 | 2024-03-06 08:43:21 | barca | 3 | 83667 | 1266 | 13.563 | 6168.8 |
3563 | 2024-03-01 12:17:15 | barca | 1 | 28756 | 3 | 0.513 | 56054.6 |
3562 | 2024-02-25 19:18:04 | barca | 1 | 28756 | 3 | 0.466 | 61708.2 |
3561 | 2024-02-14 16:09:03 | barca | 3 | 83667 | 1266 | 3.596 | 23266.7 |
3560 | 2024-02-03 22:59:47 | barca | 1 | 28756 | 3 | 0.500 | 57512.0 |
3559 | 2024-02-01 07:23:37 | barca | 1 | 28756 | 3 | 0.500 | 57512.0 |
3558 | 2024-01-29 06:15:15 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3557 | 2024-01-26 05:57:29 | barca | 1 | 28756 | 3 | 0.483 | 59536.2 |
3556 | 2024-01-15 21:47:35 | barca | 3 | 83667 | 1266 | 3.906 | 21420.1 |
3555 | 2024-01-02 15:28:03 | barca | 1 | 28756 | 3 | 0.466 | 61708.2 |
3554 | 2023-12-27 23:35:36 | barca | 2 | 53800 | 96 | 1.390 | 38705.0 |
3553 | 2023-12-20 06:32:38 | barca | 1 | 28756 | 3 | 0.483 | 59536.2 |
3552 | 2023-12-16 01:49:10 | barca | 3 | 83667 | 1266 | 3.280 | 25508.2 |
3551 | 2023-12-09 06:36:29 | barca | 2 | 53800 | 96 | 3.296 | 16322.8 |
3550 | 2023-12-08 12:33:07 | barca | 1 | 28756 | 3 | 0.500 | 57512.0 |
3549 | 2023-12-08 12:33:06 | barca | 1 | 28756 | 3 | 0.530 | 54256.6 |
3548 | 2023-12-08 10:11:28 | barca | 2 | 53800 | 96 | 1.653 | 32546.9 |
3547 | 2023-12-04 00:00:22 | barca | 2 | 53800 | 96 | 1.403 | 38346.4 |
3546 | 2023-12-03 22:25:41 | barca | 1 | 28756 | 3 | 0.533 | 53951.2 |
3545 | 2023-12-03 05:35:28 | barca | 2 | 53800 | 96 | 1.563 | 34421.0 |
3544 | 2023-11-30 16:03:31 | barca | 2 | 53800 | 96 | 1.626 | 33087.3 |
3543 | 2023-11-30 16:03:28 | barca | 3 | 83667 | 1266 | 4.030 | 20761.0 |
3542 | 2023-11-25 17:26:41 | barca | 3 | 83667 | 1266 | 5.016 | 16680.0 |
3541 | 2023-11-11 21:39:42 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3540 | 2023-11-10 18:44:02 | barca | 2 | 53800 | 96 | 1.593 | 33772.8 |
3539 | 2023-11-10 17:07:20 | barca | 3 | 83667 | 1266 | 4.250 | 19686.4 |
3538 | 2023-11-09 17:31:46 | barca | 3 | 83667 | 1266 | 4.046 | 20678.9 |
3537 | 2023-11-09 13:39:12 | barca | 3 | 83667 | 1266 | 3.296 | 25384.4 |
3536 | 2023-11-08 01:51:23 | barca | 1 | 28756 | 3 | 0.516 | 55728.7 |
3535 | 2023-11-07 12:55:03 | barca | 3 | 83667 | 1266 | 3.610 | 23176.5 |
3534 | 2023-11-07 08:01:46 | barca | 1 | 28756 | 3 | 0.440 | 65354.5 |
3533 | 2023-11-07 06:02:39 | barca | 3 | 83667 | 1266 | 4.563 | 18336.0 |
3532 | 2023-11-07 06:02:26 | barca | 3 | 83667 | 1266 | 8.483 | 9862.9 |
3531 | 2023-11-06 04:36:38 | barca | 3 | 83667 | 1266 | 4.050 | 20658.5 |
3530 | 2023-11-02 01:31:54 | barca | 3 | 83667 | 1266 | 3.313 | 25254.2 |
3529 | 2023-11-01 05:38:33 | barca | 3 | 83667 | 1266 | 4.846 | 17265.2 |
3528 | 2023-10-31 16:30:11 | barca | 2 | 53800 | 96 | 1.673 | 32157.8 |
3527 | 2023-10-30 18:43:30 | barca | 3 | 83667 | 1266 | 4.686 | 17854.7 |
3526 | 2023-10-27 17:13:34 | barca | 1 | 28756 | 3 | 0.436 | 65954.1 |
3525 | 2023-10-24 16:07:39 | barca | 1 | 28756 | 3 | 0.516 | 55728.7 |
3524 | 2023-10-24 10:19:14 | barca | 3 | 83667 | 1266 | 4.126 | 20278.0 |
3523 | 2023-10-20 20:26:23 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3522 | 2023-10-18 04:44:32 | barca | 1 | 28756 | 3 | 0.483 | 59536.2 |
3521 | 2023-10-17 15:30:19 | barca | 3 | 83667 | 1266 | 6.093 | 13731.7 |
3520 | 2023-10-17 15:30:20 | barca | 2 | 53800 | 96 | 1.686 | 31909.8 |
3519 | 2023-10-11 00:23:49 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3518 | 2023-10-04 09:21:42 | barca | 1 | 28756 | 3 | 0.550 | 52283.6 |
3517 | 2023-10-03 10:13:37 | barca | 3 | 83667 | 1266 | 4.390 | 19058.5 |
3516 | 2023-10-02 12:51:20 | barca | 3 | 83667 | 1266 | 3.813 | 21942.6 |
3515 | 2023-09-22 23:36:08 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3514 | 2023-09-22 05:51:34 | barca | 1 | 28756 | 3 | 0.483 | 59536.2 |
3513 | 2023-09-10 07:18:59 | barca | 1 | 28756 | 3 | 0.470 | 61183.0 |
3512 | 2023-09-06 20:48:20 | barca | 1 | 28756 | 3 | 0.580 | 49579.3 |
3511 | 2023-08-31 18:18:57 | barca | 2 | 53800 | 96 | 1.406 | 38264.6 |
3510 | 2023-08-22 09:54:11 | barca | 3 | 83667 | 1266 | 4.296 | 19475.6 |
3509 | 2023-08-19 12:34:11 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3508 | 2023-06-29 19:20:47 | barca | 2 | 53800 | 96 | 1.563 | 34421.0 |
3507 | 2023-06-26 16:16:38 | barca | 1 | 28756 | 3 | 0.500 | 57512.0 |
3506 | 2023-06-03 03:52:32 | barca | 1 | 28756 | 3 | 0.670 | 42919.4 |
3505 | 2023-05-30 21:25:02 | barca | 1 | 28756 | 3 | 0.780 | 36866.7 |
3504 | 2023-05-21 15:22:49 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3503 | 2023-05-16 02:32:25 | barca | 2 | 53800 | 96 | 1.420 | 37887.3 |
3502 | 2023-04-07 02:09:15 | barca | 3 | 83667 | 1266 | 3.703 | 22594.4 |
3501 | 2023-03-31 14:54:50 | barca | 2 | 53800 | 96 | 1.670 | 32215.6 |
3500 | 2023-03-31 14:26:30 | barca | 3 | 83667 | 1266 | 3.750 | 22311.2 |
3499 | 2023-03-26 20:24:50 | barca | 1 | 28756 | 3 | 0.500 | 57512.0 |
3498 | 2023-03-17 06:33:41 | barca | 1 | 28756 | 3 | 0.516 | 55728.7 |
3497 | 2023-02-25 00:23:41 | barca | 1 | 28756 | 3 | 0.516 | 55728.7 |
3496 | 2023-02-21 20:57:41 | barca | 2 | 53800 | 96 | 1.393 | 38621.7 |
3495 | 2023-01-05 10:50:57 | barca | 1 | 28756 | 3 | 0.453 | 63479.0 |
3494 | 2022-12-02 09:15:44 | barca | 2 | 53800 | 96 | 1.406 | 38264.6 |
3493 | 2022-12-02 03:47:10 | barca | 2 | 53800 | 96 | 1.373 | 39184.3 |
3492 | 2022-11-25 04:21:45 | barca | 1 | 28756 | 3 | 0.533 | 53951.2 |