History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sour"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1362 | 2024-04-23 14:17:54 | sour | 1 | 13983 | 20 | 0.436 | 32071.1 |
1361 | 2024-04-17 14:03:09 | sour | 1 | 13983 | 20 | 0.280 | 49939.3 |
1360 | 2024-04-17 14:02:22 | sour | 1 | 13983 | 20 | 0.436 | 32071.1 |
1359 | 2024-04-04 19:41:41 | sour | 2 | 29872 | 257 | 1.610 | 18554.0 |
1358 | 2024-04-04 19:27:12 | sour | 1 | 13983 | 20 | 0.563 | 24836.6 |
1357 | 2024-03-31 00:41:59 | sour | 2 | 29872 | 257 | 3.093 | 9657.9 |
1356 | 2024-03-31 00:01:17 | sour | 1 | 13983 | 20 | 0.283 | 49409.9 |
1355 | 2024-03-30 00:25:23 | sour | 1 | 13983 | 20 | 0.300 | 46610.0 |
1354 | 2024-03-28 05:59:31 | sour | 1 | 13983 | 20 | 0.266 | 52567.7 |
1353 | 2024-03-26 23:53:43 | sour | 1 | 13983 | 20 | 0.266 | 52567.7 |
1352 | 2024-03-07 08:30:05 | sour | 2 | 29872 | 257 | 1.580 | 18906.3 |
1351 | 2024-03-05 18:57:58 | sour | 2 | 29872 | 257 | 3.936 | 7589.4 |
1350 | 2024-03-05 17:26:33 | sour | 1 | 13983 | 20 | 0.563 | 24836.6 |
1349 | 2024-02-25 21:12:39 | sour | 2 | 29872 | 257 | 4.750 | 6288.8 |
1348 | 2024-02-25 21:01:15 | sour | 1 | 13983 | 20 | 0.563 | 24836.6 |
1347 | 2024-02-06 18:06:36 | sour | 1 | 13983 | 20 | 0.266 | 52567.7 |
1346 | 2024-02-02 22:51:54 | sour | 1 | 13983 | 20 | 0.266 | 52567.7 |
1345 | 2024-01-31 16:34:28 | sour | 2 | 29872 | 257 | 0.890 | 33564.0 |
1344 | 2024-01-31 11:07:49 | sour | 2 | 29872 | 257 | 0.766 | 38997.4 |
1343 | 2024-01-26 16:40:13 | sour | 1 | 13983 | 20 | 0.266 | 52567.7 |
1342 | 2024-01-23 14:53:26 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1341 | 2024-01-11 05:08:21 | sour | 2 | 29872 | 257 | 0.860 | 34734.9 |
1340 | 2023-12-31 07:42:39 | sour | 2 | 29872 | 257 | 0.876 | 34100.5 |
1339 | 2023-12-19 00:17:55 | sour | 2 | 29872 | 257 | 0.953 | 31345.2 |
1338 | 2023-12-06 01:58:09 | sour | 2 | 29872 | 257 | 0.923 | 32364.0 |
1337 | 2023-11-19 11:45:43 | sour | 1 | 13983 | 20 | 0.263 | 53167.3 |
1336 | 2023-11-15 12:03:34 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1335 | 2023-11-14 06:41:36 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1334 | 2023-11-12 03:54:30 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1333 | 2023-10-28 13:44:56 | sour | 2 | 29872 | 257 | 0.813 | 36742.9 |
1332 | 2023-10-28 03:33:34 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1331 | 2023-10-21 12:24:50 | sour | 2 | 29872 | 257 | 0.780 | 38297.4 |
1330 | 2023-10-21 03:38:10 | sour | 2 | 29872 | 257 | 0.796 | 37527.6 |
1329 | 2023-10-19 20:53:04 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1328 | 2023-10-16 23:12:40 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1327 | 2023-10-16 01:41:53 | sour | 1 | 13983 | 20 | 0.266 | 52567.7 |
1326 | 2023-10-13 10:28:58 | sour | 1 | 13983 | 20 | 0.216 | 64736.1 |
1325 | 2023-10-04 14:05:54 | sour | 1 | 13983 | 20 | 0.236 | 59250.0 |
1324 | 2023-10-01 15:40:49 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1323 | 2023-09-23 21:47:42 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1322 | 2023-09-12 14:20:05 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1321 | 2023-09-05 13:21:43 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1320 | 2023-08-06 11:18:49 | sour | 2 | 29872 | 257 | 0.766 | 38997.4 |
1319 | 2023-08-01 03:54:24 | sour | 2 | 29872 | 257 | 0.783 | 38150.7 |
1318 | 2023-06-09 20:09:09 | sour | 1 | 13983 | 20 | 0.216 | 64736.1 |
1317 | 2023-06-04 20:04:13 | sour | 1 | 13983 | 20 | 0.216 | 64736.1 |
1316 | 2023-04-17 05:03:52 | sour | 2 | 29872 | 257 | 0.750 | 39829.3 |
1315 | 2023-04-16 22:24:21 | sour | 2 | 29872 | 257 | 0.876 | 34100.5 |
1314 | 2023-03-29 07:30:20 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1313 | 2023-02-21 10:13:00 | sour | 2 | 29872 | 257 | 0.843 | 35435.3 |
1312 | 2023-02-19 23:45:09 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1311 | 2023-01-23 19:40:26 | sour | 2 | 29872 | 257 | 0.860 | 34734.9 |
1310 | 2023-01-12 08:40:06 | sour | 1 | 13983 | 20 | 0.266 | 52567.7 |
1309 | 2023-01-01 15:24:34 | sour | 2 | 29872 | 257 | 0.890 | 33564.0 |
1308 | 2022-12-27 23:48:38 | sour | 2 | 29872 | 257 | 0.843 | 35435.3 |
1307 | 2022-12-24 17:14:26 | sour | 2 | 29872 | 257 | 0.890 | 33564.0 |
1306 | 2022-11-03 08:43:43 | sour | 2 | 29872 | 257 | 0.796 | 37527.6 |
1305 | 2022-10-26 04:38:15 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1304 | 2022-10-23 04:15:29 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1303 | 2022-08-14 07:26:21 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1302 | 2022-08-07 06:27:27 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1301 | 2022-08-05 23:52:50 | sour | 1 | 13983 | 20 | 0.216 | 64736.1 |
1300 | 2022-07-29 03:31:51 | sour | 1 | 13983 | 20 | 0.216 | 64736.1 |
1299 | 2022-07-02 23:53:30 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1298 | 2022-06-21 20:17:10 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1297 | 2022-06-16 13:21:09 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1296 | 2022-06-16 02:25:30 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1295 | 2022-06-11 22:50:12 | sour | 2 | 29872 | 257 | 0.783 | 38150.7 |
1294 | 2022-06-07 10:44:08 | sour | 2 | 29872 | 257 | 0.906 | 32971.3 |
1293 | 2022-06-06 06:26:25 | sour | 2 | 29872 | 257 | 0.860 | 34734.9 |
1292 | 2022-06-05 10:17:36 | sour | 2 | 29872 | 257 | 0.953 | 31345.2 |
1291 | 2022-06-05 10:01:45 | sour | 2 | 29872 | 257 | 0.860 | 34734.9 |
1290 | 2022-06-04 07:06:33 | sour | 2 | 29872 | 257 | 0.953 | 31345.2 |
1289 | 2022-06-03 03:30:35 | sour | 2 | 29872 | 257 | 0.780 | 38297.4 |
1288 | 2022-06-02 13:26:00 | sour | 2 | 29872 | 257 | 0.936 | 31914.5 |
1287 | 2022-05-30 20:03:09 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1286 | 2022-05-18 15:02:07 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1285 | 2022-05-18 00:10:24 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1284 | 2022-05-17 08:57:04 | sour | 1 | 13983 | 20 | 0.330 | 42372.7 |
1283 | 2022-05-16 11:34:41 | sour | 1 | 13983 | 20 | 0.250 | 55932.0 |
1282 | 2022-05-16 09:34:58 | sour | 1 | 13983 | 20 | 0.263 | 53167.3 |
1281 | 2022-05-15 22:55:57 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1280 | 2022-05-15 03:28:26 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1279 | 2022-05-14 03:59:57 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1278 | 2022-05-13 15:43:41 | sour | 1 | 13983 | 20 | 0.486 | 28771.6 |
1277 | 2022-05-13 06:22:44 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1276 | 2022-05-12 12:59:43 | sour | 1 | 13983 | 20 | 0.233 | 60012.9 |
1275 | 2022-05-11 13:33:17 | sour | 1 | 13983 | 20 | 0.373 | 37487.9 |
1274 | 2022-05-11 00:03:28 | sour | 1 | 13983 | 20 | 0.403 | 34697.3 |
1273 | 2022-05-10 15:53:29 | sour | 1 | 13983 | 20 | 0.326 | 42892.6 |
1272 | 2022-05-10 04:46:37 | sour | 1 | 13983 | 20 | 0.236 | 59250.0 |
1271 | 2022-05-09 12:07:00 | sour | 1 | 13983 | 20 | 0.390 | 35853.8 |
1270 | 2022-05-08 07:43:32 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1269 | 2022-05-07 16:25:43 | sour | 1 | 13983 | 20 | 0.436 | 32071.1 |
1268 | 2022-05-02 21:04:03 | sour | 2 | 29872 | 257 | 0.890 | 33564.0 |
1267 | 2022-05-01 18:32:23 | sour | 2 | 29872 | 257 | 0.873 | 34217.6 |
1266 | 2022-05-01 11:55:46 | sour | 1 | 13983 | 20 | 0.283 | 49409.9 |
1265 | 2022-05-01 03:48:49 | sour | 2 | 29872 | 257 | 0.763 | 39150.7 |
1264 | 2022-04-30 19:23:11 | sour | 1 | 13983 | 20 | 0.220 | 63559.1 |
1263 | 2022-04-30 13:47:48 | sour | 2 | 29872 | 257 | 0.766 | 38997.4 |