History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knoll"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
444 | 2024-04-26 09:15:33 | knoll | 2 | 53800 | 52 | 3.513 | 15314.5 |
443 | 2024-04-25 13:50:23 | knoll | 1 | 28756 | 4 | 0.500 | 57512.0 |
442 | 2024-04-24 23:20:17 | knoll | 3 | 83667 | 576 | 5.436 | 15391.3 |
441 | 2024-04-08 16:40:22 | knoll | 1 | 28756 | 4 | 1.720 | 16718.6 |
440 | 2024-04-04 20:04:14 | knoll | 3 | 83667 | 576 | 14.516 | 5763.8 |
439 | 2024-04-03 15:41:22 | knoll | 2 | 53800 | 52 | 5.423 | 9920.7 |
438 | 2024-04-03 15:41:01 | knoll | 1 | 28756 | 4 | 2.220 | 12953.2 |
437 | 2024-04-03 15:40:51 | knoll | 3 | 83667 | 576 | 11.843 | 7064.7 |
436 | 2024-04-03 15:40:49 | knoll | 2 | 53800 | 52 | 3.860 | 13937.8 |
435 | 2024-04-03 15:40:45 | knoll | 1 | 28756 | 4 | 1.923 | 14953.7 |
434 | 2024-03-31 15:13:20 | knoll | 1 | 28756 | 4 | 0.483 | 59536.2 |
433 | 2024-03-29 09:25:50 | knoll | 1 | 28756 | 4 | 0.513 | 56054.6 |
432 | 2024-03-15 15:58:50 | knoll | 3 | 83667 | 576 | 4.470 | 18717.4 |
431 | 2024-03-08 17:31:19 | knoll | 1 | 28756 | 4 | 1.656 | 17364.7 |
430 | 2024-03-04 07:46:38 | knoll | 3 | 83667 | 576 | 7.406 | 11297.2 |
429 | 2024-03-04 07:46:37 | knoll | 2 | 53800 | 52 | 3.826 | 14061.7 |
428 | 2024-03-04 07:46:34 | knoll | 1 | 28756 | 4 | 1.063 | 27051.7 |
427 | 2024-03-01 11:58:19 | knoll | 1 | 28756 | 4 | 0.466 | 61708.2 |
426 | 2024-02-28 02:53:43 | knoll | 3 | 83667 | 576 | 6.953 | 12033.2 |
425 | 2024-02-28 02:53:41 | knoll | 2 | 53800 | 52 | 2.126 | 25305.7 |
424 | 2024-02-28 02:53:40 | knoll | 1 | 28756 | 4 | 1.030 | 27918.4 |
423 | 2024-02-07 04:49:06 | knoll | 3 | 83667 | 576 | 7.283 | 11488.0 |
422 | 2024-02-07 04:49:01 | knoll | 2 | 53800 | 52 | 1.720 | 31279.1 |
421 | 2024-02-07 04:48:57 | knoll | 1 | 28756 | 4 | 0.483 | 59536.2 |
420 | 2024-02-03 02:53:55 | knoll | 1 | 28756 | 4 | 0.470 | 61183.0 |
419 | 2024-01-31 11:13:01 | knoll | 1 | 28756 | 4 | 0.500 | 57512.0 |
418 | 2024-01-29 04:38:27 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
417 | 2024-01-28 23:39:53 | knoll | 1 | 28756 | 4 | 0.500 | 57512.0 |
416 | 2024-01-14 04:03:52 | knoll | 2 | 53800 | 52 | 1.533 | 35094.6 |
415 | 2024-01-08 09:43:55 | knoll | 3 | 83667 | 576 | 3.936 | 21256.9 |
414 | 2024-01-08 04:44:42 | knoll | 1 | 28756 | 4 | 0.483 | 59536.2 |
413 | 2024-01-02 07:54:51 | knoll | 1 | 28756 | 4 | 0.470 | 61183.0 |
412 | 2023-12-18 17:47:42 | knoll | 2 | 53800 | 52 | 1.470 | 36598.6 |
411 | 2023-11-28 02:04:25 | knoll | 1 | 28756 | 4 | 0.420 | 68466.7 |
410 | 2023-11-25 19:51:00 | knoll | 3 | 83667 | 576 | 3.656 | 22884.8 |
409 | 2023-11-18 06:12:40 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
408 | 2023-11-15 14:35:22 | knoll | 3 | 83667 | 576 | 3.373 | 24804.9 |
407 | 2023-11-15 14:35:16 | knoll | 2 | 53800 | 52 | 1.296 | 41512.3 |
406 | 2023-11-08 16:45:29 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
405 | 2023-11-07 00:10:14 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
404 | 2023-10-28 11:09:09 | knoll | 1 | 28756 | 4 | 0.546 | 52666.7 |
403 | 2023-10-23 00:38:37 | knoll | 1 | 28756 | 4 | 0.470 | 61183.0 |
402 | 2023-10-13 18:00:54 | knoll | 1 | 28756 | 4 | 0.456 | 63061.4 |
401 | 2023-10-08 05:12:28 | knoll | 1 | 28756 | 4 | 0.420 | 68466.7 |
400 | 2023-09-28 23:40:33 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
399 | 2023-09-22 05:56:24 | knoll | 1 | 28756 | 4 | 0.423 | 67981.1 |
398 | 2023-09-17 23:19:37 | knoll | 2 | 53800 | 52 | 1.313 | 40974.9 |
397 | 2023-09-14 06:19:49 | knoll | 1 | 28756 | 4 | 0.440 | 65354.5 |
396 | 2023-08-24 22:13:29 | knoll | 3 | 83667 | 576 | 3.530 | 23701.7 |
395 | 2023-08-13 05:43:27 | knoll | 3 | 83667 | 576 | 3.500 | 23904.9 |
394 | 2023-06-20 22:21:53 | knoll | 2 | 53800 | 52 | 1.346 | 39970.3 |
393 | 2023-06-15 11:03:28 | knoll | 1 | 28756 | 4 | 0.953 | 30174.2 |
392 | 2023-05-26 04:56:02 | knoll | 2 | 53800 | 52 | 1.280 | 42031.3 |
391 | 2023-05-07 20:20:38 | knoll | 3 | 83667 | 576 | 3.190 | 26227.9 |
390 | 2023-04-29 12:49:34 | knoll | 1 | 28756 | 4 | 0.466 | 61708.2 |
389 | 2023-04-16 11:38:51 | knoll | 2 | 53800 | 52 | 1.436 | 37465.2 |
388 | 2023-04-01 06:17:52 | knoll | 1 | 28756 | 4 | 0.420 | 68466.7 |
387 | 2023-03-19 01:56:11 | knoll | 2 | 53800 | 52 | 1.436 | 37465.2 |
386 | 2023-02-13 10:04:19 | knoll | 3 | 83667 | 576 | 3.063 | 27315.4 |
385 | 2023-01-16 01:12:42 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
384 | 2023-01-15 17:20:26 | knoll | 3 | 83667 | 576 | 3.686 | 22698.6 |
383 | 2023-01-02 07:08:34 | knoll | 1 | 28756 | 4 | 0.406 | 70827.6 |
382 | 2023-01-01 04:18:05 | knoll | 3 | 83667 | 576 | 3.076 | 27199.9 |
381 | 2022-12-23 08:33:27 | knoll | 3 | 83667 | 576 | 3.530 | 23701.7 |
380 | 2022-12-21 02:29:00 | knoll | 2 | 53800 | 52 | 1.466 | 36698.5 |
379 | 2022-11-24 21:34:06 | knoll | 3 | 83667 | 576 | 3.140 | 26645.5 |
378 | 2022-11-07 10:14:36 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
377 | 2022-09-04 12:07:25 | knoll | 1 | 28756 | 4 | 0.470 | 61183.0 |
376 | 2022-08-14 17:12:49 | knoll | 2 | 53800 | 52 | 1.310 | 41068.7 |
375 | 2022-08-07 15:07:46 | knoll | 1 | 28756 | 4 | 0.423 | 67981.1 |
374 | 2022-07-18 08:05:54 | knoll | 1 | 28756 | 4 | 0.436 | 65954.1 |
373 | 2022-06-27 11:12:28 | knoll | 1 | 28756 | 4 | 0.406 | 70827.6 |
372 | 2022-06-17 15:51:06 | knoll | 3 | 83667 | 576 | 3.610 | 23176.5 |
371 | 2022-05-06 22:24:48 | knoll | 3 | 83667 | 576 | 3.873 | 21602.6 |
370 | 2022-04-28 15:32:35 | knoll | 1 | 28756 | 4 | 0.483 | 59536.2 |
369 | 2022-04-24 14:29:52 | knoll | 3 | 83667 | 576 | 3.110 | 26902.6 |
368 | 2022-04-22 08:21:09 | knoll | 3 | 83667 | 576 | 3.640 | 22985.4 |
367 | 2022-04-06 13:08:28 | knoll | 3 | 83667 | 576 | 3.673 | 22778.9 |
366 | 2022-03-19 18:50:26 | knoll | 1 | 28756 | 4 | 0.406 | 70827.6 |
365 | 2022-03-18 23:08:24 | knoll | 1 | 28756 | 4 | 0.420 | 68466.7 |
364 | 2022-03-17 13:18:31 | knoll | 1 | 28756 | 4 | 0.910 | 31600.0 |
363 | 2022-03-16 15:51:34 | knoll | 1 | 28756 | 4 | 0.516 | 55728.7 |
362 | 2022-03-05 23:11:42 | knoll | 1 | 28756 | 4 | 0.423 | 67981.1 |
361 | 2022-03-02 11:51:26 | knoll | 1 | 28756 | 4 | 0.516 | 55728.7 |
360 | 2022-01-05 06:10:59 | knoll | 1 | 28756 | 4 | 1.016 | 28303.1 |
359 | 2021-12-27 16:50:08 | knoll | 3 | 83667 | 576 | 3.780 | 22134.1 |
358 | 2021-12-17 05:14:20 | knoll | 1 | 28756 | 4 | 0.436 | 65954.1 |
357 | 2021-11-02 19:06:12 | knoll | 1 | 28756 | 4 | 0.436 | 65954.1 |
356 | 2021-11-01 22:30:09 | knoll | 1 | 28756 | 4 | 0.936 | 30722.2 |
355 | 2021-11-01 14:43:14 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
354 | 2021-10-26 08:41:27 | knoll | 1 | 28756 | 4 | 0.440 | 65354.5 |
353 | 2021-10-02 00:56:44 | knoll | 1 | 28756 | 4 | 0.500 | 57512.0 |
352 | 2021-10-01 05:39:09 | knoll | 1 | 28756 | 4 | 0.423 | 67981.1 |
351 | 2021-09-30 18:06:35 | knoll | 1 | 28756 | 4 | 0.500 | 57512.0 |
350 | 2021-09-30 09:43:40 | knoll | 1 | 28756 | 4 | 0.466 | 61708.2 |
349 | 2021-09-29 20:45:13 | knoll | 1 | 28756 | 4 | 0.516 | 55728.7 |
348 | 2021-09-29 10:58:36 | knoll | 1 | 28756 | 4 | 0.500 | 57512.0 |
347 | 2021-09-29 10:34:49 | knoll | 1 | 28756 | 4 | 0.516 | 55728.7 |
346 | 2021-09-28 22:36:42 | knoll | 1 | 28756 | 4 | 0.453 | 63479.0 |
345 | 2021-09-28 13:40:19 | knoll | 1 | 28756 | 4 | 0.500 | 57512.0 |