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 |
| 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 |
| 805 | 2025-05-29 05:07:56 | suborder | 3 | 146162 | 94 | 30.766 | 4750.8 |
| 804 | 2025-05-28 07:44:52 | suborder | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 803 | 2025-05-26 15:04:29 | suborder | 1 | 82945 | 3 | 3.013 | 27529.0 |
| 802 | 2025-05-26 10:28:52 | suborder | 3 | 146162 | 94 | 39.766 | 3675.6 |
| 801 | 2025-05-26 03:44:45 | suborder | 3 | 146162 | 94 | 34.253 | 4267.1 |
| 800 | 2025-05-26 02:41:47 | suborder | 2 | 121059 | 8 | 22.936 | 5278.1 |
| 799 | 2025-05-24 10:48:43 | suborder | 3 | 146162 | 94 | 20.363 | 7177.8 |
| 798 | 2025-05-24 01:04:59 | suborder | 4 | 161609 | 992 | 57.800 | 2796.0 |
| 797 | 2025-05-23 23:28:56 | suborder | 4 | 161609 | 992 | 83.923 | 1925.7 |
| 796 | 2025-05-23 23:11:29 | suborder | 4 | 161609 | 992 | 53.973 | 2994.3 |
| 795 | 2025-05-23 20:38:14 | suborder | 4 | 161609 | 992 | 12.936 | 12493.0 |
| 794 | 2025-05-22 07:53:11 | suborder | 3 | 146162 | 94 | 27.016 | 5410.2 |
| 793 | 2025-05-22 07:50:34 | suborder | 4 | 161609 | 992 | 73.533 | 2197.8 |
| 792 | 2025-05-22 03:15:43 | suborder | 2 | 121059 | 8 | 18.156 | 6667.7 |
| 791 | 2025-05-21 20:38:20 | suborder | 2 | 121059 | 8 | 18.373 | 6589.0 |
| 790 | 2025-05-21 06:01:53 | suborder | 3 | 146162 | 94 | 18.080 | 8084.2 |
| 789 | 2025-05-21 01:58:06 | suborder | 1 | 82945 | 3 | 4.330 | 19155.9 |
| 788 | 2025-05-18 05:37:49 | suborder | 2 | 121059 | 8 | 19.626 | 6168.3 |
| 787 | 2025-05-14 09:35:01 | suborder | 2 | 121059 | 8 | 17.410 | 6953.4 |
| 786 | 2025-05-12 17:03:40 | suborder | 1 | 82945 | 3 | 4.673 | 17749.8 |
| 785 | 2025-05-12 00:15:37 | suborder | 1 | 82945 | 3 | 7.733 | 10726.1 |
| 784 | 2025-05-11 00:28:23 | suborder | 3 | 146162 | 94 | 71.833 | 2034.7 |
| 783 | 2025-05-04 13:03:40 | suborder | 1 | 82945 | 3 | 6.623 | 12523.8 |
| 782 | 2025-05-03 02:11:21 | suborder | 1 | 82945 | 3 | 7.206 | 11510.5 |
| 781 | 2025-04-29 05:23:02 | suborder | 2 | 121059 | 8 | 3.436 | 35232.5 |
| 780 | 2025-04-23 18:51:16 | suborder | 3 | 146162 | 94 | 43.376 | 3369.7 |
| 779 | 2025-04-22 08:32:09 | suborder | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 778 | 2025-04-22 02:40:15 | suborder | 3 | 146162 | 94 | 24.406 | 5988.8 |
| 777 | 2025-04-21 22:41:52 | suborder | 3 | 146162 | 94 | 7.406 | 19735.6 |
| 776 | 2025-04-21 05:07:05 | suborder | 3 | 146162 | 94 | 37.096 | 3940.1 |
| 775 | 2025-04-12 21:20:12 | suborder | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 774 | 2025-04-11 18:08:10 | suborder | 1 | 82945 | 3 | 3.456 | 24000.3 |
| 773 | 2025-04-11 00:42:31 | suborder | 1 | 82945 | 3 | 4.080 | 20329.7 |
| 772 | 2025-04-06 06:59:49 | suborder | 3 | 146162 | 94 | 45.393 | 3219.9 |
| 771 | 2025-03-29 01:01:35 | suborder | 1 | 82945 | 3 | 6.203 | 13371.8 |
| 770 | 2025-03-23 19:17:39 | suborder | 3 | 146162 | 94 | 48.253 | 3029.1 |
| 769 | 2025-03-22 17:15:24 | suborder | 1 | 82945 | 3 | 11.596 | 7152.9 |
| 768 | 2025-03-16 11:22:30 | suborder | 3 | 146162 | 94 | 39.846 | 3668.2 |
| 767 | 2025-03-13 06:47:57 | suborder | 2 | 121059 | 8 | 18.440 | 6565.0 |
| 766 | 2025-03-13 06:47:41 | suborder | 1 | 82945 | 3 | 7.173 | 11563.5 |
| 765 | 2025-03-11 17:42:44 | suborder | 1 | 82945 | 3 | 5.313 | 15611.7 |
| 764 | 2025-03-10 20:21:27 | suborder | 3 | 146162 | 94 | 51.006 | 2865.6 |
| 763 | 2025-03-05 21:03:57 | suborder | 2 | 121059 | 8 | 23.156 | 5228.0 |
| 762 | 2025-03-02 17:10:41 | suborder | 2 | 121059 | 8 | 9.186 | 13178.6 |
| 761 | 2025-03-02 17:09:08 | suborder | 1 | 82945 | 3 | 3.966 | 20914.0 |
| 760 | 2025-02-24 12:13:28 | suborder | 3 | 146162 | 94 | 50.270 | 2907.5 |
| 759 | 2025-02-24 00:46:13 | suborder | 3 | 146162 | 94 | 44.593 | 3277.7 |
| 758 | 2025-02-22 08:23:46 | suborder | 3 | 146162 | 94 | 65.143 | 2243.7 |