History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roughy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
859 | 2024-04-08 06:24:46 | roughy | 2 | 82551 | 52 | 2.876 | 28703.4 |
858 | 2024-04-08 06:24:23 | roughy | 3 | 112716 | 334 | 8.750 | 12881.8 |
857 | 2024-04-04 19:37:02 | roughy | 3 | 112716 | 334 | 22.440 | 5023.0 |
856 | 2024-04-04 12:23:12 | roughy | 3 | 112716 | 334 | 13.843 | 8142.5 |
855 | 2024-04-03 09:32:13 | roughy | 3 | 112716 | 334 | 12.703 | 8873.2 |
854 | 2024-04-03 09:32:15 | roughy | 2 | 82551 | 52 | 2.936 | 28116.8 |
853 | 2024-04-03 09:32:05 | roughy | 3 | 112716 | 334 | 6.393 | 17631.2 |
852 | 2024-04-03 09:32:10 | roughy | 1 | 48755 | 6 | 0.966 | 50471.0 |
851 | 2024-04-03 09:32:04 | roughy | 2 | 82551 | 52 | 2.813 | 29346.2 |
850 | 2024-04-03 09:32:02 | roughy | 1 | 48755 | 6 | 0.966 | 50471.0 |
849 | 2024-03-30 01:56:36 | roughy | 1 | 48755 | 6 | 2.966 | 16438.0 |
848 | 2024-01-31 23:41:11 | roughy | 1 | 48755 | 6 | 0.873 | 55847.7 |
847 | 2023-12-12 15:02:26 | roughy | 3 | 112716 | 334 | 6.470 | 17421.3 |
846 | 2023-12-12 15:02:28 | roughy | 2 | 82551 | 52 | 2.640 | 31269.3 |
845 | 2023-12-01 16:48:45 | roughy | 2 | 82551 | 52 | 2.580 | 31996.5 |
844 | 2023-12-01 16:48:42 | roughy | 3 | 112716 | 334 | 5.326 | 21163.3 |
843 | 2023-11-24 14:22:57 | roughy | 1 | 48755 | 6 | 0.766 | 63648.8 |
842 | 2023-11-20 18:48:47 | roughy | 1 | 48755 | 6 | 0.766 | 63648.8 |
841 | 2023-11-11 04:31:51 | roughy | 1 | 48755 | 6 | 0.843 | 57835.1 |
840 | 2023-11-10 15:31:59 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
839 | 2023-10-27 02:08:53 | roughy | 1 | 48755 | 6 | 1.563 | 31193.2 |
838 | 2023-10-27 01:49:05 | roughy | 3 | 112716 | 334 | 5.046 | 22337.7 |
837 | 2023-10-25 13:57:24 | roughy | 3 | 112716 | 334 | 5.893 | 19127.1 |
836 | 2023-10-20 17:16:30 | roughy | 1 | 48755 | 6 | 0.763 | 63899.1 |
835 | 2023-10-19 21:44:46 | roughy | 2 | 82551 | 52 | 2.813 | 29346.2 |
834 | 2023-10-18 04:17:22 | roughy | 1 | 48755 | 6 | 0.783 | 62266.9 |
833 | 2023-10-16 21:07:52 | roughy | 3 | 112716 | 334 | 7.890 | 14285.9 |
832 | 2023-10-15 21:01:53 | roughy | 3 | 112716 | 334 | 4.970 | 22679.3 |
831 | 2023-10-15 11:48:26 | roughy | 1 | 48755 | 6 | 0.766 | 63648.8 |
830 | 2023-10-13 15:46:38 | roughy | 1 | 48755 | 6 | 0.873 | 55847.7 |
829 | 2023-10-10 15:21:35 | roughy | 3 | 112716 | 334 | 5.330 | 21147.5 |
828 | 2023-10-04 09:03:57 | roughy | 1 | 48755 | 6 | 0.766 | 63648.8 |
827 | 2023-09-23 21:13:28 | roughy | 1 | 48755 | 6 | 0.890 | 54780.9 |
826 | 2023-09-11 20:36:04 | roughy | 2 | 82551 | 52 | 2.500 | 33020.4 |
825 | 2023-09-11 20:34:25 | roughy | 3 | 112716 | 334 | 6.203 | 18171.2 |
824 | 2023-09-10 12:18:49 | roughy | 1 | 48755 | 6 | 0.843 | 57835.1 |
823 | 2023-09-10 02:36:10 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
822 | 2023-06-15 03:25:13 | roughy | 1 | 48755 | 6 | 0.783 | 62266.9 |
821 | 2023-06-08 10:29:52 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
820 | 2023-03-29 18:46:04 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
819 | 2023-03-04 20:41:49 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
818 | 2023-02-16 21:55:22 | roughy | 1 | 48755 | 6 | 0.813 | 59969.2 |
817 | 2023-01-12 07:58:20 | roughy | 1 | 48755 | 6 | 0.876 | 55656.4 |
816 | 2022-12-27 00:21:39 | roughy | 1 | 48755 | 6 | 0.826 | 59025.4 |
815 | 2022-10-21 04:08:13 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
814 | 2022-10-16 08:12:46 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
813 | 2022-06-25 23:28:31 | roughy | 1 | 48755 | 6 | 0.763 | 63899.1 |
812 | 2022-06-12 07:31:29 | roughy | 1 | 48755 | 6 | 0.873 | 55847.7 |
811 | 2022-06-07 12:20:26 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
810 | 2022-05-16 10:06:12 | roughy | 1 | 48755 | 6 | 0.923 | 52822.3 |
809 | 2022-02-10 05:50:38 | roughy | 1 | 48755 | 6 | 0.890 | 54780.9 |
808 | 2022-02-08 02:41:07 | roughy | 1 | 48755 | 6 | 0.763 | 63899.1 |
807 | 2021-12-24 17:40:01 | roughy | 1 | 48755 | 6 | 0.873 | 55847.7 |
806 | 2021-12-10 05:13:19 | roughy | 1 | 48755 | 6 | 0.923 | 52822.3 |
805 | 2021-11-30 18:26:28 | roughy | 1 | 48755 | 6 | 1.686 | 28917.6 |
804 | 2021-11-19 16:28:34 | roughy | 1 | 48755 | 6 | 0.860 | 56691.9 |
803 | 2021-10-23 16:47:12 | roughy | 1 | 48755 | 6 | 0.763 | 63899.1 |
802 | 2021-10-14 08:34:51 | roughy | 1 | 48755 | 6 | 1.560 | 31253.2 |
801 | 2021-09-21 05:18:56 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
800 | 2021-07-16 08:41:13 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
799 | 2021-07-12 19:41:10 | roughy | 1 | 48755 | 6 | 0.876 | 55656.4 |
798 | 2021-05-24 11:11:30 | roughy | 1 | 48755 | 6 | 0.893 | 54596.9 |
797 | 2021-04-27 17:15:42 | roughy | 1 | 48755 | 6 | 0.876 | 55656.4 |
796 | 2021-04-09 04:43:39 | roughy | 1 | 48755 | 6 | 0.843 | 57835.1 |
795 | 2021-03-27 17:38:01 | roughy | 1 | 48755 | 6 | 0.843 | 57835.1 |
794 | 2021-03-16 20:26:39 | roughy | 3 | 112716 | 334 | 4.736 | 23799.8 |
793 | 2021-01-11 01:27:47 | roughy | 1 | 48755 | 6 | 0.763 | 63899.1 |
792 | 2020-12-31 00:05:18 | roughy | 1 | 48755 | 6 | 0.843 | 57835.1 |
791 | 2020-12-01 12:43:24 | roughy | 3 | 112716 | 334 | 5.046 | 22337.7 |
790 | 2020-11-07 06:00:44 | roughy | 1 | 48755 | 6 | 0.953 | 51159.5 |
789 | 2020-11-02 10:17:53 | roughy | 3 | 112716 | 334 | 7.830 | 14395.4 |
788 | 2020-10-29 12:36:12 | roughy | 3 | 112716 | 334 | 5.126 | 21989.1 |
787 | 2020-10-22 02:05:09 | roughy | 1 | 48755 | 6 | 0.766 | 63648.8 |
786 | 2020-10-21 20:31:54 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
785 | 2020-10-20 22:54:16 | roughy | 1 | 48755 | 6 | 0.780 | 62506.4 |
784 | 2020-09-27 16:52:21 | roughy | 1 | 48755 | 6 | 0.750 | 65006.7 |
783 | 2020-08-31 22:39:35 | roughy | 1 | 48755 | 6 | 0.903 | 53992.2 |
782 | 2020-08-30 12:45:47 | roughy | 3 | 112716 | 334 | 4.906 | 22975.1 |
781 | 2020-08-27 23:12:37 | roughy | 1 | 48755 | 6 | 0.780 | 62506.4 |
780 | 2020-07-24 09:16:13 | roughy | 1 | 48755 | 6 | 0.810 | 60191.4 |
779 | 2020-06-18 14:56:39 | roughy | 1 | 48755 | 6 | 0.780 | 62506.4 |
778 | 2020-05-04 00:15:38 | roughy | 1 | 48755 | 6 | 0.796 | 61250.0 |
777 | 2020-03-29 22:33:49 | roughy | 1 | 48755 | 6 | 0.893 | 54596.9 |
776 | 2020-03-27 16:19:35 | roughy | 1 | 48755 | 6 | 0.826 | 59025.4 |
775 | 2020-03-25 21:06:33 | roughy | 1 | 48755 | 6 | 0.826 | 59025.4 |
774 | 2020-03-23 03:58:22 | roughy | 1 | 48755 | 6 | 0.813 | 59969.2 |
773 | 2020-03-22 04:45:02 | roughy | 1 | 48755 | 6 | 1.843 | 26454.2 |
772 | 2020-03-18 20:33:45 | roughy | 1 | 48755 | 6 | 0.843 | 57835.1 |
771 | 2020-03-10 21:08:49 | roughy | 1 | 48755 | 6 | 0.763 | 63899.1 |
770 | 2020-02-27 03:08:46 | roughy | 1 | 48755 | 6 | 0.906 | 53813.5 |
769 | 2020-02-23 01:59:35 | roughy | 1 | 48755 | 6 | 0.970 | 50262.9 |
768 | 2020-02-14 12:07:12 | roughy | 1 | 48755 | 6 | 0.936 | 52088.7 |
767 | 2020-02-06 00:41:46 | roughy | 1 | 48755 | 6 | 0.890 | 54780.9 |
766 | 2020-02-05 16:43:09 | roughy | 1 | 48755 | 6 | 0.860 | 56691.9 |
765 | 2020-02-03 21:54:40 | roughy | 1 | 48755 | 6 | 1.986 | 24549.3 |
764 | 2020-02-03 17:43:58 | roughy | 1 | 48755 | 6 | 2.923 | 16679.8 |
763 | 2020-02-03 06:27:45 | roughy | 3 | 112716 | 334 | 6.220 | 18121.5 |
762 | 2020-02-03 03:49:42 | roughy | 3 | 112716 | 334 | 12.220 | 9223.9 |
761 | 2020-02-03 03:01:00 | roughy | 3 | 112716 | 334 | 12.516 | 9005.8 |
760 | 2020-02-03 01:03:45 | roughy | 3 | 112716 | 334 | 6.983 | 16141.5 |