History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violins"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
366 | 2024-03-30 02:11:53 | violins | 1 | 69583 | 2 | 2.766 | 25156.5 |
365 | 2024-03-06 01:08:54 | violins | 1 | 69583 | 2 | 2.466 | 28217.0 |
364 | 2024-02-11 18:15:52 | violins | 1 | 69583 | 2 | 1.313 | 52995.4 |
363 | 2024-02-01 06:20:32 | violins | 3 | 134027 | 359 | 6.876 | 19492.0 |
362 | 2024-01-31 13:49:31 | violins | 2 | 107671 | 26 | 3.233 | 33303.7 |
361 | 2024-01-31 13:49:11 | violins | 3 | 134027 | 359 | 6.376 | 21020.5 |
360 | 2024-01-31 13:46:43 | violins | 2 | 107671 | 26 | 6.843 | 15734.5 |
359 | 2024-01-31 13:41:19 | violins | 3 | 134027 | 359 | 6.530 | 20524.8 |
358 | 2024-01-29 22:51:27 | violins | 3 | 134027 | 359 | 7.580 | 17681.7 |
357 | 2024-01-26 01:21:36 | violins | 1 | 69583 | 2 | 1.126 | 61796.6 |
356 | 2024-01-20 11:58:43 | violins | 1 | 69583 | 2 | 1.046 | 66522.9 |
355 | 2024-01-14 17:44:39 | violins | 2 | 107671 | 26 | 3.483 | 30913.3 |
354 | 2024-01-03 18:50:50 | violins | 2 | 107671 | 26 | 2.940 | 36622.8 |
353 | 2023-12-27 20:58:57 | violins | 3 | 134027 | 359 | 6.970 | 19229.1 |
352 | 2023-12-27 20:58:58 | violins | 2 | 107671 | 26 | 3.373 | 31921.4 |
351 | 2023-12-25 03:27:59 | violins | 1 | 69583 | 2 | 1.060 | 65644.3 |
350 | 2023-12-23 00:51:05 | violins | 1 | 69583 | 2 | 1.143 | 60877.5 |
349 | 2023-12-07 03:05:31 | violins | 3 | 134027 | 359 | 9.720 | 13788.8 |
348 | 2023-11-16 07:01:01 | violins | 1 | 69583 | 2 | 1.013 | 68690.0 |
347 | 2023-11-15 23:35:07 | violins | 3 | 134027 | 359 | 6.843 | 19586.0 |
346 | 2023-11-14 08:49:59 | violins | 3 | 134027 | 359 | 5.703 | 23501.1 |
345 | 2023-11-07 19:35:14 | violins | 3 | 134027 | 359 | 6.346 | 21119.9 |
344 | 2023-10-30 08:25:53 | violins | 1 | 69583 | 2 | 1.343 | 51811.6 |
343 | 2023-10-26 02:30:44 | violins | 1 | 69583 | 2 | 1.156 | 60192.9 |
342 | 2023-10-25 05:05:32 | violins | 1 | 69583 | 2 | 1.343 | 51811.6 |
341 | 2023-10-13 23:11:56 | violins | 1 | 69583 | 2 | 1.030 | 67556.3 |
340 | 2023-10-09 17:06:28 | violins | 2 | 107671 | 26 | 4.670 | 23055.9 |
339 | 2023-10-07 13:31:04 | violins | 1 | 69583 | 2 | 1.186 | 58670.3 |
338 | 2023-09-29 00:20:52 | violins | 1 | 69583 | 2 | 1.216 | 57222.9 |
337 | 2023-09-22 15:46:29 | violins | 1 | 69583 | 2 | 1.093 | 63662.4 |
336 | 2023-09-03 12:38:04 | violins | 1 | 69583 | 2 | 1.173 | 59320.5 |
335 | 2023-08-11 20:12:36 | violins | 3 | 134027 | 359 | 6.703 | 19995.1 |
334 | 2023-07-19 23:27:26 | violins | 2 | 107671 | 26 | 2.856 | 37699.9 |
333 | 2023-05-18 16:08:49 | violins | 1 | 69583 | 2 | 1.030 | 67556.3 |
332 | 2023-04-27 00:01:57 | violins | 3 | 134027 | 359 | 6.093 | 21996.9 |
331 | 2023-04-22 17:31:43 | violins | 3 | 134027 | 359 | 5.546 | 24166.4 |
330 | 2023-04-03 08:10:06 | violins | 2 | 107671 | 26 | 3.483 | 30913.3 |
329 | 2023-03-31 09:53:38 | violins | 1 | 69583 | 2 | 1.063 | 65459.1 |
328 | 2023-02-07 13:15:35 | violins | 1 | 69583 | 2 | 1.093 | 63662.4 |
327 | 2023-02-03 00:06:15 | violins | 1 | 69583 | 2 | 1.016 | 68487.2 |
326 | 2023-01-26 00:49:54 | violins | 3 | 134027 | 359 | 6.436 | 20824.6 |
325 | 2023-01-18 09:10:12 | violins | 1 | 69583 | 2 | 1.000 | 69583.0 |
324 | 2023-01-02 11:02:51 | violins | 2 | 107671 | 26 | 2.813 | 38276.2 |
323 | 2022-12-22 01:20:00 | violins | 1 | 69583 | 2 | 1.110 | 62687.4 |
322 | 2022-12-02 05:56:11 | violins | 1 | 69583 | 2 | 1.170 | 59472.6 |
321 | 2022-11-13 20:31:41 | violins | 1 | 69583 | 2 | 1.140 | 61037.7 |
320 | 2022-11-07 02:41:21 | violins | 3 | 134027 | 359 | 5.953 | 22514.2 |
319 | 2022-09-08 18:02:49 | violins | 2 | 107671 | 26 | 3.050 | 35302.0 |
318 | 2022-09-05 13:16:33 | violins | 1 | 69583 | 2 | 1.030 | 67556.3 |
317 | 2022-07-28 00:17:21 | violins | 1 | 69583 | 2 | 1.046 | 66522.9 |
316 | 2022-05-03 15:37:54 | violins | 3 | 134027 | 359 | 6.970 | 19229.1 |
315 | 2022-04-08 15:00:54 | violins | 1 | 69583 | 2 | 1.296 | 53690.6 |
314 | 2022-03-24 20:07:39 | violins | 1 | 69583 | 2 | 2.123 | 32775.8 |
313 | 2022-03-22 16:14:58 | violins | 1 | 69583 | 2 | 1.186 | 58670.3 |
312 | 2022-01-09 19:07:20 | violins | 3 | 134027 | 359 | 7.563 | 17721.4 |
311 | 2022-01-08 06:55:58 | violins | 1 | 69583 | 2 | 1.296 | 53690.6 |
310 | 2021-11-28 09:18:42 | violins | 1 | 69583 | 2 | 1.076 | 64668.2 |
309 | 2021-11-25 01:44:54 | violins | 1 | 69583 | 2 | 1.030 | 67556.3 |
308 | 2021-09-27 11:27:53 | violins | 1 | 69583 | 2 | 2.420 | 28753.3 |
307 | 2021-09-26 18:59:54 | violins | 1 | 69583 | 2 | 1.186 | 58670.3 |
306 | 2021-09-21 23:10:05 | violins | 1 | 69583 | 2 | 1.046 | 66522.9 |
305 | 2021-07-29 06:14:20 | violins | 1 | 69583 | 2 | 1.173 | 59320.5 |
304 | 2021-07-17 15:36:49 | violins | 1 | 69583 | 2 | 1.076 | 64668.2 |
303 | 2021-05-11 14:19:19 | violins | 1 | 69583 | 2 | 1.170 | 59472.6 |
302 | 2021-05-06 20:23:16 | violins | 1 | 69583 | 2 | 1.173 | 59320.5 |
301 | 2021-04-05 03:18:25 | violins | 1 | 69583 | 2 | 2.470 | 28171.3 |
300 | 2021-03-18 18:35:14 | violins | 2 | 107671 | 26 | 2.920 | 36873.6 |
299 | 2021-02-25 23:55:58 | violins | 3 | 134027 | 359 | 8.736 | 15341.9 |
298 | 2021-02-24 09:06:05 | violins | 1 | 69583 | 2 | 1.063 | 65459.1 |
297 | 2021-02-21 20:23:56 | violins | 1 | 69583 | 2 | 1.220 | 57035.2 |
296 | 2021-01-20 11:04:20 | violins | 1 | 69583 | 2 | 1.063 | 65459.1 |
295 | 2020-12-30 22:47:00 | violins | 2 | 107671 | 26 | 2.736 | 39353.4 |
294 | 2020-11-25 10:17:35 | violins | 1 | 69583 | 2 | 1.063 | 65459.1 |
293 | 2020-11-09 01:42:11 | violins | 2 | 107671 | 26 | 2.843 | 37872.3 |
292 | 2020-11-05 10:38:46 | violins | 1 | 69583 | 2 | 1.173 | 59320.5 |
291 | 2020-10-18 03:10:34 | violins | 1 | 69583 | 2 | 1.156 | 60192.9 |
290 | 2020-10-17 23:05:35 | violins | 1 | 69583 | 2 | 1.030 | 67556.3 |
289 | 2020-10-12 23:47:11 | violins | 1 | 69583 | 2 | 1.063 | 65459.1 |
288 | 2020-08-02 06:13:02 | violins | 1 | 69583 | 2 | 1.110 | 62687.4 |
287 | 2020-07-22 18:40:19 | violins | 1 | 69583 | 2 | 1.063 | 65459.1 |
286 | 2020-03-24 07:29:27 | violins | 1 | 69583 | 2 | 1.173 | 59320.5 |
285 | 2020-03-21 12:10:58 | violins | 1 | 69583 | 2 | 1.080 | 64428.7 |
284 | 2020-02-18 14:16:09 | violins | 1 | 69583 | 2 | 1.046 | 66522.9 |
283 | 2020-02-13 07:05:11 | violins | 1 | 69583 | 2 | 1.220 | 57035.2 |
282 | 2020-02-12 14:28:04 | violins | 1 | 69583 | 2 | 1.186 | 58670.3 |
281 | 2020-02-10 18:15:06 | violins | 1 | 69583 | 2 | 1.343 | 51811.6 |
280 | 2020-02-08 20:17:59 | violins | 1 | 69583 | 2 | 1.266 | 54962.9 |
279 | 2020-02-05 15:08:15 | violins | 1 | 69583 | 2 | 1.360 | 51164.0 |
278 | 2020-01-31 11:23:18 | violins | 1 | 69583 | 2 | 1.296 | 53690.6 |
277 | 2020-01-24 18:15:56 | violins | 1 | 69583 | 2 | 4.016 | 17326.4 |
276 | 2020-01-20 12:38:36 | violins | 1 | 69583 | 2 | 1.343 | 51811.6 |
275 | 2020-01-19 14:14:59 | violins | 1 | 69583 | 2 | 2.716 | 25619.7 |
274 | 2020-01-18 03:19:19 | violins | 1 | 69583 | 2 | 1.453 | 47889.2 |
273 | 2020-01-14 08:27:27 | violins | 1 | 69583 | 2 | 4.046 | 17198.0 |
272 | 2020-01-01 14:03:17 | violins | 1 | 69583 | 2 | 1.300 | 53525.4 |
271 | 2019-12-28 23:53:12 | violins | 1 | 69583 | 2 | 1.110 | 62687.4 |
270 | 2019-12-28 21:39:39 | violins | 1 | 69583 | 2 | 1.233 | 56433.9 |
269 | 2019-12-28 05:16:45 | violins | 1 | 69583 | 2 | 2.436 | 28564.4 |
268 | 2019-11-12 12:10:47 | violins | 1 | 69583 | 2 | 1.186 | 58670.3 |
267 | 2019-11-09 07:53:24 | violins | 3 | 134027 | 359 | 6.456 | 20760.1 |