History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doornail"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 590 | 2025-11-26 09:27:57 | doornail | 2 | 121059 | 2 | 4.580 | 26432.1 |
| 589 | 2025-11-22 09:53:52 | doornail | 4 | 161609 | 292 | 12.096 | 13360.5 |
| 588 | 2025-11-20 15:17:54 | doornail | 3 | 146162 | 27 | 7.046 | 20744.0 |
| 587 | 2025-11-02 17:33:03 | doornail | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 586 | 2025-10-31 16:36:12 | doornail | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 585 | 2025-10-30 22:58:06 | doornail | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 584 | 2025-10-23 01:09:08 | doornail | 1 | 82945 | 2 | 5.576 | 14875.4 |
| 583 | 2025-10-23 01:09:02 | doornail | 1 | 82945 | 2 | 5.330 | 15561.9 |
| 582 | 2025-10-23 01:08:55 | doornail | 1 | 82945 | 2 | 8.016 | 10347.4 |
| 581 | 2025-10-23 01:08:39 | doornail | 1 | 82945 | 2 | 4.813 | 17233.5 |
| 580 | 2025-10-18 20:57:05 | doornail | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 579 | 2025-10-05 17:46:06 | doornail | 3 | 146162 | 27 | 6.766 | 21602.4 |
| 578 | 2025-10-02 08:42:04 | doornail | 2 | 121059 | 2 | 3.283 | 36874.5 |
| 577 | 2025-10-01 22:43:33 | doornail | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 576 | 2025-09-19 11:34:58 | doornail | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 575 | 2025-09-18 01:53:03 | doornail | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 574 | 2025-09-09 06:47:33 | doornail | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 573 | 2025-09-02 21:19:21 | doornail | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 572 | 2025-08-12 13:55:35 | doornail | 1 | 82945 | 2 | 3.233 | 25655.7 |
| 571 | 2025-08-09 03:53:30 | doornail | 1 | 82945 | 2 | 4.686 | 17700.6 |
| 570 | 2025-08-02 18:30:16 | doornail | 3 | 146162 | 27 | 55.673 | 2625.4 |
| 569 | 2025-07-19 20:36:19 | doornail | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 568 | 2025-07-15 12:11:46 | doornail | 1 | 82945 | 2 | 5.186 | 15994.0 |
| 567 | 2025-07-15 06:56:07 | doornail | 3 | 146162 | 27 | 37.643 | 3882.8 |
| 566 | 2025-07-07 15:23:52 | doornail | 3 | 146162 | 27 | 27.566 | 5302.3 |
| 565 | 2025-07-04 02:43:07 | doornail | 3 | 146162 | 27 | 27.203 | 5373.0 |
| 564 | 2025-07-01 21:44:41 | doornail | 3 | 146162 | 27 | 46.753 | 3126.3 |
| 563 | 2025-06-24 06:27:35 | doornail | 1 | 82945 | 2 | 7.033 | 11793.7 |
| 562 | 2025-06-21 01:05:38 | doornail | 1 | 82945 | 2 | 6.686 | 12405.8 |
| 561 | 2025-06-18 03:40:31 | doornail | 1 | 82945 | 2 | 5.703 | 14544.1 |
| 560 | 2025-06-08 10:43:04 | doornail | 3 | 146162 | 27 | 48.206 | 3032.0 |
| 559 | 2025-06-01 14:25:23 | doornail | 3 | 146162 | 27 | 26.580 | 5498.9 |
| 558 | 2025-05-31 21:18:24 | doornail | 1 | 82945 | 2 | 5.423 | 15295.0 |
| 557 | 2025-05-29 07:11:58 | doornail | 1 | 82945 | 2 | 9.486 | 8743.9 |
| 556 | 2025-05-27 00:08:02 | doornail | 2 | 121059 | 2 | 12.623 | 9590.4 |
| 555 | 2025-05-26 22:02:17 | doornail | 3 | 146162 | 27 | 37.550 | 3892.5 |
| 554 | 2025-05-26 03:15:15 | doornail | 3 | 146162 | 27 | 37.486 | 3899.1 |
| 553 | 2025-05-25 01:24:10 | doornail | 1 | 82945 | 2 | 1.486 | 55817.6 |
| 552 | 2025-05-23 08:15:42 | doornail | 3 | 146162 | 27 | 25.050 | 5834.8 |
| 551 | 2025-05-20 09:01:38 | doornail | 1 | 82945 | 2 | 5.986 | 13856.5 |
| 550 | 2025-05-20 02:27:35 | doornail | 3 | 146162 | 27 | 29.376 | 4975.6 |
| 549 | 2025-05-19 15:33:06 | doornail | 2 | 121059 | 2 | 4.190 | 28892.4 |
| 548 | 2025-05-19 05:09:45 | doornail | 3 | 146162 | 27 | 10.626 | 13755.1 |
| 547 | 2025-05-17 06:18:51 | doornail | 1 | 82945 | 2 | 6.673 | 12429.9 |
| 546 | 2025-05-10 03:46:22 | doornail | 1 | 82945 | 2 | 7.046 | 11771.9 |
| 545 | 2025-05-08 13:16:14 | doornail | 1 | 82945 | 2 | 7.063 | 11743.6 |
| 544 | 2025-05-03 13:40:34 | doornail | 4 | 161609 | 292 | 12.890 | 12537.5 |
| 543 | 2025-05-02 15:44:06 | doornail | 4 | 161609 | 292 | 71.773 | 2251.7 |
| 542 | 2025-05-02 12:22:17 | doornail | 4 | 161609 | 292 | 62.083 | 2603.1 |
| 541 | 2025-05-01 04:31:52 | doornail | 4 | 161609 | 292 | 53.893 | 2998.7 |
| 540 | 2025-04-29 15:04:59 | doornail | 4 | 161609 | 292 | 11.233 | 14387.0 |
| 539 | 2025-04-22 02:34:52 | doornail | 1 | 82945 | 2 | 6.673 | 12429.9 |
| 538 | 2025-04-16 00:09:00 | doornail | 1 | 82945 | 2 | 7.500 | 11059.3 |
| 537 | 2025-04-04 03:47:32 | doornail | 1 | 82945 | 2 | 3.313 | 25036.2 |
| 536 | 2025-04-03 14:09:41 | doornail | 3 | 146162 | 27 | 16.546 | 8833.7 |
| 535 | 2025-03-31 23:46:25 | doornail | 2 | 121059 | 2 | 12.563 | 9636.2 |
| 534 | 2025-03-30 20:33:35 | doornail | 3 | 146162 | 27 | 20.176 | 7244.3 |
| 533 | 2025-03-24 10:12:48 | doornail | 1 | 82945 | 2 | 5.313 | 15611.7 |
| 532 | 2025-03-14 18:16:06 | doornail | 1 | 82945 | 2 | 13.080 | 6341.4 |
| 531 | 2025-03-10 23:49:01 | doornail | 4 | 161609 | 292 | 61.910 | 2610.4 |
| 530 | 2025-03-04 11:13:15 | doornail | 1 | 82945 | 2 | 5.263 | 15760.0 |
| 529 | 2025-03-02 07:22:32 | doornail | 1 | 82945 | 2 | 9.076 | 9138.9 |
| 528 | 2025-02-26 18:20:49 | doornail | 4 | 161609 | 292 | 61.110 | 2644.6 |
| 527 | 2025-02-18 08:58:54 | doornail | 4 | 161609 | 292 | 51.783 | 3120.9 |
| 526 | 2025-02-16 01:36:14 | doornail | 4 | 161609 | 292 | 64.533 | 2504.3 |
| 525 | 2025-02-16 00:50:23 | doornail | 4 | 161609 | 292 | 64.096 | 2521.4 |
| 524 | 2025-02-15 09:25:44 | doornail | 4 | 161609 | 292 | 57.240 | 2823.4 |
| 523 | 2025-02-15 09:25:43 | doornail | 2 | 121059 | 2 | 16.346 | 7406.0 |
| 522 | 2025-02-15 09:25:06 | doornail | 1 | 82945 | 2 | 7.013 | 11827.3 |
| 521 | 2025-02-09 13:08:38 | doornail | 3 | 146162 | 27 | 20.266 | 7212.2 |
| 520 | 2025-02-05 07:26:35 | doornail | 3 | 146162 | 27 | 7.033 | 20782.3 |
| 519 | 2025-02-04 14:38:36 | doornail | 3 | 146162 | 27 | 47.703 | 3064.0 |
| 518 | 2025-02-03 12:50:26 | doornail | 3 | 146162 | 27 | 37.673 | 3879.8 |
| 517 | 2025-02-01 08:53:31 | doornail | 3 | 146162 | 27 | 46.680 | 3131.1 |
| 516 | 2025-01-29 00:00:36 | doornail | 1 | 82945 | 2 | 10.483 | 7912.3 |
| 515 | 2025-01-28 18:38:16 | doornail | 3 | 146162 | 27 | 19.986 | 7313.2 |
| 514 | 2025-01-14 08:13:40 | doornail | 1 | 82945 | 2 | 9.306 | 8913.1 |
| 513 | 2025-01-10 10:40:58 | doornail | 2 | 121059 | 2 | 3.483 | 34757.1 |
| 512 | 2025-01-09 20:19:03 | doornail | 3 | 146162 | 27 | 34.893 | 4188.9 |
| 511 | 2025-01-09 19:07:08 | doornail | 3 | 146162 | 27 | 37.143 | 3935.1 |
| 510 | 2025-01-05 04:08:30 | doornail | 3 | 146162 | 27 | 47.173 | 3098.4 |
| 509 | 2025-01-03 12:32:43 | doornail | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 508 | 2025-01-01 20:49:06 | doornail | 3 | 146162 | 27 | 29.673 | 4925.8 |
| 507 | 2025-01-01 06:32:37 | doornail | 4 | 161609 | 292 | 31.643 | 5107.3 |
| 506 | 2024-12-31 10:02:19 | doornail | 4 | 161609 | 292 | 57.706 | 2800.6 |
| 505 | 2024-12-30 21:32:54 | doornail | 4 | 161609 | 292 | 12.953 | 12476.6 |
| 504 | 2024-12-30 21:32:55 | doornail | 3 | 146162 | 27 | 7.766 | 18820.8 |
| 503 | 2024-12-30 21:32:56 | doornail | 2 | 121059 | 2 | 5.500 | 22010.7 |
| 502 | 2024-12-30 21:32:51 | doornail | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 501 | 2024-12-10 03:17:48 | doornail | 2 | 121059 | 2 | 9.550 | 12676.3 |
| 500 | 2024-12-07 12:40:49 | doornail | 3 | 146162 | 27 | 14.063 | 10393.4 |
| 499 | 2024-12-05 17:57:12 | doornail | 1 | 82945 | 2 | 5.860 | 14154.4 |
| 498 | 2024-11-29 09:55:18 | doornail | 3 | 146162 | 27 | 32.110 | 4551.9 |
| 497 | 2024-11-28 14:23:07 | doornail | 4 | 161609 | 292 | 54.330 | 2974.6 |
| 496 | 2024-11-28 10:53:03 | doornail | 3 | 146162 | 27 | 10.080 | 14500.2 |
| 495 | 2024-11-24 08:28:23 | doornail | 3 | 146162 | 27 | 32.686 | 4471.7 |
| 494 | 2024-11-23 11:27:39 | doornail | 4 | 161609 | 292 | 55.376 | 2918.4 |
| 493 | 2024-11-23 11:27:47 | doornail | 3 | 146162 | 27 | 37.766 | 3870.2 |
| 492 | 2024-11-23 11:27:50 | doornail | 2 | 121059 | 2 | 16.373 | 7393.8 |
| 491 | 2024-11-23 11:27:15 | doornail | 1 | 82945 | 2 | 6.173 | 13436.7 |