History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smith"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 800 | 2024-05-01 04:10:34 | smith | 1 | 28756 | 8 | 0.513 | 56054.6 |
| 799 | 2024-04-30 08:14:03 | smith | 1 | 28756 | 8 | 0.563 | 51076.4 |
| 798 | 2024-04-29 08:34:56 | smith | 3 | 83667 | 947 | 11.406 | 7335.3 |
| 797 | 2024-04-28 09:05:17 | smith | 3 | 83667 | 947 | 4.923 | 16995.1 |
| 796 | 2024-04-25 20:52:09 | smith | 1 | 28756 | 8 | 0.593 | 48492.4 |
| 795 | 2024-04-05 03:05:37 | smith | 1 | 28756 | 8 | 0.593 | 48492.4 |
| 794 | 2024-04-05 03:05:29 | smith | 2 | 53800 | 83 | 2.610 | 20613.0 |
| 793 | 2024-04-04 19:54:39 | smith | 3 | 83667 | 947 | 14.500 | 5770.1 |
| 792 | 2024-04-03 11:36:08 | smith | 3 | 83667 | 947 | 3.296 | 25384.4 |
| 791 | 2024-04-03 11:36:05 | smith | 2 | 53800 | 83 | 1.640 | 32804.9 |
| 790 | 2024-04-03 11:36:00 | smith | 1 | 28756 | 8 | 0.533 | 53951.2 |
| 789 | 2024-03-30 22:20:00 | smith | 3 | 83667 | 947 | 7.203 | 11615.6 |
| 788 | 2024-03-30 22:20:01 | smith | 2 | 53800 | 83 | 3.500 | 15371.4 |
| 787 | 2024-03-30 22:18:01 | smith | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 786 | 2024-03-29 03:06:19 | smith | 2 | 53800 | 83 | 1.876 | 28678.0 |
| 785 | 2024-03-29 03:05:52 | smith | 3 | 83667 | 947 | 4.780 | 17503.6 |
| 784 | 2024-03-29 03:05:03 | smith | 3 | 83667 | 947 | 8.970 | 9327.4 |
| 783 | 2024-03-29 03:04:59 | smith | 2 | 53800 | 83 | 3.513 | 15314.5 |
| 782 | 2024-03-29 03:04:49 | smith | 1 | 28756 | 8 | 0.560 | 51350.0 |
| 781 | 2024-03-05 18:42:28 | smith | 3 | 83667 | 947 | 13.923 | 6009.3 |
| 780 | 2024-03-05 06:40:14 | smith | 2 | 53800 | 83 | 3.810 | 14120.7 |
| 779 | 2024-03-05 06:39:33 | smith | 3 | 83667 | 947 | 4.593 | 18216.2 |
| 778 | 2024-03-04 07:29:12 | smith | 3 | 83667 | 947 | 4.640 | 18031.7 |
| 777 | 2024-03-04 07:29:10 | smith | 2 | 53800 | 83 | 5.516 | 9753.4 |
| 776 | 2024-03-04 07:29:01 | smith | 1 | 28756 | 8 | 1.140 | 25224.6 |
| 775 | 2024-02-27 23:08:30 | smith | 3 | 83667 | 947 | 8.966 | 9331.6 |
| 774 | 2024-02-27 22:44:31 | smith | 3 | 83667 | 947 | 5.453 | 15343.3 |
| 773 | 2024-02-27 22:44:30 | smith | 2 | 53800 | 83 | 2.753 | 19542.3 |
| 772 | 2024-02-27 20:47:38 | smith | 1 | 28756 | 8 | 1.076 | 26724.9 |
| 771 | 2024-02-22 00:43:44 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 770 | 2024-02-03 02:45:59 | smith | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 769 | 2024-01-30 05:51:46 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 768 | 2024-01-28 20:38:05 | smith | 1 | 28756 | 8 | 0.983 | 29253.3 |
| 767 | 2024-01-12 17:09:48 | smith | 3 | 83667 | 947 | 4.030 | 20761.0 |
| 766 | 2024-01-08 23:10:29 | smith | 3 | 83667 | 947 | 4.420 | 18929.2 |
| 765 | 2024-01-05 19:00:47 | smith | 3 | 83667 | 947 | 3.326 | 25155.4 |
| 764 | 2023-11-23 19:07:13 | smith | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 763 | 2023-11-19 21:59:37 | smith | 2 | 53800 | 83 | 1.453 | 37026.8 |
| 762 | 2023-11-18 09:37:21 | smith | 2 | 53800 | 83 | 1.576 | 34137.1 |
| 761 | 2023-11-15 09:28:16 | smith | 3 | 83667 | 947 | 3.860 | 21675.4 |
| 760 | 2023-11-14 13:14:35 | smith | 3 | 83667 | 947 | 4.110 | 20356.9 |
| 759 | 2023-11-13 01:12:17 | smith | 1 | 28756 | 8 | 0.513 | 56054.6 |
| 758 | 2023-11-12 09:52:32 | smith | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 757 | 2023-11-09 01:58:43 | smith | 3 | 83667 | 947 | 3.610 | 23176.5 |
| 756 | 2023-11-07 22:19:03 | smith | 3 | 83667 | 947 | 3.533 | 23681.6 |
| 755 | 2023-11-05 19:27:09 | smith | 2 | 53800 | 83 | 1.546 | 34799.5 |
| 754 | 2023-11-05 19:27:06 | smith | 3 | 83667 | 947 | 3.843 | 21771.3 |
| 753 | 2023-11-05 12:20:31 | smith | 2 | 53800 | 83 | 1.423 | 37807.4 |
| 752 | 2023-11-04 03:16:54 | smith | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 751 | 2023-10-21 15:37:58 | smith | 3 | 83667 | 947 | 3.766 | 22216.4 |
| 750 | 2023-10-21 04:22:14 | smith | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 749 | 2023-10-18 12:28:58 | smith | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 748 | 2023-10-13 12:35:21 | smith | 3 | 83667 | 947 | 3.420 | 24464.0 |
| 747 | 2023-10-11 04:28:27 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 746 | 2023-10-07 11:23:17 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 745 | 2023-10-06 14:33:00 | smith | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 744 | 2023-09-24 12:03:36 | smith | 1 | 28756 | 8 | 0.956 | 30079.5 |
| 743 | 2023-09-13 14:53:30 | smith | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 742 | 2023-09-09 07:06:49 | smith | 1 | 28756 | 8 | 0.440 | 65354.5 |
| 741 | 2023-07-22 10:39:45 | smith | 3 | 83667 | 947 | 3.296 | 25384.4 |
| 740 | 2023-06-14 18:51:12 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 739 | 2023-06-06 13:34:34 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 738 | 2023-06-03 07:06:25 | smith | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 737 | 2023-04-03 01:23:21 | smith | 3 | 83667 | 947 | 6.563 | 12748.3 |
| 736 | 2023-03-31 17:24:03 | smith | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 735 | 2023-01-28 10:40:53 | smith | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 734 | 2023-01-24 19:18:53 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 733 | 2023-01-14 04:56:33 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 732 | 2022-12-31 07:57:20 | smith | 3 | 83667 | 947 | 3.420 | 24464.0 |
| 731 | 2022-11-25 09:03:34 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 730 | 2022-11-02 15:25:16 | smith | 1 | 28756 | 8 | 0.576 | 49923.6 |
| 729 | 2022-09-15 06:16:24 | smith | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 728 | 2022-09-03 10:43:54 | smith | 3 | 83667 | 947 | 4.076 | 20526.7 |
| 727 | 2022-07-29 07:34:29 | smith | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 726 | 2022-07-19 06:09:51 | smith | 3 | 83667 | 947 | 3.266 | 25617.6 |
| 725 | 2022-07-19 06:09:32 | smith | 2 | 53800 | 83 | 1.610 | 33416.1 |
| 724 | 2022-06-22 04:44:12 | smith | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 723 | 2022-05-28 01:22:50 | smith | 1 | 28756 | 8 | 0.596 | 48248.3 |
| 722 | 2022-05-06 00:20:54 | smith | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 721 | 2022-02-27 09:40:50 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 720 | 2022-01-19 01:16:16 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 719 | 2022-01-06 09:30:24 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 718 | 2022-01-02 03:45:28 | smith | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 717 | 2021-12-12 03:35:02 | smith | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 716 | 2021-11-24 21:02:06 | smith | 1 | 28756 | 8 | 0.533 | 53951.2 |
| 715 | 2021-11-18 14:28:31 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 714 | 2021-10-21 11:34:18 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 713 | 2021-09-28 13:51:51 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 712 | 2021-09-06 18:48:15 | smith | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 711 | 2021-07-03 19:35:29 | smith | 2 | 53800 | 83 | 1.376 | 39098.8 |
| 710 | 2021-06-02 14:40:56 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 709 | 2021-05-07 08:56:34 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 708 | 2021-04-17 07:33:45 | smith | 2 | 53800 | 83 | 1.856 | 28987.1 |
| 707 | 2021-04-04 23:29:28 | smith | 3 | 83667 | 947 | 3.580 | 23370.7 |
| 706 | 2021-03-20 03:15:03 | smith | 2 | 53800 | 83 | 1.420 | 37887.3 |
| 705 | 2021-02-27 23:42:21 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 704 | 2021-02-18 15:41:32 | smith | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 703 | 2021-02-13 05:02:52 | smith | 3 | 83667 | 947 | 3.393 | 24658.7 |
| 702 | 2021-02-03 03:29:49 | smith | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 701 | 2021-02-01 00:24:07 | smith | 1 | 28756 | 8 | 0.466 | 61708.2 |