History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
704 | 2025-07-17 16:45:47 | harper | 1 | 48755 | 9 | 5.563 | 8764.2 |
703 | 2025-07-16 22:40:33 | harper | 2 | 82551 | 162 | 6.733 | 12260.7 |
702 | 2025-07-15 19:32:48 | harper | 1 | 48755 | 9 | 0.940 | 51867.0 |
701 | 2025-07-14 21:05:04 | harper | 2 | 82551 | 162 | 10.236 | 8064.8 |
700 | 2025-07-11 01:10:39 | harper | 1 | 48755 | 9 | 2.080 | 23439.9 |
699 | 2025-07-10 15:20:49 | harper | 1 | 48755 | 9 | 1.873 | 26030.4 |
698 | 2025-07-02 11:03:17 | harper | 1 | 48755 | 9 | 4.500 | 10834.4 |
697 | 2025-06-30 05:48:15 | harper | 1 | 48755 | 9 | 4.310 | 11312.1 |
696 | 2025-06-28 05:28:26 | harper | 1 | 48755 | 9 | 6.656 | 7325.0 |
695 | 2025-06-23 05:01:56 | harper | 1 | 48755 | 9 | 3.203 | 15221.7 |
694 | 2025-06-23 03:49:56 | harper | 1 | 48755 | 9 | 0.750 | 65006.7 |
693 | 2025-06-22 17:20:31 | harper | 1 | 48755 | 9 | 2.046 | 23829.4 |
692 | 2025-06-22 10:36:31 | harper | 2 | 82551 | 162 | 12.250 | 6738.9 |
691 | 2025-06-19 11:42:08 | harper | 1 | 48755 | 9 | 6.596 | 7391.6 |
690 | 2025-06-10 17:37:01 | harper | 1 | 48755 | 9 | 4.110 | 11862.5 |
689 | 2025-06-10 03:06:47 | harper | 1 | 48755 | 9 | 2.403 | 20289.2 |
688 | 2025-06-10 02:30:06 | harper | 1 | 48755 | 9 | 6.390 | 7629.9 |
687 | 2025-06-07 14:44:53 | harper | 1 | 48755 | 9 | 0.893 | 54596.9 |
686 | 2025-06-02 10:09:26 | harper | 1 | 48755 | 9 | 2.173 | 22436.7 |
685 | 2025-05-31 19:32:46 | harper | 1 | 48755 | 9 | 4.733 | 10301.1 |
684 | 2025-05-31 16:39:35 | harper | 1 | 48755 | 9 | 2.203 | 22131.2 |
683 | 2025-05-31 16:09:07 | harper | 1 | 48755 | 9 | 4.983 | 9784.3 |
682 | 2025-05-31 05:07:18 | harper | 1 | 48755 | 9 | 1.940 | 25131.4 |
681 | 2025-05-25 19:58:33 | harper | 1 | 48755 | 9 | 0.890 | 54780.9 |
680 | 2025-05-21 09:35:12 | harper | 2 | 82551 | 162 | 2.640 | 31269.3 |
679 | 2025-05-20 13:00:22 | harper | 2 | 82551 | 162 | 8.623 | 9573.4 |
678 | 2025-05-18 21:00:38 | harper | 2 | 82551 | 162 | 2.716 | 30394.3 |
677 | 2025-05-14 15:20:52 | harper | 2 | 82551 | 162 | 6.376 | 12947.1 |
676 | 2025-05-12 22:02:12 | harper | 2 | 82551 | 162 | 2.626 | 31436.0 |
675 | 2025-05-10 02:59:44 | harper | 1 | 48755 | 9 | 3.656 | 13335.6 |
674 | 2025-05-10 02:08:49 | harper | 1 | 48755 | 9 | 4.000 | 12188.8 |
673 | 2025-05-09 09:47:42 | harper | 1 | 48755 | 9 | 0.876 | 55656.4 |
672 | 2025-05-02 10:43:36 | harper | 1 | 48755 | 9 | 2.033 | 23981.8 |
671 | 2025-04-30 09:11:52 | harper | 2 | 82551 | 162 | 11.360 | 7266.8 |
670 | 2025-04-30 04:34:55 | harper | 1 | 48755 | 9 | 6.216 | 7843.5 |
669 | 2025-04-29 02:10:56 | harper | 2 | 82551 | 162 | 2.830 | 29170.0 |
668 | 2025-04-19 22:07:41 | harper | 1 | 48755 | 9 | 2.470 | 19738.9 |
667 | 2025-04-12 14:40:05 | harper | 2 | 82551 | 162 | 10.500 | 7862.0 |
666 | 2025-04-12 02:52:54 | harper | 2 | 82551 | 162 | 12.360 | 6678.9 |
665 | 2025-04-10 02:52:23 | harper | 2 | 82551 | 162 | 3.076 | 26837.1 |
664 | 2025-04-09 02:41:28 | harper | 1 | 48755 | 9 | 1.893 | 25755.4 |
663 | 2025-04-08 01:37:55 | harper | 1 | 48755 | 9 | 1.920 | 25393.2 |
662 | 2025-04-04 21:10:02 | harper | 1 | 48755 | 9 | 5.970 | 8166.7 |
661 | 2025-03-31 11:45:45 | harper | 1 | 48755 | 9 | 6.076 | 8024.2 |
660 | 2025-03-31 00:32:37 | harper | 2 | 82551 | 162 | 9.500 | 8689.6 |
659 | 2025-03-30 04:58:05 | harper | 1 | 48755 | 9 | 4.093 | 11911.8 |
658 | 2025-03-24 13:00:31 | harper | 2 | 82551 | 162 | 15.360 | 5374.4 |
657 | 2025-03-21 15:39:32 | harper | 2 | 82551 | 162 | 14.936 | 5527.0 |
656 | 2025-03-18 23:32:18 | harper | 1 | 48755 | 9 | 0.860 | 56691.9 |
655 | 2025-03-14 03:07:45 | harper | 1 | 48755 | 9 | 1.783 | 27344.4 |
654 | 2025-03-10 08:13:32 | harper | 1 | 48755 | 9 | 6.110 | 7979.5 |
653 | 2025-03-09 23:50:34 | harper | 1 | 48755 | 9 | 3.640 | 13394.2 |
652 | 2025-03-08 21:12:43 | harper | 1 | 48755 | 9 | 1.983 | 24586.5 |
651 | 2025-02-28 08:20:49 | harper | 1 | 48755 | 9 | 4.063 | 11999.8 |
650 | 2025-02-25 18:31:53 | harper | 1 | 48755 | 9 | 5.953 | 8190.0 |
649 | 2025-02-07 19:28:46 | harper | 1 | 48755 | 9 | 4.046 | 12050.2 |
648 | 2025-02-07 06:54:40 | harper | 2 | 82551 | 162 | 15.546 | 5310.1 |
647 | 2025-02-07 03:53:40 | harper | 1 | 48755 | 9 | 2.233 | 21833.9 |
646 | 2025-02-06 15:35:56 | harper | 2 | 82551 | 162 | 10.516 | 7850.0 |
645 | 2025-02-05 13:59:51 | harper | 2 | 82551 | 162 | 6.000 | 13758.5 |
644 | 2025-02-05 06:16:46 | harper | 2 | 82551 | 162 | 5.796 | 14242.8 |
643 | 2025-02-05 06:12:58 | harper | 1 | 48755 | 9 | 0.840 | 58041.7 |
642 | 2025-02-04 21:38:40 | harper | 1 | 48755 | 9 | 2.016 | 24184.0 |
641 | 2025-01-28 21:29:24 | harper | 1 | 48755 | 9 | 0.873 | 55847.7 |
640 | 2025-01-28 16:41:27 | harper | 1 | 48755 | 9 | 3.233 | 15080.4 |
639 | 2025-01-24 19:56:28 | harper | 1 | 48755 | 9 | 0.843 | 57835.1 |
638 | 2025-01-08 18:22:13 | harper | 1 | 48755 | 9 | 2.813 | 17332.0 |
637 | 2025-01-06 05:31:38 | harper | 2 | 82551 | 162 | 2.610 | 31628.7 |
636 | 2025-01-06 03:26:56 | harper | 2 | 82551 | 162 | 16.656 | 4956.2 |
635 | 2025-01-06 03:26:55 | harper | 1 | 48755 | 9 | 2.093 | 23294.3 |
634 | 2024-12-28 22:50:14 | harper | 1 | 48755 | 9 | 3.923 | 12428.0 |
633 | 2024-12-27 08:52:46 | harper | 1 | 48755 | 9 | 2.296 | 21234.8 |
632 | 2024-11-28 14:55:47 | harper | 1 | 48755 | 9 | 3.953 | 12333.7 |
631 | 2024-11-27 07:17:01 | harper | 1 | 48755 | 9 | 5.876 | 8297.3 |
630 | 2024-10-29 15:40:17 | harper | 1 | 48755 | 9 | 4.250 | 11471.8 |
629 | 2024-10-25 09:45:25 | harper | 1 | 48755 | 9 | 4.610 | 10575.9 |
628 | 2024-10-20 04:52:14 | harper | 2 | 82551 | 162 | 13.360 | 6179.0 |
627 | 2024-10-19 23:13:49 | harper | 2 | 82551 | 162 | 8.936 | 9238.0 |
626 | 2024-10-09 14:20:40 | harper | 1 | 48755 | 9 | 2.530 | 19270.8 |
625 | 2024-10-07 09:55:59 | harper | 1 | 48755 | 9 | 5.546 | 8791.0 |
624 | 2024-09-29 14:52:50 | harper | 1 | 48755 | 9 | 6.186 | 7881.5 |
623 | 2024-09-26 08:42:32 | harper | 1 | 48755 | 9 | 2.983 | 16344.3 |
622 | 2024-09-08 10:47:44 | harper | 1 | 48755 | 9 | 8.550 | 5702.3 |
621 | 2024-09-07 03:53:59 | harper | 1 | 48755 | 9 | 1.873 | 26030.4 |
620 | 2024-09-06 02:33:58 | harper | 1 | 48755 | 9 | 2.560 | 19044.9 |
619 | 2024-09-05 16:14:03 | harper | 1 | 48755 | 9 | 2.563 | 19022.6 |
618 | 2024-08-30 12:17:35 | harper | 1 | 48755 | 9 | 3.033 | 16074.8 |
617 | 2024-08-27 08:10:30 | harper | 1 | 48755 | 9 | 3.173 | 15365.6 |
616 | 2024-08-12 19:43:53 | harper | 1 | 48755 | 9 | 4.766 | 10229.8 |
615 | 2024-08-10 14:39:20 | harper | 1 | 48755 | 9 | 2.783 | 17518.9 |
614 | 2024-08-08 16:21:29 | harper | 1 | 48755 | 9 | 1.373 | 35509.8 |
613 | 2024-08-08 06:13:52 | harper | 1 | 48755 | 9 | 2.516 | 19378.0 |
612 | 2024-08-07 13:47:02 | harper | 1 | 48755 | 9 | 2.076 | 23485.1 |
611 | 2024-08-01 21:07:21 | harper | 1 | 48755 | 9 | 3.000 | 16251.7 |
610 | 2024-07-28 13:05:35 | harper | 1 | 48755 | 9 | 6.173 | 7898.1 |
609 | 2024-07-27 18:27:49 | harper | 1 | 48755 | 9 | 6.063 | 8041.4 |
608 | 2024-07-24 10:18:10 | harper | 1 | 48755 | 9 | 1.530 | 31866.0 |
607 | 2024-07-16 09:52:55 | harper | 1 | 48755 | 9 | 3.156 | 15448.4 |
606 | 2024-07-10 10:49:47 | harper | 1 | 48755 | 9 | 1.830 | 26642.1 |
605 | 2024-07-08 11:41:23 | harper | 1 | 48755 | 9 | 2.250 | 21668.9 |