History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oca"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1031 | 2025-10-24 21:57:17 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1030 | 2025-10-24 21:48:54 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
| 1029 | 2025-10-18 07:07:35 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1028 | 2025-10-17 08:58:58 | oca | 1 | 5146 | 11 | 0.186 | 27666.7 |
| 1027 | 2025-10-17 02:41:32 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1026 | 2025-10-07 17:50:43 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1025 | 2025-10-05 18:10:27 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1024 | 2025-10-01 15:45:40 | oca | 1 | 5146 | 11 | 0.096 | 53604.2 |
| 1023 | 2025-09-30 19:49:30 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1022 | 2025-09-26 09:16:28 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
| 1021 | 2025-09-25 09:31:01 | oca | 2 | 14084 | 267 | 1.593 | 8841.2 |
| 1020 | 2025-09-25 09:30:41 | oca | 2 | 14084 | 267 | 2.203 | 6393.1 |
| 1019 | 2025-09-25 09:30:28 | oca | 2 | 14084 | 267 | 1.970 | 7149.2 |
| 1018 | 2025-09-25 09:30:22 | oca | 2 | 14084 | 267 | 1.936 | 7274.8 |
| 1017 | 2025-09-24 22:32:30 | oca | 1 | 5146 | 11 | 0.096 | 53604.2 |
| 1016 | 2025-09-18 07:39:34 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1015 | 2025-09-15 01:33:37 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 1014 | 2025-09-14 16:12:30 | oca | 1 | 5146 | 11 | 0.096 | 53604.2 |
| 1013 | 2025-09-14 06:39:33 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1012 | 2025-09-10 01:21:02 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
| 1011 | 2025-09-08 02:00:58 | oca | 2 | 14084 | 267 | 0.436 | 32302.8 |
| 1010 | 2025-09-07 22:05:47 | oca | 2 | 14084 | 267 | 0.390 | 36112.8 |
| 1009 | 2025-09-07 14:46:29 | oca | 2 | 14084 | 267 | 1.376 | 10235.5 |
| 1008 | 2025-09-05 20:38:05 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
| 1007 | 2025-09-05 14:10:45 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 1006 | 2025-09-04 12:27:50 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
| 1005 | 2025-09-02 23:49:07 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 1004 | 2025-08-28 17:01:53 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 1003 | 2025-08-25 07:50:02 | oca | 1 | 5146 | 11 | 0.106 | 48547.2 |
| 1002 | 2025-08-16 15:04:00 | oca | 1 | 5146 | 11 | 0.080 | 64325.0 |
| 1001 | 2025-08-09 12:22:52 | oca | 1 | 5146 | 11 | 0.513 | 10031.2 |
| 1000 | 2025-08-03 20:17:54 | oca | 1 | 5146 | 11 | 0.203 | 25349.8 |
| 999 | 2025-08-03 19:44:56 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 998 | 2025-08-01 20:00:35 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 997 | 2025-08-01 10:00:42 | oca | 2 | 14084 | 267 | 2.063 | 6827.0 |
| 996 | 2025-07-31 03:54:49 | oca | 1 | 5146 | 11 | 0.483 | 10654.2 |
| 995 | 2025-07-28 20:19:31 | oca | 2 | 14084 | 267 | 0.830 | 16968.7 |
| 994 | 2025-07-28 20:19:30 | oca | 2 | 14084 | 267 | 0.780 | 18056.4 |
| 993 | 2025-07-26 20:29:45 | oca | 1 | 5146 | 11 | 0.623 | 8260.0 |
| 992 | 2025-07-26 05:08:27 | oca | 2 | 14084 | 267 | 0.390 | 36112.8 |
| 991 | 2025-07-24 09:34:09 | oca | 2 | 14084 | 267 | 0.923 | 15258.9 |
| 990 | 2025-07-23 09:26:31 | oca | 1 | 5146 | 11 | 0.703 | 7320.1 |
| 989 | 2025-07-23 03:30:30 | oca | 1 | 5146 | 11 | 0.330 | 15593.9 |
| 988 | 2025-07-22 21:08:04 | oca | 1 | 5146 | 11 | 0.203 | 25349.8 |
| 987 | 2025-07-21 14:08:16 | oca | 2 | 14084 | 267 | 0.390 | 36112.8 |
| 986 | 2025-07-20 17:24:54 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 985 | 2025-07-18 23:56:14 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 984 | 2025-07-18 09:15:13 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 983 | 2025-07-18 07:23:04 | oca | 1 | 5146 | 11 | 0.470 | 10948.9 |
| 982 | 2025-07-09 11:32:19 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 981 | 2025-07-07 12:39:58 | oca | 1 | 5146 | 11 | 0.563 | 9140.3 |
| 980 | 2025-07-07 12:12:18 | oca | 2 | 14084 | 267 | 2.266 | 6215.4 |
| 979 | 2025-07-05 13:47:46 | oca | 2 | 14084 | 267 | 1.626 | 8661.7 |
| 978 | 2025-07-03 19:35:13 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 977 | 2025-07-02 10:16:57 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 976 | 2025-06-30 15:09:59 | oca | 1 | 5146 | 11 | 0.233 | 22085.8 |
| 975 | 2025-06-29 21:54:48 | oca | 1 | 5146 | 11 | 0.623 | 8260.0 |
| 974 | 2025-06-28 23:49:20 | oca | 1 | 5146 | 11 | 0.096 | 53604.2 |
| 973 | 2025-06-28 03:11:09 | oca | 1 | 5146 | 11 | 0.343 | 15002.9 |
| 972 | 2025-06-26 00:04:37 | oca | 1 | 5146 | 11 | 0.623 | 8260.0 |
| 971 | 2025-06-23 13:54:40 | oca | 2 | 14084 | 267 | 0.420 | 33533.3 |
| 970 | 2025-06-23 09:09:50 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 969 | 2025-06-20 19:55:24 | oca | 1 | 5146 | 11 | 0.846 | 6082.7 |
| 968 | 2025-06-16 12:51:57 | oca | 1 | 5146 | 11 | 0.626 | 8220.4 |
| 967 | 2025-06-14 05:10:13 | oca | 1 | 5146 | 11 | 0.580 | 8872.4 |
| 966 | 2025-06-11 07:48:49 | oca | 1 | 5146 | 11 | 0.203 | 25349.8 |
| 965 | 2025-06-09 22:06:22 | oca | 1 | 5146 | 11 | 0.203 | 25349.8 |
| 964 | 2025-06-08 11:40:51 | oca | 1 | 5146 | 11 | 0.623 | 8260.0 |
| 963 | 2025-06-04 06:37:40 | oca | 2 | 14084 | 267 | 1.716 | 8207.5 |
| 962 | 2025-06-04 00:46:58 | oca | 1 | 5146 | 11 | 0.203 | 25349.8 |
| 961 | 2025-06-03 13:15:45 | oca | 2 | 14084 | 267 | 0.423 | 33295.5 |
| 960 | 2025-06-02 22:57:03 | oca | 2 | 14084 | 267 | 0.436 | 32302.8 |
| 959 | 2025-06-01 19:24:27 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 958 | 2025-06-01 12:00:25 | oca | 1 | 5146 | 11 | 0.090 | 57177.8 |
| 957 | 2025-06-01 00:16:28 | oca | 1 | 5146 | 11 | 0.436 | 11802.8 |
| 956 | 2025-05-31 14:10:17 | oca | 1 | 5146 | 11 | 0.143 | 35986.0 |
| 955 | 2025-05-30 21:46:07 | oca | 1 | 5146 | 11 | 0.576 | 8934.0 |
| 954 | 2025-05-29 01:50:52 | oca | 1 | 5146 | 11 | 0.216 | 23824.1 |
| 953 | 2025-05-28 10:37:35 | oca | 1 | 5146 | 11 | 0.123 | 41837.4 |
| 952 | 2025-05-27 06:39:13 | oca | 1 | 5146 | 11 | 0.486 | 10588.5 |
| 951 | 2025-05-22 23:58:39 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 950 | 2025-05-21 19:42:21 | oca | 2 | 14084 | 267 | 1.826 | 7713.0 |
| 949 | 2025-05-20 11:43:21 | oca | 2 | 14084 | 267 | 2.203 | 6393.1 |
| 948 | 2025-05-14 23:05:47 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 947 | 2025-05-08 06:37:57 | oca | 1 | 5146 | 11 | 0.703 | 7320.1 |
| 946 | 2025-05-08 05:19:55 | oca | 1 | 5146 | 11 | 0.563 | 9140.3 |
| 945 | 2025-05-01 19:31:09 | oca | 1 | 5146 | 11 | 0.110 | 46781.8 |
| 944 | 2025-04-28 14:14:27 | oca | 1 | 5146 | 11 | 0.720 | 7147.2 |
| 943 | 2025-04-28 11:55:56 | oca | 1 | 5146 | 11 | 0.096 | 53604.2 |
| 942 | 2025-04-28 11:44:46 | oca | 1 | 5146 | 11 | 0.220 | 23390.9 |
| 941 | 2025-04-28 02:51:33 | oca | 1 | 5146 | 11 | 0.610 | 8436.1 |
| 940 | 2025-04-27 19:58:34 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 939 | 2025-04-27 10:14:43 | oca | 1 | 5146 | 11 | 0.076 | 67710.5 |
| 938 | 2025-04-27 10:12:20 | oca | 1 | 5146 | 11 | 0.093 | 55333.3 |
| 937 | 2025-04-18 12:57:30 | oca | 2 | 14084 | 267 | 1.000 | 14084.0 |
| 936 | 2025-04-17 19:45:56 | oca | 2 | 14084 | 267 | 0.876 | 16077.6 |
| 935 | 2025-04-16 15:59:04 | oca | 2 | 14084 | 267 | 1.030 | 13673.8 |
| 934 | 2025-04-14 12:39:24 | oca | 1 | 5146 | 11 | 0.563 | 9140.3 |
| 933 | 2025-04-11 07:33:23 | oca | 1 | 5146 | 11 | 0.610 | 8436.1 |
| 932 | 2025-04-06 10:51:00 | oca | 1 | 5146 | 11 | 0.593 | 8677.9 |