History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lorry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
718 | 2024-04-24 20:54:46 | lorry | 2 | 53800 | 99 | 5.390 | 9981.4 |
717 | 2024-04-24 20:54:43 | lorry | 3 | 83667 | 1168 | 5.406 | 15476.7 |
716 | 2024-04-03 04:52:19 | lorry | 1 | 28756 | 5 | 1.343 | 21411.8 |
715 | 2024-03-31 03:20:33 | lorry | 1 | 28756 | 5 | 0.530 | 54256.6 |
714 | 2024-03-29 19:04:18 | lorry | 2 | 53800 | 99 | 1.750 | 30742.9 |
713 | 2024-03-29 19:03:47 | lorry | 3 | 83667 | 1168 | 4.560 | 18348.0 |
712 | 2024-03-29 08:33:03 | lorry | 3 | 83667 | 1168 | 7.843 | 10667.7 |
711 | 2024-03-29 08:33:02 | lorry | 2 | 53800 | 99 | 3.890 | 13830.3 |
710 | 2024-03-29 08:14:54 | lorry | 1 | 28756 | 5 | 1.140 | 25224.6 |
709 | 2024-03-20 18:20:49 | lorry | 2 | 53800 | 99 | 1.736 | 30990.8 |
708 | 2024-03-20 18:20:44 | lorry | 3 | 83667 | 1168 | 4.266 | 19612.5 |
707 | 2024-03-20 18:20:25 | lorry | 1 | 28756 | 5 | 0.513 | 56054.6 |
706 | 2024-03-20 18:19:56 | lorry | 2 | 53800 | 99 | 3.093 | 17394.1 |
705 | 2024-03-20 18:19:51 | lorry | 3 | 83667 | 1168 | 5.326 | 15709.2 |
704 | 2024-03-17 05:51:18 | lorry | 1 | 28756 | 5 | 0.420 | 68466.7 |
703 | 2024-02-29 17:14:04 | lorry | 1 | 28756 | 5 | 0.500 | 57512.0 |
702 | 2024-02-28 02:26:29 | lorry | 1 | 28756 | 5 | 0.516 | 55728.7 |
701 | 2024-02-19 01:11:18 | lorry | 3 | 83667 | 1168 | 8.390 | 9972.2 |
700 | 2024-02-18 06:35:23 | lorry | 3 | 83667 | 1168 | 13.610 | 6147.5 |
699 | 2024-02-18 06:35:23 | lorry | 2 | 53800 | 99 | 1.830 | 29398.9 |
698 | 2024-01-28 22:04:33 | lorry | 1 | 28756 | 5 | 0.516 | 55728.7 |
697 | 2024-01-18 04:03:06 | lorry | 3 | 83667 | 1168 | 4.610 | 18149.0 |
696 | 2024-01-10 04:14:18 | lorry | 2 | 53800 | 99 | 1.420 | 37887.3 |
695 | 2024-01-04 03:29:27 | lorry | 1 | 28756 | 5 | 0.516 | 55728.7 |
694 | 2023-12-29 00:27:51 | lorry | 2 | 53800 | 99 | 1.563 | 34421.0 |
693 | 2023-12-25 12:11:30 | lorry | 3 | 83667 | 1168 | 3.500 | 23904.9 |
692 | 2023-12-20 20:15:35 | lorry | 3 | 83667 | 1168 | 3.796 | 22040.8 |
691 | 2023-12-20 20:15:33 | lorry | 2 | 53800 | 99 | 1.500 | 35866.7 |
690 | 2023-12-16 19:56:29 | lorry | 1 | 28756 | 5 | 0.466 | 61708.2 |
689 | 2023-11-27 21:40:30 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
688 | 2023-11-25 01:18:38 | lorry | 1 | 28756 | 5 | 0.513 | 56054.6 |
687 | 2023-11-17 10:07:20 | lorry | 3 | 83667 | 1168 | 3.783 | 22116.6 |
686 | 2023-11-13 23:08:52 | lorry | 1 | 28756 | 5 | 0.436 | 65954.1 |
685 | 2023-11-13 11:10:02 | lorry | 2 | 53800 | 99 | 1.533 | 35094.6 |
684 | 2023-11-13 11:09:41 | lorry | 3 | 83667 | 1168 | 3.346 | 25005.1 |
683 | 2023-11-12 01:45:31 | lorry | 1 | 28756 | 5 | 0.436 | 65954.1 |
682 | 2023-11-04 02:16:03 | lorry | 1 | 28756 | 5 | 0.516 | 55728.7 |
681 | 2023-10-21 09:28:13 | lorry | 1 | 28756 | 5 | 0.486 | 59168.7 |
680 | 2023-10-19 05:10:34 | lorry | 1 | 28756 | 5 | 0.486 | 59168.7 |
679 | 2023-10-18 03:34:06 | lorry | 2 | 53800 | 99 | 1.390 | 38705.0 |
678 | 2023-10-13 14:07:37 | lorry | 1 | 28756 | 5 | 0.500 | 57512.0 |
677 | 2023-10-04 06:36:31 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
676 | 2023-09-30 12:43:05 | lorry | 1 | 28756 | 5 | 0.483 | 59536.2 |
675 | 2023-09-21 00:15:45 | lorry | 1 | 28756 | 5 | 0.470 | 61183.0 |
674 | 2023-09-13 11:55:24 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
673 | 2023-08-01 00:12:09 | lorry | 1 | 28756 | 5 | 0.500 | 57512.0 |
672 | 2023-07-28 21:46:26 | lorry | 2 | 53800 | 99 | 1.656 | 32487.9 |
671 | 2023-07-26 18:07:29 | lorry | 1 | 28756 | 5 | 1.046 | 27491.4 |
670 | 2023-04-23 02:53:24 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
669 | 2023-04-16 06:33:51 | lorry | 1 | 28756 | 5 | 0.533 | 53951.2 |
668 | 2023-04-08 00:25:09 | lorry | 2 | 53800 | 99 | 1.643 | 32745.0 |
667 | 2023-02-13 14:47:16 | lorry | 1 | 28756 | 5 | 0.983 | 29253.3 |
666 | 2023-01-11 22:59:10 | lorry | 2 | 53800 | 99 | 1.626 | 33087.3 |
665 | 2023-01-05 07:44:41 | lorry | 2 | 53800 | 99 | 1.373 | 39184.3 |
664 | 2023-01-03 00:16:16 | lorry | 1 | 28756 | 5 | 0.483 | 59536.2 |
663 | 2022-12-27 07:26:50 | lorry | 1 | 28756 | 5 | 0.436 | 65954.1 |
662 | 2022-12-10 12:01:27 | lorry | 1 | 28756 | 5 | 0.500 | 57512.0 |
661 | 2022-12-10 03:24:47 | lorry | 2 | 53800 | 99 | 1.376 | 39098.8 |
660 | 2022-11-16 07:36:39 | lorry | 2 | 53800 | 99 | 1.546 | 34799.5 |
659 | 2022-09-18 04:52:58 | lorry | 1 | 28756 | 5 | 0.466 | 61708.2 |
658 | 2022-09-11 03:10:29 | lorry | 2 | 53800 | 99 | 1.656 | 32487.9 |
657 | 2022-08-23 10:29:28 | lorry | 1 | 28756 | 5 | 0.500 | 57512.0 |
656 | 2022-08-12 18:44:24 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
655 | 2022-08-07 11:31:43 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
654 | 2022-08-07 00:53:24 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
653 | 2022-06-25 17:20:43 | lorry | 1 | 28756 | 5 | 0.953 | 30174.2 |
652 | 2022-04-19 08:10:23 | lorry | 1 | 28756 | 5 | 0.623 | 46157.3 |
651 | 2022-04-06 03:00:36 | lorry | 1 | 28756 | 5 | 0.610 | 47141.0 |
650 | 2022-03-05 23:41:43 | lorry | 1 | 28756 | 5 | 0.483 | 59536.2 |
649 | 2022-01-11 23:19:04 | lorry | 1 | 28756 | 5 | 0.560 | 51350.0 |
648 | 2022-01-09 19:32:24 | lorry | 1 | 28756 | 5 | 0.516 | 55728.7 |
647 | 2021-11-10 01:26:46 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
646 | 2021-10-01 20:33:20 | lorry | 1 | 28756 | 5 | 0.436 | 65954.1 |
645 | 2021-09-30 09:43:02 | lorry | 1 | 28756 | 5 | 0.436 | 65954.1 |
644 | 2021-09-29 17:12:47 | lorry | 1 | 28756 | 5 | 0.843 | 34111.5 |
643 | 2021-09-12 15:40:21 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
642 | 2021-07-28 16:17:42 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
641 | 2021-07-01 00:11:58 | lorry | 1 | 28756 | 5 | 0.466 | 61708.2 |
640 | 2021-06-20 22:42:27 | lorry | 2 | 53800 | 99 | 1.376 | 39098.8 |
639 | 2021-05-20 04:25:05 | lorry | 1 | 28756 | 5 | 0.466 | 61708.2 |
638 | 2021-04-01 10:05:35 | lorry | 2 | 53800 | 99 | 1.860 | 28924.7 |
637 | 2021-03-30 23:42:19 | lorry | 1 | 28756 | 5 | 0.546 | 52666.7 |
636 | 2021-03-06 02:58:22 | lorry | 2 | 53800 | 99 | 1.376 | 39098.8 |
635 | 2021-02-17 08:42:47 | lorry | 3 | 83667 | 1168 | 3.406 | 24564.6 |
634 | 2021-02-01 10:10:52 | lorry | 1 | 28756 | 5 | 0.500 | 57512.0 |
633 | 2021-01-04 22:53:08 | lorry | 1 | 28756 | 5 | 0.470 | 61183.0 |
632 | 2020-12-26 13:50:14 | lorry | 1 | 28756 | 5 | 0.486 | 59168.7 |
631 | 2020-11-14 19:01:18 | lorry | 3 | 83667 | 1168 | 3.360 | 24900.9 |
630 | 2020-11-01 12:51:29 | lorry | 1 | 28756 | 5 | 0.533 | 53951.2 |
629 | 2020-10-29 05:10:32 | lorry | 3 | 83667 | 1168 | 3.830 | 21845.2 |
628 | 2020-10-27 22:38:42 | lorry | 2 | 53800 | 99 | 1.390 | 38705.0 |
627 | 2020-10-12 19:48:09 | lorry | 1 | 28756 | 5 | 0.533 | 53951.2 |
626 | 2020-09-25 18:15:44 | lorry | 1 | 28756 | 5 | 0.436 | 65954.1 |
625 | 2020-09-22 20:55:04 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
624 | 2020-08-28 02:21:47 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
623 | 2020-08-23 04:33:56 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
622 | 2020-06-08 22:11:25 | lorry | 1 | 28756 | 5 | 0.453 | 63479.0 |
621 | 2020-06-05 23:54:34 | lorry | 1 | 28756 | 5 | 0.470 | 61183.0 |
620 | 2020-05-26 12:58:35 | lorry | 1 | 28756 | 5 | 0.436 | 65954.1 |
619 | 2020-04-16 20:33:23 | lorry | 3 | 83667 | 1168 | 3.453 | 24230.2 |