History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pears"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
856 | 2024-05-10 23:19:14 | pears | 1 | 28756 | 27 | 0.580 | 49579.3 |
855 | 2024-05-05 15:17:27 | pears | 1 | 28756 | 27 | 0.516 | 55728.7 |
854 | 2024-05-04 02:18:23 | pears | 1 | 28756 | 27 | 0.546 | 52666.7 |
853 | 2024-04-29 12:04:59 | pears | 1 | 28756 | 27 | 1.860 | 15460.2 |
852 | 2024-04-28 07:28:41 | pears | 1 | 28756 | 27 | 1.046 | 27491.4 |
851 | 2024-04-27 09:44:48 | pears | 1 | 28756 | 27 | 0.563 | 51076.4 |
850 | 2024-04-24 05:44:27 | pears | 1 | 28756 | 27 | 0.890 | 32310.1 |
849 | 2024-04-22 06:21:32 | pears | 1 | 28756 | 27 | 2.016 | 14263.9 |
848 | 2024-04-03 05:33:44 | pears | 1 | 28756 | 27 | 1.266 | 22714.1 |
847 | 2024-03-31 06:07:52 | pears | 1 | 28756 | 27 | 0.690 | 41675.4 |
846 | 2024-03-29 01:20:01 | pears | 2 | 53800 | 310 | 3.533 | 15227.9 |
845 | 2024-03-29 01:15:42 | pears | 1 | 28756 | 27 | 0.560 | 51350.0 |
844 | 2024-03-23 10:03:20 | pears | 1 | 28756 | 27 | 0.483 | 59536.2 |
843 | 2024-03-23 02:38:01 | pears | 1 | 28756 | 27 | 0.563 | 51076.4 |
842 | 2024-03-03 20:54:40 | pears | 1 | 28756 | 27 | 0.516 | 55728.7 |
841 | 2024-03-01 08:37:49 | pears | 1 | 28756 | 27 | 1.046 | 27491.4 |
840 | 2024-02-27 19:50:10 | pears | 1 | 28756 | 27 | 0.546 | 52666.7 |
839 | 2024-02-25 10:35:26 | pears | 1 | 28756 | 27 | 1.123 | 25606.4 |
838 | 2024-02-21 19:41:42 | pears | 1 | 28756 | 27 | 1.143 | 25158.4 |
837 | 2024-01-29 00:28:57 | pears | 1 | 28756 | 27 | 0.423 | 67981.1 |
836 | 2024-01-28 18:11:39 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
835 | 2024-01-28 10:37:00 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
834 | 2024-01-23 16:47:50 | pears | 2 | 53800 | 310 | 1.986 | 27089.6 |
833 | 2024-01-21 20:36:32 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
832 | 2024-01-20 20:28:55 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
831 | 2023-12-26 11:28:59 | pears | 2 | 53800 | 310 | 1.423 | 37807.4 |
830 | 2023-12-24 16:13:39 | pears | 2 | 53800 | 310 | 1.610 | 33416.1 |
829 | 2023-12-07 16:20:46 | pears | 1 | 28756 | 27 | 0.513 | 56054.6 |
828 | 2023-12-03 06:17:07 | pears | 1 | 28756 | 27 | 0.513 | 56054.6 |
827 | 2023-12-03 06:17:06 | pears | 1 | 28756 | 27 | 0.533 | 53951.2 |
826 | 2023-11-25 05:49:22 | pears | 1 | 28756 | 27 | 0.546 | 52666.7 |
825 | 2023-11-24 06:00:03 | pears | 1 | 28756 | 27 | 0.546 | 52666.7 |
824 | 2023-11-21 18:04:06 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
823 | 2023-11-18 07:01:24 | pears | 1 | 28756 | 27 | 0.516 | 55728.7 |
822 | 2023-11-16 20:44:14 | pears | 1 | 28756 | 27 | 0.516 | 55728.7 |
821 | 2023-11-12 07:42:51 | pears | 1 | 28756 | 27 | 0.466 | 61708.2 |
820 | 2023-11-03 04:54:32 | pears | 2 | 53800 | 310 | 1.406 | 38264.6 |
819 | 2023-11-01 06:31:06 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
818 | 2023-10-30 04:34:39 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
817 | 2023-10-24 18:42:34 | pears | 1 | 28756 | 27 | 1.013 | 28387.0 |
816 | 2023-10-20 23:34:39 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
815 | 2023-10-19 18:52:05 | pears | 1 | 28756 | 27 | 0.483 | 59536.2 |
814 | 2023-10-12 00:51:35 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
813 | 2023-10-04 14:37:28 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
812 | 2023-09-27 08:44:49 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
811 | 2023-09-22 15:36:10 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
810 | 2023-09-16 21:43:34 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
809 | 2023-09-09 16:33:38 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
808 | 2023-08-12 19:05:08 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
807 | 2023-08-03 01:43:23 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
806 | 2023-06-09 05:41:02 | pears | 1 | 28756 | 27 | 0.406 | 70827.6 |
805 | 2023-06-09 00:27:22 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
804 | 2023-05-05 10:20:26 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
803 | 2023-04-04 12:13:51 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
802 | 2023-03-28 12:43:50 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
801 | 2023-01-30 08:04:33 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
800 | 2023-01-27 22:11:12 | pears | 2 | 53800 | 310 | 1.376 | 39098.8 |
799 | 2023-01-11 13:24:09 | pears | 1 | 28756 | 27 | 0.483 | 59536.2 |
798 | 2022-12-27 23:11:43 | pears | 2 | 53800 | 310 | 1.626 | 33087.3 |
797 | 2022-11-25 10:15:15 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
796 | 2022-11-23 09:11:32 | pears | 1 | 28756 | 27 | 0.483 | 59536.2 |
795 | 2022-11-19 19:44:24 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
794 | 2022-10-19 20:34:50 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
793 | 2022-10-09 11:52:02 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
792 | 2022-08-28 18:30:00 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
791 | 2022-08-18 10:58:10 | pears | 1 | 28756 | 27 | 0.483 | 59536.2 |
790 | 2022-08-07 19:35:59 | pears | 1 | 28756 | 27 | 0.483 | 59536.2 |
789 | 2022-07-26 03:09:25 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
788 | 2022-07-08 06:08:54 | pears | 1 | 28756 | 27 | 0.486 | 59168.7 |
787 | 2022-06-07 16:00:25 | pears | 1 | 28756 | 27 | 0.516 | 55728.7 |
786 | 2022-05-24 06:29:38 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
785 | 2022-05-07 07:20:33 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
784 | 2022-05-06 17:38:26 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
783 | 2022-05-05 17:35:14 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
782 | 2022-05-05 05:50:42 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
781 | 2022-05-04 20:38:05 | pears | 1 | 28756 | 27 | 0.516 | 55728.7 |
780 | 2022-05-04 07:57:56 | pears | 1 | 28756 | 27 | 0.516 | 55728.7 |
779 | 2022-05-03 18:25:09 | pears | 1 | 28756 | 27 | 0.563 | 51076.4 |
778 | 2022-05-03 01:15:21 | pears | 1 | 28756 | 27 | 0.826 | 34813.6 |
777 | 2022-05-01 23:12:53 | pears | 1 | 28756 | 27 | 0.486 | 59168.7 |
776 | 2022-05-01 04:12:44 | pears | 1 | 28756 | 27 | 0.440 | 65354.5 |
775 | 2022-04-30 10:27:23 | pears | 1 | 28756 | 27 | 0.436 | 65954.1 |
774 | 2022-04-29 04:29:02 | pears | 1 | 28756 | 27 | 0.530 | 54256.6 |
773 | 2022-04-28 17:58:30 | pears | 1 | 28756 | 27 | 0.813 | 35370.2 |
772 | 2022-04-27 21:20:42 | pears | 1 | 28756 | 27 | 0.670 | 42919.4 |
771 | 2022-04-27 03:40:41 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
770 | 2022-04-26 12:39:56 | pears | 1 | 28756 | 27 | 0.466 | 61708.2 |
769 | 2022-04-25 22:37:46 | pears | 1 | 28756 | 27 | 0.796 | 36125.6 |
768 | 2022-04-25 09:53:33 | pears | 1 | 28756 | 27 | 0.610 | 47141.0 |
767 | 2022-04-24 17:16:08 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
766 | 2022-04-23 17:52:11 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
765 | 2022-04-22 23:51:12 | pears | 1 | 28756 | 27 | 0.846 | 33990.5 |
764 | 2022-04-22 05:08:15 | pears | 1 | 28756 | 27 | 0.440 | 65354.5 |
763 | 2022-04-21 09:02:01 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
762 | 2022-04-20 15:00:18 | pears | 1 | 28756 | 27 | 0.533 | 53951.2 |
761 | 2022-04-19 21:22:32 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |
760 | 2022-04-19 06:58:21 | pears | 1 | 28756 | 27 | 0.453 | 63479.0 |
759 | 2022-04-18 04:56:59 | pears | 1 | 28756 | 27 | 0.513 | 56054.6 |
758 | 2022-04-17 18:38:22 | pears | 1 | 28756 | 27 | 0.530 | 54256.6 |
757 | 2022-04-16 17:07:38 | pears | 1 | 28756 | 27 | 0.500 | 57512.0 |