History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"realm"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
712 | 2024-02-28 06:39:29 | realm | 2 | 53800 | 93 | 2.233 | 24093.1 |
711 | 2024-02-28 06:39:12 | realm | 3 | 83667 | 1318 | 4.233 | 19765.4 |
710 | 2024-02-27 15:31:50 | realm | 2 | 53800 | 93 | 1.750 | 30742.9 |
709 | 2024-02-27 08:21:37 | realm | 3 | 83667 | 1318 | 8.546 | 9790.2 |
708 | 2024-02-26 09:48:52 | realm | 3 | 83667 | 1318 | 3.873 | 21602.6 |
707 | 2024-02-26 09:48:50 | realm | 2 | 53800 | 93 | 1.453 | 37026.8 |
706 | 2024-02-26 09:48:45 | realm | 1 | 28756 | 6 | 0.516 | 55728.7 |
705 | 2024-02-25 08:11:50 | realm | 1 | 28756 | 6 | 0.546 | 52666.7 |
704 | 2024-01-27 08:14:25 | realm | 1 | 28756 | 6 | 0.450 | 63902.2 |
703 | 2024-01-19 16:26:17 | realm | 3 | 83667 | 1318 | 3.436 | 24350.1 |
702 | 2024-01-06 17:48:16 | realm | 3 | 83667 | 1318 | 4.300 | 19457.4 |
701 | 2024-01-04 04:44:29 | realm | 2 | 53800 | 93 | 1.423 | 37807.4 |
700 | 2023-12-25 03:21:36 | realm | 3 | 83667 | 1318 | 5.640 | 14834.6 |
699 | 2023-12-14 02:07:50 | realm | 2 | 53800 | 93 | 1.453 | 37026.8 |
698 | 2023-12-14 02:07:46 | realm | 3 | 83667 | 1318 | 3.483 | 24021.5 |
697 | 2023-12-12 20:32:15 | realm | 3 | 83667 | 1318 | 3.546 | 23594.8 |
696 | 2023-12-12 15:10:32 | realm | 3 | 83667 | 1318 | 3.626 | 23074.2 |
695 | 2023-12-08 11:17:17 | realm | 3 | 83667 | 1318 | 3.670 | 22797.5 |
694 | 2023-12-07 16:30:33 | realm | 1 | 28756 | 6 | 0.610 | 47141.0 |
693 | 2023-12-07 16:30:32 | realm | 1 | 28756 | 6 | 0.546 | 52666.7 |
692 | 2023-12-06 12:09:56 | realm | 1 | 28756 | 6 | 0.500 | 57512.0 |
691 | 2023-12-02 02:04:27 | realm | 2 | 53800 | 93 | 1.716 | 31352.0 |
690 | 2023-11-18 07:02:32 | realm | 1 | 28756 | 6 | 0.453 | 63479.0 |
689 | 2023-11-14 04:44:34 | realm | 1 | 28756 | 6 | 0.453 | 63479.0 |
688 | 2023-11-13 14:29:02 | realm | 1 | 28756 | 6 | 0.500 | 57512.0 |
687 | 2023-11-12 09:07:07 | realm | 3 | 83667 | 1318 | 3.610 | 23176.5 |
686 | 2023-11-11 17:17:22 | realm | 3 | 83667 | 1318 | 3.436 | 24350.1 |
685 | 2023-11-11 02:02:21 | realm | 3 | 83667 | 1318 | 3.920 | 21343.6 |
684 | 2023-11-10 18:13:24 | realm | 3 | 83667 | 1318 | 4.063 | 20592.4 |
683 | 2023-11-10 05:23:25 | realm | 3 | 83667 | 1318 | 4.156 | 20131.6 |
682 | 2023-11-09 00:05:40 | realm | 3 | 83667 | 1318 | 3.376 | 24782.9 |
681 | 2023-11-08 21:35:49 | realm | 3 | 83667 | 1318 | 3.953 | 21165.4 |
680 | 2023-11-07 12:12:34 | realm | 3 | 83667 | 1318 | 8.236 | 10158.7 |
679 | 2023-11-07 12:12:25 | realm | 3 | 83667 | 1318 | 11.580 | 7225.1 |
678 | 2023-11-07 12:09:40 | realm | 1 | 28756 | 6 | 1.296 | 22188.3 |
677 | 2023-11-07 12:09:39 | realm | 1 | 28756 | 6 | 1.670 | 17219.2 |
676 | 2023-11-05 04:40:29 | realm | 3 | 83667 | 1318 | 4.296 | 19475.6 |
675 | 2023-11-03 15:43:36 | realm | 3 | 83667 | 1318 | 4.110 | 20356.9 |
674 | 2023-11-02 03:57:39 | realm | 3 | 83667 | 1318 | 3.690 | 22674.0 |
673 | 2023-10-31 10:24:42 | realm | 3 | 83667 | 1318 | 3.610 | 23176.5 |
672 | 2023-10-30 07:48:18 | realm | 3 | 83667 | 1318 | 3.516 | 23796.1 |
671 | 2023-10-29 16:51:28 | realm | 3 | 83667 | 1318 | 3.453 | 24230.2 |
670 | 2023-10-29 16:17:30 | realm | 1 | 28756 | 6 | 0.720 | 39938.9 |
669 | 2023-10-28 19:53:36 | realm | 1 | 28756 | 6 | 0.906 | 31739.5 |
668 | 2023-10-18 16:54:21 | realm | 1 | 28756 | 6 | 1.013 | 28387.0 |
667 | 2023-10-16 22:01:23 | realm | 3 | 83667 | 1318 | 7.063 | 11845.8 |
666 | 2023-10-16 02:29:44 | realm | 3 | 83667 | 1318 | 3.466 | 24139.4 |
665 | 2023-10-15 14:14:24 | realm | 1 | 28756 | 6 | 0.466 | 61708.2 |
664 | 2023-10-12 13:55:05 | realm | 3 | 83667 | 1318 | 3.546 | 23594.8 |
663 | 2023-10-05 03:24:34 | realm | 1 | 28756 | 6 | 0.500 | 57512.0 |
662 | 2023-09-26 09:29:31 | realm | 1 | 28756 | 6 | 0.466 | 61708.2 |
661 | 2023-09-22 17:56:20 | realm | 1 | 28756 | 6 | 0.500 | 57512.0 |
660 | 2023-09-19 23:08:23 | realm | 1 | 28756 | 6 | 0.453 | 63479.0 |
659 | 2023-08-18 19:25:41 | realm | 3 | 83667 | 1318 | 3.940 | 21235.3 |
658 | 2023-08-16 20:17:58 | realm | 3 | 83667 | 1318 | 4.093 | 20441.5 |
657 | 2023-08-15 15:43:19 | realm | 3 | 83667 | 1318 | 3.783 | 22116.6 |
656 | 2023-08-07 17:09:05 | realm | 3 | 83667 | 1318 | 3.593 | 23286.1 |
655 | 2023-07-30 23:28:28 | realm | 3 | 83667 | 1318 | 4.000 | 20916.8 |
654 | 2023-07-15 10:27:13 | realm | 1 | 28756 | 6 | 1.030 | 27918.4 |
653 | 2023-05-06 02:58:18 | realm | 3 | 83667 | 1318 | 3.360 | 24900.9 |
652 | 2023-04-24 13:18:42 | realm | 3 | 83667 | 1318 | 4.143 | 20194.8 |
651 | 2023-04-20 19:26:25 | realm | 3 | 83667 | 1318 | 3.516 | 23796.1 |
650 | 2023-03-27 14:32:38 | realm | 1 | 28756 | 6 | 0.533 | 53951.2 |
649 | 2023-01-26 14:54:17 | realm | 3 | 83667 | 1318 | 3.376 | 24782.9 |
648 | 2022-12-09 00:44:58 | realm | 1 | 28756 | 6 | 0.436 | 65954.1 |
647 | 2022-12-07 04:53:53 | realm | 3 | 83667 | 1318 | 3.500 | 23904.9 |
646 | 2022-12-06 04:56:46 | realm | 1 | 28756 | 6 | 0.483 | 59536.2 |
645 | 2022-12-05 22:11:47 | realm | 1 | 28756 | 6 | 0.483 | 59536.2 |
644 | 2022-11-07 18:59:15 | realm | 3 | 83667 | 1318 | 3.750 | 22311.2 |
643 | 2022-11-07 16:02:59 | realm | 3 | 83667 | 1318 | 3.440 | 24321.8 |
642 | 2022-10-31 13:56:18 | realm | 3 | 83667 | 1318 | 3.606 | 23202.2 |
641 | 2022-09-28 03:24:22 | realm | 3 | 83667 | 1318 | 3.423 | 24442.6 |
640 | 2022-09-01 18:58:33 | realm | 1 | 28756 | 6 | 0.516 | 55728.7 |
639 | 2022-08-25 20:46:29 | realm | 3 | 83667 | 1318 | 3.546 | 23594.8 |
638 | 2022-08-11 07:58:25 | realm | 1 | 28756 | 6 | 0.483 | 59536.2 |
637 | 2022-08-08 23:37:01 | realm | 1 | 28756 | 6 | 0.453 | 63479.0 |
636 | 2022-06-26 18:16:02 | realm | 3 | 83667 | 1318 | 3.500 | 23904.9 |
635 | 2022-06-10 03:08:26 | realm | 3 | 83667 | 1318 | 3.533 | 23681.6 |
634 | 2022-04-04 19:54:15 | realm | 1 | 28756 | 6 | 0.533 | 53951.2 |
633 | 2022-04-04 08:35:45 | realm | 1 | 28756 | 6 | 0.456 | 63061.4 |
632 | 2022-01-06 10:31:48 | realm | 1 | 28756 | 6 | 0.533 | 53951.2 |
631 | 2021-12-17 08:52:32 | realm | 1 | 28756 | 6 | 0.516 | 55728.7 |
630 | 2021-11-06 18:37:20 | realm | 1 | 28756 | 6 | 0.453 | 63479.0 |
629 | 2021-09-24 04:58:22 | realm | 1 | 28756 | 6 | 0.500 | 57512.0 |
628 | 2021-09-06 21:37:13 | realm | 1 | 28756 | 6 | 0.436 | 65954.1 |
627 | 2021-08-22 13:25:11 | realm | 1 | 28756 | 6 | 0.453 | 63479.0 |
626 | 2021-08-20 08:48:57 | realm | 1 | 28756 | 6 | 0.453 | 63479.0 |
625 | 2021-08-12 17:15:56 | realm | 1 | 28756 | 6 | 0.516 | 55728.7 |
624 | 2021-06-05 21:42:21 | realm | 1 | 28756 | 6 | 0.546 | 52666.7 |
623 | 2021-06-04 05:20:36 | realm | 1 | 28756 | 6 | 0.513 | 56054.6 |
622 | 2021-05-09 23:34:00 | realm | 1 | 28756 | 6 | 0.500 | 57512.0 |
621 | 2021-04-14 10:34:12 | realm | 3 | 83667 | 1318 | 3.640 | 22985.4 |
620 | 2021-04-08 14:11:26 | realm | 1 | 28756 | 6 | 0.503 | 57169.0 |
619 | 2021-03-03 19:03:46 | realm | 1 | 28756 | 6 | 0.436 | 65954.1 |
618 | 2021-02-24 12:21:06 | realm | 1 | 28756 | 6 | 0.546 | 52666.7 |
617 | 2021-01-27 23:17:19 | realm | 3 | 83667 | 1318 | 3.513 | 23816.4 |
616 | 2021-01-23 12:50:32 | realm | 1 | 28756 | 6 | 0.970 | 29645.4 |
615 | 2021-01-03 13:34:59 | realm | 3 | 83667 | 1318 | 4.076 | 20526.7 |
614 | 2020-12-17 01:55:39 | realm | 3 | 83667 | 1318 | 3.610 | 23176.5 |
613 | 2020-12-02 17:58:34 | realm | 1 | 28756 | 6 | 0.906 | 31739.5 |