History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violin"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
358 | 2024-05-05 19:34:05 | violin | 3 | 112716 | 370 | 6.313 | 17854.6 |
357 | 2024-05-03 01:00:07 | violin | 3 | 112716 | 370 | 7.233 | 15583.6 |
356 | 2024-05-02 05:14:44 | violin | 2 | 82551 | 26 | 2.593 | 31836.1 |
355 | 2024-05-02 05:14:22 | violin | 3 | 112716 | 370 | 8.093 | 13927.6 |
354 | 2024-04-22 16:36:22 | violin | 2 | 82551 | 26 | 3.173 | 26016.7 |
353 | 2024-04-22 16:36:03 | violin | 3 | 112716 | 370 | 6.296 | 17902.8 |
352 | 2024-04-21 07:30:01 | violin | 2 | 82551 | 26 | 3.250 | 25400.3 |
351 | 2024-04-20 21:20:26 | violin | 3 | 112716 | 370 | 18.046 | 6246.0 |
350 | 2024-04-20 15:01:59 | violin | 2 | 82551 | 26 | 3.013 | 27398.3 |
349 | 2024-04-20 15:01:31 | violin | 3 | 112716 | 370 | 7.376 | 15281.5 |
348 | 2024-04-19 09:49:16 | violin | 2 | 82551 | 26 | 2.516 | 32810.4 |
347 | 2024-04-19 09:48:48 | violin | 3 | 112716 | 370 | 5.453 | 20670.5 |
346 | 2024-04-18 18:52:09 | violin | 3 | 112716 | 370 | 10.736 | 10498.9 |
345 | 2024-04-06 13:24:41 | violin | 1 | 48755 | 2 | 2.986 | 16327.9 |
344 | 2024-03-31 02:01:42 | violin | 1 | 48755 | 2 | 0.716 | 68093.6 |
343 | 2024-03-01 04:27:44 | violin | 2 | 82551 | 26 | 2.533 | 32590.2 |
342 | 2024-03-01 04:20:41 | violin | 3 | 112716 | 370 | 8.860 | 12721.9 |
341 | 2024-02-27 17:42:32 | violin | 2 | 82551 | 26 | 2.390 | 34540.2 |
340 | 2024-02-27 17:42:15 | violin | 3 | 112716 | 370 | 5.686 | 19823.4 |
339 | 2024-02-25 21:17:38 | violin | 1 | 48755 | 2 | 1.813 | 26891.9 |
338 | 2024-02-24 06:59:03 | violin | 3 | 112716 | 370 | 4.813 | 23419.1 |
337 | 2024-01-31 05:27:36 | violin | 2 | 82551 | 26 | 2.076 | 39764.5 |
336 | 2024-01-31 05:26:12 | violin | 3 | 112716 | 370 | 6.093 | 18499.3 |
335 | 2024-01-28 13:50:47 | violin | 3 | 112716 | 370 | 4.640 | 24292.2 |
334 | 2024-01-28 11:13:31 | violin | 3 | 112716 | 370 | 5.576 | 20214.5 |
333 | 2024-01-23 12:45:16 | violin | 1 | 48755 | 2 | 0.906 | 53813.5 |
332 | 2024-01-15 22:49:07 | violin | 2 | 82551 | 26 | 2.563 | 32208.7 |
331 | 2024-01-10 16:51:09 | violin | 2 | 82551 | 26 | 2.280 | 36206.6 |
330 | 2024-01-03 17:08:44 | violin | 2 | 82551 | 26 | 2.610 | 31628.7 |
329 | 2023-12-24 11:42:47 | violin | 3 | 112716 | 370 | 5.313 | 21215.1 |
328 | 2023-12-22 16:06:54 | violin | 1 | 48755 | 2 | 0.830 | 58741.0 |
327 | 2023-12-11 02:48:04 | violin | 3 | 112716 | 370 | 6.470 | 17421.3 |
326 | 2023-12-08 23:01:09 | violin | 3 | 112716 | 370 | 5.280 | 21347.7 |
325 | 2023-12-04 02:01:38 | violin | 3 | 112716 | 370 | 5.513 | 20445.5 |
324 | 2023-11-17 15:10:57 | violin | 1 | 48755 | 2 | 0.716 | 68093.6 |
323 | 2023-11-14 03:46:44 | violin | 1 | 48755 | 2 | 1.690 | 28849.1 |
322 | 2023-11-10 22:52:29 | violin | 3 | 112716 | 370 | 4.606 | 24471.6 |
321 | 2023-11-10 22:47:08 | violin | 3 | 112716 | 370 | 4.656 | 24208.8 |
320 | 2023-11-04 19:22:47 | violin | 1 | 48755 | 2 | 2.783 | 17518.9 |
319 | 2023-11-01 22:02:24 | violin | 2 | 82551 | 26 | 2.813 | 29346.2 |
318 | 2023-10-20 13:09:49 | violin | 2 | 82551 | 26 | 2.343 | 35233.0 |
317 | 2023-10-20 07:09:59 | violin | 1 | 48755 | 2 | 0.843 | 57835.1 |
316 | 2023-10-19 00:27:13 | violin | 1 | 48755 | 2 | 0.860 | 56691.9 |
315 | 2023-10-11 22:15:51 | violin | 1 | 48755 | 2 | 0.843 | 57835.1 |
314 | 2023-10-10 07:23:43 | violin | 1 | 48755 | 2 | 0.830 | 58741.0 |
313 | 2023-10-08 20:28:16 | violin | 1 | 48755 | 2 | 0.796 | 61250.0 |
312 | 2023-10-01 08:07:26 | violin | 2 | 82551 | 26 | 2.110 | 39123.7 |
311 | 2023-09-29 23:34:31 | violin | 3 | 112716 | 370 | 4.983 | 22620.1 |
310 | 2023-09-29 09:49:09 | violin | 1 | 48755 | 2 | 0.766 | 63648.8 |
309 | 2023-09-29 07:51:52 | violin | 1 | 48755 | 2 | 0.813 | 59969.2 |
308 | 2023-09-24 17:37:17 | violin | 3 | 112716 | 370 | 4.810 | 23433.7 |
307 | 2023-09-12 16:41:45 | violin | 1 | 48755 | 2 | 0.860 | 56691.9 |
306 | 2023-08-22 22:15:42 | violin | 3 | 112716 | 370 | 4.720 | 23880.5 |
305 | 2023-08-06 00:21:54 | violin | 1 | 48755 | 2 | 0.750 | 65006.7 |
304 | 2023-07-31 21:28:10 | violin | 2 | 82551 | 26 | 4.186 | 19720.7 |
303 | 2023-07-05 18:53:13 | violin | 3 | 112716 | 370 | 4.593 | 24540.8 |
302 | 2023-06-23 06:10:41 | violin | 3 | 112716 | 370 | 5.203 | 21663.7 |
301 | 2023-05-13 08:39:29 | violin | 1 | 48755 | 2 | 0.780 | 62506.4 |
300 | 2023-05-09 17:14:26 | violin | 1 | 48755 | 2 | 0.733 | 66514.3 |
299 | 2023-05-02 04:59:16 | violin | 1 | 48755 | 2 | 0.750 | 65006.7 |
298 | 2023-04-11 08:32:06 | violin | 2 | 82551 | 26 | 2.203 | 37472.1 |
297 | 2023-03-28 05:36:32 | violin | 3 | 112716 | 370 | 4.826 | 23356.0 |
296 | 2023-02-24 22:05:12 | violin | 1 | 48755 | 2 | 0.703 | 69352.8 |
295 | 2023-02-15 23:03:38 | violin | 3 | 112716 | 370 | 5.406 | 20850.2 |
294 | 2023-02-02 20:44:01 | violin | 1 | 48755 | 2 | 0.813 | 59969.2 |
293 | 2023-01-19 10:46:39 | violin | 2 | 82551 | 26 | 2.033 | 40605.5 |
292 | 2022-12-27 12:25:27 | violin | 3 | 112716 | 370 | 4.826 | 23356.0 |
291 | 2022-12-27 07:07:36 | violin | 3 | 112716 | 370 | 5.186 | 21734.7 |
290 | 2022-12-25 03:08:32 | violin | 1 | 48755 | 2 | 0.703 | 69352.8 |
289 | 2022-12-25 01:37:04 | violin | 1 | 48755 | 2 | 0.783 | 62266.9 |
288 | 2022-12-17 22:31:07 | violin | 1 | 48755 | 2 | 0.843 | 57835.1 |
287 | 2022-12-09 21:08:47 | violin | 3 | 112716 | 370 | 4.470 | 25216.1 |
286 | 2022-11-19 15:03:38 | violin | 3 | 112716 | 370 | 5.220 | 21593.1 |
285 | 2022-11-18 09:31:45 | violin | 3 | 112716 | 370 | 5.373 | 20978.2 |
284 | 2022-11-16 00:16:01 | violin | 3 | 112716 | 370 | 4.890 | 23050.3 |
283 | 2022-11-13 17:50:14 | violin | 1 | 48755 | 2 | 1.420 | 34334.5 |
282 | 2022-11-13 05:15:13 | violin | 1 | 48755 | 2 | 0.720 | 67715.3 |
281 | 2022-11-11 02:00:05 | violin | 3 | 112716 | 370 | 4.593 | 24540.8 |
280 | 2022-10-30 14:14:49 | violin | 2 | 82551 | 26 | 2.343 | 35233.0 |
279 | 2022-10-03 23:40:26 | violin | 3 | 112716 | 370 | 4.483 | 25143.0 |
278 | 2022-09-13 00:16:28 | violin | 1 | 48755 | 2 | 0.736 | 66243.2 |
277 | 2022-08-29 02:52:45 | violin | 3 | 112716 | 370 | 4.513 | 24975.8 |
276 | 2022-08-25 20:25:22 | violin | 3 | 112716 | 370 | 5.170 | 21801.9 |
275 | 2022-08-15 09:53:33 | violin | 1 | 48755 | 2 | 0.813 | 59969.2 |
274 | 2022-08-14 02:41:27 | violin | 1 | 48755 | 2 | 0.733 | 66514.3 |
273 | 2022-08-01 08:15:23 | violin | 1 | 48755 | 2 | 0.750 | 65006.7 |
272 | 2022-07-28 20:32:33 | violin | 1 | 48755 | 2 | 0.733 | 66514.3 |
271 | 2022-07-17 20:59:16 | violin | 1 | 48755 | 2 | 0.720 | 67715.3 |
270 | 2022-06-22 00:05:05 | violin | 3 | 112716 | 370 | 5.093 | 22131.6 |
269 | 2022-06-11 16:21:16 | violin | 1 | 48755 | 2 | 0.826 | 59025.4 |
268 | 2022-05-22 00:26:01 | violin | 2 | 82551 | 26 | 2.110 | 39123.7 |
267 | 2022-05-12 14:10:59 | violin | 3 | 112716 | 370 | 6.093 | 18499.3 |
266 | 2022-05-08 23:52:42 | violin | 3 | 112716 | 370 | 4.546 | 24794.5 |
265 | 2022-04-15 14:03:30 | violin | 3 | 112716 | 370 | 5.690 | 19809.5 |
264 | 2022-03-19 18:16:50 | violin | 1 | 48755 | 2 | 0.700 | 69650.0 |
263 | 2022-03-13 17:58:40 | violin | 1 | 48755 | 2 | 0.750 | 65006.7 |
262 | 2022-01-13 21:01:13 | violin | 1 | 48755 | 2 | 0.720 | 67715.3 |
261 | 2021-11-11 11:34:23 | violin | 1 | 48755 | 2 | 0.796 | 61250.0 |
260 | 2021-11-03 04:18:25 | violin | 1 | 48755 | 2 | 0.813 | 59969.2 |
259 | 2021-07-17 01:31:27 | violin | 1 | 48755 | 2 | 0.733 | 66514.3 |