History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"circa"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
715 | 2024-04-19 01:57:16 | circa | 2 | 53800 | 36 | 1.516 | 35488.1 |
714 | 2024-04-06 05:56:18 | circa | 1 | 28756 | 1 | 0.546 | 52666.7 |
713 | 2024-03-31 15:39:33 | circa | 1 | 28756 | 1 | 0.530 | 54256.6 |
712 | 2024-03-31 00:46:28 | circa | 2 | 53800 | 36 | 4.576 | 11757.0 |
711 | 2024-03-30 23:40:21 | circa | 2 | 53800 | 36 | 2.190 | 24566.2 |
710 | 2024-03-30 23:39:57 | circa | 3 | 83667 | 808 | 4.690 | 17839.4 |
709 | 2024-03-30 20:03:07 | circa | 3 | 83667 | 808 | 9.780 | 8554.9 |
708 | 2024-03-29 23:57:41 | circa | 3 | 83667 | 808 | 8.800 | 9507.6 |
707 | 2024-03-29 23:57:43 | circa | 2 | 53800 | 36 | 3.753 | 14335.2 |
706 | 2024-03-29 23:57:19 | circa | 1 | 28756 | 1 | 1.143 | 25158.4 |
705 | 2024-03-08 23:46:58 | circa | 2 | 53800 | 36 | 1.796 | 29955.5 |
704 | 2024-03-08 23:46:33 | circa | 3 | 83667 | 808 | 5.280 | 15846.0 |
703 | 2024-03-08 21:12:22 | circa | 1 | 28756 | 1 | 0.606 | 47452.1 |
702 | 2024-03-07 20:53:48 | circa | 3 | 83667 | 808 | 4.126 | 20278.0 |
701 | 2024-03-07 03:19:58 | circa | 3 | 83667 | 808 | 10.123 | 8265.0 |
700 | 2024-03-07 03:19:56 | circa | 2 | 53800 | 36 | 2.626 | 20487.4 |
699 | 2024-03-07 02:09:49 | circa | 1 | 28756 | 1 | 0.470 | 61183.0 |
698 | 2024-03-06 00:03:14 | circa | 1 | 28756 | 1 | 1.686 | 17055.8 |
697 | 2024-03-01 12:50:14 | circa | 1 | 28756 | 1 | 0.466 | 61708.2 |
696 | 2024-02-29 06:33:40 | circa | 2 | 53800 | 36 | 1.813 | 29674.6 |
695 | 2024-02-29 06:33:10 | circa | 3 | 83667 | 808 | 3.906 | 21420.1 |
694 | 2024-02-28 20:13:03 | circa | 3 | 83667 | 808 | 4.063 | 20592.4 |
693 | 2024-02-28 20:05:07 | circa | 1 | 28756 | 1 | 0.530 | 54256.6 |
692 | 2024-02-18 07:59:58 | circa | 1 | 28756 | 1 | 1.623 | 17717.8 |
691 | 2024-02-03 19:43:35 | circa | 1 | 28756 | 1 | 0.420 | 68466.7 |
690 | 2024-01-29 09:52:35 | circa | 1 | 28756 | 1 | 0.500 | 57512.0 |
689 | 2024-01-29 07:21:21 | circa | 1 | 28756 | 1 | 0.516 | 55728.7 |
688 | 2024-01-21 00:01:42 | circa | 1 | 28756 | 1 | 0.516 | 55728.7 |
687 | 2024-01-17 12:15:42 | circa | 2 | 53800 | 36 | 1.560 | 34487.2 |
686 | 2024-01-17 12:12:41 | circa | 3 | 83667 | 808 | 4.016 | 20833.4 |
685 | 2024-01-02 08:02:38 | circa | 2 | 53800 | 36 | 1.470 | 36598.6 |
684 | 2024-01-02 08:02:35 | circa | 3 | 83667 | 808 | 3.596 | 23266.7 |
683 | 2024-01-01 02:14:10 | circa | 3 | 83667 | 808 | 3.953 | 21165.4 |
682 | 2024-01-01 02:14:12 | circa | 2 | 53800 | 36 | 1.690 | 31834.3 |
681 | 2023-12-30 23:13:14 | circa | 3 | 83667 | 808 | 3.343 | 25027.5 |
680 | 2023-12-17 15:21:27 | circa | 2 | 53800 | 36 | 1.563 | 34421.0 |
679 | 2023-12-03 12:31:40 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
678 | 2023-12-03 12:31:39 | circa | 1 | 28756 | 1 | 0.500 | 57512.0 |
677 | 2023-11-17 08:07:09 | circa | 1 | 28756 | 1 | 0.440 | 65354.5 |
676 | 2023-11-14 23:16:12 | circa | 2 | 53800 | 36 | 1.580 | 34050.6 |
675 | 2023-11-14 23:16:09 | circa | 3 | 83667 | 808 | 3.766 | 22216.4 |
674 | 2023-11-14 16:42:45 | circa | 1 | 28756 | 1 | 0.440 | 65354.5 |
673 | 2023-11-13 15:24:07 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
672 | 2023-11-09 03:41:27 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
671 | 2023-11-05 19:25:32 | circa | 1 | 28756 | 1 | 0.483 | 59536.2 |
670 | 2023-11-03 07:10:51 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
669 | 2023-11-02 07:16:04 | circa | 3 | 83667 | 808 | 8.516 | 9824.7 |
668 | 2023-11-02 07:16:01 | circa | 2 | 53800 | 36 | 1.783 | 30173.9 |
667 | 2023-11-02 06:16:27 | circa | 1 | 28756 | 1 | 0.516 | 55728.7 |
666 | 2023-10-21 10:11:18 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
665 | 2023-10-18 11:38:03 | circa | 1 | 28756 | 1 | 0.516 | 55728.7 |
664 | 2023-10-11 14:02:29 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
663 | 2023-10-05 05:21:57 | circa | 1 | 28756 | 1 | 0.470 | 61183.0 |
662 | 2023-10-03 14:32:47 | circa | 3 | 83667 | 808 | 5.783 | 14467.8 |
661 | 2023-10-03 08:14:29 | circa | 3 | 83667 | 808 | 3.326 | 25155.4 |
660 | 2023-09-25 23:15:40 | circa | 1 | 28756 | 1 | 0.470 | 61183.0 |
659 | 2023-09-22 15:59:26 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
658 | 2023-09-17 15:07:28 | circa | 2 | 53800 | 36 | 1.360 | 39558.8 |
657 | 2023-09-04 08:21:44 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
656 | 2023-07-25 20:10:56 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
655 | 2023-07-15 07:09:58 | circa | 3 | 83667 | 808 | 3.796 | 22040.8 |
654 | 2023-06-12 11:15:19 | circa | 2 | 53800 | 36 | 1.783 | 30173.9 |
653 | 2023-04-21 07:38:21 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
652 | 2023-04-01 03:52:28 | circa | 3 | 83667 | 808 | 3.890 | 21508.2 |
651 | 2023-03-15 16:53:31 | circa | 2 | 53800 | 36 | 1.360 | 39558.8 |
650 | 2023-01-14 10:42:20 | circa | 1 | 28756 | 1 | 0.500 | 57512.0 |
649 | 2023-01-05 04:08:32 | circa | 1 | 28756 | 1 | 0.486 | 59168.7 |
648 | 2022-12-28 13:23:43 | circa | 3 | 83667 | 808 | 3.250 | 25743.7 |
647 | 2022-12-18 08:50:23 | circa | 2 | 53800 | 36 | 1.360 | 39558.8 |
646 | 2022-11-25 06:36:39 | circa | 1 | 28756 | 1 | 0.470 | 61183.0 |
645 | 2022-11-03 17:23:54 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
644 | 2022-09-14 08:01:06 | circa | 1 | 28756 | 1 | 0.470 | 61183.0 |
643 | 2022-09-01 06:13:17 | circa | 1 | 28756 | 1 | 0.466 | 61708.2 |
642 | 2022-08-28 18:34:23 | circa | 3 | 83667 | 808 | 3.253 | 25720.0 |
641 | 2022-08-15 19:11:02 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
640 | 2022-08-13 15:45:47 | circa | 2 | 53800 | 36 | 1.546 | 34799.5 |
639 | 2022-07-29 01:46:16 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
638 | 2022-07-18 11:55:45 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
637 | 2022-07-03 14:29:41 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
636 | 2022-06-22 16:27:40 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
635 | 2022-06-20 11:16:34 | circa | 1 | 28756 | 1 | 0.440 | 65354.5 |
634 | 2022-06-16 21:37:51 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
633 | 2022-06-08 17:59:25 | circa | 1 | 28756 | 1 | 0.593 | 48492.4 |
632 | 2022-06-01 18:38:46 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
631 | 2022-06-01 14:14:48 | circa | 1 | 28756 | 1 | 0.483 | 59536.2 |
630 | 2022-06-01 08:04:41 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
629 | 2022-05-25 17:54:08 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
628 | 2022-03-12 20:08:23 | circa | 1 | 28756 | 1 | 0.500 | 57512.0 |
627 | 2022-02-17 22:06:21 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
626 | 2021-11-25 23:21:25 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
625 | 2021-11-23 21:17:47 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
624 | 2021-11-13 05:26:03 | circa | 1 | 28756 | 1 | 0.483 | 59536.2 |
623 | 2021-10-11 17:50:03 | circa | 1 | 28756 | 1 | 0.483 | 59536.2 |
622 | 2021-10-09 14:20:56 | circa | 1 | 28756 | 1 | 0.500 | 57512.0 |
621 | 2021-09-03 04:58:23 | circa | 1 | 28756 | 1 | 0.436 | 65954.1 |
620 | 2021-08-16 15:16:12 | circa | 1 | 28756 | 1 | 0.453 | 63479.0 |
619 | 2021-08-10 07:17:24 | circa | 1 | 28756 | 1 | 0.500 | 57512.0 |
618 | 2021-07-22 07:08:28 | circa | 1 | 28756 | 1 | 0.483 | 59536.2 |
617 | 2021-06-28 15:56:24 | circa | 1 | 28756 | 1 | 0.470 | 61183.0 |
616 | 2021-01-25 03:01:25 | circa | 1 | 28756 | 1 | 0.500 | 57512.0 |