History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pinole"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 941 | 2024-04-03 18:05:59 | pinole | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 940 | 2024-03-31 18:26:39 | pinole | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 939 | 2024-03-28 19:57:54 | pinole | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 938 | 2024-03-28 19:57:46 | pinole | 3 | 112716 | 740 | 6.500 | 17340.9 |
| 937 | 2024-03-28 19:57:46 | pinole | 2 | 82551 | 68 | 2.593 | 31836.1 |
| 936 | 2024-03-11 04:11:42 | pinole | 1 | 48755 | 5 | 1.826 | 26700.4 |
| 935 | 2024-03-10 18:04:12 | pinole | 3 | 112716 | 740 | 15.326 | 7354.6 |
| 934 | 2024-03-10 16:23:08 | pinole | 3 | 112716 | 740 | 12.953 | 8701.9 |
| 933 | 2024-03-10 16:11:37 | pinole | 3 | 112716 | 740 | 13.423 | 8397.2 |
| 932 | 2024-03-10 08:35:16 | pinole | 3 | 112716 | 740 | 15.843 | 7114.6 |
| 931 | 2024-03-09 21:46:09 | pinole | 3 | 112716 | 740 | 21.096 | 5343.0 |
| 930 | 2024-03-09 08:43:15 | pinole | 3 | 112716 | 740 | 4.736 | 23799.8 |
| 929 | 2024-03-07 10:47:54 | pinole | 1 | 48755 | 5 | 1.030 | 47335.0 |
| 928 | 2024-01-04 15:05:49 | pinole | 3 | 112716 | 740 | 4.970 | 22679.3 |
| 927 | 2024-01-04 15:05:48 | pinole | 2 | 82551 | 68 | 2.406 | 34310.5 |
| 926 | 2023-12-28 13:44:44 | pinole | 2 | 82551 | 68 | 2.123 | 38884.1 |
| 925 | 2023-12-28 10:42:49 | pinole | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 924 | 2023-12-24 12:32:29 | pinole | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 923 | 2023-12-06 06:51:58 | pinole | 3 | 112716 | 740 | 5.516 | 20434.4 |
| 922 | 2023-12-06 06:51:55 | pinole | 2 | 82551 | 68 | 2.593 | 31836.1 |
| 921 | 2023-12-02 12:56:45 | pinole | 2 | 82551 | 68 | 4.343 | 19007.8 |
| 920 | 2023-12-02 12:56:41 | pinole | 3 | 112716 | 740 | 6.906 | 16321.5 |
| 919 | 2023-11-27 17:07:31 | pinole | 3 | 112716 | 740 | 5.076 | 22205.7 |
| 918 | 2023-11-24 15:48:26 | pinole | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 917 | 2023-11-14 00:46:53 | pinole | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 916 | 2023-11-11 01:13:01 | pinole | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 915 | 2023-11-06 15:24:01 | pinole | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 914 | 2023-11-04 14:13:07 | pinole | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 913 | 2023-10-22 06:08:56 | pinole | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 912 | 2023-10-19 00:25:44 | pinole | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 911 | 2023-10-13 23:21:49 | pinole | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 910 | 2023-10-11 23:20:10 | pinole | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 909 | 2023-10-05 01:16:38 | pinole | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 908 | 2023-10-01 16:09:21 | pinole | 2 | 82551 | 68 | 2.186 | 37763.5 |
| 907 | 2023-09-29 03:37:35 | pinole | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 906 | 2023-09-22 15:34:56 | pinole | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 905 | 2023-08-26 20:57:47 | pinole | 3 | 112716 | 740 | 4.766 | 23650.0 |
| 904 | 2023-08-17 02:48:57 | pinole | 3 | 112716 | 740 | 5.280 | 21347.7 |
| 903 | 2023-08-10 07:07:39 | pinole | 3 | 112716 | 740 | 6.203 | 18171.2 |
| 902 | 2023-08-09 07:58:59 | pinole | 3 | 112716 | 740 | 4.873 | 23130.7 |
| 901 | 2023-08-08 07:09:39 | pinole | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 900 | 2023-07-24 06:51:58 | pinole | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 899 | 2023-07-20 01:09:42 | pinole | 3 | 112716 | 740 | 5.813 | 19390.3 |
| 898 | 2023-07-11 21:08:01 | pinole | 2 | 82551 | 68 | 2.626 | 31436.0 |
| 897 | 2023-06-30 15:00:24 | pinole | 2 | 82551 | 68 | 2.403 | 34353.3 |
| 896 | 2023-05-12 16:12:12 | pinole | 3 | 112716 | 740 | 4.670 | 24136.2 |
| 895 | 2023-05-07 15:31:21 | pinole | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 894 | 2023-05-01 23:58:23 | pinole | 3 | 112716 | 740 | 5.186 | 21734.7 |
| 893 | 2023-04-23 11:59:39 | pinole | 2 | 82551 | 68 | 2.453 | 33653.1 |
| 892 | 2023-04-16 04:56:11 | pinole | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 891 | 2023-03-26 06:11:44 | pinole | 2 | 82551 | 68 | 2.173 | 37989.4 |
| 890 | 2023-03-21 22:19:38 | pinole | 3 | 112716 | 740 | 4.686 | 24053.8 |
| 889 | 2023-03-02 19:05:36 | pinole | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 888 | 2023-02-19 10:13:44 | pinole | 3 | 112716 | 740 | 4.970 | 22679.3 |
| 887 | 2023-02-08 19:49:15 | pinole | 3 | 112716 | 740 | 4.640 | 24292.2 |
| 886 | 2023-01-17 15:09:48 | pinole | 3 | 112716 | 740 | 5.343 | 21096.0 |
| 885 | 2023-01-07 11:24:05 | pinole | 3 | 112716 | 740 | 4.656 | 24208.8 |
| 884 | 2023-01-07 11:05:42 | pinole | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 883 | 2022-12-26 23:48:07 | pinole | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 882 | 2022-12-23 06:27:58 | pinole | 2 | 82551 | 68 | 2.296 | 35954.3 |
| 881 | 2022-12-12 02:18:43 | pinole | 3 | 112716 | 740 | 5.326 | 21163.3 |
| 880 | 2022-12-04 04:53:01 | pinole | 3 | 112716 | 740 | 5.203 | 21663.7 |
| 879 | 2022-12-03 17:46:39 | pinole | 3 | 112716 | 740 | 4.656 | 24208.8 |
| 878 | 2022-11-29 16:24:19 | pinole | 3 | 112716 | 740 | 4.656 | 24208.8 |
| 877 | 2022-11-09 04:20:02 | pinole | 3 | 112716 | 740 | 4.813 | 23419.1 |
| 876 | 2022-11-05 17:18:52 | pinole | 3 | 112716 | 740 | 4.783 | 23566.0 |
| 875 | 2022-11-03 22:42:31 | pinole | 3 | 112716 | 740 | 4.940 | 22817.0 |
| 874 | 2022-10-29 17:09:36 | pinole | 3 | 112716 | 740 | 5.860 | 19234.8 |
| 873 | 2022-09-26 21:04:54 | pinole | 3 | 112716 | 740 | 4.736 | 23799.8 |
| 872 | 2022-09-20 01:51:54 | pinole | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 871 | 2022-09-13 06:21:57 | pinole | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 870 | 2022-09-04 14:51:20 | pinole | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 869 | 2022-08-24 08:16:59 | pinole | 2 | 82551 | 68 | 2.170 | 38041.9 |
| 868 | 2022-07-18 22:41:02 | pinole | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 867 | 2022-07-16 15:58:49 | pinole | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 866 | 2022-07-06 23:32:48 | pinole | 3 | 112716 | 740 | 5.250 | 21469.7 |
| 865 | 2022-05-27 21:18:15 | pinole | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 864 | 2022-03-18 13:48:10 | pinole | 1 | 48755 | 5 | 1.016 | 47987.2 |
| 863 | 2022-02-09 10:44:49 | pinole | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 862 | 2021-12-26 16:37:55 | pinole | 1 | 48755 | 5 | 1.766 | 27607.6 |
| 861 | 2021-12-24 14:54:44 | pinole | 3 | 112716 | 740 | 5.296 | 21283.2 |
| 860 | 2021-12-23 13:35:06 | pinole | 3 | 112716 | 740 | 5.720 | 19705.6 |
| 859 | 2021-12-22 13:31:20 | pinole | 3 | 112716 | 740 | 6.076 | 18551.0 |
| 858 | 2021-12-21 13:29:24 | pinole | 3 | 112716 | 740 | 5.906 | 19085.0 |
| 857 | 2021-12-11 15:45:51 | pinole | 3 | 112716 | 740 | 4.700 | 23982.1 |
| 856 | 2021-12-11 06:51:48 | pinole | 3 | 112716 | 740 | 5.330 | 21147.5 |
| 855 | 2021-12-10 21:07:44 | pinole | 3 | 112716 | 740 | 5.063 | 22262.7 |
| 854 | 2021-12-10 13:56:52 | pinole | 3 | 112716 | 740 | 4.796 | 23502.1 |
| 853 | 2021-12-10 03:46:52 | pinole | 3 | 112716 | 740 | 4.766 | 23650.0 |
| 852 | 2021-12-09 18:02:13 | pinole | 3 | 112716 | 740 | 4.783 | 23566.0 |
| 851 | 2021-12-09 16:13:41 | pinole | 3 | 112716 | 740 | 6.156 | 18309.9 |
| 850 | 2021-12-09 03:46:16 | pinole | 3 | 112716 | 740 | 4.670 | 24136.2 |
| 849 | 2021-12-08 21:29:12 | pinole | 3 | 112716 | 740 | 5.436 | 20735.1 |
| 848 | 2021-12-08 11:31:13 | pinole | 3 | 112716 | 740 | 5.280 | 21347.7 |
| 847 | 2021-12-08 04:02:17 | pinole | 3 | 112716 | 740 | 4.766 | 23650.0 |
| 846 | 2021-12-07 17:46:05 | pinole | 3 | 112716 | 740 | 5.173 | 21789.3 |
| 845 | 2021-12-07 08:53:51 | pinole | 3 | 112716 | 740 | 5.016 | 22471.3 |
| 844 | 2021-12-06 20:33:30 | pinole | 3 | 112716 | 740 | 4.876 | 23116.5 |
| 843 | 2021-12-06 01:31:22 | pinole | 3 | 112716 | 740 | 4.873 | 23130.7 |
| 842 | 2021-12-05 13:47:49 | pinole | 3 | 112716 | 740 | 8.190 | 13762.6 |