History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
509 | 2024-04-12 23:52:17 | knots | 1 | 28756 | 8 | 0.516 | 55728.7 |
508 | 2024-04-08 16:40:11 | knots | 1 | 28756 | 8 | 0.546 | 52666.7 |
507 | 2024-04-08 04:28:55 | knots | 1 | 28756 | 8 | 0.766 | 37540.5 |
506 | 2024-04-03 06:29:58 | knots | 2 | 53800 | 124 | 3.643 | 14768.0 |
505 | 2024-04-03 06:22:46 | knots | 1 | 28756 | 8 | 0.516 | 55728.7 |
504 | 2024-03-31 14:59:11 | knots | 1 | 28756 | 8 | 0.483 | 59536.2 |
503 | 2024-03-30 09:06:33 | knots | 2 | 53800 | 124 | 1.796 | 29955.5 |
502 | 2024-03-29 06:37:37 | knots | 2 | 53800 | 124 | 1.780 | 30224.7 |
501 | 2024-03-29 06:37:27 | knots | 1 | 28756 | 8 | 1.093 | 26309.2 |
500 | 2024-03-29 06:37:19 | knots | 2 | 53800 | 124 | 1.796 | 29955.5 |
499 | 2024-03-29 06:37:17 | knots | 1 | 28756 | 8 | 1.033 | 27837.4 |
498 | 2024-03-09 00:26:04 | knots | 1 | 28756 | 8 | 1.080 | 26625.9 |
497 | 2024-03-04 03:53:01 | knots | 2 | 53800 | 124 | 1.296 | 41512.3 |
496 | 2024-03-04 00:44:15 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
495 | 2024-03-01 11:37:48 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
494 | 2024-02-28 02:54:04 | knots | 1 | 28756 | 8 | 0.530 | 54256.6 |
493 | 2024-02-07 14:00:05 | knots | 2 | 53800 | 124 | 2.890 | 18615.9 |
492 | 2024-02-07 14:00:01 | knots | 1 | 28756 | 8 | 0.483 | 59536.2 |
491 | 2024-02-03 00:35:55 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
490 | 2024-01-28 23:27:37 | knots | 1 | 28756 | 8 | 0.486 | 59168.7 |
489 | 2024-01-10 22:59:37 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
488 | 2024-01-08 13:39:36 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
487 | 2024-01-02 19:19:45 | knots | 2 | 53800 | 124 | 1.500 | 35866.7 |
486 | 2024-01-01 05:13:56 | knots | 2 | 53800 | 124 | 1.346 | 39970.3 |
485 | 2023-12-27 06:06:44 | knots | 1 | 28756 | 8 | 0.810 | 35501.2 |
484 | 2023-11-30 04:52:59 | knots | 2 | 53800 | 124 | 1.296 | 41512.3 |
483 | 2023-11-15 15:17:25 | knots | 2 | 53800 | 124 | 1.596 | 33709.3 |
482 | 2023-11-13 23:14:39 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
481 | 2023-11-08 16:45:58 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
480 | 2023-11-03 09:06:51 | knots | 2 | 53800 | 124 | 1.593 | 33772.8 |
479 | 2023-11-03 09:06:47 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
478 | 2023-11-02 07:26:03 | knots | 1 | 28756 | 8 | 1.580 | 18200.0 |
477 | 2023-10-30 21:25:37 | knots | 1 | 28756 | 8 | 0.470 | 61183.0 |
476 | 2023-10-22 02:52:46 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
475 | 2023-10-18 23:50:43 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
474 | 2023-10-15 22:44:54 | knots | 1 | 28756 | 8 | 0.483 | 59536.2 |
473 | 2023-10-14 05:45:07 | knots | 1 | 28756 | 8 | 0.486 | 59168.7 |
472 | 2023-10-06 07:58:47 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
471 | 2023-09-26 03:15:12 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
470 | 2023-09-22 09:21:17 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
469 | 2023-09-14 20:16:26 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
468 | 2023-08-12 07:34:24 | knots | 1 | 28756 | 8 | 0.436 | 65954.1 |
467 | 2023-06-01 00:51:21 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
466 | 2023-05-13 20:46:50 | knots | 1 | 28756 | 8 | 0.920 | 31256.5 |
465 | 2023-03-07 16:38:34 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
464 | 2023-02-19 12:13:40 | knots | 1 | 28756 | 8 | 0.470 | 61183.0 |
463 | 2022-12-29 10:08:56 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
462 | 2022-11-02 09:58:53 | knots | 1 | 28756 | 8 | 0.563 | 51076.4 |
461 | 2022-10-29 19:59:49 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
460 | 2022-09-19 15:35:54 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
459 | 2022-09-15 21:34:53 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
458 | 2022-09-12 08:30:09 | knots | 1 | 28756 | 8 | 0.466 | 61708.2 |
457 | 2022-08-26 02:36:57 | knots | 1 | 28756 | 8 | 0.436 | 65954.1 |
456 | 2022-08-17 14:33:49 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
455 | 2022-08-14 17:11:12 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
454 | 2022-08-12 22:00:14 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
453 | 2022-08-09 07:34:25 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
452 | 2022-08-06 23:44:56 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
451 | 2022-07-30 01:18:22 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
450 | 2022-07-29 01:24:31 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
449 | 2022-07-16 08:29:52 | knots | 1 | 28756 | 8 | 0.450 | 63902.2 |
448 | 2022-07-10 15:27:22 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
447 | 2022-06-25 21:21:29 | knots | 1 | 28756 | 8 | 0.406 | 70827.6 |
446 | 2022-05-29 23:48:18 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
445 | 2022-04-21 00:44:18 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
444 | 2022-04-18 21:20:37 | knots | 1 | 28756 | 8 | 0.590 | 48739.0 |
443 | 2022-03-19 02:05:18 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
442 | 2022-01-10 08:28:01 | knots | 1 | 28756 | 8 | 0.530 | 54256.6 |
441 | 2022-01-08 05:35:58 | knots | 1 | 28756 | 8 | 0.483 | 59536.2 |
440 | 2021-12-08 14:11:07 | knots | 1 | 28756 | 8 | 0.470 | 61183.0 |
439 | 2021-11-04 07:23:15 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
438 | 2021-09-23 19:46:57 | knots | 1 | 28756 | 8 | 0.466 | 61708.2 |
437 | 2021-09-01 04:58:47 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
436 | 2021-08-24 08:41:16 | knots | 1 | 28756 | 8 | 0.420 | 68466.7 |
435 | 2021-08-22 04:38:39 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
434 | 2021-07-22 12:57:39 | knots | 1 | 28756 | 8 | 0.470 | 61183.0 |
433 | 2021-06-05 23:57:18 | knots | 1 | 28756 | 8 | 0.406 | 70827.6 |
432 | 2021-05-31 11:18:24 | knots | 1 | 28756 | 8 | 0.486 | 59168.7 |
431 | 2021-05-12 00:18:16 | knots | 1 | 28756 | 8 | 0.970 | 29645.4 |
430 | 2021-03-01 06:19:51 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
429 | 2021-01-25 00:24:26 | knots | 1 | 28756 | 8 | 0.436 | 65954.1 |
428 | 2021-01-22 14:40:41 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
427 | 2020-12-26 23:18:37 | knots | 1 | 28756 | 8 | 0.436 | 65954.1 |
426 | 2020-12-19 14:24:22 | knots | 1 | 28756 | 8 | 0.470 | 61183.0 |
425 | 2020-11-24 23:03:04 | knots | 1 | 28756 | 8 | 0.453 | 63479.0 |
424 | 2020-11-13 16:39:00 | knots | 1 | 28756 | 8 | 0.470 | 61183.0 |
423 | 2020-09-20 10:35:25 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
422 | 2020-08-22 23:08:21 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
421 | 2020-08-19 18:29:53 | knots | 1 | 28756 | 8 | 0.436 | 65954.1 |
420 | 2020-08-17 08:40:29 | knots | 1 | 28756 | 8 | 0.440 | 65354.5 |
419 | 2020-07-28 06:44:39 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
418 | 2020-06-09 12:26:06 | knots | 1 | 28756 | 8 | 0.516 | 55728.7 |
417 | 2020-05-18 12:39:08 | knots | 1 | 28756 | 8 | 0.436 | 65954.1 |
416 | 2020-03-27 06:36:34 | knots | 1 | 28756 | 8 | 0.483 | 59536.2 |
415 | 2020-03-25 08:11:08 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
414 | 2020-03-24 11:26:54 | knots | 1 | 28756 | 8 | 0.483 | 59536.2 |
413 | 2020-03-23 06:04:04 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
412 | 2020-03-22 17:53:02 | knots | 1 | 28756 | 8 | 0.423 | 67981.1 |
411 | 2020-03-21 12:50:27 | knots | 1 | 28756 | 8 | 0.500 | 57512.0 |
410 | 2020-03-18 02:38:42 | knots | 1 | 28756 | 8 | 0.466 | 61708.2 |