History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
710 | 2025-02-05 15:45:06 | harry | 1 | 28756 | 12 | 1.860 | 15460.2 |
709 | 2025-01-31 19:44:45 | harry | 1 | 28756 | 12 | 2.546 | 11294.6 |
708 | 2025-01-28 13:45:41 | harry | 2 | 53800 | 125 | 8.406 | 6400.2 |
707 | 2025-01-28 08:23:02 | harry | 1 | 28756 | 12 | 3.313 | 8679.7 |
706 | 2025-01-28 00:39:17 | harry | 2 | 53800 | 125 | 1.656 | 32487.9 |
705 | 2025-01-27 23:13:00 | harry | 2 | 53800 | 125 | 7.063 | 7617.2 |
704 | 2025-01-27 23:10:39 | harry | 1 | 28756 | 12 | 0.513 | 56054.6 |
703 | 2025-01-21 17:01:54 | harry | 2 | 53800 | 125 | 9.703 | 5544.7 |
702 | 2025-01-06 11:13:52 | harry | 1 | 28756 | 12 | 1.343 | 21411.8 |
701 | 2024-12-29 09:07:01 | harry | 2 | 53800 | 125 | 9.563 | 5625.8 |
700 | 2024-12-29 08:03:40 | harry | 1 | 28756 | 12 | 0.733 | 39230.6 |
699 | 2024-12-28 22:39:19 | harry | 2 | 53800 | 125 | 12.016 | 4477.4 |
698 | 2024-12-28 22:38:44 | harry | 1 | 28756 | 12 | 0.970 | 29645.4 |
697 | 2024-12-06 03:09:32 | harry | 1 | 28756 | 12 | 3.280 | 8767.1 |
696 | 2024-11-29 01:56:43 | harry | 2 | 53800 | 125 | 7.580 | 7097.6 |
695 | 2024-11-29 01:49:41 | harry | 1 | 28756 | 12 | 2.016 | 14263.9 |
694 | 2024-11-28 21:33:49 | harry | 2 | 53800 | 125 | 5.126 | 10495.5 |
693 | 2024-11-28 21:21:53 | harry | 1 | 28756 | 12 | 0.513 | 56054.6 |
692 | 2024-11-26 13:23:01 | harry | 1 | 28756 | 12 | 1.533 | 18758.0 |
691 | 2024-11-20 18:40:16 | harry | 1 | 28756 | 12 | 0.486 | 59168.7 |
690 | 2024-11-07 06:55:07 | harry | 1 | 28756 | 12 | 2.720 | 10572.1 |
689 | 2024-10-30 02:30:15 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
688 | 2024-10-30 01:48:41 | harry | 2 | 53800 | 125 | 4.766 | 11288.3 |
687 | 2024-10-29 22:01:20 | harry | 2 | 53800 | 125 | 10.236 | 5256.0 |
686 | 2024-10-29 21:52:55 | harry | 1 | 28756 | 12 | 2.203 | 13053.1 |
685 | 2024-10-27 13:08:59 | harry | 1 | 28756 | 12 | 2.393 | 12016.7 |
684 | 2024-10-08 19:58:53 | harry | 1 | 28756 | 12 | 2.546 | 11294.6 |
683 | 2024-10-08 03:01:26 | harry | 1 | 28756 | 12 | 5.686 | 5057.3 |
682 | 2024-09-29 23:14:00 | harry | 2 | 53800 | 125 | 18.640 | 2886.3 |
681 | 2024-09-29 17:57:12 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
680 | 2024-09-29 14:50:50 | harry | 2 | 53800 | 125 | 6.890 | 7808.4 |
679 | 2024-09-29 14:42:18 | harry | 1 | 28756 | 12 | 3.110 | 9246.3 |
678 | 2024-09-25 16:42:08 | harry | 1 | 28756 | 12 | 3.890 | 7392.3 |
677 | 2024-09-22 07:50:52 | harry | 1 | 28756 | 12 | 3.653 | 7871.9 |
676 | 2024-08-30 20:46:17 | harry | 2 | 53800 | 125 | 9.610 | 5598.3 |
675 | 2024-08-30 13:49:27 | harry | 2 | 53800 | 125 | 17.406 | 3090.9 |
674 | 2024-08-30 13:43:15 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
673 | 2024-08-30 11:51:47 | harry | 1 | 28756 | 12 | 3.406 | 8442.7 |
672 | 2024-08-29 18:35:32 | harry | 1 | 28756 | 12 | 3.813 | 7541.6 |
671 | 2024-08-26 15:16:44 | harry | 1 | 28756 | 12 | 1.810 | 15887.3 |
670 | 2024-08-08 01:26:07 | harry | 1 | 28756 | 12 | 1.470 | 19561.9 |
669 | 2024-08-07 09:31:45 | harry | 1 | 28756 | 12 | 1.936 | 14853.3 |
668 | 2024-08-07 09:31:01 | harry | 1 | 28756 | 12 | 2.000 | 14378.0 |
667 | 2024-08-02 10:33:02 | harry | 1 | 28756 | 12 | 1.123 | 25606.4 |
666 | 2024-08-01 17:40:33 | harry | 1 | 28756 | 12 | 2.513 | 11442.9 |
665 | 2024-07-31 04:04:51 | harry | 2 | 53800 | 125 | 3.483 | 15446.5 |
664 | 2024-07-31 03:19:56 | harry | 2 | 53800 | 125 | 7.846 | 6857.0 |
663 | 2024-07-31 03:07:05 | harry | 1 | 28756 | 12 | 0.546 | 52666.7 |
662 | 2024-07-30 05:24:48 | harry | 1 | 28756 | 12 | 0.953 | 30174.2 |
661 | 2024-07-26 06:55:26 | harry | 1 | 28756 | 12 | 2.093 | 13739.1 |
660 | 2024-07-10 06:52:22 | harry | 1 | 28756 | 12 | 1.936 | 14853.3 |
659 | 2024-07-08 05:10:56 | harry | 1 | 28756 | 12 | 0.546 | 52666.7 |
658 | 2024-07-05 23:45:37 | harry | 1 | 28756 | 12 | 1.063 | 27051.7 |
657 | 2024-07-03 08:02:06 | harry | 1 | 28756 | 12 | 1.530 | 18794.8 |
656 | 2024-06-30 23:11:20 | harry | 1 | 28756 | 12 | 2.356 | 12205.4 |
655 | 2024-06-29 14:52:40 | harry | 2 | 53800 | 125 | 8.983 | 5989.1 |
654 | 2024-06-29 14:41:18 | harry | 1 | 28756 | 12 | 1.033 | 27837.4 |
653 | 2024-06-25 19:58:23 | harry | 1 | 28756 | 12 | 2.203 | 13053.1 |
652 | 2024-06-25 05:02:23 | harry | 1 | 28756 | 12 | 1.890 | 15214.8 |
651 | 2024-06-24 14:13:41 | harry | 1 | 28756 | 12 | 1.500 | 19170.7 |
650 | 2024-06-10 00:32:52 | harry | 1 | 28756 | 12 | 2.013 | 14285.1 |
649 | 2024-06-06 17:20:36 | harry | 1 | 28756 | 12 | 1.766 | 16283.1 |
648 | 2024-05-30 22:00:48 | harry | 1 | 28756 | 12 | 1.106 | 26000.0 |
647 | 2024-05-30 07:34:45 | harry | 1 | 28756 | 12 | 4.783 | 6012.1 |
646 | 2024-05-24 21:40:03 | harry | 1 | 28756 | 12 | 0.576 | 49923.6 |
645 | 2024-05-21 16:14:40 | harry | 1 | 28756 | 12 | 1.233 | 23322.0 |
644 | 2024-05-10 08:11:54 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
643 | 2024-05-04 06:17:49 | harry | 1 | 28756 | 12 | 0.530 | 54256.6 |
642 | 2024-04-27 17:07:44 | harry | 1 | 28756 | 12 | 0.673 | 42728.1 |
641 | 2024-04-24 04:57:38 | harry | 1 | 28756 | 12 | 1.906 | 15087.1 |
640 | 2024-04-24 04:00:28 | harry | 1 | 28756 | 12 | 0.563 | 51076.4 |
639 | 2024-04-24 02:45:57 | harry | 1 | 28756 | 12 | 0.626 | 45936.1 |
638 | 2024-04-24 02:44:06 | harry | 1 | 28756 | 12 | 0.826 | 34813.6 |
637 | 2024-04-24 02:43:13 | harry | 1 | 28756 | 12 | 1.140 | 25224.6 |
636 | 2024-04-24 02:28:42 | harry | 1 | 28756 | 12 | 0.653 | 44036.8 |
635 | 2024-04-18 15:51:15 | harry | 1 | 28756 | 12 | 1.436 | 20025.1 |
634 | 2024-04-02 21:58:19 | harry | 1 | 28756 | 12 | 0.563 | 51076.4 |
633 | 2024-03-31 03:50:51 | harry | 1 | 28756 | 12 | 1.110 | 25906.3 |
632 | 2024-03-31 03:26:11 | harry | 1 | 28756 | 12 | 1.766 | 16283.1 |
631 | 2024-03-29 01:17:55 | harry | 1 | 28756 | 12 | 1.686 | 17055.8 |
630 | 2024-03-21 10:07:13 | harry | 1 | 28756 | 12 | 0.686 | 41918.4 |
629 | 2024-03-15 22:40:59 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
628 | 2024-03-03 23:27:00 | harry | 2 | 53800 | 125 | 6.140 | 8762.2 |
627 | 2024-03-03 22:17:04 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
626 | 2024-03-01 09:30:22 | harry | 1 | 28756 | 12 | 1.796 | 16011.1 |
625 | 2024-02-27 20:08:30 | harry | 1 | 28756 | 12 | 0.546 | 52666.7 |
624 | 2024-02-13 12:40:16 | harry | 1 | 28756 | 12 | 1.153 | 24940.2 |
623 | 2024-01-29 00:24:37 | harry | 1 | 28756 | 12 | 0.483 | 59536.2 |
622 | 2024-01-10 16:54:11 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
621 | 2024-01-07 13:44:56 | harry | 2 | 53800 | 125 | 1.500 | 35866.7 |
620 | 2024-01-03 08:48:17 | harry | 2 | 53800 | 125 | 1.686 | 31909.8 |
619 | 2023-12-25 19:33:24 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |
618 | 2023-12-15 14:24:01 | harry | 1 | 28756 | 12 | 0.513 | 56054.6 |
617 | 2023-12-07 01:59:07 | harry | 1 | 28756 | 12 | 0.440 | 65354.5 |
616 | 2023-12-07 01:59:06 | harry | 1 | 28756 | 12 | 0.470 | 61183.0 |
615 | 2023-11-23 10:13:06 | harry | 2 | 53800 | 125 | 1.376 | 39098.8 |
614 | 2023-11-16 07:59:54 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
613 | 2023-11-15 19:09:39 | harry | 1 | 28756 | 12 | 0.453 | 63479.0 |
612 | 2023-11-09 03:23:30 | harry | 1 | 28756 | 12 | 0.486 | 59168.7 |
611 | 2023-11-03 14:51:22 | harry | 1 | 28756 | 12 | 0.533 | 53951.2 |