History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hornist"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
325 | 2024-05-13 01:45:22 | hornist | 1 | 69583 | 3 | 3.016 | 23071.3 |
324 | 2024-05-13 01:42:43 | hornist | 1 | 69583 | 3 | 3.580 | 19436.6 |
323 | 2024-05-06 19:59:34 | hornist | 3 | 134027 | 256 | 13.690 | 9790.1 |
322 | 2024-05-04 14:26:45 | hornist | 3 | 134027 | 256 | 11.563 | 11591.0 |
321 | 2024-04-28 21:21:16 | hornist | 3 | 134027 | 256 | 12.750 | 10511.9 |
320 | 2024-04-25 23:01:00 | hornist | 2 | 107671 | 24 | 3.953 | 27237.8 |
319 | 2024-04-25 23:00:48 | hornist | 3 | 134027 | 256 | 7.076 | 18941.1 |
318 | 2024-04-25 19:39:55 | hornist | 1 | 69583 | 3 | 1.420 | 49002.1 |
317 | 2024-04-24 23:55:37 | hornist | 3 | 134027 | 256 | 17.343 | 7728.0 |
316 | 2024-04-20 23:08:03 | hornist | 3 | 134027 | 256 | 12.796 | 10474.1 |
315 | 2024-04-20 23:08:04 | hornist | 2 | 107671 | 24 | 10.280 | 10473.8 |
314 | 2024-04-20 23:07:46 | hornist | 3 | 134027 | 256 | 15.983 | 8385.6 |
313 | 2024-04-20 23:07:56 | hornist | 1 | 69583 | 3 | 5.250 | 13253.9 |
312 | 2024-04-20 23:07:43 | hornist | 2 | 107671 | 24 | 6.733 | 15991.5 |
311 | 2024-04-20 23:07:43 | hornist | 1 | 69583 | 3 | 1.330 | 52318.0 |
310 | 2024-03-18 03:52:33 | hornist | 1 | 69583 | 3 | 2.903 | 23969.3 |
309 | 2024-02-29 05:40:49 | hornist | 1 | 69583 | 3 | 1.203 | 57841.2 |
308 | 2024-02-28 17:12:28 | hornist | 1 | 69583 | 3 | 1.140 | 61037.7 |
307 | 2024-02-14 22:47:21 | hornist | 2 | 107671 | 24 | 11.076 | 9721.1 |
306 | 2024-02-14 22:46:58 | hornist | 1 | 69583 | 3 | 2.736 | 25432.4 |
305 | 2024-01-17 21:51:53 | hornist | 1 | 69583 | 3 | 1.250 | 55666.4 |
304 | 2024-01-12 01:46:45 | hornist | 2 | 107671 | 24 | 3.343 | 32207.9 |
303 | 2024-01-11 18:11:26 | hornist | 1 | 69583 | 3 | 1.153 | 60349.5 |
302 | 2023-11-20 08:35:43 | hornist | 1 | 69583 | 3 | 1.250 | 55666.4 |
301 | 2023-11-11 18:49:34 | hornist | 1 | 69583 | 3 | 1.216 | 57222.9 |
300 | 2023-11-06 00:58:15 | hornist | 1 | 69583 | 3 | 1.126 | 61796.6 |
299 | 2023-10-28 13:38:52 | hornist | 1 | 69583 | 3 | 1.186 | 58670.3 |
298 | 2023-10-25 06:41:04 | hornist | 1 | 69583 | 3 | 1.716 | 40549.5 |
297 | 2023-10-22 08:48:21 | hornist | 2 | 107671 | 24 | 3.453 | 31181.9 |
296 | 2023-10-12 06:08:21 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
295 | 2023-08-30 18:33:47 | hornist | 1 | 69583 | 3 | 1.080 | 64428.7 |
294 | 2023-07-31 19:38:09 | hornist | 2 | 107671 | 24 | 2.843 | 37872.3 |
293 | 2023-07-12 05:17:46 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
292 | 2023-06-01 20:22:46 | hornist | 1 | 69583 | 3 | 1.156 | 60192.9 |
291 | 2023-04-09 07:32:57 | hornist | 2 | 107671 | 24 | 2.796 | 38508.9 |
290 | 2023-03-26 07:08:19 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
289 | 2023-03-24 15:05:15 | hornist | 1 | 69583 | 3 | 1.156 | 60192.9 |
288 | 2023-01-16 18:04:23 | hornist | 2 | 107671 | 24 | 3.126 | 34443.7 |
287 | 2023-01-10 00:22:37 | hornist | 1 | 69583 | 3 | 1.033 | 67360.1 |
286 | 2022-12-06 11:57:16 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
285 | 2022-10-28 21:39:00 | hornist | 2 | 107671 | 24 | 2.813 | 38276.2 |
284 | 2022-10-12 05:32:45 | hornist | 1 | 69583 | 3 | 1.250 | 55666.4 |
283 | 2022-09-12 03:52:26 | hornist | 1 | 69583 | 3 | 1.343 | 51811.6 |
282 | 2022-08-09 12:46:47 | hornist | 1 | 69583 | 3 | 1.080 | 64428.7 |
281 | 2022-07-11 14:05:13 | hornist | 1 | 69583 | 3 | 1.170 | 59472.6 |
280 | 2022-06-26 06:08:06 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
279 | 2022-06-25 03:56:43 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
278 | 2022-05-29 11:41:15 | hornist | 1 | 69583 | 3 | 1.046 | 66522.9 |
277 | 2022-05-23 16:51:16 | hornist | 2 | 107671 | 24 | 2.876 | 37437.8 |
276 | 2022-04-15 09:23:42 | hornist | 1 | 69583 | 3 | 1.266 | 54962.9 |
275 | 2022-02-12 19:04:44 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
274 | 2022-01-18 17:55:19 | hornist | 2 | 107671 | 24 | 3.280 | 32826.5 |
273 | 2021-12-30 14:18:40 | hornist | 1 | 69583 | 3 | 1.266 | 54962.9 |
272 | 2021-12-04 08:23:25 | hornist | 1 | 69583 | 3 | 1.046 | 66522.9 |
271 | 2021-11-10 07:12:14 | hornist | 2 | 107671 | 24 | 2.953 | 36461.6 |
270 | 2021-10-13 19:15:05 | hornist | 1 | 69583 | 3 | 1.076 | 64668.2 |
269 | 2021-09-23 13:08:27 | hornist | 1 | 69583 | 3 | 1.186 | 58670.3 |
268 | 2021-09-22 17:58:20 | hornist | 1 | 69583 | 3 | 1.283 | 54234.6 |
267 | 2021-06-22 17:17:47 | hornist | 2 | 107671 | 24 | 2.890 | 37256.4 |
266 | 2021-06-20 11:32:10 | hornist | 1 | 69583 | 3 | 1.186 | 58670.3 |
265 | 2021-05-21 07:52:16 | hornist | 1 | 69583 | 3 | 1.096 | 63488.1 |
264 | 2021-04-21 19:15:41 | hornist | 1 | 69583 | 3 | 1.076 | 64668.2 |
263 | 2021-04-03 10:57:05 | hornist | 2 | 107671 | 24 | 2.813 | 38276.2 |
262 | 2021-03-24 06:55:10 | hornist | 1 | 69583 | 3 | 1.090 | 63837.6 |
261 | 2021-03-21 14:29:18 | hornist | 1 | 69583 | 3 | 1.096 | 63488.1 |
260 | 2021-03-17 21:50:30 | hornist | 1 | 69583 | 3 | 1.283 | 54234.6 |
259 | 2021-02-21 09:18:29 | hornist | 1 | 69583 | 3 | 1.220 | 57035.2 |
258 | 2021-02-02 14:58:18 | hornist | 1 | 69583 | 3 | 1.203 | 57841.2 |
257 | 2021-01-28 09:00:23 | hornist | 1 | 69583 | 3 | 1.080 | 64428.7 |
256 | 2021-01-18 11:50:50 | hornist | 2 | 107671 | 24 | 2.843 | 37872.3 |
255 | 2020-12-07 14:18:26 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
254 | 2020-11-24 00:13:11 | hornist | 2 | 107671 | 24 | 2.796 | 38508.9 |
253 | 2020-11-11 13:14:00 | hornist | 1 | 69583 | 3 | 1.203 | 57841.2 |
252 | 2020-10-27 21:03:12 | hornist | 1 | 69583 | 3 | 1.076 | 64668.2 |
251 | 2020-10-04 06:29:50 | hornist | 2 | 107671 | 24 | 3.390 | 31761.4 |
250 | 2020-09-22 22:00:06 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
249 | 2020-09-05 03:11:35 | hornist | 1 | 69583 | 3 | 1.063 | 65459.1 |
248 | 2020-08-28 23:58:07 | hornist | 1 | 69583 | 3 | 1.093 | 63662.4 |
247 | 2020-08-25 19:17:37 | hornist | 1 | 69583 | 3 | 1.076 | 64668.2 |
246 | 2020-08-18 05:24:40 | hornist | 2 | 107671 | 24 | 2.920 | 36873.6 |
245 | 2020-08-03 12:11:03 | hornist | 1 | 69583 | 3 | 1.110 | 62687.4 |
244 | 2020-08-02 05:09:22 | hornist | 2 | 107671 | 24 | 3.123 | 34476.8 |
243 | 2020-08-01 05:41:00 | hornist | 2 | 107671 | 24 | 3.266 | 32967.2 |
242 | 2020-07-20 04:09:02 | hornist | 1 | 69583 | 3 | 1.200 | 57985.8 |
241 | 2020-05-24 09:51:39 | hornist | 1 | 69583 | 3 | 1.110 | 62687.4 |
240 | 2020-04-09 16:55:44 | hornist | 1 | 69583 | 3 | 1.206 | 57697.3 |
239 | 2020-03-24 07:19:40 | hornist | 1 | 69583 | 3 | 1.250 | 55666.4 |
238 | 2020-03-20 19:24:17 | hornist | 1 | 69583 | 3 | 1.203 | 57841.2 |
237 | 2020-03-01 07:57:19 | hornist | 1 | 69583 | 3 | 2.000 | 34791.5 |
236 | 2020-02-26 04:10:28 | hornist | 1 | 69583 | 3 | 1.410 | 49349.6 |
235 | 2020-02-21 04:16:48 | hornist | 1 | 69583 | 3 | 1.703 | 40859.1 |
234 | 2020-02-09 09:48:25 | hornist | 1 | 69583 | 3 | 1.283 | 54234.6 |
233 | 2020-02-08 03:01:00 | hornist | 1 | 69583 | 3 | 2.656 | 26198.4 |
232 | 2020-02-05 19:15:55 | hornist | 1 | 69583 | 3 | 1.576 | 44151.6 |
231 | 2020-02-03 01:48:57 | hornist | 1 | 69583 | 3 | 1.343 | 51811.6 |
230 | 2020-01-31 14:29:55 | hornist | 1 | 69583 | 3 | 1.546 | 45008.4 |
229 | 2020-01-31 13:40:15 | hornist | 1 | 69583 | 3 | 1.266 | 54962.9 |
228 | 2020-01-16 13:15:16 | hornist | 1 | 69583 | 3 | 1.203 | 57841.2 |
227 | 2020-01-16 13:14:33 | hornist | 1 | 69583 | 3 | 1.406 | 49490.0 |
226 | 2020-01-12 20:34:23 | hornist | 1 | 69583 | 3 | 1.280 | 54361.7 |