History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nears"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
710 | 2024-04-27 07:12:19 | nears | 1 | 28756 | 18 | 1.063 | 27051.7 |
709 | 2024-04-20 22:29:09 | nears | 1 | 28756 | 18 | 1.156 | 24875.4 |
708 | 2024-04-20 22:28:41 | nears | 1 | 28756 | 18 | 1.280 | 22465.6 |
707 | 2024-04-19 00:23:22 | nears | 1 | 28756 | 18 | 1.826 | 15748.1 |
706 | 2024-04-03 05:33:44 | nears | 1 | 28756 | 18 | 1.186 | 24246.2 |
705 | 2024-03-31 07:42:25 | nears | 1 | 28756 | 18 | 0.483 | 59536.2 |
704 | 2024-03-29 04:33:59 | nears | 1 | 28756 | 18 | 0.516 | 55728.7 |
703 | 2024-03-22 05:04:12 | nears | 2 | 53800 | 236 | 1.826 | 29463.3 |
702 | 2024-03-04 12:47:50 | nears | 1 | 28756 | 18 | 1.076 | 26724.9 |
701 | 2024-03-03 20:54:44 | nears | 1 | 28756 | 18 | 0.530 | 54256.6 |
700 | 2024-03-01 08:05:48 | nears | 1 | 28756 | 18 | 0.576 | 49923.6 |
699 | 2024-02-25 22:46:35 | nears | 1 | 28756 | 18 | 1.030 | 27918.4 |
698 | 2024-01-29 16:41:49 | nears | 1 | 28756 | 18 | 0.530 | 54256.6 |
697 | 2024-01-26 20:37:49 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
696 | 2024-01-23 11:43:04 | nears | 1 | 28756 | 18 | 1.656 | 17364.7 |
695 | 2024-01-19 23:01:16 | nears | 2 | 53800 | 236 | 1.436 | 37465.2 |
694 | 2023-12-20 08:35:16 | nears | 2 | 53800 | 236 | 1.483 | 36277.8 |
693 | 2023-12-19 22:35:31 | nears | 1 | 28756 | 18 | 0.420 | 68466.7 |
692 | 2023-12-16 00:08:46 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
691 | 2023-12-01 16:34:36 | nears | 1 | 28756 | 18 | 0.453 | 63479.0 |
690 | 2023-11-30 16:30:01 | nears | 2 | 53800 | 236 | 1.720 | 31279.1 |
689 | 2023-11-30 06:48:35 | nears | 2 | 53800 | 236 | 1.860 | 28924.7 |
688 | 2023-11-23 23:08:27 | nears | 1 | 28756 | 18 | 0.420 | 68466.7 |
687 | 2023-11-20 14:40:00 | nears | 2 | 53800 | 236 | 1.453 | 37026.8 |
686 | 2023-11-18 11:46:06 | nears | 1 | 28756 | 18 | 0.483 | 59536.2 |
685 | 2023-11-18 07:00:09 | nears | 1 | 28756 | 18 | 0.470 | 61183.0 |
684 | 2023-11-16 07:27:48 | nears | 1 | 28756 | 18 | 0.440 | 65354.5 |
683 | 2023-11-12 02:06:34 | nears | 1 | 28756 | 18 | 0.483 | 59536.2 |
682 | 2023-10-27 03:06:22 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
681 | 2023-10-23 10:25:45 | nears | 1 | 28756 | 18 | 0.483 | 59536.2 |
680 | 2023-10-22 02:57:05 | nears | 1 | 28756 | 18 | 0.483 | 59536.2 |
679 | 2023-10-13 19:16:11 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
678 | 2023-10-05 00:16:48 | nears | 1 | 28756 | 18 | 0.486 | 59168.7 |
677 | 2023-09-27 20:01:29 | nears | 1 | 28756 | 18 | 0.486 | 59168.7 |
676 | 2023-09-23 13:52:10 | nears | 1 | 28756 | 18 | 0.470 | 61183.0 |
675 | 2023-09-10 07:34:18 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
674 | 2023-08-29 20:29:37 | nears | 2 | 53800 | 236 | 1.580 | 34050.6 |
673 | 2023-08-16 01:21:48 | nears | 1 | 28756 | 18 | 0.703 | 40904.7 |
672 | 2023-06-15 15:57:30 | nears | 1 | 28756 | 18 | 0.453 | 63479.0 |
671 | 2023-05-15 16:26:17 | nears | 2 | 53800 | 236 | 1.453 | 37026.8 |
670 | 2023-05-08 23:40:55 | nears | 1 | 28756 | 18 | 0.466 | 61708.2 |
669 | 2023-04-03 22:31:51 | nears | 1 | 28756 | 18 | 0.486 | 59168.7 |
668 | 2023-02-23 12:49:21 | nears | 2 | 53800 | 236 | 1.376 | 39098.8 |
667 | 2023-02-02 15:46:16 | nears | 1 | 28756 | 18 | 0.440 | 65354.5 |
666 | 2023-01-17 23:27:51 | nears | 1 | 28756 | 18 | 0.423 | 67981.1 |
665 | 2022-12-04 23:04:48 | nears | 2 | 53800 | 236 | 1.360 | 39558.8 |
664 | 2022-11-14 12:19:52 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
663 | 2022-10-19 18:35:07 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
662 | 2022-09-01 20:03:31 | nears | 1 | 28756 | 18 | 0.580 | 49579.3 |
661 | 2022-07-06 02:34:11 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
660 | 2022-06-25 20:10:11 | nears | 1 | 28756 | 18 | 0.466 | 61708.2 |
659 | 2022-04-11 18:12:13 | nears | 2 | 53800 | 236 | 1.843 | 29191.5 |
658 | 2022-03-25 09:25:45 | nears | 1 | 28756 | 18 | 0.673 | 42728.1 |
657 | 2022-03-16 08:47:36 | nears | 1 | 28756 | 18 | 0.593 | 48492.4 |
656 | 2022-03-12 21:52:56 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
655 | 2022-03-08 17:08:42 | nears | 1 | 28756 | 18 | 0.530 | 54256.6 |
654 | 2021-12-19 12:29:39 | nears | 2 | 53800 | 236 | 1.596 | 33709.3 |
653 | 2021-12-19 03:33:47 | nears | 1 | 28756 | 18 | 0.516 | 55728.7 |
652 | 2021-12-05 23:45:58 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
651 | 2021-10-30 09:33:32 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
650 | 2021-10-29 08:13:12 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
649 | 2021-10-28 20:50:46 | nears | 1 | 28756 | 18 | 0.470 | 61183.0 |
648 | 2021-10-27 16:40:03 | nears | 1 | 28756 | 18 | 0.470 | 61183.0 |
647 | 2021-10-24 04:28:42 | nears | 1 | 28756 | 18 | 0.453 | 63479.0 |
646 | 2021-10-06 00:37:20 | nears | 2 | 53800 | 236 | 1.390 | 38705.0 |
645 | 2021-09-14 07:58:55 | nears | 1 | 28756 | 18 | 0.440 | 65354.5 |
644 | 2021-09-12 04:17:23 | nears | 1 | 28756 | 18 | 0.440 | 65354.5 |
643 | 2021-09-05 04:37:32 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
642 | 2021-09-01 21:05:21 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
641 | 2021-08-15 01:12:55 | nears | 2 | 53800 | 236 | 1.406 | 38264.6 |
640 | 2021-08-14 15:50:33 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
639 | 2021-08-12 11:49:04 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
638 | 2021-08-07 04:40:03 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
637 | 2021-06-09 19:48:17 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
636 | 2021-06-01 04:20:12 | nears | 1 | 28756 | 18 | 0.500 | 57512.0 |
635 | 2021-04-15 15:45:09 | nears | 1 | 28756 | 18 | 0.420 | 68466.7 |
634 | 2021-04-12 23:42:17 | nears | 1 | 28756 | 18 | 0.986 | 29164.3 |
633 | 2021-03-18 21:53:08 | nears | 1 | 28756 | 18 | 0.453 | 63479.0 |
632 | 2021-03-01 23:42:49 | nears | 1 | 28756 | 18 | 0.420 | 68466.7 |
631 | 2020-12-31 02:00:47 | nears | 1 | 28756 | 18 | 0.486 | 59168.7 |
630 | 2020-11-30 11:04:48 | nears | 1 | 28756 | 18 | 0.560 | 51350.0 |
629 | 2020-11-01 05:38:42 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
628 | 2020-10-25 13:31:16 | nears | 2 | 53800 | 236 | 1.453 | 37026.8 |
627 | 2020-10-23 05:58:45 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
626 | 2020-10-22 00:50:20 | nears | 1 | 28756 | 18 | 0.593 | 48492.4 |
625 | 2020-09-23 03:15:56 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
624 | 2020-09-09 21:26:38 | nears | 1 | 28756 | 18 | 0.453 | 63479.0 |
623 | 2020-09-09 04:43:30 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
622 | 2020-09-03 12:26:08 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
621 | 2020-08-26 19:19:40 | nears | 1 | 28756 | 18 | 0.486 | 59168.7 |
620 | 2020-08-23 15:31:47 | nears | 1 | 28756 | 18 | 0.483 | 59536.2 |
619 | 2020-08-14 08:05:10 | nears | 1 | 28756 | 18 | 0.440 | 65354.5 |
618 | 2020-08-03 07:35:54 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
617 | 2020-07-18 07:43:30 | nears | 1 | 28756 | 18 | 0.483 | 59536.2 |
616 | 2020-07-16 07:14:03 | nears | 1 | 28756 | 18 | 0.546 | 52666.7 |
615 | 2020-06-13 06:03:48 | nears | 1 | 28756 | 18 | 0.516 | 55728.7 |
614 | 2020-05-22 07:21:22 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |
613 | 2020-05-19 04:31:41 | nears | 1 | 28756 | 18 | 0.423 | 67981.1 |
612 | 2020-05-18 14:43:41 | nears | 1 | 28756 | 18 | 0.486 | 59168.7 |
611 | 2020-05-17 13:55:28 | nears | 1 | 28756 | 18 | 0.436 | 65954.1 |