History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spaller"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
682 | 2024-04-19 05:14:40 | spaller | 1 | 69583 | 6 | 5.156 | 13495.5 |
681 | 2024-03-26 12:17:42 | spaller | 1 | 69583 | 6 | 1.296 | 53690.6 |
680 | 2024-02-29 09:14:47 | spaller | 3 | 134027 | 709 | 11.096 | 12078.9 |
679 | 2024-02-29 09:14:22 | spaller | 2 | 107671 | 76 | 4.750 | 22667.6 |
678 | 2024-02-28 16:52:56 | spaller | 2 | 107671 | 76 | 15.843 | 6796.1 |
677 | 2024-02-27 09:48:12 | spaller | 1 | 69583 | 6 | 1.076 | 64668.2 |
676 | 2023-12-28 02:28:16 | spaller | 1 | 69583 | 6 | 1.283 | 54234.6 |
675 | 2023-12-25 10:24:03 | spaller | 1 | 69583 | 6 | 1.233 | 56433.9 |
674 | 2023-12-19 00:14:02 | spaller | 1 | 69583 | 6 | 1.123 | 61961.7 |
673 | 2023-12-15 06:50:56 | spaller | 1 | 69583 | 6 | 1.123 | 61961.7 |
672 | 2023-11-19 21:13:00 | spaller | 1 | 69583 | 6 | 1.283 | 54234.6 |
671 | 2023-11-08 11:34:15 | spaller | 1 | 69583 | 6 | 2.483 | 28023.8 |
670 | 2023-10-17 16:08:30 | spaller | 1 | 69583 | 6 | 1.216 | 57222.9 |
669 | 2023-10-15 05:42:21 | spaller | 1 | 69583 | 6 | 1.123 | 61961.7 |
668 | 2023-10-09 21:29:57 | spaller | 1 | 69583 | 6 | 1.126 | 61796.6 |
667 | 2023-10-05 14:24:10 | spaller | 1 | 69583 | 6 | 1.156 | 60192.9 |
666 | 2023-09-29 03:54:02 | spaller | 1 | 69583 | 6 | 1.156 | 60192.9 |
665 | 2023-09-23 02:36:41 | spaller | 1 | 69583 | 6 | 1.203 | 57841.2 |
664 | 2023-08-22 08:10:57 | spaller | 1 | 69583 | 6 | 1.076 | 64668.2 |
663 | 2023-08-02 10:40:51 | spaller | 1 | 69583 | 6 | 1.060 | 65644.3 |
662 | 2023-04-30 13:04:33 | spaller | 1 | 69583 | 6 | 1.170 | 59472.6 |
661 | 2023-04-23 19:20:39 | spaller | 1 | 69583 | 6 | 1.216 | 57222.9 |
660 | 2023-02-21 17:48:05 | spaller | 1 | 69583 | 6 | 1.170 | 59472.6 |
659 | 2023-01-03 23:05:18 | spaller | 1 | 69583 | 6 | 1.076 | 64668.2 |
658 | 2022-12-21 00:24:13 | spaller | 1 | 69583 | 6 | 1.063 | 65459.1 |
657 | 2022-09-03 04:54:17 | spaller | 1 | 69583 | 6 | 1.093 | 63662.4 |
656 | 2022-08-30 11:27:42 | spaller | 1 | 69583 | 6 | 1.093 | 63662.4 |
655 | 2022-07-19 13:47:24 | spaller | 1 | 69583 | 6 | 1.173 | 59320.5 |
654 | 2022-04-18 13:25:46 | spaller | 1 | 69583 | 6 | 1.296 | 53690.6 |
653 | 2022-04-16 02:06:57 | spaller | 1 | 69583 | 6 | 1.203 | 57841.2 |
652 | 2022-01-14 06:36:11 | spaller | 1 | 69583 | 6 | 1.140 | 61037.7 |
651 | 2021-12-28 02:05:47 | spaller | 1 | 69583 | 6 | 1.123 | 61961.7 |
650 | 2021-12-24 22:51:58 | spaller | 1 | 69583 | 6 | 1.220 | 57035.2 |
649 | 2021-11-08 02:31:43 | spaller | 1 | 69583 | 6 | 1.063 | 65459.1 |
648 | 2021-10-30 23:53:52 | spaller | 1 | 69583 | 6 | 1.140 | 61037.7 |
647 | 2021-10-29 22:35:41 | spaller | 1 | 69583 | 6 | 1.186 | 58670.3 |
646 | 2021-09-29 21:33:55 | spaller | 1 | 69583 | 6 | 1.296 | 53690.6 |
645 | 2021-09-22 09:15:32 | spaller | 1 | 69583 | 6 | 1.190 | 58473.1 |
644 | 2021-09-21 09:11:15 | spaller | 1 | 69583 | 6 | 1.266 | 54962.9 |
643 | 2021-09-15 02:14:35 | spaller | 1 | 69583 | 6 | 1.093 | 63662.4 |
642 | 2021-09-10 16:20:22 | spaller | 1 | 69583 | 6 | 1.236 | 56296.9 |
641 | 2021-09-08 01:59:29 | spaller | 1 | 69583 | 6 | 1.203 | 57841.2 |
640 | 2021-09-04 19:47:02 | spaller | 1 | 69583 | 6 | 1.076 | 64668.2 |
639 | 2021-05-29 01:31:13 | spaller | 1 | 69583 | 6 | 1.156 | 60192.9 |
638 | 2021-05-28 12:22:47 | spaller | 1 | 69583 | 6 | 1.203 | 57841.2 |
637 | 2021-05-03 09:26:24 | spaller | 1 | 69583 | 6 | 1.313 | 52995.4 |
636 | 2021-04-01 14:33:14 | spaller | 1 | 69583 | 6 | 1.403 | 49595.9 |
635 | 2021-03-06 06:06:56 | spaller | 1 | 69583 | 6 | 1.096 | 63488.1 |
634 | 2021-02-25 11:17:21 | spaller | 1 | 69583 | 6 | 1.093 | 63662.4 |
633 | 2021-02-14 13:17:06 | spaller | 1 | 69583 | 6 | 1.110 | 62687.4 |
632 | 2021-02-10 05:06:56 | spaller | 1 | 69583 | 6 | 1.093 | 63662.4 |
631 | 2021-01-28 05:05:45 | spaller | 1 | 69583 | 6 | 1.110 | 62687.4 |
630 | 2021-01-16 16:29:58 | spaller | 1 | 69583 | 6 | 1.123 | 61961.7 |
629 | 2020-11-25 11:40:44 | spaller | 1 | 69583 | 6 | 1.076 | 64668.2 |
628 | 2020-11-21 21:46:26 | spaller | 1 | 69583 | 6 | 1.110 | 62687.4 |
627 | 2020-10-26 02:46:29 | spaller | 1 | 69583 | 6 | 1.076 | 64668.2 |
626 | 2020-10-02 22:04:59 | spaller | 1 | 69583 | 6 | 1.080 | 64428.7 |
625 | 2020-09-22 20:11:00 | spaller | 1 | 69583 | 6 | 1.123 | 61961.7 |
624 | 2020-09-01 09:22:40 | spaller | 1 | 69583 | 6 | 1.093 | 63662.4 |
623 | 2020-08-27 22:21:15 | spaller | 1 | 69583 | 6 | 1.156 | 60192.9 |
622 | 2020-08-23 06:59:26 | spaller | 1 | 69583 | 6 | 2.466 | 28217.0 |
621 | 2020-08-21 17:34:05 | spaller | 1 | 69583 | 6 | 1.203 | 57841.2 |
620 | 2020-08-20 02:18:54 | spaller | 1 | 69583 | 6 | 1.143 | 60877.5 |
619 | 2020-05-15 16:09:34 | spaller | 1 | 69583 | 6 | 1.096 | 63488.1 |
618 | 2020-04-12 02:03:33 | spaller | 1 | 69583 | 6 | 1.093 | 63662.4 |
617 | 2020-03-29 22:11:08 | spaller | 1 | 69583 | 6 | 1.233 | 56433.9 |
616 | 2020-03-28 19:33:34 | spaller | 1 | 69583 | 6 | 1.296 | 53690.6 |
615 | 2020-03-28 15:28:44 | spaller | 1 | 69583 | 6 | 1.326 | 52475.9 |
614 | 2020-03-26 15:15:52 | spaller | 1 | 69583 | 6 | 1.406 | 49490.0 |
613 | 2020-03-20 10:38:35 | spaller | 1 | 69583 | 6 | 1.110 | 62687.4 |
612 | 2020-02-25 08:12:58 | spaller | 1 | 69583 | 6 | 2.050 | 33942.9 |
611 | 2020-02-24 11:03:09 | spaller | 1 | 69583 | 6 | 1.343 | 51811.6 |
610 | 2020-02-17 03:36:36 | spaller | 1 | 69583 | 6 | 2.736 | 25432.4 |
609 | 2020-02-12 23:36:34 | spaller | 1 | 69583 | 6 | 1.266 | 54962.9 |
608 | 2020-02-05 14:06:01 | spaller | 1 | 69583 | 6 | 2.763 | 25183.9 |
607 | 2020-02-05 02:53:53 | spaller | 1 | 69583 | 6 | 2.530 | 27503.2 |
606 | 2020-02-02 19:39:52 | spaller | 1 | 69583 | 6 | 1.390 | 50059.7 |
605 | 2020-01-31 20:09:18 | spaller | 1 | 69583 | 6 | 2.796 | 24886.6 |
604 | 2020-01-29 18:00:06 | spaller | 1 | 69583 | 6 | 1.406 | 49490.0 |
603 | 2020-01-24 16:19:08 | spaller | 1 | 69583 | 6 | 2.923 | 23805.3 |
602 | 2020-01-15 07:13:12 | spaller | 1 | 69583 | 6 | 1.296 | 53690.6 |
601 | 2020-01-14 23:31:25 | spaller | 1 | 69583 | 6 | 1.593 | 43680.5 |
600 | 2020-01-12 03:16:57 | spaller | 1 | 69583 | 6 | 2.190 | 31773.1 |
599 | 2020-01-04 22:15:51 | spaller | 1 | 69583 | 6 | 2.563 | 27149.0 |
598 | 2019-12-30 09:39:28 | spaller | 1 | 69583 | 6 | 1.330 | 52318.0 |
597 | 2019-12-27 04:12:37 | spaller | 1 | 69583 | 6 | 1.313 | 52995.4 |
596 | 2019-12-27 03:01:19 | spaller | 1 | 69583 | 6 | 1.326 | 52475.9 |
595 | 2019-12-26 15:24:59 | spaller | 1 | 69583 | 6 | 1.123 | 61961.7 |
594 | 2019-12-07 22:33:55 | spaller | 1 | 69583 | 6 | 1.110 | 62687.4 |
593 | 2019-11-12 22:04:16 | spaller | 1 | 69583 | 6 | 1.220 | 57035.2 |
592 | 2019-09-20 09:19:24 | spaller | 3 | 134027 | 709 | 6.053 | 22142.2 |
591 | 2019-09-18 23:48:09 | spaller | 1 | 69583 | 6 | 1.023 | 68018.6 |
590 | 2019-08-21 18:05:55 | spaller | 3 | 134027 | 709 | 6.250 | 21444.3 |
589 | 2019-08-11 14:15:13 | spaller | 1 | 69583 | 6 | 1.060 | 65644.3 |
588 | 2019-05-11 19:06:32 | spaller | 1 | 69583 | 6 | 1.223 | 56895.3 |
587 | 2019-04-28 15:16:02 | spaller | 3 | 134027 | 709 | 13.866 | 9665.9 |
586 | 2019-04-28 13:56:41 | spaller | 3 | 134027 | 709 | 6.813 | 19672.2 |
585 | 2019-04-22 04:53:46 | spaller | 3 | 134027 | 709 | 6.130 | 21864.1 |
584 | 2019-04-18 08:30:45 | spaller | 3 | 134027 | 709 | 6.836 | 19606.1 |
583 | 2019-04-10 15:39:47 | spaller | 3 | 134027 | 709 | 12.556 | 10674.3 |