History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
745 | 2025-07-10 17:45:02 | piers | 1 | 28756 | 14 | 0.970 | 29645.4 |
744 | 2025-07-08 07:16:41 | piers | 1 | 28756 | 14 | 1.376 | 20898.3 |
743 | 2025-06-30 22:30:48 | piers | 1 | 28756 | 14 | 0.936 | 30722.2 |
742 | 2025-06-30 16:04:38 | piers | 1 | 28756 | 14 | 1.936 | 14853.3 |
741 | 2025-06-30 07:15:06 | piers | 1 | 28756 | 14 | 2.030 | 14165.5 |
740 | 2025-06-30 03:37:00 | piers | 1 | 28756 | 14 | 2.373 | 12118.0 |
739 | 2025-06-20 01:07:41 | piers | 2 | 53800 | 305 | 8.563 | 6282.8 |
738 | 2025-06-19 20:12:10 | piers | 1 | 28756 | 14 | 2.406 | 11951.8 |
737 | 2025-06-19 09:12:11 | piers | 1 | 28756 | 14 | 0.530 | 54256.6 |
736 | 2025-06-17 13:34:48 | piers | 1 | 28756 | 14 | 0.530 | 54256.6 |
735 | 2025-06-16 21:45:23 | piers | 1 | 28756 | 14 | 2.343 | 12273.2 |
734 | 2025-06-10 11:46:57 | piers | 1 | 28756 | 14 | 1.013 | 28387.0 |
733 | 2025-06-07 06:40:21 | piers | 1 | 28756 | 14 | 0.953 | 30174.2 |
732 | 2025-06-01 09:37:47 | piers | 1 | 28756 | 14 | 0.500 | 57512.0 |
731 | 2025-05-31 15:23:58 | piers | 1 | 28756 | 14 | 4.283 | 6714.0 |
730 | 2025-05-31 10:26:12 | piers | 1 | 28756 | 14 | 2.500 | 11502.4 |
729 | 2025-05-30 02:12:23 | piers | 1 | 28756 | 14 | 0.533 | 53951.2 |
728 | 2025-05-24 23:56:45 | piers | 1 | 28756 | 14 | 0.453 | 63479.0 |
727 | 2025-05-20 00:51:40 | piers | 2 | 53800 | 305 | 6.423 | 8376.1 |
726 | 2025-05-19 09:25:28 | piers | 1 | 28756 | 14 | 0.500 | 57512.0 |
725 | 2025-05-18 11:58:12 | piers | 2 | 53800 | 305 | 7.483 | 7189.6 |
724 | 2025-05-17 14:53:15 | piers | 1 | 28756 | 14 | 2.640 | 10892.4 |
723 | 2025-05-17 13:48:41 | piers | 1 | 28756 | 14 | 2.486 | 11567.2 |
722 | 2025-05-13 01:30:54 | piers | 1 | 28756 | 14 | 1.530 | 18794.8 |
721 | 2025-05-12 19:03:45 | piers | 1 | 28756 | 14 | 0.610 | 47141.0 |
720 | 2025-05-11 18:04:25 | piers | 1 | 28756 | 14 | 0.906 | 31739.5 |
719 | 2025-05-09 10:51:05 | piers | 1 | 28756 | 14 | 0.546 | 52666.7 |
718 | 2025-05-08 06:31:04 | piers | 1 | 28756 | 14 | 0.983 | 29253.3 |
717 | 2025-05-07 23:45:07 | piers | 1 | 28756 | 14 | 3.563 | 8070.7 |
716 | 2025-05-06 17:24:05 | piers | 1 | 28756 | 14 | 2.626 | 10950.5 |
715 | 2025-05-04 20:28:09 | piers | 2 | 53800 | 305 | 1.843 | 29191.5 |
714 | 2025-05-01 14:29:15 | piers | 1 | 28756 | 14 | 0.513 | 56054.6 |
713 | 2025-04-29 02:12:16 | piers | 1 | 28756 | 14 | 0.486 | 59168.7 |
712 | 2025-04-19 23:52:21 | piers | 2 | 53800 | 305 | 4.140 | 12995.2 |
711 | 2025-04-19 08:43:37 | piers | 1 | 28756 | 14 | 0.500 | 57512.0 |
710 | 2025-04-17 11:41:45 | piers | 1 | 28756 | 14 | 0.530 | 54256.6 |
709 | 2025-04-10 11:14:06 | piers | 1 | 28756 | 14 | 0.500 | 57512.0 |
708 | 2025-04-08 05:30:46 | piers | 1 | 28756 | 14 | 0.516 | 55728.7 |
707 | 2025-03-31 01:23:20 | piers | 2 | 53800 | 305 | 6.390 | 8419.4 |
706 | 2025-03-30 17:16:03 | piers | 1 | 28756 | 14 | 0.953 | 30174.2 |
705 | 2025-03-30 13:33:57 | piers | 1 | 28756 | 14 | 0.453 | 63479.0 |
704 | 2025-03-20 21:03:58 | piers | 2 | 53800 | 305 | 8.156 | 6596.4 |
703 | 2025-03-19 11:04:16 | piers | 1 | 28756 | 14 | 0.500 | 57512.0 |
702 | 2025-03-17 19:38:26 | piers | 1 | 28756 | 14 | 3.470 | 8287.0 |
701 | 2025-03-11 07:35:29 | piers | 1 | 28756 | 14 | 1.406 | 20452.3 |
700 | 2025-03-07 19:30:52 | piers | 1 | 28756 | 14 | 1.033 | 27837.4 |
699 | 2025-02-28 03:17:09 | piers | 2 | 53800 | 305 | 8.470 | 6351.8 |
698 | 2025-02-28 00:50:55 | piers | 2 | 53800 | 305 | 8.516 | 6317.5 |
697 | 2025-02-28 00:25:34 | piers | 1 | 28756 | 14 | 0.500 | 57512.0 |
696 | 2025-02-26 06:21:54 | piers | 1 | 28756 | 14 | 1.626 | 17685.1 |
695 | 2025-02-09 07:08:28 | piers | 1 | 28756 | 14 | 2.966 | 9695.2 |
694 | 2025-02-01 04:32:51 | piers | 1 | 28756 | 14 | 2.750 | 10456.7 |
693 | 2025-01-28 15:18:29 | piers | 2 | 53800 | 305 | 11.810 | 4555.5 |
692 | 2025-01-28 11:11:39 | piers | 2 | 53800 | 305 | 7.876 | 6830.9 |
691 | 2025-01-28 10:00:11 | piers | 1 | 28756 | 14 | 0.530 | 54256.6 |
690 | 2025-01-26 11:11:55 | piers | 1 | 28756 | 14 | 1.813 | 15861.0 |
689 | 2025-01-25 08:55:18 | piers | 1 | 28756 | 14 | 2.000 | 14378.0 |
688 | 2025-01-25 07:37:42 | piers | 2 | 53800 | 305 | 8.110 | 6633.8 |
687 | 2025-01-05 18:42:40 | piers | 1 | 28756 | 14 | 2.360 | 12184.7 |
686 | 2024-12-29 04:56:36 | piers | 1 | 28756 | 14 | 2.173 | 13233.3 |
685 | 2024-12-28 06:55:50 | piers | 2 | 53800 | 305 | 2.046 | 26295.2 |
684 | 2024-12-28 03:48:40 | piers | 2 | 53800 | 305 | 3.406 | 15795.7 |
683 | 2024-12-27 15:59:36 | piers | 2 | 53800 | 305 | 8.000 | 6725.0 |
682 | 2024-12-27 13:09:01 | piers | 1 | 28756 | 14 | 0.593 | 48492.4 |
681 | 2024-12-27 10:03:51 | piers | 2 | 53800 | 305 | 8.063 | 6672.5 |
680 | 2024-12-27 09:14:51 | piers | 1 | 28756 | 14 | 1.000 | 28756.0 |
679 | 2024-12-06 13:20:07 | piers | 1 | 28756 | 14 | 3.076 | 9348.5 |
678 | 2024-12-02 12:26:01 | piers | 1 | 28756 | 14 | 1.186 | 24246.2 |
677 | 2024-11-28 21:28:11 | piers | 1 | 28756 | 14 | 1.343 | 21411.8 |
676 | 2024-11-27 03:44:36 | piers | 1 | 28756 | 14 | 2.343 | 12273.2 |
675 | 2024-11-26 07:02:18 | piers | 1 | 28756 | 14 | 1.360 | 21144.1 |
674 | 2024-11-18 13:32:50 | piers | 2 | 53800 | 305 | 4.140 | 12995.2 |
673 | 2024-11-06 09:14:29 | piers | 1 | 28756 | 14 | 0.970 | 29645.4 |
672 | 2024-10-29 16:16:33 | piers | 2 | 53800 | 305 | 10.936 | 4919.5 |
671 | 2024-10-29 15:39:28 | piers | 2 | 53800 | 305 | 3.970 | 13551.6 |
670 | 2024-10-29 15:22:31 | piers | 1 | 28756 | 14 | 0.453 | 63479.0 |
669 | 2024-10-27 21:15:17 | piers | 1 | 28756 | 14 | 0.533 | 53951.2 |
668 | 2024-10-27 04:09:10 | piers | 1 | 28756 | 14 | 1.750 | 16432.0 |
667 | 2024-10-22 10:30:11 | piers | 1 | 28756 | 14 | 2.140 | 13437.4 |
666 | 2024-10-10 11:19:32 | piers | 1 | 28756 | 14 | 2.906 | 9895.4 |
665 | 2024-10-07 10:06:50 | piers | 1 | 28756 | 14 | 3.873 | 7424.7 |
664 | 2024-09-29 17:40:29 | piers | 2 | 53800 | 305 | 10.390 | 5178.1 |
663 | 2024-09-29 08:29:54 | piers | 2 | 53800 | 305 | 15.486 | 3474.1 |
662 | 2024-09-29 02:39:23 | piers | 2 | 53800 | 305 | 11.720 | 4590.4 |
661 | 2024-09-29 02:26:38 | piers | 1 | 28756 | 14 | 0.500 | 57512.0 |
660 | 2024-09-27 19:57:44 | piers | 1 | 28756 | 14 | 2.046 | 14054.7 |
659 | 2024-09-27 01:38:33 | piers | 1 | 28756 | 14 | 1.780 | 16155.1 |
658 | 2024-09-07 04:08:19 | piers | 1 | 28756 | 14 | 4.640 | 6197.4 |
657 | 2024-08-29 02:33:12 | piers | 1 | 28756 | 14 | 2.030 | 14165.5 |
656 | 2024-08-28 16:23:28 | piers | 1 | 28756 | 14 | 2.123 | 13545.0 |
655 | 2024-08-26 17:12:04 | piers | 1 | 28756 | 14 | 2.936 | 9794.3 |
654 | 2024-08-12 10:48:56 | piers | 1 | 28756 | 14 | 3.080 | 9336.4 |
653 | 2024-08-09 04:09:30 | piers | 1 | 28756 | 14 | 1.813 | 15861.0 |
652 | 2024-08-07 22:09:18 | piers | 1 | 28756 | 14 | 1.610 | 17860.9 |
651 | 2024-08-02 00:29:04 | piers | 2 | 53800 | 305 | 8.580 | 6270.4 |
650 | 2024-08-01 19:10:54 | piers | 2 | 53800 | 305 | 3.170 | 16971.6 |
649 | 2024-08-01 10:49:02 | piers | 2 | 53800 | 305 | 4.326 | 12436.4 |
648 | 2024-07-30 05:22:27 | piers | 2 | 53800 | 305 | 3.186 | 16886.4 |
647 | 2024-07-29 23:49:43 | piers | 2 | 53800 | 305 | 4.093 | 13144.4 |
646 | 2024-07-29 22:36:16 | piers | 1 | 28756 | 14 | 0.486 | 59168.7 |