History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
808 | 2025-07-31 11:50:14 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
807 | 2025-07-27 01:53:40 | canal | 2 | 53800 | 130 | 4.593 | 11713.5 |
806 | 2025-07-25 19:34:21 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
805 | 2025-07-22 16:32:21 | canal | 1 | 28756 | 7 | 2.456 | 11708.5 |
804 | 2025-07-17 16:54:22 | canal | 1 | 28756 | 7 | 1.250 | 23004.8 |
803 | 2025-07-08 08:07:00 | canal | 1 | 28756 | 7 | 1.513 | 19005.9 |
802 | 2025-07-08 02:28:25 | canal | 1 | 28756 | 7 | 2.360 | 12184.7 |
801 | 2025-07-07 13:54:39 | canal | 2 | 53800 | 130 | 6.453 | 8337.2 |
800 | 2025-07-06 03:54:34 | canal | 2 | 53800 | 130 | 8.673 | 6203.2 |
799 | 2025-07-05 19:22:11 | canal | 2 | 53800 | 130 | 1.610 | 33416.1 |
798 | 2025-07-04 12:47:04 | canal | 2 | 53800 | 130 | 9.546 | 5635.9 |
797 | 2025-07-03 23:30:59 | canal | 1 | 28756 | 7 | 0.576 | 49923.6 |
796 | 2025-07-02 18:14:13 | canal | 2 | 53800 | 130 | 4.233 | 12709.7 |
795 | 2025-07-02 02:16:06 | canal | 1 | 28756 | 7 | 1.953 | 14724.0 |
794 | 2025-07-01 08:18:00 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
793 | 2025-06-22 12:04:19 | canal | 1 | 28756 | 7 | 2.596 | 11077.0 |
792 | 2025-06-20 09:00:26 | canal | 1 | 28756 | 7 | 3.190 | 9014.4 |
791 | 2025-06-18 05:37:49 | canal | 1 | 28756 | 7 | 1.936 | 14853.3 |
790 | 2025-06-16 13:20:02 | canal | 1 | 28756 | 7 | 1.000 | 28756.0 |
789 | 2025-06-13 05:02:29 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
788 | 2025-06-08 07:17:43 | canal | 1 | 28756 | 7 | 1.326 | 21686.3 |
787 | 2025-06-05 05:00:34 | canal | 1 | 28756 | 7 | 2.110 | 13628.4 |
786 | 2025-06-02 01:30:35 | canal | 1 | 28756 | 7 | 2.640 | 10892.4 |
785 | 2025-06-01 23:46:11 | canal | 1 | 28756 | 7 | 2.470 | 11642.1 |
784 | 2025-06-01 03:17:15 | canal | 2 | 53800 | 130 | 8.200 | 6561.0 |
783 | 2025-05-31 08:20:28 | canal | 1 | 28756 | 7 | 2.390 | 12031.8 |
782 | 2025-05-30 07:00:02 | canal | 2 | 53800 | 130 | 10.766 | 4997.2 |
781 | 2025-05-26 23:37:36 | canal | 1 | 28756 | 7 | 1.670 | 17219.2 |
780 | 2025-05-26 05:38:06 | canal | 1 | 28756 | 7 | 2.360 | 12184.7 |
779 | 2025-05-20 19:24:38 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
778 | 2025-05-16 13:13:28 | canal | 1 | 28756 | 7 | 1.390 | 20687.8 |
777 | 2025-05-15 10:28:51 | canal | 2 | 53800 | 130 | 2.686 | 20029.8 |
776 | 2025-05-14 07:04:54 | canal | 1 | 28756 | 7 | 3.563 | 8070.7 |
775 | 2025-05-13 18:43:19 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
774 | 2025-05-13 05:04:59 | canal | 1 | 28756 | 7 | 0.486 | 59168.7 |
773 | 2025-05-10 01:19:55 | canal | 1 | 28756 | 7 | 2.360 | 12184.7 |
772 | 2025-05-09 09:58:12 | canal | 1 | 28756 | 7 | 0.843 | 34111.5 |
771 | 2025-05-08 06:57:13 | canal | 1 | 28756 | 7 | 1.466 | 19615.3 |
770 | 2025-05-07 15:58:33 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
769 | 2025-05-03 15:33:01 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
768 | 2025-05-01 23:45:17 | canal | 1 | 28756 | 7 | 2.580 | 11145.7 |
767 | 2025-04-29 08:05:57 | canal | 1 | 28756 | 7 | 2.686 | 10705.9 |
766 | 2025-04-29 06:25:14 | canal | 2 | 53800 | 130 | 1.733 | 31044.4 |
765 | 2025-04-29 06:05:56 | canal | 2 | 53800 | 130 | 1.533 | 35094.6 |
764 | 2025-04-29 00:56:27 | canal | 1 | 28756 | 7 | 2.783 | 10332.7 |
763 | 2025-04-27 05:40:26 | canal | 1 | 28756 | 7 | 2.186 | 13154.6 |
762 | 2025-04-19 16:49:35 | canal | 1 | 28756 | 7 | 0.576 | 49923.6 |
761 | 2025-04-19 00:32:26 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
760 | 2025-04-16 00:17:39 | canal | 2 | 53800 | 130 | 10.843 | 4961.7 |
759 | 2025-04-15 13:07:47 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
758 | 2025-04-14 10:52:56 | canal | 2 | 53800 | 130 | 12.250 | 4391.8 |
757 | 2025-04-12 05:16:29 | canal | 1 | 28756 | 7 | 1.186 | 24246.2 |
756 | 2025-04-09 12:14:37 | canal | 2 | 53800 | 130 | 11.326 | 4750.1 |
755 | 2025-04-08 06:10:05 | canal | 1 | 28756 | 7 | 1.063 | 27051.7 |
754 | 2025-04-07 08:48:49 | canal | 1 | 28756 | 7 | 3.530 | 8146.2 |
753 | 2025-04-04 12:17:38 | canal | 2 | 53800 | 130 | 6.206 | 8669.0 |
752 | 2025-04-04 08:15:29 | canal | 2 | 53800 | 130 | 6.970 | 7718.8 |
751 | 2025-04-03 08:27:57 | canal | 2 | 53800 | 130 | 1.656 | 32487.9 |
750 | 2025-03-31 01:37:21 | canal | 1 | 28756 | 7 | 3.750 | 7668.3 |
749 | 2025-03-29 10:24:44 | canal | 1 | 28756 | 7 | 3.970 | 7243.3 |
748 | 2025-03-19 01:31:14 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
747 | 2025-03-18 06:46:25 | canal | 1 | 28756 | 7 | 1.390 | 20687.8 |
746 | 2025-03-15 16:27:51 | canal | 1 | 28756 | 7 | 3.970 | 7243.3 |
745 | 2025-03-13 02:46:33 | canal | 1 | 28756 | 7 | 0.936 | 30722.2 |
744 | 2025-03-08 09:23:42 | canal | 1 | 28756 | 7 | 3.660 | 7856.8 |
743 | 2025-02-28 18:32:09 | canal | 1 | 28756 | 7 | 2.250 | 12780.4 |
742 | 2025-02-28 02:12:27 | canal | 2 | 53800 | 130 | 8.440 | 6374.4 |
741 | 2025-02-28 00:45:25 | canal | 2 | 53800 | 130 | 7.080 | 7598.9 |
740 | 2025-02-28 00:31:05 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
739 | 2025-02-27 06:24:00 | canal | 1 | 28756 | 7 | 1.406 | 20452.3 |
738 | 2025-02-26 18:48:47 | canal | 1 | 28756 | 7 | 1.640 | 17534.1 |
737 | 2025-02-24 17:56:15 | canal | 1 | 28756 | 7 | 2.783 | 10332.7 |
736 | 2025-02-19 22:45:44 | canal | 1 | 28756 | 7 | 1.376 | 20898.3 |
735 | 2025-02-06 09:18:55 | canal | 1 | 28756 | 7 | 2.390 | 12031.8 |
734 | 2025-01-28 14:34:06 | canal | 2 | 53800 | 130 | 8.596 | 6258.7 |
733 | 2025-01-28 06:38:39 | canal | 2 | 53800 | 130 | 10.076 | 5339.4 |
732 | 2025-01-28 05:45:38 | canal | 2 | 53800 | 130 | 7.453 | 7218.6 |
731 | 2025-01-28 05:44:13 | canal | 1 | 28756 | 7 | 3.330 | 8635.4 |
730 | 2025-01-27 12:12:02 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
729 | 2025-01-27 11:10:50 | canal | 1 | 28756 | 7 | 1.906 | 15087.1 |
728 | 2025-01-24 14:03:48 | canal | 1 | 28756 | 7 | 2.216 | 12976.5 |
727 | 2025-01-18 19:44:58 | canal | 1 | 28756 | 7 | 2.110 | 13628.4 |
726 | 2025-01-15 06:07:58 | canal | 1 | 28756 | 7 | 2.170 | 13251.6 |
725 | 2025-01-06 13:03:12 | canal | 1 | 28756 | 7 | 3.656 | 7865.4 |
724 | 2024-12-31 14:53:45 | canal | 2 | 53800 | 130 | 4.263 | 12620.2 |
723 | 2024-12-29 12:42:33 | canal | 2 | 53800 | 130 | 3.983 | 13507.4 |
722 | 2024-12-29 01:03:29 | canal | 2 | 53800 | 130 | 1.623 | 33148.5 |
721 | 2024-12-28 11:55:54 | canal | 2 | 53800 | 130 | 8.046 | 6686.6 |
720 | 2024-12-28 11:08:35 | canal | 2 | 53800 | 130 | 3.390 | 15870.2 |
719 | 2024-12-28 11:08:11 | canal | 1 | 28756 | 7 | 0.450 | 63902.2 |
718 | 2024-12-28 07:34:56 | canal | 1 | 28756 | 7 | 2.296 | 12524.4 |
717 | 2024-12-28 00:38:57 | canal | 1 | 28756 | 7 | 1.360 | 21144.1 |
716 | 2024-12-07 07:50:14 | canal | 1 | 28756 | 7 | 1.296 | 22188.3 |
715 | 2024-11-28 06:31:08 | canal | 2 | 53800 | 130 | 8.610 | 6248.5 |
714 | 2024-11-28 06:30:56 | canal | 1 | 28756 | 7 | 0.483 | 59536.2 |
713 | 2024-11-28 05:46:59 | canal | 2 | 53800 | 130 | 1.830 | 29398.9 |
712 | 2024-11-28 05:46:41 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
711 | 2024-11-07 02:34:10 | canal | 1 | 28756 | 7 | 1.390 | 20687.8 |
710 | 2024-10-29 16:33:27 | canal | 2 | 53800 | 130 | 8.140 | 6609.3 |
709 | 2024-10-29 05:23:11 | canal | 2 | 53800 | 130 | 7.610 | 7069.6 |