History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coatings"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 870 | 2025-01-14 10:33:34 | coatings | 3 | 146162 | 563 | 34.160 | 4278.7 |
| 869 | 2025-01-14 10:12:21 | coatings | 3 | 146162 | 563 | 12.470 | 11721.1 |
| 868 | 2025-01-13 16:57:36 | coatings | 3 | 146162 | 563 | 46.846 | 3120.1 |
| 867 | 2025-01-09 04:31:42 | coatings | 1 | 82945 | 5 | 6.830 | 12144.2 |
| 866 | 2025-01-09 01:47:32 | coatings | 2 | 121059 | 58 | 16.580 | 7301.5 |
| 865 | 2025-01-06 22:09:49 | coatings | 2 | 121059 | 58 | 3.843 | 31501.2 |
| 864 | 2025-01-06 22:09:47 | coatings | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 863 | 2025-01-05 08:12:32 | coatings | 3 | 146162 | 563 | 39.533 | 3697.2 |
| 862 | 2024-12-27 18:29:18 | coatings | 2 | 121059 | 58 | 3.406 | 35542.9 |
| 861 | 2024-12-27 10:02:04 | coatings | 1 | 82945 | 5 | 7.016 | 11822.3 |
| 860 | 2024-12-19 12:29:43 | coatings | 2 | 121059 | 58 | 3.830 | 31608.1 |
| 859 | 2024-12-18 06:26:04 | coatings | 3 | 146162 | 563 | 40.633 | 3597.1 |
| 858 | 2024-12-15 06:24:12 | coatings | 2 | 121059 | 58 | 17.673 | 6849.9 |
| 857 | 2024-12-15 06:23:12 | coatings | 1 | 82945 | 5 | 4.486 | 18489.7 |
| 856 | 2024-12-13 22:52:29 | coatings | 3 | 146162 | 563 | 37.486 | 3899.1 |
| 855 | 2024-12-13 15:18:03 | coatings | 3 | 146162 | 563 | 19.266 | 7586.5 |
| 854 | 2024-12-13 11:58:52 | coatings | 3 | 146162 | 563 | 38.613 | 3785.3 |
| 853 | 2024-12-12 14:14:53 | coatings | 3 | 146162 | 563 | 16.973 | 8611.4 |
| 852 | 2024-12-07 17:41:21 | coatings | 1 | 82945 | 5 | 6.406 | 12948.0 |
| 851 | 2024-11-27 05:42:50 | coatings | 1 | 82945 | 5 | 7.030 | 11798.7 |
| 850 | 2024-11-17 16:59:20 | coatings | 3 | 146162 | 563 | 35.813 | 4081.3 |
| 849 | 2024-11-17 09:52:06 | coatings | 1 | 82945 | 5 | 6.030 | 13755.4 |
| 848 | 2024-11-16 05:39:00 | coatings | 2 | 121059 | 58 | 19.926 | 6075.4 |
| 847 | 2024-11-13 22:42:29 | coatings | 3 | 146162 | 563 | 30.190 | 4841.4 |
| 846 | 2024-11-13 12:17:29 | coatings | 2 | 121059 | 58 | 15.170 | 7980.2 |
| 845 | 2024-11-13 11:36:12 | coatings | 3 | 146162 | 563 | 7.343 | 19904.9 |
| 844 | 2024-11-13 10:25:34 | coatings | 3 | 146162 | 563 | 37.376 | 3910.6 |
| 843 | 2024-11-13 10:25:34 | coatings | 2 | 121059 | 58 | 20.173 | 6001.0 |
| 842 | 2024-11-13 10:12:48 | coatings | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 841 | 2024-11-08 22:30:51 | coatings | 1 | 82945 | 5 | 8.970 | 9246.9 |
| 840 | 2024-11-06 20:09:19 | coatings | 1 | 82945 | 5 | 3.543 | 23411.0 |
| 839 | 2024-10-15 18:52:52 | coatings | 2 | 121059 | 58 | 21.360 | 5667.6 |
| 838 | 2024-10-14 00:40:25 | coatings | 2 | 121059 | 58 | 19.836 | 6103.0 |
| 837 | 2024-10-14 00:40:19 | coatings | 1 | 82945 | 5 | 3.436 | 24140.0 |
| 836 | 2024-10-09 15:45:15 | coatings | 1 | 82945 | 5 | 6.796 | 12205.0 |
| 835 | 2024-10-09 05:43:41 | coatings | 3 | 146162 | 563 | 53.236 | 2745.5 |
| 834 | 2024-10-08 20:30:55 | coatings | 3 | 146162 | 563 | 48.473 | 3015.3 |
| 833 | 2024-10-08 14:08:25 | coatings | 3 | 146162 | 563 | 42.923 | 3405.2 |
| 832 | 2024-10-08 00:33:26 | coatings | 3 | 146162 | 563 | 53.846 | 2714.4 |
| 831 | 2024-10-07 02:21:15 | coatings | 1 | 82945 | 5 | 5.626 | 14743.2 |
| 830 | 2024-09-23 16:14:56 | coatings | 1 | 82945 | 5 | 9.420 | 8805.2 |
| 829 | 2024-09-13 19:17:58 | coatings | 1 | 82945 | 5 | 5.966 | 13903.0 |
| 828 | 2024-09-08 18:35:46 | coatings | 1 | 82945 | 5 | 14.360 | 5776.1 |
| 827 | 2024-09-05 01:23:21 | coatings | 1 | 82945 | 5 | 15.093 | 5495.6 |
| 826 | 2024-09-04 12:31:18 | coatings | 3 | 146162 | 563 | 94.066 | 1553.8 |
| 825 | 2024-08-27 21:51:40 | coatings | 3 | 146162 | 563 | 53.470 | 2733.5 |
| 824 | 2024-08-25 03:34:08 | coatings | 3 | 146162 | 563 | 52.236 | 2798.1 |
| 823 | 2024-08-24 18:57:06 | coatings | 3 | 146162 | 563 | 34.503 | 4236.2 |
| 822 | 2024-08-22 00:21:50 | coatings | 3 | 146162 | 563 | 43.410 | 3367.0 |
| 821 | 2024-08-21 23:53:00 | coatings | 3 | 146162 | 563 | 29.410 | 4969.8 |
| 820 | 2024-08-21 00:17:46 | coatings | 3 | 146162 | 563 | 40.253 | 3631.1 |
| 819 | 2024-08-18 18:37:08 | coatings | 3 | 146162 | 563 | 51.833 | 2819.9 |
| 818 | 2024-08-15 10:42:34 | coatings | 1 | 82945 | 5 | 10.330 | 8029.5 |
| 817 | 2024-08-15 10:19:39 | coatings | 1 | 82945 | 5 | 11.313 | 7331.8 |
| 816 | 2024-08-05 02:14:40 | coatings | 1 | 82945 | 5 | 5.420 | 15303.5 |
| 815 | 2024-08-02 00:18:08 | coatings | 1 | 82945 | 5 | 4.966 | 16702.6 |
| 814 | 2024-07-30 10:39:54 | coatings | 1 | 82945 | 5 | 4.250 | 19516.5 |
| 813 | 2024-07-25 16:00:11 | coatings | 2 | 121059 | 58 | 16.923 | 7153.5 |
| 812 | 2024-07-24 22:13:40 | coatings | 2 | 121059 | 58 | 6.766 | 17892.3 |
| 811 | 2024-07-24 22:12:06 | coatings | 1 | 82945 | 5 | 4.890 | 16962.2 |
| 810 | 2024-07-22 01:30:06 | coatings | 3 | 146162 | 563 | 16.360 | 8934.1 |
| 809 | 2024-07-20 22:21:36 | coatings | 3 | 146162 | 563 | 17.016 | 8589.7 |
| 808 | 2024-07-20 22:03:51 | coatings | 3 | 146162 | 563 | 27.573 | 5300.9 |
| 807 | 2024-07-20 21:14:03 | coatings | 3 | 146162 | 563 | 29.126 | 5018.3 |
| 806 | 2024-07-20 17:50:46 | coatings | 3 | 146162 | 563 | 43.253 | 3379.2 |
| 805 | 2024-07-20 15:22:27 | coatings | 2 | 121059 | 58 | 13.906 | 8705.5 |
| 804 | 2024-07-20 15:18:42 | coatings | 1 | 82945 | 5 | 4.876 | 17010.9 |
| 803 | 2024-07-20 08:53:38 | coatings | 3 | 146162 | 563 | 39.113 | 3736.9 |
| 802 | 2024-07-12 10:24:15 | coatings | 1 | 82945 | 5 | 4.440 | 18681.3 |
| 801 | 2024-07-07 01:26:18 | coatings | 1 | 82945 | 5 | 7.670 | 10814.2 |
| 800 | 2024-07-02 21:30:18 | coatings | 1 | 82945 | 5 | 7.813 | 10616.3 |
| 799 | 2024-06-30 08:08:52 | coatings | 1 | 82945 | 5 | 3.593 | 23085.2 |
| 798 | 2024-06-26 09:51:47 | coatings | 1 | 82945 | 5 | 3.700 | 22417.6 |
| 797 | 2024-06-20 21:53:03 | coatings | 1 | 82945 | 5 | 4.796 | 17294.6 |
| 796 | 2024-06-20 20:57:46 | coatings | 3 | 146162 | 563 | 27.986 | 5222.7 |
| 795 | 2024-06-20 02:01:02 | coatings | 3 | 146162 | 563 | 34.393 | 4249.8 |
| 794 | 2024-06-18 23:51:56 | coatings | 3 | 146162 | 563 | 28.546 | 5120.2 |
| 793 | 2024-06-13 01:36:56 | coatings | 2 | 121059 | 58 | 13.876 | 8724.3 |
| 792 | 2024-06-13 01:36:07 | coatings | 1 | 82945 | 5 | 6.186 | 13408.5 |
| 791 | 2024-06-12 14:12:18 | coatings | 2 | 121059 | 58 | 14.390 | 8412.7 |
| 790 | 2024-06-10 16:18:32 | coatings | 1 | 82945 | 5 | 6.953 | 11929.4 |
| 789 | 2024-06-08 21:48:09 | coatings | 1 | 82945 | 5 | 3.326 | 24938.4 |
| 788 | 2024-06-05 18:33:47 | coatings | 1 | 82945 | 5 | 3.186 | 26034.2 |
| 787 | 2024-06-01 10:38:20 | coatings | 3 | 146162 | 563 | 45.863 | 3186.9 |
| 786 | 2024-05-30 18:47:45 | coatings | 3 | 146162 | 563 | 14.123 | 10349.2 |
| 785 | 2024-05-30 16:15:13 | coatings | 1 | 82945 | 5 | 1.750 | 47397.1 |
| 784 | 2024-05-30 13:27:48 | coatings | 3 | 146162 | 563 | 18.483 | 7907.9 |
| 783 | 2024-05-05 20:05:29 | coatings | 3 | 146162 | 563 | 17.703 | 8256.3 |
| 782 | 2024-05-01 19:41:23 | coatings | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 781 | 2024-05-01 19:41:11 | coatings | 2 | 121059 | 58 | 7.910 | 15304.6 |
| 780 | 2024-05-01 15:02:13 | coatings | 3 | 146162 | 563 | 9.016 | 16211.4 |
| 779 | 2024-04-30 17:56:30 | coatings | 3 | 146162 | 563 | 29.203 | 5005.0 |
| 778 | 2024-04-30 13:02:47 | coatings | 3 | 146162 | 563 | 10.516 | 13899.0 |
| 777 | 2024-04-30 09:20:33 | coatings | 3 | 146162 | 563 | 25.843 | 5655.8 |
| 776 | 2024-04-30 09:20:34 | coatings | 2 | 121059 | 58 | 9.986 | 12122.9 |
| 775 | 2024-04-30 06:45:57 | coatings | 1 | 82945 | 5 | 3.266 | 25396.5 |
| 774 | 2024-04-30 05:07:45 | coatings | 1 | 82945 | 5 | 4.110 | 20181.3 |
| 773 | 2024-04-30 04:29:58 | coatings | 1 | 82945 | 5 | 1.653 | 50178.5 |
| 772 | 2024-04-30 04:24:52 | coatings | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 771 | 2024-04-25 18:58:32 | coatings | 1 | 82945 | 5 | 1.830 | 45325.1 |