History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gene"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
891 | 2024-04-23 15:00:43 | gene | 1 | 13983 | 17 | 0.516 | 27098.8 |
890 | 2024-04-23 14:31:19 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
889 | 2024-04-23 13:50:41 | gene | 1 | 13983 | 17 | 0.970 | 14415.5 |
888 | 2024-04-19 17:08:46 | gene | 1 | 13983 | 17 | 0.830 | 16847.0 |
887 | 2024-04-12 10:56:06 | gene | 1 | 13983 | 17 | 0.420 | 33292.9 |
886 | 2024-04-09 17:11:50 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
885 | 2024-04-05 00:59:57 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
884 | 2024-04-03 00:38:45 | gene | 1 | 13983 | 17 | 0.500 | 27966.0 |
883 | 2024-03-30 19:41:33 | gene | 2 | 29872 | 310 | 1.173 | 25466.3 |
882 | 2024-03-30 19:40:53 | gene | 1 | 13983 | 17 | 0.280 | 49939.3 |
881 | 2024-03-21 05:07:07 | gene | 1 | 13983 | 17 | 0.483 | 28950.3 |
880 | 2024-03-05 19:46:09 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
879 | 2024-03-03 20:18:48 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
878 | 2024-02-19 11:34:33 | gene | 2 | 29872 | 310 | 1.826 | 16359.3 |
877 | 2024-02-19 03:55:18 | gene | 2 | 29872 | 310 | 2.970 | 10057.9 |
876 | 2024-01-26 18:46:55 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
875 | 2024-01-09 02:42:42 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
874 | 2023-12-29 10:14:37 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
873 | 2023-12-29 05:41:04 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
872 | 2023-12-08 07:03:47 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
871 | 2023-12-08 07:03:46 | gene | 1 | 13983 | 17 | 0.563 | 24836.6 |
870 | 2023-12-01 01:07:06 | gene | 2 | 29872 | 310 | 0.843 | 35435.3 |
869 | 2023-11-30 01:46:11 | gene | 2 | 29872 | 310 | 0.796 | 37527.6 |
868 | 2023-11-23 02:30:12 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
867 | 2023-11-19 18:21:46 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
866 | 2023-11-10 10:49:24 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
865 | 2023-11-10 01:52:27 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
864 | 2023-10-26 09:12:22 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
863 | 2023-10-26 09:00:32 | gene | 2 | 29872 | 310 | 0.753 | 39670.7 |
862 | 2023-10-24 18:32:13 | gene | 2 | 29872 | 310 | 1.030 | 29001.9 |
861 | 2023-10-19 18:38:30 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
860 | 2023-10-18 06:48:30 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
859 | 2023-10-17 19:24:23 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
858 | 2023-10-13 13:31:20 | gene | 2 | 29872 | 310 | 0.736 | 40587.0 |
857 | 2023-10-11 08:17:12 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
856 | 2023-10-08 21:00:30 | gene | 2 | 29872 | 310 | 1.000 | 29872.0 |
855 | 2023-10-03 15:03:10 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
854 | 2023-09-23 19:45:03 | gene | 2 | 29872 | 310 | 0.813 | 36742.9 |
853 | 2023-09-23 02:05:49 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
852 | 2023-09-18 23:38:42 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
851 | 2023-09-12 08:29:29 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
850 | 2023-08-13 20:26:15 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
849 | 2023-06-19 01:24:29 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
848 | 2023-05-10 17:39:07 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
847 | 2023-03-20 00:15:27 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
846 | 2023-03-16 17:29:16 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
845 | 2023-03-07 01:51:07 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
844 | 2022-12-29 01:52:43 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
843 | 2022-12-11 17:35:35 | gene | 1 | 13983 | 17 | 0.200 | 69915.0 |
842 | 2022-09-19 16:44:18 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
841 | 2022-09-18 12:31:41 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
840 | 2022-09-16 22:40:15 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
839 | 2022-09-12 06:12:54 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
838 | 2022-08-31 18:33:55 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
837 | 2022-08-14 23:58:57 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
836 | 2022-08-14 11:21:02 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
835 | 2022-08-06 22:22:09 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
834 | 2022-07-17 19:01:03 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
833 | 2022-07-17 18:06:29 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
832 | 2022-07-10 15:20:17 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
831 | 2022-07-10 03:48:07 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
830 | 2022-07-09 21:40:12 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
829 | 2022-07-02 15:35:21 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
828 | 2022-06-25 20:31:05 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
827 | 2022-06-25 06:17:23 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
826 | 2022-06-24 19:29:44 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
825 | 2022-05-26 03:58:43 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
824 | 2022-04-25 07:41:04 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
823 | 2022-04-08 17:14:29 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
822 | 2022-04-07 19:50:30 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
821 | 2022-04-06 17:01:39 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
820 | 2022-04-05 22:30:24 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
819 | 2022-04-01 17:34:09 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
818 | 2022-02-18 03:49:05 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
817 | 2022-01-18 19:11:22 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
816 | 2021-12-19 18:20:12 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
815 | 2021-11-16 12:28:28 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
814 | 2021-11-13 11:26:21 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
813 | 2021-10-04 06:55:35 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
812 | 2021-09-04 05:39:59 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
811 | 2021-09-01 22:56:55 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
810 | 2021-08-17 15:57:47 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
809 | 2021-08-15 11:33:42 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
808 | 2021-08-13 21:38:49 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
807 | 2021-05-15 04:39:36 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
806 | 2021-05-13 04:15:01 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
805 | 2021-04-14 09:23:52 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
804 | 2021-02-09 11:26:34 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
803 | 2021-01-30 01:46:04 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
802 | 2020-12-02 10:59:24 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
801 | 2020-11-07 17:55:34 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
800 | 2020-10-15 08:09:30 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
799 | 2020-09-27 17:30:12 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
798 | 2020-09-24 20:29:13 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
797 | 2020-08-31 01:17:15 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
796 | 2020-08-27 05:46:06 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
795 | 2020-08-25 02:33:27 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
794 | 2020-08-24 18:08:28 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
793 | 2020-08-21 21:53:39 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
792 | 2020-08-14 00:15:51 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |