History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stems"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
660 | 2024-04-27 10:01:20 | stems | 1 | 28756 | 9 | 0.563 | 51076.4 |
659 | 2024-04-08 15:06:02 | stems | 1 | 28756 | 9 | 1.733 | 16593.2 |
658 | 2024-04-06 07:29:18 | stems | 1 | 28756 | 9 | 1.110 | 25906.3 |
657 | 2024-03-31 02:13:45 | stems | 2 | 53800 | 177 | 1.750 | 30742.9 |
656 | 2024-03-30 20:52:39 | stems | 2 | 53800 | 177 | 4.690 | 11471.2 |
655 | 2024-03-30 20:49:32 | stems | 1 | 28756 | 9 | 0.546 | 52666.7 |
654 | 2024-03-26 22:07:51 | stems | 1 | 28756 | 9 | 1.750 | 16432.0 |
653 | 2024-03-26 21:28:47 | stems | 1 | 28756 | 9 | 0.576 | 49923.6 |
652 | 2024-03-07 06:44:35 | stems | 2 | 53800 | 177 | 1.766 | 30464.3 |
651 | 2024-03-07 04:52:23 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
650 | 2024-02-25 18:29:11 | stems | 2 | 53800 | 177 | 1.656 | 32487.9 |
649 | 2024-02-25 18:29:07 | stems | 1 | 28756 | 9 | 0.486 | 59168.7 |
648 | 2024-02-25 18:29:03 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
647 | 2024-02-03 19:42:03 | stems | 1 | 28756 | 9 | 0.420 | 68466.7 |
646 | 2024-01-13 16:39:16 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
645 | 2024-01-11 23:09:42 | stems | 1 | 28756 | 9 | 0.513 | 56054.6 |
644 | 2024-01-02 22:26:35 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
643 | 2023-12-17 05:40:44 | stems | 1 | 28756 | 9 | 0.440 | 65354.5 |
642 | 2023-12-06 02:02:25 | stems | 2 | 53800 | 177 | 1.530 | 35163.4 |
641 | 2023-12-03 10:34:59 | stems | 1 | 28756 | 9 | 0.470 | 61183.0 |
640 | 2023-12-03 10:34:58 | stems | 1 | 28756 | 9 | 0.500 | 57512.0 |
639 | 2023-11-18 10:31:19 | stems | 1 | 28756 | 9 | 1.143 | 25158.4 |
638 | 2023-11-16 21:13:05 | stems | 1 | 28756 | 9 | 0.546 | 52666.7 |
637 | 2023-11-10 15:43:01 | stems | 1 | 28756 | 9 | 0.563 | 51076.4 |
636 | 2023-11-09 10:25:48 | stems | 1 | 28756 | 9 | 0.516 | 55728.7 |
635 | 2023-10-30 15:50:51 | stems | 2 | 53800 | 177 | 1.720 | 31279.1 |
634 | 2023-10-25 23:20:06 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
633 | 2023-10-23 03:05:04 | stems | 1 | 28756 | 9 | 0.733 | 39230.6 |
632 | 2023-10-19 03:51:43 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
631 | 2023-10-13 17:16:00 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
630 | 2023-10-07 20:31:21 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
629 | 2023-09-29 06:50:02 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
628 | 2023-09-28 14:47:30 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
627 | 2023-09-25 01:00:16 | stems | 1 | 28756 | 9 | 0.530 | 54256.6 |
626 | 2023-08-29 04:46:23 | stems | 1 | 28756 | 9 | 1.016 | 28303.1 |
625 | 2023-08-28 11:55:24 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
624 | 2023-08-28 07:54:33 | stems | 1 | 28756 | 9 | 0.470 | 61183.0 |
623 | 2023-06-03 09:16:35 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
622 | 2023-05-07 15:12:23 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
621 | 2023-03-27 12:28:11 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
620 | 2023-01-14 03:05:21 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
619 | 2023-01-10 17:38:47 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
618 | 2022-10-16 23:12:44 | stems | 1 | 28756 | 9 | 0.440 | 65354.5 |
617 | 2022-09-15 17:50:03 | stems | 1 | 28756 | 9 | 0.466 | 61708.2 |
616 | 2022-07-29 04:56:23 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
615 | 2022-06-08 04:16:31 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
614 | 2022-06-06 00:10:08 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
613 | 2022-05-06 11:46:31 | stems | 1 | 28756 | 9 | 0.546 | 52666.7 |
612 | 2022-04-27 21:47:35 | stems | 2 | 53800 | 177 | 1.546 | 34799.5 |
611 | 2022-03-25 13:34:46 | stems | 2 | 53800 | 177 | 2.156 | 24953.6 |
610 | 2022-03-19 21:37:29 | stems | 2 | 53800 | 177 | 1.546 | 34799.5 |
609 | 2022-02-15 20:41:03 | stems | 1 | 28756 | 9 | 0.500 | 57512.0 |
608 | 2022-01-25 19:47:43 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
607 | 2021-12-07 06:03:52 | stems | 1 | 28756 | 9 | 0.516 | 55728.7 |
606 | 2021-10-30 18:04:31 | stems | 1 | 28756 | 9 | 0.516 | 55728.7 |
605 | 2021-10-29 18:57:09 | stems | 1 | 28756 | 9 | 0.500 | 57512.0 |
604 | 2021-10-27 00:07:32 | stems | 1 | 28756 | 9 | 0.500 | 57512.0 |
603 | 2021-10-14 13:55:50 | stems | 1 | 28756 | 9 | 0.530 | 54256.6 |
602 | 2021-10-12 11:03:34 | stems | 1 | 28756 | 9 | 0.533 | 53951.2 |
601 | 2021-09-21 14:04:43 | stems | 1 | 28756 | 9 | 0.936 | 30722.2 |
600 | 2021-09-20 09:43:42 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
599 | 2021-09-13 22:11:49 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
598 | 2021-09-10 17:50:39 | stems | 1 | 28756 | 9 | 0.530 | 54256.6 |
597 | 2021-08-24 02:48:09 | stems | 1 | 28756 | 9 | 0.516 | 55728.7 |
596 | 2021-07-15 02:36:32 | stems | 2 | 53800 | 177 | 1.423 | 37807.4 |
595 | 2021-07-11 07:32:05 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
594 | 2021-05-28 00:27:54 | stems | 1 | 28756 | 9 | 0.516 | 55728.7 |
593 | 2021-05-15 09:12:37 | stems | 1 | 28756 | 9 | 0.470 | 61183.0 |
592 | 2021-05-02 05:24:31 | stems | 1 | 28756 | 9 | 0.533 | 53951.2 |
591 | 2021-04-07 09:14:43 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
590 | 2021-04-03 10:02:25 | stems | 1 | 28756 | 9 | 0.470 | 61183.0 |
589 | 2021-04-03 05:29:24 | stems | 1 | 28756 | 9 | 0.500 | 57512.0 |
588 | 2021-03-21 18:31:21 | stems | 2 | 53800 | 177 | 1.720 | 31279.1 |
587 | 2021-03-20 18:13:44 | stems | 2 | 53800 | 177 | 1.643 | 32745.0 |
586 | 2021-03-18 04:58:59 | stems | 1 | 28756 | 9 | 0.546 | 52666.7 |
585 | 2021-01-28 00:54:42 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
584 | 2021-01-19 11:11:32 | stems | 2 | 53800 | 177 | 1.373 | 39184.3 |
583 | 2020-12-22 04:39:00 | stems | 1 | 28756 | 9 | 0.470 | 61183.0 |
582 | 2020-11-24 16:16:38 | stems | 2 | 53800 | 177 | 1.376 | 39098.8 |
581 | 2020-10-30 11:27:37 | stems | 2 | 53800 | 177 | 1.373 | 39184.3 |
580 | 2020-10-29 13:44:51 | stems | 1 | 28756 | 9 | 0.546 | 52666.7 |
579 | 2020-10-26 22:43:14 | stems | 1 | 28756 | 9 | 0.516 | 55728.7 |
578 | 2020-10-24 21:59:22 | stems | 2 | 53800 | 177 | 1.610 | 33416.1 |
577 | 2020-10-22 06:22:27 | stems | 1 | 28756 | 9 | 0.516 | 55728.7 |
576 | 2020-10-02 01:56:34 | stems | 1 | 28756 | 9 | 0.440 | 65354.5 |
575 | 2020-09-18 04:40:51 | stems | 1 | 28756 | 9 | 0.530 | 54256.6 |
574 | 2020-09-13 11:18:03 | stems | 2 | 53800 | 177 | 1.593 | 33772.8 |
573 | 2020-09-04 15:07:50 | stems | 1 | 28756 | 9 | 0.500 | 57512.0 |
572 | 2020-08-30 15:53:56 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
571 | 2020-08-30 04:45:22 | stems | 1 | 28756 | 9 | 0.436 | 65954.1 |
570 | 2020-07-29 14:52:32 | stems | 1 | 28756 | 9 | 0.483 | 59536.2 |
569 | 2020-06-19 04:44:22 | stems | 2 | 53800 | 177 | 1.420 | 37887.3 |
568 | 2020-06-17 13:16:28 | stems | 2 | 53800 | 177 | 1.610 | 33416.1 |
567 | 2020-06-14 13:41:30 | stems | 2 | 53800 | 177 | 1.406 | 38264.6 |
566 | 2020-06-13 12:57:36 | stems | 2 | 53800 | 177 | 1.436 | 37465.2 |
565 | 2020-06-12 13:45:15 | stems | 2 | 53800 | 177 | 1.560 | 34487.2 |
564 | 2020-06-12 01:56:32 | stems | 2 | 53800 | 177 | 1.420 | 37887.3 |
563 | 2020-06-08 05:37:26 | stems | 1 | 28756 | 9 | 0.453 | 63479.0 |
562 | 2020-06-07 14:34:40 | stems | 2 | 53800 | 177 | 1.593 | 33772.8 |
561 | 2020-06-06 15:04:54 | stems | 2 | 53800 | 177 | 1.700 | 31647.1 |