History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canfield"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 653 | 2026-03-09 03:41:30 | canfield | 1 | 82945 | 2 | 2.190 | 37874.4 |
| 652 | 2026-03-06 11:23:49 | canfield | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 651 | 2026-03-06 03:49:30 | canfield | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 650 | 2026-03-05 15:03:22 | canfield | 1 | 82945 | 2 | 1.580 | 52496.8 |
| 649 | 2026-03-05 04:30:42 | canfield | 1 | 82945 | 2 | 1.576 | 52630.1 |
| 648 | 2026-03-04 19:25:30 | canfield | 1 | 82945 | 2 | 2.923 | 28376.7 |
| 647 | 2026-03-02 13:27:20 | canfield | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 646 | 2026-03-01 09:38:04 | canfield | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 645 | 2026-02-28 08:06:53 | canfield | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 644 | 2026-02-28 03:04:36 | canfield | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 643 | 2026-02-25 17:49:34 | canfield | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 642 | 2026-02-24 06:46:53 | canfield | 1 | 82945 | 2 | 1.780 | 46598.3 |
| 641 | 2026-02-23 15:45:45 | canfield | 1 | 82945 | 2 | 1.576 | 52630.1 |
| 640 | 2026-02-23 09:40:20 | canfield | 1 | 82945 | 2 | 2.013 | 41204.7 |
| 639 | 2026-02-23 08:43:51 | canfield | 1 | 82945 | 2 | 1.606 | 51646.9 |
| 638 | 2026-02-23 06:38:35 | canfield | 1 | 82945 | 2 | 1.563 | 53067.8 |
| 637 | 2026-02-23 04:50:00 | canfield | 1 | 82945 | 2 | 1.563 | 53067.8 |
| 636 | 2026-02-22 13:29:06 | canfield | 1 | 82945 | 2 | 1.593 | 52068.4 |
| 635 | 2026-02-22 07:04:05 | canfield | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 634 | 2026-02-22 01:11:27 | canfield | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 633 | 2026-02-21 05:04:12 | canfield | 1 | 82945 | 2 | 3.126 | 26533.9 |
| 632 | 2026-02-20 14:16:55 | canfield | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 631 | 2026-02-20 03:09:56 | canfield | 1 | 82945 | 2 | 1.906 | 43517.8 |
| 630 | 2026-02-18 19:22:01 | canfield | 1 | 82945 | 2 | 3.216 | 25791.4 |
| 629 | 2026-02-15 10:45:53 | canfield | 1 | 82945 | 2 | 2.483 | 33405.2 |
| 628 | 2026-02-14 06:13:32 | canfield | 1 | 82945 | 2 | 2.720 | 30494.5 |
| 627 | 2026-02-13 07:56:17 | canfield | 3 | 146162 | 71 | 10.280 | 14218.1 |
| 626 | 2026-02-08 10:45:56 | canfield | 1 | 82945 | 2 | 1.623 | 51106.0 |
| 625 | 2026-02-08 06:08:39 | canfield | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 624 | 2026-02-05 11:41:08 | canfield | 1 | 82945 | 2 | 1.560 | 53169.9 |
| 623 | 2026-02-05 06:02:16 | canfield | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 622 | 2026-01-20 08:21:55 | canfield | 1 | 82945 | 2 | 7.173 | 11563.5 |
| 621 | 2026-01-07 00:28:20 | canfield | 3 | 146162 | 71 | 12.736 | 11476.3 |
| 620 | 2026-01-04 06:41:31 | canfield | 1 | 82945 | 2 | 1.716 | 48336.2 |
| 619 | 2025-12-27 22:01:23 | canfield | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 618 | 2025-12-24 17:35:38 | canfield | 1 | 82945 | 2 | 3.376 | 24569.0 |
| 617 | 2025-12-19 21:08:44 | canfield | 3 | 146162 | 71 | 8.953 | 16325.5 |
| 616 | 2025-12-13 14:34:13 | canfield | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 615 | 2025-12-13 03:45:48 | canfield | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 614 | 2025-12-12 17:39:45 | canfield | 1 | 82945 | 2 | 3.843 | 21583.4 |
| 613 | 2025-12-08 09:24:05 | canfield | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 612 | 2025-11-24 15:29:55 | canfield | 3 | 146162 | 71 | 7.173 | 20376.7 |
| 611 | 2025-11-19 18:03:54 | canfield | 1 | 82945 | 2 | 2.626 | 31586.1 |
| 610 | 2025-11-04 02:47:17 | canfield | 4 | 161609 | 794 | 23.126 | 6988.2 |
| 609 | 2025-10-28 01:04:46 | canfield | 3 | 146162 | 71 | 7.846 | 18628.9 |
| 608 | 2025-10-25 18:06:03 | canfield | 1 | 82945 | 2 | 1.563 | 53067.8 |
| 607 | 2025-10-21 09:48:32 | canfield | 3 | 146162 | 71 | 37.003 | 3950.0 |
| 606 | 2025-10-06 12:52:38 | canfield | 4 | 161609 | 794 | 12.626 | 12799.7 |
| 605 | 2025-09-19 05:27:01 | canfield | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 604 | 2025-09-09 04:16:30 | canfield | 4 | 161609 | 794 | 12.876 | 12551.2 |
| 603 | 2025-08-29 14:46:19 | canfield | 4 | 161609 | 794 | 13.500 | 11971.0 |
| 602 | 2025-08-26 13:16:09 | canfield | 1 | 82945 | 2 | 1.643 | 50483.9 |
| 601 | 2025-08-23 12:20:43 | canfield | 4 | 161609 | 794 | 32.970 | 4901.7 |
| 600 | 2025-08-17 19:11:20 | canfield | 4 | 161609 | 794 | 45.143 | 3579.9 |
| 599 | 2025-08-17 13:30:25 | canfield | 4 | 161609 | 794 | 61.723 | 2618.3 |
| 598 | 2025-08-15 15:11:12 | canfield | 4 | 161609 | 794 | 74.970 | 2155.6 |
| 597 | 2025-08-12 22:27:22 | canfield | 4 | 161609 | 794 | 33.393 | 4839.6 |
| 596 | 2025-08-12 05:49:17 | canfield | 2 | 121059 | 8 | 16.020 | 7556.7 |
| 595 | 2025-08-09 02:20:45 | canfield | 1 | 82945 | 2 | 7.626 | 10876.6 |
| 594 | 2025-08-04 18:28:59 | canfield | 3 | 146162 | 71 | 24.470 | 5973.1 |
| 593 | 2025-08-04 18:28:56 | canfield | 3 | 146162 | 71 | 20.486 | 7134.7 |
| 592 | 2025-08-04 04:57:35 | canfield | 1 | 82945 | 2 | 3.060 | 27106.2 |
| 591 | 2025-08-03 10:30:24 | canfield | 3 | 146162 | 71 | 7.423 | 19690.4 |
| 590 | 2025-08-02 05:16:04 | canfield | 3 | 146162 | 71 | 30.660 | 4767.2 |
| 589 | 2025-07-29 13:33:51 | canfield | 3 | 146162 | 71 | 39.423 | 3707.5 |
| 588 | 2025-07-25 06:16:51 | canfield | 1 | 82945 | 2 | 3.670 | 22600.8 |
| 587 | 2025-07-24 22:06:08 | canfield | 1 | 82945 | 2 | 7.296 | 11368.6 |
| 586 | 2025-07-24 19:39:42 | canfield | 1 | 82945 | 2 | 3.983 | 20824.8 |
| 585 | 2025-07-22 21:46:53 | canfield | 1 | 82945 | 2 | 5.420 | 15303.5 |
| 584 | 2025-07-17 16:01:48 | canfield | 1 | 82945 | 2 | 8.453 | 9812.5 |
| 583 | 2025-07-07 08:08:51 | canfield | 1 | 82945 | 2 | 7.923 | 10468.9 |
| 582 | 2025-07-05 13:20:54 | canfield | 1 | 82945 | 2 | 7.736 | 10721.9 |
| 581 | 2025-07-05 01:06:31 | canfield | 1 | 82945 | 2 | 5.800 | 14300.9 |
| 580 | 2025-06-28 00:56:00 | canfield | 1 | 82945 | 2 | 5.390 | 15388.7 |
| 579 | 2025-06-27 13:31:54 | canfield | 3 | 146162 | 71 | 37.863 | 3860.3 |
| 578 | 2025-06-25 19:47:06 | canfield | 3 | 146162 | 71 | 7.906 | 18487.5 |
| 577 | 2025-06-21 20:25:26 | canfield | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 576 | 2025-06-13 20:19:22 | canfield | 1 | 82945 | 2 | 7.953 | 10429.4 |
| 575 | 2025-06-13 12:52:32 | canfield | 3 | 146162 | 71 | 36.876 | 3963.6 |
| 574 | 2025-06-10 12:07:14 | canfield | 3 | 146162 | 71 | 31.533 | 4635.2 |
| 573 | 2025-06-03 00:38:26 | canfield | 3 | 146162 | 71 | 7.563 | 19325.9 |
| 572 | 2025-05-29 08:53:35 | canfield | 1 | 82945 | 2 | 6.826 | 12151.3 |
| 571 | 2025-05-28 21:53:19 | canfield | 1 | 82945 | 2 | 5.220 | 15889.8 |
| 570 | 2025-05-23 06:36:27 | canfield | 1 | 82945 | 2 | 5.750 | 14425.2 |
| 569 | 2025-05-22 16:06:07 | canfield | 1 | 82945 | 2 | 3.706 | 22381.3 |
| 568 | 2025-05-21 15:29:24 | canfield | 3 | 146162 | 71 | 8.703 | 16794.4 |
| 567 | 2025-05-21 11:45:43 | canfield | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 566 | 2025-05-20 02:37:15 | canfield | 1 | 82945 | 2 | 6.466 | 12827.9 |
| 565 | 2025-05-16 05:12:16 | canfield | 1 | 82945 | 2 | 5.656 | 14665.0 |
| 564 | 2025-05-16 00:43:51 | canfield | 1 | 82945 | 2 | 3.856 | 21510.6 |
| 563 | 2025-05-14 16:10:19 | canfield | 1 | 82945 | 2 | 8.923 | 9295.6 |
| 562 | 2025-05-13 13:23:41 | canfield | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 561 | 2025-05-10 16:11:11 | canfield | 1 | 82945 | 2 | 4.813 | 17233.5 |
| 560 | 2025-05-09 13:47:22 | canfield | 1 | 82945 | 2 | 6.766 | 12259.1 |
| 559 | 2025-05-09 01:09:37 | canfield | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 558 | 2025-05-08 03:00:09 | canfield | 1 | 82945 | 2 | 3.876 | 21399.6 |
| 557 | 2025-05-04 08:29:31 | canfield | 1 | 82945 | 2 | 7.576 | 10948.4 |
| 556 | 2025-05-03 23:22:03 | canfield | 3 | 146162 | 71 | 42.643 | 3427.6 |
| 555 | 2025-05-02 21:19:41 | canfield | 3 | 146162 | 71 | 26.470 | 5521.8 |
| 554 | 2025-04-26 13:56:42 | canfield | 3 | 146162 | 71 | 35.173 | 4155.5 |