History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prenames"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 688 | 2025-10-18 20:05:04 | prenames | 3 | 146162 | 283 | 7.780 | 18786.9 |
| 687 | 2025-10-18 19:41:17 | prenames | 3 | 146162 | 283 | 14.160 | 10322.2 |
| 686 | 2025-10-08 17:45:35 | prenames | 3 | 146162 | 283 | 6.986 | 20922.1 |
| 685 | 2025-10-01 14:56:07 | prenames | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 684 | 2025-09-15 04:16:39 | prenames | 1 | 82945 | 4 | 1.750 | 47397.1 |
| 683 | 2025-09-14 12:18:13 | prenames | 1 | 82945 | 4 | 1.640 | 50576.2 |
| 682 | 2025-09-08 03:06:35 | prenames | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 681 | 2025-08-28 08:28:58 | prenames | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 680 | 2025-08-27 17:19:37 | prenames | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 679 | 2025-08-27 01:25:20 | prenames | 1 | 82945 | 4 | 1.720 | 48223.8 |
| 678 | 2025-08-27 00:45:52 | prenames | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 677 | 2025-08-21 14:55:11 | prenames | 1 | 82945 | 4 | 3.516 | 23590.7 |
| 676 | 2025-08-14 15:16:51 | prenames | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 675 | 2025-08-05 06:40:15 | prenames | 1 | 82945 | 4 | 3.686 | 22502.7 |
| 674 | 2025-07-27 09:49:08 | prenames | 1 | 82945 | 4 | 9.843 | 8426.8 |
| 673 | 2025-07-26 06:44:12 | prenames | 1 | 82945 | 4 | 10.970 | 7561.1 |
| 672 | 2025-07-24 12:45:57 | prenames | 1 | 82945 | 4 | 4.970 | 16689.1 |
| 671 | 2025-07-24 02:43:12 | prenames | 1 | 82945 | 4 | 8.170 | 10152.4 |
| 670 | 2025-07-22 11:39:25 | prenames | 1 | 82945 | 4 | 4.796 | 17294.6 |
| 669 | 2025-07-20 16:11:40 | prenames | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 668 | 2025-07-11 09:13:43 | prenames | 1 | 82945 | 4 | 5.436 | 15258.5 |
| 667 | 2025-07-10 18:41:10 | prenames | 1 | 82945 | 4 | 6.016 | 13787.4 |
| 666 | 2025-07-09 20:43:37 | prenames | 1 | 82945 | 4 | 8.923 | 9295.6 |
| 665 | 2025-06-30 05:32:45 | prenames | 1 | 82945 | 4 | 6.140 | 13509.0 |
| 664 | 2025-06-27 17:00:47 | prenames | 2 | 121059 | 28 | 18.360 | 6593.6 |
| 663 | 2025-06-26 14:10:11 | prenames | 2 | 121059 | 28 | 16.190 | 7477.4 |
| 662 | 2025-06-24 08:52:00 | prenames | 1 | 82945 | 4 | 7.313 | 11342.1 |
| 661 | 2025-06-24 00:48:45 | prenames | 2 | 121059 | 28 | 14.080 | 8597.9 |
| 660 | 2025-06-23 08:52:30 | prenames | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 659 | 2025-06-23 02:12:36 | prenames | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 658 | 2025-06-18 05:03:54 | prenames | 1 | 82945 | 4 | 5.516 | 15037.2 |
| 657 | 2025-06-16 02:14:11 | prenames | 1 | 82945 | 4 | 8.563 | 9686.4 |
| 656 | 2025-06-15 21:10:19 | prenames | 3 | 146162 | 283 | 42.173 | 3465.8 |
| 655 | 2025-06-14 14:55:13 | prenames | 3 | 146162 | 283 | 50.880 | 2872.7 |
| 654 | 2025-06-13 22:08:57 | prenames | 3 | 146162 | 283 | 48.503 | 3013.5 |
| 653 | 2025-06-05 03:32:40 | prenames | 3 | 146162 | 283 | 39.883 | 3664.8 |
| 652 | 2025-06-04 01:22:37 | prenames | 3 | 146162 | 283 | 27.656 | 5285.0 |
| 651 | 2025-06-02 16:45:38 | prenames | 3 | 146162 | 283 | 25.233 | 5792.5 |
| 650 | 2025-05-31 23:26:57 | prenames | 1 | 82945 | 4 | 5.390 | 15388.7 |
| 649 | 2025-05-31 01:17:22 | prenames | 3 | 146162 | 283 | 30.750 | 4753.2 |
| 648 | 2025-05-26 22:19:54 | prenames | 3 | 146162 | 283 | 39.860 | 3666.9 |
| 647 | 2025-05-24 10:02:16 | prenames | 1 | 82945 | 4 | 7.126 | 11639.8 |
| 646 | 2025-05-22 11:42:08 | prenames | 1 | 82945 | 4 | 5.330 | 15561.9 |
| 645 | 2025-05-18 05:45:44 | prenames | 1 | 82945 | 4 | 3.483 | 23814.2 |
| 644 | 2025-05-18 04:13:15 | prenames | 2 | 121059 | 28 | 16.503 | 7335.6 |
| 643 | 2025-05-17 09:03:47 | prenames | 1 | 82945 | 4 | 1.576 | 52630.1 |
| 642 | 2025-05-13 04:35:42 | prenames | 3 | 146162 | 283 | 38.563 | 3790.2 |
| 641 | 2025-05-08 05:22:26 | prenames | 1 | 82945 | 4 | 3.533 | 23477.2 |
| 640 | 2025-05-03 23:59:02 | prenames | 1 | 82945 | 4 | 3.856 | 21510.6 |
| 639 | 2025-05-03 13:16:00 | prenames | 1 | 82945 | 4 | 7.700 | 10772.1 |
| 638 | 2025-05-02 17:09:15 | prenames | 3 | 146162 | 283 | 38.703 | 3776.5 |
| 637 | 2025-05-02 16:08:07 | prenames | 3 | 146162 | 283 | 52.583 | 2779.6 |
| 636 | 2025-05-01 00:38:50 | prenames | 1 | 82945 | 4 | 7.030 | 11798.7 |
| 635 | 2025-04-30 18:36:13 | prenames | 3 | 146162 | 283 | 7.780 | 18786.9 |
| 634 | 2025-04-28 00:43:57 | prenames | 3 | 146162 | 283 | 46.690 | 3130.5 |
| 633 | 2025-04-26 01:15:27 | prenames | 3 | 146162 | 283 | 37.646 | 3882.5 |
| 632 | 2025-04-25 15:29:21 | prenames | 2 | 121059 | 28 | 20.580 | 5882.4 |
| 631 | 2025-04-25 08:26:46 | prenames | 3 | 146162 | 283 | 38.753 | 3771.6 |
| 630 | 2025-04-23 07:54:39 | prenames | 1 | 82945 | 4 | 4.483 | 18502.1 |
| 629 | 2025-04-15 09:20:59 | prenames | 1 | 82945 | 4 | 10.203 | 8129.5 |
| 628 | 2025-04-15 04:59:02 | prenames | 1 | 82945 | 4 | 6.846 | 12115.8 |
| 627 | 2025-04-14 03:02:53 | prenames | 1 | 82945 | 4 | 4.623 | 17941.8 |
| 626 | 2025-04-14 02:11:52 | prenames | 1 | 82945 | 4 | 6.703 | 12374.3 |
| 625 | 2025-03-31 16:39:29 | prenames | 1 | 82945 | 4 | 7.156 | 11591.0 |
| 624 | 2025-03-27 19:04:29 | prenames | 3 | 146162 | 283 | 23.686 | 6170.8 |
| 623 | 2025-03-27 02:03:14 | prenames | 3 | 146162 | 283 | 23.580 | 6198.6 |
| 622 | 2025-03-25 15:50:24 | prenames | 3 | 146162 | 283 | 30.236 | 4834.0 |
| 621 | 2025-03-25 11:13:14 | prenames | 3 | 146162 | 283 | 52.520 | 2783.0 |
| 620 | 2025-03-25 02:23:24 | prenames | 3 | 146162 | 283 | 39.296 | 3719.5 |
| 619 | 2025-03-24 18:42:54 | prenames | 2 | 121059 | 28 | 5.360 | 22585.6 |
| 618 | 2025-03-22 17:34:07 | prenames | 2 | 121059 | 28 | 31.813 | 3805.3 |
| 617 | 2025-03-22 16:51:35 | prenames | 3 | 146162 | 283 | 21.533 | 6787.8 |
| 616 | 2025-03-22 12:13:42 | prenames | 2 | 121059 | 28 | 27.800 | 4354.6 |
| 615 | 2025-03-22 08:48:11 | prenames | 1 | 82945 | 4 | 4.376 | 18954.5 |
| 614 | 2025-03-19 12:44:05 | prenames | 2 | 121059 | 28 | 3.626 | 33386.4 |
| 613 | 2025-03-13 14:55:07 | prenames | 1 | 82945 | 4 | 7.080 | 11715.4 |
| 612 | 2025-03-13 00:35:15 | prenames | 1 | 82945 | 4 | 6.923 | 11981.1 |
| 611 | 2025-03-12 21:11:28 | prenames | 1 | 82945 | 4 | 6.440 | 12879.7 |
| 610 | 2025-03-12 04:14:22 | prenames | 1 | 82945 | 4 | 8.810 | 9414.9 |
| 609 | 2025-03-10 00:40:30 | prenames | 1 | 82945 | 4 | 5.860 | 14154.4 |
| 608 | 2025-03-02 18:25:01 | prenames | 1 | 82945 | 4 | 5.626 | 14743.2 |
| 607 | 2025-03-01 10:50:00 | prenames | 1 | 82945 | 4 | 4.940 | 16790.5 |
| 606 | 2025-02-10 08:46:27 | prenames | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 605 | 2025-02-08 14:27:59 | prenames | 2 | 121059 | 28 | 3.593 | 33693.0 |
| 604 | 2025-02-08 03:57:12 | prenames | 2 | 121059 | 28 | 19.096 | 6339.5 |
| 603 | 2025-02-08 03:54:36 | prenames | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 602 | 2025-02-07 16:32:40 | prenames | 2 | 121059 | 28 | 12.780 | 9472.5 |
| 601 | 2025-02-07 16:29:20 | prenames | 3 | 146162 | 283 | 8.516 | 17163.2 |
| 600 | 2025-02-06 05:49:36 | prenames | 3 | 146162 | 283 | 55.646 | 2626.6 |
| 599 | 2025-02-06 04:29:43 | prenames | 3 | 146162 | 283 | 32.140 | 4547.7 |
| 598 | 2025-02-06 00:59:38 | prenames | 3 | 146162 | 283 | 32.610 | 4482.1 |
| 597 | 2025-02-06 00:59:39 | prenames | 2 | 121059 | 28 | 19.576 | 6184.1 |
| 596 | 2025-02-06 00:59:38 | prenames | 1 | 82945 | 4 | 10.453 | 7935.0 |
| 595 | 2025-01-24 23:04:50 | prenames | 1 | 82945 | 4 | 6.453 | 12853.7 |
| 594 | 2025-01-08 14:38:32 | prenames | 1 | 82945 | 4 | 5.343 | 15524.1 |
| 593 | 2024-12-20 09:47:02 | prenames | 1 | 82945 | 4 | 10.936 | 7584.6 |
| 592 | 2024-12-18 10:16:50 | prenames | 1 | 82945 | 4 | 8.560 | 9689.8 |
| 591 | 2024-12-15 16:36:10 | prenames | 1 | 82945 | 4 | 7.076 | 11722.0 |
| 590 | 2024-12-07 04:15:16 | prenames | 2 | 121059 | 28 | 13.516 | 8956.7 |
| 589 | 2024-12-07 04:15:11 | prenames | 1 | 82945 | 4 | 4.500 | 18432.2 |