History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crew"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
741 | 2024-04-30 03:55:37 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
740 | 2024-04-29 07:03:58 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
739 | 2024-04-29 03:02:42 | crew | 1 | 13983 | 11 | 0.266 | 52567.7 |
738 | 2024-04-14 08:53:46 | crew | 1 | 13983 | 11 | 0.563 | 24836.6 |
737 | 2024-04-05 12:22:33 | crew | 1 | 13983 | 11 | 0.470 | 29751.1 |
736 | 2024-04-05 00:31:36 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
735 | 2024-04-03 20:10:53 | crew | 2 | 29872 | 187 | 1.950 | 15319.0 |
734 | 2024-04-03 20:10:50 | crew | 1 | 13983 | 11 | 0.266 | 52567.7 |
733 | 2024-04-03 20:10:42 | crew | 2 | 29872 | 187 | 2.016 | 14817.5 |
732 | 2024-04-03 03:36:04 | crew | 2 | 29872 | 187 | 2.920 | 10230.1 |
731 | 2024-04-03 03:17:26 | crew | 1 | 13983 | 11 | 0.500 | 27966.0 |
730 | 2024-03-31 01:03:33 | crew | 1 | 13983 | 11 | 0.813 | 17199.3 |
729 | 2024-03-27 02:09:25 | crew | 1 | 13983 | 11 | 0.830 | 16847.0 |
728 | 2024-03-05 20:48:23 | crew | 2 | 29872 | 187 | 1.110 | 26911.7 |
727 | 2024-03-05 20:01:20 | crew | 1 | 13983 | 11 | 0.546 | 25609.9 |
726 | 2024-03-03 20:01:23 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
725 | 2024-02-29 21:35:21 | crew | 1 | 13983 | 11 | 0.266 | 52567.7 |
724 | 2024-02-25 22:48:57 | crew | 2 | 29872 | 187 | 1.016 | 29401.6 |
723 | 2024-02-25 22:45:06 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
722 | 2024-02-21 02:26:16 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
721 | 2024-02-08 03:40:39 | crew | 2 | 29872 | 187 | 0.873 | 34217.6 |
720 | 2024-02-08 02:33:06 | crew | 2 | 29872 | 187 | 0.720 | 41488.9 |
719 | 2024-02-02 22:55:25 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
718 | 2024-02-02 14:58:23 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
717 | 2024-01-28 15:27:35 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
716 | 2024-01-26 19:15:29 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
715 | 2024-01-11 01:19:09 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
714 | 2024-01-03 11:03:42 | crew | 1 | 13983 | 11 | 0.203 | 68881.8 |
713 | 2023-12-09 19:55:17 | crew | 2 | 29872 | 187 | 0.920 | 32469.6 |
712 | 2023-12-06 22:22:26 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
711 | 2023-12-04 04:45:41 | crew | 2 | 29872 | 187 | 0.780 | 38297.4 |
710 | 2023-11-25 03:04:44 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
709 | 2023-11-20 10:59:00 | crew | 2 | 29872 | 187 | 0.843 | 35435.3 |
708 | 2023-11-14 08:36:41 | crew | 2 | 29872 | 187 | 0.750 | 39829.3 |
707 | 2023-11-11 04:16:48 | crew | 1 | 13983 | 11 | 0.203 | 68881.8 |
706 | 2023-11-10 22:45:14 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
705 | 2023-10-27 02:57:22 | crew | 1 | 13983 | 11 | 0.203 | 68881.8 |
704 | 2023-10-20 16:59:10 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
703 | 2023-10-17 22:29:02 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
702 | 2023-10-11 04:38:41 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
701 | 2023-10-04 09:39:19 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
700 | 2023-09-22 12:30:24 | crew | 1 | 13983 | 11 | 0.203 | 68881.8 |
699 | 2023-09-21 23:45:34 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
698 | 2023-09-14 06:15:46 | crew | 2 | 29872 | 187 | 0.763 | 39150.7 |
697 | 2023-09-10 14:12:26 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
696 | 2023-09-04 10:08:47 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
695 | 2023-08-15 16:23:31 | crew | 2 | 29872 | 187 | 0.733 | 40753.1 |
694 | 2023-07-26 17:43:58 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
693 | 2023-07-18 22:12:43 | crew | 1 | 13983 | 11 | 0.220 | 63559.1 |
692 | 2023-05-15 06:19:03 | crew | 1 | 13983 | 11 | 0.483 | 28950.3 |
691 | 2023-05-01 18:01:43 | crew | 2 | 29872 | 187 | 0.736 | 40587.0 |
690 | 2023-04-21 22:44:37 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
689 | 2023-03-31 14:51:26 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
688 | 2023-02-12 17:21:03 | crew | 1 | 13983 | 11 | 0.203 | 68881.8 |
687 | 2023-02-05 11:14:44 | crew | 2 | 29872 | 187 | 0.733 | 40753.1 |
686 | 2023-02-05 07:04:55 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
685 | 2022-12-10 01:54:43 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
684 | 2022-11-16 22:04:46 | crew | 2 | 29872 | 187 | 0.750 | 39829.3 |
683 | 2022-10-22 12:19:13 | crew | 1 | 13983 | 11 | 0.220 | 63559.1 |
682 | 2022-08-16 22:25:28 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
681 | 2022-07-02 14:50:51 | crew | 1 | 13983 | 11 | 0.203 | 68881.8 |
680 | 2022-06-28 17:15:27 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
679 | 2022-06-19 12:48:48 | crew | 2 | 29872 | 187 | 0.736 | 40587.0 |
678 | 2022-03-12 03:03:07 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
677 | 2022-03-02 05:25:45 | crew | 1 | 13983 | 11 | 0.220 | 63559.1 |
676 | 2022-02-05 10:10:31 | crew | 2 | 29872 | 187 | 0.780 | 38297.4 |
675 | 2021-12-16 23:58:19 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
674 | 2021-12-07 18:38:54 | crew | 1 | 13983 | 11 | 0.220 | 63559.1 |
673 | 2021-12-07 07:17:46 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
672 | 2021-12-06 21:50:08 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
671 | 2021-12-06 12:11:46 | crew | 1 | 13983 | 11 | 0.546 | 25609.9 |
670 | 2021-12-05 21:24:13 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
669 | 2021-12-05 11:07:03 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
668 | 2021-12-02 00:50:57 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
667 | 2021-12-01 21:29:59 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
666 | 2021-12-01 16:55:20 | crew | 1 | 13983 | 11 | 0.280 | 49939.3 |
665 | 2021-12-01 05:38:33 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
664 | 2021-11-30 21:33:46 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
663 | 2021-11-30 10:13:50 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
662 | 2021-11-29 18:08:55 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
661 | 2021-11-29 11:08:37 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
660 | 2021-11-04 10:30:10 | crew | 2 | 29872 | 187 | 1.030 | 29001.9 |
659 | 2021-10-28 04:37:11 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
658 | 2021-10-26 04:18:55 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
657 | 2021-10-21 19:04:49 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
656 | 2021-10-20 21:34:02 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
655 | 2021-09-20 13:00:37 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
654 | 2021-09-19 17:31:36 | crew | 1 | 13983 | 11 | 0.236 | 59250.0 |
653 | 2021-09-13 05:00:55 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
652 | 2021-09-09 23:41:54 | crew | 1 | 13983 | 11 | 0.736 | 18998.6 |
651 | 2021-09-07 20:27:08 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
650 | 2021-08-28 20:35:12 | crew | 2 | 29872 | 187 | 0.733 | 40753.1 |
649 | 2021-08-28 19:50:54 | crew | 1 | 13983 | 11 | 0.216 | 64736.1 |
648 | 2021-08-23 08:10:28 | crew | 1 | 13983 | 11 | 0.220 | 63559.1 |
647 | 2021-08-21 03:42:54 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
646 | 2021-05-14 19:39:05 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |
645 | 2021-02-11 21:16:55 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
644 | 2021-02-06 22:13:58 | crew | 1 | 13983 | 11 | 0.220 | 63559.1 |
643 | 2020-11-04 22:26:40 | crew | 1 | 13983 | 11 | 0.250 | 55932.0 |
642 | 2020-10-13 02:41:28 | crew | 1 | 13983 | 11 | 0.233 | 60012.9 |