History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bocci"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
639 | 2024-04-27 13:11:57 | bocci | 1 | 28756 | 6 | 0.640 | 44931.3 |
638 | 2024-04-26 08:16:09 | bocci | 1 | 28756 | 6 | 0.546 | 52666.7 |
637 | 2024-04-09 14:22:32 | bocci | 1 | 28756 | 6 | 0.563 | 51076.4 |
636 | 2024-04-05 23:28:43 | bocci | 2 | 53800 | 22 | 2.766 | 19450.5 |
635 | 2024-04-05 23:28:39 | bocci | 1 | 28756 | 6 | 0.500 | 57512.0 |
634 | 2024-04-03 06:15:47 | bocci | 3 | 83667 | 481 | 10.440 | 8014.1 |
633 | 2024-03-31 15:17:44 | bocci | 1 | 28756 | 6 | 0.530 | 54256.6 |
632 | 2024-03-30 20:05:32 | bocci | 3 | 83667 | 481 | 9.080 | 9214.4 |
631 | 2024-03-30 09:39:32 | bocci | 2 | 53800 | 22 | 2.826 | 19037.5 |
630 | 2024-03-30 09:38:57 | bocci | 1 | 28756 | 6 | 0.563 | 51076.4 |
629 | 2024-03-30 08:12:12 | bocci | 3 | 83667 | 481 | 4.143 | 20194.8 |
628 | 2024-03-30 08:12:13 | bocci | 2 | 53800 | 22 | 1.703 | 31591.3 |
627 | 2024-03-30 08:12:10 | bocci | 1 | 28756 | 6 | 0.500 | 57512.0 |
626 | 2024-03-29 02:02:50 | bocci | 1 | 28756 | 6 | 1.486 | 19351.3 |
625 | 2024-03-04 20:41:05 | bocci | 2 | 53800 | 22 | 1.750 | 30742.9 |
624 | 2024-03-04 20:41:05 | bocci | 1 | 28756 | 6 | 0.516 | 55728.7 |
623 | 2024-03-04 20:40:45 | bocci | 3 | 83667 | 481 | 4.393 | 19045.5 |
622 | 2024-03-04 20:40:34 | bocci | 3 | 83667 | 481 | 9.483 | 8822.8 |
621 | 2024-03-04 18:22:21 | bocci | 1 | 28756 | 6 | 1.093 | 26309.2 |
620 | 2024-03-01 17:12:41 | bocci | 3 | 83667 | 481 | 4.860 | 17215.4 |
619 | 2024-03-01 11:30:24 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
618 | 2024-03-01 04:01:04 | bocci | 2 | 53800 | 22 | 1.516 | 35488.1 |
617 | 2024-03-01 03:59:17 | bocci | 3 | 83667 | 481 | 3.953 | 21165.4 |
616 | 2024-02-28 23:18:45 | bocci | 3 | 83667 | 481 | 4.033 | 20745.6 |
615 | 2024-02-28 23:18:39 | bocci | 2 | 53800 | 22 | 2.966 | 18138.9 |
614 | 2024-02-28 23:18:37 | bocci | 1 | 28756 | 6 | 0.516 | 55728.7 |
613 | 2024-02-03 18:54:35 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
612 | 2024-01-29 10:05:51 | bocci | 1 | 28756 | 6 | 0.843 | 34111.5 |
611 | 2024-01-29 04:17:33 | bocci | 1 | 28756 | 6 | 0.500 | 57512.0 |
610 | 2024-01-16 17:32:07 | bocci | 3 | 83667 | 481 | 6.580 | 12715.3 |
609 | 2024-01-16 17:32:06 | bocci | 2 | 53800 | 22 | 1.593 | 33772.8 |
608 | 2024-01-15 02:30:55 | bocci | 2 | 53800 | 22 | 1.596 | 33709.3 |
607 | 2024-01-14 07:52:06 | bocci | 1 | 28756 | 6 | 0.516 | 55728.7 |
606 | 2023-12-28 20:18:27 | bocci | 1 | 28756 | 6 | 0.470 | 61183.0 |
605 | 2023-12-24 21:57:53 | bocci | 3 | 83667 | 481 | 4.076 | 20526.7 |
604 | 2023-12-24 21:57:47 | bocci | 2 | 53800 | 22 | 3.406 | 15795.7 |
603 | 2023-12-07 03:09:30 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |
602 | 2023-11-24 02:39:39 | bocci | 3 | 83667 | 481 | 3.656 | 22884.8 |
601 | 2023-11-17 13:24:58 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
600 | 2023-11-12 04:07:52 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |
599 | 2023-11-04 01:50:54 | bocci | 1 | 28756 | 6 | 0.440 | 65354.5 |
598 | 2023-10-23 19:31:09 | bocci | 2 | 53800 | 22 | 1.733 | 31044.4 |
597 | 2023-10-20 02:07:39 | bocci | 1 | 28756 | 6 | 1.096 | 26237.2 |
596 | 2023-10-18 15:15:55 | bocci | 1 | 28756 | 6 | 0.920 | 31256.5 |
595 | 2023-10-17 07:26:04 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |
594 | 2023-10-12 00:57:06 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
593 | 2023-10-05 22:09:09 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
592 | 2023-09-27 01:12:11 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
591 | 2023-09-20 18:42:43 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
590 | 2023-08-24 08:26:00 | bocci | 3 | 83667 | 481 | 3.593 | 23286.1 |
589 | 2023-08-18 00:20:47 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
588 | 2023-08-14 05:48:10 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
587 | 2023-08-03 12:33:11 | bocci | 2 | 53800 | 22 | 1.436 | 37465.2 |
586 | 2023-05-17 04:24:24 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
585 | 2023-05-07 13:12:25 | bocci | 1 | 28756 | 6 | 0.516 | 55728.7 |
584 | 2023-05-03 10:39:55 | bocci | 3 | 83667 | 481 | 3.703 | 22594.4 |
583 | 2023-05-01 16:04:33 | bocci | 3 | 83667 | 481 | 3.233 | 25879.1 |
582 | 2023-04-19 09:54:15 | bocci | 2 | 53800 | 22 | 1.326 | 40573.2 |
581 | 2023-03-31 20:46:55 | bocci | 3 | 83667 | 481 | 3.673 | 22778.9 |
580 | 2023-03-12 21:06:31 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
579 | 2023-03-11 03:48:17 | bocci | 3 | 83667 | 481 | 3.236 | 25855.1 |
578 | 2023-02-10 06:11:53 | bocci | 3 | 83667 | 481 | 3.156 | 26510.5 |
577 | 2023-02-01 21:14:33 | bocci | 1 | 28756 | 6 | 0.440 | 65354.5 |
576 | 2023-01-25 04:58:53 | bocci | 1 | 28756 | 6 | 0.436 | 65954.1 |
575 | 2023-01-20 13:20:07 | bocci | 2 | 53800 | 22 | 1.360 | 39558.8 |
574 | 2023-01-17 07:29:40 | bocci | 3 | 83667 | 481 | 3.170 | 26393.4 |
573 | 2023-01-02 04:06:34 | bocci | 1 | 28756 | 6 | 0.953 | 30174.2 |
572 | 2022-12-30 04:54:16 | bocci | 3 | 83667 | 481 | 3.873 | 21602.6 |
571 | 2022-12-20 10:56:38 | bocci | 3 | 83667 | 481 | 4.063 | 20592.4 |
570 | 2022-11-26 15:18:50 | bocci | 1 | 28756 | 6 | 0.500 | 57512.0 |
569 | 2022-11-25 05:55:58 | bocci | 1 | 28756 | 6 | 0.426 | 67502.3 |
568 | 2022-11-21 10:25:30 | bocci | 3 | 83667 | 481 | 3.653 | 22903.6 |
567 | 2022-10-31 19:52:15 | bocci | 2 | 53800 | 22 | 1.440 | 37361.1 |
566 | 2022-10-10 21:37:13 | bocci | 1 | 28756 | 6 | 0.440 | 65354.5 |
565 | 2022-09-30 17:32:38 | bocci | 1 | 28756 | 6 | 0.486 | 59168.7 |
564 | 2022-09-23 13:43:58 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
563 | 2022-09-10 11:10:47 | bocci | 1 | 28756 | 6 | 0.440 | 65354.5 |
562 | 2022-08-31 14:58:56 | bocci | 1 | 28756 | 6 | 0.513 | 56054.6 |
561 | 2022-08-15 15:58:21 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
560 | 2022-08-06 05:16:58 | bocci | 1 | 28756 | 6 | 1.263 | 22768.0 |
559 | 2022-07-18 09:52:53 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |
558 | 2022-07-17 21:19:07 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |
557 | 2022-07-03 14:07:59 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
556 | 2022-07-02 08:01:07 | bocci | 1 | 28756 | 6 | 0.530 | 54256.6 |
555 | 2022-06-25 21:21:50 | bocci | 3 | 83667 | 481 | 3.500 | 23904.9 |
554 | 2022-06-24 06:03:48 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |
553 | 2022-06-02 01:58:14 | bocci | 2 | 53800 | 22 | 1.360 | 39558.8 |
552 | 2022-05-18 14:44:10 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |
551 | 2022-05-07 17:00:24 | bocci | 1 | 28756 | 6 | 0.500 | 57512.0 |
550 | 2022-05-05 11:58:09 | bocci | 1 | 28756 | 6 | 0.466 | 61708.2 |
549 | 2022-03-01 09:08:52 | bocci | 1 | 28756 | 6 | 0.470 | 61183.0 |
548 | 2022-02-11 13:21:19 | bocci | 3 | 83667 | 481 | 3.313 | 25254.2 |
547 | 2022-01-24 11:35:00 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
546 | 2021-11-22 00:34:21 | bocci | 1 | 28756 | 6 | 0.500 | 57512.0 |
545 | 2021-11-21 02:14:24 | bocci | 1 | 28756 | 6 | 0.546 | 52666.7 |
544 | 2021-11-19 23:39:26 | bocci | 1 | 28756 | 6 | 0.470 | 61183.0 |
543 | 2021-10-05 15:58:22 | bocci | 1 | 28756 | 6 | 0.453 | 63479.0 |
542 | 2021-09-16 13:05:26 | bocci | 1 | 28756 | 6 | 0.500 | 57512.0 |
541 | 2021-08-18 05:04:02 | bocci | 1 | 28756 | 6 | 0.560 | 51350.0 |
540 | 2021-08-14 21:29:07 | bocci | 1 | 28756 | 6 | 0.483 | 59536.2 |