History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"recce"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
755 | 2024-04-14 16:13:19 | recce | 2 | 53800 | 62 | 3.670 | 14659.4 |
754 | 2024-04-14 16:12:54 | recce | 3 | 83667 | 1093 | 7.280 | 11492.7 |
753 | 2024-04-14 16:12:56 | recce | 2 | 53800 | 62 | 3.530 | 15240.8 |
752 | 2024-04-14 16:12:48 | recce | 1 | 28756 | 2 | 1.110 | 25906.3 |
751 | 2024-04-14 16:12:11 | recce | 3 | 83667 | 1093 | 6.983 | 11981.5 |
750 | 2024-04-13 10:10:51 | recce | 3 | 83667 | 1093 | 3.593 | 23286.1 |
749 | 2024-04-11 12:10:32 | recce | 3 | 83667 | 1093 | 4.080 | 20506.6 |
748 | 2024-04-06 11:17:25 | recce | 1 | 28756 | 2 | 1.736 | 16564.5 |
747 | 2024-03-31 14:46:37 | recce | 3 | 83667 | 1093 | 5.423 | 15428.2 |
746 | 2024-03-31 14:46:32 | recce | 2 | 53800 | 62 | 3.813 | 14109.6 |
745 | 2024-03-31 14:44:24 | recce | 1 | 28756 | 2 | 1.766 | 16283.1 |
744 | 2024-03-29 00:40:26 | recce | 1 | 28756 | 2 | 0.560 | 51350.0 |
743 | 2024-03-27 07:50:43 | recce | 1 | 28756 | 2 | 0.500 | 57512.0 |
742 | 2024-03-07 08:43:18 | recce | 3 | 83667 | 1093 | 14.360 | 5826.4 |
741 | 2024-03-07 08:43:18 | recce | 2 | 53800 | 62 | 6.843 | 7862.0 |
740 | 2024-03-07 05:20:36 | recce | 1 | 28756 | 2 | 0.610 | 47141.0 |
739 | 2024-03-01 12:00:39 | recce | 1 | 28756 | 2 | 0.580 | 49579.3 |
738 | 2024-03-01 04:10:28 | recce | 2 | 53800 | 62 | 1.500 | 35866.7 |
737 | 2024-03-01 04:10:08 | recce | 3 | 83667 | 1093 | 4.456 | 18776.3 |
736 | 2024-02-28 05:27:24 | recce | 3 | 83667 | 1093 | 9.390 | 8910.2 |
735 | 2024-02-28 00:09:28 | recce | 2 | 53800 | 62 | 1.563 | 34421.0 |
734 | 2024-02-27 14:59:40 | recce | 2 | 53800 | 62 | 1.703 | 31591.3 |
733 | 2024-02-27 14:59:00 | recce | 3 | 83667 | 1093 | 3.796 | 22040.8 |
732 | 2024-02-25 22:10:50 | recce | 3 | 83667 | 1093 | 7.796 | 10732.0 |
731 | 2024-02-25 22:10:47 | recce | 2 | 53800 | 62 | 3.716 | 14477.9 |
730 | 2024-02-25 19:22:14 | recce | 1 | 28756 | 2 | 0.500 | 57512.0 |
729 | 2024-02-03 22:30:55 | recce | 1 | 28756 | 2 | 0.440 | 65354.5 |
728 | 2024-01-29 06:05:19 | recce | 1 | 28756 | 2 | 0.516 | 55728.7 |
727 | 2024-01-26 15:49:13 | recce | 1 | 28756 | 2 | 0.483 | 59536.2 |
726 | 2024-01-21 06:24:38 | recce | 1 | 28756 | 2 | 0.453 | 63479.0 |
725 | 2024-01-14 21:10:56 | recce | 3 | 83667 | 1093 | 4.030 | 20761.0 |
724 | 2024-01-14 21:10:58 | recce | 2 | 53800 | 62 | 1.703 | 31591.3 |
723 | 2024-01-13 04:58:57 | recce | 1 | 28756 | 2 | 0.530 | 54256.6 |
722 | 2023-12-11 08:34:34 | recce | 3 | 83667 | 1093 | 3.486 | 24000.9 |
721 | 2023-12-11 08:34:31 | recce | 2 | 53800 | 62 | 1.563 | 34421.0 |
720 | 2023-12-10 11:29:32 | recce | 3 | 83667 | 1093 | 3.440 | 24321.8 |
719 | 2023-12-07 23:53:10 | recce | 1 | 28756 | 2 | 0.576 | 49923.6 |
718 | 2023-12-07 23:53:09 | recce | 1 | 28756 | 2 | 0.500 | 57512.0 |
717 | 2023-11-30 05:05:15 | recce | 2 | 53800 | 62 | 1.550 | 34709.7 |
716 | 2023-11-30 05:05:10 | recce | 3 | 83667 | 1093 | 3.766 | 22216.4 |
715 | 2023-11-21 23:13:09 | recce | 2 | 53800 | 62 | 1.420 | 37887.3 |
714 | 2023-11-17 22:32:02 | recce | 1 | 28756 | 2 | 0.516 | 55728.7 |
713 | 2023-11-17 17:20:33 | recce | 1 | 28756 | 2 | 0.453 | 63479.0 |
712 | 2023-11-11 01:44:59 | recce | 1 | 28756 | 2 | 0.470 | 61183.0 |
711 | 2023-10-27 16:46:35 | recce | 1 | 28756 | 2 | 0.576 | 49923.6 |
710 | 2023-10-20 06:48:41 | recce | 1 | 28756 | 2 | 1.703 | 16885.5 |
709 | 2023-10-18 00:04:01 | recce | 1 | 28756 | 2 | 0.453 | 63479.0 |
708 | 2023-10-13 04:13:34 | recce | 1 | 28756 | 2 | 0.513 | 56054.6 |
707 | 2023-10-04 12:34:06 | recce | 1 | 28756 | 2 | 0.450 | 63902.2 |
706 | 2023-09-29 11:57:46 | recce | 1 | 28756 | 2 | 0.983 | 29253.3 |
705 | 2023-09-23 09:48:13 | recce | 1 | 28756 | 2 | 0.453 | 63479.0 |
704 | 2023-09-21 15:48:50 | recce | 3 | 83667 | 1093 | 3.563 | 23482.2 |
703 | 2023-09-18 00:58:11 | recce | 3 | 83667 | 1093 | 3.346 | 25005.1 |
702 | 2023-09-16 23:14:05 | recce | 2 | 53800 | 62 | 1.580 | 34050.6 |
701 | 2023-09-12 19:29:58 | recce | 3 | 83667 | 1093 | 3.560 | 23502.0 |
700 | 2023-09-10 17:03:21 | recce | 3 | 83667 | 1093 | 4.140 | 20209.4 |
699 | 2023-09-07 07:58:55 | recce | 3 | 83667 | 1093 | 3.343 | 25027.5 |
698 | 2023-09-04 19:04:57 | recce | 1 | 28756 | 2 | 0.483 | 59536.2 |
697 | 2023-08-23 14:41:17 | recce | 2 | 53800 | 62 | 1.390 | 38705.0 |
696 | 2023-06-06 06:29:29 | recce | 1 | 28756 | 2 | 0.436 | 65954.1 |
695 | 2023-06-02 23:53:09 | recce | 1 | 28756 | 2 | 0.500 | 57512.0 |
694 | 2023-05-16 12:40:41 | recce | 3 | 83667 | 1093 | 3.296 | 25384.4 |
693 | 2023-05-07 16:28:38 | recce | 2 | 53800 | 62 | 1.373 | 39184.3 |
692 | 2023-05-02 20:25:03 | recce | 3 | 83667 | 1093 | 3.326 | 25155.4 |
691 | 2023-04-03 16:01:41 | recce | 3 | 83667 | 1093 | 3.873 | 21602.6 |
690 | 2023-03-03 00:50:53 | recce | 3 | 83667 | 1093 | 4.000 | 20916.8 |
689 | 2023-03-01 13:20:47 | recce | 3 | 83667 | 1093 | 3.326 | 25155.4 |
688 | 2023-02-24 06:55:17 | recce | 3 | 83667 | 1093 | 3.313 | 25254.2 |
687 | 2023-02-19 20:35:55 | recce | 1 | 28756 | 2 | 0.483 | 59536.2 |
686 | 2023-02-14 15:12:36 | recce | 1 | 28756 | 2 | 0.483 | 59536.2 |
685 | 2023-02-11 12:32:07 | recce | 2 | 53800 | 62 | 1.406 | 38264.6 |
684 | 2022-12-19 05:22:40 | recce | 1 | 28756 | 2 | 0.436 | 65954.1 |
683 | 2022-12-05 11:06:18 | recce | 3 | 83667 | 1093 | 3.360 | 24900.9 |
682 | 2022-11-23 15:18:22 | recce | 2 | 53800 | 62 | 1.716 | 31352.0 |
681 | 2022-10-24 18:28:38 | recce | 1 | 28756 | 2 | 0.453 | 63479.0 |
680 | 2022-10-21 04:34:34 | recce | 1 | 28756 | 2 | 0.500 | 57512.0 |
679 | 2022-08-31 19:56:07 | recce | 1 | 28756 | 2 | 0.453 | 63479.0 |
678 | 2022-08-29 09:54:34 | recce | 1 | 28756 | 2 | 0.453 | 63479.0 |
677 | 2022-07-01 04:37:12 | recce | 1 | 28756 | 2 | 0.470 | 61183.0 |
676 | 2022-05-04 11:13:02 | recce | 2 | 53800 | 62 | 1.393 | 38621.7 |
675 | 2022-05-03 17:18:40 | recce | 2 | 53800 | 62 | 2.373 | 22671.7 |
674 | 2022-04-25 06:55:44 | recce | 2 | 53800 | 62 | 1.423 | 37807.4 |
673 | 2022-04-21 10:50:03 | recce | 2 | 53800 | 62 | 1.873 | 28724.0 |
672 | 2022-04-11 20:13:41 | recce | 1 | 28756 | 2 | 0.656 | 43835.4 |
671 | 2022-04-08 22:57:29 | recce | 2 | 53800 | 62 | 1.576 | 34137.1 |
670 | 2022-04-06 22:45:33 | recce | 2 | 53800 | 62 | 1.390 | 38705.0 |
669 | 2022-04-05 04:15:24 | recce | 3 | 83667 | 1093 | 4.373 | 19132.6 |
668 | 2022-04-01 23:18:50 | recce | 2 | 53800 | 62 | 1.610 | 33416.1 |
667 | 2022-03-24 15:12:56 | recce | 2 | 53800 | 62 | 1.966 | 27365.2 |
666 | 2022-03-10 21:24:34 | recce | 1 | 28756 | 2 | 1.110 | 25906.3 |
665 | 2022-03-01 23:05:25 | recce | 2 | 53800 | 62 | 1.813 | 29674.6 |
664 | 2022-02-28 23:40:47 | recce | 2 | 53800 | 62 | 4.030 | 13349.9 |
663 | 2022-02-28 00:08:05 | recce | 2 | 53800 | 62 | 1.670 | 32215.6 |
662 | 2022-02-25 18:14:53 | recce | 2 | 53800 | 62 | 1.703 | 31591.3 |
661 | 2022-02-06 18:47:55 | recce | 2 | 53800 | 62 | 1.440 | 37361.1 |
660 | 2022-02-05 14:42:46 | recce | 2 | 53800 | 62 | 1.420 | 37887.3 |
659 | 2022-02-04 15:47:24 | recce | 2 | 53800 | 62 | 1.736 | 30990.8 |
658 | 2022-02-03 11:56:38 | recce | 2 | 53800 | 62 | 1.626 | 33087.3 |
657 | 2022-02-02 09:09:44 | recce | 2 | 53800 | 62 | 1.403 | 38346.4 |
656 | 2022-02-01 10:40:56 | recce | 2 | 53800 | 62 | 1.563 | 34421.0 |