History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shrub"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
504 | 2024-03-28 20:41:57 | shrub | 1 | 28756 | 5 | 0.546 | 52666.7 |
503 | 2024-03-05 22:27:34 | shrub | 3 | 83667 | 611 | 4.466 | 18734.2 |
502 | 2024-03-05 22:27:35 | shrub | 2 | 53800 | 45 | 3.563 | 15099.6 |
501 | 2024-03-05 22:27:32 | shrub | 1 | 28756 | 5 | 0.560 | 51350.0 |
500 | 2024-03-04 06:33:21 | shrub | 1 | 28756 | 5 | 0.546 | 52666.7 |
499 | 2024-03-01 11:51:37 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
498 | 2024-02-27 12:15:46 | shrub | 2 | 53800 | 45 | 1.733 | 31044.4 |
497 | 2024-02-27 12:15:27 | shrub | 3 | 83667 | 611 | 7.326 | 11420.6 |
496 | 2024-02-26 07:53:45 | shrub | 3 | 83667 | 611 | 4.563 | 18336.0 |
495 | 2024-02-26 07:53:45 | shrub | 2 | 53800 | 45 | 1.686 | 31909.8 |
494 | 2024-02-26 07:53:19 | shrub | 1 | 28756 | 5 | 0.453 | 63479.0 |
493 | 2024-02-03 00:42:59 | shrub | 1 | 28756 | 5 | 0.450 | 63902.2 |
492 | 2024-01-28 23:09:51 | shrub | 1 | 28756 | 5 | 0.470 | 61183.0 |
491 | 2024-01-27 03:11:09 | shrub | 1 | 28756 | 5 | 0.423 | 67981.1 |
490 | 2024-01-02 07:13:07 | shrub | 1 | 28756 | 5 | 1.076 | 26724.9 |
489 | 2024-01-01 14:34:26 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
488 | 2023-12-31 23:58:09 | shrub | 2 | 53800 | 45 | 1.546 | 34799.5 |
487 | 2023-12-14 04:24:08 | shrub | 3 | 83667 | 611 | 3.983 | 21006.0 |
486 | 2023-12-09 10:00:46 | shrub | 3 | 83667 | 611 | 3.890 | 21508.2 |
485 | 2023-12-09 10:00:45 | shrub | 2 | 53800 | 45 | 1.733 | 31044.4 |
484 | 2023-12-09 05:36:05 | shrub | 3 | 83667 | 611 | 3.453 | 24230.2 |
483 | 2023-11-28 07:55:30 | shrub | 1 | 28756 | 5 | 0.513 | 56054.6 |
482 | 2023-11-18 12:52:59 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
481 | 2023-11-11 04:06:38 | shrub | 3 | 83667 | 611 | 3.750 | 22311.2 |
480 | 2023-11-05 15:56:15 | shrub | 2 | 53800 | 45 | 1.576 | 34137.1 |
479 | 2023-11-05 15:56:13 | shrub | 3 | 83667 | 611 | 3.420 | 24464.0 |
478 | 2023-11-03 09:19:05 | shrub | 1 | 28756 | 5 | 0.453 | 63479.0 |
477 | 2023-10-28 10:41:36 | shrub | 1 | 28756 | 5 | 0.470 | 61183.0 |
476 | 2023-10-24 21:03:37 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
475 | 2023-10-21 04:05:03 | shrub | 1 | 28756 | 5 | 0.516 | 55728.7 |
474 | 2023-10-14 17:34:26 | shrub | 1 | 28756 | 5 | 0.513 | 56054.6 |
473 | 2023-10-08 18:47:16 | shrub | 1 | 28756 | 5 | 0.750 | 38341.3 |
472 | 2023-10-04 08:34:51 | shrub | 2 | 53800 | 45 | 1.546 | 34799.5 |
471 | 2023-09-26 22:16:29 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
470 | 2023-09-24 02:54:01 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
469 | 2023-08-24 03:57:16 | shrub | 1 | 28756 | 5 | 0.486 | 59168.7 |
468 | 2023-08-19 00:30:42 | shrub | 1 | 28756 | 5 | 0.450 | 63902.2 |
467 | 2023-07-15 04:59:56 | shrub | 2 | 53800 | 45 | 1.376 | 39098.8 |
466 | 2023-05-20 23:26:20 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
465 | 2023-04-22 02:56:49 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
464 | 2023-04-01 02:41:25 | shrub | 2 | 53800 | 45 | 1.533 | 35094.6 |
463 | 2023-03-18 20:49:14 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
462 | 2023-01-05 00:35:29 | shrub | 1 | 28756 | 5 | 0.423 | 67981.1 |
461 | 2022-12-30 03:00:46 | shrub | 2 | 53800 | 45 | 1.360 | 39558.8 |
460 | 2022-12-18 14:15:25 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
459 | 2022-09-30 20:37:32 | shrub | 1 | 28756 | 5 | 0.453 | 63479.0 |
458 | 2022-08-30 11:31:11 | shrub | 2 | 53800 | 45 | 1.513 | 35558.5 |
457 | 2022-08-15 05:28:50 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
456 | 2022-07-15 07:37:42 | shrub | 3 | 83667 | 611 | 3.280 | 25508.2 |
455 | 2022-05-17 19:31:50 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
454 | 2022-04-18 00:11:57 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
453 | 2022-03-29 11:48:31 | shrub | 2 | 53800 | 45 | 1.830 | 29398.9 |
452 | 2022-02-01 10:45:47 | shrub | 1 | 28756 | 5 | 0.576 | 49923.6 |
451 | 2022-01-30 06:59:34 | shrub | 1 | 28756 | 5 | 0.516 | 55728.7 |
450 | 2021-12-26 16:55:52 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
449 | 2021-12-12 02:04:01 | shrub | 2 | 53800 | 45 | 1.546 | 34799.5 |
448 | 2021-11-25 10:58:45 | shrub | 1 | 28756 | 5 | 0.563 | 51076.4 |
447 | 2021-10-04 22:00:08 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
446 | 2021-10-02 19:21:55 | shrub | 1 | 28756 | 5 | 0.483 | 59536.2 |
445 | 2021-09-30 18:43:06 | shrub | 3 | 83667 | 611 | 3.950 | 21181.5 |
444 | 2021-09-29 19:47:11 | shrub | 3 | 83667 | 611 | 3.236 | 25855.1 |
443 | 2021-09-28 14:10:30 | shrub | 3 | 83667 | 611 | 3.373 | 24804.9 |
442 | 2021-09-27 16:35:39 | shrub | 3 | 83667 | 611 | 4.110 | 20356.9 |
441 | 2021-09-21 17:02:33 | shrub | 3 | 83667 | 611 | 3.423 | 24442.6 |
440 | 2021-09-20 23:59:43 | shrub | 3 | 83667 | 611 | 3.640 | 22985.4 |
439 | 2021-09-19 22:10:12 | shrub | 3 | 83667 | 611 | 3.640 | 22985.4 |
438 | 2021-09-13 14:28:01 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
437 | 2021-09-09 21:19:25 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
436 | 2021-07-09 11:54:40 | shrub | 1 | 28756 | 5 | 0.576 | 49923.6 |
435 | 2021-06-17 00:00:22 | shrub | 3 | 83667 | 611 | 3.983 | 21006.0 |
434 | 2021-06-15 18:27:57 | shrub | 3 | 83667 | 611 | 3.220 | 25983.5 |
433 | 2021-06-15 01:04:40 | shrub | 3 | 83667 | 611 | 3.563 | 23482.2 |
432 | 2021-06-05 15:23:55 | shrub | 1 | 28756 | 5 | 0.970 | 29645.4 |
431 | 2021-04-26 19:36:32 | shrub | 1 | 28756 | 5 | 1.033 | 27837.4 |
430 | 2021-03-03 12:13:14 | shrub | 1 | 28756 | 5 | 0.516 | 55728.7 |
429 | 2021-02-21 23:52:26 | shrub | 3 | 83667 | 611 | 3.216 | 26015.9 |
428 | 2021-02-05 03:53:26 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
427 | 2020-11-23 04:16:36 | shrub | 1 | 28756 | 5 | 0.483 | 59536.2 |
426 | 2020-11-09 12:25:38 | shrub | 1 | 28756 | 5 | 0.513 | 56054.6 |
425 | 2020-11-03 07:05:12 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
424 | 2020-08-25 17:04:54 | shrub | 1 | 28756 | 5 | 0.453 | 63479.0 |
423 | 2020-08-06 13:06:54 | shrub | 1 | 28756 | 5 | 0.513 | 56054.6 |
422 | 2020-05-29 04:50:07 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
421 | 2020-05-01 22:54:38 | shrub | 1 | 28756 | 5 | 0.470 | 61183.0 |
420 | 2020-03-28 12:58:31 | shrub | 3 | 83667 | 611 | 4.296 | 19475.6 |
419 | 2020-03-28 04:08:15 | shrub | 3 | 83667 | 611 | 3.903 | 21436.6 |
418 | 2020-03-25 15:57:13 | shrub | 1 | 28756 | 5 | 0.500 | 57512.0 |
417 | 2020-03-24 11:14:39 | shrub | 1 | 28756 | 5 | 0.453 | 63479.0 |
416 | 2020-03-23 16:28:30 | shrub | 1 | 28756 | 5 | 0.513 | 56054.6 |
415 | 2020-03-23 08:36:31 | shrub | 1 | 28756 | 5 | 0.546 | 52666.7 |
414 | 2020-03-21 16:29:19 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
413 | 2020-03-18 06:20:44 | shrub | 1 | 28756 | 5 | 0.516 | 55728.7 |
412 | 2020-03-06 19:25:26 | shrub | 1 | 28756 | 5 | 0.436 | 65954.1 |
411 | 2020-02-27 02:16:08 | shrub | 1 | 28756 | 5 | 0.766 | 37540.5 |
410 | 2020-02-26 23:50:09 | shrub | 1 | 28756 | 5 | 0.530 | 54256.6 |
409 | 2020-02-25 00:50:02 | shrub | 1 | 28756 | 5 | 0.533 | 53951.2 |
408 | 2020-02-24 00:19:15 | shrub | 1 | 28756 | 5 | 0.546 | 52666.7 |
407 | 2020-02-23 16:49:44 | shrub | 1 | 28756 | 5 | 0.530 | 54256.6 |
406 | 2020-02-23 14:23:16 | shrub | 1 | 28756 | 5 | 1.126 | 25538.2 |
405 | 2020-02-12 16:50:20 | shrub | 3 | 83667 | 611 | 3.546 | 23594.8 |