History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wear"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
791 | 2024-04-27 05:07:35 | wear | 1 | 13983 | 23 | 0.826 | 16928.6 |
790 | 2024-04-26 03:43:58 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
789 | 2024-04-26 01:41:48 | wear | 1 | 13983 | 23 | 0.843 | 16587.2 |
788 | 2024-04-05 00:20:15 | wear | 1 | 13983 | 23 | 0.266 | 52567.7 |
787 | 2024-03-30 19:53:31 | wear | 2 | 29872 | 268 | 3.000 | 9957.3 |
786 | 2024-03-30 18:39:29 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
785 | 2024-03-05 19:37:40 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
784 | 2024-03-02 18:33:23 | wear | 2 | 29872 | 268 | 2.016 | 14817.5 |
783 | 2024-03-02 16:58:52 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
782 | 2024-02-29 10:24:41 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
781 | 2024-02-24 09:40:01 | wear | 2 | 29872 | 268 | 0.846 | 35309.7 |
780 | 2024-02-06 03:46:55 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
779 | 2024-01-26 06:43:53 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
778 | 2024-01-04 10:44:44 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
777 | 2023-12-18 23:04:07 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
776 | 2023-12-06 03:14:57 | wear | 2 | 29872 | 268 | 1.470 | 20321.1 |
775 | 2023-11-30 15:59:00 | wear | 2 | 29872 | 268 | 0.906 | 32971.3 |
774 | 2023-11-27 14:48:47 | wear | 2 | 29872 | 268 | 1.500 | 19914.7 |
773 | 2023-11-17 18:54:58 | wear | 2 | 29872 | 268 | 0.826 | 36164.6 |
772 | 2023-11-17 04:11:11 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
771 | 2023-11-10 18:25:21 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
770 | 2023-11-10 08:01:26 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
769 | 2023-11-07 14:05:16 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
768 | 2023-10-27 13:09:38 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
767 | 2023-10-26 04:51:50 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
766 | 2023-10-24 08:22:01 | wear | 2 | 29872 | 268 | 0.720 | 41488.9 |
765 | 2023-10-19 18:18:16 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
764 | 2023-10-17 18:32:25 | wear | 1 | 13983 | 23 | 0.266 | 52567.7 |
763 | 2023-10-11 02:13:44 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
762 | 2023-10-11 01:21:11 | wear | 2 | 29872 | 268 | 0.873 | 34217.6 |
761 | 2023-10-08 02:47:09 | wear | 2 | 29872 | 268 | 0.766 | 38997.4 |
760 | 2023-10-03 13:33:20 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
759 | 2023-09-27 07:26:08 | wear | 2 | 29872 | 268 | 0.810 | 36879.0 |
758 | 2023-09-22 01:19:42 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
757 | 2023-09-19 17:45:16 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
756 | 2023-08-21 13:13:47 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
755 | 2023-08-19 04:42:22 | wear | 2 | 29872 | 268 | 0.733 | 40753.1 |
754 | 2023-07-12 00:29:18 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
753 | 2023-07-08 16:24:53 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
752 | 2023-05-24 09:41:01 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
751 | 2023-05-03 08:53:33 | wear | 2 | 29872 | 268 | 0.733 | 40753.1 |
750 | 2023-03-31 13:07:55 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
749 | 2023-03-19 06:30:08 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
748 | 2023-03-14 22:11:15 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
747 | 2023-02-12 04:52:47 | wear | 2 | 29872 | 268 | 0.736 | 40587.0 |
746 | 2023-01-06 16:12:53 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
745 | 2022-12-09 07:26:39 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
744 | 2022-12-08 12:06:31 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
743 | 2022-11-24 02:06:03 | wear | 2 | 29872 | 268 | 0.733 | 40753.1 |
742 | 2022-11-16 10:22:18 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
741 | 2022-10-23 14:29:12 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
740 | 2022-09-30 15:10:01 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
739 | 2022-09-19 17:45:28 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
738 | 2022-09-18 13:13:43 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
737 | 2022-09-12 07:51:04 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
736 | 2022-09-07 18:23:52 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
735 | 2022-09-02 01:27:51 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
734 | 2022-08-26 02:20:23 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
733 | 2022-08-23 18:51:40 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
732 | 2022-08-14 11:29:54 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
731 | 2022-08-06 23:22:00 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
730 | 2022-08-06 12:10:26 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
729 | 2022-07-30 00:59:35 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
728 | 2022-07-23 13:33:44 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
727 | 2022-07-19 21:05:09 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
726 | 2022-07-17 18:27:39 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
725 | 2022-07-03 09:25:01 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
724 | 2022-07-02 06:46:09 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
723 | 2022-06-25 21:05:18 | wear | 1 | 13983 | 23 | 0.203 | 68881.8 |
722 | 2022-05-13 21:33:43 | wear | 1 | 13983 | 23 | 0.356 | 39278.1 |
721 | 2022-04-23 08:08:39 | wear | 2 | 29872 | 268 | 0.733 | 40753.1 |
720 | 2022-03-25 09:25:35 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
719 | 2022-03-15 12:48:30 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
718 | 2022-02-17 07:38:41 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
717 | 2022-02-11 02:16:32 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
716 | 2022-01-30 17:12:38 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
715 | 2021-12-28 07:19:01 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
714 | 2021-12-24 10:40:19 | wear | 2 | 29872 | 268 | 0.936 | 31914.5 |
713 | 2021-12-01 20:45:19 | wear | 1 | 13983 | 23 | 0.593 | 23580.1 |
712 | 2021-11-23 19:48:17 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
711 | 2021-11-21 17:00:52 | wear | 1 | 13983 | 23 | 0.330 | 42372.7 |
710 | 2021-11-05 23:48:37 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
709 | 2021-10-09 12:52:50 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
708 | 2021-09-18 08:52:22 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
707 | 2021-08-22 05:20:42 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
706 | 2021-06-21 10:08:27 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
705 | 2021-06-18 13:56:36 | wear | 1 | 13983 | 23 | 0.250 | 55932.0 |
704 | 2021-05-18 01:30:58 | wear | 1 | 13983 | 23 | 0.516 | 27098.8 |
703 | 2021-05-02 18:54:53 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
702 | 2021-04-01 23:28:56 | wear | 1 | 13983 | 23 | 0.296 | 47239.9 |
701 | 2021-02-14 19:02:55 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
700 | 2021-01-17 00:27:18 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
699 | 2020-11-10 03:59:56 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
698 | 2020-11-09 15:18:29 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
697 | 2020-10-29 14:49:07 | wear | 1 | 13983 | 23 | 0.220 | 63559.1 |
696 | 2020-10-26 20:42:09 | wear | 2 | 29872 | 268 | 1.016 | 29401.6 |
695 | 2020-10-25 13:58:39 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |
694 | 2020-10-22 00:15:04 | wear | 1 | 13983 | 23 | 0.233 | 60012.9 |
693 | 2020-10-21 20:54:01 | wear | 1 | 13983 | 23 | 0.216 | 64736.1 |
692 | 2020-10-18 12:29:18 | wear | 1 | 13983 | 23 | 0.236 | 59250.0 |