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 |
1056 | 2025-10-04 16:00:52 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
1055 | 2025-09-26 17:20:34 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
1054 | 2025-09-22 21:01:39 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
1053 | 2025-09-20 07:33:25 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
1052 | 2025-09-19 17:15:42 | gene | 2 | 29872 | 310 | 1.720 | 17367.4 |
1051 | 2025-09-17 16:41:53 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
1050 | 2025-09-04 11:50:23 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
1049 | 2025-09-01 03:59:55 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
1048 | 2025-08-30 03:09:24 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
1047 | 2025-08-27 10:48:39 | gene | 1 | 13983 | 17 | 0.280 | 49939.3 |
1046 | 2025-08-25 23:42:06 | gene | 1 | 13983 | 17 | 0.263 | 53167.3 |
1045 | 2025-08-17 03:37:51 | gene | 1 | 13983 | 17 | 1.173 | 11920.7 |
1044 | 2025-08-13 01:01:16 | gene | 1 | 13983 | 17 | 0.920 | 15198.9 |
1043 | 2025-08-04 09:04:08 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
1042 | 2025-08-01 06:10:16 | gene | 1 | 13983 | 17 | 1.123 | 12451.5 |
1041 | 2025-07-31 14:54:22 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
1040 | 2025-07-30 05:31:20 | gene | 1 | 13983 | 17 | 0.296 | 47239.9 |
1039 | 2025-07-27 15:42:08 | gene | 1 | 13983 | 17 | 0.283 | 49409.9 |
1038 | 2025-07-27 12:15:30 | gene | 1 | 13983 | 17 | 1.233 | 11340.6 |
1037 | 2025-07-26 19:11:17 | gene | 1 | 13983 | 17 | 0.653 | 21413.5 |
1036 | 2025-07-24 03:23:02 | gene | 1 | 13983 | 17 | 0.640 | 21848.4 |
1035 | 2025-07-23 15:58:09 | gene | 1 | 13983 | 17 | 1.530 | 9139.2 |
1034 | 2025-07-22 19:03:20 | gene | 1 | 13983 | 17 | 0.906 | 15433.8 |
1033 | 2025-07-18 11:38:53 | gene | 1 | 13983 | 17 | 1.533 | 9121.3 |
1032 | 2025-07-17 05:16:53 | gene | 1 | 13983 | 17 | 0.923 | 15149.5 |
1031 | 2025-07-09 22:58:08 | gene | 2 | 29872 | 310 | 4.296 | 6953.4 |
1030 | 2025-07-09 08:03:30 | gene | 1 | 13983 | 17 | 1.360 | 10281.6 |
1029 | 2025-07-06 19:35:13 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
1028 | 2025-07-04 08:33:35 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
1027 | 2025-07-02 16:35:24 | gene | 1 | 13983 | 17 | 0.953 | 14672.6 |
1026 | 2025-07-02 04:26:31 | gene | 1 | 13983 | 17 | 1.610 | 8685.1 |
1025 | 2025-06-30 07:11:41 | gene | 1 | 13983 | 17 | 1.360 | 10281.6 |
1024 | 2025-06-26 15:14:57 | gene | 1 | 13983 | 17 | 1.546 | 9044.6 |
1023 | 2025-06-21 16:52:45 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
1022 | 2025-06-19 16:54:02 | gene | 1 | 13983 | 17 | 1.483 | 9428.9 |
1021 | 2025-06-16 19:36:35 | gene | 1 | 13983 | 17 | 1.346 | 10388.6 |
1020 | 2025-06-12 23:25:10 | gene | 1 | 13983 | 17 | 1.923 | 7271.5 |
1019 | 2025-06-09 21:42:31 | gene | 2 | 29872 | 310 | 4.313 | 6926.0 |
1018 | 2025-06-09 06:55:12 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
1017 | 2025-06-07 08:49:36 | gene | 2 | 29872 | 310 | 4.156 | 7187.7 |
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 |