History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bosun"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
746 | 2024-04-05 00:00:41 | bosun | 2 | 53800 | 39 | 6.250 | 8608.0 |
745 | 2024-04-05 00:00:31 | bosun | 1 | 28756 | 3 | 1.030 | 27918.4 |
744 | 2024-04-04 19:35:31 | bosun | 3 | 83667 | 788 | 12.016 | 6963.0 |
743 | 2024-04-03 08:32:26 | bosun | 2 | 53800 | 39 | 2.343 | 22962.0 |
742 | 2024-04-03 08:32:21 | bosun | 3 | 83667 | 788 | 5.420 | 15436.7 |
741 | 2024-04-03 08:32:11 | bosun | 1 | 28756 | 3 | 1.736 | 16564.5 |
740 | 2024-04-03 08:32:00 | bosun | 3 | 83667 | 788 | 5.623 | 14879.4 |
739 | 2024-04-03 08:31:58 | bosun | 2 | 53800 | 39 | 2.033 | 26463.4 |
738 | 2024-04-03 08:31:52 | bosun | 1 | 28756 | 3 | 1.203 | 23903.6 |
737 | 2024-03-31 15:58:47 | bosun | 1 | 28756 | 3 | 0.533 | 53951.2 |
736 | 2024-03-29 09:40:33 | bosun | 1 | 28756 | 3 | 0.486 | 59168.7 |
735 | 2024-03-29 02:10:24 | bosun | 1 | 28756 | 3 | 0.546 | 52666.7 |
734 | 2024-03-18 11:18:33 | bosun | 1 | 28756 | 3 | 0.530 | 54256.6 |
733 | 2024-03-04 01:26:41 | bosun | 1 | 28756 | 3 | 0.470 | 61183.0 |
732 | 2024-03-01 14:14:29 | bosun | 1 | 28756 | 3 | 0.470 | 61183.0 |
731 | 2024-02-29 04:39:37 | bosun | 2 | 53800 | 39 | 1.796 | 29955.5 |
730 | 2024-02-29 04:38:36 | bosun | 3 | 83667 | 788 | 7.800 | 10726.5 |
729 | 2024-02-28 19:05:41 | bosun | 2 | 53800 | 39 | 1.500 | 35866.7 |
728 | 2024-02-28 18:15:43 | bosun | 3 | 83667 | 788 | 4.030 | 20761.0 |
727 | 2024-02-28 14:43:58 | bosun | 2 | 53800 | 39 | 1.580 | 34050.6 |
726 | 2024-02-28 14:43:35 | bosun | 3 | 83667 | 788 | 3.876 | 21585.9 |
725 | 2024-02-28 07:57:05 | bosun | 3 | 83667 | 788 | 5.673 | 14748.3 |
724 | 2024-02-28 07:57:06 | bosun | 2 | 53800 | 39 | 3.546 | 15172.0 |
723 | 2024-02-28 07:57:03 | bosun | 1 | 28756 | 3 | 1.063 | 27051.7 |
722 | 2024-01-29 10:09:55 | bosun | 2 | 53800 | 39 | 1.720 | 31279.1 |
721 | 2024-01-29 10:08:47 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
720 | 2024-01-29 07:15:53 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
719 | 2024-01-04 20:39:49 | bosun | 3 | 83667 | 788 | 4.690 | 17839.4 |
718 | 2023-12-21 05:47:55 | bosun | 3 | 83667 | 788 | 4.093 | 20441.5 |
717 | 2023-12-21 05:47:57 | bosun | 2 | 53800 | 39 | 1.703 | 31591.3 |
716 | 2023-12-17 14:21:30 | bosun | 2 | 53800 | 39 | 1.640 | 32804.9 |
715 | 2023-12-17 07:48:43 | bosun | 3 | 83667 | 788 | 3.920 | 21343.6 |
714 | 2023-12-14 15:51:18 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
713 | 2023-11-29 08:05:56 | bosun | 2 | 53800 | 39 | 1.406 | 38264.6 |
712 | 2023-11-20 09:07:12 | bosun | 1 | 28756 | 3 | 0.470 | 61183.0 |
711 | 2023-11-12 04:08:29 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
710 | 2023-11-11 21:31:35 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
709 | 2023-11-04 01:51:00 | bosun | 1 | 28756 | 3 | 0.483 | 59536.2 |
708 | 2023-11-01 22:59:32 | bosun | 3 | 83667 | 788 | 4.076 | 20526.7 |
707 | 2023-11-01 00:29:05 | bosun | 3 | 83667 | 788 | 3.876 | 21585.9 |
706 | 2023-10-31 05:56:37 | bosun | 3 | 83667 | 788 | 3.250 | 25743.7 |
705 | 2023-10-27 13:37:29 | bosun | 2 | 53800 | 39 | 1.656 | 32487.9 |
704 | 2023-10-20 14:46:51 | bosun | 3 | 83667 | 788 | 4.110 | 20356.9 |
703 | 2023-10-19 20:19:25 | bosun | 1 | 28756 | 3 | 0.436 | 65954.1 |
702 | 2023-10-19 09:28:23 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
701 | 2023-10-17 18:48:16 | bosun | 3 | 83667 | 788 | 3.576 | 23396.8 |
700 | 2023-10-11 20:22:50 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
699 | 2023-09-30 05:54:18 | bosun | 1 | 28756 | 3 | 0.516 | 55728.7 |
698 | 2023-09-25 22:32:31 | bosun | 1 | 28756 | 3 | 0.436 | 65954.1 |
697 | 2023-09-21 15:27:07 | bosun | 1 | 28756 | 3 | 1.000 | 28756.0 |
696 | 2023-08-24 23:11:32 | bosun | 3 | 83667 | 788 | 3.703 | 22594.4 |
695 | 2023-08-03 17:31:00 | bosun | 1 | 28756 | 3 | 0.546 | 52666.7 |
694 | 2023-07-26 23:31:26 | bosun | 1 | 28756 | 3 | 0.483 | 59536.2 |
693 | 2023-04-24 14:20:54 | bosun | 1 | 28756 | 3 | 0.436 | 65954.1 |
692 | 2023-04-22 13:42:14 | bosun | 1 | 28756 | 3 | 0.440 | 65354.5 |
691 | 2023-03-02 23:38:23 | bosun | 1 | 28756 | 3 | 0.470 | 61183.0 |
690 | 2023-02-12 22:04:16 | bosun | 1 | 28756 | 3 | 0.436 | 65954.1 |
689 | 2023-01-10 04:00:37 | bosun | 1 | 28756 | 3 | 0.530 | 54256.6 |
688 | 2022-12-11 07:55:34 | bosun | 1 | 28756 | 3 | 0.966 | 29768.1 |
687 | 2022-09-26 08:17:07 | bosun | 1 | 28756 | 3 | 0.436 | 65954.1 |
686 | 2022-08-14 19:47:14 | bosun | 1 | 28756 | 3 | 0.436 | 65954.1 |
685 | 2022-06-09 08:49:13 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
684 | 2022-06-05 17:55:17 | bosun | 1 | 28756 | 3 | 0.483 | 59536.2 |
683 | 2022-03-30 10:33:58 | bosun | 1 | 28756 | 3 | 0.766 | 37540.5 |
682 | 2022-03-28 06:44:27 | bosun | 1 | 28756 | 3 | 0.486 | 59168.7 |
681 | 2022-02-18 23:51:45 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
680 | 2022-02-04 00:27:44 | bosun | 3 | 83667 | 788 | 3.970 | 21074.8 |
679 | 2022-01-31 00:22:07 | bosun | 3 | 83667 | 788 | 3.890 | 21508.2 |
678 | 2022-01-27 00:27:22 | bosun | 3 | 83667 | 788 | 3.516 | 23796.1 |
677 | 2021-12-31 05:01:15 | bosun | 3 | 83667 | 788 | 4.483 | 18663.2 |
676 | 2021-12-30 06:42:15 | bosun | 3 | 83667 | 788 | 4.170 | 20064.0 |
675 | 2021-12-29 21:29:30 | bosun | 1 | 28756 | 3 | 0.530 | 54256.6 |
674 | 2021-12-29 05:33:28 | bosun | 3 | 83667 | 788 | 3.360 | 24900.9 |
673 | 2021-12-28 07:20:49 | bosun | 3 | 83667 | 788 | 3.453 | 24230.2 |
672 | 2021-12-27 19:27:38 | bosun | 1 | 28756 | 3 | 0.486 | 59168.7 |
671 | 2021-12-27 05:43:42 | bosun | 3 | 83667 | 788 | 4.203 | 19906.5 |
670 | 2021-12-26 06:27:46 | bosun | 3 | 83667 | 788 | 3.736 | 22394.8 |
669 | 2021-12-25 06:22:16 | bosun | 3 | 83667 | 788 | 4.106 | 20376.8 |
668 | 2021-12-24 02:39:15 | bosun | 3 | 83667 | 788 | 4.390 | 19058.5 |
667 | 2021-11-17 15:39:11 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
666 | 2021-10-30 11:21:07 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
665 | 2021-09-16 17:16:51 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
664 | 2021-09-14 13:15:13 | bosun | 1 | 28756 | 3 | 0.530 | 54256.6 |
663 | 2021-09-03 22:34:20 | bosun | 3 | 83667 | 788 | 3.733 | 22412.8 |
662 | 2021-08-23 14:34:25 | bosun | 1 | 28756 | 3 | 0.533 | 53951.2 |
661 | 2021-08-18 02:29:50 | bosun | 1 | 28756 | 3 | 0.436 | 65954.1 |
660 | 2021-08-14 19:06:01 | bosun | 1 | 28756 | 3 | 0.516 | 55728.7 |
659 | 2021-06-23 23:52:52 | bosun | 1 | 28756 | 3 | 0.466 | 61708.2 |
658 | 2021-06-15 20:08:27 | bosun | 3 | 83667 | 788 | 3.563 | 23482.2 |
657 | 2021-05-16 14:14:09 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
656 | 2021-05-14 03:29:28 | bosun | 1 | 28756 | 3 | 0.530 | 54256.6 |
655 | 2021-04-18 22:05:57 | bosun | 3 | 83667 | 788 | 3.796 | 22040.8 |
654 | 2021-04-17 23:41:21 | bosun | 3 | 83667 | 788 | 3.423 | 24442.6 |
653 | 2021-02-10 18:06:56 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
652 | 2021-02-05 23:54:04 | bosun | 1 | 28756 | 3 | 0.453 | 63479.0 |
651 | 2020-11-03 22:58:50 | bosun | 1 | 28756 | 3 | 0.516 | 55728.7 |
650 | 2020-11-02 14:19:04 | bosun | 1 | 28756 | 3 | 0.500 | 57512.0 |
649 | 2020-11-02 02:01:15 | bosun | 3 | 83667 | 788 | 3.780 | 22134.1 |
648 | 2020-10-28 10:22:47 | bosun | 1 | 28756 | 3 | 1.000 | 28756.0 |
647 | 2020-10-27 00:23:24 | bosun | 1 | 28756 | 3 | 0.610 | 47141.0 |