History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fires"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1498 | 2024-04-17 10:30:58 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1497 | 2024-04-03 03:57:49 | fires | 1 | 28756 | 27 | 1.126 | 25538.2 |
1496 | 2024-03-31 07:25:21 | fires | 1 | 28756 | 27 | 0.500 | 57512.0 |
1495 | 2024-03-27 05:41:35 | fires | 1 | 28756 | 27 | 1.013 | 28387.0 |
1494 | 2024-03-08 20:01:26 | fires | 2 | 53800 | 412 | 1.516 | 35488.1 |
1493 | 2024-03-04 01:46:06 | fires | 2 | 53800 | 412 | 1.796 | 29955.5 |
1492 | 2024-03-04 01:45:51 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1491 | 2024-02-25 22:49:38 | fires | 2 | 53800 | 412 | 3.610 | 14903.0 |
1490 | 2024-02-25 22:44:15 | fires | 1 | 28756 | 27 | 0.516 | 55728.7 |
1489 | 2024-02-02 23:16:19 | fires | 1 | 28756 | 27 | 0.513 | 56054.6 |
1488 | 2024-01-26 19:25:37 | fires | 1 | 28756 | 27 | 0.486 | 59168.7 |
1487 | 2024-01-20 03:43:41 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1486 | 2024-01-20 01:15:59 | fires | 1 | 28756 | 27 | 0.516 | 55728.7 |
1485 | 2024-01-19 20:24:38 | fires | 1 | 28756 | 27 | 0.560 | 51350.0 |
1484 | 2024-01-13 16:09:39 | fires | 1 | 28756 | 27 | 0.440 | 65354.5 |
1483 | 2023-12-18 19:38:13 | fires | 1 | 28756 | 27 | 0.436 | 65954.1 |
1482 | 2023-12-13 18:16:01 | fires | 1 | 28756 | 27 | 0.436 | 65954.1 |
1481 | 2023-12-10 20:48:39 | fires | 1 | 28756 | 27 | 0.486 | 59168.7 |
1480 | 2023-12-06 21:27:44 | fires | 2 | 53800 | 412 | 1.640 | 32804.9 |
1479 | 2023-11-29 12:35:03 | fires | 2 | 53800 | 412 | 1.376 | 39098.8 |
1478 | 2023-11-25 06:53:32 | fires | 2 | 53800 | 412 | 1.580 | 34050.6 |
1477 | 2023-11-23 21:49:53 | fires | 1 | 28756 | 27 | 0.486 | 59168.7 |
1476 | 2023-11-16 11:33:04 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1475 | 2023-11-15 08:48:00 | fires | 1 | 28756 | 27 | 0.436 | 65954.1 |
1474 | 2023-11-15 06:15:09 | fires | 2 | 53800 | 412 | 1.813 | 29674.6 |
1473 | 2023-11-11 08:57:35 | fires | 2 | 53800 | 412 | 1.390 | 38705.0 |
1472 | 2023-11-10 10:12:09 | fires | 1 | 28756 | 27 | 0.970 | 29645.4 |
1471 | 2023-11-07 11:12:48 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1470 | 2023-11-02 07:15:53 | fires | 1 | 28756 | 27 | 1.546 | 18600.3 |
1469 | 2023-10-28 04:38:06 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1468 | 2023-10-26 02:07:50 | fires | 1 | 28756 | 27 | 0.500 | 57512.0 |
1467 | 2023-10-23 23:46:12 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1466 | 2023-10-21 10:27:02 | fires | 1 | 28756 | 27 | 0.470 | 61183.0 |
1465 | 2023-10-18 12:16:20 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1464 | 2023-10-12 01:54:42 | fires | 1 | 28756 | 27 | 0.453 | 63479.0 |
1463 | 2023-10-05 01:26:08 | fires | 1 | 28756 | 27 | 0.436 | 65954.1 |
1462 | 2023-09-24 12:06:23 | fires | 1 | 28756 | 27 | 0.470 | 61183.0 |
1461 | 2023-09-20 15:09:45 | fires | 1 | 28756 | 27 | 0.470 | 61183.0 |
1460 | 2023-09-17 11:46:05 | fires | 1 | 28756 | 27 | 0.450 | 63902.2 |
1459 | 2023-09-04 06:01:06 | fires | 1 | 28756 | 27 | 0.453 | 63479.0 |
1458 | 2023-09-03 22:42:19 | fires | 1 | 28756 | 27 | 0.483 | 59536.2 |
1457 | 2023-08-31 17:47:28 | fires | 1 | 28756 | 27 | 0.513 | 56054.6 |
1456 | 2023-08-25 02:27:26 | fires | 2 | 53800 | 412 | 1.423 | 37807.4 |
1455 | 2023-08-20 07:53:19 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1454 | 2023-08-10 09:46:54 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1453 | 2023-08-09 10:38:21 | fires | 2 | 53800 | 412 | 1.546 | 34799.5 |
1452 | 2023-05-31 12:14:32 | fires | 1 | 28756 | 27 | 0.486 | 59168.7 |
1451 | 2023-05-28 06:27:27 | fires | 1 | 28756 | 27 | 0.423 | 67981.1 |
1450 | 2023-05-13 21:47:57 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1449 | 2023-05-10 14:17:47 | fires | 2 | 53800 | 412 | 1.356 | 39675.5 |
1448 | 2023-05-06 02:21:28 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1447 | 2023-04-09 03:58:05 | fires | 2 | 53800 | 412 | 1.656 | 32487.9 |
1446 | 2023-03-21 23:56:20 | fires | 2 | 53800 | 412 | 1.330 | 40451.1 |
1445 | 2023-02-22 07:33:31 | fires | 1 | 28756 | 27 | 0.966 | 29768.1 |
1444 | 2023-02-16 08:57:32 | fires | 2 | 53800 | 412 | 1.623 | 33148.5 |
1443 | 2023-01-11 23:35:49 | fires | 1 | 28756 | 27 | 0.970 | 29645.4 |
1442 | 2022-11-29 09:09:28 | fires | 2 | 53800 | 412 | 1.330 | 40451.1 |
1441 | 2022-11-19 13:35:59 | fires | 1 | 28756 | 27 | 0.516 | 55728.7 |
1440 | 2022-10-28 20:22:07 | fires | 1 | 28756 | 27 | 0.500 | 57512.0 |
1439 | 2022-08-19 02:31:37 | fires | 1 | 28756 | 27 | 0.486 | 59168.7 |
1438 | 2022-08-18 17:48:21 | fires | 2 | 53800 | 412 | 1.546 | 34799.5 |
1437 | 2022-08-18 04:58:25 | fires | 2 | 53800 | 412 | 1.406 | 38264.6 |
1436 | 2022-08-17 22:31:09 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1435 | 2022-08-16 22:35:15 | fires | 2 | 53800 | 412 | 1.453 | 37026.8 |
1434 | 2022-08-15 19:19:59 | fires | 1 | 28756 | 27 | 0.453 | 63479.0 |
1433 | 2022-08-15 01:28:29 | fires | 1 | 28756 | 27 | 0.470 | 61183.0 |
1432 | 2022-08-14 20:09:14 | fires | 2 | 53800 | 412 | 1.500 | 35866.7 |
1431 | 2022-08-13 22:40:47 | fires | 2 | 53800 | 412 | 1.516 | 35488.1 |
1430 | 2022-08-11 20:33:51 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1429 | 2022-08-09 22:03:23 | fires | 2 | 53800 | 412 | 1.623 | 33148.5 |
1428 | 2022-08-08 17:51:08 | fires | 2 | 53800 | 412 | 1.580 | 34050.6 |
1427 | 2022-08-06 17:16:35 | fires | 2 | 53800 | 412 | 1.453 | 37026.8 |
1426 | 2022-08-05 18:17:41 | fires | 2 | 53800 | 412 | 1.533 | 35094.6 |
1425 | 2022-08-04 19:45:21 | fires | 2 | 53800 | 412 | 1.500 | 35866.7 |
1424 | 2022-08-03 19:32:40 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1423 | 2022-07-31 21:23:00 | fires | 2 | 53800 | 412 | 1.516 | 35488.1 |
1422 | 2022-07-30 23:25:44 | fires | 2 | 53800 | 412 | 1.736 | 30990.8 |
1421 | 2022-07-29 09:32:44 | fires | 1 | 28756 | 27 | 0.453 | 63479.0 |
1420 | 2022-07-28 00:03:57 | fires | 2 | 53800 | 412 | 1.576 | 34137.1 |
1419 | 2022-07-26 18:32:46 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1418 | 2022-07-22 17:34:40 | fires | 2 | 53800 | 412 | 1.470 | 36598.6 |
1417 | 2022-07-21 22:37:43 | fires | 2 | 53800 | 412 | 1.360 | 39558.8 |
1416 | 2022-07-19 18:02:21 | fires | 2 | 53800 | 412 | 1.343 | 40059.6 |
1415 | 2022-07-18 23:34:42 | fires | 2 | 53800 | 412 | 1.656 | 32487.9 |
1414 | 2022-07-16 21:19:32 | fires | 2 | 53800 | 412 | 1.533 | 35094.6 |
1413 | 2022-07-15 17:47:23 | fires | 2 | 53800 | 412 | 1.390 | 38705.0 |
1412 | 2022-07-14 22:02:39 | fires | 2 | 53800 | 412 | 1.486 | 36204.6 |
1411 | 2022-07-13 21:01:09 | fires | 2 | 53800 | 412 | 1.373 | 39184.3 |
1410 | 2022-07-12 04:58:50 | fires | 2 | 53800 | 412 | 3.390 | 15870.2 |
1409 | 2022-07-11 09:13:23 | fires | 2 | 53800 | 412 | 3.343 | 16093.3 |
1408 | 2022-07-10 15:28:35 | fires | 2 | 53800 | 412 | 1.623 | 33148.5 |
1407 | 2022-07-09 03:35:41 | fires | 2 | 53800 | 412 | 3.703 | 14528.8 |
1406 | 2022-07-08 08:31:22 | fires | 2 | 53800 | 412 | 1.423 | 37807.4 |
1405 | 2022-07-07 14:23:10 | fires | 2 | 53800 | 412 | 1.580 | 34050.6 |
1404 | 2022-07-06 05:51:49 | fires | 2 | 53800 | 412 | 1.720 | 31279.1 |
1403 | 2022-07-05 07:04:14 | fires | 2 | 53800 | 412 | 1.576 | 34137.1 |
1402 | 2022-07-05 04:35:17 | fires | 2 | 53800 | 412 | 1.376 | 39098.8 |
1401 | 2022-07-04 15:01:43 | fires | 2 | 53800 | 412 | 1.516 | 35488.1 |
1400 | 2022-07-03 02:20:50 | fires | 2 | 53800 | 412 | 1.593 | 33772.8 |
1399 | 2022-07-02 03:17:20 | fires | 2 | 53800 | 412 | 1.373 | 39184.3 |