History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"proteid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1259 | 2024-03-28 06:33:19 | proteid | 1 | 69583 | 6 | 1.280 | 54361.7 |
1258 | 2024-03-13 04:26:55 | proteid | 1 | 69583 | 6 | 1.280 | 54361.7 |
1257 | 2024-03-08 23:49:57 | proteid | 3 | 134027 | 298 | 12.733 | 10526.0 |
1256 | 2024-03-08 23:48:58 | proteid | 3 | 134027 | 298 | 22.813 | 5875.0 |
1255 | 2024-03-07 23:54:28 | proteid | 3 | 134027 | 298 | 6.750 | 19855.9 |
1254 | 2024-03-07 05:33:44 | proteid | 3 | 134027 | 298 | 19.846 | 6753.4 |
1253 | 2024-03-07 05:33:42 | proteid | 2 | 107671 | 28 | 3.923 | 27446.1 |
1252 | 2024-03-07 00:54:41 | proteid | 1 | 69583 | 6 | 1.093 | 63662.4 |
1251 | 2024-01-19 16:13:31 | proteid | 3 | 134027 | 298 | 6.673 | 20085.0 |
1250 | 2024-01-16 05:45:38 | proteid | 1 | 69583 | 6 | 1.266 | 54962.9 |
1249 | 2024-01-10 19:36:19 | proteid | 1 | 69583 | 6 | 1.080 | 64428.7 |
1248 | 2024-01-09 02:04:13 | proteid | 2 | 107671 | 28 | 3.563 | 30219.2 |
1247 | 2023-12-18 01:07:07 | proteid | 1 | 69583 | 6 | 1.063 | 65459.1 |
1246 | 2023-12-16 16:13:45 | proteid | 2 | 107671 | 28 | 6.093 | 17671.3 |
1245 | 2023-12-16 08:17:53 | proteid | 3 | 134027 | 298 | 6.420 | 20876.5 |
1244 | 2023-12-08 14:38:05 | proteid | 1 | 69583 | 6 | 1.173 | 59320.5 |
1243 | 2023-11-19 21:38:39 | proteid | 1 | 69583 | 6 | 1.203 | 57841.2 |
1242 | 2023-11-11 17:59:54 | proteid | 3 | 134027 | 298 | 7.253 | 18478.8 |
1241 | 2023-11-07 07:46:17 | proteid | 3 | 134027 | 298 | 5.813 | 23056.4 |
1240 | 2023-11-06 22:48:55 | proteid | 3 | 134027 | 298 | 8.970 | 14941.7 |
1239 | 2023-11-06 07:58:24 | proteid | 3 | 134027 | 298 | 6.360 | 21073.4 |
1238 | 2023-11-06 05:15:02 | proteid | 3 | 134027 | 298 | 9.220 | 14536.6 |
1237 | 2023-11-05 07:46:35 | proteid | 3 | 134027 | 298 | 6.266 | 21389.6 |
1236 | 2023-11-04 22:40:21 | proteid | 3 | 134027 | 298 | 6.813 | 19672.2 |
1235 | 2023-11-04 07:52:51 | proteid | 3 | 134027 | 298 | 6.033 | 22215.6 |
1234 | 2023-11-03 22:33:05 | proteid | 3 | 134027 | 298 | 6.046 | 22167.9 |
1233 | 2023-11-03 07:48:03 | proteid | 3 | 134027 | 298 | 6.093 | 21996.9 |
1232 | 2023-11-02 07:51:56 | proteid | 3 | 134027 | 298 | 6.093 | 21996.9 |
1231 | 2023-11-01 11:46:15 | proteid | 3 | 134027 | 298 | 6.173 | 21711.8 |
1230 | 2023-10-31 23:03:40 | proteid | 3 | 134027 | 298 | 6.890 | 19452.4 |
1229 | 2023-10-31 11:37:58 | proteid | 3 | 134027 | 298 | 7.033 | 19056.9 |
1228 | 2023-10-30 11:11:43 | proteid | 3 | 134027 | 298 | 6.000 | 22337.8 |
1227 | 2023-10-29 21:30:55 | proteid | 3 | 134027 | 298 | 6.406 | 20922.1 |
1226 | 2023-10-29 11:25:05 | proteid | 3 | 134027 | 298 | 6.063 | 22105.7 |
1225 | 2023-10-28 21:46:49 | proteid | 3 | 134027 | 298 | 15.500 | 8646.9 |
1224 | 2023-10-28 13:19:38 | proteid | 3 | 134027 | 298 | 6.300 | 21274.1 |
1223 | 2023-10-27 22:14:26 | proteid | 3 | 134027 | 298 | 6.703 | 19995.1 |
1222 | 2023-10-27 12:10:22 | proteid | 3 | 134027 | 298 | 6.140 | 21828.5 |
1221 | 2023-10-26 20:57:52 | proteid | 3 | 134027 | 298 | 7.140 | 18771.3 |
1220 | 2023-10-26 11:06:39 | proteid | 3 | 134027 | 298 | 6.016 | 22278.4 |
1219 | 2023-10-25 22:20:21 | proteid | 1 | 69583 | 6 | 1.186 | 58670.3 |
1218 | 2023-10-25 19:42:40 | proteid | 3 | 134027 | 298 | 7.800 | 17182.9 |
1217 | 2023-10-25 10:58:20 | proteid | 3 | 134027 | 298 | 7.796 | 17191.8 |
1216 | 2023-10-24 22:39:10 | proteid | 3 | 134027 | 298 | 7.156 | 18729.3 |
1215 | 2023-10-24 20:05:04 | proteid | 3 | 134027 | 298 | 6.706 | 19986.1 |
1214 | 2023-10-24 11:19:12 | proteid | 3 | 134027 | 298 | 6.516 | 20568.9 |
1213 | 2023-10-23 14:31:33 | proteid | 3 | 134027 | 298 | 5.953 | 22514.2 |
1212 | 2023-10-22 14:39:45 | proteid | 3 | 134027 | 298 | 5.830 | 22989.2 |
1211 | 2023-10-21 14:34:26 | proteid | 3 | 134027 | 298 | 6.563 | 20421.6 |
1210 | 2023-10-20 14:47:07 | proteid | 3 | 134027 | 298 | 7.470 | 17942.0 |
1209 | 2023-10-20 00:17:25 | proteid | 3 | 134027 | 298 | 6.280 | 21341.9 |
1208 | 2023-10-19 11:30:14 | proteid | 3 | 134027 | 298 | 6.296 | 21287.6 |
1207 | 2023-10-18 23:16:03 | proteid | 3 | 134027 | 298 | 6.720 | 19944.5 |
1206 | 2023-10-18 11:07:52 | proteid | 3 | 134027 | 298 | 5.766 | 23244.4 |
1205 | 2023-10-18 08:14:09 | proteid | 2 | 107671 | 28 | 7.296 | 14757.5 |
1204 | 2023-10-18 07:54:46 | proteid | 3 | 134027 | 298 | 7.360 | 18210.2 |
1203 | 2023-10-17 22:47:06 | proteid | 3 | 134027 | 298 | 6.250 | 21444.3 |
1202 | 2023-10-17 11:00:54 | proteid | 3 | 134027 | 298 | 18.186 | 7369.8 |
1201 | 2023-10-16 08:52:36 | proteid | 3 | 134027 | 298 | 5.763 | 23256.5 |
1200 | 2023-10-15 15:51:27 | proteid | 2 | 107671 | 28 | 2.906 | 37051.3 |
1199 | 2023-10-15 08:59:19 | proteid | 3 | 134027 | 298 | 7.173 | 18684.9 |
1198 | 2023-10-15 06:54:51 | proteid | 3 | 134027 | 298 | 6.563 | 20421.6 |
1197 | 2023-10-14 15:20:42 | proteid | 3 | 134027 | 298 | 6.843 | 19586.0 |
1196 | 2023-10-14 04:38:52 | proteid | 3 | 134027 | 298 | 5.920 | 22639.7 |
1195 | 2023-10-13 04:47:30 | proteid | 3 | 134027 | 298 | 6.186 | 21666.2 |
1194 | 2023-10-12 05:01:19 | proteid | 3 | 134027 | 298 | 7.206 | 18599.4 |
1193 | 2023-10-08 17:33:10 | proteid | 3 | 134027 | 298 | 6.253 | 21434.0 |
1192 | 2023-10-08 07:17:19 | proteid | 3 | 134027 | 298 | 8.673 | 15453.4 |
1191 | 2023-10-07 17:38:30 | proteid | 3 | 134027 | 298 | 6.953 | 19276.1 |
1190 | 2023-10-06 19:36:28 | proteid | 3 | 134027 | 298 | 5.796 | 23124.1 |
1189 | 2023-10-06 00:13:46 | proteid | 1 | 69583 | 6 | 1.080 | 64428.7 |
1188 | 2023-10-05 22:07:26 | proteid | 3 | 134027 | 298 | 6.486 | 20664.0 |
1187 | 2023-10-05 10:02:04 | proteid | 3 | 134027 | 298 | 5.843 | 22938.0 |
1186 | 2023-10-04 19:32:59 | proteid | 3 | 134027 | 298 | 6.423 | 20866.7 |
1185 | 2023-09-29 13:56:15 | proteid | 3 | 134027 | 298 | 6.310 | 21240.4 |
1184 | 2023-09-29 03:41:36 | proteid | 1 | 69583 | 6 | 1.140 | 61037.7 |
1183 | 2023-09-28 23:09:03 | proteid | 3 | 134027 | 298 | 7.016 | 19103.1 |
1182 | 2023-09-28 13:55:01 | proteid | 3 | 134027 | 298 | 5.873 | 22820.9 |
1181 | 2023-09-27 23:14:31 | proteid | 3 | 134027 | 298 | 5.796 | 23124.1 |
1180 | 2023-09-27 15:46:00 | proteid | 3 | 134027 | 298 | 7.516 | 17832.2 |
1179 | 2023-09-27 06:29:15 | proteid | 3 | 134027 | 298 | 6.546 | 20474.6 |
1178 | 2023-09-26 06:51:00 | proteid | 3 | 134027 | 298 | 6.970 | 19229.1 |
1177 | 2023-09-25 06:36:37 | proteid | 3 | 134027 | 298 | 5.813 | 23056.4 |
1176 | 2023-09-25 05:12:55 | proteid | 1 | 69583 | 6 | 1.220 | 57035.2 |
1175 | 2023-09-24 03:29:15 | proteid | 3 | 134027 | 298 | 6.000 | 22337.8 |
1174 | 2023-09-19 08:19:41 | proteid | 3 | 134027 | 298 | 6.936 | 19323.4 |
1173 | 2023-09-18 22:11:54 | proteid | 3 | 134027 | 298 | 6.623 | 20236.6 |
1172 | 2023-09-18 06:33:39 | proteid | 3 | 134027 | 298 | 6.203 | 21606.8 |
1171 | 2023-09-17 19:08:14 | proteid | 3 | 134027 | 298 | 5.940 | 22563.5 |
1170 | 2023-09-16 00:03:04 | proteid | 3 | 134027 | 298 | 6.576 | 20381.2 |
1169 | 2023-09-11 12:10:47 | proteid | 3 | 134027 | 298 | 6.310 | 21240.4 |
1168 | 2023-09-09 13:05:21 | proteid | 1 | 69583 | 6 | 1.156 | 60192.9 |
1167 | 2023-09-07 23:17:41 | proteid | 3 | 134027 | 298 | 5.906 | 22693.4 |
1166 | 2023-09-06 23:18:25 | proteid | 3 | 134027 | 298 | 5.923 | 22628.2 |
1165 | 2023-08-02 08:38:42 | proteid | 1 | 69583 | 6 | 1.110 | 62687.4 |
1164 | 2023-07-25 06:34:28 | proteid | 2 | 107671 | 28 | 3.216 | 33479.8 |
1163 | 2023-05-16 20:20:00 | proteid | 1 | 69583 | 6 | 1.190 | 58473.1 |
1162 | 2023-04-29 15:39:15 | proteid | 1 | 69583 | 6 | 1.076 | 64668.2 |
1161 | 2023-04-05 23:24:16 | proteid | 2 | 107671 | 28 | 2.796 | 38508.9 |
1160 | 2023-02-20 22:38:18 | proteid | 1 | 69583 | 6 | 1.063 | 65459.1 |