History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"suborder"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 905 | 2025-12-24 07:50:41 | suborder | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 904 | 2025-12-23 05:34:33 | suborder | 2 | 121059 | 8 | 3.843 | 31501.2 |
| 903 | 2025-12-22 19:56:45 | suborder | 2 | 121059 | 8 | 3.716 | 32577.8 |
| 902 | 2025-12-22 19:21:19 | suborder | 2 | 121059 | 8 | 3.423 | 35366.3 |
| 901 | 2025-12-22 07:27:14 | suborder | 3 | 146162 | 94 | 6.843 | 21359.3 |
| 900 | 2025-12-22 06:27:32 | suborder | 3 | 146162 | 94 | 7.593 | 19249.6 |
| 899 | 2025-12-22 02:29:15 | suborder | 3 | 146162 | 94 | 7.703 | 18974.7 |
| 898 | 2025-12-21 22:34:09 | suborder | 4 | 161609 | 992 | 15.470 | 10446.6 |
| 897 | 2025-12-21 19:25:54 | suborder | 4 | 161609 | 992 | 11.343 | 14247.5 |
| 896 | 2025-12-20 05:39:36 | suborder | 3 | 146162 | 94 | 8.766 | 16673.7 |
| 895 | 2025-12-19 02:52:50 | suborder | 4 | 161609 | 992 | 15.236 | 10607.0 |
| 894 | 2025-12-18 23:36:37 | suborder | 4 | 161609 | 992 | 40.220 | 4018.1 |
| 893 | 2025-12-18 18:32:55 | suborder | 4 | 161609 | 992 | 16.530 | 9776.7 |
| 892 | 2025-12-18 17:07:03 | suborder | 4 | 161609 | 992 | 12.610 | 12815.9 |
| 891 | 2025-12-18 08:18:41 | suborder | 4 | 161609 | 992 | 15.253 | 10595.2 |
| 890 | 2025-12-18 06:16:45 | suborder | 4 | 161609 | 992 | 14.890 | 10853.5 |
| 889 | 2025-12-18 02:42:51 | suborder | 4 | 161609 | 992 | 46.236 | 3495.3 |
| 888 | 2025-12-17 20:43:15 | suborder | 4 | 161609 | 992 | 19.033 | 8491.0 |
| 887 | 2025-12-16 18:19:38 | suborder | 4 | 161609 | 992 | 16.923 | 9549.7 |
| 886 | 2025-12-16 18:12:32 | suborder | 4 | 161609 | 992 | 12.796 | 12629.6 |
| 885 | 2025-12-09 02:13:22 | suborder | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 884 | 2025-12-08 22:24:05 | suborder | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 883 | 2025-12-07 17:39:04 | suborder | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 882 | 2025-12-07 11:24:33 | suborder | 1 | 82945 | 3 | 9.826 | 8441.4 |
| 881 | 2025-12-06 11:25:26 | suborder | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 880 | 2025-12-05 11:56:42 | suborder | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 879 | 2025-11-28 14:41:11 | suborder | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 878 | 2025-11-25 22:12:55 | suborder | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 877 | 2025-11-22 01:33:07 | suborder | 1 | 82945 | 3 | 2.673 | 31030.7 |
| 876 | 2025-11-18 13:24:08 | suborder | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 875 | 2025-11-17 15:35:50 | suborder | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 874 | 2025-11-16 14:35:10 | suborder | 1 | 82945 | 3 | 1.750 | 47397.1 |
| 873 | 2025-11-15 10:39:41 | suborder | 1 | 82945 | 3 | 3.000 | 27648.3 |
| 872 | 2025-11-13 05:44:21 | suborder | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 871 | 2025-11-12 08:37:46 | suborder | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 870 | 2025-11-06 17:48:08 | suborder | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 869 | 2025-11-06 02:30:47 | suborder | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 868 | 2025-11-05 08:22:45 | suborder | 4 | 161609 | 992 | 12.466 | 12964.0 |
| 867 | 2025-11-04 22:32:38 | suborder | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 866 | 2025-11-04 12:17:18 | suborder | 1 | 82945 | 3 | 2.530 | 32784.6 |
| 865 | 2025-11-03 20:27:17 | suborder | 2 | 121059 | 8 | 3.843 | 31501.2 |
| 864 | 2025-11-03 04:39:27 | suborder | 1 | 82945 | 3 | 1.953 | 42470.6 |
| 863 | 2025-11-02 07:00:13 | suborder | 1 | 82945 | 3 | 1.340 | 61899.3 |
| 862 | 2025-11-01 14:28:55 | suborder | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 861 | 2025-10-31 19:48:00 | suborder | 2 | 121059 | 8 | 3.860 | 31362.4 |
| 860 | 2025-10-28 16:00:38 | suborder | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 859 | 2025-10-28 09:08:59 | suborder | 3 | 146162 | 94 | 6.640 | 22012.3 |
| 858 | 2025-10-28 07:33:33 | suborder | 3 | 146162 | 94 | 6.436 | 22710.1 |
| 857 | 2025-10-25 23:26:37 | suborder | 1 | 82945 | 3 | 2.233 | 37145.1 |
| 856 | 2025-10-22 18:23:26 | suborder | 2 | 121059 | 8 | 14.580 | 8303.1 |
| 855 | 2025-10-20 23:02:11 | suborder | 1 | 82945 | 3 | 7.106 | 11672.5 |
| 854 | 2025-10-17 16:53:43 | suborder | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 853 | 2025-10-13 06:36:31 | suborder | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 852 | 2025-10-06 03:05:41 | suborder | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 851 | 2025-10-04 23:40:11 | suborder | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 850 | 2025-10-04 18:43:28 | suborder | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 849 | 2025-10-04 01:53:14 | suborder | 1 | 82945 | 3 | 1.356 | 61168.9 |
| 848 | 2025-09-28 15:22:46 | suborder | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 847 | 2025-09-26 23:23:19 | suborder | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 846 | 2025-09-26 22:44:51 | suborder | 3 | 146162 | 94 | 9.326 | 15672.5 |
| 845 | 2025-09-24 23:45:48 | suborder | 1 | 82945 | 3 | 6.893 | 12033.2 |
| 844 | 2025-09-16 16:40:33 | suborder | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 843 | 2025-09-13 22:46:26 | suborder | 2 | 121059 | 8 | 3.830 | 31608.1 |
| 842 | 2025-09-13 20:57:33 | suborder | 4 | 161609 | 992 | 10.860 | 14881.1 |
| 841 | 2025-09-13 09:22:28 | suborder | 3 | 146162 | 94 | 6.703 | 21805.5 |
| 840 | 2025-09-13 02:41:39 | suborder | 1 | 82945 | 3 | 1.703 | 48705.2 |
| 839 | 2025-09-12 06:37:08 | suborder | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 838 | 2025-09-10 12:51:54 | suborder | 3 | 146162 | 94 | 7.173 | 20376.7 |
| 837 | 2025-09-05 03:24:55 | suborder | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 836 | 2025-09-03 23:20:20 | suborder | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 835 | 2025-09-03 18:33:12 | suborder | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 834 | 2025-09-02 20:06:51 | suborder | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 833 | 2025-08-29 12:52:35 | suborder | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 832 | 2025-08-28 15:36:15 | suborder | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 831 | 2025-08-24 23:44:45 | suborder | 1 | 82945 | 3 | 7.110 | 11666.0 |
| 830 | 2025-08-16 20:36:42 | suborder | 3 | 146162 | 94 | 31.206 | 4683.8 |
| 829 | 2025-08-09 08:32:47 | suborder | 1 | 82945 | 3 | 4.000 | 20736.3 |
| 828 | 2025-08-04 01:19:46 | suborder | 1 | 82945 | 3 | 3.750 | 22118.7 |
| 827 | 2025-07-27 16:03:42 | suborder | 1 | 82945 | 3 | 6.720 | 12343.0 |
| 826 | 2025-07-17 20:54:42 | suborder | 1 | 82945 | 3 | 7.203 | 11515.3 |
| 825 | 2025-07-17 17:10:51 | suborder | 1 | 82945 | 3 | 3.686 | 22502.7 |
| 824 | 2025-07-16 05:05:08 | suborder | 2 | 121059 | 8 | 3.283 | 36874.5 |
| 823 | 2025-07-10 23:48:54 | suborder | 1 | 82945 | 3 | 3.813 | 21753.2 |
| 822 | 2025-07-03 07:44:37 | suborder | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 821 | 2025-07-01 17:47:50 | suborder | 2 | 121059 | 8 | 3.936 | 30756.9 |
| 820 | 2025-06-26 15:27:42 | suborder | 1 | 82945 | 3 | 7.106 | 11672.5 |
| 819 | 2025-06-26 11:55:07 | suborder | 3 | 146162 | 94 | 32.553 | 4490.0 |
| 818 | 2025-06-26 03:54:38 | suborder | 3 | 146162 | 94 | 37.720 | 3874.9 |
| 817 | 2025-06-24 08:23:34 | suborder | 3 | 146162 | 94 | 36.893 | 3961.8 |
| 816 | 2025-06-20 04:21:12 | suborder | 3 | 146162 | 94 | 49.003 | 2982.7 |
| 815 | 2025-06-19 17:27:26 | suborder | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 814 | 2025-06-18 12:38:05 | suborder | 3 | 146162 | 94 | 33.500 | 4363.0 |
| 813 | 2025-06-17 07:02:32 | suborder | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 812 | 2025-06-16 00:39:43 | suborder | 1 | 82945 | 3 | 3.766 | 22024.7 |
| 811 | 2025-06-15 20:31:20 | suborder | 3 | 146162 | 94 | 29.656 | 4928.6 |
| 810 | 2025-06-14 13:02:22 | suborder | 1 | 82945 | 3 | 10.266 | 8079.6 |
| 809 | 2025-06-06 12:04:25 | suborder | 1 | 82945 | 3 | 6.546 | 12671.1 |
| 808 | 2025-06-05 21:26:32 | suborder | 2 | 121059 | 8 | 10.560 | 11463.9 |
| 807 | 2025-06-05 14:09:00 | suborder | 3 | 146162 | 94 | 7.466 | 19577.0 |
| 806 | 2025-06-04 11:58:35 | suborder | 3 | 146162 | 94 | 24.983 | 5850.5 |