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 |
| 1073 | 2025-12-02 02:35:27 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1072 | 2025-11-30 18:58:44 | gene | 1 | 13983 | 17 | 0.530 | 26383.0 |
| 1071 | 2025-11-28 02:12:00 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1070 | 2025-11-26 09:16:45 | gene | 2 | 29872 | 310 | 2.046 | 14600.2 |
| 1069 | 2025-11-24 15:21:22 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1068 | 2025-11-24 01:21:25 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1067 | 2025-11-22 13:32:31 | gene | 2 | 29872 | 310 | 4.420 | 6758.4 |
| 1066 | 2025-11-18 05:25:20 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1065 | 2025-11-15 15:06:08 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1064 | 2025-11-14 19:47:34 | gene | 1 | 13983 | 17 | 0.500 | 27966.0 |
| 1063 | 2025-11-14 12:41:17 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1062 | 2025-11-14 06:00:17 | gene | 1 | 13983 | 17 | 0.500 | 27966.0 |
| 1061 | 2025-11-13 17:33:05 | gene | 1 | 13983 | 17 | 0.500 | 27966.0 |
| 1060 | 2025-11-13 16:21:14 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1059 | 2025-11-13 02:47:06 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1058 | 2025-11-10 21:29:55 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1057 | 2025-11-10 19:28:15 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 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 |