History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"picacho"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
269 | 2024-05-05 15:41:23 | picacho | 1 | 69583 | 2 | 1.266 | 54962.9 |
268 | 2024-05-03 05:17:20 | picacho | 1 | 69583 | 2 | 3.296 | 21111.3 |
267 | 2024-05-01 11:10:30 | picacho | 1 | 69583 | 2 | 1.360 | 51164.0 |
266 | 2024-04-19 00:19:50 | picacho | 1 | 69583 | 2 | 1.593 | 43680.5 |
265 | 2024-04-10 15:13:23 | picacho | 1 | 69583 | 2 | 2.843 | 24475.2 |
264 | 2024-04-08 09:43:58 | picacho | 4 | 151207 | 600 | 21.596 | 7001.6 |
263 | 2024-04-06 07:55:05 | picacho | 2 | 107671 | 3 | 8.190 | 13146.6 |
262 | 2024-04-06 07:55:01 | picacho | 3 | 134027 | 49 | 8.376 | 16001.3 |
261 | 2024-04-05 03:07:54 | picacho | 2 | 107671 | 3 | 8.483 | 12692.6 |
260 | 2024-04-05 03:07:19 | picacho | 3 | 134027 | 49 | 8.143 | 16459.2 |
259 | 2024-04-03 19:50:12 | picacho | 1 | 69583 | 2 | 1.920 | 36241.1 |
258 | 2024-04-03 18:39:13 | picacho | 4 | 151207 | 600 | 25.436 | 5944.6 |
257 | 2024-04-03 15:58:13 | picacho | 3 | 134027 | 49 | 18.640 | 7190.3 |
256 | 2024-04-03 15:34:52 | picacho | 4 | 151207 | 600 | 37.940 | 3985.4 |
255 | 2024-04-03 03:39:39 | picacho | 4 | 151207 | 600 | 28.983 | 5217.1 |
254 | 2024-04-03 03:36:16 | picacho | 3 | 134027 | 49 | 16.326 | 8209.4 |
253 | 2024-04-02 22:27:02 | picacho | 4 | 151207 | 600 | 42.110 | 3590.8 |
252 | 2024-04-02 21:30:29 | picacho | 1 | 69583 | 2 | 1.296 | 53690.6 |
251 | 2024-04-02 21:30:18 | picacho | 3 | 134027 | 49 | 11.470 | 11685.0 |
250 | 2024-04-02 21:30:16 | picacho | 4 | 151207 | 600 | 13.360 | 11317.9 |
249 | 2024-04-02 21:30:15 | picacho | 2 | 107671 | 3 | 7.093 | 15179.9 |
248 | 2024-04-02 21:30:12 | picacho | 1 | 69583 | 2 | 1.250 | 55666.4 |
247 | 2024-03-25 03:59:42 | picacho | 1 | 69583 | 2 | 1.216 | 57222.9 |
246 | 2024-03-05 02:28:39 | picacho | 1 | 69583 | 2 | 4.170 | 16686.6 |
245 | 2024-03-04 16:49:19 | picacho | 3 | 134027 | 49 | 23.656 | 5665.7 |
244 | 2024-03-02 03:36:39 | picacho | 3 | 134027 | 49 | 7.596 | 17644.4 |
243 | 2024-02-28 08:58:20 | picacho | 4 | 151207 | 600 | 27.640 | 5470.6 |
242 | 2024-02-28 08:58:16 | picacho | 2 | 107671 | 3 | 14.503 | 7424.1 |
241 | 2024-02-28 06:35:33 | picacho | 1 | 69583 | 2 | 1.423 | 48898.8 |
240 | 2024-02-26 12:27:09 | picacho | 3 | 134027 | 49 | 9.796 | 13681.8 |
239 | 2024-02-17 12:42:39 | picacho | 3 | 134027 | 49 | 6.030 | 22226.7 |
238 | 2024-02-09 16:42:10 | picacho | 4 | 151207 | 600 | 16.690 | 9059.7 |
237 | 2024-02-06 18:53:54 | picacho | 4 | 151207 | 600 | 13.670 | 11061.2 |
236 | 2024-02-06 18:53:50 | picacho | 2 | 107671 | 3 | 3.186 | 33795.0 |
235 | 2024-02-06 18:52:42 | picacho | 3 | 134027 | 49 | 6.140 | 21828.5 |
234 | 2024-02-01 13:23:36 | picacho | 2 | 107671 | 3 | 3.203 | 33615.7 |
233 | 2024-02-01 13:12:32 | picacho | 3 | 134027 | 49 | 8.280 | 16186.8 |
232 | 2024-01-26 13:40:35 | picacho | 3 | 134027 | 49 | 7.593 | 17651.4 |
231 | 2024-01-22 19:23:17 | picacho | 4 | 151207 | 600 | 23.470 | 6442.6 |
230 | 2024-01-16 14:20:55 | picacho | 4 | 151207 | 600 | 10.576 | 14297.2 |
229 | 2024-01-16 14:20:56 | picacho | 2 | 107671 | 3 | 3.326 | 32372.5 |
228 | 2024-01-16 00:59:49 | picacho | 3 | 134027 | 49 | 6.173 | 21711.8 |
227 | 2023-12-22 01:03:20 | picacho | 1 | 69583 | 2 | 1.203 | 57841.2 |
226 | 2023-12-17 06:01:11 | picacho | 1 | 69583 | 2 | 1.140 | 61037.7 |
225 | 2023-12-05 05:07:06 | picacho | 1 | 69583 | 2 | 1.063 | 65459.1 |
224 | 2023-12-03 11:34:32 | picacho | 1 | 69583 | 2 | 1.076 | 64668.2 |
223 | 2023-11-18 08:18:50 | picacho | 1 | 69583 | 2 | 1.063 | 65459.1 |
222 | 2023-11-17 09:44:40 | picacho | 3 | 134027 | 49 | 5.920 | 22639.7 |
221 | 2023-10-25 22:36:33 | picacho | 1 | 69583 | 2 | 1.220 | 57035.2 |
220 | 2023-10-14 01:51:53 | picacho | 1 | 69583 | 2 | 2.140 | 32515.4 |
219 | 2023-10-05 17:41:14 | picacho | 1 | 69583 | 2 | 1.093 | 63662.4 |
218 | 2023-10-02 04:52:36 | picacho | 1 | 69583 | 2 | 1.063 | 65459.1 |
217 | 2023-09-23 22:29:22 | picacho | 1 | 69583 | 2 | 1.186 | 58670.3 |
216 | 2023-09-15 11:16:50 | picacho | 1 | 69583 | 2 | 1.266 | 54962.9 |
215 | 2023-08-19 13:15:46 | picacho | 3 | 134027 | 49 | 5.673 | 23625.4 |
214 | 2023-07-30 03:40:48 | picacho | 1 | 69583 | 2 | 1.076 | 64668.2 |
213 | 2023-07-24 22:43:02 | picacho | 1 | 69583 | 2 | 1.080 | 64428.7 |
212 | 2023-05-06 08:57:47 | picacho | 3 | 134027 | 49 | 9.936 | 13489.0 |
211 | 2023-04-24 21:31:17 | picacho | 1 | 69583 | 2 | 1.106 | 62914.1 |
210 | 2023-03-15 17:36:55 | picacho | 1 | 69583 | 2 | 1.046 | 66522.9 |
209 | 2023-02-12 21:58:10 | picacho | 1 | 69583 | 2 | 1.156 | 60192.9 |
208 | 2023-02-12 10:36:51 | picacho | 3 | 134027 | 49 | 5.606 | 23907.8 |
207 | 2022-12-09 21:32:41 | picacho | 1 | 69583 | 2 | 1.046 | 66522.9 |
206 | 2022-11-24 09:33:14 | picacho | 3 | 134027 | 49 | 5.703 | 23501.1 |
205 | 2022-11-05 00:39:39 | picacho | 2 | 107671 | 3 | 5.876 | 18323.9 |
204 | 2022-11-03 03:07:52 | picacho | 1 | 69583 | 2 | 1.046 | 66522.9 |
203 | 2022-09-02 04:33:33 | picacho | 1 | 69583 | 2 | 1.186 | 58670.3 |
202 | 2022-08-10 19:44:04 | picacho | 1 | 69583 | 2 | 1.046 | 66522.9 |
201 | 2022-06-18 06:14:10 | picacho | 1 | 69583 | 2 | 1.063 | 65459.1 |
200 | 2022-05-15 22:55:32 | picacho | 2 | 107671 | 3 | 3.236 | 33272.9 |
199 | 2022-05-01 21:44:00 | picacho | 3 | 134027 | 49 | 5.686 | 23571.4 |
198 | 2022-04-02 04:13:52 | picacho | 1 | 69583 | 2 | 1.123 | 61961.7 |
197 | 2022-01-30 12:57:00 | picacho | 1 | 69583 | 2 | 1.233 | 56433.9 |
196 | 2022-01-27 01:43:35 | picacho | 1 | 69583 | 2 | 1.080 | 64428.7 |
195 | 2022-01-05 22:57:03 | picacho | 1 | 69583 | 2 | 1.123 | 61961.7 |
194 | 2021-11-06 06:47:56 | picacho | 1 | 69583 | 2 | 1.296 | 53690.6 |
193 | 2021-10-08 13:06:33 | picacho | 1 | 69583 | 2 | 1.063 | 65459.1 |
192 | 2021-09-24 11:58:25 | picacho | 1 | 69583 | 2 | 1.076 | 64668.2 |
191 | 2021-09-18 00:16:39 | picacho | 1 | 69583 | 2 | 1.186 | 58670.3 |
190 | 2021-03-23 04:36:33 | picacho | 1 | 69583 | 2 | 1.140 | 61037.7 |
189 | 2021-02-25 12:22:17 | picacho | 1 | 69583 | 2 | 1.096 | 63488.1 |
188 | 2021-02-01 13:53:08 | picacho | 1 | 69583 | 2 | 1.080 | 64428.7 |
187 | 2021-01-05 03:19:56 | picacho | 1 | 69583 | 2 | 1.093 | 63662.4 |
186 | 2020-11-02 08:16:37 | picacho | 1 | 69583 | 2 | 1.236 | 56296.9 |
185 | 2020-10-25 13:38:26 | picacho | 1 | 69583 | 2 | 1.126 | 61796.6 |
184 | 2020-10-19 11:03:37 | picacho | 1 | 69583 | 2 | 1.123 | 61961.7 |
183 | 2020-10-14 18:25:11 | picacho | 1 | 69583 | 2 | 1.076 | 64668.2 |
182 | 2020-09-02 19:04:37 | picacho | 1 | 69583 | 2 | 1.126 | 61796.6 |
181 | 2020-06-02 21:54:41 | picacho | 1 | 69583 | 2 | 1.140 | 61037.7 |
180 | 2020-03-28 12:28:59 | picacho | 1 | 69583 | 2 | 1.250 | 55666.4 |
179 | 2020-03-28 05:38:31 | picacho | 1 | 69583 | 2 | 1.330 | 52318.0 |
178 | 2020-03-25 01:08:22 | picacho | 1 | 69583 | 2 | 1.266 | 54962.9 |
177 | 2020-03-24 06:46:04 | picacho | 1 | 69583 | 2 | 2.643 | 26327.3 |
176 | 2020-03-20 15:06:30 | picacho | 1 | 69583 | 2 | 1.096 | 63488.1 |
175 | 2020-03-13 13:34:05 | picacho | 1 | 69583 | 2 | 1.106 | 62914.1 |
174 | 2020-03-04 12:26:32 | picacho | 1 | 69583 | 2 | 1.190 | 58473.1 |
173 | 2020-03-04 01:12:13 | picacho | 1 | 69583 | 2 | 1.076 | 64668.2 |
172 | 2020-02-25 14:16:19 | picacho | 1 | 69583 | 2 | 1.296 | 53690.6 |
171 | 2020-02-19 01:51:39 | picacho | 1 | 69583 | 2 | 1.093 | 63662.4 |
170 | 2020-02-18 16:36:35 | picacho | 1 | 69583 | 2 | 3.970 | 17527.2 |