History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cropland"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
294 | 2024-04-26 23:49:28 | cropland | 2 | 121059 | 3 | 8.033 | 15070.2 |
293 | 2024-04-26 23:39:44 | cropland | 1 | 82945 | 2 | 1.516 | 54713.1 |
292 | 2024-04-25 14:20:49 | cropland | 3 | 146162 | 47 | 10.970 | 13323.8 |
291 | 2024-04-24 19:56:19 | cropland | 2 | 121059 | 3 | 7.000 | 17294.1 |
290 | 2024-04-24 17:39:35 | cropland | 1 | 82945 | 2 | 1.546 | 53651.4 |
289 | 2024-04-18 19:05:23 | cropland | 2 | 121059 | 3 | 4.936 | 24525.7 |
288 | 2024-04-15 21:15:22 | cropland | 2 | 121059 | 3 | 4.016 | 30144.2 |
287 | 2024-04-15 21:15:02 | cropland | 3 | 146162 | 47 | 8.486 | 17223.9 |
286 | 2024-04-13 05:46:21 | cropland | 4 | 161609 | 614 | 13.330 | 12123.7 |
285 | 2024-04-12 02:04:52 | cropland | 4 | 161609 | 614 | 55.906 | 2890.7 |
284 | 2024-04-11 03:39:21 | cropland | 3 | 146162 | 47 | 7.483 | 19532.5 |
283 | 2024-04-10 21:25:53 | cropland | 4 | 161609 | 614 | 40.126 | 4027.5 |
282 | 2024-04-09 18:11:17 | cropland | 4 | 161609 | 614 | 29.393 | 5498.2 |
281 | 2024-04-09 11:16:26 | cropland | 4 | 161609 | 614 | 44.236 | 3653.3 |
280 | 2024-04-08 21:54:21 | cropland | 4 | 161609 | 614 | 29.160 | 5542.1 |
279 | 2024-04-08 21:54:21 | cropland | 3 | 146162 | 47 | 18.063 | 8091.8 |
278 | 2024-04-08 21:54:21 | cropland | 2 | 121059 | 3 | 7.423 | 16308.6 |
277 | 2024-04-08 21:54:10 | cropland | 1 | 82945 | 2 | 3.296 | 25165.4 |
276 | 2024-03-30 09:31:51 | cropland | 1 | 82945 | 2 | 4.030 | 20581.9 |
275 | 2024-03-25 06:30:02 | cropland | 1 | 82945 | 2 | 1.530 | 54212.4 |
274 | 2024-03-25 06:29:57 | cropland | 2 | 121059 | 3 | 4.030 | 30039.5 |
273 | 2024-03-19 23:25:35 | cropland | 2 | 121059 | 3 | 4.190 | 28892.4 |
272 | 2024-03-19 23:25:25 | cropland | 1 | 82945 | 2 | 1.546 | 53651.4 |
271 | 2024-03-11 09:05:12 | cropland | 4 | 161609 | 614 | 36.830 | 4388.0 |
270 | 2024-03-11 00:02:40 | cropland | 2 | 121059 | 3 | 7.486 | 16171.4 |
269 | 2024-03-11 00:02:17 | cropland | 3 | 146162 | 47 | 7.216 | 20255.3 |
268 | 2024-03-10 18:40:18 | cropland | 3 | 146162 | 47 | 19.800 | 7381.9 |
267 | 2024-03-10 13:53:58 | cropland | 4 | 161609 | 614 | 16.003 | 10098.7 |
266 | 2024-03-10 10:43:31 | cropland | 3 | 146162 | 47 | 24.080 | 6069.9 |
265 | 2024-03-10 10:16:47 | cropland | 4 | 161609 | 614 | 31.296 | 5163.9 |
264 | 2024-03-10 06:43:13 | cropland | 4 | 161609 | 614 | 30.236 | 5344.9 |
263 | 2024-03-09 19:55:18 | cropland | 4 | 161609 | 614 | 24.596 | 6570.5 |
262 | 2024-03-09 03:41:35 | cropland | 4 | 161609 | 614 | 19.080 | 8470.1 |
261 | 2024-03-09 03:41:49 | cropland | 1 | 82945 | 2 | 1.656 | 50087.6 |
260 | 2024-03-09 03:41:41 | cropland | 2 | 121059 | 3 | 4.343 | 27874.5 |
259 | 2024-03-09 03:41:36 | cropland | 3 | 146162 | 47 | 8.906 | 16411.6 |
258 | 2024-03-09 03:41:30 | cropland | 1 | 82945 | 2 | 1.593 | 52068.4 |
257 | 2024-02-05 11:44:57 | cropland | 2 | 121059 | 3 | 9.126 | 13265.3 |
256 | 2024-02-05 11:10:58 | cropland | 3 | 146162 | 47 | 7.470 | 19566.5 |
255 | 2024-02-05 00:55:10 | cropland | 4 | 161609 | 614 | 15.623 | 10344.3 |
254 | 2024-02-04 13:52:43 | cropland | 3 | 146162 | 47 | 8.970 | 16294.5 |
253 | 2024-02-01 08:39:04 | cropland | 2 | 121059 | 3 | 5.436 | 22269.9 |
252 | 2024-02-01 08:38:52 | cropland | 3 | 146162 | 47 | 7.530 | 19410.6 |
251 | 2024-01-31 08:31:11 | cropland | 1 | 82945 | 2 | 1.466 | 56579.1 |
250 | 2024-01-31 08:31:07 | cropland | 2 | 121059 | 3 | 3.953 | 30624.6 |
249 | 2024-01-31 08:31:03 | cropland | 3 | 146162 | 47 | 7.063 | 20694.0 |
248 | 2024-01-30 06:54:21 | cropland | 4 | 161609 | 614 | 12.673 | 12752.2 |
247 | 2024-01-24 15:45:00 | cropland | 1 | 82945 | 2 | 1.300 | 63803.8 |
246 | 2024-01-23 03:54:44 | cropland | 1 | 82945 | 2 | 1.626 | 51011.7 |
245 | 2024-01-07 17:23:31 | cropland | 4 | 161609 | 614 | 11.076 | 14590.9 |
244 | 2023-12-21 05:57:46 | cropland | 3 | 146162 | 47 | 6.326 | 23105.0 |
243 | 2023-12-11 16:48:23 | cropland | 2 | 121059 | 3 | 3.610 | 33534.3 |
242 | 2023-11-27 02:15:26 | cropland | 1 | 82945 | 2 | 1.390 | 59672.7 |
241 | 2023-11-22 05:05:02 | cropland | 4 | 161609 | 614 | 16.843 | 9595.0 |
240 | 2023-11-21 19:52:10 | cropland | 1 | 82945 | 2 | 1.263 | 65673.0 |
239 | 2023-11-20 16:14:52 | cropland | 1 | 82945 | 2 | 1.390 | 59672.7 |
238 | 2023-11-19 10:25:05 | cropland | 1 | 82945 | 2 | 1.406 | 58993.6 |
237 | 2023-10-20 04:01:35 | cropland | 4 | 161609 | 614 | 25.330 | 6380.1 |
236 | 2023-10-18 00:54:09 | cropland | 4 | 161609 | 614 | 22.203 | 7278.7 |
235 | 2023-10-15 10:45:36 | cropland | 4 | 161609 | 614 | 10.656 | 15166.0 |
234 | 2023-09-21 05:12:10 | cropland | 3 | 146162 | 47 | 6.533 | 22372.9 |
233 | 2023-09-19 01:19:22 | cropland | 1 | 82945 | 2 | 1.516 | 54713.1 |
232 | 2023-09-15 17:06:49 | cropland | 1 | 82945 | 2 | 1.486 | 55817.6 |
231 | 2023-09-10 23:09:47 | cropland | 2 | 121059 | 3 | 3.280 | 36908.2 |
230 | 2023-09-07 18:10:09 | cropland | 1 | 82945 | 2 | 1.313 | 63172.1 |
229 | 2023-07-26 00:37:44 | cropland | 4 | 161609 | 614 | 11.263 | 14348.7 |
228 | 2023-06-24 11:22:37 | cropland | 3 | 146162 | 47 | 6.610 | 22112.3 |
227 | 2023-06-16 23:49:07 | cropland | 4 | 161609 | 614 | 11.486 | 14070.1 |
226 | 2023-06-15 07:14:01 | cropland | 1 | 82945 | 2 | 1.436 | 57761.1 |
225 | 2023-06-04 10:00:43 | cropland | 2 | 121059 | 3 | 3.233 | 37444.8 |
224 | 2023-05-16 06:08:49 | cropland | 1 | 82945 | 2 | 1.280 | 64800.8 |
223 | 2023-04-22 23:13:15 | cropland | 1 | 82945 | 2 | 1.280 | 64800.8 |
222 | 2023-04-06 10:58:08 | cropland | 4 | 161609 | 614 | 12.173 | 13276.0 |
221 | 2023-04-01 06:31:31 | cropland | 1 | 82945 | 2 | 1.406 | 58993.6 |
220 | 2023-03-20 00:33:24 | cropland | 3 | 146162 | 47 | 6.203 | 23563.1 |
219 | 2023-03-12 10:33:05 | cropland | 2 | 121059 | 3 | 3.920 | 30882.4 |
218 | 2023-01-19 11:14:07 | cropland | 1 | 82945 | 2 | 1.343 | 61761.0 |
217 | 2023-01-15 17:39:44 | cropland | 1 | 82945 | 2 | 1.266 | 65517.4 |
216 | 2023-01-12 19:43:02 | cropland | 1 | 82945 | 2 | 1.283 | 64649.3 |
215 | 2023-01-04 13:39:46 | cropland | 4 | 161609 | 614 | 10.596 | 15251.9 |
214 | 2022-12-21 16:47:35 | cropland | 3 | 146162 | 47 | 6.156 | 23743.0 |
213 | 2022-12-16 15:41:34 | cropland | 2 | 121059 | 3 | 3.686 | 32842.9 |
212 | 2022-12-02 04:02:56 | cropland | 4 | 161609 | 614 | 13.076 | 12359.2 |
211 | 2022-10-29 17:08:25 | cropland | 4 | 161609 | 614 | 10.533 | 15343.1 |
210 | 2022-10-24 12:52:06 | cropland | 1 | 82945 | 2 | 1.373 | 60411.5 |
209 | 2022-09-15 21:05:22 | cropland | 4 | 161609 | 614 | 11.016 | 14670.4 |
208 | 2022-09-10 12:01:57 | cropland | 4 | 161609 | 614 | 12.313 | 13125.1 |
207 | 2022-09-10 03:15:15 | cropland | 1 | 82945 | 2 | 1.296 | 64000.8 |
206 | 2022-09-08 09:53:17 | cropland | 4 | 161609 | 614 | 10.656 | 15166.0 |
205 | 2022-08-20 14:36:58 | cropland | 3 | 146162 | 47 | 6.360 | 22981.4 |
204 | 2022-08-09 13:28:04 | cropland | 2 | 121059 | 3 | 3.200 | 37830.9 |
203 | 2022-06-14 13:04:06 | cropland | 1 | 82945 | 2 | 1.296 | 64000.8 |
202 | 2022-04-23 11:26:16 | cropland | 1 | 82945 | 2 | 1.500 | 55296.7 |
201 | 2022-04-20 00:51:40 | cropland | 1 | 82945 | 2 | 1.360 | 60989.0 |
200 | 2022-02-17 16:34:09 | cropland | 1 | 82945 | 2 | 1.406 | 58993.6 |
199 | 2021-12-28 15:20:51 | cropland | 1 | 82945 | 2 | 1.546 | 53651.4 |
198 | 2021-12-21 15:18:49 | cropland | 1 | 82945 | 2 | 1.533 | 54106.3 |
197 | 2021-11-15 18:38:21 | cropland | 1 | 82945 | 2 | 1.440 | 57600.7 |
196 | 2021-11-14 17:33:24 | cropland | 1 | 82945 | 2 | 1.453 | 57085.3 |
195 | 2021-11-13 19:27:06 | cropland | 1 | 82945 | 2 | 1.500 | 55296.7 |