History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"psalm"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1003 | 2024-05-01 08:38:36 | psalm | 2 | 53800 | 38 | 2.326 | 23129.8 |
| 1002 | 2024-05-01 08:34:47 | psalm | 3 | 83667 | 710 | 4.406 | 18989.3 |
| 1001 | 2024-05-01 08:34:43 | psalm | 3 | 83667 | 710 | 7.206 | 11610.7 |
| 1000 | 2024-05-01 08:34:44 | psalm | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 999 | 2024-05-01 08:34:39 | psalm | 2 | 53800 | 38 | 1.640 | 32804.9 |
| 998 | 2024-05-01 08:34:36 | psalm | 1 | 28756 | 3 | 1.046 | 27491.4 |
| 997 | 2024-04-30 01:02:21 | psalm | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 996 | 2024-04-26 08:27:25 | psalm | 3 | 83667 | 710 | 4.000 | 20916.8 |
| 995 | 2024-04-24 02:41:03 | psalm | 1 | 28756 | 3 | 0.766 | 37540.5 |
| 994 | 2024-04-06 06:52:58 | psalm | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 993 | 2024-03-31 18:18:29 | psalm | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 992 | 2024-03-28 18:32:06 | psalm | 1 | 28756 | 3 | 2.233 | 12877.7 |
| 991 | 2024-03-18 09:33:36 | psalm | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 990 | 2024-03-16 00:26:53 | psalm | 2 | 53800 | 38 | 1.596 | 33709.3 |
| 989 | 2024-03-16 00:25:46 | psalm | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 988 | 2024-03-16 00:25:21 | psalm | 3 | 83667 | 710 | 3.673 | 22778.9 |
| 987 | 2024-03-15 19:18:28 | psalm | 3 | 83667 | 710 | 3.903 | 21436.6 |
| 986 | 2024-03-09 18:16:41 | psalm | 3 | 83667 | 710 | 9.593 | 8721.7 |
| 985 | 2024-03-07 08:47:45 | psalm | 3 | 83667 | 710 | 11.063 | 7562.8 |
| 984 | 2024-03-07 08:47:41 | psalm | 2 | 53800 | 38 | 5.503 | 9776.5 |
| 983 | 2024-03-07 05:44:27 | psalm | 1 | 28756 | 3 | 0.420 | 68466.7 |
| 982 | 2024-03-01 12:21:44 | psalm | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 981 | 2024-02-28 12:22:03 | psalm | 3 | 83667 | 710 | 3.873 | 21602.6 |
| 980 | 2024-02-28 12:21:54 | psalm | 2 | 53800 | 38 | 1.580 | 34050.6 |
| 979 | 2024-02-26 22:44:28 | psalm | 2 | 53800 | 38 | 1.423 | 37807.4 |
| 978 | 2024-02-26 19:35:44 | psalm | 1 | 28756 | 3 | 0.686 | 41918.4 |
| 977 | 2024-02-03 19:51:11 | psalm | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 976 | 2024-02-01 05:25:40 | psalm | 2 | 53800 | 38 | 1.720 | 31279.1 |
| 975 | 2024-02-01 05:25:12 | psalm | 3 | 83667 | 710 | 3.596 | 23266.7 |
| 974 | 2024-01-28 00:14:03 | psalm | 3 | 83667 | 710 | 3.660 | 22859.8 |
| 973 | 2023-12-25 19:45:08 | psalm | 3 | 83667 | 710 | 3.766 | 22216.4 |
| 972 | 2023-12-25 19:45:07 | psalm | 2 | 53800 | 38 | 1.516 | 35488.1 |
| 971 | 2023-12-18 07:38:33 | psalm | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 970 | 2023-12-07 21:45:19 | psalm | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 969 | 2023-12-07 21:45:18 | psalm | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 968 | 2023-11-20 00:34:12 | psalm | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 967 | 2023-11-12 07:44:23 | psalm | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 966 | 2023-11-10 12:07:47 | psalm | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 965 | 2023-10-29 22:32:04 | psalm | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 964 | 2023-10-11 03:18:25 | psalm | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 963 | 2023-10-05 22:39:43 | psalm | 3 | 83667 | 710 | 3.186 | 26260.8 |
| 962 | 2023-10-05 17:31:29 | psalm | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 961 | 2023-10-04 23:45:05 | psalm | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 960 | 2023-10-01 14:14:27 | psalm | 3 | 83667 | 710 | 4.110 | 20356.9 |
| 959 | 2023-10-01 14:14:26 | psalm | 2 | 53800 | 38 | 1.656 | 32487.9 |
| 958 | 2023-09-29 08:05:31 | psalm | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 957 | 2023-09-24 15:42:05 | psalm | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 956 | 2023-08-20 01:22:24 | psalm | 3 | 83667 | 710 | 3.516 | 23796.1 |
| 955 | 2023-08-02 05:14:34 | psalm | 1 | 28756 | 3 | 0.420 | 68466.7 |
| 954 | 2023-05-01 05:25:26 | psalm | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 953 | 2023-02-22 03:14:17 | psalm | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 952 | 2022-12-29 06:35:54 | psalm | 3 | 83667 | 710 | 3.953 | 21165.4 |
| 951 | 2022-12-21 08:29:51 | psalm | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 950 | 2022-11-17 22:36:19 | psalm | 3 | 83667 | 710 | 3.266 | 25617.6 |
| 949 | 2022-11-13 05:37:34 | psalm | 3 | 83667 | 710 | 3.673 | 22778.9 |
| 948 | 2022-10-29 16:21:32 | psalm | 3 | 83667 | 710 | 4.156 | 20131.6 |
| 947 | 2022-10-25 09:55:08 | psalm | 3 | 83667 | 710 | 4.936 | 16950.4 |
| 946 | 2022-10-09 17:17:23 | psalm | 3 | 83667 | 710 | 3.656 | 22884.8 |
| 945 | 2022-10-01 12:56:26 | psalm | 3 | 83667 | 710 | 3.296 | 25384.4 |
| 944 | 2022-09-08 03:47:06 | psalm | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 943 | 2022-09-06 00:23:14 | psalm | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 942 | 2022-09-03 22:18:31 | psalm | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 941 | 2022-04-14 23:19:14 | psalm | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 940 | 2022-01-31 00:09:28 | psalm | 3 | 83667 | 710 | 4.016 | 20833.4 |
| 939 | 2022-01-15 00:35:42 | psalm | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 938 | 2022-01-11 05:13:27 | psalm | 3 | 83667 | 710 | 4.076 | 20526.7 |
| 937 | 2022-01-10 00:22:18 | psalm | 3 | 83667 | 710 | 3.733 | 22412.8 |
| 936 | 2022-01-09 11:49:46 | psalm | 3 | 83667 | 710 | 8.500 | 9843.2 |
| 935 | 2022-01-08 20:56:27 | psalm | 3 | 83667 | 710 | 4.000 | 20916.8 |
| 934 | 2022-01-08 01:44:46 | psalm | 3 | 83667 | 710 | 3.453 | 24230.2 |
| 933 | 2022-01-07 14:00:45 | psalm | 3 | 83667 | 710 | 3.860 | 21675.4 |
| 932 | 2022-01-06 21:50:10 | psalm | 3 | 83667 | 710 | 3.470 | 24111.5 |
| 931 | 2022-01-06 00:28:25 | psalm | 3 | 83667 | 710 | 3.936 | 21256.9 |
| 930 | 2022-01-02 16:01:11 | psalm | 3 | 83667 | 710 | 3.843 | 21771.3 |
| 929 | 2022-01-01 19:55:24 | psalm | 3 | 83667 | 710 | 3.546 | 23594.8 |
| 928 | 2022-01-01 13:05:03 | psalm | 3 | 83667 | 710 | 3.860 | 21675.4 |
| 927 | 2022-01-01 10:10:52 | psalm | 3 | 83667 | 710 | 3.453 | 24230.2 |
| 926 | 2021-12-31 18:04:56 | psalm | 3 | 83667 | 710 | 7.936 | 10542.7 |
| 925 | 2021-12-31 06:48:38 | psalm | 3 | 83667 | 710 | 3.390 | 24680.5 |
| 924 | 2021-12-30 13:47:25 | psalm | 3 | 83667 | 710 | 3.953 | 21165.4 |
| 923 | 2021-12-30 11:12:37 | psalm | 3 | 83667 | 710 | 3.986 | 20990.2 |
| 922 | 2021-12-29 22:56:12 | psalm | 3 | 83667 | 710 | 3.310 | 25277.0 |
| 921 | 2021-12-29 14:39:50 | psalm | 3 | 83667 | 710 | 3.656 | 22884.8 |
| 920 | 2021-12-29 13:37:44 | psalm | 3 | 83667 | 710 | 8.063 | 10376.7 |
| 919 | 2021-12-29 11:19:20 | psalm | 3 | 83667 | 710 | 3.906 | 21420.1 |
| 918 | 2021-12-28 14:14:20 | psalm | 3 | 83667 | 710 | 4.470 | 18717.4 |
| 917 | 2021-12-28 13:23:34 | psalm | 3 | 83667 | 710 | 3.970 | 21074.8 |
| 916 | 2021-12-28 10:21:03 | psalm | 3 | 83667 | 710 | 3.860 | 21675.4 |
| 915 | 2021-12-27 18:23:12 | psalm | 3 | 83667 | 710 | 3.360 | 24900.9 |
| 914 | 2021-12-27 14:13:21 | psalm | 3 | 83667 | 710 | 3.263 | 25641.1 |
| 913 | 2021-12-27 13:26:02 | psalm | 3 | 83667 | 710 | 3.406 | 24564.6 |
| 912 | 2021-12-27 08:17:20 | psalm | 3 | 83667 | 710 | 3.266 | 25617.6 |
| 911 | 2021-12-26 16:02:34 | psalm | 3 | 83667 | 710 | 3.453 | 24230.2 |
| 910 | 2021-12-26 14:27:46 | psalm | 3 | 83667 | 710 | 3.876 | 21585.9 |
| 909 | 2021-12-26 13:23:49 | psalm | 3 | 83667 | 710 | 5.110 | 16373.2 |
| 908 | 2021-12-26 05:17:31 | psalm | 3 | 83667 | 710 | 3.530 | 23701.7 |
| 907 | 2021-12-25 16:22:31 | psalm | 3 | 83667 | 710 | 3.186 | 26260.8 |
| 906 | 2021-12-25 14:31:18 | psalm | 3 | 83667 | 710 | 3.250 | 25743.7 |
| 905 | 2021-12-25 13:40:39 | psalm | 3 | 83667 | 710 | 3.326 | 25155.4 |
| 904 | 2021-12-25 03:42:53 | psalm | 3 | 83667 | 710 | 3.843 | 21771.3 |