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 |
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 |
607 | 2020-03-24 22:52:07 | vivid | 1 | 28756 | 3 | 0.516 | 55728.7 |
606 | 2020-03-23 02:17:18 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
605 | 2020-03-21 14:48:20 | vivid | 1 | 28756 | 3 | 0.453 | 63479.0 |
604 | 2020-03-18 16:37:17 | vivid | 1 | 28756 | 3 | 0.483 | 59536.2 |
603 | 2020-03-10 00:23:42 | vivid | 1 | 28756 | 3 | 0.436 | 65954.1 |
602 | 2020-02-27 16:32:02 | vivid | 1 | 28756 | 3 | 1.283 | 22413.1 |
601 | 2020-02-23 18:10:10 | vivid | 1 | 28756 | 3 | 1.046 | 27491.4 |
600 | 2020-02-23 15:50:16 | vivid | 1 | 28756 | 3 | 1.063 | 27051.7 |
599 | 2020-02-13 21:12:08 | vivid | 1 | 28756 | 3 | 0.893 | 32201.6 |
598 | 2020-02-05 21:36:51 | vivid | 1 | 28756 | 3 | 0.530 | 54256.6 |
597 | 2020-02-04 23:14:15 | vivid | 1 | 28756 | 3 | 0.563 | 51076.4 |
596 | 2020-02-02 22:25:17 | vivid | 1 | 28756 | 3 | 0.530 | 54256.6 |
595 | 2020-02-02 20:32:04 | vivid | 1 | 28756 | 3 | 0.640 | 44931.3 |
594 | 2020-02-02 19:44:01 | vivid | 1 | 28756 | 3 | 1.623 | 17717.8 |
593 | 2020-01-27 20:10:16 | vivid | 1 | 28756 | 3 | 1.030 | 27918.4 |
592 | 2020-01-22 00:31:24 | vivid | 1 | 28756 | 3 | 0.860 | 33437.2 |
591 | 2020-01-14 18:11:35 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
590 | 2020-01-14 08:45:08 | vivid | 3 | 83667 | 577 | 4.250 | 19686.4 |
589 | 2020-01-14 08:41:30 | vivid | 3 | 83667 | 577 | 4.153 | 20146.2 |
588 | 2020-01-14 02:28:25 | vivid | 3 | 83667 | 577 | 13.360 | 6262.5 |
587 | 2020-01-13 21:20:22 | vivid | 1 | 28756 | 3 | 0.546 | 52666.7 |
586 | 2020-01-12 02:30:23 | vivid | 1 | 28756 | 3 | 0.500 | 57512.0 |
585 | 2020-01-04 00:55:09 | vivid | 1 | 28756 | 3 | 0.483 | 59536.2 |
584 | 2019-12-27 18:23:07 | vivid | 1 | 28756 | 3 | 0.516 | 55728.7 |
583 | 2019-12-26 12:10:22 | vivid | 1 | 28756 | 3 | 0.986 | 29164.3 |