History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aspens"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 847 | 2024-04-30 05:44:36 | aspens | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 846 | 2024-04-29 17:53:06 | aspens | 3 | 112716 | 912 | 11.750 | 9592.9 |
| 845 | 2024-04-29 17:16:54 | aspens | 3 | 112716 | 912 | 10.420 | 10817.3 |
| 844 | 2024-04-29 17:16:58 | aspens | 2 | 82551 | 59 | 2.610 | 31628.7 |
| 843 | 2024-04-29 17:16:45 | aspens | 2 | 82551 | 59 | 7.533 | 10958.6 |
| 842 | 2024-04-29 17:16:50 | aspens | 1 | 48755 | 4 | 1.250 | 39004.0 |
| 841 | 2024-04-29 17:16:13 | aspens | 3 | 112716 | 912 | 5.923 | 19030.2 |
| 840 | 2024-04-28 08:25:55 | aspens | 3 | 112716 | 912 | 9.843 | 11451.4 |
| 839 | 2024-04-27 03:11:48 | aspens | 1 | 48755 | 4 | 1.000 | 48755.0 |
| 838 | 2024-04-04 18:57:37 | aspens | 1 | 48755 | 4 | 1.296 | 37619.6 |
| 837 | 2024-03-31 04:58:42 | aspens | 1 | 48755 | 4 | 3.516 | 13866.6 |
| 836 | 2024-03-04 00:19:52 | aspens | 1 | 48755 | 4 | 2.983 | 16344.3 |
| 835 | 2024-01-25 16:39:51 | aspens | 2 | 82551 | 59 | 2.296 | 35954.3 |
| 834 | 2024-01-25 16:39:39 | aspens | 3 | 112716 | 912 | 5.420 | 20796.3 |
| 833 | 2024-01-23 20:47:45 | aspens | 3 | 112716 | 912 | 5.516 | 20434.4 |
| 832 | 2024-01-20 00:18:04 | aspens | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 831 | 2024-01-07 15:49:56 | aspens | 3 | 112716 | 912 | 6.280 | 17948.4 |
| 830 | 2023-12-25 20:10:40 | aspens | 3 | 112716 | 912 | 5.233 | 21539.5 |
| 829 | 2023-12-25 20:10:39 | aspens | 2 | 82551 | 59 | 2.470 | 33421.5 |
| 828 | 2023-12-23 20:10:03 | aspens | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 827 | 2023-12-21 16:41:10 | aspens | 2 | 82551 | 59 | 2.156 | 38289.0 |
| 826 | 2023-12-20 15:35:14 | aspens | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 825 | 2023-12-19 07:00:24 | aspens | 3 | 112716 | 912 | 4.796 | 23502.1 |
| 824 | 2023-11-23 10:17:40 | aspens | 3 | 112716 | 912 | 4.703 | 23966.8 |
| 823 | 2023-11-22 09:26:40 | aspens | 1 | 48755 | 4 | 0.920 | 52994.6 |
| 822 | 2023-11-21 08:49:15 | aspens | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 821 | 2023-11-16 11:08:38 | aspens | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 820 | 2023-11-12 16:58:04 | aspens | 1 | 48755 | 4 | 0.893 | 54596.9 |
| 819 | 2023-11-03 16:19:41 | aspens | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 818 | 2023-10-30 06:35:53 | aspens | 3 | 112716 | 912 | 5.690 | 19809.5 |
| 817 | 2023-10-26 15:20:52 | aspens | 3 | 112716 | 912 | 6.000 | 18786.0 |
| 816 | 2023-10-25 10:33:09 | aspens | 3 | 112716 | 912 | 6.533 | 17253.3 |
| 815 | 2023-10-24 15:36:32 | aspens | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 814 | 2023-10-24 01:45:14 | aspens | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 813 | 2023-10-24 00:54:18 | aspens | 3 | 112716 | 912 | 6.546 | 17219.1 |
| 812 | 2023-10-22 19:38:48 | aspens | 3 | 112716 | 912 | 6.423 | 17548.8 |
| 811 | 2023-10-20 15:37:33 | aspens | 3 | 112716 | 912 | 6.173 | 18259.5 |
| 810 | 2023-10-19 06:55:34 | aspens | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 809 | 2023-10-13 19:43:49 | aspens | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 808 | 2023-10-06 05:09:49 | aspens | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 807 | 2023-09-28 00:44:36 | aspens | 3 | 112716 | 912 | 8.266 | 13636.1 |
| 806 | 2023-09-26 21:55:54 | aspens | 2 | 82551 | 59 | 2.360 | 34979.2 |
| 805 | 2023-09-25 15:23:02 | aspens | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 804 | 2023-09-24 13:09:19 | aspens | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 803 | 2023-09-21 14:45:31 | aspens | 2 | 82551 | 59 | 2.156 | 38289.0 |
| 802 | 2023-09-19 16:18:45 | aspens | 3 | 112716 | 912 | 5.563 | 20261.7 |
| 801 | 2023-09-17 22:10:01 | aspens | 3 | 112716 | 912 | 5.860 | 19234.8 |
| 800 | 2023-09-14 12:17:43 | aspens | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 799 | 2023-09-07 07:11:56 | aspens | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 798 | 2023-09-03 06:27:30 | aspens | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 797 | 2023-08-27 13:42:37 | aspens | 3 | 112716 | 912 | 5.513 | 20445.5 |
| 796 | 2023-07-07 10:28:37 | aspens | 3 | 112716 | 912 | 4.780 | 23580.8 |
| 795 | 2023-06-29 18:33:47 | aspens | 2 | 82551 | 59 | 2.156 | 38289.0 |
| 794 | 2023-06-10 12:51:59 | aspens | 3 | 112716 | 912 | 5.296 | 21283.2 |
| 793 | 2023-06-08 08:41:31 | aspens | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 792 | 2023-05-31 06:35:52 | aspens | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 791 | 2023-05-28 00:51:43 | aspens | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 790 | 2023-05-14 18:07:37 | aspens | 3 | 112716 | 912 | 5.360 | 21029.1 |
| 789 | 2023-04-24 06:39:43 | aspens | 3 | 112716 | 912 | 5.143 | 21916.4 |
| 788 | 2023-04-20 03:13:44 | aspens | 3 | 112716 | 912 | 4.656 | 24208.8 |
| 787 | 2023-03-28 19:33:49 | aspens | 3 | 112716 | 912 | 4.640 | 24292.2 |
| 786 | 2023-03-27 18:35:52 | aspens | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 785 | 2023-03-23 02:31:16 | aspens | 2 | 82551 | 59 | 2.483 | 33246.5 |
| 784 | 2023-03-10 23:50:24 | aspens | 3 | 112716 | 912 | 4.736 | 23799.8 |
| 783 | 2023-02-22 02:03:29 | aspens | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 782 | 2023-01-11 00:06:52 | aspens | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 781 | 2022-12-23 23:58:34 | aspens | 2 | 82551 | 59 | 2.110 | 39123.7 |
| 780 | 2022-12-17 12:00:51 | aspens | 3 | 112716 | 912 | 5.403 | 20861.7 |
| 779 | 2022-11-15 18:26:06 | aspens | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 778 | 2022-10-17 07:05:14 | aspens | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 777 | 2022-09-10 15:00:36 | aspens | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 776 | 2022-08-30 21:17:12 | aspens | 3 | 112716 | 912 | 4.623 | 24381.6 |
| 775 | 2022-08-27 03:40:20 | aspens | 3 | 112716 | 912 | 4.720 | 23880.5 |
| 774 | 2022-08-26 05:03:31 | aspens | 3 | 112716 | 912 | 5.436 | 20735.1 |
| 773 | 2022-08-25 03:13:33 | aspens | 3 | 112716 | 912 | 6.110 | 18447.8 |
| 772 | 2022-08-24 08:49:59 | aspens | 3 | 112716 | 912 | 12.206 | 9234.5 |
| 771 | 2022-08-23 09:33:13 | aspens | 3 | 112716 | 912 | 5.670 | 19879.4 |
| 770 | 2022-08-22 06:51:00 | aspens | 3 | 112716 | 912 | 9.110 | 12372.8 |
| 769 | 2022-08-21 13:48:00 | aspens | 3 | 112716 | 912 | 6.046 | 18643.1 |
| 768 | 2022-08-21 01:09:31 | aspens | 2 | 82551 | 59 | 2.173 | 37989.4 |
| 767 | 2022-08-20 10:10:50 | aspens | 3 | 112716 | 912 | 6.170 | 18268.4 |
| 766 | 2022-08-19 13:11:54 | aspens | 3 | 112716 | 912 | 11.563 | 9748.0 |
| 765 | 2022-08-09 19:58:13 | aspens | 3 | 112716 | 912 | 5.063 | 22262.7 |
| 764 | 2022-08-09 02:38:31 | aspens | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 763 | 2022-08-07 11:52:17 | aspens | 3 | 112716 | 912 | 4.610 | 24450.3 |
| 762 | 2022-06-07 23:59:01 | aspens | 3 | 112716 | 912 | 4.750 | 23729.7 |
| 761 | 2022-06-05 18:31:23 | aspens | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 760 | 2022-04-29 00:44:51 | aspens | 1 | 48755 | 4 | 1.000 | 48755.0 |
| 759 | 2022-04-25 00:36:51 | aspens | 3 | 112716 | 912 | 5.250 | 21469.7 |
| 758 | 2022-03-12 23:46:44 | aspens | 3 | 112716 | 912 | 5.500 | 20493.8 |
| 757 | 2022-03-04 08:48:03 | aspens | 3 | 112716 | 912 | 5.843 | 19290.8 |
| 756 | 2022-02-15 14:37:21 | aspens | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 755 | 2022-01-25 15:21:46 | aspens | 1 | 48755 | 4 | 0.986 | 49447.3 |
| 754 | 2021-12-04 23:55:31 | aspens | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 753 | 2021-10-25 06:02:59 | aspens | 1 | 48755 | 4 | 0.893 | 54596.9 |
| 752 | 2021-10-20 15:06:48 | aspens | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 751 | 2021-09-12 16:20:16 | aspens | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 750 | 2021-08-23 22:09:13 | aspens | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 749 | 2021-07-21 23:38:02 | aspens | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 748 | 2021-06-24 18:27:24 | aspens | 3 | 112716 | 912 | 6.063 | 18590.8 |