History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"strains"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1313 | 2024-04-28 09:31:32 | strains | 1 | 69583 | 6 | 3.983 | 17470.0 |
1312 | 2024-04-27 13:21:51 | strains | 2 | 107671 | 67 | 4.343 | 24791.8 |
1311 | 2024-04-25 19:37:45 | strains | 2 | 107671 | 67 | 5.030 | 21405.8 |
1310 | 2024-04-25 19:04:11 | strains | 2 | 107671 | 67 | 4.830 | 22292.1 |
1309 | 2024-04-25 18:51:25 | strains | 3 | 134027 | 659 | 7.690 | 17428.7 |
1308 | 2024-04-24 19:25:25 | strains | 3 | 134027 | 659 | 10.813 | 12395.0 |
1307 | 2024-04-22 06:13:41 | strains | 3 | 134027 | 659 | 18.720 | 7159.6 |
1306 | 2024-04-20 18:54:30 | strains | 3 | 134027 | 659 | 19.360 | 6922.9 |
1305 | 2024-04-20 14:45:10 | strains | 3 | 134027 | 659 | 16.560 | 8093.4 |
1304 | 2024-04-19 21:29:18 | strains | 3 | 134027 | 659 | 26.046 | 5145.8 |
1303 | 2024-04-19 17:14:08 | strains | 1 | 69583 | 6 | 1.186 | 58670.3 |
1302 | 2024-04-19 15:54:33 | strains | 3 | 134027 | 659 | 9.923 | 13506.7 |
1301 | 2024-03-10 22:15:23 | strains | 3 | 134027 | 659 | 11.876 | 11285.5 |
1300 | 2024-03-09 00:12:23 | strains | 3 | 134027 | 659 | 8.780 | 15265.0 |
1299 | 2024-03-08 16:40:55 | strains | 3 | 134027 | 659 | 16.470 | 8137.6 |
1298 | 2024-03-08 04:10:58 | strains | 3 | 134027 | 659 | 23.470 | 5710.6 |
1297 | 2024-03-07 18:21:04 | strains | 3 | 134027 | 659 | 13.376 | 10020.0 |
1296 | 2024-03-07 07:16:18 | strains | 3 | 134027 | 659 | 18.376 | 7293.6 |
1295 | 2024-02-27 17:16:52 | strains | 1 | 69583 | 6 | 1.296 | 53690.6 |
1294 | 2024-02-09 16:43:48 | strains | 3 | 134027 | 659 | 12.766 | 10498.7 |
1293 | 2024-02-07 09:42:42 | strains | 2 | 107671 | 67 | 3.373 | 31921.4 |
1292 | 2024-02-07 09:31:06 | strains | 3 | 134027 | 659 | 7.440 | 18014.4 |
1291 | 2024-01-29 18:48:53 | strains | 1 | 69583 | 6 | 1.250 | 55666.4 |
1290 | 2024-01-29 12:42:43 | strains | 3 | 134027 | 659 | 6.670 | 20094.0 |
1289 | 2024-01-26 10:44:33 | strains | 3 | 134027 | 659 | 7.093 | 18895.7 |
1288 | 2024-01-23 02:12:33 | strains | 3 | 134027 | 659 | 13.096 | 10234.2 |
1287 | 2024-01-22 18:34:14 | strains | 3 | 134027 | 659 | 9.690 | 13831.5 |
1286 | 2024-01-22 00:44:16 | strains | 3 | 134027 | 659 | 7.266 | 18445.8 |
1285 | 2024-01-22 00:44:15 | strains | 2 | 107671 | 67 | 3.580 | 30075.7 |
1284 | 2023-12-08 17:13:33 | strains | 1 | 69583 | 6 | 1.186 | 58670.3 |
1283 | 2023-11-26 15:26:08 | strains | 1 | 69583 | 6 | 2.686 | 25905.8 |
1282 | 2023-11-23 09:01:30 | strains | 1 | 69583 | 6 | 1.093 | 63662.4 |
1281 | 2023-11-19 02:17:39 | strains | 1 | 69583 | 6 | 1.233 | 56433.9 |
1280 | 2023-11-15 21:16:43 | strains | 1 | 69583 | 6 | 1.423 | 48898.8 |
1279 | 2023-11-10 09:06:13 | strains | 1 | 69583 | 6 | 1.156 | 60192.9 |
1278 | 2023-10-31 23:53:36 | strains | 1 | 69583 | 6 | 1.160 | 59985.3 |
1277 | 2023-10-17 22:37:31 | strains | 1 | 69583 | 6 | 1.203 | 57841.2 |
1276 | 2023-10-11 07:49:22 | strains | 1 | 69583 | 6 | 2.326 | 29915.3 |
1275 | 2023-10-03 16:17:23 | strains | 1 | 69583 | 6 | 1.093 | 63662.4 |
1274 | 2023-09-29 00:20:03 | strains | 1 | 69583 | 6 | 1.173 | 59320.5 |
1273 | 2023-09-26 01:58:19 | strains | 1 | 69583 | 6 | 1.220 | 57035.2 |
1272 | 2023-09-11 13:56:14 | strains | 3 | 134027 | 659 | 13.250 | 10115.2 |
1271 | 2023-09-09 21:03:53 | strains | 1 | 69583 | 6 | 1.203 | 57841.2 |
1270 | 2023-09-07 17:43:28 | strains | 3 | 134027 | 659 | 6.236 | 21492.5 |
1269 | 2023-08-12 07:02:28 | strains | 1 | 69583 | 6 | 1.076 | 64668.2 |
1268 | 2023-08-09 19:32:33 | strains | 3 | 134027 | 659 | 6.063 | 22105.7 |
1267 | 2023-08-08 20:23:48 | strains | 3 | 134027 | 659 | 6.656 | 20136.3 |
1266 | 2023-08-04 10:17:55 | strains | 3 | 134027 | 659 | 6.486 | 20664.0 |
1265 | 2023-08-02 04:17:00 | strains | 1 | 69583 | 6 | 1.076 | 64668.2 |
1264 | 2023-07-28 16:11:09 | strains | 3 | 134027 | 659 | 7.706 | 17392.6 |
1263 | 2023-07-26 18:09:22 | strains | 3 | 134027 | 659 | 6.780 | 19768.0 |
1262 | 2023-07-25 00:01:27 | strains | 3 | 134027 | 659 | 7.250 | 18486.5 |
1261 | 2023-07-21 10:22:01 | strains | 3 | 134027 | 659 | 9.593 | 13971.3 |
1260 | 2023-07-20 23:08:55 | strains | 3 | 134027 | 659 | 6.720 | 19944.5 |
1259 | 2023-07-19 23:02:29 | strains | 3 | 134027 | 659 | 7.296 | 18369.9 |
1258 | 2023-07-18 19:35:29 | strains | 3 | 134027 | 659 | 6.623 | 20236.6 |
1257 | 2023-07-12 15:33:18 | strains | 3 | 134027 | 659 | 6.750 | 19855.9 |
1256 | 2023-07-11 21:02:14 | strains | 3 | 134027 | 659 | 6.670 | 20094.0 |
1255 | 2023-07-11 19:03:58 | strains | 1 | 69583 | 6 | 1.233 | 56433.9 |
1254 | 2023-06-28 07:05:37 | strains | 3 | 134027 | 659 | 6.050 | 22153.2 |
1253 | 2023-06-16 00:16:00 | strains | 1 | 69583 | 6 | 1.093 | 63662.4 |
1252 | 2023-06-05 14:49:18 | strains | 1 | 69583 | 6 | 1.236 | 56296.9 |
1251 | 2023-05-23 01:36:29 | strains | 3 | 134027 | 659 | 5.813 | 23056.4 |
1250 | 2023-05-07 07:31:13 | strains | 1 | 69583 | 6 | 1.170 | 59472.6 |
1249 | 2023-04-16 21:49:31 | strains | 1 | 69583 | 6 | 1.063 | 65459.1 |
1248 | 2023-04-09 14:09:54 | strains | 3 | 134027 | 659 | 5.750 | 23309.0 |
1247 | 2023-03-30 15:53:00 | strains | 1 | 69583 | 6 | 2.406 | 28920.6 |
1246 | 2023-03-20 21:37:41 | strains | 1 | 69583 | 6 | 1.093 | 63662.4 |
1245 | 2023-03-17 10:21:55 | strains | 1 | 69583 | 6 | 1.123 | 61961.7 |
1244 | 2023-03-03 01:11:23 | strains | 1 | 69583 | 6 | 1.173 | 59320.5 |
1243 | 2023-02-22 08:31:13 | strains | 1 | 69583 | 6 | 1.096 | 63488.1 |
1242 | 2023-02-09 13:49:29 | strains | 3 | 134027 | 659 | 6.593 | 20328.7 |
1241 | 2023-01-11 16:37:11 | strains | 1 | 69583 | 6 | 1.076 | 64668.2 |
1240 | 2023-01-02 00:32:05 | strains | 1 | 69583 | 6 | 1.203 | 57841.2 |
1239 | 2022-12-30 01:20:56 | strains | 1 | 69583 | 6 | 1.156 | 60192.9 |
1238 | 2022-12-22 04:03:15 | strains | 3 | 134027 | 659 | 6.750 | 19855.9 |
1237 | 2022-11-26 05:09:49 | strains | 1 | 69583 | 6 | 1.110 | 62687.4 |
1236 | 2022-11-22 20:03:33 | strains | 1 | 69583 | 6 | 1.203 | 57841.2 |
1235 | 2022-11-22 10:50:11 | strains | 3 | 134027 | 659 | 5.906 | 22693.4 |
1234 | 2022-11-20 20:42:10 | strains | 3 | 134027 | 659 | 5.920 | 22639.7 |
1233 | 2022-11-18 14:36:40 | strains | 3 | 134027 | 659 | 9.766 | 13723.8 |
1232 | 2022-11-18 10:06:27 | strains | 3 | 134027 | 659 | 6.406 | 20922.1 |
1231 | 2022-11-17 21:40:26 | strains | 1 | 69583 | 6 | 1.106 | 62914.1 |
1230 | 2022-11-14 05:51:07 | strains | 1 | 69583 | 6 | 1.046 | 66522.9 |
1229 | 2022-11-08 15:14:01 | strains | 3 | 134027 | 659 | 7.640 | 17542.8 |
1228 | 2022-11-05 04:50:28 | strains | 3 | 134027 | 659 | 6.283 | 21331.7 |
1227 | 2022-10-18 05:40:19 | strains | 1 | 69583 | 6 | 1.080 | 64428.7 |
1226 | 2022-10-03 01:45:44 | strains | 3 | 134027 | 659 | 5.906 | 22693.4 |
1225 | 2022-10-02 10:57:51 | strains | 1 | 69583 | 6 | 1.063 | 65459.1 |
1224 | 2022-09-29 10:02:40 | strains | 1 | 69583 | 6 | 1.063 | 65459.1 |
1223 | 2022-08-19 03:34:50 | strains | 1 | 69583 | 6 | 1.080 | 64428.7 |
1222 | 2022-08-16 01:23:43 | strains | 1 | 69583 | 6 | 1.110 | 62687.4 |
1221 | 2022-07-26 14:19:16 | strains | 1 | 69583 | 6 | 1.076 | 64668.2 |
1220 | 2022-06-29 08:09:45 | strains | 3 | 134027 | 659 | 6.660 | 20124.2 |
1219 | 2022-06-28 13:09:23 | strains | 1 | 69583 | 6 | 1.063 | 65459.1 |
1218 | 2022-06-28 09:18:02 | strains | 3 | 134027 | 659 | 6.610 | 20276.4 |
1217 | 2022-06-27 08:24:17 | strains | 3 | 134027 | 659 | 5.843 | 22938.0 |
1216 | 2022-06-26 16:08:24 | strains | 3 | 134027 | 659 | 5.923 | 22628.2 |
1215 | 2022-06-25 17:09:52 | strains | 1 | 69583 | 6 | 1.206 | 57697.3 |
1214 | 2022-06-25 06:33:28 | strains | 3 | 134027 | 659 | 6.750 | 19855.9 |