History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coleopteran"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
271 | 2024-05-13 18:52:42 | coleopteran | 5 | 164607 | 118 | 42.360 | 3885.9 |
270 | 2024-05-13 16:25:54 | coleopteran | 5 | 164607 | 118 | 39.130 | 4206.7 |
269 | 2024-05-13 12:59:00 | coleopteran | 4 | 148819 | 22 | 26.453 | 5625.8 |
268 | 2024-05-13 12:52:46 | coleopteran | 5 | 164607 | 118 | 56.566 | 2910.0 |
267 | 2024-05-13 12:52:47 | coleopteran | 4 | 148819 | 22 | 35.440 | 4199.2 |
266 | 2024-05-13 12:52:53 | coleopteran | 2 | 86808 | 3 | 9.110 | 9528.9 |
265 | 2024-05-13 12:52:00 | coleopteran | 1 | 49908 | 3 | 1.093 | 45661.5 |
264 | 2024-05-13 08:38:49 | coleopteran | 3 | 121633 | 8 | 19.330 | 6292.4 |
263 | 2024-05-10 20:59:12 | coleopteran | 3 | 121633 | 8 | 15.610 | 7792.0 |
262 | 2024-05-10 20:58:45 | coleopteran | 2 | 86808 | 3 | 2.940 | 29526.5 |
261 | 2024-05-10 20:57:04 | coleopteran | 1 | 49908 | 3 | 1.970 | 25334.0 |
260 | 2024-05-10 17:04:29 | coleopteran | 3 | 121633 | 8 | 13.456 | 9039.3 |
259 | 2024-05-09 08:55:25 | coleopteran | 3 | 121633 | 8 | 14.063 | 8649.2 |
258 | 2024-05-09 08:55:32 | coleopteran | 1 | 49908 | 3 | 3.076 | 16225.0 |
257 | 2024-05-09 08:55:24 | coleopteran | 2 | 86808 | 3 | 2.810 | 30892.5 |
256 | 2024-05-09 08:55:23 | coleopteran | 1 | 49908 | 3 | 1.920 | 25993.8 |
255 | 2024-04-19 22:27:46 | coleopteran | 4 | 148819 | 22 | 19.390 | 7675.0 |
254 | 2024-04-18 15:24:42 | coleopteran | 4 | 148819 | 22 | 38.956 | 3820.2 |
253 | 2024-04-18 15:24:52 | coleopteran | 3 | 121633 | 8 | 21.283 | 5715.0 |
252 | 2024-04-18 15:24:48 | coleopteran | 2 | 86808 | 3 | 4.953 | 17526.3 |
251 | 2024-04-13 22:54:36 | coleopteran | 5 | 164607 | 118 | 73.143 | 2250.5 |
250 | 2024-04-12 15:42:41 | coleopteran | 5 | 164607 | 118 | 19.360 | 8502.4 |
249 | 2024-04-12 15:42:42 | coleopteran | 3 | 121633 | 8 | 16.500 | 7371.7 |
248 | 2024-04-12 15:42:44 | coleopteran | 2 | 86808 | 3 | 4.406 | 19702.2 |
247 | 2024-04-12 15:38:39 | coleopteran | 1 | 49908 | 3 | 2.346 | 21273.7 |
246 | 2024-04-12 13:25:50 | coleopteran | 4 | 148819 | 22 | 12.703 | 11715.3 |
245 | 2024-04-10 18:27:26 | coleopteran | 4 | 148819 | 22 | 29.956 | 4967.9 |
244 | 2024-04-10 11:22:53 | coleopteran | 4 | 148819 | 22 | 23.030 | 6462.0 |
243 | 2024-04-10 06:37:20 | coleopteran | 4 | 148819 | 22 | 14.923 | 9972.5 |
242 | 2024-03-30 18:11:19 | coleopteran | 1 | 49908 | 3 | 2.920 | 17091.8 |
241 | 2024-03-21 12:56:45 | coleopteran | 1 | 49908 | 3 | 2.953 | 16900.8 |
240 | 2024-03-15 11:01:49 | coleopteran | 1 | 49908 | 3 | 3.296 | 15142.0 |
239 | 2024-03-15 11:00:31 | coleopteran | 1 | 49908 | 3 | 1.983 | 25167.9 |
238 | 2024-02-20 17:22:30 | coleopteran | 2 | 86808 | 3 | 3.313 | 26202.2 |
237 | 2024-02-20 10:26:05 | coleopteran | 1 | 49908 | 3 | 0.860 | 58032.6 |
236 | 2024-02-20 04:07:39 | coleopteran | 3 | 121633 | 8 | 12.330 | 9864.8 |
235 | 2024-02-20 04:07:42 | coleopteran | 2 | 86808 | 3 | 3.076 | 28221.1 |
234 | 2024-02-19 19:45:47 | coleopteran | 3 | 121633 | 8 | 7.283 | 16700.9 |
233 | 2024-02-19 19:45:48 | coleopteran | 2 | 86808 | 3 | 5.080 | 17088.2 |
232 | 2024-02-19 19:30:19 | coleopteran | 1 | 49908 | 3 | 0.983 | 50771.1 |
231 | 2024-02-19 18:21:07 | coleopteran | 1 | 49908 | 3 | 0.890 | 56076.4 |
230 | 2024-02-19 11:23:39 | coleopteran | 4 | 148819 | 22 | 11.110 | 13395.0 |
229 | 2024-02-19 06:07:26 | coleopteran | 5 | 164607 | 118 | 33.986 | 4843.4 |
228 | 2024-02-18 08:38:25 | coleopteran | 5 | 164607 | 118 | 57.223 | 2876.6 |
227 | 2024-02-17 05:25:50 | coleopteran | 4 | 148819 | 22 | 24.440 | 6089.2 |
226 | 2024-02-17 05:25:45 | coleopteran | 3 | 121633 | 8 | 9.236 | 13169.4 |
225 | 2024-02-17 00:02:50 | coleopteran | 5 | 164607 | 118 | 20.423 | 8059.9 |
224 | 2024-02-15 04:30:38 | coleopteran | 4 | 148819 | 22 | 23.453 | 6345.4 |
223 | 2024-02-15 03:50:14 | coleopteran | 5 | 164607 | 118 | 19.843 | 8295.5 |
222 | 2024-02-13 21:47:06 | coleopteran | 2 | 86808 | 3 | 7.970 | 10891.8 |
221 | 2024-02-13 21:45:47 | coleopteran | 3 | 121633 | 8 | 8.423 | 14440.6 |
220 | 2024-02-13 19:24:40 | coleopteran | 1 | 49908 | 3 | 0.936 | 53320.5 |
219 | 2024-02-11 19:46:33 | coleopteran | 4 | 148819 | 22 | 23.530 | 6324.6 |
218 | 2024-02-11 16:23:34 | coleopteran | 5 | 164607 | 118 | 14.703 | 11195.5 |
217 | 2024-02-11 16:23:35 | coleopteran | 4 | 148819 | 22 | 9.610 | 15485.8 |
216 | 2024-02-11 16:23:32 | coleopteran | 3 | 121633 | 8 | 5.233 | 23243.5 |
215 | 2024-02-11 16:23:33 | coleopteran | 2 | 86808 | 3 | 2.533 | 34270.8 |
214 | 2024-02-11 13:24:19 | coleopteran | 1 | 49908 | 3 | 0.796 | 62698.5 |
213 | 2024-02-08 14:27:59 | coleopteran | 1 | 49908 | 3 | 2.076 | 24040.5 |
212 | 2024-01-29 13:21:52 | coleopteran | 1 | 49908 | 3 | 0.906 | 55086.1 |
211 | 2024-01-25 19:41:37 | coleopteran | 1 | 49908 | 3 | 0.780 | 63984.6 |
210 | 2024-01-20 13:24:21 | coleopteran | 1 | 49908 | 3 | 0.936 | 53320.5 |
209 | 2024-01-09 18:52:30 | coleopteran | 2 | 86808 | 3 | 2.373 | 36581.5 |
208 | 2023-12-16 22:51:07 | coleopteran | 1 | 49908 | 3 | 0.876 | 56972.6 |
207 | 2023-12-11 23:04:06 | coleopteran | 4 | 148819 | 22 | 9.656 | 15412.1 |
206 | 2023-12-03 22:23:51 | coleopteran | 1 | 49908 | 3 | 0.780 | 63984.6 |
205 | 2023-11-04 12:56:31 | coleopteran | 1 | 49908 | 3 | 0.780 | 63984.6 |
204 | 2023-10-19 06:31:44 | coleopteran | 2 | 86808 | 3 | 2.110 | 41141.2 |
203 | 2023-10-01 19:11:16 | coleopteran | 1 | 49908 | 3 | 0.766 | 65154.0 |
202 | 2023-09-25 05:10:27 | coleopteran | 1 | 49908 | 3 | 0.986 | 50616.6 |
201 | 2023-09-10 09:43:08 | coleopteran | 4 | 148819 | 22 | 8.186 | 18179.7 |
200 | 2023-08-04 12:58:41 | coleopteran | 1 | 49908 | 3 | 0.843 | 59202.8 |
199 | 2023-07-29 07:57:40 | coleopteran | 1 | 49908 | 3 | 1.516 | 32920.8 |
198 | 2023-07-29 00:42:19 | coleopteran | 2 | 86808 | 3 | 2.500 | 34723.2 |
197 | 2023-05-25 10:27:35 | coleopteran | 4 | 148819 | 22 | 8.030 | 18532.9 |
196 | 2023-04-25 18:27:56 | coleopteran | 1 | 49908 | 3 | 0.766 | 65154.0 |
195 | 2023-04-04 16:46:16 | coleopteran | 2 | 86808 | 3 | 2.143 | 40507.7 |
194 | 2023-03-05 02:55:46 | coleopteran | 1 | 49908 | 3 | 0.766 | 65154.0 |
193 | 2023-03-04 22:51:20 | coleopteran | 4 | 148819 | 22 | 8.063 | 18457.0 |
192 | 2023-03-01 15:55:49 | coleopteran | 1 | 49908 | 3 | 0.830 | 60130.1 |
191 | 2023-02-17 17:30:02 | coleopteran | 1 | 49908 | 3 | 0.843 | 59202.8 |
190 | 2023-01-03 16:01:20 | coleopteran | 2 | 86808 | 3 | 2.030 | 42762.6 |
189 | 2022-12-16 10:01:27 | coleopteran | 1 | 49908 | 3 | 0.766 | 65154.0 |
188 | 2022-12-12 23:02:43 | coleopteran | 4 | 148819 | 22 | 8.390 | 17737.7 |
187 | 2022-09-19 21:49:57 | coleopteran | 1 | 49908 | 3 | 0.780 | 63984.6 |
186 | 2022-09-08 10:17:57 | coleopteran | 2 | 86808 | 3 | 2.046 | 42428.2 |
185 | 2022-09-08 09:59:25 | coleopteran | 5 | 164607 | 118 | 14.610 | 11266.7 |
184 | 2022-09-06 07:17:01 | coleopteran | 2 | 86808 | 3 | 2.186 | 39710.9 |
183 | 2022-08-21 04:31:32 | coleopteran | 1 | 49908 | 3 | 0.873 | 57168.4 |
182 | 2022-08-03 12:35:11 | coleopteran | 5 | 164607 | 118 | 13.736 | 11983.6 |
181 | 2022-07-30 13:54:31 | coleopteran | 4 | 148819 | 22 | 8.110 | 18350.1 |
180 | 2022-07-30 10:19:30 | coleopteran | 5 | 164607 | 118 | 14.156 | 11628.1 |
179 | 2022-07-30 06:19:44 | coleopteran | 5 | 164607 | 118 | 15.500 | 10619.8 |
178 | 2022-07-03 02:03:12 | coleopteran | 5 | 164607 | 118 | 13.843 | 11891.0 |
177 | 2022-04-10 20:20:18 | coleopteran | 1 | 49908 | 3 | 0.826 | 60421.3 |
176 | 2022-03-12 03:33:36 | coleopteran | 1 | 49908 | 3 | 0.783 | 63739.5 |
175 | 2022-03-03 12:57:24 | coleopteran | 4 | 148819 | 22 | 11.860 | 12548.0 |
174 | 2022-01-06 18:20:53 | coleopteran | 1 | 49908 | 3 | 0.936 | 53320.5 |
173 | 2021-11-23 12:46:45 | coleopteran | 1 | 49908 | 3 | 1.576 | 31667.5 |
172 | 2021-10-09 18:48:54 | coleopteran | 1 | 49908 | 3 | 0.843 | 59202.8 |