History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oranges"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
763 | 2024-04-30 19:16:35 | oranges | 1 | 69583 | 6 | 1.423 | 48898.8 |
762 | 2024-03-30 19:28:33 | oranges | 3 | 134027 | 651 | 19.970 | 6711.4 |
761 | 2024-03-30 08:31:08 | oranges | 3 | 134027 | 651 | 13.783 | 9724.1 |
760 | 2024-03-30 07:22:06 | oranges | 3 | 134027 | 651 | 14.440 | 9281.6 |
759 | 2024-03-30 07:20:27 | oranges | 3 | 134027 | 651 | 9.453 | 14178.3 |
758 | 2024-03-24 21:32:55 | oranges | 1 | 69583 | 6 | 1.063 | 65459.1 |
757 | 2024-01-13 04:24:37 | oranges | 1 | 69583 | 6 | 1.093 | 63662.4 |
756 | 2023-12-31 09:36:26 | oranges | 2 | 107671 | 46 | 3.376 | 31893.1 |
755 | 2023-12-30 01:05:20 | oranges | 2 | 107671 | 46 | 3.486 | 30886.7 |
754 | 2023-12-28 06:43:08 | oranges | 3 | 134027 | 651 | 7.610 | 17612.0 |
753 | 2023-12-24 21:04:01 | oranges | 3 | 134027 | 651 | 7.236 | 18522.2 |
752 | 2023-12-22 10:52:26 | oranges | 3 | 134027 | 651 | 8.486 | 15793.9 |
751 | 2023-12-22 10:52:25 | oranges | 2 | 107671 | 46 | 5.673 | 18979.6 |
750 | 2023-12-16 21:04:14 | oranges | 1 | 69583 | 6 | 1.186 | 58670.3 |
749 | 2023-12-08 05:13:57 | oranges | 1 | 69583 | 6 | 1.326 | 52475.9 |
748 | 2023-12-04 13:15:54 | oranges | 3 | 134027 | 651 | 6.640 | 20184.8 |
747 | 2023-12-02 21:43:02 | oranges | 1 | 69583 | 6 | 1.123 | 61961.7 |
746 | 2023-11-12 12:34:36 | oranges | 3 | 134027 | 651 | 7.403 | 18104.4 |
745 | 2023-11-12 12:34:38 | oranges | 2 | 107671 | 46 | 3.626 | 29694.2 |
744 | 2023-11-09 01:04:42 | oranges | 1 | 69583 | 6 | 1.080 | 64428.7 |
743 | 2023-11-02 14:14:50 | oranges | 1 | 69583 | 6 | 1.216 | 57222.9 |
742 | 2023-10-29 18:04:44 | oranges | 1 | 69583 | 6 | 2.486 | 27989.9 |
741 | 2023-10-21 23:05:56 | oranges | 1 | 69583 | 6 | 1.093 | 63662.4 |
740 | 2023-10-04 13:34:58 | oranges | 3 | 134027 | 651 | 7.406 | 18097.1 |
739 | 2023-10-04 13:34:59 | oranges | 2 | 107671 | 46 | 3.593 | 29966.9 |
738 | 2023-10-03 09:05:09 | oranges | 1 | 69583 | 6 | 1.190 | 58473.1 |
737 | 2023-09-29 18:18:24 | oranges | 1 | 69583 | 6 | 1.076 | 64668.2 |
736 | 2023-09-23 20:46:31 | oranges | 1 | 69583 | 6 | 1.060 | 65644.3 |
735 | 2023-08-31 21:14:58 | oranges | 3 | 134027 | 651 | 6.390 | 20974.5 |
734 | 2023-08-28 22:32:52 | oranges | 1 | 69583 | 6 | 1.186 | 58670.3 |
733 | 2023-08-27 13:25:12 | oranges | 1 | 69583 | 6 | 1.203 | 57841.2 |
732 | 2023-06-02 10:15:27 | oranges | 1 | 69583 | 6 | 1.063 | 65459.1 |
731 | 2023-05-16 14:17:34 | oranges | 3 | 134027 | 651 | 6.720 | 19944.5 |
730 | 2023-05-13 23:46:34 | oranges | 1 | 69583 | 6 | 1.063 | 65459.1 |
729 | 2023-03-24 16:07:52 | oranges | 1 | 69583 | 6 | 1.250 | 55666.4 |
728 | 2023-02-21 04:02:25 | oranges | 3 | 134027 | 651 | 5.860 | 22871.5 |
727 | 2023-01-28 02:27:15 | oranges | 1 | 69583 | 6 | 1.046 | 66522.9 |
726 | 2023-01-09 03:40:10 | oranges | 1 | 69583 | 6 | 1.046 | 66522.9 |
725 | 2022-12-02 15:06:54 | oranges | 3 | 134027 | 651 | 5.763 | 23256.5 |
724 | 2022-10-11 10:23:34 | oranges | 1 | 69583 | 6 | 1.076 | 64668.2 |
723 | 2022-10-10 03:39:18 | oranges | 1 | 69583 | 6 | 1.250 | 55666.4 |
722 | 2022-09-10 17:11:05 | oranges | 1 | 69583 | 6 | 1.203 | 57841.2 |
721 | 2022-07-18 07:00:00 | oranges | 1 | 69583 | 6 | 1.140 | 61037.7 |
720 | 2022-07-13 11:49:21 | oranges | 3 | 134027 | 651 | 5.906 | 22693.4 |
719 | 2022-07-08 21:48:06 | oranges | 3 | 134027 | 651 | 6.750 | 19855.9 |
718 | 2022-06-27 07:50:58 | oranges | 1 | 69583 | 6 | 1.063 | 65459.1 |
717 | 2022-05-30 19:35:25 | oranges | 1 | 69583 | 6 | 1.076 | 64668.2 |
716 | 2022-03-10 21:10:47 | oranges | 1 | 69583 | 6 | 1.170 | 59472.6 |
715 | 2022-02-18 11:30:34 | oranges | 1 | 69583 | 6 | 1.080 | 64428.7 |
714 | 2021-12-07 18:15:30 | oranges | 2 | 107671 | 46 | 3.063 | 35152.1 |
713 | 2021-12-07 17:53:28 | oranges | 1 | 69583 | 6 | 1.330 | 52318.0 |
712 | 2021-12-06 23:36:33 | oranges | 2 | 107671 | 46 | 2.906 | 37051.3 |
711 | 2021-12-05 22:21:37 | oranges | 2 | 107671 | 46 | 3.200 | 33647.2 |
710 | 2021-11-27 03:22:04 | oranges | 1 | 69583 | 6 | 2.393 | 29077.7 |
709 | 2021-10-19 04:04:40 | oranges | 1 | 69583 | 6 | 1.076 | 64668.2 |
708 | 2021-09-11 06:07:20 | oranges | 1 | 69583 | 6 | 1.063 | 65459.1 |
707 | 2021-09-09 02:29:12 | oranges | 1 | 69583 | 6 | 1.126 | 61796.6 |
706 | 2021-09-05 17:44:15 | oranges | 2 | 107671 | 46 | 3.250 | 33129.5 |
705 | 2021-09-03 16:43:25 | oranges | 2 | 107671 | 46 | 3.376 | 31893.1 |
704 | 2021-08-24 06:37:20 | oranges | 1 | 69583 | 6 | 1.063 | 65459.1 |
703 | 2021-08-22 10:19:24 | oranges | 1 | 69583 | 6 | 1.126 | 61796.6 |
702 | 2021-08-20 20:20:56 | oranges | 1 | 69583 | 6 | 1.126 | 61796.6 |
701 | 2021-07-03 13:27:20 | oranges | 2 | 107671 | 46 | 3.423 | 31455.2 |
700 | 2021-06-13 06:23:37 | oranges | 2 | 107671 | 46 | 2.953 | 36461.6 |
699 | 2021-05-20 05:51:04 | oranges | 1 | 69583 | 6 | 1.780 | 39091.6 |
698 | 2021-05-02 03:02:21 | oranges | 1 | 69583 | 6 | 1.296 | 53690.6 |
697 | 2021-04-16 14:40:56 | oranges | 2 | 107671 | 46 | 3.500 | 30763.1 |
696 | 2021-04-14 15:50:50 | oranges | 2 | 107671 | 46 | 3.860 | 27894.0 |
695 | 2021-03-31 09:17:45 | oranges | 1 | 69583 | 6 | 1.173 | 59320.5 |
694 | 2021-03-23 05:47:32 | oranges | 2 | 107671 | 46 | 2.966 | 36301.8 |
693 | 2021-02-25 13:07:10 | oranges | 2 | 107671 | 46 | 2.986 | 36058.6 |
692 | 2021-02-17 13:16:44 | oranges | 1 | 69583 | 6 | 1.093 | 63662.4 |
691 | 2021-02-02 16:23:22 | oranges | 1 | 69583 | 6 | 2.186 | 31831.2 |
690 | 2021-02-01 19:16:07 | oranges | 3 | 134027 | 651 | 6.110 | 21935.7 |
689 | 2021-02-01 15:53:43 | oranges | 2 | 107671 | 46 | 3.000 | 35890.3 |
688 | 2021-01-14 18:21:13 | oranges | 1 | 69583 | 6 | 1.170 | 59472.6 |
687 | 2020-12-02 16:38:54 | oranges | 1 | 69583 | 6 | 1.096 | 63488.1 |
686 | 2020-11-17 10:30:26 | oranges | 2 | 107671 | 46 | 2.910 | 37000.3 |
685 | 2020-11-13 07:17:31 | oranges | 1 | 69583 | 6 | 1.310 | 53116.8 |
684 | 2020-10-29 17:42:19 | oranges | 1 | 69583 | 6 | 1.123 | 61961.7 |
683 | 2020-10-20 10:43:26 | oranges | 1 | 69583 | 6 | 2.076 | 33517.8 |
682 | 2020-10-14 23:21:21 | oranges | 2 | 107671 | 46 | 3.030 | 35535.0 |
681 | 2020-10-01 22:28:14 | oranges | 1 | 69583 | 6 | 1.063 | 65459.1 |
680 | 2020-09-08 02:50:42 | oranges | 2 | 107671 | 46 | 3.000 | 35890.3 |
679 | 2020-08-09 09:50:58 | oranges | 1 | 69583 | 6 | 1.170 | 59472.6 |
678 | 2020-07-18 23:43:53 | oranges | 1 | 69583 | 6 | 1.093 | 63662.4 |
677 | 2020-05-08 04:44:37 | oranges | 1 | 69583 | 6 | 1.220 | 57035.2 |
676 | 2020-04-13 21:58:56 | oranges | 1 | 69583 | 6 | 1.106 | 62914.1 |
675 | 2020-03-28 20:57:13 | oranges | 1 | 69583 | 6 | 1.296 | 53690.6 |
674 | 2020-03-25 03:52:44 | oranges | 1 | 69583 | 6 | 1.216 | 57222.9 |
673 | 2020-03-23 22:12:31 | oranges | 1 | 69583 | 6 | 2.516 | 27656.2 |
672 | 2020-03-20 18:18:08 | oranges | 1 | 69583 | 6 | 1.310 | 53116.8 |
671 | 2020-02-23 16:31:17 | oranges | 1 | 69583 | 6 | 1.203 | 57841.2 |
670 | 2020-02-23 14:19:29 | oranges | 1 | 69583 | 6 | 1.390 | 50059.7 |
669 | 2020-02-22 19:09:30 | oranges | 1 | 69583 | 6 | 1.280 | 54361.7 |
668 | 2020-02-14 14:14:09 | oranges | 1 | 69583 | 6 | 1.406 | 49490.0 |
667 | 2020-02-06 23:29:25 | oranges | 1 | 69583 | 6 | 2.766 | 25156.5 |
666 | 2020-02-05 20:00:44 | oranges | 1 | 69583 | 6 | 1.310 | 53116.8 |
665 | 2020-02-05 15:02:27 | oranges | 1 | 69583 | 6 | 4.190 | 16606.9 |
664 | 2020-01-31 14:05:17 | oranges | 1 | 69583 | 6 | 3.016 | 23071.3 |