History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shank"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
403 | 2024-04-02 20:50:31 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
402 | 2024-03-31 13:53:37 | shank | 2 | 53800 | 167 | 3.233 | 16640.9 |
401 | 2024-03-31 13:53:29 | shank | 1 | 28756 | 13 | 1.703 | 16885.5 |
400 | 2024-03-31 13:53:18 | shank | 2 | 53800 | 167 | 1.843 | 29191.5 |
399 | 2024-03-31 05:49:57 | shank | 2 | 53800 | 167 | 3.830 | 14047.0 |
398 | 2024-03-31 03:49:35 | shank | 1 | 28756 | 13 | 0.530 | 54256.6 |
397 | 2024-03-27 04:10:08 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
396 | 2024-03-02 14:39:37 | shank | 1 | 28756 | 13 | 1.686 | 17055.8 |
395 | 2024-02-25 22:18:47 | shank | 1 | 28756 | 13 | 0.686 | 41918.4 |
394 | 2024-02-22 21:46:19 | shank | 1 | 28756 | 13 | 0.576 | 49923.6 |
393 | 2024-01-26 21:04:29 | shank | 1 | 28756 | 13 | 0.436 | 65954.1 |
392 | 2023-12-09 09:28:40 | shank | 2 | 53800 | 167 | 1.436 | 37465.2 |
391 | 2023-12-06 22:50:11 | shank | 1 | 28756 | 13 | 0.483 | 59536.2 |
390 | 2023-12-03 17:38:26 | shank | 1 | 28756 | 13 | 1.140 | 25224.6 |
389 | 2023-12-03 08:53:34 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
388 | 2023-12-03 08:53:33 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
387 | 2023-12-02 17:11:03 | shank | 2 | 53800 | 167 | 1.796 | 29955.5 |
386 | 2023-11-19 10:58:07 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
385 | 2023-11-10 02:55:53 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
384 | 2023-10-28 10:40:28 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
383 | 2023-10-23 04:26:12 | shank | 1 | 28756 | 13 | 0.466 | 61708.2 |
382 | 2023-10-18 21:02:39 | shank | 1 | 28756 | 13 | 0.563 | 51076.4 |
381 | 2023-10-11 11:53:53 | shank | 1 | 28756 | 13 | 0.546 | 52666.7 |
380 | 2023-10-06 02:33:11 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
379 | 2023-09-26 15:13:47 | shank | 2 | 53800 | 167 | 1.576 | 34137.1 |
378 | 2023-09-24 19:22:51 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
377 | 2023-09-21 10:54:40 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
376 | 2023-09-19 15:49:31 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
375 | 2023-08-07 13:39:07 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
374 | 2023-07-15 14:18:15 | shank | 1 | 28756 | 13 | 1.076 | 26724.9 |
373 | 2023-04-22 14:37:55 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
372 | 2023-04-20 11:01:34 | shank | 1 | 28756 | 13 | 0.440 | 65354.5 |
371 | 2023-02-08 06:42:42 | shank | 1 | 28756 | 13 | 0.483 | 59536.2 |
370 | 2023-01-02 18:08:22 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
369 | 2022-12-06 05:38:49 | shank | 1 | 28756 | 13 | 0.483 | 59536.2 |
368 | 2022-09-08 09:35:59 | shank | 1 | 28756 | 13 | 0.440 | 65354.5 |
367 | 2022-08-04 23:23:15 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
366 | 2022-08-02 15:09:40 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
365 | 2022-07-15 15:43:09 | shank | 2 | 53800 | 167 | 1.360 | 39558.8 |
364 | 2022-05-02 16:07:21 | shank | 1 | 28756 | 13 | 0.610 | 47141.0 |
363 | 2022-03-25 17:55:43 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
362 | 2022-01-12 03:33:58 | shank | 1 | 28756 | 13 | 0.640 | 44931.3 |
361 | 2022-01-08 21:12:43 | shank | 1 | 28756 | 13 | 0.533 | 53951.2 |
360 | 2021-12-27 10:28:21 | shank | 1 | 28756 | 13 | 0.533 | 53951.2 |
359 | 2021-12-25 07:47:55 | shank | 1 | 28756 | 13 | 0.530 | 54256.6 |
358 | 2021-10-28 02:08:13 | shank | 1 | 28756 | 13 | 0.546 | 52666.7 |
357 | 2021-09-29 12:49:48 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
356 | 2021-09-26 06:29:41 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
355 | 2021-09-14 03:34:12 | shank | 1 | 28756 | 13 | 0.440 | 65354.5 |
354 | 2021-08-27 13:47:35 | shank | 1 | 28756 | 13 | 0.436 | 65954.1 |
353 | 2021-06-23 06:24:43 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
352 | 2021-06-14 03:34:41 | shank | 1 | 28756 | 13 | 1.030 | 27918.4 |
351 | 2021-03-24 08:50:30 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
350 | 2021-03-21 02:33:36 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
349 | 2021-02-26 15:28:43 | shank | 1 | 28756 | 13 | 0.450 | 63902.2 |
348 | 2021-02-24 13:49:07 | shank | 2 | 53800 | 167 | 1.560 | 34487.2 |
347 | 2020-12-18 05:46:55 | shank | 1 | 28756 | 13 | 0.436 | 65954.1 |
346 | 2020-11-14 21:44:32 | shank | 1 | 28756 | 13 | 0.456 | 63061.4 |
345 | 2020-09-14 07:16:53 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
344 | 2020-08-02 06:32:52 | shank | 1 | 28756 | 13 | 0.546 | 52666.7 |
343 | 2020-05-30 02:07:08 | shank | 1 | 28756 | 13 | 0.436 | 65954.1 |
342 | 2020-05-02 21:13:33 | shank | 1 | 28756 | 13 | 0.466 | 61708.2 |
341 | 2020-03-24 23:15:21 | shank | 1 | 28756 | 13 | 0.470 | 61183.0 |
340 | 2020-03-23 10:32:33 | shank | 1 | 28756 | 13 | 0.513 | 56054.6 |
339 | 2020-03-22 20:19:58 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
338 | 2020-03-22 04:51:58 | shank | 1 | 28756 | 13 | 0.530 | 54256.6 |
337 | 2020-03-21 01:20:50 | shank | 1 | 28756 | 13 | 1.063 | 27051.7 |
336 | 2020-03-17 22:58:17 | shank | 1 | 28756 | 13 | 0.580 | 49579.3 |
335 | 2020-02-28 03:38:14 | shank | 1 | 28756 | 13 | 0.533 | 53951.2 |
334 | 2020-02-27 06:27:52 | shank | 1 | 28756 | 13 | 1.173 | 24514.9 |
333 | 2020-02-26 19:56:04 | shank | 1 | 28756 | 13 | 0.530 | 54256.6 |
332 | 2020-02-25 00:50:55 | shank | 1 | 28756 | 13 | 1.050 | 27386.7 |
331 | 2020-02-22 22:13:50 | shank | 1 | 28756 | 13 | 0.563 | 51076.4 |
330 | 2020-02-22 21:18:32 | shank | 1 | 28756 | 13 | 0.610 | 47141.0 |
329 | 2020-02-20 07:17:10 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
328 | 2020-02-14 10:43:56 | shank | 1 | 28756 | 13 | 0.563 | 51076.4 |
327 | 2020-02-10 05:59:04 | shank | 1 | 28756 | 13 | 0.580 | 49579.3 |
326 | 2020-01-30 07:53:51 | shank | 1 | 28756 | 13 | 0.546 | 52666.7 |
325 | 2020-01-30 06:57:45 | shank | 1 | 28756 | 13 | 0.563 | 51076.4 |
324 | 2020-01-29 09:49:22 | shank | 1 | 28756 | 13 | 0.563 | 51076.4 |
323 | 2020-01-24 20:15:26 | shank | 2 | 53800 | 167 | 1.750 | 30742.9 |
322 | 2020-01-24 19:29:28 | shank | 2 | 53800 | 167 | 1.690 | 31834.3 |
321 | 2020-01-24 19:13:02 | shank | 2 | 53800 | 167 | 2.860 | 18811.2 |
320 | 2020-01-24 16:57:09 | shank | 2 | 53800 | 167 | 4.923 | 10928.3 |
319 | 2020-01-24 15:14:19 | shank | 1 | 28756 | 13 | 0.530 | 54256.6 |
318 | 2020-01-24 11:44:08 | shank | 2 | 53800 | 167 | 1.846 | 29144.1 |
317 | 2020-01-24 05:41:53 | shank | 1 | 28756 | 13 | 1.016 | 28303.1 |
316 | 2020-01-21 12:36:47 | shank | 1 | 28756 | 13 | 0.546 | 52666.7 |
315 | 2020-01-11 07:16:06 | shank | 1 | 28756 | 13 | 0.640 | 44931.3 |
314 | 2020-01-10 18:04:37 | shank | 1 | 28756 | 13 | 0.596 | 48248.3 |
313 | 2020-01-08 02:24:05 | shank | 1 | 28756 | 13 | 0.580 | 49579.3 |
312 | 2020-01-03 05:53:53 | shank | 1 | 28756 | 13 | 1.373 | 20943.9 |
311 | 2019-12-30 20:53:33 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
310 | 2019-12-24 17:53:24 | shank | 1 | 28756 | 13 | 0.500 | 57512.0 |
309 | 2019-12-24 17:23:36 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
308 | 2019-12-24 10:20:05 | shank | 1 | 28756 | 13 | 0.516 | 55728.7 |
307 | 2019-12-24 03:18:27 | shank | 1 | 28756 | 13 | 0.440 | 65354.5 |
306 | 2019-11-24 22:11:00 | shank | 1 | 28756 | 13 | 0.440 | 65354.5 |
305 | 2019-11-18 13:36:55 | shank | 1 | 28756 | 13 | 0.453 | 63479.0 |
304 | 2019-10-24 05:17:50 | shank | 1 | 28756 | 13 | 0.513 | 56054.6 |