History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crown"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
740 | 2024-03-27 04:19:47 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
739 | 2024-03-18 21:55:59 | crown | 1 | 28756 | 11 | 1.110 | 25906.3 |
738 | 2024-03-07 10:09:53 | crown | 1 | 28756 | 11 | 1.140 | 25224.6 |
737 | 2024-03-04 00:27:40 | crown | 1 | 28756 | 11 | 0.970 | 29645.4 |
736 | 2024-02-25 18:32:56 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
735 | 2024-02-02 21:11:55 | crown | 1 | 28756 | 11 | 0.530 | 54256.6 |
734 | 2024-01-26 00:48:33 | crown | 1 | 28756 | 11 | 0.483 | 59536.2 |
733 | 2024-01-22 12:27:05 | crown | 1 | 28756 | 11 | 1.106 | 26000.0 |
732 | 2024-01-18 15:22:01 | crown | 2 | 53800 | 104 | 1.736 | 30990.8 |
731 | 2024-01-15 12:48:04 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
730 | 2023-12-14 21:15:17 | crown | 2 | 53800 | 104 | 1.546 | 34799.5 |
729 | 2023-12-12 15:56:42 | crown | 2 | 53800 | 104 | 1.673 | 32157.8 |
728 | 2023-12-08 02:16:31 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
727 | 2023-12-01 13:36:21 | crown | 1 | 28756 | 11 | 0.516 | 55728.7 |
726 | 2023-11-18 01:38:55 | crown | 1 | 28756 | 11 | 0.513 | 56054.6 |
725 | 2023-11-11 10:58:07 | crown | 1 | 28756 | 11 | 0.530 | 54256.6 |
724 | 2023-11-11 09:22:48 | crown | 1 | 28756 | 11 | 0.483 | 59536.2 |
723 | 2023-10-27 22:34:12 | crown | 2 | 53800 | 104 | 1.576 | 34137.1 |
722 | 2023-10-27 08:05:08 | crown | 1 | 28756 | 11 | 0.440 | 65354.5 |
721 | 2023-10-25 12:57:56 | crown | 2 | 53800 | 104 | 1.550 | 34709.7 |
720 | 2023-10-19 19:01:52 | crown | 1 | 28756 | 11 | 1.076 | 26724.9 |
719 | 2023-10-19 12:12:32 | crown | 1 | 28756 | 11 | 0.513 | 56054.6 |
718 | 2023-10-11 13:02:15 | crown | 1 | 28756 | 11 | 0.483 | 59536.2 |
717 | 2023-10-06 23:53:32 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
716 | 2023-09-26 00:02:26 | crown | 1 | 28756 | 11 | 0.483 | 59536.2 |
715 | 2023-09-14 03:50:43 | crown | 1 | 28756 | 11 | 0.513 | 56054.6 |
714 | 2023-09-13 12:49:41 | crown | 2 | 53800 | 104 | 1.486 | 36204.6 |
713 | 2023-08-30 03:43:53 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
712 | 2023-08-15 15:35:08 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
711 | 2023-06-04 16:17:59 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
710 | 2023-06-02 05:53:08 | crown | 2 | 53800 | 104 | 1.376 | 39098.8 |
709 | 2023-05-08 13:37:20 | crown | 1 | 28756 | 11 | 0.470 | 61183.0 |
708 | 2023-04-24 21:48:37 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
707 | 2023-03-29 03:20:37 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
706 | 2023-03-18 13:40:14 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
705 | 2023-03-08 04:25:14 | crown | 2 | 53800 | 104 | 1.406 | 38264.6 |
704 | 2023-01-29 19:26:47 | crown | 1 | 28756 | 11 | 0.486 | 59168.7 |
703 | 2023-01-12 00:27:20 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
702 | 2022-12-14 10:03:43 | crown | 2 | 53800 | 104 | 1.703 | 31591.3 |
701 | 2022-10-31 22:19:04 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
700 | 2022-10-11 22:14:50 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
699 | 2022-08-04 17:25:49 | crown | 2 | 53800 | 104 | 1.390 | 38705.0 |
698 | 2022-06-21 00:54:49 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
697 | 2022-06-17 19:28:23 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
696 | 2022-06-14 02:08:01 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
695 | 2022-02-26 06:37:57 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
694 | 2022-02-23 11:53:43 | crown | 1 | 28756 | 11 | 0.766 | 37540.5 |
693 | 2021-12-11 01:52:33 | crown | 1 | 28756 | 11 | 0.486 | 59168.7 |
692 | 2021-12-02 09:12:08 | crown | 1 | 28756 | 11 | 0.546 | 52666.7 |
691 | 2021-11-08 17:09:55 | crown | 1 | 28756 | 11 | 0.983 | 29253.3 |
690 | 2021-10-29 08:26:23 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
689 | 2021-10-22 10:57:17 | crown | 1 | 28756 | 11 | 0.516 | 55728.7 |
688 | 2021-09-22 03:50:27 | crown | 1 | 28756 | 11 | 0.596 | 48248.3 |
687 | 2021-09-21 18:14:27 | crown | 1 | 28756 | 11 | 0.470 | 61183.0 |
686 | 2021-09-15 02:28:56 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
685 | 2021-09-10 08:11:25 | crown | 1 | 28756 | 11 | 0.483 | 59536.2 |
684 | 2021-09-08 03:50:43 | crown | 1 | 28756 | 11 | 0.966 | 29768.1 |
683 | 2021-08-21 13:31:19 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
682 | 2021-08-05 15:27:13 | crown | 1 | 28756 | 11 | 0.470 | 61183.0 |
681 | 2021-07-16 18:07:49 | crown | 2 | 53800 | 104 | 1.376 | 39098.8 |
680 | 2021-05-29 14:59:27 | crown | 1 | 28756 | 11 | 1.046 | 27491.4 |
679 | 2021-05-05 23:28:47 | crown | 2 | 53800 | 104 | 1.830 | 29398.9 |
678 | 2021-05-04 03:14:10 | crown | 1 | 28756 | 11 | 1.030 | 27918.4 |
677 | 2021-04-27 18:39:40 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
676 | 2021-02-12 10:07:01 | crown | 2 | 53800 | 104 | 1.403 | 38346.4 |
675 | 2021-01-23 03:44:18 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
674 | 2021-01-17 07:34:41 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
673 | 2021-01-05 10:45:14 | crown | 2 | 53800 | 104 | 2.266 | 23742.3 |
672 | 2021-01-05 10:34:54 | crown | 2 | 53800 | 104 | 1.410 | 38156.0 |
671 | 2021-01-05 10:34:19 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
670 | 2020-11-06 00:24:09 | crown | 1 | 28756 | 11 | 0.483 | 59536.2 |
669 | 2020-10-30 23:50:30 | crown | 1 | 28756 | 11 | 0.560 | 51350.0 |
668 | 2020-10-23 05:48:30 | crown | 2 | 53800 | 104 | 1.610 | 33416.1 |
667 | 2020-10-21 05:01:18 | crown | 1 | 28756 | 11 | 0.486 | 59168.7 |
666 | 2020-10-18 05:10:36 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
665 | 2020-10-12 03:13:20 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
664 | 2020-10-03 08:13:11 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
663 | 2020-09-27 11:54:12 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
662 | 2020-09-21 05:00:34 | crown | 1 | 28756 | 11 | 0.466 | 61708.2 |
661 | 2020-09-01 10:18:08 | crown | 1 | 28756 | 11 | 0.516 | 55728.7 |
660 | 2020-08-29 20:15:20 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
659 | 2020-08-18 11:19:52 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
658 | 2020-07-30 20:26:00 | crown | 1 | 28756 | 11 | 0.516 | 55728.7 |
657 | 2020-07-20 01:52:25 | crown | 1 | 28756 | 11 | 0.466 | 61708.2 |
656 | 2020-07-19 01:42:00 | crown | 1 | 28756 | 11 | 0.466 | 61708.2 |
655 | 2020-07-16 05:37:26 | crown | 1 | 28756 | 11 | 0.470 | 61183.0 |
654 | 2020-07-15 04:31:22 | crown | 1 | 28756 | 11 | 0.466 | 61708.2 |
653 | 2020-06-14 10:00:24 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
652 | 2020-06-13 11:27:06 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
651 | 2020-06-10 15:17:42 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
650 | 2020-06-09 16:01:19 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
649 | 2020-06-08 16:02:02 | crown | 1 | 28756 | 11 | 0.516 | 55728.7 |
648 | 2020-06-02 06:57:16 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
647 | 2020-06-02 03:35:06 | crown | 1 | 28756 | 11 | 0.470 | 61183.0 |
646 | 2020-06-01 07:30:03 | crown | 1 | 28756 | 11 | 0.483 | 59536.2 |
645 | 2020-06-01 03:59:00 | crown | 1 | 28756 | 11 | 0.453 | 63479.0 |
644 | 2020-05-29 04:31:18 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |
643 | 2020-05-27 04:07:51 | crown | 1 | 28756 | 11 | 0.486 | 59168.7 |
642 | 2020-05-25 19:07:28 | crown | 1 | 28756 | 11 | 0.500 | 57512.0 |
641 | 2020-05-24 02:36:21 | crown | 1 | 28756 | 11 | 0.436 | 65954.1 |