History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shmear"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 999 | 2024-04-06 00:31:54 | shmear | 3 | 112716 | 398 | 7.033 | 16026.7 |
| 998 | 2024-04-05 13:29:31 | shmear | 2 | 82551 | 26 | 5.186 | 15918.0 |
| 997 | 2024-04-05 13:29:32 | shmear | 1 | 48755 | 5 | 1.220 | 39963.1 |
| 996 | 2024-04-05 11:50:20 | shmear | 2 | 82551 | 26 | 3.296 | 25045.8 |
| 995 | 2024-04-05 11:50:09 | shmear | 1 | 48755 | 5 | 3.983 | 12240.8 |
| 994 | 2024-04-05 11:49:52 | shmear | 3 | 112716 | 398 | 7.516 | 14996.8 |
| 993 | 2024-04-05 09:55:09 | shmear | 3 | 112716 | 398 | 10.000 | 11271.6 |
| 992 | 2024-04-03 07:36:57 | shmear | 1 | 48755 | 5 | 2.936 | 16605.9 |
| 991 | 2024-03-31 09:17:09 | shmear | 1 | 48755 | 5 | 2.766 | 17626.5 |
| 990 | 2024-03-29 21:53:19 | shmear | 2 | 82551 | 26 | 5.703 | 14475.0 |
| 989 | 2024-03-29 21:53:01 | shmear | 3 | 112716 | 398 | 11.093 | 10161.0 |
| 988 | 2024-03-29 04:16:02 | shmear | 1 | 48755 | 5 | 2.000 | 24377.5 |
| 987 | 2024-03-28 22:30:43 | shmear | 3 | 112716 | 398 | 11.470 | 9827.0 |
| 986 | 2024-03-28 22:30:10 | shmear | 3 | 112716 | 398 | 15.940 | 7071.3 |
| 985 | 2024-03-28 22:30:10 | shmear | 2 | 82551 | 26 | 3.266 | 25275.9 |
| 984 | 2024-03-28 22:30:01 | shmear | 1 | 48755 | 5 | 2.406 | 20263.9 |
| 983 | 2024-03-12 18:20:04 | shmear | 1 | 48755 | 5 | 2.406 | 20263.9 |
| 982 | 2024-03-06 08:32:02 | shmear | 2 | 82551 | 26 | 4.000 | 20637.8 |
| 981 | 2024-03-06 08:31:46 | shmear | 3 | 112716 | 398 | 19.330 | 5831.1 |
| 980 | 2024-03-06 08:31:55 | shmear | 1 | 48755 | 5 | 1.890 | 25796.3 |
| 979 | 2024-03-06 08:31:37 | shmear | 2 | 82551 | 26 | 7.516 | 10983.4 |
| 978 | 2024-03-06 08:31:34 | shmear | 1 | 48755 | 5 | 2.000 | 24377.5 |
| 977 | 2024-02-19 14:58:25 | shmear | 3 | 112716 | 398 | 27.110 | 4157.7 |
| 976 | 2024-02-14 19:21:23 | shmear | 2 | 82551 | 26 | 2.716 | 30394.3 |
| 975 | 2024-02-14 16:44:29 | shmear | 3 | 112716 | 398 | 5.423 | 20784.8 |
| 974 | 2024-02-13 13:51:16 | shmear | 3 | 112716 | 398 | 6.440 | 17502.5 |
| 973 | 2024-02-12 13:25:59 | shmear | 3 | 112716 | 398 | 4.733 | 23814.9 |
| 972 | 2023-12-17 06:16:08 | shmear | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 971 | 2023-12-02 08:03:24 | shmear | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 970 | 2023-11-26 13:41:56 | shmear | 3 | 112716 | 398 | 4.893 | 23036.2 |
| 969 | 2023-11-23 13:51:57 | shmear | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 968 | 2023-11-19 02:13:06 | shmear | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 967 | 2023-10-23 18:45:12 | shmear | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 966 | 2023-10-14 02:15:48 | shmear | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 965 | 2023-10-07 20:32:06 | shmear | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 964 | 2023-10-04 10:39:30 | shmear | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 963 | 2023-09-25 21:51:12 | shmear | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 962 | 2023-09-14 12:23:33 | shmear | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 961 | 2023-08-30 18:07:57 | shmear | 3 | 112716 | 398 | 10.050 | 11215.5 |
| 960 | 2023-08-08 20:34:24 | shmear | 3 | 112716 | 398 | 5.016 | 22471.3 |
| 959 | 2023-08-07 01:25:58 | shmear | 3 | 112716 | 398 | 4.766 | 23650.0 |
| 958 | 2023-08-02 03:07:45 | shmear | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 957 | 2023-07-15 19:28:27 | shmear | 3 | 112716 | 398 | 4.720 | 23880.5 |
| 956 | 2023-07-14 22:20:06 | shmear | 3 | 112716 | 398 | 5.110 | 22057.9 |
| 955 | 2023-07-08 13:53:43 | shmear | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 954 | 2023-05-11 16:50:25 | shmear | 3 | 112716 | 398 | 4.563 | 24702.2 |
| 953 | 2023-04-30 03:43:12 | shmear | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 952 | 2023-04-04 19:12:15 | shmear | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 951 | 2023-03-21 10:00:41 | shmear | 3 | 112716 | 398 | 9.860 | 11431.6 |
| 950 | 2023-02-19 03:38:53 | shmear | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 949 | 2023-02-10 22:28:35 | shmear | 3 | 112716 | 398 | 4.813 | 23419.1 |
| 948 | 2022-12-16 03:42:37 | shmear | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 947 | 2022-12-06 14:16:14 | shmear | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 946 | 2022-12-06 08:20:11 | shmear | 3 | 112716 | 398 | 4.953 | 22757.1 |
| 945 | 2022-12-05 20:58:43 | shmear | 3 | 112716 | 398 | 5.846 | 19280.9 |
| 944 | 2022-09-10 17:44:01 | shmear | 3 | 112716 | 398 | 5.453 | 20670.5 |
| 943 | 2022-08-26 17:18:49 | shmear | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 942 | 2022-08-06 06:43:03 | shmear | 3 | 112716 | 398 | 4.516 | 24959.3 |
| 941 | 2022-07-23 10:52:37 | shmear | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 940 | 2022-07-19 18:32:25 | shmear | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 939 | 2022-07-13 02:23:50 | shmear | 3 | 112716 | 398 | 4.610 | 24450.3 |
| 938 | 2022-06-07 04:07:06 | shmear | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 937 | 2022-05-06 14:21:15 | shmear | 2 | 82551 | 26 | 2.376 | 34743.7 |
| 936 | 2022-04-25 21:40:21 | shmear | 1 | 48755 | 5 | 1.016 | 47987.2 |
| 935 | 2022-04-17 00:22:42 | shmear | 3 | 112716 | 398 | 5.030 | 22408.7 |
| 934 | 2022-04-15 21:01:36 | shmear | 3 | 112716 | 398 | 5.000 | 22543.2 |
| 933 | 2022-04-15 05:42:06 | shmear | 3 | 112716 | 398 | 5.203 | 21663.7 |
| 932 | 2022-04-14 14:14:26 | shmear | 3 | 112716 | 398 | 5.920 | 19039.9 |
| 931 | 2022-04-13 13:01:29 | shmear | 3 | 112716 | 398 | 4.750 | 23729.7 |
| 930 | 2022-04-12 07:41:18 | shmear | 3 | 112716 | 398 | 4.826 | 23356.0 |
| 929 | 2022-04-11 23:54:43 | shmear | 3 | 112716 | 398 | 5.126 | 21989.1 |
| 928 | 2022-04-11 12:09:13 | shmear | 3 | 112716 | 398 | 5.436 | 20735.1 |
| 927 | 2022-04-10 23:55:11 | shmear | 3 | 112716 | 398 | 4.703 | 23966.8 |
| 926 | 2022-04-10 12:37:04 | shmear | 3 | 112716 | 398 | 4.720 | 23880.5 |
| 925 | 2022-04-09 21:56:29 | shmear | 3 | 112716 | 398 | 5.436 | 20735.1 |
| 924 | 2022-04-09 09:31:27 | shmear | 3 | 112716 | 398 | 4.593 | 24540.8 |
| 923 | 2022-04-07 23:59:56 | shmear | 1 | 48755 | 5 | 1.093 | 44606.6 |
| 922 | 2022-03-16 14:14:13 | shmear | 3 | 112716 | 398 | 5.640 | 19985.1 |
| 921 | 2022-03-11 23:36:16 | shmear | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 920 | 2022-01-28 22:16:05 | shmear | 3 | 112716 | 398 | 5.393 | 20900.4 |
| 919 | 2022-01-28 03:22:03 | shmear | 3 | 112716 | 398 | 5.263 | 21416.7 |
| 918 | 2022-01-27 09:31:56 | shmear | 3 | 112716 | 398 | 5.406 | 20850.2 |
| 917 | 2022-01-26 22:45:45 | shmear | 3 | 112716 | 398 | 5.610 | 20092.0 |
| 916 | 2022-01-26 13:21:11 | shmear | 3 | 112716 | 398 | 5.093 | 22131.6 |
| 915 | 2022-01-26 00:52:06 | shmear | 3 | 112716 | 398 | 5.093 | 22131.6 |
| 914 | 2022-01-25 05:19:45 | shmear | 3 | 112716 | 398 | 4.843 | 23274.0 |
| 913 | 2022-01-24 22:27:10 | shmear | 3 | 112716 | 398 | 4.656 | 24208.8 |
| 912 | 2022-01-24 00:51:44 | shmear | 3 | 112716 | 398 | 5.063 | 22262.7 |
| 911 | 2022-01-21 20:52:50 | shmear | 3 | 112716 | 398 | 8.000 | 14089.5 |
| 910 | 2022-01-21 09:03:43 | shmear | 3 | 112716 | 398 | 4.860 | 23192.6 |
| 909 | 2022-01-20 16:52:32 | shmear | 3 | 112716 | 398 | 5.200 | 21676.2 |
| 908 | 2022-01-20 04:51:41 | shmear | 3 | 112716 | 398 | 7.110 | 15853.2 |
| 907 | 2022-01-19 17:49:04 | shmear | 3 | 112716 | 398 | 5.516 | 20434.4 |
| 906 | 2022-01-19 02:13:30 | shmear | 3 | 112716 | 398 | 5.140 | 21929.2 |
| 905 | 2022-01-18 14:12:33 | shmear | 3 | 112716 | 398 | 5.266 | 21404.5 |
| 904 | 2022-01-09 18:31:17 | shmear | 3 | 112716 | 398 | 5.156 | 21861.1 |
| 903 | 2022-01-07 19:33:03 | shmear | 3 | 112716 | 398 | 4.813 | 23419.1 |
| 902 | 2022-01-06 20:06:39 | shmear | 3 | 112716 | 398 | 5.843 | 19290.8 |
| 901 | 2022-01-05 07:27:48 | shmear | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 900 | 2022-01-02 23:06:53 | shmear | 3 | 112716 | 398 | 5.563 | 20261.7 |