History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1366 | 2025-05-31 17:53:16 | coal | 2 | 29872 | 331 | 2.796 | 10683.8 |
1365 | 2025-05-31 02:15:11 | coal | 1 | 13983 | 17 | 1.250 | 11186.4 |
1364 | 2025-05-29 07:22:25 | coal | 1 | 13983 | 17 | 0.966 | 14475.2 |
1363 | 2025-05-29 02:03:13 | coal | 2 | 29872 | 331 | 2.373 | 12588.3 |
1362 | 2025-05-28 06:33:11 | coal | 1 | 13983 | 17 | 0.263 | 53167.3 |
1361 | 2025-05-28 03:10:13 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1360 | 2025-05-28 02:29:37 | coal | 2 | 29872 | 331 | 2.280 | 13101.8 |
1359 | 2025-05-27 21:43:00 | coal | 1 | 13983 | 17 | 0.266 | 52567.7 |
1358 | 2025-05-24 10:57:53 | coal | 1 | 13983 | 17 | 1.796 | 7785.6 |
1357 | 2025-05-23 16:55:25 | coal | 1 | 13983 | 17 | 1.623 | 8615.5 |
1356 | 2025-05-17 08:12:51 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1355 | 2025-05-16 03:42:26 | coal | 1 | 13983 | 17 | 1.376 | 10162.1 |
1354 | 2025-05-12 10:43:50 | coal | 1 | 13983 | 17 | 0.610 | 22923.0 |
1353 | 2025-05-12 10:00:44 | coal | 2 | 29872 | 331 | 3.360 | 8890.5 |
1352 | 2025-05-10 20:33:47 | coal | 2 | 29872 | 331 | 6.110 | 4889.0 |
1351 | 2025-05-09 11:01:36 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1350 | 2025-05-08 14:44:58 | coal | 1 | 13983 | 17 | 1.500 | 9322.0 |
1349 | 2025-05-05 11:22:30 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1348 | 2025-05-05 02:48:56 | coal | 1 | 13983 | 17 | 0.220 | 63559.1 |
1347 | 2025-05-03 06:18:07 | coal | 1 | 13983 | 17 | 0.280 | 49939.3 |
1346 | 2025-05-01 15:48:21 | coal | 1 | 13983 | 17 | 1.360 | 10281.6 |
1345 | 2025-05-01 04:50:18 | coal | 1 | 13983 | 17 | 0.813 | 17199.3 |
1344 | 2025-04-27 08:38:35 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1343 | 2025-04-27 07:37:16 | coal | 1 | 13983 | 17 | 0.266 | 52567.7 |
1342 | 2025-04-26 20:46:38 | coal | 1 | 13983 | 17 | 0.686 | 20383.4 |
1341 | 2025-04-25 11:37:27 | coal | 2 | 29872 | 331 | 0.796 | 37527.6 |
1340 | 2025-04-22 10:54:07 | coal | 1 | 13983 | 17 | 0.220 | 63559.1 |
1339 | 2025-04-17 06:59:51 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1338 | 2025-04-16 02:46:04 | coal | 2 | 29872 | 331 | 3.330 | 8970.6 |
1337 | 2025-04-15 03:03:41 | coal | 1 | 13983 | 17 | 1.186 | 11790.1 |
1336 | 2025-04-13 01:51:56 | coal | 1 | 13983 | 17 | 0.263 | 53167.3 |
1335 | 2025-04-11 09:07:25 | coal | 1 | 13983 | 17 | 0.733 | 19076.4 |
1334 | 2025-04-08 09:09:16 | coal | 1 | 13983 | 17 | 0.266 | 52567.7 |
1333 | 2025-04-07 20:30:58 | coal | 1 | 13983 | 17 | 0.216 | 64736.1 |
1332 | 2025-04-06 14:26:46 | coal | 1 | 13983 | 17 | 0.390 | 35853.8 |
1331 | 2025-04-03 21:42:37 | coal | 2 | 29872 | 331 | 4.890 | 6108.8 |
1330 | 2025-04-03 01:02:43 | coal | 2 | 29872 | 331 | 2.173 | 13746.9 |
1329 | 2025-03-31 05:15:45 | coal | 1 | 13983 | 17 | 1.593 | 8777.8 |
1328 | 2025-03-27 09:06:10 | coal | 1 | 13983 | 17 | 0.453 | 30867.5 |
1327 | 2025-03-27 04:06:01 | coal | 1 | 13983 | 17 | 1.610 | 8685.1 |
1326 | 2025-03-17 12:03:58 | coal | 2 | 29872 | 331 | 4.233 | 7056.9 |
1325 | 2025-03-17 06:05:49 | coal | 2 | 29872 | 331 | 4.280 | 6979.4 |
1324 | 2025-03-14 21:58:54 | coal | 1 | 13983 | 17 | 0.233 | 60012.9 |
1323 | 2025-03-13 19:31:00 | coal | 1 | 13983 | 17 | 1.606 | 8706.7 |
1322 | 2025-03-12 03:05:33 | coal | 1 | 13983 | 17 | 2.360 | 5925.0 |
1321 | 2025-03-10 23:39:34 | coal | 1 | 13983 | 17 | 0.576 | 24276.0 |
1320 | 2025-03-06 22:55:47 | coal | 1 | 13983 | 17 | 1.406 | 9945.2 |
1319 | 2025-03-06 08:08:26 | coal | 2 | 29872 | 331 | 4.530 | 6594.3 |
1318 | 2025-03-06 03:37:40 | coal | 2 | 29872 | 331 | 2.406 | 12415.6 |
1317 | 2025-03-05 19:32:00 | coal | 1 | 13983 | 17 | 1.363 | 10259.0 |
1316 | 2025-02-27 23:32:08 | coal | 2 | 29872 | 331 | 3.796 | 7869.3 |
1315 | 2025-02-27 22:19:44 | coal | 2 | 29872 | 331 | 2.093 | 14272.3 |
1314 | 2025-02-27 21:24:34 | coal | 1 | 13983 | 17 | 0.906 | 15433.8 |
1313 | 2025-02-24 15:35:05 | coal | 1 | 13983 | 17 | 1.576 | 8872.5 |
1312 | 2025-02-23 03:00:38 | coal | 1 | 13983 | 17 | 1.936 | 7222.6 |
1311 | 2025-02-15 23:24:40 | coal | 1 | 13983 | 17 | 0.640 | 21848.4 |
1310 | 2025-02-04 15:14:30 | coal | 1 | 13983 | 17 | 0.263 | 53167.3 |
1309 | 2025-01-28 23:24:20 | coal | 2 | 29872 | 331 | 6.423 | 4650.8 |
1308 | 2025-01-28 19:35:15 | coal | 2 | 29872 | 331 | 4.500 | 6638.2 |
1307 | 2025-01-28 19:03:17 | coal | 1 | 13983 | 17 | 0.283 | 49409.9 |
1306 | 2025-01-25 13:46:00 | coal | 1 | 13983 | 17 | 0.856 | 16335.3 |
1305 | 2025-01-24 02:04:06 | coal | 1 | 13983 | 17 | 1.423 | 9826.4 |
1304 | 2025-01-15 03:26:22 | coal | 1 | 13983 | 17 | 0.670 | 20870.1 |
1303 | 2025-01-13 01:47:07 | coal | 1 | 13983 | 17 | 1.093 | 12793.2 |
1302 | 2025-01-06 08:46:58 | coal | 1 | 13983 | 17 | 0.923 | 15149.5 |
1301 | 2025-01-05 13:47:46 | coal | 2 | 29872 | 331 | 3.453 | 8651.0 |
1300 | 2025-01-05 13:44:48 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1299 | 2024-12-29 14:52:02 | coal | 2 | 29872 | 331 | 5.826 | 5127.4 |
1298 | 2024-12-29 14:12:03 | coal | 2 | 29872 | 331 | 4.280 | 6979.4 |
1297 | 2024-12-29 13:48:13 | coal | 1 | 13983 | 17 | 0.216 | 64736.1 |
1296 | 2024-12-26 12:01:44 | coal | 1 | 13983 | 17 | 1.203 | 11623.4 |
1295 | 2024-12-25 00:59:28 | coal | 1 | 13983 | 17 | 0.953 | 14672.6 |
1294 | 2024-12-07 06:36:14 | coal | 2 | 29872 | 331 | 4.470 | 6682.8 |
1293 | 2024-12-06 13:28:02 | coal | 2 | 29872 | 331 | 6.720 | 4445.2 |
1292 | 2024-12-06 12:23:53 | coal | 1 | 13983 | 17 | 1.296 | 10789.4 |
1291 | 2024-11-29 09:26:11 | coal | 2 | 29872 | 331 | 4.843 | 6168.1 |
1290 | 2024-11-29 08:38:13 | coal | 1 | 13983 | 17 | 0.266 | 52567.7 |
1289 | 2024-11-26 11:11:29 | coal | 1 | 13983 | 17 | 0.216 | 64736.1 |
1288 | 2024-11-25 22:09:53 | coal | 1 | 13983 | 17 | 0.563 | 24836.6 |
1287 | 2024-11-24 23:20:12 | coal | 1 | 13983 | 17 | 1.140 | 12265.8 |
1286 | 2024-11-06 09:05:45 | coal | 2 | 29872 | 331 | 2.643 | 11302.3 |
1285 | 2024-11-06 08:03:39 | coal | 1 | 13983 | 17 | 0.220 | 63559.1 |
1284 | 2024-10-30 07:26:21 | coal | 2 | 29872 | 331 | 4.390 | 6804.6 |
1283 | 2024-10-30 05:36:30 | coal | 2 | 29872 | 331 | 4.203 | 7107.3 |
1282 | 2024-10-30 04:47:54 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1281 | 2024-10-27 09:25:33 | coal | 1 | 13983 | 17 | 0.986 | 14181.5 |
1280 | 2024-10-25 22:14:17 | coal | 1 | 13983 | 17 | 2.000 | 6991.5 |
1279 | 2024-10-23 18:18:15 | coal | 1 | 13983 | 17 | 0.736 | 18998.6 |
1278 | 2024-10-07 19:53:15 | coal | 2 | 29872 | 331 | 5.076 | 5884.9 |
1277 | 2024-10-07 09:51:48 | coal | 2 | 29872 | 331 | 10.360 | 2883.4 |
1276 | 2024-10-07 08:35:02 | coal | 1 | 13983 | 17 | 0.436 | 32071.1 |
1275 | 2024-09-29 19:31:30 | coal | 1 | 13983 | 17 | 1.920 | 7282.8 |
1274 | 2024-09-27 09:49:19 | coal | 2 | 29872 | 331 | 2.470 | 12093.9 |
1273 | 2024-09-27 07:50:08 | coal | 2 | 29872 | 331 | 7.140 | 4183.8 |
1272 | 2024-09-27 07:48:31 | coal | 1 | 13983 | 17 | 1.796 | 7785.6 |
1271 | 2024-09-25 17:17:06 | coal | 1 | 13983 | 17 | 1.186 | 11790.1 |
1270 | 2024-09-09 16:57:54 | coal | 1 | 13983 | 17 | 2.623 | 5330.9 |
1269 | 2024-09-07 06:25:15 | coal | 1 | 13983 | 17 | 1.766 | 7917.9 |
1268 | 2024-08-30 19:10:28 | coal | 1 | 13983 | 17 | 0.250 | 55932.0 |
1267 | 2024-08-30 00:37:38 | coal | 1 | 13983 | 17 | 3.080 | 4539.9 |