History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"confections"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
244 | 2024-04-16 20:58:39 | confections | 2 | 86808 | 24 | 12.266 | 7077.1 |
243 | 2024-04-16 07:08:09 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
242 | 2024-04-16 03:07:54 | confections | 2 | 86808 | 24 | 2.766 | 31383.9 |
241 | 2024-04-16 03:01:29 | confections | 1 | 49908 | 4 | 0.983 | 50771.1 |
240 | 2024-04-14 12:21:59 | confections | 1 | 49908 | 4 | 2.516 | 19836.2 |
239 | 2024-04-12 00:35:20 | confections | 3 | 121633 | 88 | 15.233 | 7984.8 |
238 | 2024-04-11 18:14:41 | confections | 4 | 148819 | 325 | 27.610 | 5390.0 |
237 | 2024-04-10 09:31:50 | confections | 2 | 86808 | 24 | 6.983 | 12431.3 |
236 | 2024-04-10 09:24:48 | confections | 1 | 49908 | 4 | 0.860 | 58032.6 |
235 | 2024-04-09 13:02:52 | confections | 3 | 121633 | 88 | 22.033 | 5520.5 |
234 | 2024-04-08 17:08:59 | confections | 1 | 49908 | 4 | 3.690 | 13525.2 |
233 | 2024-04-07 00:18:21 | confections | 4 | 148819 | 325 | 39.550 | 3762.8 |
232 | 2024-04-06 09:10:28 | confections | 3 | 121633 | 88 | 14.203 | 8563.9 |
231 | 2024-04-05 16:41:08 | confections | 4 | 148819 | 325 | 25.440 | 5849.8 |
230 | 2024-04-04 13:00:07 | confections | 3 | 121633 | 88 | 19.690 | 6177.4 |
229 | 2024-04-04 13:00:05 | confections | 4 | 148819 | 325 | 13.030 | 11421.3 |
228 | 2024-04-04 13:00:07 | confections | 2 | 86808 | 24 | 4.360 | 19910.1 |
227 | 2024-04-04 12:58:55 | confections | 1 | 49908 | 4 | 0.953 | 52369.4 |
226 | 2024-03-14 14:14:56 | confections | 1 | 49908 | 4 | 1.096 | 45536.5 |
225 | 2024-03-12 23:50:01 | confections | 2 | 86808 | 24 | 5.733 | 15141.8 |
224 | 2024-03-12 23:45:42 | confections | 1 | 49908 | 4 | 1.890 | 26406.3 |
223 | 2024-03-12 20:39:36 | confections | 3 | 121633 | 88 | 18.330 | 6635.7 |
222 | 2024-03-11 18:37:30 | confections | 1 | 49908 | 4 | 2.486 | 20075.6 |
221 | 2024-03-11 18:30:04 | confections | 2 | 86808 | 24 | 5.106 | 17001.2 |
220 | 2024-03-11 18:30:02 | confections | 3 | 121633 | 88 | 5.576 | 21813.7 |
219 | 2024-03-11 18:22:13 | confections | 1 | 49908 | 4 | 0.873 | 57168.4 |
218 | 2024-03-11 07:44:59 | confections | 4 | 148819 | 325 | 23.406 | 6358.2 |
217 | 2024-03-09 02:50:02 | confections | 1 | 49908 | 4 | 0.843 | 59202.8 |
216 | 2024-03-08 03:23:39 | confections | 1 | 49908 | 4 | 0.953 | 52369.4 |
215 | 2024-03-07 10:11:21 | confections | 3 | 121633 | 88 | 16.936 | 7181.9 |
214 | 2024-03-07 08:36:58 | confections | 4 | 148819 | 325 | 31.440 | 4733.4 |
213 | 2024-03-06 10:08:54 | confections | 3 | 121633 | 88 | 12.580 | 9668.8 |
212 | 2024-03-06 10:08:53 | confections | 2 | 86808 | 24 | 5.563 | 15604.5 |
211 | 2024-03-06 10:06:21 | confections | 1 | 49908 | 4 | 2.030 | 24585.2 |
210 | 2024-03-06 05:03:26 | confections | 4 | 148819 | 325 | 31.860 | 4671.0 |
209 | 2024-03-04 10:27:51 | confections | 4 | 148819 | 325 | 32.393 | 4594.2 |
208 | 2024-03-04 10:27:51 | confections | 3 | 121633 | 88 | 19.313 | 6298.0 |
207 | 2024-03-04 10:27:47 | confections | 2 | 86808 | 24 | 2.893 | 30006.2 |
206 | 2024-03-04 10:05:40 | confections | 1 | 49908 | 4 | 3.106 | 16068.3 |
205 | 2024-02-16 02:06:01 | confections | 1 | 49908 | 4 | 1.923 | 25953.2 |
204 | 2024-02-08 09:49:33 | confections | 1 | 49908 | 4 | 1.003 | 49758.7 |
203 | 2024-02-08 00:31:17 | confections | 4 | 148819 | 325 | 21.706 | 6856.1 |
202 | 2024-02-05 11:47:28 | confections | 4 | 148819 | 325 | 12.046 | 12354.2 |
201 | 2024-02-05 11:47:26 | confections | 3 | 121633 | 88 | 11.703 | 10393.3 |
200 | 2024-02-05 11:47:23 | confections | 2 | 86808 | 24 | 2.813 | 30859.6 |
199 | 2024-02-05 10:26:41 | confections | 1 | 49908 | 4 | 0.923 | 54071.5 |
198 | 2024-02-03 01:52:34 | confections | 1 | 49908 | 4 | 0.890 | 56076.4 |
197 | 2024-02-02 05:43:40 | confections | 1 | 49908 | 4 | 0.936 | 53320.5 |
196 | 2024-02-02 01:50:19 | confections | 1 | 49908 | 4 | 0.860 | 58032.6 |
195 | 2023-12-25 05:14:10 | confections | 1 | 49908 | 4 | 0.860 | 58032.6 |
194 | 2023-12-13 06:40:14 | confections | 1 | 49908 | 4 | 0.763 | 65410.2 |
193 | 2023-12-11 06:34:22 | confections | 1 | 49908 | 4 | 0.796 | 62698.5 |
192 | 2023-12-01 05:30:49 | confections | 1 | 49908 | 4 | 0.843 | 59202.8 |
191 | 2023-10-23 19:53:15 | confections | 1 | 49908 | 4 | 0.890 | 56076.4 |
190 | 2023-10-11 19:55:18 | confections | 1 | 49908 | 4 | 0.860 | 58032.6 |
189 | 2023-10-06 04:25:19 | confections | 1 | 49908 | 4 | 0.936 | 53320.5 |
188 | 2023-09-30 10:15:32 | confections | 1 | 49908 | 4 | 0.783 | 63739.5 |
187 | 2023-09-15 19:34:50 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
186 | 2023-07-03 04:21:16 | confections | 1 | 49908 | 4 | 0.893 | 55888.0 |
185 | 2023-06-30 14:34:43 | confections | 1 | 49908 | 4 | 0.940 | 53093.6 |
184 | 2023-04-08 13:13:18 | confections | 1 | 49908 | 4 | 0.763 | 65410.2 |
183 | 2023-03-13 09:40:07 | confections | 1 | 49908 | 4 | 0.813 | 61387.5 |
182 | 2023-01-21 15:16:42 | confections | 1 | 49908 | 4 | 0.766 | 65154.0 |
181 | 2022-11-21 20:20:41 | confections | 1 | 49908 | 4 | 0.876 | 56972.6 |
180 | 2022-11-18 17:52:40 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
179 | 2022-09-05 08:06:03 | confections | 3 | 121633 | 88 | 5.153 | 23604.3 |
178 | 2022-09-02 02:24:13 | confections | 3 | 121633 | 88 | 4.626 | 26293.3 |
177 | 2022-08-01 13:03:58 | confections | 1 | 49908 | 4 | 0.766 | 65154.0 |
176 | 2022-07-15 02:24:09 | confections | 3 | 121633 | 88 | 4.860 | 25027.4 |
175 | 2022-07-10 06:06:30 | confections | 1 | 49908 | 4 | 0.750 | 66544.0 |
174 | 2022-07-08 02:12:55 | confections | 1 | 49908 | 4 | 0.766 | 65154.0 |
173 | 2022-06-14 18:52:13 | confections | 1 | 49908 | 4 | 0.796 | 62698.5 |
172 | 2022-04-06 23:16:31 | confections | 1 | 49908 | 4 | 0.826 | 60421.3 |
171 | 2022-03-04 05:11:46 | confections | 1 | 49908 | 4 | 0.766 | 65154.0 |
170 | 2021-12-23 00:59:24 | confections | 1 | 49908 | 4 | 0.953 | 52369.4 |
169 | 2021-12-18 21:58:21 | confections | 1 | 49908 | 4 | 1.063 | 46950.1 |
168 | 2021-11-09 09:12:25 | confections | 1 | 49908 | 4 | 0.906 | 55086.1 |
167 | 2021-10-01 04:13:51 | confections | 1 | 49908 | 4 | 0.843 | 59202.8 |
166 | 2021-09-12 14:25:53 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
165 | 2021-07-08 09:14:18 | confections | 1 | 49908 | 4 | 0.810 | 61614.8 |
164 | 2021-06-12 10:00:50 | confections | 1 | 49908 | 4 | 0.860 | 58032.6 |
163 | 2021-04-23 16:07:20 | confections | 1 | 49908 | 4 | 0.906 | 55086.1 |
162 | 2021-03-09 08:22:12 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
161 | 2021-03-06 02:43:41 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
160 | 2021-01-09 00:09:36 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
159 | 2020-12-01 16:35:16 | confections | 1 | 49908 | 4 | 0.783 | 63739.5 |
158 | 2020-11-17 11:14:54 | confections | 1 | 49908 | 4 | 0.780 | 63984.6 |
157 | 2020-10-28 08:51:58 | confections | 1 | 49908 | 4 | 0.860 | 58032.6 |
156 | 2020-10-21 11:17:47 | confections | 1 | 49908 | 4 | 0.796 | 62698.5 |
155 | 2020-08-27 16:40:22 | confections | 1 | 49908 | 4 | 0.876 | 56972.6 |
154 | 2020-05-26 03:58:56 | confections | 1 | 49908 | 4 | 0.766 | 65154.0 |
153 | 2020-03-24 22:26:29 | confections | 1 | 49908 | 4 | 0.906 | 55086.1 |
152 | 2020-03-22 17:02:49 | confections | 1 | 49908 | 4 | 0.906 | 55086.1 |
151 | 2020-03-06 08:53:36 | confections | 1 | 49908 | 4 | 0.766 | 65154.0 |
150 | 2020-03-01 07:02:04 | confections | 1 | 49908 | 4 | 1.110 | 44962.2 |
149 | 2020-03-01 05:19:23 | confections | 1 | 49908 | 4 | 0.966 | 51664.6 |
148 | 2020-02-24 01:07:39 | confections | 1 | 49908 | 4 | 3.033 | 16455.0 |
147 | 2020-02-22 22:13:40 | confections | 1 | 49908 | 4 | 1.970 | 25334.0 |
146 | 2020-02-21 10:46:06 | confections | 1 | 49908 | 4 | 0.906 | 55086.1 |
145 | 2020-02-20 14:11:15 | confections | 1 | 49908 | 4 | 2.250 | 22181.3 |