History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"happy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
710 | 2025-06-03 22:14:20 | happy | 1 | 28756 | 10 | 2.483 | 11581.2 |
709 | 2025-06-02 11:33:55 | happy | 1 | 28756 | 10 | 3.953 | 7274.5 |
708 | 2025-05-31 12:17:06 | happy | 1 | 28756 | 10 | 2.220 | 12953.2 |
707 | 2025-05-31 12:04:46 | happy | 1 | 28756 | 10 | 2.530 | 11366.0 |
706 | 2025-05-29 13:15:24 | happy | 1 | 28756 | 10 | 3.893 | 7386.6 |
705 | 2025-05-23 01:41:01 | happy | 1 | 28756 | 10 | 3.296 | 8724.5 |
704 | 2025-05-22 19:03:56 | happy | 1 | 28756 | 10 | 0.513 | 56054.6 |
703 | 2025-05-17 05:27:49 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
702 | 2025-05-16 06:42:12 | happy | 1 | 28756 | 10 | 1.956 | 14701.4 |
701 | 2025-05-16 04:04:25 | happy | 1 | 28756 | 10 | 1.593 | 18051.5 |
700 | 2025-05-15 15:24:58 | happy | 1 | 28756 | 10 | 0.440 | 65354.5 |
699 | 2025-05-10 05:29:59 | happy | 1 | 28756 | 10 | 1.500 | 19170.7 |
698 | 2025-05-08 19:03:55 | happy | 1 | 28756 | 10 | 0.890 | 32310.1 |
697 | 2025-05-08 15:13:33 | happy | 2 | 53800 | 70 | 8.250 | 6521.2 |
696 | 2025-05-08 05:24:40 | happy | 1 | 28756 | 10 | 2.953 | 9737.9 |
695 | 2025-05-08 05:17:50 | happy | 1 | 28756 | 10 | 2.420 | 11882.6 |
694 | 2025-05-07 00:40:28 | happy | 2 | 53800 | 70 | 1.390 | 38705.0 |
693 | 2025-05-03 21:59:47 | happy | 1 | 28756 | 10 | 2.356 | 12205.4 |
692 | 2025-05-02 11:32:45 | happy | 1 | 28756 | 10 | 1.076 | 26724.9 |
691 | 2025-05-02 04:13:27 | happy | 1 | 28756 | 10 | 2.420 | 11882.6 |
690 | 2025-04-30 13:26:40 | happy | 2 | 53800 | 70 | 6.546 | 8218.8 |
689 | 2025-04-30 11:56:59 | happy | 1 | 28756 | 10 | 3.063 | 9388.2 |
688 | 2025-04-29 04:10:24 | happy | 2 | 53800 | 70 | 1.580 | 34050.6 |
687 | 2025-04-28 10:51:47 | happy | 2 | 53800 | 70 | 8.406 | 6400.2 |
686 | 2025-04-25 17:03:27 | happy | 2 | 53800 | 70 | 1.610 | 33416.1 |
685 | 2025-04-22 10:42:52 | happy | 2 | 53800 | 70 | 8.203 | 6558.6 |
684 | 2025-04-19 16:43:10 | happy | 1 | 28756 | 10 | 0.890 | 32310.1 |
683 | 2025-04-19 16:21:05 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
682 | 2025-04-16 04:41:17 | happy | 1 | 28756 | 10 | 1.076 | 26724.9 |
681 | 2025-04-16 04:06:04 | happy | 1 | 28756 | 10 | 2.343 | 12273.2 |
680 | 2025-04-09 05:35:39 | happy | 1 | 28756 | 10 | 4.753 | 6050.1 |
679 | 2025-04-01 21:54:54 | happy | 1 | 28756 | 10 | 3.393 | 8475.1 |
678 | 2025-03-31 13:26:20 | happy | 1 | 28756 | 10 | 1.156 | 24875.4 |
677 | 2025-03-16 15:20:02 | happy | 1 | 28756 | 10 | 0.546 | 52666.7 |
676 | 2025-03-16 12:35:00 | happy | 2 | 53800 | 70 | 7.500 | 7173.3 |
675 | 2025-03-16 08:41:57 | happy | 2 | 53800 | 70 | 7.670 | 7014.3 |
674 | 2025-03-16 08:41:57 | happy | 1 | 28756 | 10 | 1.296 | 22188.3 |
673 | 2025-03-15 17:56:35 | happy | 1 | 28756 | 10 | 1.376 | 20898.3 |
672 | 2025-03-09 23:47:22 | happy | 1 | 28756 | 10 | 1.123 | 25606.4 |
671 | 2025-03-02 12:02:26 | happy | 1 | 28756 | 10 | 2.330 | 12341.6 |
670 | 2025-02-27 16:04:21 | happy | 3 | 83667 | 893 | 14.313 | 5845.5 |
669 | 2025-02-27 15:14:11 | happy | 3 | 83667 | 893 | 23.706 | 3529.4 |
668 | 2025-02-27 06:50:37 | happy | 2 | 53800 | 70 | 12.066 | 4458.8 |
667 | 2025-02-27 03:22:36 | happy | 2 | 53800 | 70 | 3.703 | 14528.8 |
666 | 2025-02-27 00:37:39 | happy | 3 | 83667 | 893 | 15.736 | 5316.9 |
665 | 2025-02-26 23:46:49 | happy | 3 | 83667 | 893 | 20.186 | 4144.8 |
664 | 2025-02-26 23:46:44 | happy | 2 | 53800 | 70 | 8.546 | 6295.3 |
663 | 2025-02-26 23:45:12 | happy | 1 | 28756 | 10 | 1.810 | 15887.3 |
662 | 2025-02-26 13:19:23 | happy | 1 | 28756 | 10 | 2.390 | 12031.8 |
661 | 2025-02-25 03:24:57 | happy | 2 | 53800 | 70 | 4.063 | 13241.4 |
660 | 2025-02-24 13:42:53 | happy | 1 | 28756 | 10 | 1.126 | 25538.2 |
659 | 2025-02-08 05:23:29 | happy | 1 | 28756 | 10 | 2.923 | 9837.8 |
658 | 2025-02-07 01:52:34 | happy | 1 | 28756 | 10 | 2.640 | 10892.4 |
657 | 2025-01-28 08:05:57 | happy | 3 | 83667 | 893 | 12.876 | 6497.9 |
656 | 2025-01-27 23:47:08 | happy | 2 | 53800 | 70 | 8.033 | 6697.4 |
655 | 2025-01-27 20:17:25 | happy | 3 | 83667 | 893 | 4.326 | 19340.5 |
654 | 2025-01-27 18:33:11 | happy | 2 | 53800 | 70 | 5.843 | 9207.6 |
653 | 2025-01-27 18:29:00 | happy | 3 | 83667 | 893 | 21.563 | 3880.1 |
652 | 2025-01-27 10:47:23 | happy | 3 | 83667 | 893 | 14.580 | 5738.5 |
651 | 2025-01-27 10:47:24 | happy | 2 | 53800 | 70 | 10.546 | 5101.5 |
650 | 2025-01-27 10:44:05 | happy | 1 | 28756 | 10 | 0.513 | 56054.6 |
649 | 2025-01-26 23:36:19 | happy | 1 | 28756 | 10 | 0.483 | 59536.2 |
648 | 2025-01-16 04:42:37 | happy | 1 | 28756 | 10 | 0.530 | 54256.6 |
647 | 2025-01-06 18:37:21 | happy | 1 | 28756 | 10 | 1.656 | 17364.7 |
646 | 2024-12-29 04:03:19 | happy | 3 | 83667 | 893 | 18.516 | 4518.6 |
645 | 2024-12-28 18:06:33 | happy | 3 | 83667 | 893 | 23.406 | 3574.6 |
644 | 2024-12-28 15:48:40 | happy | 2 | 53800 | 70 | 1.813 | 29674.6 |
643 | 2024-12-28 15:40:17 | happy | 3 | 83667 | 893 | 18.750 | 4462.2 |
642 | 2024-12-28 15:38:52 | happy | 3 | 83667 | 893 | 12.140 | 6891.8 |
641 | 2024-12-28 13:14:54 | happy | 2 | 53800 | 70 | 7.906 | 6805.0 |
640 | 2024-12-27 22:05:03 | happy | 1 | 28756 | 10 | 1.440 | 19969.4 |
639 | 2024-12-27 19:45:24 | happy | 3 | 83667 | 893 | 18.373 | 4553.8 |
638 | 2024-12-27 19:45:23 | happy | 2 | 53800 | 70 | 5.140 | 10466.9 |
637 | 2024-12-27 19:08:26 | happy | 1 | 28756 | 10 | 0.516 | 55728.7 |
636 | 2024-11-28 20:59:46 | happy | 3 | 83667 | 893 | 22.736 | 3679.9 |
635 | 2024-11-28 12:19:49 | happy | 3 | 83667 | 893 | 4.016 | 20833.4 |
634 | 2024-11-28 06:31:47 | happy | 3 | 83667 | 893 | 34.643 | 2415.1 |
633 | 2024-11-27 20:38:27 | happy | 1 | 28756 | 10 | 0.513 | 56054.6 |
632 | 2024-11-27 12:07:16 | happy | 3 | 83667 | 893 | 20.876 | 4007.8 |
631 | 2024-11-27 12:07:16 | happy | 2 | 53800 | 70 | 3.796 | 14172.8 |
630 | 2024-11-27 12:01:27 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
629 | 2024-11-27 07:58:04 | happy | 1 | 28756 | 10 | 2.843 | 10114.7 |
628 | 2024-11-07 07:46:15 | happy | 1 | 28756 | 10 | 0.970 | 29645.4 |
627 | 2024-10-29 16:08:12 | happy | 3 | 83667 | 893 | 16.093 | 5199.0 |
626 | 2024-10-29 09:02:32 | happy | 3 | 83667 | 893 | 8.736 | 9577.3 |
625 | 2024-10-28 19:12:30 | happy | 1 | 28756 | 10 | 3.640 | 7900.0 |
624 | 2024-10-28 03:54:31 | happy | 3 | 83667 | 893 | 16.800 | 4980.2 |
623 | 2024-10-28 02:42:09 | happy | 1 | 28756 | 10 | 0.530 | 54256.6 |
622 | 2024-10-27 06:01:33 | happy | 1 | 28756 | 10 | 1.406 | 20452.3 |
621 | 2024-10-22 07:06:33 | happy | 1 | 28756 | 10 | 1.440 | 19969.4 |
620 | 2024-10-20 10:32:35 | happy | 1 | 28756 | 10 | 1.626 | 17685.1 |
619 | 2024-10-08 06:03:48 | happy | 1 | 28756 | 10 | 4.410 | 6520.6 |
618 | 2024-09-29 14:35:54 | happy | 2 | 53800 | 70 | 1.610 | 33416.1 |
617 | 2024-09-29 08:23:23 | happy | 3 | 83667 | 893 | 28.610 | 2924.4 |
616 | 2024-09-29 04:16:46 | happy | 2 | 53800 | 70 | 9.313 | 5776.9 |
615 | 2024-09-28 20:07:22 | happy | 3 | 83667 | 893 | 40.923 | 2044.5 |
614 | 2024-09-28 16:57:03 | happy | 3 | 83667 | 893 | 18.533 | 4514.5 |
613 | 2024-09-28 16:57:06 | happy | 2 | 53800 | 70 | 13.500 | 3985.2 |
612 | 2024-09-28 16:56:47 | happy | 1 | 28756 | 10 | 3.940 | 7298.5 |
611 | 2024-09-28 00:01:13 | happy | 1 | 28756 | 10 | 0.470 | 61183.0 |