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 |
| 1118 | 2026-03-04 07:51:38 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1117 | 2026-03-02 02:50:38 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1116 | 2026-02-28 17:37:01 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1115 | 2026-02-28 13:24:50 | gene | 1 | 13983 | 17 | 0.486 | 28771.6 |
| 1114 | 2026-02-28 04:26:23 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1113 | 2026-02-25 20:37:13 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1112 | 2026-02-25 09:06:30 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1111 | 2026-02-24 15:50:53 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1110 | 2026-02-23 21:02:35 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1109 | 2026-02-23 19:29:13 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1108 | 2026-02-23 09:40:59 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1107 | 2026-02-23 00:18:28 | gene | 1 | 13983 | 17 | 0.253 | 55268.8 |
| 1106 | 2026-02-22 16:27:40 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1105 | 2026-02-22 12:32:44 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1104 | 2026-02-22 12:13:53 | gene | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1103 | 2026-02-22 07:15:58 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1102 | 2026-02-21 23:34:24 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1101 | 2026-02-21 14:42:40 | gene | 1 | 13983 | 17 | 0.516 | 27098.8 |
| 1100 | 2026-02-21 12:08:55 | gene | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1099 | 2026-02-21 05:11:38 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1098 | 2026-02-20 16:31:49 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1097 | 2026-02-20 10:59:29 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1096 | 2026-02-20 07:05:14 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1095 | 2026-02-20 05:21:54 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1094 | 2026-02-20 05:13:09 | gene | 1 | 13983 | 17 | 0.483 | 28950.3 |
| 1093 | 2026-02-20 03:03:16 | gene | 2 | 29872 | 310 | 1.813 | 16476.6 |
| 1092 | 2026-02-20 02:41:21 | gene | 1 | 13983 | 17 | 0.376 | 37188.8 |
| 1091 | 2026-02-19 09:13:19 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1090 | 2026-02-15 14:04:19 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1089 | 2026-02-15 04:32:18 | gene | 1 | 13983 | 17 | 0.500 | 27966.0 |
| 1088 | 2026-02-15 04:30:00 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1087 | 2026-02-13 13:15:45 | gene | 1 | 13983 | 17 | 0.796 | 17566.6 |
| 1086 | 2026-01-19 20:30:20 | gene | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1085 | 2026-01-15 18:09:18 | gene | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1084 | 2026-01-09 14:43:07 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1083 | 2026-01-06 06:52:48 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1082 | 2026-01-06 03:45:39 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1081 | 2025-12-31 13:17:18 | gene | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1080 | 2025-12-30 10:33:07 | gene | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1079 | 2025-12-29 15:10:36 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1078 | 2025-12-28 07:02:36 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1077 | 2025-12-28 03:37:22 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1076 | 2025-12-23 15:01:06 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1075 | 2025-12-14 18:22:43 | gene | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1074 | 2025-12-14 18:22:01 | gene | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 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 |