History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sardines"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
863 | 2024-04-30 06:50:19 | sardines | 1 | 82945 | 4 | 4.453 | 18626.8 |
862 | 2024-04-08 08:54:36 | sardines | 1 | 82945 | 4 | 1.686 | 49196.3 |
861 | 2024-03-05 03:38:31 | sardines | 3 | 146162 | 480 | 25.220 | 5795.5 |
860 | 2024-03-04 14:48:31 | sardines | 3 | 146162 | 480 | 17.203 | 8496.3 |
859 | 2024-03-04 14:13:10 | sardines | 3 | 146162 | 480 | 15.546 | 9401.9 |
858 | 2024-03-04 13:29:54 | sardines | 3 | 146162 | 480 | 14.343 | 10190.5 |
857 | 2024-03-03 23:57:06 | sardines | 1 | 82945 | 4 | 5.140 | 16137.2 |
856 | 2024-02-11 04:00:48 | sardines | 1 | 82945 | 4 | 1.470 | 56425.2 |
855 | 2024-02-09 14:44:04 | sardines | 1 | 82945 | 4 | 1.326 | 62552.8 |
854 | 2024-02-08 08:43:33 | sardines | 3 | 146162 | 480 | 17.440 | 8380.8 |
853 | 2024-02-08 01:08:59 | sardines | 3 | 146162 | 480 | 17.673 | 8270.4 |
852 | 2024-02-08 01:09:00 | sardines | 2 | 121059 | 35 | 12.766 | 9482.9 |
851 | 2024-01-31 14:01:08 | sardines | 1 | 82945 | 4 | 1.530 | 54212.4 |
850 | 2024-01-04 15:09:54 | sardines | 3 | 146162 | 480 | 6.656 | 21959.4 |
849 | 2024-01-03 22:16:02 | sardines | 3 | 146162 | 480 | 9.596 | 15231.6 |
848 | 2024-01-03 22:16:04 | sardines | 2 | 121059 | 35 | 4.296 | 28179.5 |
847 | 2023-12-28 22:28:59 | sardines | 3 | 146162 | 480 | 7.440 | 19645.4 |
846 | 2023-12-28 22:29:00 | sardines | 2 | 121059 | 35 | 3.733 | 32429.4 |
845 | 2023-11-29 17:47:06 | sardines | 1 | 82945 | 4 | 1.470 | 56425.2 |
844 | 2023-11-22 03:14:06 | sardines | 1 | 82945 | 4 | 1.360 | 60989.0 |
843 | 2023-11-14 01:12:29 | sardines | 1 | 82945 | 4 | 1.330 | 62364.7 |
842 | 2023-10-30 10:50:41 | sardines | 1 | 82945 | 4 | 1.483 | 55930.5 |
841 | 2023-10-22 14:54:52 | sardines | 1 | 82945 | 4 | 1.546 | 53651.4 |
840 | 2023-10-19 02:14:54 | sardines | 1 | 82945 | 4 | 1.436 | 57761.1 |
839 | 2023-10-14 05:58:35 | sardines | 1 | 82945 | 4 | 1.483 | 55930.5 |
838 | 2023-10-11 23:19:09 | sardines | 1 | 82945 | 4 | 2.626 | 31586.1 |
837 | 2023-09-26 18:50:20 | sardines | 1 | 82945 | 4 | 1.623 | 51106.0 |
836 | 2023-09-21 23:46:38 | sardines | 1 | 82945 | 4 | 1.686 | 49196.3 |
835 | 2023-09-15 01:19:56 | sardines | 1 | 82945 | 4 | 1.500 | 55296.7 |
834 | 2023-06-27 06:27:06 | sardines | 1 | 82945 | 4 | 1.500 | 55296.7 |
833 | 2023-06-22 01:14:51 | sardines | 1 | 82945 | 4 | 1.373 | 60411.5 |
832 | 2023-04-01 09:28:46 | sardines | 1 | 82945 | 4 | 1.453 | 57085.3 |
831 | 2023-03-14 18:43:14 | sardines | 1 | 82945 | 4 | 2.736 | 30316.2 |
830 | 2023-01-14 21:16:28 | sardines | 1 | 82945 | 4 | 1.296 | 64000.8 |
829 | 2022-11-29 22:08:48 | sardines | 1 | 82945 | 4 | 1.513 | 54821.5 |
828 | 2022-11-26 15:18:43 | sardines | 1 | 82945 | 4 | 1.483 | 55930.5 |
827 | 2022-08-02 23:44:21 | sardines | 1 | 82945 | 4 | 1.453 | 57085.3 |
826 | 2022-06-03 12:51:33 | sardines | 1 | 82945 | 4 | 1.330 | 62364.7 |
825 | 2022-04-08 09:40:52 | sardines | 1 | 82945 | 4 | 1.550 | 53512.9 |
824 | 2022-04-04 23:13:29 | sardines | 1 | 82945 | 4 | 1.670 | 49667.7 |
823 | 2022-02-11 06:27:46 | sardines | 1 | 82945 | 4 | 1.313 | 63172.1 |
822 | 2021-12-28 15:53:13 | sardines | 1 | 82945 | 4 | 1.563 | 53067.8 |
821 | 2021-12-21 03:49:48 | sardines | 1 | 82945 | 4 | 1.340 | 61899.3 |
820 | 2021-12-02 20:49:49 | sardines | 1 | 82945 | 4 | 2.470 | 33581.0 |
819 | 2021-11-19 00:36:57 | sardines | 1 | 82945 | 4 | 1.360 | 60989.0 |
818 | 2021-10-28 16:05:35 | sardines | 1 | 82945 | 4 | 1.313 | 63172.1 |
817 | 2021-09-13 22:13:33 | sardines | 1 | 82945 | 4 | 1.470 | 56425.2 |
816 | 2021-09-10 17:13:29 | sardines | 1 | 82945 | 4 | 2.093 | 39629.7 |
815 | 2021-06-30 13:13:08 | sardines | 1 | 82945 | 4 | 3.143 | 26390.4 |
814 | 2021-06-28 05:29:48 | sardines | 1 | 82945 | 4 | 1.563 | 53067.8 |
813 | 2021-06-09 20:17:25 | sardines | 1 | 82945 | 4 | 1.313 | 63172.1 |
812 | 2021-05-25 21:46:34 | sardines | 3 | 146162 | 480 | 7.750 | 18859.6 |
811 | 2021-05-05 15:43:07 | sardines | 1 | 82945 | 4 | 1.500 | 55296.7 |
810 | 2021-04-11 12:22:50 | sardines | 3 | 146162 | 480 | 8.096 | 18053.6 |
809 | 2021-03-07 11:55:46 | sardines | 1 | 82945 | 4 | 1.296 | 64000.8 |
808 | 2021-03-04 10:00:42 | sardines | 1 | 82945 | 4 | 1.513 | 54821.5 |
807 | 2021-03-04 09:38:32 | sardines | 1 | 82945 | 4 | 1.516 | 54713.1 |
806 | 2021-02-12 03:37:13 | sardines | 1 | 82945 | 4 | 1.330 | 62364.7 |
805 | 2021-01-25 17:40:03 | sardines | 3 | 146162 | 480 | 7.126 | 20511.1 |
804 | 2020-12-20 07:21:56 | sardines | 3 | 146162 | 480 | 6.986 | 20922.1 |
803 | 2020-12-03 12:29:06 | sardines | 1 | 82945 | 4 | 1.326 | 62552.8 |
802 | 2020-11-09 23:33:25 | sardines | 1 | 82945 | 4 | 1.483 | 55930.5 |
801 | 2020-11-06 12:33:49 | sardines | 1 | 82945 | 4 | 1.436 | 57761.1 |
800 | 2020-10-26 07:34:55 | sardines | 1 | 82945 | 4 | 1.310 | 63316.8 |
799 | 2020-10-23 20:26:32 | sardines | 1 | 82945 | 4 | 1.470 | 56425.2 |
798 | 2020-10-03 23:02:52 | sardines | 1 | 82945 | 4 | 1.313 | 63172.1 |
797 | 2020-09-05 14:20:45 | sardines | 1 | 82945 | 4 | 1.330 | 62364.7 |
796 | 2020-09-01 05:16:48 | sardines | 1 | 82945 | 4 | 1.563 | 53067.8 |
795 | 2020-08-30 04:36:00 | sardines | 1 | 82945 | 4 | 1.360 | 60989.0 |
794 | 2020-05-30 12:19:05 | sardines | 1 | 82945 | 4 | 1.376 | 60279.8 |
793 | 2020-03-28 17:48:14 | sardines | 1 | 82945 | 4 | 1.580 | 52496.8 |
792 | 2020-03-26 12:30:29 | sardines | 1 | 82945 | 4 | 1.453 | 57085.3 |
791 | 2020-03-23 15:35:50 | sardines | 1 | 82945 | 4 | 2.140 | 38759.3 |
790 | 2020-03-20 09:31:29 | sardines | 1 | 82945 | 4 | 1.373 | 60411.5 |
789 | 2020-02-27 05:15:33 | sardines | 1 | 82945 | 4 | 1.670 | 49667.7 |
788 | 2020-02-25 21:21:08 | sardines | 1 | 82945 | 4 | 1.500 | 55296.7 |
787 | 2020-02-25 15:25:16 | sardines | 1 | 82945 | 4 | 1.936 | 42843.5 |
786 | 2020-02-25 13:49:57 | sardines | 1 | 82945 | 4 | 1.766 | 46967.7 |
785 | 2020-02-24 20:53:47 | sardines | 1 | 82945 | 4 | 1.623 | 51106.0 |
784 | 2020-02-13 13:56:11 | sardines | 3 | 146162 | 480 | 7.530 | 19410.6 |
783 | 2020-02-06 02:40:31 | sardines | 3 | 146162 | 480 | 12.780 | 11436.8 |
782 | 2020-02-05 20:14:44 | sardines | 1 | 82945 | 4 | 1.546 | 53651.4 |
781 | 2020-02-05 12:28:17 | sardines | 3 | 146162 | 480 | 9.470 | 15434.2 |
780 | 2020-02-04 15:54:59 | sardines | 1 | 82945 | 4 | 1.550 | 53512.9 |
779 | 2020-02-03 23:27:04 | sardines | 1 | 82945 | 4 | 1.533 | 54106.3 |
778 | 2020-02-02 19:48:19 | sardines | 3 | 146162 | 480 | 13.720 | 10653.2 |
777 | 2020-02-02 03:51:54 | sardines | 3 | 146162 | 480 | 8.296 | 17618.4 |
776 | 2020-02-02 00:02:36 | sardines | 3 | 146162 | 480 | 15.500 | 9429.8 |
775 | 2020-02-01 10:05:59 | sardines | 3 | 146162 | 480 | 16.503 | 8856.7 |
774 | 2020-01-31 07:50:02 | sardines | 1 | 82945 | 4 | 1.610 | 51518.6 |
773 | 2020-01-30 15:19:27 | sardines | 1 | 82945 | 4 | 3.076 | 26965.2 |
772 | 2020-01-30 12:58:42 | sardines | 1 | 82945 | 4 | 2.330 | 35598.7 |
771 | 2020-01-16 06:37:27 | sardines | 1 | 82945 | 4 | 3.500 | 23698.6 |
770 | 2020-01-15 09:48:01 | sardines | 1 | 82945 | 4 | 3.143 | 26390.4 |
769 | 2020-01-11 22:55:25 | sardines | 3 | 146162 | 480 | 8.736 | 16731.0 |
768 | 2020-01-11 22:17:34 | sardines | 1 | 82945 | 4 | 1.593 | 52068.4 |
767 | 2020-01-11 06:49:08 | sardines | 3 | 146162 | 480 | 9.266 | 15774.0 |
766 | 2020-01-11 02:50:44 | sardines | 3 | 146162 | 480 | 11.406 | 12814.5 |
765 | 2020-01-07 22:19:44 | sardines | 1 | 82945 | 4 | 1.936 | 42843.5 |
764 | 2020-01-01 14:41:31 | sardines | 1 | 82945 | 4 | 3.110 | 26670.4 |