History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pests"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
799 | 2024-04-28 17:35:12 | pests | 1 | 28756 | 23 | 0.530 | 54256.6 |
798 | 2024-04-28 06:47:08 | pests | 2 | 53800 | 277 | 3.673 | 14647.4 |
797 | 2024-04-18 21:24:27 | pests | 1 | 28756 | 23 | 0.466 | 61708.2 |
796 | 2024-04-08 07:32:11 | pests | 1 | 28756 | 23 | 1.266 | 22714.1 |
795 | 2024-04-02 20:34:55 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
794 | 2024-03-31 07:21:57 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
793 | 2024-03-29 23:19:15 | pests | 2 | 53800 | 277 | 1.703 | 31591.3 |
792 | 2024-03-29 17:15:08 | pests | 2 | 53800 | 277 | 1.373 | 39184.3 |
791 | 2024-03-28 22:36:08 | pests | 2 | 53800 | 277 | 5.970 | 9011.7 |
790 | 2024-03-28 22:36:03 | pests | 1 | 28756 | 23 | 1.780 | 16155.1 |
789 | 2024-03-28 09:16:39 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
788 | 2024-03-19 22:20:44 | pests | 1 | 28756 | 23 | 0.686 | 41918.4 |
787 | 2024-03-08 02:33:24 | pests | 1 | 28756 | 23 | 0.513 | 56054.6 |
786 | 2024-03-02 17:51:16 | pests | 1 | 28756 | 23 | 1.046 | 27491.4 |
785 | 2024-03-01 22:08:06 | pests | 2 | 53800 | 277 | 3.706 | 14517.0 |
784 | 2024-03-01 09:42:03 | pests | 2 | 53800 | 277 | 4.593 | 11713.5 |
783 | 2024-03-01 09:22:53 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
782 | 2024-02-27 19:49:09 | pests | 1 | 28756 | 23 | 0.440 | 65354.5 |
781 | 2024-02-17 15:58:00 | pests | 1 | 28756 | 23 | 0.533 | 53951.2 |
780 | 2024-01-26 23:07:29 | pests | 1 | 28756 | 23 | 0.530 | 54256.6 |
779 | 2024-01-26 06:24:24 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
778 | 2024-01-03 19:15:41 | pests | 2 | 53800 | 277 | 1.733 | 31044.4 |
777 | 2023-12-26 13:49:45 | pests | 2 | 53800 | 277 | 1.640 | 32804.9 |
776 | 2023-12-05 13:54:23 | pests | 1 | 28756 | 23 | 0.530 | 54256.6 |
775 | 2023-12-01 07:22:32 | pests | 2 | 53800 | 277 | 1.563 | 34421.0 |
774 | 2023-11-22 02:20:40 | pests | 1 | 28756 | 23 | 0.546 | 52666.7 |
773 | 2023-11-18 14:35:57 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
772 | 2023-11-13 23:15:25 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
771 | 2023-11-03 09:47:56 | pests | 2 | 53800 | 277 | 1.533 | 35094.6 |
770 | 2023-10-30 04:49:12 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
769 | 2023-10-28 01:36:54 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
768 | 2023-10-20 23:54:29 | pests | 1 | 28756 | 23 | 0.450 | 63902.2 |
767 | 2023-10-16 16:38:07 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
766 | 2023-10-06 15:19:54 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
765 | 2023-10-05 03:31:36 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
764 | 2023-09-26 03:05:17 | pests | 1 | 28756 | 23 | 0.563 | 51076.4 |
763 | 2023-09-24 06:55:39 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
762 | 2023-09-09 02:29:18 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
761 | 2023-08-30 08:38:37 | pests | 2 | 53800 | 277 | 1.470 | 36598.6 |
760 | 2023-08-19 11:51:23 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
759 | 2023-08-16 12:21:33 | pests | 1 | 28756 | 23 | 0.440 | 65354.5 |
758 | 2023-06-10 19:16:56 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
757 | 2023-05-18 19:26:20 | pests | 2 | 53800 | 277 | 2.216 | 24278.0 |
756 | 2023-05-05 20:24:43 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
755 | 2023-05-01 03:27:30 | pests | 2 | 53800 | 277 | 1.360 | 39558.8 |
754 | 2023-03-27 03:58:37 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
753 | 2023-03-19 10:57:27 | pests | 2 | 53800 | 277 | 1.373 | 39184.3 |
752 | 2023-02-24 01:49:40 | pests | 2 | 53800 | 277 | 1.360 | 39558.8 |
751 | 2023-01-23 13:44:08 | pests | 1 | 28756 | 23 | 0.486 | 59168.7 |
750 | 2023-01-10 17:56:12 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
749 | 2022-12-03 21:44:10 | pests | 2 | 53800 | 277 | 1.373 | 39184.3 |
748 | 2022-10-13 00:54:27 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
747 | 2022-10-09 05:03:47 | pests | 1 | 28756 | 23 | 0.440 | 65354.5 |
746 | 2022-09-15 13:23:29 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
745 | 2022-08-09 15:28:15 | pests | 2 | 53800 | 277 | 1.360 | 39558.8 |
744 | 2022-07-18 06:46:52 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
743 | 2022-07-10 09:28:50 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
742 | 2022-07-09 22:03:02 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
741 | 2022-07-02 22:22:05 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
740 | 2022-06-25 14:34:46 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
739 | 2022-06-18 19:58:21 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
738 | 2022-06-18 14:21:46 | pests | 2 | 53800 | 277 | 1.340 | 40149.3 |
737 | 2022-06-09 23:16:34 | pests | 1 | 28756 | 23 | 0.470 | 61183.0 |
736 | 2022-06-07 10:55:46 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
735 | 2022-06-01 18:46:28 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
734 | 2022-05-28 18:16:35 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |
733 | 2022-05-08 19:13:01 | pests | 2 | 53800 | 277 | 2.906 | 18513.4 |
732 | 2022-05-07 05:19:51 | pests | 1 | 28756 | 23 | 0.470 | 61183.0 |
731 | 2022-05-06 15:56:26 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
730 | 2022-05-06 14:19:44 | pests | 1 | 28756 | 23 | 0.470 | 61183.0 |
729 | 2022-05-05 20:30:16 | pests | 1 | 28756 | 23 | 0.530 | 54256.6 |
728 | 2022-05-05 13:39:26 | pests | 1 | 28756 | 23 | 0.516 | 55728.7 |
727 | 2022-05-05 04:01:52 | pests | 1 | 28756 | 23 | 0.530 | 54256.6 |
726 | 2022-05-04 19:22:52 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
725 | 2022-05-04 07:33:33 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
724 | 2022-05-03 22:37:03 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
723 | 2022-05-03 09:14:27 | pests | 1 | 28756 | 23 | 0.516 | 55728.7 |
722 | 2022-05-03 00:02:04 | pests | 1 | 28756 | 23 | 0.560 | 51350.0 |
721 | 2022-04-15 21:18:11 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
720 | 2022-04-14 21:56:56 | pests | 1 | 28756 | 23 | 0.576 | 49923.6 |
719 | 2022-04-14 02:05:10 | pests | 1 | 28756 | 23 | 0.593 | 48492.4 |
718 | 2022-04-06 15:02:15 | pests | 2 | 53800 | 277 | 1.796 | 29955.5 |
717 | 2022-03-19 18:27:50 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
716 | 2022-03-18 23:05:43 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
715 | 2022-03-18 03:29:04 | pests | 1 | 28756 | 23 | 0.576 | 49923.6 |
714 | 2022-03-17 05:33:40 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
713 | 2022-03-16 12:46:42 | pests | 1 | 28756 | 23 | 0.670 | 42919.4 |
712 | 2022-03-15 21:40:29 | pests | 1 | 28756 | 23 | 0.563 | 51076.4 |
711 | 2022-03-15 09:09:01 | pests | 1 | 28756 | 23 | 0.563 | 51076.4 |
710 | 2022-03-14 19:40:55 | pests | 1 | 28756 | 23 | 0.640 | 44931.3 |
709 | 2022-03-14 11:51:02 | pests | 1 | 28756 | 23 | 0.546 | 52666.7 |
708 | 2022-03-13 13:24:14 | pests | 1 | 28756 | 23 | 0.453 | 63479.0 |
707 | 2022-03-12 17:17:47 | pests | 1 | 28756 | 23 | 0.470 | 61183.0 |
706 | 2022-03-01 14:17:57 | pests | 1 | 28756 | 23 | 0.593 | 48492.4 |
705 | 2022-02-28 21:41:12 | pests | 1 | 28756 | 23 | 0.530 | 54256.6 |
704 | 2022-02-28 08:26:26 | pests | 1 | 28756 | 23 | 0.596 | 48248.3 |
703 | 2022-02-27 20:36:27 | pests | 1 | 28756 | 23 | 0.483 | 59536.2 |
702 | 2022-02-27 13:49:30 | pests | 1 | 28756 | 23 | 0.563 | 51076.4 |
701 | 2022-02-27 00:28:12 | pests | 1 | 28756 | 23 | 0.500 | 57512.0 |
700 | 2022-02-26 08:09:50 | pests | 1 | 28756 | 23 | 0.436 | 65954.1 |