History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knows"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
669 | 2024-04-03 06:30:08 | knows | 2 | 53800 | 101 | 5.376 | 10007.4 |
668 | 2024-04-03 06:22:27 | knows | 1 | 28756 | 10 | 2.186 | 13154.6 |
667 | 2024-03-31 14:59:01 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
666 | 2024-03-29 07:12:24 | knows | 1 | 28756 | 10 | 1.063 | 27051.7 |
665 | 2024-03-29 07:12:09 | knows | 2 | 53800 | 101 | 5.453 | 9866.1 |
664 | 2024-03-28 18:48:25 | knows | 2 | 53800 | 101 | 5.153 | 10440.5 |
663 | 2024-03-28 18:17:43 | knows | 1 | 28756 | 10 | 0.530 | 54256.6 |
662 | 2024-03-04 03:52:36 | knows | 2 | 53800 | 101 | 1.720 | 31279.1 |
661 | 2024-03-04 00:44:36 | knows | 1 | 28756 | 10 | 0.486 | 59168.7 |
660 | 2024-03-01 11:38:06 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
659 | 2024-02-26 19:08:46 | knows | 1 | 28756 | 10 | 1.063 | 27051.7 |
658 | 2024-02-04 00:57:55 | knows | 1 | 28756 | 10 | 0.470 | 61183.0 |
657 | 2024-02-03 00:36:11 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
656 | 2023-12-30 16:54:45 | knows | 2 | 53800 | 101 | 1.453 | 37026.8 |
655 | 2023-12-15 13:38:34 | knows | 2 | 53800 | 101 | 1.406 | 38264.6 |
654 | 2023-11-26 11:21:28 | knows | 2 | 53800 | 101 | 1.326 | 40573.2 |
653 | 2023-11-26 01:44:35 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
652 | 2023-11-15 14:29:17 | knows | 2 | 53800 | 101 | 1.283 | 41933.0 |
651 | 2023-11-09 18:07:19 | knows | 1 | 28756 | 10 | 0.406 | 70827.6 |
650 | 2023-11-08 16:46:42 | knows | 1 | 28756 | 10 | 0.470 | 61183.0 |
649 | 2023-10-30 16:53:56 | knows | 1 | 28756 | 10 | 0.530 | 54256.6 |
648 | 2023-10-22 13:30:39 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
647 | 2023-10-19 16:56:25 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
646 | 2023-10-12 05:40:04 | knows | 1 | 28756 | 10 | 0.966 | 29768.1 |
645 | 2023-10-06 07:58:51 | knows | 1 | 28756 | 10 | 0.436 | 65954.1 |
644 | 2023-09-27 14:45:46 | knows | 1 | 28756 | 10 | 0.420 | 68466.7 |
643 | 2023-09-22 07:38:32 | knows | 1 | 28756 | 10 | 0.420 | 68466.7 |
642 | 2023-09-15 17:19:26 | knows | 2 | 53800 | 101 | 1.313 | 40974.9 |
641 | 2023-09-10 18:42:56 | knows | 1 | 28756 | 10 | 0.500 | 57512.0 |
640 | 2023-07-25 09:55:07 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
639 | 2023-06-18 22:41:32 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
638 | 2023-06-16 14:50:40 | knows | 2 | 53800 | 101 | 1.453 | 37026.8 |
637 | 2023-04-02 17:52:09 | knows | 1 | 28756 | 10 | 0.420 | 68466.7 |
636 | 2023-04-02 12:27:41 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
635 | 2023-03-14 19:51:20 | knows | 2 | 53800 | 101 | 1.296 | 41512.3 |
634 | 2023-03-04 09:13:25 | knows | 1 | 28756 | 10 | 0.450 | 63902.2 |
633 | 2023-01-15 06:26:10 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
632 | 2022-12-17 00:04:53 | knows | 2 | 53800 | 101 | 1.266 | 42496.1 |
631 | 2022-12-11 04:01:39 | knows | 1 | 28756 | 10 | 0.450 | 63902.2 |
630 | 2022-12-07 20:46:15 | knows | 2 | 53800 | 101 | 1.470 | 36598.6 |
629 | 2022-12-07 20:22:54 | knows | 1 | 28756 | 10 | 0.470 | 61183.0 |
628 | 2022-11-04 13:11:08 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
627 | 2022-10-31 09:27:52 | knows | 2 | 53800 | 101 | 1.296 | 41512.3 |
626 | 2022-09-17 20:27:33 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
625 | 2022-09-03 20:08:22 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
624 | 2022-08-08 05:24:32 | knows | 2 | 53800 | 101 | 1.280 | 42031.3 |
623 | 2022-08-07 15:30:58 | knows | 1 | 28756 | 10 | 0.450 | 63902.2 |
622 | 2022-08-07 04:20:08 | knows | 1 | 28756 | 10 | 0.420 | 68466.7 |
621 | 2022-08-05 21:25:46 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
620 | 2022-08-04 09:02:43 | knows | 1 | 28756 | 10 | 0.640 | 44931.3 |
619 | 2022-06-23 21:43:46 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
618 | 2022-06-21 16:40:58 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
617 | 2022-05-16 08:38:27 | knows | 1 | 28756 | 10 | 0.516 | 55728.7 |
616 | 2022-03-23 15:35:04 | knows | 1 | 28756 | 10 | 0.626 | 45936.1 |
615 | 2022-02-24 18:18:17 | knows | 1 | 28756 | 10 | 0.516 | 55728.7 |
614 | 2021-12-13 20:48:12 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
613 | 2021-11-29 14:12:43 | knows | 1 | 28756 | 10 | 0.513 | 56054.6 |
612 | 2021-10-21 02:20:18 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
611 | 2021-09-11 02:09:07 | knows | 1 | 28756 | 10 | 0.406 | 70827.6 |
610 | 2021-08-22 05:37:03 | knows | 1 | 28756 | 10 | 0.406 | 70827.6 |
609 | 2021-08-13 07:46:27 | knows | 1 | 28756 | 10 | 0.436 | 65954.1 |
608 | 2021-05-05 17:37:19 | knows | 1 | 28756 | 10 | 0.516 | 55728.7 |
607 | 2021-02-03 10:32:21 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
606 | 2021-01-28 19:10:58 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
605 | 2020-12-20 16:34:31 | knows | 1 | 28756 | 10 | 0.420 | 68466.7 |
604 | 2020-12-04 17:13:01 | knows | 2 | 53800 | 101 | 1.346 | 39970.3 |
603 | 2020-11-08 22:56:28 | knows | 1 | 28756 | 10 | 0.516 | 55728.7 |
602 | 2020-11-01 15:23:55 | knows | 1 | 28756 | 10 | 0.516 | 55728.7 |
601 | 2020-10-29 06:07:40 | knows | 1 | 28756 | 10 | 0.470 | 61183.0 |
600 | 2020-10-27 14:47:46 | knows | 2 | 53800 | 101 | 1.440 | 37361.1 |
599 | 2020-10-06 19:37:42 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
598 | 2020-10-05 10:23:54 | knows | 1 | 28756 | 10 | 0.500 | 57512.0 |
597 | 2020-09-18 04:40:16 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
596 | 2020-08-15 12:22:06 | knows | 1 | 28756 | 10 | 0.436 | 65954.1 |
595 | 2020-08-13 13:56:07 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
594 | 2020-08-08 00:55:46 | knows | 1 | 28756 | 10 | 0.436 | 65954.1 |
593 | 2020-08-02 08:27:01 | knows | 1 | 28756 | 10 | 0.610 | 47141.0 |
592 | 2020-07-30 17:58:38 | knows | 1 | 28756 | 10 | 0.440 | 65354.5 |
591 | 2020-07-30 00:21:24 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
590 | 2020-07-29 22:27:43 | knows | 1 | 28756 | 10 | 0.986 | 29164.3 |
589 | 2020-07-25 02:49:52 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
588 | 2020-07-24 06:53:38 | knows | 1 | 28756 | 10 | 0.500 | 57512.0 |
587 | 2020-05-05 23:12:07 | knows | 1 | 28756 | 10 | 0.436 | 65954.1 |
586 | 2020-04-24 13:38:52 | knows | 1 | 28756 | 10 | 0.453 | 63479.0 |
585 | 2020-03-26 07:11:03 | knows | 1 | 28756 | 10 | 0.500 | 57512.0 |
584 | 2020-03-24 17:48:30 | knows | 1 | 28756 | 10 | 0.470 | 61183.0 |
583 | 2020-03-23 07:27:05 | knows | 1 | 28756 | 10 | 1.046 | 27491.4 |
582 | 2020-03-23 06:04:03 | knows | 1 | 28756 | 10 | 0.530 | 54256.6 |
581 | 2020-03-22 10:17:06 | knows | 1 | 28756 | 10 | 0.983 | 29253.3 |
580 | 2020-03-18 15:22:42 | knows | 1 | 28756 | 10 | 0.483 | 59536.2 |
579 | 2020-02-23 23:11:30 | knows | 1 | 28756 | 10 | 0.513 | 56054.6 |
578 | 2020-02-17 23:11:49 | knows | 1 | 28756 | 10 | 0.533 | 53951.2 |
577 | 2020-02-12 22:49:28 | knows | 1 | 28756 | 10 | 1.610 | 17860.9 |
576 | 2020-02-02 21:32:06 | knows | 1 | 28756 | 10 | 0.516 | 55728.7 |
575 | 2020-02-02 08:07:55 | knows | 1 | 28756 | 10 | 2.280 | 12612.3 |
574 | 2020-02-01 07:40:12 | knows | 1 | 28756 | 10 | 1.016 | 28303.1 |
573 | 2020-02-01 04:15:00 | knows | 1 | 28756 | 10 | 0.516 | 55728.7 |
572 | 2020-01-28 11:01:10 | knows | 1 | 28756 | 10 | 0.423 | 67981.1 |
571 | 2020-01-25 06:52:44 | knows | 1 | 28756 | 10 | 0.500 | 57512.0 |
570 | 2020-01-23 22:35:27 | knows | 1 | 28756 | 10 | 1.046 | 27491.4 |