History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vivid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
707 | 2024-05-06 02:02:27 | vivid | 1 | 28756 | 3 | 1.076 | 26724.9 |
706 | 2024-05-05 19:30:23 | vivid | 3 | 83667 | 577 | 7.110 | 11767.5 |
705 | 2024-05-05 19:25:08 | vivid | 1 | 28756 | 3 | 1.626 | 17685.1 |
704 | 2024-05-05 19:24:59 | vivid | 2 | 53800 | 47 | 3.046 | 17662.5 |
703 | 2024-05-05 19:13:47 | vivid | 1 | 28756 | 3 | 0.923 | 31154.9 |
702 | 2024-05-05 03:15:00 | vivid | 3 | 83667 | 577 | 3.173 | 26368.4 |
701 | 2024-05-01 00:05:59 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
700 | 2024-04-29 15:47:13 | vivid | 1 | 28756 | 3 | 0.983 | 29253.3 |
699 | 2024-04-27 11:23:56 | vivid | 2 | 53800 | 47 | 5.266 | 10216.5 |
698 | 2024-04-27 11:23:14 | vivid | 3 | 83667 | 577 | 4.813 | 17383.5 |
697 | 2024-04-27 05:01:17 | vivid | 3 | 83667 | 577 | 8.453 | 9897.9 |
696 | 2024-04-16 04:42:54 | vivid | 1 | 28756 | 3 | 0.486 | 59168.7 |
695 | 2024-04-08 04:31:46 | vivid | 2 | 53800 | 47 | 1.763 | 30516.2 |
694 | 2024-04-08 04:31:26 | vivid | 3 | 83667 | 577 | 3.936 | 21256.9 |
693 | 2024-04-05 19:04:29 | vivid | 3 | 83667 | 577 | 14.500 | 5770.1 |
692 | 2024-04-05 19:04:28 | vivid | 2 | 53800 | 47 | 6.016 | 8942.8 |
691 | 2024-04-05 18:52:11 | vivid | 1 | 28756 | 3 | 1.250 | 23004.8 |
690 | 2024-04-05 04:10:27 | vivid | 1 | 28756 | 3 | 0.733 | 39230.6 |
689 | 2024-04-05 04:10:19 | vivid | 3 | 83667 | 577 | 5.050 | 16567.7 |
688 | 2024-04-05 04:10:17 | vivid | 2 | 53800 | 47 | 1.813 | 29674.6 |
687 | 2024-04-05 04:10:15 | vivid | 1 | 28756 | 3 | 1.153 | 24940.2 |
686 | 2024-03-31 14:25:52 | vivid | 3 | 83667 | 577 | 13.593 | 6155.2 |
685 | 2024-03-31 14:25:50 | vivid | 2 | 53800 | 47 | 4.406 | 12210.6 |
684 | 2024-03-31 14:15:16 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
683 | 2024-03-28 20:54:02 | vivid | 1 | 28756 | 3 | 1.126 | 25538.2 |
682 | 2024-03-13 04:41:27 | vivid | 2 | 53800 | 47 | 1.500 | 35866.7 |
681 | 2024-03-13 04:40:59 | vivid | 3 | 83667 | 577 | 8.110 | 10316.5 |
680 | 2024-03-12 17:27:56 | vivid | 3 | 83667 | 577 | 3.156 | 26510.5 |
679 | 2024-03-06 00:17:30 | vivid | 2 | 53800 | 47 | 3.643 | 14768.0 |
678 | 2024-03-06 00:17:28 | vivid | 1 | 28756 | 3 | 0.766 | 37540.5 |
677 | 2024-03-05 18:05:05 | vivid | 3 | 83667 | 577 | 9.203 | 9091.3 |
676 | 2024-03-04 18:32:06 | vivid | 3 | 83667 | 577 | 12.860 | 6506.0 |
675 | 2024-03-04 18:32:03 | vivid | 2 | 53800 | 47 | 5.453 | 9866.1 |
674 | 2024-03-04 18:19:10 | vivid | 1 | 28756 | 3 | 0.546 | 52666.7 |
673 | 2024-03-01 11:52:47 | vivid | 1 | 28756 | 3 | 0.423 | 67981.1 |
672 | 2024-02-27 19:32:53 | vivid | 1 | 28756 | 3 | 0.516 | 55728.7 |
671 | 2024-02-03 17:33:07 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
670 | 2024-01-28 18:19:01 | vivid | 1 | 28756 | 3 | 0.470 | 61183.0 |
669 | 2024-01-22 23:03:26 | vivid | 3 | 83667 | 577 | 3.156 | 26510.5 |
668 | 2024-01-22 22:07:38 | vivid | 1 | 28756 | 3 | 0.466 | 61708.2 |
667 | 2024-01-10 19:17:44 | vivid | 2 | 53800 | 47 | 1.610 | 33416.1 |
666 | 2024-01-09 06:14:08 | vivid | 3 | 83667 | 577 | 4.046 | 20678.9 |
665 | 2024-01-02 23:06:24 | vivid | 2 | 53800 | 47 | 1.813 | 29674.6 |
664 | 2024-01-02 23:06:19 | vivid | 3 | 83667 | 577 | 4.483 | 18663.2 |
663 | 2023-12-28 08:20:36 | vivid | 3 | 83667 | 577 | 3.110 | 26902.6 |
662 | 2023-11-17 14:53:44 | vivid | 1 | 28756 | 3 | 0.453 | 63479.0 |
661 | 2023-11-17 11:29:56 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
660 | 2023-11-16 00:24:41 | vivid | 3 | 83667 | 577 | 3.156 | 26510.5 |
659 | 2023-11-16 00:24:33 | vivid | 2 | 53800 | 47 | 1.546 | 34799.5 |
658 | 2023-11-13 22:59:45 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
657 | 2023-11-04 01:43:31 | vivid | 1 | 28756 | 3 | 0.970 | 29645.4 |
656 | 2023-10-21 12:09:55 | vivid | 1 | 28756 | 3 | 0.420 | 68466.7 |
655 | 2023-10-19 00:09:15 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
654 | 2023-10-16 11:56:47 | vivid | 1 | 28756 | 3 | 0.953 | 30174.2 |
653 | 2023-10-07 12:28:27 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
652 | 2023-10-04 19:56:37 | vivid | 3 | 83667 | 577 | 3.156 | 26510.5 |
651 | 2023-10-01 16:28:18 | vivid | 3 | 83667 | 577 | 3.580 | 23370.7 |
650 | 2023-09-28 12:10:48 | vivid | 1 | 28756 | 3 | 0.423 | 67981.1 |
649 | 2023-09-13 12:27:21 | vivid | 1 | 28756 | 3 | 0.466 | 61708.2 |
648 | 2023-09-04 22:56:56 | vivid | 1 | 28756 | 3 | 0.483 | 59536.2 |
647 | 2023-07-12 01:13:38 | vivid | 3 | 83667 | 577 | 3.826 | 21868.0 |
646 | 2023-06-21 20:01:05 | vivid | 3 | 83667 | 577 | 3.203 | 26121.4 |
645 | 2023-06-01 19:25:23 | vivid | 1 | 28756 | 3 | 0.936 | 30722.2 |
644 | 2023-05-23 07:06:12 | vivid | 3 | 83667 | 577 | 3.733 | 22412.8 |
643 | 2023-04-02 13:31:40 | vivid | 3 | 83667 | 577 | 3.750 | 22311.2 |
642 | 2023-03-26 09:12:18 | vivid | 1 | 28756 | 3 | 0.470 | 61183.0 |
641 | 2023-01-18 22:34:59 | vivid | 3 | 83667 | 577 | 3.123 | 26790.6 |
640 | 2023-01-10 00:57:40 | vivid | 1 | 28756 | 3 | 0.423 | 67981.1 |
639 | 2023-01-01 21:07:08 | vivid | 3 | 83667 | 577 | 3.126 | 26764.9 |
638 | 2022-12-26 15:29:25 | vivid | 3 | 83667 | 577 | 3.126 | 26764.9 |
637 | 2022-11-27 21:19:18 | vivid | 3 | 83667 | 577 | 3.576 | 23396.8 |
636 | 2022-11-09 23:08:08 | vivid | 3 | 83667 | 577 | 3.750 | 22311.2 |
635 | 2022-11-07 03:43:40 | vivid | 3 | 83667 | 577 | 3.063 | 27315.4 |
634 | 2022-11-07 03:43:35 | vivid | 3 | 83667 | 577 | 3.563 | 23482.2 |
633 | 2022-10-11 00:26:13 | vivid | 1 | 28756 | 3 | 0.453 | 63479.0 |
632 | 2022-10-02 22:53:36 | vivid | 3 | 83667 | 577 | 3.296 | 25384.4 |
631 | 2022-09-08 16:19:57 | vivid | 3 | 83667 | 577 | 3.203 | 26121.4 |
630 | 2022-07-30 02:27:09 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
629 | 2022-07-03 10:14:54 | vivid | 1 | 28756 | 3 | 0.420 | 68466.7 |
628 | 2022-06-16 10:12:07 | vivid | 1 | 28756 | 3 | 0.420 | 68466.7 |
627 | 2022-05-28 17:15:05 | vivid | 1 | 28756 | 3 | 0.423 | 67981.1 |
626 | 2022-05-26 13:41:45 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
625 | 2022-05-26 02:33:03 | vivid | 1 | 28756 | 3 | 0.440 | 65354.5 |
624 | 2022-04-01 02:54:11 | vivid | 3 | 83667 | 577 | 3.953 | 21165.4 |
623 | 2022-02-05 12:54:42 | vivid | 1 | 28756 | 3 | 0.423 | 67981.1 |
622 | 2022-02-03 09:34:30 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
621 | 2021-12-16 18:49:50 | vivid | 3 | 83667 | 577 | 3.813 | 21942.6 |
620 | 2021-11-27 07:46:08 | vivid | 1 | 28756 | 3 | 0.456 | 63061.4 |
619 | 2021-11-25 06:10:34 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
618 | 2021-05-18 20:38:02 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
617 | 2021-04-18 20:30:25 | vivid | 1 | 28756 | 3 | 0.483 | 59536.2 |
616 | 2020-12-26 03:14:19 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
615 | 2020-12-22 05:46:35 | vivid | 1 | 28756 | 3 | 0.483 | 59536.2 |
614 | 2020-11-03 11:55:42 | vivid | 1 | 28756 | 3 | 0.453 | 63479.0 |
613 | 2020-10-31 05:54:19 | vivid | 1 | 28756 | 3 | 0.440 | 65354.5 |
612 | 2020-10-16 00:37:28 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
611 | 2020-09-27 13:34:22 | vivid | 1 | 28756 | 3 | 0.423 | 67981.1 |
610 | 2020-09-26 18:02:30 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
609 | 2020-03-27 06:44:58 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
608 | 2020-03-25 22:00:24 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |