History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pecan"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 973 | 2024-04-28 06:57:27 | pecan | 2 | 53800 | 93 | 3.953 | 13609.9 |
| 972 | 2024-04-28 06:56:40 | pecan | 3 | 83667 | 1098 | 4.313 | 19398.8 |
| 971 | 2024-04-27 04:26:10 | pecan | 3 | 83667 | 1098 | 7.160 | 11685.3 |
| 970 | 2024-04-25 05:57:25 | pecan | 2 | 53800 | 93 | 1.716 | 31352.0 |
| 969 | 2024-04-25 05:56:52 | pecan | 3 | 83667 | 1098 | 6.440 | 12991.8 |
| 968 | 2024-04-24 17:22:57 | pecan | 3 | 83667 | 1098 | 3.970 | 21074.8 |
| 967 | 2024-04-24 17:17:07 | pecan | 3 | 83667 | 1098 | 14.673 | 5702.1 |
| 966 | 2024-04-06 06:07:46 | pecan | 1 | 28756 | 5 | 0.593 | 48492.4 |
| 965 | 2024-03-31 15:48:11 | pecan | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 964 | 2024-03-27 06:08:07 | pecan | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 963 | 2024-03-26 02:06:14 | pecan | 2 | 53800 | 93 | 1.596 | 33709.3 |
| 962 | 2024-03-26 02:06:10 | pecan | 3 | 83667 | 1098 | 4.093 | 20441.5 |
| 961 | 2024-03-26 02:06:04 | pecan | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 960 | 2024-03-26 02:05:53 | pecan | 2 | 53800 | 93 | 1.593 | 33772.8 |
| 959 | 2024-03-26 02:05:21 | pecan | 3 | 83667 | 1098 | 3.920 | 21343.6 |
| 958 | 2024-03-23 18:39:20 | pecan | 3 | 83667 | 1098 | 13.110 | 6381.9 |
| 957 | 2024-03-07 04:22:39 | pecan | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 956 | 2024-03-05 18:07:42 | pecan | 1 | 28756 | 5 | 1.140 | 25224.6 |
| 955 | 2024-03-01 12:00:57 | pecan | 1 | 28756 | 5 | 1.640 | 17534.1 |
| 954 | 2024-02-26 01:30:19 | pecan | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 953 | 2024-02-21 03:51:42 | pecan | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 952 | 2024-02-03 23:27:11 | pecan | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 951 | 2024-01-31 12:14:31 | pecan | 2 | 53800 | 93 | 1.610 | 33416.1 |
| 950 | 2024-01-31 12:14:08 | pecan | 3 | 83667 | 1098 | 3.390 | 24680.5 |
| 949 | 2024-01-30 20:07:07 | pecan | 2 | 53800 | 93 | 1.750 | 30742.9 |
| 948 | 2024-01-30 20:06:43 | pecan | 3 | 83667 | 1098 | 3.830 | 21845.2 |
| 947 | 2024-01-30 16:23:07 | pecan | 1 | 28756 | 5 | 1.030 | 27918.4 |
| 946 | 2024-01-30 10:05:45 | pecan | 2 | 53800 | 93 | 3.313 | 16239.1 |
| 945 | 2024-01-30 10:05:17 | pecan | 3 | 83667 | 1098 | 4.050 | 20658.5 |
| 944 | 2024-01-30 08:58:00 | pecan | 3 | 83667 | 1098 | 4.000 | 20916.8 |
| 943 | 2024-01-26 21:07:49 | pecan | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 942 | 2024-01-22 14:02:40 | pecan | 3 | 83667 | 1098 | 3.250 | 25743.7 |
| 941 | 2024-01-12 07:31:36 | pecan | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 940 | 2023-12-31 15:06:30 | pecan | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 939 | 2023-12-21 00:39:51 | pecan | 3 | 83667 | 1098 | 3.530 | 23701.7 |
| 938 | 2023-12-14 01:46:11 | pecan | 3 | 83667 | 1098 | 3.673 | 22778.9 |
| 937 | 2023-12-14 01:46:02 | pecan | 2 | 53800 | 93 | 1.356 | 39675.5 |
| 936 | 2023-12-13 17:12:53 | pecan | 3 | 83667 | 1098 | 3.343 | 25027.5 |
| 935 | 2023-12-05 11:05:37 | pecan | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 934 | 2023-11-25 20:34:28 | pecan | 3 | 83667 | 1098 | 4.360 | 19189.7 |
| 933 | 2023-11-25 20:34:21 | pecan | 2 | 53800 | 93 | 1.563 | 34421.0 |
| 932 | 2023-11-21 20:17:33 | pecan | 3 | 83667 | 1098 | 4.143 | 20194.8 |
| 931 | 2023-11-21 20:17:25 | pecan | 2 | 53800 | 93 | 1.560 | 34487.2 |
| 930 | 2023-11-12 07:43:44 | pecan | 1 | 28756 | 5 | 0.640 | 44931.3 |
| 929 | 2023-11-09 05:53:00 | pecan | 2 | 53800 | 93 | 1.436 | 37465.2 |
| 928 | 2023-11-09 05:52:56 | pecan | 3 | 83667 | 1098 | 3.703 | 22594.4 |
| 927 | 2023-11-07 23:17:16 | pecan | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 926 | 2023-10-28 19:52:31 | pecan | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 925 | 2023-10-21 22:12:22 | pecan | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 924 | 2023-10-18 17:46:16 | pecan | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 923 | 2023-10-11 07:36:35 | pecan | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 922 | 2023-10-05 17:36:03 | pecan | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 921 | 2023-09-30 14:07:28 | pecan | 3 | 83667 | 1098 | 3.283 | 25484.9 |
| 920 | 2023-09-28 00:17:37 | pecan | 3 | 83667 | 1098 | 3.876 | 21585.9 |
| 919 | 2023-09-26 12:41:19 | pecan | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 918 | 2023-09-22 08:37:00 | pecan | 1 | 28756 | 5 | 0.890 | 32310.1 |
| 917 | 2023-09-21 03:50:01 | pecan | 3 | 83667 | 1098 | 3.280 | 25508.2 |
| 916 | 2023-09-20 10:55:21 | pecan | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 915 | 2023-09-19 09:18:13 | pecan | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 914 | 2023-09-16 01:17:12 | pecan | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 913 | 2023-07-15 08:55:16 | pecan | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 912 | 2023-06-24 16:38:51 | pecan | 3 | 83667 | 1098 | 3.513 | 23816.4 |
| 911 | 2023-06-23 04:48:34 | pecan | 2 | 53800 | 93 | 1.390 | 38705.0 |
| 910 | 2023-06-09 22:17:30 | pecan | 2 | 53800 | 93 | 1.376 | 39098.8 |
| 909 | 2023-05-29 23:32:06 | pecan | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 908 | 2023-04-20 09:41:39 | pecan | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 907 | 2023-03-18 01:17:12 | pecan | 3 | 83667 | 1098 | 3.250 | 25743.7 |
| 906 | 2023-02-17 05:41:43 | pecan | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 905 | 2023-02-05 19:26:08 | pecan | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 904 | 2022-12-20 11:30:05 | pecan | 3 | 83667 | 1098 | 3.250 | 25743.7 |
| 903 | 2022-12-04 15:21:39 | pecan | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 902 | 2022-11-09 06:26:56 | pecan | 3 | 83667 | 1098 | 3.720 | 22491.1 |
| 901 | 2022-10-31 03:48:54 | pecan | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 900 | 2022-09-14 21:08:19 | pecan | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 899 | 2022-09-10 17:26:30 | pecan | 3 | 83667 | 1098 | 3.310 | 25277.0 |
| 898 | 2022-08-15 06:13:36 | pecan | 3 | 83667 | 1098 | 3.343 | 25027.5 |
| 897 | 2022-08-03 01:30:31 | pecan | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 896 | 2022-07-31 18:33:21 | pecan | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 895 | 2022-07-13 21:55:15 | pecan | 1 | 28756 | 5 | 0.543 | 52957.6 |
| 894 | 2022-06-19 09:37:21 | pecan | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 893 | 2022-05-16 03:06:54 | pecan | 3 | 83667 | 1098 | 3.813 | 21942.6 |
| 892 | 2022-05-08 13:55:16 | pecan | 3 | 83667 | 1098 | 3.283 | 25484.9 |
| 891 | 2022-05-07 00:57:04 | pecan | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 890 | 2022-05-06 09:03:27 | pecan | 1 | 28756 | 5 | 0.593 | 48492.4 |
| 889 | 2022-05-05 21:42:40 | pecan | 2 | 53800 | 93 | 1.563 | 34421.0 |
| 888 | 2022-05-05 08:59:05 | pecan | 1 | 28756 | 5 | 0.593 | 48492.4 |
| 887 | 2022-05-04 20:32:16 | pecan | 2 | 53800 | 93 | 1.626 | 33087.3 |
| 886 | 2022-05-03 20:58:30 | pecan | 2 | 53800 | 93 | 1.860 | 28924.7 |
| 885 | 2022-04-07 23:54:28 | pecan | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 884 | 2022-03-27 03:05:27 | pecan | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 883 | 2022-03-25 20:49:48 | pecan | 2 | 53800 | 93 | 1.593 | 33772.8 |
| 882 | 2022-03-23 18:40:11 | pecan | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 881 | 2022-03-23 17:18:59 | pecan | 2 | 53800 | 93 | 1.406 | 38264.6 |
| 880 | 2022-02-25 02:27:35 | pecan | 2 | 53800 | 93 | 1.440 | 37361.1 |
| 879 | 2022-02-24 08:48:24 | pecan | 2 | 53800 | 93 | 1.970 | 27309.6 |
| 878 | 2022-02-23 17:42:58 | pecan | 2 | 53800 | 93 | 1.500 | 35866.7 |
| 877 | 2022-02-22 22:31:45 | pecan | 2 | 53800 | 93 | 1.576 | 34137.1 |
| 876 | 2022-02-22 03:15:23 | pecan | 2 | 53800 | 93 | 1.453 | 37026.8 |
| 875 | 2022-02-21 07:01:26 | pecan | 2 | 53800 | 93 | 1.440 | 37361.1 |
| 874 | 2022-02-20 18:23:08 | pecan | 2 | 53800 | 93 | 4.280 | 12570.1 |