History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hectares"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
421 | 2024-05-08 21:37:08 | hectares | 1 | 82945 | 3 | 1.483 | 55930.5 |
420 | 2024-05-01 14:43:42 | hectares | 1 | 82945 | 3 | 1.656 | 50087.6 |
419 | 2024-05-01 07:02:03 | hectares | 1 | 82945 | 3 | 1.593 | 52068.4 |
418 | 2024-05-01 06:12:33 | hectares | 2 | 121059 | 18 | 8.003 | 15126.7 |
417 | 2024-05-01 06:12:21 | hectares | 3 | 146162 | 168 | 8.813 | 16584.8 |
416 | 2024-04-30 19:30:49 | hectares | 2 | 121059 | 18 | 8.170 | 14817.5 |
415 | 2024-04-28 21:52:37 | hectares | 2 | 121059 | 18 | 7.593 | 15943.5 |
414 | 2024-04-28 21:52:25 | hectares | 3 | 146162 | 168 | 7.423 | 19690.4 |
413 | 2024-04-23 02:15:14 | hectares | 2 | 121059 | 18 | 3.716 | 32577.8 |
412 | 2024-04-23 02:15:07 | hectares | 1 | 82945 | 3 | 1.563 | 53067.8 |
411 | 2024-04-23 02:14:54 | hectares | 3 | 146162 | 168 | 7.576 | 19292.8 |
410 | 2024-04-20 22:50:46 | hectares | 3 | 146162 | 168 | 24.206 | 6038.3 |
409 | 2024-04-20 15:00:38 | hectares | 3 | 146162 | 168 | 18.720 | 7807.8 |
408 | 2024-04-19 10:18:45 | hectares | 3 | 146162 | 168 | 16.236 | 9002.3 |
407 | 2024-04-19 10:18:48 | hectares | 2 | 121059 | 18 | 10.016 | 12086.6 |
406 | 2024-04-19 10:08:36 | hectares | 1 | 82945 | 3 | 1.700 | 48791.2 |
405 | 2024-04-06 10:31:29 | hectares | 1 | 82945 | 3 | 5.643 | 14698.7 |
404 | 2024-04-05 18:29:46 | hectares | 1 | 82945 | 3 | 3.890 | 21322.6 |
403 | 2024-03-18 21:28:45 | hectares | 2 | 121059 | 18 | 8.483 | 14270.8 |
402 | 2024-03-18 21:28:36 | hectares | 3 | 146162 | 168 | 12.500 | 11693.0 |
401 | 2024-03-18 21:28:36 | hectares | 2 | 121059 | 18 | 3.826 | 31641.1 |
400 | 2024-03-18 21:28:31 | hectares | 1 | 82945 | 3 | 1.486 | 55817.6 |
399 | 2024-03-18 21:28:17 | hectares | 3 | 146162 | 168 | 8.796 | 16616.9 |
398 | 2024-03-18 06:04:50 | hectares | 3 | 146162 | 168 | 16.143 | 9054.2 |
397 | 2024-03-16 15:21:27 | hectares | 3 | 146162 | 168 | 23.233 | 6291.1 |
396 | 2024-03-16 15:21:20 | hectares | 2 | 121059 | 18 | 8.800 | 13756.7 |
395 | 2024-03-16 15:16:59 | hectares | 1 | 82945 | 3 | 1.690 | 49079.9 |
394 | 2024-03-06 09:42:10 | hectares | 1 | 82945 | 3 | 4.360 | 19024.1 |
393 | 2024-02-09 16:44:49 | hectares | 3 | 146162 | 168 | 10.360 | 14108.3 |
392 | 2024-02-06 09:21:18 | hectares | 2 | 121059 | 18 | 4.063 | 29795.5 |
391 | 2024-02-06 08:09:21 | hectares | 2 | 121059 | 18 | 3.670 | 32986.1 |
390 | 2024-02-06 08:09:05 | hectares | 3 | 146162 | 168 | 8.393 | 17414.8 |
389 | 2024-02-05 10:16:18 | hectares | 3 | 146162 | 168 | 16.033 | 9116.3 |
388 | 2024-02-05 08:50:30 | hectares | 3 | 146162 | 168 | 11.236 | 13008.4 |
387 | 2024-02-05 05:27:34 | hectares | 3 | 146162 | 168 | 11.406 | 12814.5 |
386 | 2024-02-04 20:27:51 | hectares | 3 | 146162 | 168 | 8.596 | 17003.5 |
385 | 2024-01-31 13:01:20 | hectares | 1 | 82945 | 3 | 1.470 | 56425.2 |
384 | 2024-01-06 16:35:21 | hectares | 1 | 82945 | 3 | 1.576 | 52630.1 |
383 | 2023-12-23 02:43:50 | hectares | 2 | 121059 | 18 | 3.143 | 38517.0 |
382 | 2023-12-09 19:38:56 | hectares | 3 | 146162 | 168 | 7.376 | 19815.9 |
381 | 2023-12-08 19:57:23 | hectares | 3 | 146162 | 168 | 7.486 | 19524.7 |
380 | 2023-12-08 14:25:44 | hectares | 1 | 82945 | 3 | 1.513 | 54821.5 |
379 | 2023-12-03 19:59:01 | hectares | 3 | 146162 | 168 | 7.796 | 18748.3 |
378 | 2023-11-29 00:01:19 | hectares | 1 | 82945 | 3 | 1.296 | 64000.8 |
377 | 2023-11-26 03:29:14 | hectares | 1 | 82945 | 3 | 1.376 | 60279.8 |
376 | 2023-11-21 12:46:59 | hectares | 1 | 82945 | 3 | 1.250 | 66356.0 |
375 | 2023-11-21 00:02:45 | hectares | 2 | 121059 | 18 | 12.753 | 9492.6 |
374 | 2023-11-21 00:02:27 | hectares | 3 | 146162 | 168 | 16.796 | 8702.2 |
373 | 2023-11-10 21:45:51 | hectares | 3 | 146162 | 168 | 7.110 | 20557.2 |
372 | 2023-10-31 12:18:26 | hectares | 1 | 82945 | 3 | 1.470 | 56425.2 |
371 | 2023-10-22 10:58:31 | hectares | 1 | 82945 | 3 | 3.033 | 27347.5 |
370 | 2023-10-21 07:35:17 | hectares | 1 | 82945 | 3 | 1.406 | 58993.6 |
369 | 2023-10-15 02:49:13 | hectares | 1 | 82945 | 3 | 1.406 | 58993.6 |
368 | 2023-10-08 05:46:28 | hectares | 1 | 82945 | 3 | 1.360 | 60989.0 |
367 | 2023-09-28 23:04:25 | hectares | 1 | 82945 | 3 | 1.453 | 57085.3 |
366 | 2023-09-25 11:30:10 | hectares | 2 | 121059 | 18 | 3.750 | 32282.4 |
365 | 2023-09-17 01:26:34 | hectares | 1 | 82945 | 3 | 1.470 | 56425.2 |
364 | 2023-09-11 19:44:04 | hectares | 1 | 82945 | 3 | 1.376 | 60279.8 |
363 | 2023-09-07 14:19:19 | hectares | 1 | 82945 | 3 | 1.423 | 58288.8 |
362 | 2023-08-14 01:55:58 | hectares | 3 | 146162 | 168 | 6.720 | 21750.3 |
361 | 2023-08-06 22:13:16 | hectares | 1 | 82945 | 3 | 1.403 | 59119.7 |
360 | 2023-08-04 07:10:28 | hectares | 1 | 82945 | 3 | 2.093 | 39629.7 |
359 | 2023-07-09 10:55:33 | hectares | 1 | 82945 | 3 | 1.360 | 60989.0 |
358 | 2023-07-05 11:42:17 | hectares | 2 | 121059 | 18 | 3.140 | 38553.8 |
357 | 2023-06-20 22:43:24 | hectares | 1 | 82945 | 3 | 2.123 | 39069.7 |
356 | 2023-05-21 15:54:43 | hectares | 1 | 82945 | 3 | 1.233 | 67270.9 |
355 | 2023-04-27 02:57:01 | hectares | 3 | 146162 | 168 | 7.190 | 20328.5 |
354 | 2023-04-01 09:57:28 | hectares | 1 | 82945 | 3 | 1.266 | 65517.4 |
353 | 2023-03-23 22:44:14 | hectares | 2 | 121059 | 18 | 3.220 | 37596.0 |
352 | 2023-03-19 15:47:49 | hectares | 2 | 121059 | 18 | 3.546 | 34139.6 |
351 | 2023-02-04 20:40:34 | hectares | 1 | 82945 | 3 | 1.250 | 66356.0 |
350 | 2023-02-04 19:22:08 | hectares | 2 | 121059 | 18 | 3.593 | 33693.0 |
349 | 2023-02-01 00:40:32 | hectares | 3 | 146162 | 168 | 6.063 | 24107.2 |
348 | 2023-01-29 11:07:22 | hectares | 3 | 146162 | 168 | 6.360 | 22981.4 |
347 | 2023-01-14 12:27:55 | hectares | 1 | 82945 | 3 | 1.390 | 59672.7 |
346 | 2022-12-22 13:17:23 | hectares | 2 | 121059 | 18 | 3.703 | 32692.1 |
345 | 2022-12-22 13:00:19 | hectares | 3 | 146162 | 168 | 6.143 | 23793.3 |
344 | 2022-12-18 01:49:26 | hectares | 3 | 146162 | 168 | 7.593 | 19249.6 |
343 | 2022-12-17 15:23:04 | hectares | 1 | 82945 | 3 | 1.283 | 64649.3 |
342 | 2022-11-11 11:53:14 | hectares | 3 | 146162 | 168 | 7.126 | 20511.1 |
341 | 2022-11-06 18:00:45 | hectares | 1 | 82945 | 3 | 1.266 | 65517.4 |
340 | 2022-10-31 01:43:02 | hectares | 1 | 82945 | 3 | 1.250 | 66356.0 |
339 | 2022-10-22 02:19:43 | hectares | 1 | 82945 | 3 | 1.250 | 66356.0 |
338 | 2022-08-19 06:42:35 | hectares | 2 | 121059 | 18 | 3.080 | 39304.9 |
337 | 2022-07-02 03:48:01 | hectares | 1 | 82945 | 3 | 1.296 | 64000.8 |
336 | 2022-06-19 04:09:25 | hectares | 1 | 82945 | 3 | 1.236 | 67107.6 |
335 | 2022-06-04 02:42:49 | hectares | 3 | 146162 | 168 | 6.310 | 23163.5 |
334 | 2022-03-11 17:31:24 | hectares | 1 | 82945 | 3 | 1.343 | 61761.0 |
333 | 2022-02-15 18:58:38 | hectares | 1 | 82945 | 3 | 1.453 | 57085.3 |
332 | 2022-02-13 14:54:44 | hectares | 1 | 82945 | 3 | 1.283 | 64649.3 |
331 | 2022-01-27 14:48:12 | hectares | 3 | 146162 | 168 | 6.626 | 22058.9 |
330 | 2021-12-17 17:05:43 | hectares | 1 | 82945 | 3 | 1.486 | 55817.6 |
329 | 2021-12-01 10:43:28 | hectares | 1 | 82945 | 3 | 2.830 | 29309.2 |
328 | 2021-08-21 16:51:05 | hectares | 1 | 82945 | 3 | 1.250 | 66356.0 |
327 | 2021-07-28 11:34:30 | hectares | 2 | 121059 | 18 | 3.923 | 30858.8 |
326 | 2021-07-09 09:27:30 | hectares | 3 | 146162 | 168 | 7.296 | 20033.2 |
325 | 2021-06-21 07:23:44 | hectares | 2 | 121059 | 18 | 3.173 | 38152.9 |
324 | 2021-06-06 21:20:33 | hectares | 2 | 121059 | 18 | 3.843 | 31501.2 |
323 | 2021-06-05 19:01:51 | hectares | 2 | 121059 | 18 | 3.700 | 32718.6 |
322 | 2021-06-04 16:40:00 | hectares | 2 | 121059 | 18 | 3.173 | 38152.9 |