History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prepare"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1203 | 2024-04-28 09:02:00 | prepare | 3 | 134027 | 333 | 14.143 | 9476.6 |
| 1202 | 2024-04-28 07:22:11 | prepare | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 1201 | 2024-04-20 16:15:52 | prepare | 2 | 107671 | 40 | 12.110 | 8891.1 |
| 1200 | 2024-04-20 08:48:46 | prepare | 3 | 134027 | 333 | 5.970 | 22450.1 |
| 1199 | 2024-04-19 12:06:49 | prepare | 2 | 107671 | 40 | 2.920 | 36873.6 |
| 1198 | 2024-04-11 04:48:39 | prepare | 1 | 69583 | 5 | 1.403 | 49595.9 |
| 1197 | 2024-04-01 02:32:45 | prepare | 3 | 134027 | 333 | 19.533 | 6861.6 |
| 1196 | 2024-03-28 07:41:26 | prepare | 3 | 134027 | 333 | 7.000 | 19146.7 |
| 1195 | 2024-03-10 16:27:28 | prepare | 1 | 69583 | 5 | 2.423 | 28717.7 |
| 1194 | 2024-02-28 10:25:55 | prepare | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 1193 | 2024-02-21 15:11:53 | prepare | 1 | 69583 | 5 | 1.846 | 37693.9 |
| 1192 | 2024-02-09 18:05:48 | prepare | 3 | 134027 | 333 | 8.190 | 16364.7 |
| 1191 | 2024-02-09 05:39:06 | prepare | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 1190 | 2024-02-09 05:33:44 | prepare | 3 | 134027 | 333 | 13.390 | 10009.5 |
| 1189 | 2024-02-09 05:33:42 | prepare | 2 | 107671 | 40 | 4.093 | 26306.1 |
| 1188 | 2024-01-22 23:04:18 | prepare | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 1187 | 2024-01-17 10:59:07 | prepare | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 1186 | 2024-01-08 17:58:27 | prepare | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 1185 | 2024-01-05 10:34:48 | prepare | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 1184 | 2024-01-01 20:15:28 | prepare | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 1183 | 2024-01-01 12:43:33 | prepare | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1182 | 2024-01-01 08:13:52 | prepare | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 1181 | 2023-12-15 17:52:53 | prepare | 2 | 107671 | 40 | 2.873 | 37476.9 |
| 1180 | 2023-12-06 15:02:39 | prepare | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 1179 | 2023-12-01 06:07:21 | prepare | 3 | 134027 | 333 | 6.846 | 19577.4 |
| 1178 | 2023-11-26 20:04:48 | prepare | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1177 | 2023-11-24 21:20:09 | prepare | 3 | 134027 | 333 | 7.410 | 18087.3 |
| 1176 | 2023-11-23 18:00:12 | prepare | 3 | 134027 | 333 | 5.796 | 23124.1 |
| 1175 | 2023-11-23 02:41:24 | prepare | 3 | 134027 | 333 | 5.843 | 22938.0 |
| 1174 | 2023-11-19 00:59:07 | prepare | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 1173 | 2023-11-19 00:48:16 | prepare | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 1172 | 2023-11-03 23:45:32 | prepare | 3 | 134027 | 333 | 7.356 | 18220.1 |
| 1171 | 2023-11-03 23:45:33 | prepare | 2 | 107671 | 40 | 3.563 | 30219.2 |
| 1170 | 2023-10-20 16:49:12 | prepare | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 1169 | 2023-10-18 09:05:49 | prepare | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1168 | 2023-10-12 10:16:30 | prepare | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 1167 | 2023-10-08 08:54:08 | prepare | 1 | 69583 | 5 | 2.906 | 23944.6 |
| 1166 | 2023-10-03 02:55:18 | prepare | 2 | 107671 | 40 | 2.923 | 36835.8 |
| 1165 | 2023-09-25 21:22:10 | prepare | 2 | 107671 | 40 | 3.126 | 34443.7 |
| 1164 | 2023-09-25 16:37:46 | prepare | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 1163 | 2023-09-23 12:21:18 | prepare | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 1162 | 2023-09-16 09:51:11 | prepare | 2 | 107671 | 40 | 2.983 | 36094.9 |
| 1161 | 2023-09-06 09:18:41 | prepare | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1160 | 2023-09-05 03:28:39 | prepare | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 1159 | 2023-08-30 00:04:11 | prepare | 3 | 134027 | 333 | 6.843 | 19586.0 |
| 1158 | 2023-08-13 18:20:09 | prepare | 3 | 134027 | 333 | 6.560 | 20430.9 |
| 1157 | 2023-08-13 17:07:32 | prepare | 3 | 134027 | 333 | 6.283 | 21331.7 |
| 1156 | 2023-08-02 02:03:04 | prepare | 3 | 134027 | 333 | 7.000 | 19146.7 |
| 1155 | 2023-07-31 05:19:51 | prepare | 3 | 134027 | 333 | 6.266 | 21389.6 |
| 1154 | 2023-07-30 06:06:49 | prepare | 3 | 134027 | 333 | 6.516 | 20568.9 |
| 1153 | 2023-07-28 17:58:06 | prepare | 3 | 134027 | 333 | 6.690 | 20033.9 |
| 1152 | 2023-07-26 09:41:28 | prepare | 3 | 134027 | 333 | 5.750 | 23309.0 |
| 1151 | 2023-07-25 16:13:40 | prepare | 3 | 134027 | 333 | 6.606 | 20288.7 |
| 1150 | 2023-07-24 15:10:52 | prepare | 3 | 134027 | 333 | 6.330 | 21173.3 |
| 1149 | 2023-07-22 20:48:19 | prepare | 3 | 134027 | 333 | 7.046 | 19021.7 |
| 1148 | 2023-07-21 08:20:52 | prepare | 3 | 134027 | 333 | 5.936 | 22578.7 |
| 1147 | 2023-07-20 02:20:09 | prepare | 3 | 134027 | 333 | 6.126 | 21878.4 |
| 1146 | 2023-07-09 04:20:51 | prepare | 3 | 134027 | 333 | 6.313 | 21230.3 |
| 1145 | 2023-07-08 12:09:36 | prepare | 3 | 134027 | 333 | 5.766 | 23244.4 |
| 1144 | 2023-07-07 17:14:22 | prepare | 3 | 134027 | 333 | 6.780 | 19768.0 |
| 1143 | 2023-07-06 11:50:25 | prepare | 3 | 134027 | 333 | 6.170 | 21722.4 |
| 1142 | 2023-07-05 02:10:10 | prepare | 3 | 134027 | 333 | 6.313 | 21230.3 |
| 1141 | 2023-07-04 06:48:31 | prepare | 3 | 134027 | 333 | 6.950 | 19284.5 |
| 1140 | 2023-07-03 16:02:24 | prepare | 3 | 134027 | 333 | 6.486 | 20664.0 |
| 1139 | 2023-07-02 11:24:15 | prepare | 3 | 134027 | 333 | 5.966 | 22465.1 |
| 1138 | 2023-07-01 22:09:07 | prepare | 3 | 134027 | 333 | 6.826 | 19634.8 |
| 1137 | 2023-07-01 04:09:50 | prepare | 3 | 134027 | 333 | 5.656 | 23696.4 |
| 1136 | 2023-06-30 11:23:15 | prepare | 3 | 134027 | 333 | 6.700 | 20004.0 |
| 1135 | 2023-06-29 17:04:29 | prepare | 3 | 134027 | 333 | 6.170 | 21722.4 |
| 1134 | 2023-06-28 17:00:33 | prepare | 3 | 134027 | 333 | 7.096 | 18887.7 |
| 1133 | 2023-06-27 20:50:28 | prepare | 3 | 134027 | 333 | 6.093 | 21996.9 |
| 1132 | 2023-06-27 05:35:21 | prepare | 3 | 134027 | 333 | 5.843 | 22938.0 |
| 1131 | 2023-06-26 07:46:03 | prepare | 3 | 134027 | 333 | 6.373 | 21030.4 |
| 1130 | 2023-06-25 14:57:50 | prepare | 3 | 134027 | 333 | 6.173 | 21711.8 |
| 1129 | 2023-06-24 13:12:30 | prepare | 3 | 134027 | 333 | 6.656 | 20136.3 |
| 1128 | 2023-06-23 22:46:50 | prepare | 3 | 134027 | 333 | 7.233 | 18529.9 |
| 1127 | 2023-06-23 00:59:04 | prepare | 3 | 134027 | 333 | 5.956 | 22502.9 |
| 1126 | 2023-06-22 06:07:39 | prepare | 3 | 134027 | 333 | 6.843 | 19586.0 |
| 1125 | 2023-06-21 15:29:51 | prepare | 3 | 134027 | 333 | 6.063 | 22105.7 |
| 1124 | 2023-06-20 18:22:37 | prepare | 3 | 134027 | 333 | 6.673 | 20085.0 |
| 1123 | 2023-06-20 01:08:59 | prepare | 3 | 134027 | 333 | 5.890 | 22755.0 |
| 1122 | 2023-06-19 05:40:42 | prepare | 3 | 134027 | 333 | 5.830 | 22989.2 |
| 1121 | 2023-06-18 08:41:21 | prepare | 3 | 134027 | 333 | 6.373 | 21030.4 |
| 1120 | 2023-06-18 06:08:08 | prepare | 2 | 107671 | 40 | 2.860 | 37647.2 |
| 1119 | 2023-06-17 19:24:13 | prepare | 3 | 134027 | 333 | 6.686 | 20045.9 |
| 1118 | 2023-06-16 19:13:33 | prepare | 3 | 134027 | 333 | 5.733 | 23378.2 |
| 1117 | 2023-06-15 05:18:28 | prepare | 3 | 134027 | 333 | 8.266 | 16214.3 |
| 1116 | 2023-06-14 05:27:27 | prepare | 3 | 134027 | 333 | 5.830 | 22989.2 |
| 1115 | 2023-06-13 14:39:42 | prepare | 3 | 134027 | 333 | 6.236 | 21492.5 |
| 1114 | 2023-06-12 04:39:51 | prepare | 3 | 134027 | 333 | 6.390 | 20974.5 |
| 1113 | 2023-06-11 07:31:30 | prepare | 3 | 134027 | 333 | 7.173 | 18684.9 |
| 1112 | 2023-06-10 16:59:04 | prepare | 3 | 134027 | 333 | 5.733 | 23378.2 |
| 1111 | 2023-06-09 06:02:09 | prepare | 3 | 134027 | 333 | 5.990 | 22375.1 |
| 1110 | 2023-06-08 06:02:10 | prepare | 3 | 134027 | 333 | 5.656 | 23696.4 |
| 1109 | 2023-06-06 14:55:04 | prepare | 3 | 134027 | 333 | 7.263 | 18453.4 |
| 1108 | 2023-06-05 19:29:32 | prepare | 3 | 134027 | 333 | 6.156 | 21771.8 |
| 1107 | 2023-06-05 05:35:03 | prepare | 3 | 134027 | 333 | 6.360 | 21073.4 |
| 1106 | 2023-06-04 10:48:36 | prepare | 3 | 134027 | 333 | 6.720 | 19944.5 |
| 1105 | 2023-06-03 04:45:46 | prepare | 3 | 134027 | 333 | 6.673 | 20085.0 |
| 1104 | 2023-06-01 18:10:26 | prepare | 3 | 134027 | 333 | 6.923 | 19359.7 |