History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spruce"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
679 | 2024-04-06 02:26:04 | spruce | 1 | 48755 | 6 | 1.640 | 29728.7 |
678 | 2024-03-31 17:55:58 | spruce | 1 | 48755 | 6 | 2.093 | 23294.3 |
677 | 2024-03-30 20:39:48 | spruce | 3 | 112716 | 400 | 24.236 | 4650.8 |
676 | 2024-03-30 01:08:54 | spruce | 3 | 112716 | 400 | 20.410 | 5522.6 |
675 | 2024-03-29 21:35:37 | spruce | 3 | 112716 | 400 | 6.423 | 17548.8 |
674 | 2024-03-28 00:36:21 | spruce | 1 | 48755 | 6 | 0.876 | 55656.4 |
673 | 2024-03-10 08:48:16 | spruce | 3 | 112716 | 400 | 10.830 | 10407.8 |
672 | 2024-03-08 22:53:25 | spruce | 3 | 112716 | 400 | 10.283 | 10961.4 |
671 | 2024-03-07 13:56:05 | spruce | 3 | 112716 | 400 | 10.596 | 10637.6 |
670 | 2024-03-06 21:46:38 | spruce | 3 | 112716 | 400 | 17.346 | 6498.1 |
669 | 2024-03-06 21:46:38 | spruce | 2 | 82551 | 33 | 5.970 | 13827.6 |
668 | 2024-03-06 21:04:34 | spruce | 1 | 48755 | 6 | 1.750 | 27860.0 |
667 | 2024-03-03 23:52:54 | spruce | 1 | 48755 | 6 | 2.860 | 17047.2 |
666 | 2024-02-28 16:52:55 | spruce | 1 | 48755 | 6 | 5.313 | 9176.5 |
665 | 2024-01-17 16:05:46 | spruce | 3 | 112716 | 400 | 4.953 | 22757.1 |
664 | 2024-01-15 09:54:42 | spruce | 2 | 82551 | 33 | 2.156 | 38289.0 |
663 | 2024-01-12 22:38:32 | spruce | 3 | 112716 | 400 | 7.080 | 15920.3 |
662 | 2023-12-28 15:17:53 | spruce | 1 | 48755 | 6 | 0.953 | 51159.5 |
661 | 2023-12-21 00:30:05 | spruce | 1 | 48755 | 6 | 0.780 | 62506.4 |
660 | 2023-12-01 01:48:15 | spruce | 3 | 112716 | 400 | 5.126 | 21989.1 |
659 | 2023-11-26 08:08:52 | spruce | 1 | 48755 | 6 | 0.843 | 57835.1 |
658 | 2023-11-18 23:55:47 | spruce | 3 | 112716 | 400 | 4.750 | 23729.7 |
657 | 2023-11-18 23:55:41 | spruce | 2 | 82551 | 33 | 2.123 | 38884.1 |
656 | 2023-11-17 02:51:20 | spruce | 1 | 48755 | 6 | 0.780 | 62506.4 |
655 | 2023-10-21 13:47:30 | spruce | 1 | 48755 | 6 | 0.826 | 59025.4 |
654 | 2023-10-20 04:17:08 | spruce | 1 | 48755 | 6 | 0.750 | 65006.7 |
653 | 2023-10-19 22:36:28 | spruce | 1 | 48755 | 6 | 1.643 | 29674.4 |
652 | 2023-10-13 19:00:59 | spruce | 1 | 48755 | 6 | 0.750 | 65006.7 |
651 | 2023-10-08 02:46:45 | spruce | 1 | 48755 | 6 | 1.720 | 28345.9 |
650 | 2023-09-27 16:24:03 | spruce | 3 | 112716 | 400 | 6.483 | 17386.4 |
649 | 2023-09-26 19:24:10 | spruce | 1 | 48755 | 6 | 0.763 | 63899.1 |
648 | 2023-09-23 21:13:31 | spruce | 1 | 48755 | 6 | 1.576 | 30935.9 |
647 | 2023-09-17 10:44:39 | spruce | 3 | 112716 | 400 | 4.766 | 23650.0 |
646 | 2023-08-30 02:26:19 | spruce | 3 | 112716 | 400 | 8.436 | 13361.3 |
645 | 2023-08-11 11:41:33 | spruce | 3 | 112716 | 400 | 5.310 | 21227.1 |
644 | 2023-08-04 03:46:06 | spruce | 1 | 48755 | 6 | 0.783 | 62266.9 |
643 | 2023-06-23 04:26:28 | spruce | 3 | 112716 | 400 | 5.283 | 21335.6 |
642 | 2023-06-12 13:18:03 | spruce | 1 | 48755 | 6 | 0.860 | 56691.9 |
641 | 2023-05-16 19:29:53 | spruce | 3 | 112716 | 400 | 4.563 | 24702.2 |
640 | 2023-05-07 15:45:09 | spruce | 3 | 112716 | 400 | 4.970 | 22679.3 |
639 | 2023-04-28 17:01:54 | spruce | 1 | 48755 | 6 | 0.766 | 63648.8 |
638 | 2023-04-12 11:18:20 | spruce | 3 | 112716 | 400 | 4.826 | 23356.0 |
637 | 2023-03-28 01:40:22 | spruce | 3 | 112716 | 400 | 4.733 | 23814.9 |
636 | 2023-03-17 16:33:13 | spruce | 3 | 112716 | 400 | 4.593 | 24540.8 |
635 | 2023-02-22 14:44:36 | spruce | 3 | 112716 | 400 | 4.640 | 24292.2 |
634 | 2023-02-17 21:22:10 | spruce | 1 | 48755 | 6 | 0.860 | 56691.9 |
633 | 2023-02-14 07:37:02 | spruce | 1 | 48755 | 6 | 0.750 | 65006.7 |
632 | 2023-01-22 12:43:25 | spruce | 3 | 112716 | 400 | 4.780 | 23580.8 |
631 | 2023-01-14 13:22:45 | spruce | 3 | 112716 | 400 | 10.720 | 10514.6 |
630 | 2022-12-29 21:42:30 | spruce | 3 | 112716 | 400 | 4.546 | 24794.5 |
629 | 2022-12-16 14:33:03 | spruce | 1 | 48755 | 6 | 0.733 | 66514.3 |
628 | 2022-12-03 04:14:19 | spruce | 3 | 112716 | 400 | 6.123 | 18408.6 |
627 | 2022-10-02 15:40:41 | spruce | 1 | 48755 | 6 | 0.750 | 65006.7 |
626 | 2022-08-23 21:07:32 | spruce | 1 | 48755 | 6 | 0.766 | 63648.8 |
625 | 2022-08-21 11:22:32 | spruce | 1 | 48755 | 6 | 0.750 | 65006.7 |
624 | 2022-07-14 18:39:54 | spruce | 3 | 112716 | 400 | 4.783 | 23566.0 |
623 | 2022-07-12 05:02:47 | spruce | 3 | 112716 | 400 | 6.000 | 18786.0 |
622 | 2022-07-07 18:55:53 | spruce | 3 | 112716 | 400 | 4.700 | 23982.1 |
621 | 2022-07-06 18:54:54 | spruce | 3 | 112716 | 400 | 4.673 | 24120.7 |
620 | 2022-07-05 18:54:12 | spruce | 3 | 112716 | 400 | 5.373 | 20978.2 |
619 | 2022-07-04 18:49:32 | spruce | 3 | 112716 | 400 | 4.733 | 23814.9 |
618 | 2022-07-03 18:50:33 | spruce | 3 | 112716 | 400 | 5.296 | 21283.2 |
617 | 2022-07-02 18:47:43 | spruce | 3 | 112716 | 400 | 4.656 | 24208.8 |
616 | 2022-07-01 18:43:01 | spruce | 3 | 112716 | 400 | 4.580 | 24610.5 |
615 | 2022-06-30 18:42:10 | spruce | 3 | 112716 | 400 | 4.626 | 24365.8 |
614 | 2022-06-29 18:40:52 | spruce | 3 | 112716 | 400 | 4.686 | 24053.8 |
613 | 2022-06-28 18:38:31 | spruce | 3 | 112716 | 400 | 4.610 | 24450.3 |
612 | 2022-06-27 18:36:01 | spruce | 3 | 112716 | 400 | 5.093 | 22131.6 |
611 | 2022-06-26 18:34:20 | spruce | 3 | 112716 | 400 | 5.690 | 19809.5 |
610 | 2022-06-25 18:31:39 | spruce | 3 | 112716 | 400 | 5.173 | 21789.3 |
609 | 2022-06-25 05:48:21 | spruce | 3 | 112716 | 400 | 4.890 | 23050.3 |
608 | 2022-06-24 18:29:29 | spruce | 3 | 112716 | 400 | 4.673 | 24120.7 |
607 | 2022-06-22 18:24:04 | spruce | 3 | 112716 | 400 | 4.860 | 23192.6 |
606 | 2022-06-21 18:21:03 | spruce | 3 | 112716 | 400 | 4.593 | 24540.8 |
605 | 2022-06-20 18:16:13 | spruce | 3 | 112716 | 400 | 4.733 | 23814.9 |
604 | 2022-06-19 17:55:05 | spruce | 3 | 112716 | 400 | 5.000 | 22543.2 |
603 | 2022-06-18 17:51:48 | spruce | 3 | 112716 | 400 | 5.436 | 20735.1 |
602 | 2022-06-13 18:49:08 | spruce | 3 | 112716 | 400 | 4.576 | 24632.0 |
601 | 2022-06-12 18:47:37 | spruce | 3 | 112716 | 400 | 5.326 | 21163.3 |
600 | 2022-06-11 18:43:58 | spruce | 3 | 112716 | 400 | 4.690 | 24033.3 |
599 | 2022-06-10 18:39:58 | spruce | 3 | 112716 | 400 | 4.593 | 24540.8 |
598 | 2022-06-09 18:39:10 | spruce | 3 | 112716 | 400 | 6.626 | 17011.2 |
597 | 2022-06-08 18:38:30 | spruce | 3 | 112716 | 400 | 5.343 | 21096.0 |
596 | 2022-06-07 18:36:30 | spruce | 3 | 112716 | 400 | 4.623 | 24381.6 |
595 | 2022-06-07 07:48:45 | spruce | 1 | 48755 | 6 | 0.766 | 63648.8 |
594 | 2022-06-06 18:35:31 | spruce | 3 | 112716 | 400 | 5.733 | 19660.9 |
593 | 2022-05-29 10:05:56 | spruce | 1 | 48755 | 6 | 0.736 | 66243.2 |
592 | 2022-05-25 15:48:17 | spruce | 3 | 112716 | 400 | 4.796 | 23502.1 |
591 | 2022-05-24 19:36:48 | spruce | 3 | 112716 | 400 | 5.330 | 21147.5 |
590 | 2022-05-21 14:41:55 | spruce | 3 | 112716 | 400 | 4.766 | 23650.0 |
589 | 2022-05-20 17:38:45 | spruce | 3 | 112716 | 400 | 4.640 | 24292.2 |
588 | 2022-05-19 19:57:06 | spruce | 3 | 112716 | 400 | 6.906 | 16321.5 |
587 | 2022-05-17 23:17:27 | spruce | 3 | 112716 | 400 | 10.406 | 10831.8 |
586 | 2022-05-16 22:34:11 | spruce | 3 | 112716 | 400 | 6.253 | 18025.9 |
585 | 2022-05-15 18:29:54 | spruce | 3 | 112716 | 400 | 5.406 | 20850.2 |
584 | 2022-05-13 19:17:09 | spruce | 3 | 112716 | 400 | 5.533 | 20371.6 |
583 | 2022-05-07 15:44:14 | spruce | 3 | 112716 | 400 | 5.313 | 21215.1 |
582 | 2022-05-07 09:33:37 | spruce | 3 | 112716 | 400 | 4.656 | 24208.8 |
581 | 2022-04-11 03:14:39 | spruce | 1 | 48755 | 6 | 0.763 | 63899.1 |
580 | 2022-04-05 01:30:38 | spruce | 3 | 112716 | 400 | 5.923 | 19030.2 |