History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"niece"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
677 | 2024-04-21 08:17:35 | niece | 1 | 28756 | 5 | 0.640 | 44931.3 |
676 | 2024-04-19 21:35:58 | niece | 1 | 28756 | 5 | 1.733 | 16593.2 |
675 | 2024-04-07 02:48:53 | niece | 1 | 28756 | 5 | 0.796 | 36125.6 |
674 | 2024-04-03 07:46:06 | niece | 2 | 53800 | 48 | 5.080 | 10590.6 |
673 | 2024-04-03 07:46:00 | niece | 3 | 83667 | 857 | 7.763 | 10777.7 |
672 | 2024-04-03 07:42:36 | niece | 1 | 28756 | 5 | 0.530 | 54256.6 |
671 | 2024-04-03 03:06:03 | niece | 1 | 28756 | 5 | 0.563 | 51076.4 |
670 | 2024-03-31 15:52:59 | niece | 1 | 28756 | 5 | 0.516 | 55728.7 |
669 | 2024-03-29 23:47:14 | niece | 3 | 83667 | 857 | 13.970 | 5989.0 |
668 | 2024-03-27 19:20:40 | niece | 3 | 83667 | 857 | 7.703 | 10861.6 |
667 | 2024-03-27 08:16:25 | niece | 1 | 28756 | 5 | 0.533 | 53951.2 |
666 | 2024-03-16 23:09:32 | niece | 2 | 53800 | 48 | 3.126 | 17210.5 |
665 | 2024-03-16 23:09:32 | niece | 1 | 28756 | 5 | 0.983 | 29253.3 |
664 | 2024-03-16 23:08:56 | niece | 3 | 83667 | 857 | 4.530 | 18469.5 |
663 | 2024-03-14 12:06:11 | niece | 3 | 83667 | 857 | 3.406 | 24564.6 |
662 | 2024-03-04 00:04:32 | niece | 1 | 28756 | 5 | 0.563 | 51076.4 |
661 | 2024-03-01 13:01:41 | niece | 1 | 28756 | 5 | 0.423 | 67981.1 |
660 | 2024-02-25 19:08:27 | niece | 1 | 28756 | 5 | 0.470 | 61183.0 |
659 | 2024-02-06 10:00:22 | niece | 2 | 53800 | 48 | 1.720 | 31279.1 |
658 | 2024-02-06 09:59:42 | niece | 3 | 83667 | 857 | 4.030 | 20761.0 |
657 | 2024-02-06 08:27:27 | niece | 3 | 83667 | 857 | 4.143 | 20194.8 |
656 | 2024-02-02 22:37:55 | niece | 1 | 28756 | 5 | 0.516 | 55728.7 |
655 | 2024-01-29 10:20:04 | niece | 3 | 83667 | 857 | 4.780 | 17503.6 |
654 | 2024-01-29 08:57:55 | niece | 1 | 28756 | 5 | 0.436 | 65954.1 |
653 | 2024-01-25 23:58:21 | niece | 1 | 28756 | 5 | 0.516 | 55728.7 |
652 | 2024-01-23 22:38:21 | niece | 1 | 28756 | 5 | 0.500 | 57512.0 |
651 | 2024-01-01 18:35:58 | niece | 1 | 28756 | 5 | 0.453 | 63479.0 |
650 | 2023-12-20 03:13:37 | niece | 3 | 83667 | 857 | 3.266 | 25617.6 |
649 | 2023-12-02 07:25:55 | niece | 3 | 83667 | 857 | 4.093 | 20441.5 |
648 | 2023-11-21 14:38:46 | niece | 3 | 83667 | 857 | 5.810 | 14400.5 |
647 | 2023-11-21 14:38:47 | niece | 2 | 53800 | 48 | 1.593 | 33772.8 |
646 | 2023-11-15 16:44:58 | niece | 3 | 83667 | 857 | 3.686 | 22698.6 |
645 | 2023-11-15 16:44:51 | niece | 2 | 53800 | 48 | 1.360 | 39558.8 |
644 | 2023-11-14 23:35:38 | niece | 3 | 83667 | 857 | 3.516 | 23796.1 |
643 | 2023-11-14 23:35:40 | niece | 2 | 53800 | 48 | 1.596 | 33709.3 |
642 | 2023-11-11 11:47:05 | niece | 3 | 83667 | 857 | 3.813 | 21942.6 |
641 | 2023-11-08 16:52:38 | niece | 1 | 28756 | 5 | 0.470 | 61183.0 |
640 | 2023-11-08 00:00:24 | niece | 1 | 28756 | 5 | 0.470 | 61183.0 |
639 | 2023-10-27 04:26:03 | niece | 1 | 28756 | 5 | 0.500 | 57512.0 |
638 | 2023-10-25 05:36:55 | niece | 1 | 28756 | 5 | 0.466 | 61708.2 |
637 | 2023-10-23 20:15:15 | niece | 3 | 83667 | 857 | 4.000 | 20916.8 |
636 | 2023-10-19 16:36:51 | niece | 1 | 28756 | 5 | 0.483 | 59536.2 |
635 | 2023-10-19 15:30:36 | niece | 3 | 83667 | 857 | 7.313 | 11440.9 |
634 | 2023-10-19 15:30:41 | niece | 2 | 53800 | 48 | 1.640 | 32804.9 |
633 | 2023-10-19 07:52:17 | niece | 3 | 83667 | 857 | 3.860 | 21675.4 |
632 | 2023-10-19 07:52:16 | niece | 2 | 53800 | 48 | 1.653 | 32546.9 |
631 | 2023-10-16 20:20:04 | niece | 1 | 28756 | 5 | 0.500 | 57512.0 |
630 | 2023-10-13 05:58:40 | niece | 1 | 28756 | 5 | 0.440 | 65354.5 |
629 | 2023-10-04 07:12:29 | niece | 1 | 28756 | 5 | 0.470 | 61183.0 |
628 | 2023-10-03 18:10:22 | niece | 3 | 83667 | 857 | 3.860 | 21675.4 |
627 | 2023-09-30 00:38:36 | niece | 2 | 53800 | 48 | 1.420 | 37887.3 |
626 | 2023-09-28 04:04:46 | niece | 3 | 83667 | 857 | 4.453 | 18788.9 |
625 | 2023-09-24 10:25:07 | niece | 3 | 83667 | 857 | 3.686 | 22698.6 |
624 | 2023-09-23 15:14:30 | niece | 1 | 28756 | 5 | 0.420 | 68466.7 |
623 | 2023-09-22 23:26:51 | niece | 1 | 28756 | 5 | 0.420 | 68466.7 |
622 | 2023-09-19 01:32:52 | niece | 3 | 83667 | 857 | 3.266 | 25617.6 |
621 | 2023-09-12 07:43:47 | niece | 1 | 28756 | 5 | 0.486 | 59168.7 |
620 | 2023-08-21 12:00:14 | niece | 1 | 28756 | 5 | 0.453 | 63479.0 |
619 | 2023-08-12 15:44:36 | niece | 1 | 28756 | 5 | 0.470 | 61183.0 |
618 | 2023-08-12 14:15:38 | niece | 1 | 28756 | 5 | 0.466 | 61708.2 |
617 | 2023-07-11 18:00:41 | niece | 3 | 83667 | 857 | 4.123 | 20292.7 |
616 | 2023-07-10 08:19:54 | niece | 3 | 83667 | 857 | 3.703 | 22594.4 |
615 | 2023-07-09 19:45:34 | niece | 3 | 83667 | 857 | 3.656 | 22884.8 |
614 | 2023-07-08 20:21:33 | niece | 3 | 83667 | 857 | 3.343 | 25027.5 |
613 | 2023-07-08 05:58:19 | niece | 3 | 83667 | 857 | 3.296 | 25384.4 |
612 | 2023-07-07 13:28:10 | niece | 3 | 83667 | 857 | 3.656 | 22884.8 |
611 | 2023-07-06 19:34:57 | niece | 3 | 83667 | 857 | 3.376 | 24782.9 |
610 | 2023-07-04 21:24:06 | niece | 3 | 83667 | 857 | 3.420 | 24464.0 |
609 | 2023-07-04 02:22:01 | niece | 3 | 83667 | 857 | 3.266 | 25617.6 |
608 | 2023-07-03 11:24:42 | niece | 3 | 83667 | 857 | 3.266 | 25617.6 |
607 | 2023-07-02 13:50:37 | niece | 3 | 83667 | 857 | 3.720 | 22491.1 |
606 | 2023-07-01 20:02:07 | niece | 3 | 83667 | 857 | 3.326 | 25155.4 |
605 | 2023-07-01 01:09:31 | niece | 3 | 83667 | 857 | 3.326 | 25155.4 |
604 | 2023-06-30 07:59:11 | niece | 3 | 83667 | 857 | 4.000 | 20916.8 |
603 | 2023-06-29 18:04:55 | niece | 3 | 83667 | 857 | 3.466 | 24139.4 |
602 | 2023-06-28 20:22:07 | niece | 3 | 83667 | 857 | 3.826 | 21868.0 |
601 | 2023-06-28 01:06:00 | niece | 3 | 83667 | 857 | 3.236 | 25855.1 |
600 | 2023-06-27 09:00:26 | niece | 3 | 83667 | 857 | 3.860 | 21675.4 |
599 | 2023-06-26 14:28:45 | niece | 3 | 83667 | 857 | 3.360 | 24900.9 |
598 | 2023-06-25 19:35:18 | niece | 3 | 83667 | 857 | 3.796 | 22040.8 |
597 | 2023-06-25 01:07:30 | niece | 3 | 83667 | 857 | 3.326 | 25155.4 |
596 | 2023-06-24 07:58:39 | niece | 3 | 83667 | 857 | 3.436 | 24350.1 |
595 | 2023-06-23 12:44:52 | niece | 3 | 83667 | 857 | 3.313 | 25254.2 |
594 | 2023-06-22 19:51:44 | niece | 3 | 83667 | 857 | 3.283 | 25484.9 |
593 | 2023-06-22 00:59:43 | niece | 3 | 83667 | 857 | 3.326 | 25155.4 |
592 | 2023-06-21 07:31:29 | niece | 3 | 83667 | 857 | 3.390 | 24680.5 |
591 | 2023-06-20 16:48:30 | niece | 3 | 83667 | 857 | 3.250 | 25743.7 |
590 | 2023-06-19 22:16:31 | niece | 3 | 83667 | 857 | 5.236 | 15979.2 |
589 | 2023-06-19 03:18:59 | niece | 3 | 83667 | 857 | 3.750 | 22311.2 |
588 | 2023-06-18 10:39:29 | niece | 3 | 83667 | 857 | 3.326 | 25155.4 |
587 | 2023-06-17 21:42:31 | niece | 3 | 83667 | 857 | 3.983 | 21006.0 |
586 | 2023-06-17 15:23:50 | niece | 1 | 28756 | 5 | 0.703 | 40904.7 |
585 | 2023-06-16 23:00:36 | niece | 3 | 83667 | 857 | 3.843 | 21771.3 |
584 | 2023-06-16 04:58:04 | niece | 3 | 83667 | 857 | 3.470 | 24111.5 |
583 | 2023-06-15 15:40:35 | niece | 3 | 83667 | 857 | 3.703 | 22594.4 |
582 | 2023-06-15 07:40:44 | niece | 3 | 83667 | 857 | 3.300 | 25353.6 |
581 | 2023-06-14 19:31:44 | niece | 3 | 83667 | 857 | 3.373 | 24804.9 |
580 | 2023-06-13 19:13:43 | niece | 3 | 83667 | 857 | 3.690 | 22674.0 |
579 | 2023-06-13 01:20:53 | niece | 3 | 83667 | 857 | 3.296 | 25384.4 |
578 | 2023-06-11 04:04:57 | niece | 3 | 83667 | 857 | 3.283 | 25484.9 |