History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smelt"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1415 | 2024-04-26 14:32:44 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1414 | 2024-04-03 06:35:57 | smelt | 2 | 53800 | 100 | 5.533 | 9723.5 |
1413 | 2024-04-03 06:35:55 | smelt | 1 | 28756 | 7 | 1.123 | 25606.4 |
1412 | 2024-04-03 06:35:24 | smelt | 3 | 83667 | 1059 | 8.640 | 9683.7 |
1411 | 2024-04-03 06:34:46 | smelt | 3 | 83667 | 1059 | 13.486 | 6204.0 |
1410 | 2024-04-03 06:34:46 | smelt | 2 | 53800 | 100 | 5.766 | 9330.6 |
1409 | 2024-04-03 06:14:51 | smelt | 1 | 28756 | 7 | 0.580 | 49579.3 |
1408 | 2024-03-31 03:39:40 | smelt | 1 | 28756 | 7 | 1.076 | 26724.9 |
1407 | 2024-03-04 00:32:20 | smelt | 1 | 28756 | 7 | 0.516 | 55728.7 |
1406 | 2024-02-29 23:41:44 | smelt | 1 | 28756 | 7 | 0.516 | 55728.7 |
1405 | 2024-02-25 19:16:39 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1404 | 2024-02-09 12:37:59 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1403 | 2024-02-02 21:22:23 | smelt | 1 | 28756 | 7 | 0.530 | 54256.6 |
1402 | 2024-01-28 22:21:51 | smelt | 1 | 28756 | 7 | 0.470 | 61183.0 |
1401 | 2024-01-28 22:03:28 | smelt | 2 | 53800 | 100 | 1.406 | 38264.6 |
1400 | 2024-01-26 16:39:33 | smelt | 1 | 28756 | 7 | 0.483 | 59536.2 |
1399 | 2024-01-13 21:07:20 | smelt | 3 | 83667 | 1059 | 3.940 | 21235.3 |
1398 | 2024-01-07 19:57:52 | smelt | 3 | 83667 | 1059 | 3.983 | 21006.0 |
1397 | 2024-01-06 01:06:11 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1396 | 2023-11-29 14:44:28 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1395 | 2023-11-28 14:43:23 | smelt | 2 | 53800 | 100 | 2.330 | 23090.1 |
1394 | 2023-11-28 14:43:14 | smelt | 3 | 83667 | 1059 | 3.296 | 25384.4 |
1393 | 2023-11-22 03:52:33 | smelt | 3 | 83667 | 1059 | 3.606 | 23202.2 |
1392 | 2023-11-22 03:52:19 | smelt | 2 | 53800 | 100 | 1.390 | 38705.0 |
1391 | 2023-11-18 18:52:39 | smelt | 2 | 53800 | 100 | 1.376 | 39098.8 |
1390 | 2023-11-18 18:04:03 | smelt | 1 | 28756 | 7 | 0.530 | 54256.6 |
1389 | 2023-11-15 23:04:25 | smelt | 1 | 28756 | 7 | 0.500 | 57512.0 |
1388 | 2023-11-15 14:45:15 | smelt | 2 | 53800 | 100 | 1.656 | 32487.9 |
1387 | 2023-11-06 09:23:55 | smelt | 2 | 53800 | 100 | 1.610 | 33416.1 |
1386 | 2023-10-30 22:29:53 | smelt | 3 | 83667 | 1059 | 4.610 | 18149.0 |
1385 | 2023-10-30 06:03:10 | smelt | 3 | 83667 | 1059 | 3.610 | 23176.5 |
1384 | 2023-10-30 06:03:08 | smelt | 2 | 53800 | 100 | 1.436 | 37465.2 |
1383 | 2023-10-27 05:42:53 | smelt | 1 | 28756 | 7 | 0.483 | 59536.2 |
1382 | 2023-10-22 02:17:02 | smelt | 1 | 28756 | 7 | 0.890 | 32310.1 |
1381 | 2023-10-21 06:11:32 | smelt | 1 | 28756 | 7 | 0.576 | 49923.6 |
1380 | 2023-10-11 04:21:24 | smelt | 1 | 28756 | 7 | 0.516 | 55728.7 |
1379 | 2023-10-08 05:32:24 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1378 | 2023-09-26 08:19:51 | smelt | 1 | 28756 | 7 | 0.486 | 59168.7 |
1377 | 2023-09-25 16:14:20 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1376 | 2023-09-14 10:43:59 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1375 | 2023-09-14 10:14:02 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1374 | 2023-08-24 06:33:46 | smelt | 1 | 28756 | 7 | 0.483 | 59536.2 |
1373 | 2023-08-11 16:44:31 | smelt | 2 | 53800 | 100 | 1.530 | 35163.4 |
1372 | 2023-07-02 08:28:21 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1371 | 2023-04-23 06:19:43 | smelt | 2 | 53800 | 100 | 1.343 | 40059.6 |
1370 | 2023-04-22 05:38:19 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1369 | 2023-04-11 02:04:20 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1368 | 2023-02-02 08:33:57 | smelt | 1 | 28756 | 7 | 0.516 | 55728.7 |
1367 | 2023-01-29 20:48:36 | smelt | 2 | 53800 | 100 | 1.390 | 38705.0 |
1366 | 2022-12-15 11:27:52 | smelt | 1 | 28756 | 7 | 0.483 | 59536.2 |
1365 | 2022-11-30 13:06:06 | smelt | 1 | 28756 | 7 | 0.423 | 67981.1 |
1364 | 2022-11-11 11:55:58 | smelt | 2 | 53800 | 100 | 1.686 | 31909.8 |
1363 | 2022-08-07 19:21:44 | smelt | 1 | 28756 | 7 | 0.500 | 57512.0 |
1362 | 2022-08-05 14:09:23 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1361 | 2022-07-29 06:05:54 | smelt | 1 | 28756 | 7 | 0.440 | 65354.5 |
1360 | 2022-07-24 20:39:34 | smelt | 1 | 28756 | 7 | 0.450 | 63902.2 |
1359 | 2022-07-22 13:06:48 | smelt | 1 | 28756 | 7 | 0.470 | 61183.0 |
1358 | 2022-07-17 22:32:07 | smelt | 1 | 28756 | 7 | 0.470 | 61183.0 |
1357 | 2022-07-03 02:16:33 | smelt | 1 | 28756 | 7 | 0.530 | 54256.6 |
1356 | 2022-06-17 03:04:21 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1355 | 2022-06-15 17:59:39 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1354 | 2022-05-30 22:49:40 | smelt | 2 | 53800 | 100 | 1.343 | 40059.6 |
1353 | 2022-05-28 19:14:09 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1352 | 2022-03-31 17:36:31 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1351 | 2022-03-17 14:46:19 | smelt | 1 | 28756 | 7 | 0.626 | 45936.1 |
1350 | 2022-01-23 14:25:26 | smelt | 2 | 53800 | 100 | 1.530 | 35163.4 |
1349 | 2021-12-27 19:56:24 | smelt | 1 | 28756 | 7 | 0.546 | 52666.7 |
1348 | 2021-12-04 06:04:15 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1347 | 2021-11-30 19:57:50 | smelt | 1 | 28756 | 7 | 0.563 | 51076.4 |
1346 | 2021-11-03 15:59:22 | smelt | 1 | 28756 | 7 | 0.483 | 59536.2 |
1345 | 2021-10-23 10:36:35 | smelt | 2 | 53800 | 100 | 1.343 | 40059.6 |
1344 | 2021-09-23 03:33:38 | smelt | 1 | 28756 | 7 | 0.483 | 59536.2 |
1343 | 2021-09-01 09:57:45 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1342 | 2021-08-11 03:26:28 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1341 | 2021-06-26 14:11:04 | smelt | 2 | 53800 | 100 | 1.516 | 35488.1 |
1340 | 2021-05-28 23:57:59 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1339 | 2021-04-22 14:15:13 | smelt | 1 | 28756 | 7 | 0.563 | 51076.4 |
1338 | 2021-04-07 22:56:57 | smelt | 2 | 53800 | 100 | 2.936 | 18324.3 |
1337 | 2021-04-03 10:01:27 | smelt | 3 | 83667 | 1059 | 5.076 | 16482.9 |
1336 | 2021-02-19 00:15:19 | smelt | 3 | 83667 | 1059 | 3.390 | 24680.5 |
1335 | 2021-02-16 08:53:55 | smelt | 1 | 28756 | 7 | 0.500 | 57512.0 |
1334 | 2021-01-22 23:39:58 | smelt | 2 | 53800 | 100 | 1.406 | 38264.6 |
1333 | 2021-01-16 16:05:26 | smelt | 1 | 28756 | 7 | 0.500 | 57512.0 |
1332 | 2021-01-14 00:00:09 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1331 | 2021-01-03 14:06:44 | smelt | 3 | 83667 | 1059 | 3.283 | 25484.9 |
1330 | 2020-12-19 10:56:58 | smelt | 3 | 83667 | 1059 | 3.500 | 23904.9 |
1329 | 2020-11-21 20:38:57 | smelt | 1 | 28756 | 7 | 0.466 | 61708.2 |
1328 | 2020-11-03 02:39:26 | smelt | 2 | 53800 | 100 | 1.716 | 31352.0 |
1327 | 2020-11-02 06:06:20 | smelt | 2 | 53800 | 100 | 1.436 | 37465.2 |
1326 | 2020-11-02 00:55:36 | smelt | 3 | 83667 | 1059 | 3.670 | 22797.5 |
1325 | 2020-10-29 14:42:17 | smelt | 1 | 28756 | 7 | 0.466 | 61708.2 |
1324 | 2020-10-27 10:11:05 | smelt | 3 | 83667 | 1059 | 4.313 | 19398.8 |
1323 | 2020-10-24 16:25:00 | smelt | 1 | 28756 | 7 | 0.500 | 57512.0 |
1322 | 2020-10-14 08:32:38 | smelt | 3 | 83667 | 1059 | 3.280 | 25508.2 |
1321 | 2020-10-10 09:39:39 | smelt | 1 | 28756 | 7 | 0.453 | 63479.0 |
1320 | 2020-10-06 14:17:35 | smelt | 3 | 83667 | 1059 | 3.296 | 25384.4 |
1319 | 2020-10-04 04:49:04 | smelt | 3 | 83667 | 1059 | 3.893 | 21491.7 |
1318 | 2020-10-04 00:29:25 | smelt | 1 | 28756 | 7 | 0.436 | 65954.1 |
1317 | 2020-09-26 03:34:06 | smelt | 1 | 28756 | 7 | 0.483 | 59536.2 |
1316 | 2020-07-30 15:15:03 | smelt | 3 | 83667 | 1059 | 7.640 | 10951.2 |