History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subparts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
901 | 2025-09-07 12:56:13 | subparts | 1 | 82945 | 2 | 1.403 | 59119.7 |
900 | 2025-09-04 05:28:46 | subparts | 1 | 82945 | 2 | 1.513 | 54821.5 |
899 | 2025-08-29 11:55:15 | subparts | 1 | 82945 | 2 | 1.500 | 55296.7 |
898 | 2025-08-29 10:55:43 | subparts | 1 | 82945 | 2 | 1.440 | 57600.7 |
897 | 2025-08-25 13:33:54 | subparts | 1 | 82945 | 2 | 6.466 | 12827.9 |
896 | 2025-08-17 08:15:21 | subparts | 1 | 82945 | 2 | 2.593 | 31988.0 |
895 | 2025-08-17 02:52:42 | subparts | 1 | 82945 | 2 | 3.640 | 22787.1 |
894 | 2025-08-05 14:28:18 | subparts | 2 | 121059 | 6 | 18.686 | 6478.6 |
893 | 2025-08-05 10:50:07 | subparts | 1 | 82945 | 2 | 4.233 | 19594.8 |
892 | 2025-08-04 06:06:07 | subparts | 1 | 82945 | 2 | 3.390 | 24467.6 |
891 | 2025-08-01 12:42:59 | subparts | 1 | 82945 | 2 | 3.796 | 21850.6 |
890 | 2025-08-01 02:57:15 | subparts | 1 | 82945 | 2 | 3.843 | 21583.4 |
889 | 2025-07-31 06:48:51 | subparts | 1 | 82945 | 2 | 7.906 | 10491.4 |
888 | 2025-07-27 21:16:38 | subparts | 4 | 161609 | 951 | 40.033 | 4036.9 |
887 | 2025-07-25 22:39:09 | subparts | 4 | 161609 | 951 | 11.516 | 14033.4 |
886 | 2025-07-24 07:36:15 | subparts | 1 | 82945 | 2 | 4.893 | 16951.8 |
885 | 2025-07-22 22:03:08 | subparts | 4 | 161609 | 951 | 60.846 | 2656.0 |
884 | 2025-07-22 19:07:49 | subparts | 4 | 161609 | 951 | 50.923 | 3173.6 |
883 | 2025-07-22 16:12:10 | subparts | 1 | 82945 | 2 | 3.640 | 22787.1 |
882 | 2025-07-18 15:46:16 | subparts | 4 | 161609 | 951 | 33.470 | 4828.5 |
881 | 2025-07-18 08:52:32 | subparts | 4 | 161609 | 951 | 54.036 | 2990.8 |
880 | 2025-07-17 06:46:30 | subparts | 4 | 161609 | 951 | 39.563 | 4084.9 |
879 | 2025-07-15 19:38:54 | subparts | 1 | 82945 | 2 | 1.593 | 52068.4 |
878 | 2025-07-13 23:59:48 | subparts | 4 | 161609 | 951 | 69.487 | 2325.7 |
877 | 2025-07-12 12:44:14 | subparts | 1 | 82945 | 2 | 1.546 | 53651.4 |
876 | 2025-07-10 07:14:40 | subparts | 1 | 82945 | 2 | 3.373 | 24590.9 |
875 | 2025-07-09 12:00:46 | subparts | 1 | 82945 | 2 | 3.500 | 23698.6 |
874 | 2025-07-06 01:14:32 | subparts | 1 | 82945 | 2 | 1.560 | 53169.9 |
873 | 2025-07-02 21:19:12 | subparts | 2 | 121059 | 6 | 18.923 | 6397.5 |
872 | 2025-07-02 10:55:51 | subparts | 1 | 82945 | 2 | 6.236 | 13301.0 |
871 | 2025-07-02 01:50:15 | subparts | 1 | 82945 | 2 | 3.203 | 25896.0 |
870 | 2025-06-30 05:32:04 | subparts | 2 | 121059 | 6 | 17.936 | 6749.5 |
869 | 2025-06-29 12:02:59 | subparts | 1 | 82945 | 2 | 1.360 | 60989.0 |
868 | 2025-06-27 07:24:18 | subparts | 1 | 82945 | 2 | 1.500 | 55296.7 |
867 | 2025-06-20 09:40:33 | subparts | 1 | 82945 | 2 | 6.533 | 12696.3 |
866 | 2025-06-11 16:22:59 | subparts | 1 | 82945 | 2 | 6.673 | 12429.9 |
865 | 2025-06-11 00:08:13 | subparts | 4 | 161609 | 951 | 59.470 | 2717.5 |
864 | 2025-06-10 16:49:47 | subparts | 4 | 161609 | 951 | 62.520 | 2584.9 |
863 | 2025-06-10 05:55:45 | subparts | 4 | 161609 | 951 | 53.003 | 3049.1 |
862 | 2025-06-10 04:31:18 | subparts | 4 | 161609 | 951 | 59.676 | 2708.1 |
861 | 2025-06-09 23:33:15 | subparts | 4 | 161609 | 951 | 45.440 | 3556.5 |
860 | 2025-06-08 12:23:36 | subparts | 4 | 161609 | 951 | 52.126 | 3100.4 |
859 | 2025-06-08 11:21:35 | subparts | 1 | 82945 | 2 | 8.970 | 9246.9 |
858 | 2025-06-08 08:44:14 | subparts | 1 | 82945 | 2 | 6.013 | 13794.3 |
857 | 2025-06-08 01:17:10 | subparts | 3 | 146162 | 92 | 26.830 | 5447.7 |
856 | 2025-06-07 23:15:54 | subparts | 2 | 121059 | 6 | 23.516 | 5147.9 |
855 | 2025-06-07 13:43:53 | subparts | 1 | 82945 | 2 | 3.640 | 22787.1 |
854 | 2025-06-07 07:59:59 | subparts | 3 | 146162 | 92 | 14.516 | 10069.0 |
853 | 2025-06-05 10:03:29 | subparts | 3 | 146162 | 92 | 36.800 | 3971.8 |
852 | 2025-06-03 17:48:49 | subparts | 3 | 146162 | 92 | 7.046 | 20744.0 |
851 | 2025-06-02 10:40:57 | subparts | 1 | 82945 | 2 | 8.846 | 9376.6 |
850 | 2025-06-01 14:19:19 | subparts | 1 | 82945 | 2 | 7.100 | 11682.4 |
849 | 2025-05-31 05:22:21 | subparts | 1 | 82945 | 2 | 9.783 | 8478.5 |
848 | 2025-05-29 12:18:10 | subparts | 1 | 82945 | 2 | 9.453 | 8774.5 |
847 | 2025-05-07 17:25:54 | subparts | 3 | 146162 | 92 | 6.343 | 23043.0 |
846 | 2025-05-06 11:01:32 | subparts | 1 | 82945 | 2 | 7.140 | 11616.9 |
845 | 2025-05-05 07:39:07 | subparts | 3 | 146162 | 92 | 42.800 | 3415.0 |
844 | 2025-05-05 04:50:51 | subparts | 2 | 121059 | 6 | 16.503 | 7335.6 |
843 | 2025-05-04 09:09:36 | subparts | 3 | 146162 | 92 | 52.800 | 2768.2 |
842 | 2025-05-02 05:13:25 | subparts | 3 | 146162 | 92 | 43.126 | 3389.2 |
841 | 2025-05-01 22:23:49 | subparts | 2 | 121059 | 6 | 11.720 | 10329.3 |
840 | 2025-05-01 13:04:55 | subparts | 1 | 82945 | 2 | 6.080 | 13642.3 |
839 | 2025-04-28 12:30:25 | subparts | 1 | 82945 | 2 | 11.080 | 7486.0 |
838 | 2025-04-25 00:16:14 | subparts | 1 | 82945 | 2 | 7.016 | 11822.3 |
837 | 2025-04-19 11:18:00 | subparts | 1 | 82945 | 2 | 1.296 | 64000.8 |
836 | 2025-04-19 05:24:05 | subparts | 1 | 82945 | 2 | 1.546 | 53651.4 |
835 | 2025-04-18 08:23:05 | subparts | 1 | 82945 | 2 | 5.826 | 14237.0 |
834 | 2025-04-12 20:17:13 | subparts | 3 | 146162 | 92 | 7.456 | 19603.3 |
833 | 2025-04-12 01:08:14 | subparts | 3 | 146162 | 92 | 39.290 | 3720.1 |
832 | 2025-04-09 17:32:17 | subparts | 3 | 146162 | 92 | 50.316 | 2904.9 |
831 | 2025-04-06 11:54:38 | subparts | 3 | 146162 | 92 | 37.206 | 3928.5 |
830 | 2025-03-31 15:35:33 | subparts | 1 | 82945 | 2 | 4.436 | 18698.2 |
829 | 2025-03-29 13:39:35 | subparts | 1 | 82945 | 2 | 10.390 | 7983.2 |
828 | 2025-03-25 09:38:56 | subparts | 3 | 146162 | 92 | 34.956 | 4181.3 |
827 | 2025-03-24 07:15:28 | subparts | 3 | 146162 | 92 | 35.406 | 4128.2 |
826 | 2025-03-23 15:04:38 | subparts | 1 | 82945 | 2 | 3.670 | 22600.8 |
825 | 2025-03-23 12:10:41 | subparts | 1 | 82945 | 2 | 3.983 | 20824.8 |
824 | 2025-03-23 09:19:36 | subparts | 3 | 146162 | 92 | 35.830 | 4079.3 |
823 | 2025-03-20 23:16:53 | subparts | 4 | 161609 | 951 | 63.720 | 2536.2 |
822 | 2025-03-20 20:26:10 | subparts | 2 | 121059 | 6 | 5.970 | 20277.9 |
821 | 2025-03-20 19:37:02 | subparts | 3 | 146162 | 92 | 7.470 | 19566.5 |
820 | 2025-03-19 00:41:19 | subparts | 1 | 82945 | 2 | 1.403 | 59119.7 |
819 | 2025-03-12 07:58:19 | subparts | 1 | 82945 | 2 | 5.530 | 14999.1 |
818 | 2025-02-19 11:54:27 | subparts | 1 | 82945 | 2 | 7.080 | 11715.4 |
817 | 2025-02-07 22:15:52 | subparts | 1 | 82945 | 2 | 3.593 | 23085.2 |
816 | 2025-02-05 15:12:48 | subparts | 3 | 146162 | 92 | 24.626 | 5935.3 |
815 | 2025-02-04 23:18:02 | subparts | 1 | 82945 | 2 | 7.076 | 11722.0 |
814 | 2025-02-04 13:41:52 | subparts | 1 | 82945 | 2 | 7.093 | 11693.9 |
813 | 2025-02-03 19:23:49 | subparts | 3 | 146162 | 92 | 37.046 | 3945.4 |
812 | 2025-02-02 07:10:35 | subparts | 3 | 146162 | 92 | 34.876 | 4190.9 |
811 | 2025-01-21 18:34:39 | subparts | 3 | 146162 | 92 | 35.126 | 4161.1 |
810 | 2025-01-17 15:05:46 | subparts | 3 | 146162 | 92 | 53.500 | 2732.0 |
809 | 2025-01-17 15:05:45 | subparts | 3 | 146162 | 92 | 21.876 | 6681.4 |
808 | 2025-01-14 20:11:45 | subparts | 1 | 82945 | 2 | 3.483 | 23814.2 |
807 | 2025-01-05 13:04:10 | subparts | 1 | 82945 | 2 | 1.516 | 54713.1 |
806 | 2025-01-04 10:46:38 | subparts | 3 | 146162 | 92 | 36.453 | 4009.6 |
805 | 2025-01-04 05:25:44 | subparts | 2 | 121059 | 6 | 16.783 | 7213.2 |
804 | 2025-01-04 04:33:12 | subparts | 3 | 146162 | 92 | 36.533 | 4000.8 |
803 | 2025-01-03 23:49:50 | subparts | 1 | 82945 | 2 | 6.813 | 12174.5 |
802 | 2025-01-03 20:01:50 | subparts | 4 | 161609 | 951 | 62.160 | 2599.9 |