History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smallholder"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
339 | 2025-09-10 11:41:29 | smallholder | 1 | 49908 | 3 | 0.830 | 60130.1 |
338 | 2025-09-10 10:55:35 | smallholder | 1 | 49908 | 3 | 0.813 | 61387.5 |
337 | 2025-08-24 08:03:37 | smallholder | 4 | 148819 | 30 | 44.660 | 3332.3 |
336 | 2025-08-10 07:56:07 | smallholder | 1 | 49908 | 3 | 5.733 | 8705.4 |
335 | 2025-08-05 09:34:48 | smallholder | 1 | 49908 | 3 | 1.483 | 33653.4 |
334 | 2025-07-27 10:19:50 | smallholder | 1 | 49908 | 3 | 1.763 | 28308.6 |
333 | 2025-07-25 20:01:41 | smallholder | 1 | 49908 | 3 | 0.873 | 57168.4 |
332 | 2025-07-18 14:51:23 | smallholder | 4 | 148819 | 30 | 36.470 | 4080.6 |
331 | 2025-06-30 07:00:38 | smallholder | 1 | 49908 | 3 | 4.986 | 10009.6 |
330 | 2025-06-22 13:54:50 | smallholder | 1 | 49908 | 3 | 6.356 | 7852.1 |
329 | 2025-06-10 06:01:42 | smallholder | 4 | 148819 | 30 | 39.813 | 3737.9 |
328 | 2025-06-10 00:14:36 | smallholder | 4 | 148819 | 30 | 48.533 | 3066.3 |
327 | 2025-06-09 04:30:14 | smallholder | 2 | 86808 | 4 | 2.046 | 42428.2 |
326 | 2025-06-08 21:24:41 | smallholder | 5 | 164607 | 114 | 13.906 | 11837.1 |
325 | 2025-06-08 20:50:59 | smallholder | 4 | 148819 | 30 | 9.330 | 15950.6 |
324 | 2025-06-08 00:23:38 | smallholder | 1 | 49908 | 3 | 3.530 | 14138.2 |
323 | 2025-05-27 16:06:07 | smallholder | 4 | 148819 | 30 | 31.203 | 4769.4 |
322 | 2025-05-26 09:33:04 | smallholder | 2 | 86808 | 4 | 6.560 | 13232.9 |
321 | 2025-05-26 04:09:40 | smallholder | 4 | 148819 | 30 | 38.640 | 3851.4 |
320 | 2025-05-25 13:00:13 | smallholder | 5 | 164607 | 114 | 21.206 | 7762.3 |
319 | 2025-05-25 10:42:00 | smallholder | 1 | 49908 | 3 | 0.906 | 55086.1 |
318 | 2025-05-07 04:25:21 | smallholder | 5 | 164607 | 114 | 16.486 | 9984.7 |
317 | 2025-04-22 10:16:29 | smallholder | 5 | 164607 | 114 | 14.706 | 11193.2 |
316 | 2025-04-21 11:11:19 | smallholder | 1 | 49908 | 3 | 3.966 | 12584.0 |
315 | 2025-04-21 06:33:43 | smallholder | 2 | 86808 | 4 | 9.406 | 9229.0 |
314 | 2025-04-20 15:22:41 | smallholder | 4 | 148819 | 30 | 9.156 | 16253.7 |
313 | 2025-04-12 15:58:07 | smallholder | 4 | 148819 | 30 | 50.486 | 2947.7 |
312 | 2025-04-11 22:04:26 | smallholder | 4 | 148819 | 30 | 49.630 | 2998.6 |
311 | 2025-04-10 16:48:00 | smallholder | 1 | 49908 | 3 | 0.840 | 59414.3 |
310 | 2025-04-10 15:46:09 | smallholder | 5 | 164607 | 114 | 14.923 | 11030.4 |
309 | 2025-04-10 15:25:38 | smallholder | 4 | 148819 | 30 | 9.813 | 15165.5 |
308 | 2025-04-09 18:05:16 | smallholder | 3 | 121633 | 9 | 15.610 | 7792.0 |
307 | 2025-04-09 17:44:55 | smallholder | 2 | 86808 | 4 | 8.796 | 9869.0 |
306 | 2025-04-01 18:03:06 | smallholder | 4 | 148819 | 30 | 26.066 | 5709.3 |
305 | 2025-03-30 13:17:05 | smallholder | 4 | 148819 | 30 | 9.203 | 16170.7 |
304 | 2025-03-18 05:37:12 | smallholder | 1 | 49908 | 3 | 5.970 | 8359.8 |
303 | 2025-03-14 03:18:26 | smallholder | 4 | 148819 | 30 | 45.330 | 3283.0 |
302 | 2025-03-09 07:48:08 | smallholder | 1 | 49908 | 3 | 3.530 | 14138.2 |
301 | 2025-03-05 03:02:17 | smallholder | 4 | 148819 | 30 | 41.676 | 3570.9 |
300 | 2025-02-27 15:39:41 | smallholder | 4 | 148819 | 30 | 25.936 | 5737.9 |
299 | 2025-02-27 15:39:39 | smallholder | 2 | 86808 | 4 | 2.453 | 35388.5 |
298 | 2025-02-22 18:01:23 | smallholder | 4 | 148819 | 30 | 49.063 | 3033.2 |
297 | 2025-02-22 18:01:23 | smallholder | 3 | 121633 | 9 | 26.923 | 4517.8 |
296 | 2025-02-21 03:03:10 | smallholder | 1 | 49908 | 3 | 5.860 | 8516.7 |
295 | 2025-02-21 02:32:59 | smallholder | 4 | 148819 | 30 | 46.363 | 3209.9 |
294 | 2025-02-20 12:37:59 | smallholder | 4 | 148819 | 30 | 41.783 | 3561.7 |
293 | 2025-02-15 08:21:22 | smallholder | 2 | 86808 | 4 | 12.203 | 7113.7 |
292 | 2025-02-15 08:19:55 | smallholder | 1 | 49908 | 3 | 4.513 | 11058.7 |
291 | 2025-02-15 06:26:52 | smallholder | 3 | 121633 | 9 | 28.550 | 4260.4 |
290 | 2025-02-03 04:32:43 | smallholder | 1 | 49908 | 3 | 2.000 | 24954.0 |
289 | 2025-01-30 10:19:20 | smallholder | 4 | 148819 | 30 | 80.520 | 1848.2 |
288 | 2025-01-21 23:14:57 | smallholder | 4 | 148819 | 30 | 42.860 | 3472.2 |
287 | 2025-01-21 23:14:59 | smallholder | 3 | 121633 | 9 | 24.736 | 4917.2 |
286 | 2025-01-21 23:12:24 | smallholder | 1 | 49908 | 3 | 4.780 | 10441.0 |
285 | 2025-01-21 15:26:32 | smallholder | 3 | 121633 | 9 | 20.766 | 5857.3 |
284 | 2025-01-21 15:26:01 | smallholder | 4 | 148819 | 30 | 41.143 | 3617.1 |
283 | 2025-01-21 15:26:26 | smallholder | 2 | 86808 | 4 | 11.703 | 7417.6 |
282 | 2025-01-21 15:25:54 | smallholder | 1 | 49908 | 3 | 4.110 | 12143.1 |
281 | 2025-01-21 15:06:32 | smallholder | 4 | 148819 | 30 | 44.783 | 3323.1 |
280 | 2025-01-20 15:29:24 | smallholder | 3 | 121633 | 9 | 26.266 | 4630.8 |
279 | 2025-01-20 15:28:46 | smallholder | 4 | 148819 | 30 | 48.470 | 3070.3 |
278 | 2025-01-20 15:28:46 | smallholder | 2 | 86808 | 4 | 17.783 | 4881.5 |
277 | 2025-01-20 15:25:36 | smallholder | 4 | 148819 | 30 | 46.953 | 3169.5 |
276 | 2025-01-16 09:04:46 | smallholder | 3 | 121633 | 9 | 27.550 | 4415.0 |
275 | 2025-01-11 17:26:23 | smallholder | 3 | 121633 | 9 | 29.816 | 4079.5 |
274 | 2025-01-11 08:26:22 | smallholder | 1 | 49908 | 3 | 4.300 | 11606.5 |
273 | 2025-01-02 21:54:21 | smallholder | 1 | 49908 | 3 | 3.983 | 12530.3 |
272 | 2024-12-26 03:45:42 | smallholder | 2 | 86808 | 4 | 11.703 | 7417.6 |
271 | 2024-12-20 22:08:41 | smallholder | 3 | 121633 | 9 | 25.876 | 4700.6 |
270 | 2024-12-19 07:07:18 | smallholder | 3 | 121633 | 9 | 22.533 | 5398.0 |
269 | 2024-12-19 07:07:05 | smallholder | 2 | 86808 | 4 | 9.516 | 9122.3 |
268 | 2024-12-14 03:58:21 | smallholder | 3 | 121633 | 9 | 22.533 | 5398.0 |
267 | 2024-12-13 16:20:25 | smallholder | 4 | 148819 | 30 | 64.266 | 2315.7 |
266 | 2024-12-11 19:52:31 | smallholder | 3 | 121633 | 9 | 19.220 | 6328.5 |
265 | 2024-12-11 19:28:34 | smallholder | 3 | 121633 | 9 | 49.533 | 2455.6 |
264 | 2024-12-11 03:55:39 | smallholder | 4 | 148819 | 30 | 47.283 | 3147.4 |
263 | 2024-12-11 03:55:07 | smallholder | 5 | 164607 | 114 | 69.643 | 2363.6 |
262 | 2024-12-11 03:55:08 | smallholder | 3 | 121633 | 9 | 36.830 | 3302.6 |
261 | 2024-12-11 03:55:26 | smallholder | 2 | 86808 | 4 | 9.420 | 9215.3 |
260 | 2024-12-11 03:54:54 | smallholder | 1 | 49908 | 3 | 3.143 | 15879.1 |
259 | 2024-12-05 09:34:39 | smallholder | 1 | 49908 | 3 | 4.313 | 11571.5 |
258 | 2024-12-05 09:34:08 | smallholder | 1 | 49908 | 3 | 4.170 | 11968.3 |
257 | 2024-12-04 01:08:21 | smallholder | 4 | 148819 | 30 | 23.873 | 6233.8 |
256 | 2024-12-01 00:02:15 | smallholder | 1 | 49908 | 3 | 2.233 | 22350.2 |
255 | 2024-11-30 23:36:12 | smallholder | 4 | 148819 | 30 | 41.626 | 3575.1 |
254 | 2024-11-22 02:12:55 | smallholder | 2 | 86808 | 4 | 11.016 | 7880.2 |
253 | 2024-11-22 02:12:30 | smallholder | 1 | 49908 | 3 | 4.373 | 11412.8 |
252 | 2024-11-15 02:02:41 | smallholder | 2 | 86808 | 4 | 10.173 | 8533.2 |
251 | 2024-11-04 17:31:03 | smallholder | 2 | 86808 | 4 | 11.610 | 7477.0 |
250 | 2024-11-04 17:30:06 | smallholder | 1 | 49908 | 3 | 3.453 | 14453.5 |
249 | 2024-10-26 20:12:26 | smallholder | 1 | 49908 | 3 | 4.110 | 12143.1 |
248 | 2024-10-24 21:43:32 | smallholder | 4 | 148819 | 30 | 63.033 | 2361.0 |
247 | 2024-10-24 05:28:00 | smallholder | 4 | 148819 | 30 | 60.680 | 2452.5 |
246 | 2024-10-22 03:26:09 | smallholder | 4 | 148819 | 30 | 28.423 | 5235.9 |
245 | 2024-10-22 03:26:12 | smallholder | 2 | 86808 | 4 | 12.360 | 7023.3 |
244 | 2024-10-22 03:24:38 | smallholder | 1 | 49908 | 3 | 3.920 | 12731.6 |
243 | 2024-10-11 12:00:03 | smallholder | 3 | 121633 | 9 | 25.630 | 4745.7 |
242 | 2024-10-11 11:56:04 | smallholder | 1 | 49908 | 3 | 3.843 | 12986.7 |
241 | 2024-09-22 04:08:37 | smallholder | 3 | 121633 | 9 | 27.893 | 4360.7 |
240 | 2024-09-21 01:27:28 | smallholder | 3 | 121633 | 9 | 39.893 | 3049.0 |