History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"blain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
693 | 2024-04-26 22:46:54 | blain | 1 | 28756 | 9 | 1.106 | 26000.0 |
692 | 2024-04-26 03:42:57 | blain | 2 | 53800 | 116 | 1.513 | 35558.5 |
691 | 2024-04-17 11:49:43 | blain | 1 | 28756 | 9 | 0.560 | 51350.0 |
690 | 2024-04-08 16:38:38 | blain | 1 | 28756 | 9 | 1.720 | 16718.6 |
689 | 2024-04-04 20:12:30 | blain | 2 | 53800 | 116 | 1.390 | 38705.0 |
688 | 2024-04-03 10:13:45 | blain | 1 | 28756 | 9 | 0.576 | 49923.6 |
687 | 2024-04-03 08:32:06 | blain | 2 | 53800 | 116 | 4.796 | 11217.7 |
686 | 2024-04-03 08:31:57 | blain | 1 | 28756 | 9 | 1.110 | 25906.3 |
685 | 2024-03-31 05:56:02 | blain | 2 | 53800 | 116 | 1.890 | 28465.6 |
684 | 2024-03-31 03:43:40 | blain | 1 | 28756 | 9 | 0.530 | 54256.6 |
683 | 2024-03-27 05:03:31 | blain | 1 | 28756 | 9 | 0.546 | 52666.7 |
682 | 2024-03-04 00:29:05 | blain | 1 | 28756 | 9 | 0.453 | 63479.0 |
681 | 2024-02-26 01:34:31 | blain | 2 | 53800 | 116 | 1.640 | 32804.9 |
680 | 2024-02-26 01:34:12 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
679 | 2024-02-21 04:26:52 | blain | 1 | 28756 | 9 | 1.530 | 18794.8 |
678 | 2024-02-03 00:10:19 | blain | 1 | 28756 | 9 | 0.513 | 56054.6 |
677 | 2024-01-31 02:17:43 | blain | 1 | 28756 | 9 | 0.546 | 52666.7 |
676 | 2024-01-28 21:58:39 | blain | 1 | 28756 | 9 | 0.466 | 61708.2 |
675 | 2024-01-26 20:47:41 | blain | 1 | 28756 | 9 | 1.000 | 28756.0 |
674 | 2024-01-18 12:51:31 | blain | 1 | 28756 | 9 | 0.483 | 59536.2 |
673 | 2024-01-06 15:22:20 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
672 | 2023-12-16 05:35:37 | blain | 2 | 53800 | 116 | 3.046 | 17662.5 |
671 | 2023-12-14 14:10:30 | blain | 2 | 53800 | 116 | 1.406 | 38264.6 |
670 | 2023-12-14 01:17:20 | blain | 2 | 53800 | 116 | 1.356 | 39675.5 |
669 | 2023-12-09 04:22:33 | blain | 2 | 53800 | 116 | 1.390 | 38705.0 |
668 | 2023-11-14 11:36:18 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
667 | 2023-11-13 04:06:36 | blain | 1 | 28756 | 9 | 1.050 | 27386.7 |
666 | 2023-11-12 23:00:49 | blain | 1 | 28756 | 9 | 0.500 | 57512.0 |
665 | 2023-11-11 18:59:45 | blain | 2 | 53800 | 116 | 1.516 | 35488.1 |
664 | 2023-10-28 19:50:49 | blain | 1 | 28756 | 9 | 0.533 | 53951.2 |
663 | 2023-10-21 06:02:59 | blain | 1 | 28756 | 9 | 1.780 | 16155.1 |
662 | 2023-10-18 12:00:51 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
661 | 2023-10-11 07:34:04 | blain | 1 | 28756 | 9 | 0.423 | 67981.1 |
660 | 2023-10-05 04:13:51 | blain | 1 | 28756 | 9 | 0.500 | 57512.0 |
659 | 2023-09-24 04:02:59 | blain | 1 | 28756 | 9 | 0.453 | 63479.0 |
658 | 2023-09-24 02:31:07 | blain | 1 | 28756 | 9 | 0.470 | 61183.0 |
657 | 2023-09-21 15:39:06 | blain | 1 | 28756 | 9 | 0.470 | 61183.0 |
656 | 2023-09-10 20:44:44 | blain | 2 | 53800 | 116 | 3.203 | 16796.8 |
655 | 2023-09-06 16:49:31 | blain | 2 | 53800 | 116 | 1.403 | 38346.4 |
654 | 2023-09-01 04:41:05 | blain | 1 | 28756 | 9 | 0.440 | 65354.5 |
653 | 2023-08-11 23:00:26 | blain | 1 | 28756 | 9 | 0.483 | 59536.2 |
652 | 2023-07-26 17:52:45 | blain | 2 | 53800 | 116 | 1.563 | 34421.0 |
651 | 2023-07-08 09:46:26 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
650 | 2023-06-28 02:12:25 | blain | 1 | 28756 | 9 | 0.466 | 61708.2 |
649 | 2023-06-20 03:07:10 | blain | 1 | 28756 | 9 | 0.500 | 57512.0 |
648 | 2023-06-05 07:53:52 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
647 | 2023-05-19 23:04:28 | blain | 2 | 53800 | 116 | 1.376 | 39098.8 |
646 | 2023-05-10 03:10:42 | blain | 1 | 28756 | 9 | 0.483 | 59536.2 |
645 | 2023-05-06 04:16:16 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
644 | 2023-04-29 04:13:36 | blain | 1 | 28756 | 9 | 0.516 | 55728.7 |
643 | 2023-03-31 14:41:47 | blain | 2 | 53800 | 116 | 1.533 | 35094.6 |
642 | 2023-03-27 13:49:57 | blain | 1 | 28756 | 9 | 0.483 | 59536.2 |
641 | 2023-03-27 05:20:07 | blain | 1 | 28756 | 9 | 0.470 | 61183.0 |
640 | 2023-03-22 07:42:48 | blain | 1 | 28756 | 9 | 0.500 | 57512.0 |
639 | 2023-03-15 16:29:12 | blain | 1 | 28756 | 9 | 0.423 | 67981.1 |
638 | 2023-03-14 13:08:04 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
637 | 2023-03-07 09:42:54 | blain | 1 | 28756 | 9 | 0.453 | 63479.0 |
636 | 2023-02-24 23:24:30 | blain | 2 | 53800 | 116 | 1.623 | 33148.5 |
635 | 2023-02-04 17:48:26 | blain | 2 | 53800 | 116 | 1.330 | 40451.1 |
634 | 2023-01-21 13:08:02 | blain | 1 | 28756 | 9 | 0.440 | 65354.5 |
633 | 2023-01-14 21:21:57 | blain | 1 | 28756 | 9 | 0.420 | 68466.7 |
632 | 2023-01-10 16:17:25 | blain | 1 | 28756 | 9 | 0.420 | 68466.7 |
631 | 2022-12-11 20:45:31 | blain | 2 | 53800 | 116 | 1.376 | 39098.8 |
630 | 2022-12-07 10:10:28 | blain | 1 | 28756 | 9 | 0.420 | 68466.7 |
629 | 2022-12-06 07:04:30 | blain | 1 | 28756 | 9 | 0.513 | 56054.6 |
628 | 2022-12-05 20:12:41 | blain | 2 | 53800 | 116 | 1.486 | 36204.6 |
627 | 2022-11-30 21:46:41 | blain | 1 | 28756 | 9 | 0.516 | 55728.7 |
626 | 2022-11-27 00:50:42 | blain | 2 | 53800 | 116 | 1.360 | 39558.8 |
625 | 2022-11-15 08:49:08 | blain | 1 | 28756 | 9 | 0.483 | 59536.2 |
624 | 2022-11-14 21:06:55 | blain | 1 | 28756 | 9 | 0.440 | 65354.5 |
623 | 2022-10-25 11:34:42 | blain | 2 | 53800 | 116 | 1.360 | 39558.8 |
622 | 2022-10-15 07:46:42 | blain | 1 | 28756 | 9 | 0.420 | 68466.7 |
621 | 2022-10-14 20:27:42 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
620 | 2022-10-10 21:19:37 | blain | 2 | 53800 | 116 | 1.410 | 38156.0 |
619 | 2022-09-18 22:58:02 | blain | 1 | 28756 | 9 | 0.440 | 65354.5 |
618 | 2022-09-11 19:27:32 | blain | 2 | 53800 | 116 | 1.533 | 35094.6 |
617 | 2022-09-09 12:39:10 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
616 | 2022-09-07 21:51:05 | blain | 1 | 28756 | 9 | 0.470 | 61183.0 |
615 | 2022-09-01 13:35:04 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
614 | 2022-08-31 12:49:43 | blain | 1 | 28756 | 9 | 0.483 | 59536.2 |
613 | 2022-08-28 04:05:22 | blain | 2 | 53800 | 116 | 1.390 | 38705.0 |
612 | 2022-08-22 16:26:09 | blain | 1 | 28756 | 9 | 0.440 | 65354.5 |
611 | 2022-08-14 15:11:02 | blain | 1 | 28756 | 9 | 0.453 | 63479.0 |
610 | 2022-08-07 18:48:39 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
609 | 2022-08-06 04:00:17 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
608 | 2022-07-24 01:48:46 | blain | 2 | 53800 | 116 | 1.360 | 39558.8 |
607 | 2022-07-20 03:35:38 | blain | 1 | 28756 | 9 | 0.420 | 68466.7 |
606 | 2022-07-13 13:06:33 | blain | 1 | 28756 | 9 | 0.516 | 55728.7 |
605 | 2022-07-07 20:03:52 | blain | 2 | 53800 | 116 | 1.513 | 35558.5 |
604 | 2022-06-05 22:47:40 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
603 | 2022-06-04 22:52:38 | blain | 2 | 53800 | 116 | 1.356 | 39675.5 |
602 | 2022-06-01 07:58:31 | blain | 1 | 28756 | 9 | 0.453 | 63479.0 |
601 | 2022-05-26 11:21:10 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
600 | 2022-05-19 21:14:59 | blain | 2 | 53800 | 116 | 1.483 | 36277.8 |
599 | 2022-05-10 05:12:02 | blain | 1 | 28756 | 9 | 0.436 | 65954.1 |
598 | 2022-04-17 20:58:49 | blain | 2 | 53800 | 116 | 1.656 | 32487.9 |
597 | 2022-04-14 04:59:02 | blain | 1 | 28756 | 9 | 0.483 | 59536.2 |
596 | 2022-04-07 22:26:26 | blain | 1 | 28756 | 9 | 0.576 | 49923.6 |
595 | 2022-04-05 05:08:10 | blain | 2 | 53800 | 116 | 1.343 | 40059.6 |
594 | 2022-04-03 01:34:59 | blain | 2 | 53800 | 116 | 1.436 | 37465.2 |