History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pierced"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
291 | 2024-04-27 04:53:10 | pierced | 3 | 134027 | 306 | 16.126 | 8311.2 |
290 | 2024-03-27 05:30:06 | pierced | 2 | 107671 | 25 | 3.203 | 33615.7 |
289 | 2024-03-27 05:27:21 | pierced | 3 | 134027 | 306 | 6.983 | 19193.3 |
288 | 2024-03-26 09:03:28 | pierced | 3 | 134027 | 306 | 18.143 | 7387.3 |
287 | 2024-03-24 22:24:15 | pierced | 1 | 69583 | 6 | 1.080 | 64428.7 |
286 | 2024-03-24 22:24:11 | pierced | 2 | 107671 | 25 | 4.003 | 26897.6 |
285 | 2024-03-24 22:24:08 | pierced | 3 | 134027 | 306 | 6.550 | 20462.1 |
284 | 2024-03-07 00:05:31 | pierced | 1 | 69583 | 6 | 3.890 | 17887.7 |
283 | 2024-03-04 03:06:48 | pierced | 1 | 69583 | 6 | 1.220 | 57035.2 |
282 | 2024-02-28 11:05:45 | pierced | 1 | 69583 | 6 | 1.313 | 52995.4 |
281 | 2024-02-22 03:32:26 | pierced | 2 | 107671 | 25 | 3.030 | 35535.0 |
280 | 2024-02-22 03:30:41 | pierced | 3 | 134027 | 306 | 8.643 | 15507.0 |
279 | 2024-02-21 21:28:36 | pierced | 2 | 107671 | 25 | 3.560 | 30244.7 |
278 | 2024-02-21 13:03:26 | pierced | 3 | 134027 | 306 | 41.720 | 3212.5 |
277 | 2024-02-21 03:37:47 | pierced | 3 | 134027 | 306 | 11.046 | 12133.5 |
276 | 2024-02-21 03:37:46 | pierced | 2 | 107671 | 25 | 4.936 | 21813.4 |
275 | 2024-02-20 15:52:31 | pierced | 1 | 69583 | 6 | 1.780 | 39091.6 |
274 | 2024-02-11 15:06:42 | pierced | 1 | 69583 | 6 | 4.140 | 16807.5 |
273 | 2024-01-19 02:39:56 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
272 | 2024-01-15 14:47:52 | pierced | 3 | 134027 | 306 | 6.906 | 19407.3 |
271 | 2024-01-15 14:47:53 | pierced | 2 | 107671 | 25 | 3.436 | 31336.1 |
270 | 2023-12-13 06:00:16 | pierced | 1 | 69583 | 6 | 1.170 | 59472.6 |
269 | 2023-12-09 10:54:48 | pierced | 1 | 69583 | 6 | 1.080 | 64428.7 |
268 | 2023-11-18 20:58:45 | pierced | 3 | 134027 | 306 | 6.080 | 22043.9 |
267 | 2023-11-18 20:58:40 | pierced | 2 | 107671 | 25 | 3.436 | 31336.1 |
266 | 2023-11-17 18:06:34 | pierced | 1 | 69583 | 6 | 1.063 | 65459.1 |
265 | 2023-10-24 15:23:43 | pierced | 1 | 69583 | 6 | 1.220 | 57035.2 |
264 | 2023-10-21 13:42:00 | pierced | 1 | 69583 | 6 | 1.140 | 61037.7 |
263 | 2023-10-08 13:51:12 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
262 | 2023-09-29 19:24:34 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
261 | 2023-09-29 14:17:52 | pierced | 1 | 69583 | 6 | 1.203 | 57841.2 |
260 | 2023-09-24 17:04:25 | pierced | 1 | 69583 | 6 | 2.753 | 25275.3 |
259 | 2023-09-22 23:55:26 | pierced | 1 | 69583 | 6 | 1.140 | 61037.7 |
258 | 2023-07-17 17:15:02 | pierced | 1 | 69583 | 6 | 1.203 | 57841.2 |
257 | 2023-05-30 10:06:57 | pierced | 1 | 69583 | 6 | 1.123 | 61961.7 |
256 | 2023-04-19 14:24:50 | pierced | 1 | 69583 | 6 | 1.123 | 61961.7 |
255 | 2023-02-07 06:49:38 | pierced | 1 | 69583 | 6 | 1.076 | 64668.2 |
254 | 2023-02-07 05:48:15 | pierced | 1 | 69583 | 6 | 1.080 | 64428.7 |
253 | 2022-12-05 17:19:05 | pierced | 1 | 69583 | 6 | 1.063 | 65459.1 |
252 | 2022-10-09 18:04:54 | pierced | 1 | 69583 | 6 | 1.076 | 64668.2 |
251 | 2022-08-01 14:42:15 | pierced | 1 | 69583 | 6 | 1.156 | 60192.9 |
250 | 2022-06-11 23:37:00 | pierced | 1 | 69583 | 6 | 1.173 | 59320.5 |
249 | 2022-03-24 19:39:33 | pierced | 1 | 69583 | 6 | 1.346 | 51696.1 |
248 | 2022-02-07 15:50:26 | pierced | 1 | 69583 | 6 | 1.110 | 62687.4 |
247 | 2022-01-04 00:03:28 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
246 | 2021-11-04 09:46:53 | pierced | 1 | 69583 | 6 | 1.280 | 54361.7 |
245 | 2021-11-02 07:34:58 | pierced | 1 | 69583 | 6 | 1.126 | 61796.6 |
244 | 2021-10-24 10:21:38 | pierced | 1 | 69583 | 6 | 1.250 | 55666.4 |
243 | 2021-09-19 15:40:07 | pierced | 1 | 69583 | 6 | 1.250 | 55666.4 |
242 | 2021-09-02 05:29:51 | pierced | 1 | 69583 | 6 | 1.080 | 64428.7 |
241 | 2021-07-13 16:21:15 | pierced | 1 | 69583 | 6 | 1.216 | 57222.9 |
240 | 2021-05-05 04:00:15 | pierced | 1 | 69583 | 6 | 1.280 | 54361.7 |
239 | 2021-04-14 11:35:56 | pierced | 1 | 69583 | 6 | 1.300 | 53525.4 |
238 | 2021-04-03 06:43:14 | pierced | 1 | 69583 | 6 | 1.076 | 64668.2 |
237 | 2021-02-11 15:36:27 | pierced | 1 | 69583 | 6 | 1.123 | 61961.7 |
236 | 2021-01-18 02:57:36 | pierced | 1 | 69583 | 6 | 1.203 | 57841.2 |
235 | 2020-12-31 20:28:26 | pierced | 1 | 69583 | 6 | 1.076 | 64668.2 |
234 | 2020-11-12 16:21:40 | pierced | 1 | 69583 | 6 | 1.250 | 55666.4 |
233 | 2020-11-05 22:50:07 | pierced | 1 | 69583 | 6 | 2.500 | 27833.2 |
232 | 2020-10-29 13:10:41 | pierced | 1 | 69583 | 6 | 1.156 | 60192.9 |
231 | 2020-10-16 19:01:59 | pierced | 1 | 69583 | 6 | 1.360 | 51164.0 |
230 | 2020-09-28 19:58:08 | pierced | 1 | 69583 | 6 | 1.046 | 66522.9 |
229 | 2020-08-28 00:59:03 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
228 | 2020-06-13 06:03:09 | pierced | 1 | 69583 | 6 | 1.106 | 62914.1 |
227 | 2020-05-27 22:24:12 | pierced | 1 | 69583 | 6 | 1.063 | 65459.1 |
226 | 2020-03-27 07:26:27 | pierced | 1 | 69583 | 6 | 1.296 | 53690.6 |
225 | 2020-03-21 12:04:45 | pierced | 1 | 69583 | 6 | 1.076 | 64668.2 |
224 | 2020-03-14 09:26:35 | pierced | 1 | 69583 | 6 | 1.203 | 57841.2 |
223 | 2020-03-04 15:02:38 | pierced | 1 | 69583 | 6 | 1.203 | 57841.2 |
222 | 2020-02-29 18:41:31 | pierced | 3 | 134027 | 306 | 7.393 | 18128.9 |
221 | 2020-02-23 11:15:43 | pierced | 1 | 69583 | 6 | 2.673 | 26031.8 |
220 | 2020-02-19 00:48:27 | pierced | 3 | 134027 | 306 | 8.733 | 15347.2 |
219 | 2020-02-17 04:52:35 | pierced | 1 | 69583 | 6 | 1.436 | 48456.1 |
218 | 2020-02-14 21:37:13 | pierced | 3 | 134027 | 306 | 14.420 | 9294.5 |
217 | 2020-02-14 20:35:53 | pierced | 3 | 134027 | 306 | 8.016 | 16719.9 |
216 | 2020-02-14 18:58:24 | pierced | 3 | 134027 | 306 | 7.953 | 16852.4 |
215 | 2020-02-14 16:50:25 | pierced | 3 | 134027 | 306 | 16.970 | 7897.9 |
214 | 2020-02-14 13:36:12 | pierced | 1 | 69583 | 6 | 1.310 | 53116.8 |
213 | 2020-02-11 15:29:48 | pierced | 1 | 69583 | 6 | 2.843 | 24475.2 |
212 | 2020-02-10 03:47:48 | pierced | 1 | 69583 | 6 | 2.423 | 28717.7 |
211 | 2020-02-10 00:56:26 | pierced | 1 | 69583 | 6 | 1.343 | 51811.6 |
210 | 2020-02-03 01:41:05 | pierced | 1 | 69583 | 6 | 2.766 | 25156.5 |
209 | 2020-01-26 13:25:32 | pierced | 1 | 69583 | 6 | 1.436 | 48456.1 |
208 | 2020-01-22 23:51:57 | pierced | 2 | 107671 | 25 | 7.500 | 14356.1 |
207 | 2020-01-20 17:34:20 | pierced | 1 | 69583 | 6 | 1.356 | 51314.9 |
206 | 2020-01-20 16:52:29 | pierced | 1 | 69583 | 6 | 2.843 | 24475.2 |
205 | 2020-01-19 14:05:26 | pierced | 1 | 69583 | 6 | 1.266 | 54962.9 |
204 | 2020-01-15 14:23:13 | pierced | 3 | 134027 | 306 | 7.550 | 17751.9 |
203 | 2020-01-15 13:28:15 | pierced | 3 | 134027 | 306 | 6.626 | 20227.4 |
202 | 2020-01-15 09:31:15 | pierced | 3 | 134027 | 306 | 7.143 | 18763.4 |
201 | 2020-01-15 09:29:37 | pierced | 2 | 107671 | 25 | 3.310 | 32529.0 |
200 | 2020-01-15 06:02:55 | pierced | 1 | 69583 | 6 | 2.830 | 24587.6 |
199 | 2020-01-01 23:00:28 | pierced | 1 | 69583 | 6 | 1.326 | 52475.9 |
198 | 2019-12-29 07:33:18 | pierced | 1 | 69583 | 6 | 2.670 | 26061.0 |
197 | 2019-12-29 05:43:11 | pierced | 1 | 69583 | 6 | 1.310 | 53116.8 |
196 | 2019-12-28 18:34:27 | pierced | 1 | 69583 | 6 | 1.093 | 63662.4 |
195 | 2019-12-08 15:23:35 | pierced | 1 | 69583 | 6 | 1.186 | 58670.3 |
194 | 2019-11-11 09:48:26 | pierced | 1 | 69583 | 6 | 1.203 | 57841.2 |
193 | 2019-09-06 16:16:55 | pierced | 1 | 69583 | 6 | 1.196 | 58179.8 |
192 | 2019-06-07 00:20:44 | pierced | 1 | 69583 | 6 | 1.263 | 55093.4 |