History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pinots"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 893 | 2024-05-06 02:00:53 | pinots | 1 | 48755 | 8 | 0.893 | 54596.9 |
| 892 | 2024-05-02 07:22:46 | pinots | 1 | 48755 | 8 | 1.953 | 24964.2 |
| 891 | 2024-05-01 14:07:52 | pinots | 3 | 112716 | 976 | 19.406 | 5808.3 |
| 890 | 2024-05-01 14:07:33 | pinots | 3 | 112716 | 976 | 20.143 | 5595.8 |
| 889 | 2024-05-01 09:03:09 | pinots | 3 | 112716 | 976 | 6.626 | 17011.2 |
| 888 | 2024-04-20 16:03:12 | pinots | 3 | 112716 | 976 | 6.923 | 16281.4 |
| 887 | 2024-04-18 07:10:01 | pinots | 3 | 112716 | 976 | 27.300 | 4128.8 |
| 886 | 2024-04-18 03:40:24 | pinots | 3 | 112716 | 976 | 7.360 | 15314.7 |
| 885 | 2024-03-30 09:06:45 | pinots | 3 | 112716 | 976 | 12.376 | 9107.6 |
| 884 | 2024-03-29 03:44:41 | pinots | 2 | 82551 | 93 | 2.766 | 29844.9 |
| 883 | 2024-03-28 21:14:39 | pinots | 3 | 112716 | 976 | 12.940 | 8710.7 |
| 882 | 2024-03-28 21:14:40 | pinots | 2 | 82551 | 93 | 5.063 | 16304.8 |
| 881 | 2024-03-28 21:14:37 | pinots | 1 | 48755 | 8 | 1.890 | 25796.3 |
| 880 | 2024-03-12 19:35:09 | pinots | 2 | 82551 | 93 | 3.623 | 22785.3 |
| 879 | 2024-03-12 04:50:52 | pinots | 2 | 82551 | 93 | 9.080 | 9091.5 |
| 878 | 2024-03-12 00:51:55 | pinots | 3 | 112716 | 976 | 6.093 | 18499.3 |
| 877 | 2024-03-11 11:25:41 | pinots | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 876 | 2024-03-11 01:16:56 | pinots | 2 | 82551 | 93 | 5.296 | 15587.4 |
| 875 | 2024-03-11 00:16:23 | pinots | 3 | 112716 | 976 | 5.563 | 20261.7 |
| 874 | 2024-03-10 20:09:28 | pinots | 3 | 112716 | 976 | 11.456 | 9839.0 |
| 873 | 2024-03-10 18:02:18 | pinots | 3 | 112716 | 976 | 18.110 | 6224.0 |
| 872 | 2024-03-10 17:23:01 | pinots | 3 | 112716 | 976 | 13.970 | 8068.4 |
| 871 | 2024-03-07 17:04:27 | pinots | 1 | 48755 | 8 | 0.953 | 51159.5 |
| 870 | 2024-02-04 10:37:52 | pinots | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 869 | 2024-01-30 08:33:00 | pinots | 2 | 82551 | 93 | 2.266 | 36430.3 |
| 868 | 2024-01-30 08:32:23 | pinots | 3 | 112716 | 976 | 4.936 | 22835.5 |
| 867 | 2024-01-30 02:42:06 | pinots | 2 | 82551 | 93 | 2.626 | 31436.0 |
| 866 | 2024-01-30 02:40:30 | pinots | 3 | 112716 | 976 | 6.156 | 18309.9 |
| 865 | 2024-01-26 03:58:39 | pinots | 3 | 112716 | 976 | 5.410 | 20834.8 |
| 864 | 2024-01-22 12:31:16 | pinots | 3 | 112716 | 976 | 6.593 | 17096.3 |
| 863 | 2024-01-22 12:31:08 | pinots | 1 | 48755 | 8 | 0.920 | 52994.6 |
| 862 | 2024-01-22 12:31:02 | pinots | 2 | 82551 | 93 | 2.860 | 28864.0 |
| 861 | 2024-01-03 10:32:12 | pinots | 3 | 112716 | 976 | 5.110 | 22057.9 |
| 860 | 2023-12-28 07:20:37 | pinots | 3 | 112716 | 976 | 4.860 | 23192.6 |
| 859 | 2023-12-06 23:27:51 | pinots | 2 | 82551 | 93 | 2.236 | 36919.1 |
| 858 | 2023-12-04 20:10:05 | pinots | 1 | 48755 | 8 | 0.873 | 55847.7 |
| 857 | 2023-11-29 02:19:50 | pinots | 1 | 48755 | 8 | 0.856 | 56956.8 |
| 856 | 2023-11-27 22:17:16 | pinots | 3 | 112716 | 976 | 4.750 | 23729.7 |
| 855 | 2023-11-27 20:08:07 | pinots | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 854 | 2023-11-27 00:11:40 | pinots | 1 | 48755 | 8 | 0.860 | 56691.9 |
| 853 | 2023-11-13 16:49:55 | pinots | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 852 | 2023-11-10 20:30:52 | pinots | 2 | 82551 | 93 | 2.360 | 34979.2 |
| 851 | 2023-11-02 07:05:54 | pinots | 1 | 48755 | 8 | 1.983 | 24586.5 |
| 850 | 2023-10-21 07:40:19 | pinots | 1 | 48755 | 8 | 0.876 | 55656.4 |
| 849 | 2023-10-19 14:18:02 | pinots | 3 | 112716 | 976 | 9.860 | 11431.6 |
| 848 | 2023-10-19 13:08:09 | pinots | 3 | 112716 | 976 | 10.690 | 10544.1 |
| 847 | 2023-10-18 23:46:57 | pinots | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 846 | 2023-10-16 20:37:13 | pinots | 3 | 112716 | 976 | 5.406 | 20850.2 |
| 845 | 2023-10-13 16:29:56 | pinots | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 844 | 2023-10-05 17:47:37 | pinots | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 843 | 2023-09-26 08:18:27 | pinots | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 842 | 2023-09-22 17:24:57 | pinots | 3 | 112716 | 976 | 5.610 | 20092.0 |
| 841 | 2023-09-22 15:48:47 | pinots | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 840 | 2023-09-18 19:20:59 | pinots | 3 | 112716 | 976 | 5.766 | 19548.4 |
| 839 | 2023-09-17 09:06:45 | pinots | 3 | 112716 | 976 | 5.420 | 20796.3 |
| 838 | 2023-09-14 07:48:44 | pinots | 3 | 112716 | 976 | 5.266 | 21404.5 |
| 837 | 2023-09-12 17:50:02 | pinots | 1 | 48755 | 8 | 0.746 | 65355.2 |
| 836 | 2023-09-11 21:42:57 | pinots | 3 | 112716 | 976 | 5.330 | 21147.5 |
| 835 | 2023-09-11 01:50:38 | pinots | 3 | 112716 | 976 | 6.126 | 18399.6 |
| 834 | 2023-09-09 19:36:15 | pinots | 3 | 112716 | 976 | 4.673 | 24120.7 |
| 833 | 2023-09-08 07:49:14 | pinots | 3 | 112716 | 976 | 5.296 | 21283.2 |
| 832 | 2023-09-05 20:45:02 | pinots | 3 | 112716 | 976 | 5.356 | 21044.8 |
| 831 | 2023-08-23 02:43:09 | pinots | 3 | 112716 | 976 | 4.843 | 23274.0 |
| 830 | 2023-08-15 17:52:26 | pinots | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 829 | 2023-06-23 09:54:03 | pinots | 3 | 112716 | 976 | 4.673 | 24120.7 |
| 828 | 2023-06-17 08:58:17 | pinots | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 827 | 2023-05-08 16:00:40 | pinots | 1 | 48755 | 8 | 0.733 | 66514.3 |
| 826 | 2023-04-01 12:17:14 | pinots | 1 | 48755 | 8 | 0.813 | 59969.2 |
| 825 | 2023-02-17 21:33:18 | pinots | 3 | 112716 | 976 | 5.330 | 21147.5 |
| 824 | 2023-02-02 07:05:34 | pinots | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 823 | 2023-01-14 21:03:25 | pinots | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 822 | 2022-12-29 05:19:53 | pinots | 3 | 112716 | 976 | 5.516 | 20434.4 |
| 821 | 2022-11-29 08:44:28 | pinots | 3 | 112716 | 976 | 5.233 | 21539.5 |
| 820 | 2022-11-26 21:21:05 | pinots | 3 | 112716 | 976 | 5.610 | 20092.0 |
| 819 | 2022-11-13 05:55:08 | pinots | 3 | 112716 | 976 | 6.063 | 18590.8 |
| 818 | 2022-11-11 05:41:10 | pinots | 3 | 112716 | 976 | 5.453 | 20670.5 |
| 817 | 2022-11-07 06:48:40 | pinots | 1 | 48755 | 8 | 0.736 | 66243.2 |
| 816 | 2022-10-19 10:20:07 | pinots | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 815 | 2022-10-06 09:52:00 | pinots | 3 | 112716 | 976 | 4.766 | 23650.0 |
| 814 | 2022-10-05 11:41:40 | pinots | 3 | 112716 | 976 | 5.110 | 22057.9 |
| 813 | 2022-10-04 19:59:29 | pinots | 3 | 112716 | 976 | 5.673 | 19868.9 |
| 812 | 2022-10-03 11:37:39 | pinots | 3 | 112716 | 976 | 4.766 | 23650.0 |
| 811 | 2022-10-02 06:34:20 | pinots | 3 | 112716 | 976 | 4.750 | 23729.7 |
| 810 | 2022-10-01 08:47:51 | pinots | 3 | 112716 | 976 | 4.860 | 23192.6 |
| 809 | 2022-09-30 17:55:34 | pinots | 3 | 112716 | 976 | 4.813 | 23419.1 |
| 808 | 2022-09-30 09:23:04 | pinots | 3 | 112716 | 976 | 4.780 | 23580.8 |
| 807 | 2022-09-29 11:38:27 | pinots | 3 | 112716 | 976 | 4.656 | 24208.8 |
| 806 | 2022-09-28 12:22:54 | pinots | 3 | 112716 | 976 | 4.796 | 23502.1 |
| 805 | 2022-09-27 06:19:05 | pinots | 3 | 112716 | 976 | 4.670 | 24136.2 |
| 804 | 2022-09-26 23:50:36 | pinots | 3 | 112716 | 976 | 4.626 | 24365.8 |
| 803 | 2022-09-25 11:36:02 | pinots | 3 | 112716 | 976 | 4.750 | 23729.7 |
| 802 | 2022-09-24 10:54:21 | pinots | 3 | 112716 | 976 | 5.096 | 22118.5 |
| 801 | 2022-09-23 10:16:09 | pinots | 3 | 112716 | 976 | 4.706 | 23951.6 |
| 800 | 2022-09-22 10:13:02 | pinots | 3 | 112716 | 976 | 4.706 | 23951.6 |
| 799 | 2022-09-21 22:28:05 | pinots | 3 | 112716 | 976 | 5.360 | 21029.1 |
| 798 | 2022-09-20 09:05:41 | pinots | 3 | 112716 | 976 | 4.640 | 24292.2 |
| 797 | 2022-09-19 12:16:52 | pinots | 3 | 112716 | 976 | 4.673 | 24120.7 |
| 796 | 2022-09-18 20:33:48 | pinots | 3 | 112716 | 976 | 4.856 | 23211.7 |
| 795 | 2022-09-17 09:10:45 | pinots | 3 | 112716 | 976 | 4.643 | 24276.5 |
| 794 | 2022-09-07 23:52:59 | pinots | 3 | 112716 | 976 | 4.766 | 23650.0 |