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 |
1016 | 2025-06-04 12:02:20 | gene | 2 | 29872 | 310 | 2.080 | 14361.5 |
1015 | 2025-06-04 08:14:05 | gene | 1 | 13983 | 17 | 2.423 | 5770.9 |
1014 | 2025-06-04 05:54:06 | gene | 2 | 29872 | 310 | 4.046 | 7383.1 |
1013 | 2025-06-03 00:27:02 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
1012 | 2025-05-31 22:16:30 | gene | 1 | 13983 | 17 | 0.703 | 19890.5 |
1011 | 2025-05-31 01:44:02 | gene | 2 | 29872 | 310 | 4.766 | 6267.7 |
1010 | 2025-05-29 10:26:48 | gene | 2 | 29872 | 310 | 4.126 | 7239.9 |
1009 | 2025-05-28 21:42:40 | gene | 1 | 13983 | 17 | 1.953 | 7159.8 |
1008 | 2025-05-27 21:15:45 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
1007 | 2025-05-26 21:34:32 | gene | 1 | 13983 | 17 | 0.686 | 20383.4 |
1006 | 2025-05-22 03:44:09 | gene | 1 | 13983 | 17 | 0.516 | 27098.8 |
1005 | 2025-05-19 13:08:01 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
1004 | 2025-05-16 03:53:56 | gene | 1 | 13983 | 17 | 0.953 | 14672.6 |
1003 | 2025-05-10 07:18:51 | gene | 1 | 13983 | 17 | 2.266 | 6170.8 |
1002 | 2025-05-09 21:58:46 | gene | 2 | 29872 | 310 | 4.533 | 6589.9 |
1001 | 2025-05-09 07:36:00 | gene | 1 | 13983 | 17 | 0.656 | 21315.5 |
1000 | 2025-05-08 04:33:36 | gene | 1 | 13983 | 17 | 0.970 | 14415.5 |
999 | 2025-05-04 17:38:56 | gene | 1 | 13983 | 17 | 0.826 | 16928.6 |
998 | 2025-05-04 08:21:12 | gene | 1 | 13983 | 17 | 1.123 | 12451.5 |
997 | 2025-05-02 16:58:22 | gene | 1 | 13983 | 17 | 1.453 | 9623.5 |
996 | 2025-05-02 06:49:42 | gene | 1 | 13983 | 17 | 1.623 | 8615.5 |
995 | 2025-05-02 01:10:41 | gene | 1 | 13983 | 17 | 1.013 | 13803.6 |
994 | 2025-05-02 00:59:51 | gene | 2 | 29872 | 310 | 4.263 | 7007.3 |
993 | 2025-04-30 01:56:33 | gene | 2 | 29872 | 310 | 4.390 | 6804.6 |
992 | 2025-04-29 02:53:10 | gene | 1 | 13983 | 17 | 0.330 | 42372.7 |
991 | 2025-04-24 20:44:41 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
990 | 2025-04-23 09:43:58 | gene | 1 | 13983 | 17 | 0.283 | 49409.9 |
989 | 2025-04-14 20:53:26 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
988 | 2025-04-14 03:18:26 | gene | 1 | 13983 | 17 | 0.670 | 20870.1 |
987 | 2025-04-08 21:47:29 | gene | 2 | 29872 | 310 | 6.483 | 4607.7 |
986 | 2025-04-08 07:07:05 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
985 | 2025-04-08 02:49:47 | gene | 1 | 13983 | 17 | 1.216 | 11499.2 |
984 | 2025-04-05 10:59:28 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
983 | 2025-04-02 00:24:05 | gene | 1 | 13983 | 17 | 0.966 | 14475.2 |
982 | 2025-04-01 17:35:16 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
981 | 2025-03-29 04:45:33 | gene | 1 | 13983 | 17 | 1.906 | 7336.3 |
980 | 2025-03-26 12:54:50 | gene | 1 | 13983 | 17 | 0.453 | 30867.5 |
979 | 2025-03-18 21:58:43 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
978 | 2025-03-14 20:37:39 | gene | 1 | 13983 | 17 | 0.283 | 49409.9 |
977 | 2025-03-07 03:03:20 | gene | 2 | 29872 | 310 | 7.296 | 4094.3 |
976 | 2025-03-07 02:43:36 | gene | 1 | 13983 | 17 | 1.610 | 8685.1 |
975 | 2025-03-01 03:42:41 | gene | 1 | 13983 | 17 | 0.660 | 21186.4 |
974 | 2025-02-28 20:15:08 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
973 | 2025-02-25 23:45:34 | gene | 2 | 29872 | 310 | 4.313 | 6926.0 |
972 | 2025-02-25 23:26:44 | gene | 1 | 13983 | 17 | 1.373 | 10184.3 |
971 | 2025-02-25 12:06:26 | gene | 2 | 29872 | 310 | 6.420 | 4653.0 |
970 | 2025-02-25 11:55:20 | gene | 1 | 13983 | 17 | 0.203 | 68881.8 |
969 | 2025-02-25 02:18:42 | gene | 1 | 13983 | 17 | 0.936 | 14939.1 |
968 | 2025-02-23 05:58:45 | gene | 1 | 13983 | 17 | 0.783 | 17858.2 |
967 | 2025-02-11 03:23:55 | gene | 2 | 29872 | 310 | 3.500 | 8534.9 |
966 | 2025-02-04 22:57:17 | gene | 2 | 29872 | 310 | 6.156 | 4852.5 |
965 | 2025-02-04 22:12:48 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
964 | 2025-01-26 12:24:20 | gene | 2 | 29872 | 310 | 2.126 | 14050.8 |
963 | 2025-01-26 12:15:15 | gene | 2 | 29872 | 310 | 3.406 | 8770.4 |
962 | 2025-01-26 11:53:47 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
961 | 2025-01-26 11:31:00 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
960 | 2025-01-24 02:40:46 | gene | 1 | 13983 | 17 | 2.376 | 5885.1 |
959 | 2025-01-05 18:43:48 | gene | 2 | 29872 | 310 | 3.983 | 7499.9 |
958 | 2025-01-05 18:37:40 | gene | 1 | 13983 | 17 | 0.920 | 15198.9 |
957 | 2024-12-27 10:24:36 | gene | 2 | 29872 | 310 | 2.000 | 14936.0 |
956 | 2024-12-27 09:20:34 | gene | 1 | 13983 | 17 | 1.546 | 9044.6 |
955 | 2024-12-27 07:33:04 | gene | 2 | 29872 | 310 | 4.376 | 6826.3 |
954 | 2024-12-27 07:26:31 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
953 | 2024-12-25 01:42:51 | gene | 1 | 13983 | 17 | 0.313 | 44674.1 |
952 | 2024-12-06 18:08:28 | gene | 2 | 29872 | 310 | 5.423 | 5508.4 |
951 | 2024-12-06 17:56:01 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
950 | 2024-11-27 05:15:30 | gene | 2 | 29872 | 310 | 2.420 | 12343.8 |
949 | 2024-11-27 04:35:18 | gene | 2 | 29872 | 310 | 2.656 | 11247.0 |
948 | 2024-11-27 02:56:25 | gene | 1 | 13983 | 17 | 1.250 | 11186.4 |
947 | 2024-11-26 23:25:13 | gene | 1 | 13983 | 17 | 0.686 | 20383.4 |
946 | 2024-11-24 23:20:18 | gene | 1 | 13983 | 17 | 0.606 | 23074.3 |
945 | 2024-11-06 17:50:10 | gene | 2 | 29872 | 310 | 3.530 | 8462.3 |
944 | 2024-11-06 17:47:38 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
943 | 2024-10-28 16:22:23 | gene | 2 | 29872 | 310 | 5.046 | 5919.9 |
942 | 2024-10-27 22:51:56 | gene | 2 | 29872 | 310 | 4.970 | 6010.5 |
941 | 2024-10-27 20:53:32 | gene | 1 | 13983 | 17 | 0.626 | 22337.1 |
940 | 2024-10-27 20:29:00 | gene | 2 | 29872 | 310 | 4.186 | 7136.2 |
939 | 2024-10-27 20:24:22 | gene | 1 | 13983 | 17 | 1.063 | 13154.3 |
938 | 2024-10-26 22:00:57 | gene | 1 | 13983 | 17 | 0.953 | 14672.6 |
937 | 2024-10-25 19:28:19 | gene | 1 | 13983 | 17 | 0.750 | 18644.0 |
936 | 2024-10-07 14:09:01 | gene | 1 | 13983 | 17 | 2.750 | 5084.7 |
935 | 2024-09-27 17:03:15 | gene | 2 | 29872 | 310 | 9.393 | 3180.2 |
934 | 2024-09-27 16:24:41 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
933 | 2024-09-27 15:30:39 | gene | 1 | 13983 | 17 | 1.750 | 7990.3 |
932 | 2024-09-25 17:17:54 | gene | 1 | 13983 | 17 | 0.763 | 18326.3 |
931 | 2024-09-08 06:18:35 | gene | 2 | 29872 | 310 | 6.433 | 4643.6 |
930 | 2024-09-07 12:57:42 | gene | 2 | 29872 | 310 | 3.626 | 8238.3 |
929 | 2024-09-07 11:59:26 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
928 | 2024-09-07 03:26:42 | gene | 1 | 13983 | 17 | 1.970 | 7098.0 |
927 | 2024-08-30 04:07:30 | gene | 1 | 13983 | 17 | 2.873 | 4867.0 |
926 | 2024-08-28 15:06:14 | gene | 1 | 13983 | 17 | 1.080 | 12947.2 |
925 | 2024-08-28 11:31:02 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
924 | 2024-08-26 16:48:52 | gene | 1 | 13983 | 17 | 2.500 | 5593.2 |
923 | 2024-08-07 23:13:37 | gene | 1 | 13983 | 17 | 1.220 | 11461.5 |
922 | 2024-08-02 07:34:50 | gene | 1 | 13983 | 17 | 0.673 | 20777.1 |
921 | 2024-07-29 17:09:13 | gene | 2 | 29872 | 310 | 0.860 | 34734.9 |
920 | 2024-07-29 16:49:18 | gene | 2 | 29872 | 310 | 4.753 | 6284.9 |
919 | 2024-07-29 15:00:51 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
918 | 2024-07-29 03:44:07 | gene | 1 | 13983 | 17 | 0.513 | 27257.3 |
917 | 2024-07-28 02:18:35 | gene | 1 | 13983 | 17 | 0.673 | 20777.1 |