History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"purchases"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
799 | 2024-05-13 22:04:13 | purchases | 4 | 165329 | 512 | 31.190 | 5300.7 |
798 | 2024-05-12 23:46:02 | purchases | 4 | 165329 | 512 | 16.186 | 10214.3 |
797 | 2024-05-12 01:29:08 | purchases | 2 | 121436 | 7 | 9.673 | 12554.1 |
796 | 2024-05-12 01:29:08 | purchases | 3 | 148641 | 56 | 8.906 | 16690.0 |
795 | 2024-05-12 01:26:51 | purchases | 1 | 81242 | 5 | 4.580 | 17738.4 |
794 | 2024-05-10 23:37:31 | purchases | 4 | 165329 | 512 | 42.376 | 3901.5 |
793 | 2024-05-10 20:56:44 | purchases | 4 | 165329 | 512 | 25.223 | 6554.7 |
792 | 2024-05-10 02:45:08 | purchases | 4 | 165329 | 512 | 35.346 | 4677.4 |
791 | 2024-05-08 22:50:34 | purchases | 4 | 165329 | 512 | 29.250 | 5652.3 |
790 | 2024-05-08 19:49:16 | purchases | 4 | 165329 | 512 | 28.876 | 5725.5 |
789 | 2024-05-03 22:39:04 | purchases | 1 | 81242 | 5 | 4.420 | 18380.5 |
788 | 2024-04-30 15:28:56 | purchases | 1 | 81242 | 5 | 1.546 | 52549.8 |
787 | 2024-04-28 16:21:46 | purchases | 3 | 148641 | 56 | 7.533 | 19732.0 |
786 | 2024-04-28 07:41:15 | purchases | 1 | 81242 | 5 | 1.250 | 64993.6 |
785 | 2024-04-27 19:35:36 | purchases | 2 | 121436 | 7 | 4.216 | 28803.6 |
784 | 2024-04-27 10:54:57 | purchases | 4 | 165329 | 512 | 18.453 | 8959.5 |
783 | 2024-04-19 12:52:10 | purchases | 3 | 148641 | 56 | 17.843 | 8330.5 |
782 | 2024-04-19 10:55:58 | purchases | 3 | 148641 | 56 | 16.920 | 8784.9 |
781 | 2024-04-19 10:55:57 | purchases | 2 | 121436 | 7 | 7.296 | 16644.2 |
780 | 2024-04-19 09:55:18 | purchases | 1 | 81242 | 5 | 1.450 | 56029.0 |
779 | 2024-04-10 05:15:39 | purchases | 1 | 81242 | 5 | 1.376 | 59042.2 |
778 | 2024-04-07 23:38:18 | purchases | 4 | 165329 | 512 | 17.703 | 9339.0 |
777 | 2024-04-07 14:18:17 | purchases | 4 | 165329 | 512 | 20.780 | 7956.2 |
776 | 2024-04-03 23:37:08 | purchases | 4 | 165329 | 512 | 32.456 | 5093.9 |
775 | 2024-04-03 17:23:51 | purchases | 4 | 165329 | 512 | 33.753 | 4898.2 |
774 | 2024-04-03 17:23:52 | purchases | 3 | 148641 | 56 | 24.313 | 6113.6 |
773 | 2024-04-03 17:23:53 | purchases | 2 | 121436 | 7 | 13.843 | 8772.4 |
772 | 2024-04-03 16:35:00 | purchases | 1 | 81242 | 5 | 1.466 | 55417.5 |
771 | 2024-03-28 20:29:17 | purchases | 1 | 81242 | 5 | 1.420 | 57212.7 |
770 | 2024-03-19 21:17:07 | purchases | 1 | 81242 | 5 | 1.233 | 65889.7 |
769 | 2024-03-04 17:07:57 | purchases | 4 | 165329 | 512 | 41.783 | 3956.8 |
768 | 2024-03-03 03:35:17 | purchases | 4 | 165329 | 512 | 34.923 | 4734.1 |
767 | 2024-03-02 21:01:58 | purchases | 4 | 165329 | 512 | 10.610 | 15582.4 |
766 | 2024-03-01 06:32:37 | purchases | 1 | 81242 | 5 | 1.580 | 51419.0 |
765 | 2024-02-27 07:48:39 | purchases | 1 | 81242 | 5 | 1.436 | 56575.2 |
764 | 2024-02-22 08:07:41 | purchases | 4 | 165329 | 512 | 29.733 | 5560.5 |
763 | 2024-02-17 16:24:41 | purchases | 4 | 165329 | 512 | 14.796 | 11173.9 |
762 | 2024-02-16 09:25:13 | purchases | 4 | 165329 | 512 | 12.390 | 13343.7 |
761 | 2024-02-08 23:39:35 | purchases | 1 | 81242 | 5 | 2.580 | 31489.1 |
760 | 2024-01-24 05:37:55 | purchases | 4 | 165329 | 512 | 10.300 | 16051.4 |
759 | 2024-01-10 07:51:29 | purchases | 1 | 81242 | 5 | 1.313 | 61875.1 |
758 | 2024-01-07 06:58:30 | purchases | 4 | 165329 | 512 | 12.373 | 13362.1 |
757 | 2024-01-06 19:17:01 | purchases | 4 | 165329 | 512 | 10.393 | 15907.7 |
756 | 2024-01-01 22:12:59 | purchases | 4 | 165329 | 512 | 10.470 | 15790.7 |
755 | 2023-12-31 21:35:31 | purchases | 4 | 165329 | 512 | 11.156 | 14819.7 |
754 | 2023-12-21 17:41:35 | purchases | 4 | 165329 | 512 | 21.016 | 7866.8 |
753 | 2023-12-20 12:50:56 | purchases | 3 | 148641 | 56 | 6.076 | 24463.6 |
752 | 2023-12-18 21:11:54 | purchases | 2 | 121436 | 7 | 3.296 | 36843.4 |
751 | 2023-12-17 14:39:37 | purchases | 4 | 165329 | 512 | 10.923 | 15135.9 |
750 | 2023-12-05 02:23:41 | purchases | 1 | 81242 | 5 | 1.330 | 61084.2 |
749 | 2023-12-04 02:01:21 | purchases | 4 | 165329 | 512 | 11.030 | 14989.0 |
748 | 2023-12-02 21:35:15 | purchases | 4 | 165329 | 512 | 11.236 | 14714.2 |
747 | 2023-12-01 20:48:27 | purchases | 4 | 165329 | 512 | 10.610 | 15582.4 |
746 | 2023-11-29 19:46:49 | purchases | 1 | 81242 | 5 | 1.216 | 66810.9 |
745 | 2023-11-26 03:15:12 | purchases | 4 | 165329 | 512 | 12.703 | 13015.0 |
744 | 2023-11-14 17:17:08 | purchases | 4 | 165329 | 512 | 10.656 | 15515.1 |
743 | 2023-11-11 21:45:58 | purchases | 4 | 165329 | 512 | 14.313 | 11551.0 |
742 | 2023-11-03 17:49:10 | purchases | 1 | 81242 | 5 | 1.283 | 63321.9 |
741 | 2023-10-24 16:22:55 | purchases | 1 | 81242 | 5 | 1.343 | 60492.9 |
740 | 2023-09-19 16:38:36 | purchases | 2 | 121436 | 7 | 3.356 | 36184.7 |
739 | 2023-09-19 12:47:51 | purchases | 3 | 148641 | 56 | 5.986 | 24831.4 |
738 | 2023-09-15 03:05:38 | purchases | 1 | 81242 | 5 | 1.530 | 53099.3 |
737 | 2023-09-11 01:21:27 | purchases | 4 | 165329 | 512 | 14.500 | 11402.0 |
736 | 2023-09-09 09:50:39 | purchases | 4 | 165329 | 512 | 12.546 | 13177.8 |
735 | 2023-09-07 09:04:36 | purchases | 4 | 165329 | 512 | 11.970 | 13811.9 |
734 | 2023-09-03 06:37:28 | purchases | 4 | 165329 | 512 | 10.826 | 15271.5 |
733 | 2023-09-02 03:03:15 | purchases | 4 | 165329 | 512 | 13.096 | 12624.4 |
732 | 2023-08-27 18:45:56 | purchases | 4 | 165329 | 512 | 11.110 | 14881.1 |
731 | 2023-08-27 12:30:37 | purchases | 1 | 81242 | 5 | 1.423 | 57092.1 |
730 | 2023-08-25 19:08:39 | purchases | 4 | 165329 | 512 | 10.500 | 15745.6 |
729 | 2023-08-17 11:39:52 | purchases | 4 | 165329 | 512 | 10.610 | 15582.4 |
728 | 2023-08-09 07:49:24 | purchases | 4 | 165329 | 512 | 10.843 | 15247.5 |
727 | 2023-08-08 12:04:24 | purchases | 4 | 165329 | 512 | 11.516 | 14356.5 |
726 | 2023-08-07 15:29:38 | purchases | 4 | 165329 | 512 | 10.390 | 15912.3 |
725 | 2023-07-15 17:21:00 | purchases | 4 | 165329 | 512 | 11.326 | 14597.3 |
724 | 2023-06-28 03:16:10 | purchases | 2 | 121436 | 7 | 3.076 | 39478.5 |
723 | 2023-06-23 12:50:00 | purchases | 4 | 165329 | 512 | 20.096 | 8227.0 |
722 | 2023-06-23 06:53:13 | purchases | 4 | 165329 | 512 | 16.720 | 9888.1 |
721 | 2023-06-19 18:01:52 | purchases | 1 | 81242 | 5 | 1.310 | 62016.8 |
720 | 2023-06-16 05:36:00 | purchases | 3 | 148641 | 56 | 6.140 | 24208.6 |
719 | 2023-05-29 10:41:21 | purchases | 1 | 81242 | 5 | 1.216 | 66810.9 |
718 | 2023-05-18 14:34:48 | purchases | 4 | 165329 | 512 | 10.330 | 16004.7 |
717 | 2023-05-03 16:43:16 | purchases | 4 | 165329 | 512 | 10.686 | 15471.6 |
716 | 2023-05-01 19:14:18 | purchases | 4 | 165329 | 512 | 12.750 | 12967.0 |
715 | 2023-04-30 12:40:25 | purchases | 4 | 165329 | 512 | 13.096 | 12624.4 |
714 | 2023-04-29 20:00:20 | purchases | 4 | 165329 | 512 | 12.030 | 13743.1 |
713 | 2023-04-28 10:26:27 | purchases | 4 | 165329 | 512 | 12.203 | 13548.2 |
712 | 2023-04-27 08:59:30 | purchases | 4 | 165329 | 512 | 12.500 | 13226.3 |
711 | 2023-04-25 14:24:43 | purchases | 4 | 165329 | 512 | 25.156 | 6572.1 |
710 | 2023-04-24 21:04:15 | purchases | 4 | 165329 | 512 | 12.436 | 13294.4 |
709 | 2023-03-28 21:55:31 | purchases | 4 | 165329 | 512 | 10.953 | 15094.4 |
708 | 2023-03-23 23:58:58 | purchases | 2 | 121436 | 7 | 3.390 | 35821.8 |
707 | 2023-03-23 08:57:24 | purchases | 1 | 81242 | 5 | 1.296 | 62686.7 |
706 | 2023-03-14 07:35:08 | purchases | 3 | 148641 | 56 | 6.830 | 21763.0 |
705 | 2023-02-21 22:38:18 | purchases | 1 | 81242 | 5 | 1.423 | 57092.1 |
704 | 2023-02-15 18:28:42 | purchases | 4 | 165329 | 512 | 10.283 | 16077.9 |
703 | 2023-02-12 06:57:09 | purchases | 4 | 165329 | 512 | 11.266 | 14675.0 |
702 | 2023-02-10 09:02:26 | purchases | 4 | 165329 | 512 | 10.280 | 16082.6 |
701 | 2023-02-02 15:57:45 | purchases | 4 | 165329 | 512 | 10.236 | 16151.7 |
700 | 2023-01-19 03:42:30 | purchases | 4 | 165329 | 512 | 10.530 | 15700.8 |