History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prosciutto"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
159 | 2024-05-30 05:04:33 | prosciutto | 4 | 161450 | 20 | 48.020 | 3362.1 |
158 | 2024-05-28 07:17:49 | prosciutto | 4 | 161450 | 20 | 37.000 | 4363.5 |
157 | 2024-05-28 07:17:35 | prosciutto | 3 | 140603 | 5 | 12.563 | 11191.8 |
156 | 2024-05-27 03:20:58 | prosciutto | 4 | 161450 | 20 | 37.723 | 4279.9 |
155 | 2024-05-26 23:37:07 | prosciutto | 4 | 161450 | 20 | 39.190 | 4119.7 |
154 | 2024-05-26 23:36:54 | prosciutto | 3 | 140603 | 5 | 18.783 | 7485.7 |
153 | 2024-05-26 14:49:32 | prosciutto | 4 | 161450 | 20 | 32.330 | 4993.8 |
152 | 2024-05-24 19:11:28 | prosciutto | 4 | 161450 | 20 | 32.096 | 5030.2 |
151 | 2024-05-24 19:11:34 | prosciutto | 3 | 140603 | 5 | 15.330 | 9171.8 |
150 | 2024-05-24 19:11:31 | prosciutto | 2 | 108824 | 3 | 7.670 | 14188.3 |
149 | 2024-05-24 19:08:51 | prosciutto | 1 | 67641 | 3 | 2.623 | 25787.6 |
148 | 2024-05-16 21:57:25 | prosciutto | 5 | 173545 | 176 | 17.486 | 9924.8 |
147 | 2024-05-10 06:53:53 | prosciutto | 1 | 67641 | 3 | 1.060 | 63812.3 |
146 | 2024-04-25 11:56:35 | prosciutto | 5 | 173545 | 176 | 56.706 | 3060.4 |
145 | 2024-04-24 08:21:39 | prosciutto | 3 | 140603 | 5 | 21.953 | 6404.7 |
144 | 2024-04-24 08:21:55 | prosciutto | 2 | 108824 | 3 | 4.796 | 22690.6 |
143 | 2024-04-24 08:14:38 | prosciutto | 3 | 140603 | 5 | 19.126 | 7351.4 |
142 | 2024-04-24 08:14:50 | prosciutto | 2 | 108824 | 3 | 5.203 | 20915.6 |
141 | 2024-04-24 08:14:07 | prosciutto | 1 | 67641 | 3 | 1.500 | 45094.0 |
140 | 2024-04-24 08:13:43 | prosciutto | 1 | 67641 | 3 | 3.623 | 18669.9 |
139 | 2024-04-23 23:38:06 | prosciutto | 5 | 173545 | 176 | 23.533 | 7374.5 |
138 | 2024-04-22 18:52:32 | prosciutto | 5 | 173545 | 176 | 25.516 | 6801.4 |
137 | 2024-04-22 00:53:46 | prosciutto | 5 | 173545 | 176 | 64.270 | 2700.2 |
136 | 2024-04-22 00:54:12 | prosciutto | 1 | 67641 | 3 | 1.313 | 51516.4 |
135 | 2024-04-22 00:53:52 | prosciutto | 2 | 108824 | 3 | 7.796 | 13959.0 |
134 | 2024-04-22 00:53:38 | prosciutto | 1 | 67641 | 3 | 3.970 | 17038.0 |
133 | 2024-04-22 00:52:56 | prosciutto | 3 | 140603 | 5 | 9.503 | 14795.6 |
132 | 2024-04-22 00:23:51 | prosciutto | 4 | 161450 | 20 | 17.173 | 9401.4 |
131 | 2024-04-20 06:28:25 | prosciutto | 4 | 161450 | 20 | 23.563 | 6851.8 |
130 | 2024-04-20 06:28:26 | prosciutto | 3 | 140603 | 5 | 22.796 | 6167.9 |
129 | 2024-04-20 06:28:26 | prosciutto | 2 | 108824 | 3 | 7.123 | 15277.8 |
128 | 2024-04-20 06:18:15 | prosciutto | 1 | 67641 | 3 | 1.233 | 54858.9 |
127 | 2024-03-28 19:36:46 | prosciutto | 4 | 161450 | 20 | 32.706 | 4936.4 |
126 | 2024-03-24 08:13:41 | prosciutto | 5 | 173545 | 176 | 28.610 | 6065.9 |
125 | 2024-03-22 08:04:38 | prosciutto | 4 | 161450 | 20 | 26.330 | 6131.8 |
124 | 2024-03-22 03:05:45 | prosciutto | 4 | 161450 | 20 | 40.223 | 4013.9 |
123 | 2024-03-21 16:57:47 | prosciutto | 5 | 173545 | 176 | 59.160 | 2933.5 |
122 | 2024-03-21 16:57:54 | prosciutto | 4 | 161450 | 20 | 35.953 | 4490.6 |
121 | 2024-03-21 16:57:54 | prosciutto | 3 | 140603 | 5 | 8.140 | 17273.1 |
120 | 2024-03-21 16:57:55 | prosciutto | 2 | 108824 | 3 | 5.390 | 20190.0 |
119 | 2024-03-21 16:53:04 | prosciutto | 1 | 67641 | 3 | 3.780 | 17894.4 |
118 | 2024-03-05 23:22:26 | prosciutto | 2 | 108824 | 3 | 5.156 | 21106.3 |
117 | 2024-03-05 23:21:11 | prosciutto | 1 | 67641 | 3 | 2.623 | 25787.6 |
116 | 2024-02-26 03:06:30 | prosciutto | 3 | 140603 | 5 | 19.156 | 7339.9 |
115 | 2024-02-26 03:06:28 | prosciutto | 4 | 161450 | 20 | 20.406 | 7911.9 |
114 | 2024-02-26 03:06:18 | prosciutto | 2 | 108824 | 3 | 7.593 | 14332.1 |
113 | 2024-02-26 03:05:01 | prosciutto | 2 | 108824 | 3 | 7.580 | 14356.7 |
112 | 2024-02-23 00:21:30 | prosciutto | 5 | 173545 | 176 | 27.613 | 6284.9 |
111 | 2024-02-20 01:15:32 | prosciutto | 5 | 173545 | 176 | 30.736 | 5646.3 |
110 | 2024-02-19 20:12:01 | prosciutto | 3 | 140603 | 5 | 10.830 | 12982.7 |
109 | 2024-02-19 15:53:05 | prosciutto | 4 | 161450 | 20 | 21.783 | 7411.7 |
108 | 2024-02-19 00:25:02 | prosciutto | 1 | 67641 | 3 | 4.030 | 16784.4 |
107 | 2024-02-18 23:44:02 | prosciutto | 5 | 173545 | 176 | 31.906 | 5439.3 |
106 | 2024-02-18 00:40:49 | prosciutto | 5 | 173545 | 176 | 31.173 | 5567.2 |
105 | 2024-02-18 00:40:49 | prosciutto | 4 | 161450 | 20 | 28.830 | 5600.1 |
104 | 2024-02-18 00:40:49 | prosciutto | 3 | 140603 | 5 | 17.360 | 8099.3 |
103 | 2024-02-18 00:40:50 | prosciutto | 2 | 108824 | 3 | 3.703 | 29388.1 |
102 | 2024-02-17 20:50:47 | prosciutto | 1 | 67641 | 3 | 1.266 | 53428.9 |
101 | 2024-01-22 22:38:10 | prosciutto | 1 | 67641 | 3 | 1.203 | 56226.9 |
100 | 2024-01-19 19:54:31 | prosciutto | 1 | 67641 | 3 | 1.170 | 57812.8 |
99 | 2024-01-09 13:50:04 | prosciutto | 1 | 67641 | 3 | 1.046 | 64666.3 |
98 | 2023-11-18 02:12:02 | prosciutto | 1 | 67641 | 3 | 1.016 | 66575.8 |
97 | 2023-10-31 02:49:31 | prosciutto | 1 | 67641 | 3 | 1.453 | 46552.6 |
96 | 2023-09-30 07:43:11 | prosciutto | 2 | 108824 | 3 | 3.266 | 33320.3 |
95 | 2023-09-05 08:18:53 | prosciutto | 1 | 67641 | 3 | 1.030 | 65670.9 |
94 | 2023-07-11 20:23:49 | prosciutto | 2 | 108824 | 3 | 2.830 | 38453.7 |
93 | 2023-06-07 13:38:39 | prosciutto | 1 | 67641 | 3 | 1.030 | 65670.9 |
92 | 2023-03-27 18:09:26 | prosciutto | 1 | 67641 | 3 | 1.203 | 56226.9 |
91 | 2023-03-27 13:17:22 | prosciutto | 2 | 108824 | 3 | 3.173 | 34296.9 |
90 | 2023-01-13 05:37:35 | prosciutto | 1 | 67641 | 3 | 1.076 | 62863.4 |
89 | 2022-12-23 20:58:56 | prosciutto | 2 | 108824 | 3 | 2.673 | 40712.3 |
88 | 2022-10-30 15:35:37 | prosciutto | 1 | 67641 | 3 | 1.143 | 59178.5 |
87 | 2022-08-22 00:13:51 | prosciutto | 2 | 108824 | 3 | 2.690 | 40455.0 |
86 | 2022-06-19 01:37:32 | prosciutto | 1 | 67641 | 3 | 1.046 | 64666.3 |
85 | 2021-05-30 14:10:04 | prosciutto | 1 | 67641 | 3 | 1.200 | 56367.5 |
84 | 2021-05-16 08:30:35 | prosciutto | 4 | 161450 | 20 | 11.093 | 14554.2 |
83 | 2021-05-05 07:15:29 | prosciutto | 1 | 67641 | 3 | 1.173 | 57665.0 |
82 | 2021-04-15 22:50:29 | prosciutto | 4 | 161450 | 20 | 11.296 | 14292.7 |
81 | 2021-04-03 10:01:29 | prosciutto | 1 | 67641 | 3 | 2.296 | 29460.4 |
80 | 2021-02-21 23:09:43 | prosciutto | 4 | 161450 | 20 | 11.376 | 14192.2 |
79 | 2021-02-11 19:52:26 | prosciutto | 1 | 67641 | 3 | 1.076 | 62863.4 |
78 | 2020-03-30 03:03:20 | prosciutto | 1 | 67641 | 3 | 1.236 | 54725.7 |
77 | 2020-02-20 08:47:16 | prosciutto | 4 | 161450 | 20 | 13.873 | 11637.7 |
76 | 2020-02-20 06:51:16 | prosciutto | 1 | 67641 | 3 | 2.466 | 27429.4 |
75 | 2020-02-16 18:02:39 | prosciutto | 4 | 161450 | 20 | 14.190 | 11377.7 |
74 | 2020-02-15 11:00:43 | prosciutto | 1 | 67641 | 3 | 1.393 | 48557.8 |
73 | 2020-02-14 13:02:02 | prosciutto | 4 | 161450 | 20 | 25.750 | 6269.9 |
72 | 2020-02-14 11:46:01 | prosciutto | 1 | 67641 | 3 | 1.343 | 50365.6 |
71 | 2020-01-31 00:44:53 | prosciutto | 4 | 161450 | 20 | 36.046 | 4479.0 |
70 | 2020-01-19 13:48:51 | prosciutto | 3 | 140603 | 5 | 6.610 | 21271.3 |
69 | 2020-01-19 12:21:18 | prosciutto | 4 | 161450 | 20 | 25.580 | 6311.6 |
68 | 2020-01-19 12:21:13 | prosciutto | 2 | 108824 | 3 | 3.813 | 28540.3 |
67 | 2020-01-19 09:03:33 | prosciutto | 1 | 67641 | 3 | 3.703 | 18266.5 |
66 | 2020-01-15 16:25:52 | prosciutto | 2 | 108824 | 3 | 3.436 | 31671.7 |
65 | 2020-01-15 11:39:40 | prosciutto | 1 | 67641 | 3 | 1.330 | 50857.9 |
64 | 2020-01-07 14:25:55 | prosciutto | 4 | 161450 | 20 | 38.440 | 4200.1 |
63 | 2020-01-07 08:15:14 | prosciutto | 1 | 67641 | 3 | 1.186 | 57032.9 |
62 | 2019-07-10 05:37:07 | prosciutto | 1 | 67641 | 3 | 1.113 | 60773.6 |
61 | 2018-08-05 18:00:13 | prosciutto | 1 | 67641 | 3 | 1.166 | 58011.1 |
60 | 2018-05-11 03:33:39 | prosciutto | 1 | 67641 | 3 | 1.160 | 58311.2 |