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 |
| 918 | 2025-10-25 13:39:04 | subparts | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 917 | 2025-10-24 09:51:30 | subparts | 4 | 161609 | 951 | 13.283 | 12166.6 |
| 916 | 2025-10-16 10:14:56 | subparts | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 915 | 2025-10-16 05:03:50 | subparts | 1 | 82945 | 2 | 1.326 | 62552.8 |
| 914 | 2025-10-08 12:33:01 | subparts | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 913 | 2025-10-05 16:38:58 | subparts | 4 | 161609 | 951 | 10.686 | 15123.4 |
| 912 | 2025-10-05 02:32:10 | subparts | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 911 | 2025-10-02 09:39:44 | subparts | 3 | 146162 | 92 | 6.356 | 22995.9 |
| 910 | 2025-09-29 10:59:49 | subparts | 1 | 82945 | 2 | 1.373 | 60411.5 |
| 909 | 2025-09-29 10:35:21 | subparts | 1 | 82945 | 2 | 1.560 | 53169.9 |
| 908 | 2025-09-25 03:06:03 | subparts | 1 | 82945 | 2 | 4.216 | 19673.9 |
| 907 | 2025-09-25 02:23:05 | subparts | 1 | 82945 | 2 | 4.736 | 17513.7 |
| 906 | 2025-09-24 13:48:23 | subparts | 1 | 82945 | 2 | 1.326 | 62552.8 |
| 905 | 2025-09-16 08:25:01 | subparts | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 904 | 2025-09-14 21:29:36 | subparts | 3 | 146162 | 92 | 7.016 | 20832.7 |
| 903 | 2025-09-14 12:34:40 | subparts | 1 | 82945 | 2 | 1.310 | 63316.8 |
| 902 | 2025-09-13 05:03:56 | subparts | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 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 |