History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"craft"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
664 | 2024-04-09 16:57:38 | craft | 1 | 28756 | 8 | 0.466 | 61708.2 |
663 | 2024-04-08 22:16:52 | craft | 1 | 28756 | 8 | 1.233 | 23322.0 |
662 | 2024-04-05 18:57:46 | craft | 2 | 53800 | 100 | 3.796 | 14172.8 |
661 | 2024-04-05 18:54:56 | craft | 1 | 28756 | 8 | 0.530 | 54256.6 |
660 | 2024-04-05 17:21:08 | craft | 3 | 83667 | 1063 | 10.593 | 7898.3 |
659 | 2024-04-05 05:46:32 | craft | 3 | 83667 | 1063 | 12.796 | 6538.5 |
658 | 2024-04-05 05:26:09 | craft | 3 | 83667 | 1063 | 15.376 | 5441.4 |
657 | 2024-03-31 08:08:31 | craft | 3 | 83667 | 1063 | 13.736 | 6091.1 |
656 | 2024-03-31 08:08:30 | craft | 2 | 53800 | 100 | 5.560 | 9676.3 |
655 | 2024-03-31 08:05:31 | craft | 1 | 28756 | 8 | 1.063 | 27051.7 |
654 | 2024-03-29 02:24:35 | craft | 1 | 28756 | 8 | 0.500 | 57512.0 |
653 | 2024-03-06 04:00:29 | craft | 3 | 83667 | 1063 | 12.250 | 6830.0 |
652 | 2024-03-05 17:51:05 | craft | 3 | 83667 | 1063 | 9.123 | 9171.0 |
651 | 2024-03-04 23:22:44 | craft | 2 | 53800 | 100 | 1.766 | 30464.3 |
650 | 2024-03-04 23:22:42 | craft | 1 | 28756 | 8 | 0.516 | 55728.7 |
649 | 2024-03-04 23:22:09 | craft | 3 | 83667 | 1063 | 6.890 | 12143.3 |
648 | 2024-03-04 18:36:24 | craft | 3 | 83667 | 1063 | 9.096 | 9198.2 |
647 | 2024-03-04 18:36:24 | craft | 2 | 53800 | 100 | 1.966 | 27365.2 |
646 | 2024-03-04 18:17:02 | craft | 1 | 28756 | 8 | 0.530 | 54256.6 |
645 | 2024-02-27 20:21:19 | craft | 1 | 28756 | 8 | 0.893 | 32201.6 |
644 | 2024-02-27 02:49:14 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
643 | 2024-02-24 00:28:33 | craft | 1 | 28756 | 8 | 0.576 | 49923.6 |
642 | 2024-02-18 00:25:15 | craft | 1 | 28756 | 8 | 1.126 | 25538.2 |
641 | 2024-02-06 02:44:26 | craft | 1 | 28756 | 8 | 1.016 | 28303.1 |
640 | 2024-02-03 17:38:27 | craft | 1 | 28756 | 8 | 0.486 | 59168.7 |
639 | 2024-01-28 22:30:59 | craft | 1 | 28756 | 8 | 0.483 | 59536.2 |
638 | 2024-01-28 20:17:17 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
637 | 2024-01-07 07:34:14 | craft | 3 | 83667 | 1063 | 3.390 | 24680.5 |
636 | 2024-01-07 07:34:13 | craft | 2 | 53800 | 100 | 1.500 | 35866.7 |
635 | 2024-01-06 21:25:20 | craft | 1 | 28756 | 8 | 0.500 | 57512.0 |
634 | 2024-01-04 15:39:38 | craft | 2 | 53800 | 100 | 1.546 | 34799.5 |
633 | 2024-01-04 15:39:31 | craft | 3 | 83667 | 1063 | 3.796 | 22040.8 |
632 | 2023-12-30 03:10:27 | craft | 3 | 83667 | 1063 | 3.733 | 22412.8 |
631 | 2023-12-28 10:16:32 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
630 | 2023-12-26 21:48:25 | craft | 3 | 83667 | 1063 | 5.563 | 15039.9 |
629 | 2023-12-22 12:48:02 | craft | 2 | 53800 | 100 | 1.406 | 38264.6 |
628 | 2023-12-22 12:47:55 | craft | 3 | 83667 | 1063 | 3.436 | 24350.1 |
627 | 2023-12-22 00:34:35 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
626 | 2023-11-15 22:46:54 | craft | 1 | 28756 | 8 | 0.420 | 68466.7 |
625 | 2023-11-15 14:52:09 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
624 | 2023-11-14 00:10:35 | craft | 1 | 28756 | 8 | 0.500 | 57512.0 |
623 | 2023-11-12 07:40:26 | craft | 1 | 28756 | 8 | 1.063 | 27051.7 |
622 | 2023-11-02 08:31:17 | craft | 1 | 28756 | 8 | 1.126 | 25538.2 |
621 | 2023-10-31 09:48:57 | craft | 1 | 28756 | 8 | 0.500 | 57512.0 |
620 | 2023-10-24 22:34:58 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
619 | 2023-10-17 01:38:49 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
618 | 2023-10-14 23:20:11 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
617 | 2023-10-05 02:36:22 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
616 | 2023-09-26 06:19:49 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
615 | 2023-09-25 21:13:39 | craft | 1 | 28756 | 8 | 0.516 | 55728.7 |
614 | 2023-08-12 13:16:45 | craft | 1 | 28756 | 8 | 0.440 | 65354.5 |
613 | 2023-08-02 11:06:54 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
612 | 2023-07-19 03:48:25 | craft | 1 | 28756 | 8 | 0.500 | 57512.0 |
611 | 2023-07-08 15:21:26 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
610 | 2023-05-14 23:16:25 | craft | 1 | 28756 | 8 | 0.470 | 61183.0 |
609 | 2023-04-25 01:21:22 | craft | 1 | 28756 | 8 | 0.483 | 59536.2 |
608 | 2023-03-31 12:54:04 | craft | 1 | 28756 | 8 | 0.500 | 57512.0 |
607 | 2023-03-08 19:09:55 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
606 | 2023-01-08 22:49:29 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
605 | 2022-12-30 12:35:23 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
604 | 2022-09-21 13:17:37 | craft | 1 | 28756 | 8 | 0.450 | 63902.2 |
603 | 2022-09-19 11:46:06 | craft | 1 | 28756 | 8 | 0.486 | 59168.7 |
602 | 2022-06-09 04:06:41 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
601 | 2022-06-08 03:45:49 | craft | 1 | 28756 | 8 | 0.440 | 65354.5 |
600 | 2022-06-08 01:11:43 | craft | 1 | 28756 | 8 | 0.513 | 56054.6 |
599 | 2022-06-07 02:00:08 | craft | 1 | 28756 | 8 | 0.513 | 56054.6 |
598 | 2022-04-29 05:48:07 | craft | 1 | 28756 | 8 | 0.436 | 65954.1 |
597 | 2022-02-28 03:48:14 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
596 | 2022-01-20 11:43:52 | craft | 1 | 28756 | 8 | 0.516 | 55728.7 |
595 | 2021-11-23 08:04:04 | craft | 1 | 28756 | 8 | 0.516 | 55728.7 |
594 | 2021-11-20 05:04:04 | craft | 1 | 28756 | 8 | 0.453 | 63479.0 |
593 | 2021-10-24 12:18:57 | craft | 1 | 28756 | 8 | 0.483 | 59536.2 |
592 | 2021-10-22 11:24:53 | craft | 1 | 28756 | 8 | 0.470 | 61183.0 |
591 | 2021-09-03 15:51:05 | craft | 3 | 83667 | 1063 | 3.970 | 21074.8 |
590 | 2021-08-26 14:59:56 | craft | 3 | 83667 | 1063 | 3.593 | 23286.1 |
589 | 2021-08-17 00:35:25 | craft | 1 | 28756 | 8 | 0.970 | 29645.4 |
588 | 2021-08-05 09:38:55 | craft | 3 | 83667 | 1063 | 4.046 | 20678.9 |
587 | 2021-07-31 13:23:14 | craft | 3 | 83667 | 1063 | 3.296 | 25384.4 |
586 | 2021-07-02 15:24:14 | craft | 3 | 83667 | 1063 | 4.016 | 20833.4 |
585 | 2021-06-30 12:21:28 | craft | 1 | 28756 | 8 | 0.500 | 57512.0 |
584 | 2021-06-28 01:20:14 | craft | 3 | 83667 | 1063 | 4.016 | 20833.4 |
583 | 2021-06-26 07:08:06 | craft | 3 | 83667 | 1063 | 3.343 | 25027.5 |
582 | 2021-06-25 21:22:30 | craft | 3 | 83667 | 1063 | 3.313 | 25254.2 |
581 | 2021-06-24 20:30:35 | craft | 3 | 83667 | 1063 | 8.563 | 9770.8 |
580 | 2021-06-23 05:22:37 | craft | 3 | 83667 | 1063 | 4.156 | 20131.6 |
579 | 2021-06-20 01:03:13 | craft | 2 | 53800 | 100 | 1.610 | 33416.1 |
578 | 2021-06-19 03:14:59 | craft | 3 | 83667 | 1063 | 6.736 | 12420.9 |
577 | 2021-05-30 10:07:50 | craft | 1 | 28756 | 8 | 0.516 | 55728.7 |
576 | 2021-05-16 08:24:09 | craft | 1 | 28756 | 8 | 0.470 | 61183.0 |
575 | 2021-05-13 00:36:25 | craft | 3 | 83667 | 1063 | 3.330 | 25125.2 |
574 | 2021-05-12 23:40:20 | craft | 1 | 28756 | 8 | 0.530 | 54256.6 |
573 | 2021-05-12 05:19:01 | craft | 3 | 83667 | 1063 | 4.093 | 20441.5 |
572 | 2021-05-05 02:46:37 | craft | 1 | 28756 | 8 | 0.516 | 55728.7 |
571 | 2021-04-30 23:00:35 | craft | 3 | 83667 | 1063 | 8.450 | 9901.4 |
570 | 2021-04-24 08:01:19 | craft | 3 | 83667 | 1063 | 5.046 | 16580.9 |
569 | 2021-04-18 03:33:27 | craft | 3 | 83667 | 1063 | 3.906 | 21420.1 |
568 | 2021-04-17 09:17:42 | craft | 3 | 83667 | 1063 | 6.970 | 12003.9 |
567 | 2021-04-10 05:49:39 | craft | 3 | 83667 | 1063 | 3.906 | 21420.1 |
566 | 2021-04-08 20:39:45 | craft | 3 | 83667 | 1063 | 3.470 | 24111.5 |
565 | 2021-04-05 01:06:44 | craft | 3 | 83667 | 1063 | 3.876 | 21585.9 |