History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piggie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
668 | 2024-05-07 08:36:15 | piggie | 2 | 82551 | 34 | 2.140 | 38575.2 |
667 | 2024-05-06 16:39:47 | piggie | 2 | 82551 | 34 | 4.890 | 16881.6 |
666 | 2024-05-02 04:25:58 | piggie | 2 | 82551 | 34 | 2.813 | 29346.2 |
665 | 2024-05-02 04:25:06 | piggie | 3 | 112716 | 375 | 5.796 | 19447.2 |
664 | 2024-05-01 23:04:06 | piggie | 2 | 82551 | 34 | 2.813 | 29346.2 |
663 | 2024-05-01 23:02:15 | piggie | 3 | 112716 | 375 | 15.423 | 7308.3 |
662 | 2024-05-01 23:02:18 | piggie | 2 | 82551 | 34 | 3.436 | 24025.3 |
661 | 2024-05-01 23:02:07 | piggie | 1 | 48755 | 5 | 2.546 | 19149.6 |
660 | 2024-05-01 23:01:48 | piggie | 3 | 112716 | 375 | 6.436 | 17513.4 |
659 | 2024-05-01 18:56:33 | piggie | 3 | 112716 | 375 | 18.766 | 6006.4 |
658 | 2024-05-01 12:37:43 | piggie | 3 | 112716 | 375 | 9.330 | 12081.0 |
657 | 2024-05-01 07:58:07 | piggie | 3 | 112716 | 375 | 17.500 | 6440.9 |
656 | 2024-04-29 15:27:26 | piggie | 1 | 48755 | 5 | 0.860 | 56691.9 |
655 | 2024-04-16 02:42:40 | piggie | 1 | 48755 | 5 | 2.266 | 21515.9 |
654 | 2024-04-12 11:28:35 | piggie | 1 | 48755 | 5 | 1.920 | 25393.2 |
653 | 2024-03-30 22:21:23 | piggie | 2 | 82551 | 34 | 5.030 | 16411.7 |
652 | 2024-03-30 22:20:40 | piggie | 3 | 112716 | 375 | 5.686 | 19823.4 |
651 | 2024-03-30 02:12:17 | piggie | 2 | 82551 | 34 | 6.750 | 12229.8 |
650 | 2024-03-30 01:18:19 | piggie | 3 | 112716 | 375 | 9.923 | 11359.1 |
649 | 2024-03-29 10:35:34 | piggie | 3 | 112716 | 375 | 7.733 | 14576.0 |
648 | 2024-03-29 10:35:35 | piggie | 2 | 82551 | 34 | 2.860 | 28864.0 |
647 | 2024-03-29 10:35:25 | piggie | 3 | 112716 | 375 | 7.220 | 15611.6 |
646 | 2024-03-29 10:35:29 | piggie | 1 | 48755 | 5 | 0.936 | 52088.7 |
645 | 2024-03-29 10:35:25 | piggie | 2 | 82551 | 34 | 2.983 | 27673.8 |
644 | 2024-03-29 10:35:19 | piggie | 1 | 48755 | 5 | 0.890 | 54780.9 |
643 | 2024-03-14 08:52:51 | piggie | 1 | 48755 | 5 | 0.860 | 56691.9 |
642 | 2024-02-29 17:56:01 | piggie | 1 | 48755 | 5 | 0.890 | 54780.9 |
641 | 2024-02-05 08:26:05 | piggie | 2 | 82551 | 34 | 2.673 | 30883.3 |
640 | 2024-01-31 09:34:23 | piggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
639 | 2024-01-26 18:15:08 | piggie | 1 | 48755 | 5 | 0.860 | 56691.9 |
638 | 2024-01-16 02:46:27 | piggie | 2 | 82551 | 34 | 2.143 | 38521.2 |
637 | 2024-01-13 23:30:38 | piggie | 3 | 112716 | 375 | 8.190 | 13762.6 |
636 | 2023-12-31 09:25:01 | piggie | 3 | 112716 | 375 | 4.720 | 23880.5 |
635 | 2023-12-29 09:40:05 | piggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
634 | 2023-12-25 15:32:51 | piggie | 2 | 82551 | 34 | 2.203 | 37472.1 |
633 | 2023-12-22 21:23:28 | piggie | 3 | 112716 | 375 | 5.143 | 21916.4 |
632 | 2023-12-21 20:54:02 | piggie | 2 | 82551 | 34 | 2.966 | 27832.4 |
631 | 2023-12-03 07:47:20 | piggie | 3 | 112716 | 375 | 7.220 | 15611.6 |
630 | 2023-12-02 14:03:41 | piggie | 3 | 112716 | 375 | 8.330 | 13531.3 |
629 | 2023-12-02 14:03:46 | piggie | 2 | 82551 | 34 | 2.423 | 34069.7 |
628 | 2023-11-26 17:30:07 | piggie | 1 | 48755 | 5 | 0.780 | 62506.4 |
627 | 2023-11-17 02:39:19 | piggie | 1 | 48755 | 5 | 0.813 | 59969.2 |
626 | 2023-11-13 09:35:08 | piggie | 1 | 48755 | 5 | 0.826 | 59025.4 |
625 | 2023-11-12 07:55:14 | piggie | 2 | 82551 | 34 | 2.143 | 38521.2 |
624 | 2023-11-08 20:51:25 | piggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
623 | 2023-11-06 20:04:59 | piggie | 1 | 48755 | 5 | 0.766 | 63648.8 |
622 | 2023-10-22 06:12:41 | piggie | 1 | 48755 | 5 | 0.780 | 62506.4 |
621 | 2023-10-22 04:03:03 | piggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
620 | 2023-10-19 00:29:25 | piggie | 1 | 48755 | 5 | 0.763 | 63899.1 |
619 | 2023-10-13 17:28:54 | piggie | 1 | 48755 | 5 | 0.813 | 59969.2 |
618 | 2023-10-06 16:23:43 | piggie | 3 | 112716 | 375 | 5.546 | 20323.8 |
617 | 2023-10-05 05:24:44 | piggie | 1 | 48755 | 5 | 0.830 | 58741.0 |
616 | 2023-09-29 22:47:12 | piggie | 3 | 112716 | 375 | 5.736 | 19650.6 |
615 | 2023-09-27 07:16:37 | piggie | 2 | 82551 | 34 | 2.110 | 39123.7 |
614 | 2023-09-24 19:01:45 | piggie | 3 | 112716 | 375 | 5.236 | 21527.1 |
613 | 2023-09-23 03:39:00 | piggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
612 | 2023-09-12 19:09:42 | piggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
611 | 2023-09-12 00:41:07 | piggie | 3 | 112716 | 375 | 5.986 | 18829.9 |
610 | 2023-09-11 05:25:42 | piggie | 1 | 48755 | 5 | 0.826 | 59025.4 |
609 | 2023-08-22 18:55:22 | piggie | 3 | 112716 | 375 | 5.220 | 21593.1 |
608 | 2023-08-14 10:48:53 | piggie | 3 | 112716 | 375 | 4.703 | 23966.8 |
607 | 2023-08-14 07:11:19 | piggie | 2 | 82551 | 34 | 2.266 | 36430.3 |
606 | 2023-07-15 04:44:28 | piggie | 3 | 112716 | 375 | 5.093 | 22131.6 |
605 | 2023-07-06 02:25:09 | piggie | 3 | 112716 | 375 | 5.220 | 21593.1 |
604 | 2023-07-06 02:12:53 | piggie | 3 | 112716 | 375 | 4.513 | 24975.8 |
603 | 2023-07-01 13:56:33 | piggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
602 | 2023-06-18 18:09:51 | piggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
601 | 2023-05-30 19:15:15 | piggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
600 | 2023-05-22 02:58:11 | piggie | 3 | 112716 | 375 | 4.546 | 24794.5 |
599 | 2023-04-23 11:31:13 | piggie | 2 | 82551 | 34 | 2.110 | 39123.7 |
598 | 2023-04-21 11:47:21 | piggie | 1 | 48755 | 5 | 0.890 | 54780.9 |
597 | 2023-04-17 08:01:23 | piggie | 3 | 112716 | 375 | 5.203 | 21663.7 |
596 | 2023-04-02 00:17:58 | piggie | 1 | 48755 | 5 | 0.720 | 67715.3 |
595 | 2023-03-25 04:30:12 | piggie | 3 | 112716 | 375 | 4.513 | 24975.8 |
594 | 2023-03-15 06:26:26 | piggie | 1 | 48755 | 5 | 0.720 | 67715.3 |
593 | 2023-02-28 13:38:23 | piggie | 3 | 112716 | 375 | 4.486 | 25126.2 |
592 | 2023-01-30 05:28:49 | piggie | 2 | 82551 | 34 | 5.033 | 16401.9 |
591 | 2023-01-14 17:41:44 | piggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
590 | 2022-12-23 23:18:12 | piggie | 3 | 112716 | 375 | 4.516 | 24959.3 |
589 | 2022-11-20 08:23:11 | piggie | 1 | 48755 | 5 | 0.860 | 56691.9 |
588 | 2022-11-16 18:48:49 | piggie | 1 | 48755 | 5 | 0.876 | 55656.4 |
587 | 2022-11-13 00:09:43 | piggie | 2 | 82551 | 34 | 3.076 | 26837.1 |
586 | 2022-11-04 04:32:51 | piggie | 1 | 48755 | 5 | 0.846 | 57630.0 |
585 | 2022-09-01 11:39:07 | piggie | 1 | 48755 | 5 | 0.813 | 59969.2 |
584 | 2022-08-29 01:22:37 | piggie | 3 | 112716 | 375 | 5.126 | 21989.1 |
583 | 2022-08-25 12:48:06 | piggie | 3 | 112716 | 375 | 4.593 | 24540.8 |
582 | 2022-08-23 03:21:33 | piggie | 3 | 112716 | 375 | 4.623 | 24381.6 |
581 | 2022-07-20 06:07:37 | piggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
580 | 2022-06-23 16:26:37 | piggie | 1 | 48755 | 5 | 0.733 | 66514.3 |
579 | 2022-06-16 03:11:58 | piggie | 2 | 82551 | 34 | 2.170 | 38041.9 |
578 | 2022-06-13 22:03:00 | piggie | 2 | 82551 | 34 | 2.110 | 39123.7 |
577 | 2022-03-26 02:37:29 | piggie | 1 | 48755 | 5 | 0.750 | 65006.7 |
576 | 2022-02-28 21:15:22 | piggie | 1 | 48755 | 5 | 0.890 | 54780.9 |
575 | 2022-01-28 16:58:23 | piggie | 2 | 82551 | 34 | 2.250 | 36689.3 |
574 | 2021-12-22 00:42:05 | piggie | 1 | 48755 | 5 | 0.830 | 58741.0 |
573 | 2021-12-08 18:45:31 | piggie | 1 | 48755 | 5 | 1.016 | 47987.2 |
572 | 2021-11-19 20:13:50 | piggie | 2 | 82551 | 34 | 2.156 | 38289.0 |
571 | 2021-10-28 23:27:26 | piggie | 1 | 48755 | 5 | 0.923 | 52822.3 |
570 | 2021-09-19 09:32:51 | piggie | 1 | 48755 | 5 | 0.843 | 57835.1 |
569 | 2021-09-17 06:13:36 | piggie | 1 | 48755 | 5 | 0.920 | 52994.6 |