History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gannet"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
668 | 2024-04-20 21:03:17 | gannet | 1 | 48755 | 4 | 0.780 | 62506.4 |
667 | 2024-03-29 07:56:01 | gannet | 1 | 48755 | 4 | 2.326 | 20960.9 |
666 | 2024-03-14 17:37:44 | gannet | 2 | 82551 | 68 | 6.000 | 13758.5 |
665 | 2024-03-14 17:37:35 | gannet | 2 | 82551 | 68 | 3.046 | 27101.4 |
664 | 2024-02-26 08:18:02 | gannet | 1 | 48755 | 4 | 1.046 | 46610.9 |
663 | 2024-01-30 22:43:24 | gannet | 2 | 82551 | 68 | 2.500 | 33020.4 |
662 | 2024-01-30 22:42:59 | gannet | 3 | 112716 | 773 | 5.906 | 19085.0 |
661 | 2024-01-28 20:53:12 | gannet | 2 | 82551 | 68 | 2.250 | 36689.3 |
660 | 2024-01-28 20:52:43 | gannet | 3 | 112716 | 773 | 5.483 | 20557.4 |
659 | 2024-01-28 01:10:37 | gannet | 3 | 112716 | 773 | 4.656 | 24208.8 |
658 | 2024-01-16 05:32:04 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
657 | 2024-01-03 15:59:58 | gannet | 1 | 48755 | 4 | 0.873 | 55847.7 |
656 | 2023-12-23 05:53:30 | gannet | 3 | 112716 | 773 | 5.296 | 21283.2 |
655 | 2023-12-18 17:41:17 | gannet | 2 | 82551 | 68 | 2.346 | 35188.0 |
654 | 2023-11-28 04:27:45 | gannet | 2 | 82551 | 68 | 2.530 | 32628.9 |
653 | 2023-11-27 16:24:04 | gannet | 1 | 48755 | 4 | 0.766 | 63648.8 |
652 | 2023-11-27 01:40:02 | gannet | 2 | 82551 | 68 | 2.420 | 34112.0 |
651 | 2023-11-25 20:15:40 | gannet | 2 | 82551 | 68 | 2.470 | 33421.5 |
650 | 2023-11-19 09:29:19 | gannet | 1 | 48755 | 4 | 0.970 | 50262.9 |
649 | 2023-11-17 07:54:04 | gannet | 1 | 48755 | 4 | 0.826 | 59025.4 |
648 | 2023-11-14 10:37:30 | gannet | 3 | 112716 | 773 | 5.736 | 19650.6 |
647 | 2023-11-13 19:05:15 | gannet | 1 | 48755 | 4 | 0.856 | 56956.8 |
646 | 2023-11-12 08:28:53 | gannet | 3 | 112716 | 773 | 6.530 | 17261.3 |
645 | 2023-11-09 21:18:14 | gannet | 3 | 112716 | 773 | 5.780 | 19501.0 |
644 | 2023-11-06 21:29:58 | gannet | 3 | 112716 | 773 | 5.830 | 19333.8 |
643 | 2023-11-05 04:27:27 | gannet | 1 | 48755 | 4 | 1.406 | 34676.4 |
642 | 2023-10-26 04:38:35 | gannet | 1 | 48755 | 4 | 0.843 | 57835.1 |
641 | 2023-10-21 23:29:08 | gannet | 1 | 48755 | 4 | 0.780 | 62506.4 |
640 | 2023-10-17 20:36:14 | gannet | 3 | 112716 | 773 | 5.826 | 19347.1 |
639 | 2023-10-17 20:36:11 | gannet | 2 | 82551 | 68 | 2.640 | 31269.3 |
638 | 2023-10-16 18:54:54 | gannet | 1 | 48755 | 4 | 0.810 | 60191.4 |
637 | 2023-10-16 17:28:38 | gannet | 1 | 48755 | 4 | 0.796 | 61250.0 |
636 | 2023-10-05 06:13:12 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
635 | 2023-09-26 13:29:28 | gannet | 1 | 48755 | 4 | 0.796 | 61250.0 |
634 | 2023-09-13 16:41:08 | gannet | 1 | 48755 | 4 | 1.046 | 46610.9 |
633 | 2023-08-29 04:54:25 | gannet | 2 | 82551 | 68 | 2.110 | 39123.7 |
632 | 2023-08-21 18:01:31 | gannet | 1 | 48755 | 4 | 0.796 | 61250.0 |
631 | 2023-08-11 02:29:39 | gannet | 3 | 112716 | 773 | 5.283 | 21335.6 |
630 | 2023-08-06 09:21:11 | gannet | 1 | 48755 | 4 | 0.733 | 66514.3 |
629 | 2023-05-23 21:24:25 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
628 | 2023-05-23 18:57:58 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
627 | 2023-05-08 14:58:40 | gannet | 2 | 82551 | 68 | 2.093 | 39441.5 |
626 | 2023-04-26 00:52:47 | gannet | 3 | 112716 | 773 | 4.656 | 24208.8 |
625 | 2023-04-25 03:51:58 | gannet | 1 | 48755 | 4 | 0.903 | 53992.2 |
624 | 2023-04-08 05:33:34 | gannet | 1 | 48755 | 4 | 0.733 | 66514.3 |
623 | 2023-03-21 07:25:19 | gannet | 1 | 48755 | 4 | 0.860 | 56691.9 |
622 | 2023-03-15 08:40:42 | gannet | 2 | 82551 | 68 | 2.203 | 37472.1 |
621 | 2023-02-16 04:42:56 | gannet | 2 | 82551 | 68 | 2.110 | 39123.7 |
620 | 2023-01-31 16:36:31 | gannet | 3 | 112716 | 773 | 5.593 | 20153.0 |
619 | 2023-01-09 01:29:19 | gannet | 1 | 48755 | 4 | 0.736 | 66243.2 |
618 | 2023-01-06 15:26:44 | gannet | 1 | 48755 | 4 | 0.736 | 66243.2 |
617 | 2023-01-03 23:07:47 | gannet | 3 | 112716 | 773 | 5.126 | 21989.1 |
616 | 2022-11-26 23:43:38 | gannet | 2 | 82551 | 68 | 2.580 | 31996.5 |
615 | 2022-11-20 04:58:05 | gannet | 3 | 112716 | 773 | 4.813 | 23419.1 |
614 | 2022-11-16 09:03:58 | gannet | 3 | 112716 | 773 | 4.750 | 23729.7 |
613 | 2022-11-14 09:46:34 | gannet | 3 | 112716 | 773 | 4.873 | 23130.7 |
612 | 2022-11-12 19:19:41 | gannet | 3 | 112716 | 773 | 4.830 | 23336.6 |
611 | 2022-10-30 19:09:09 | gannet | 3 | 112716 | 773 | 5.563 | 20261.7 |
610 | 2022-10-05 03:10:57 | gannet | 1 | 48755 | 4 | 0.733 | 66514.3 |
609 | 2022-10-04 11:23:32 | gannet | 3 | 112716 | 773 | 4.953 | 22757.1 |
608 | 2022-09-29 13:58:09 | gannet | 3 | 112716 | 773 | 4.766 | 23650.0 |
607 | 2022-09-21 15:58:27 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
606 | 2022-09-10 10:49:50 | gannet | 3 | 112716 | 773 | 4.660 | 24188.0 |
605 | 2022-08-30 04:58:27 | gannet | 3 | 112716 | 773 | 5.486 | 20546.1 |
604 | 2022-08-21 20:53:53 | gannet | 3 | 112716 | 773 | 4.860 | 23192.6 |
603 | 2022-07-20 06:42:25 | gannet | 3 | 112716 | 773 | 5.280 | 21347.7 |
602 | 2022-06-14 17:05:48 | gannet | 3 | 112716 | 773 | 5.203 | 21663.7 |
601 | 2022-06-11 20:42:02 | gannet | 1 | 48755 | 4 | 0.860 | 56691.9 |
600 | 2022-05-22 22:59:03 | gannet | 1 | 48755 | 4 | 0.846 | 57630.0 |
599 | 2022-04-22 23:27:29 | gannet | 2 | 82551 | 68 | 2.610 | 31628.7 |
598 | 2022-02-28 06:09:21 | gannet | 1 | 48755 | 4 | 0.796 | 61250.0 |
597 | 2022-02-08 14:36:16 | gannet | 1 | 48755 | 4 | 0.766 | 63648.8 |
596 | 2021-12-08 15:16:50 | gannet | 1 | 48755 | 4 | 0.843 | 57835.1 |
595 | 2021-12-06 13:56:44 | gannet | 1 | 48755 | 4 | 0.830 | 58741.0 |
594 | 2021-11-26 15:07:02 | gannet | 1 | 48755 | 4 | 0.843 | 57835.1 |
593 | 2021-11-23 10:27:57 | gannet | 1 | 48755 | 4 | 0.780 | 62506.4 |
592 | 2021-11-14 16:26:38 | gannet | 1 | 48755 | 4 | 1.623 | 30040.0 |
591 | 2021-10-11 21:05:19 | gannet | 1 | 48755 | 4 | 0.863 | 56494.8 |
590 | 2021-09-22 03:16:48 | gannet | 1 | 48755 | 4 | 0.796 | 61250.0 |
589 | 2021-09-21 13:07:16 | gannet | 1 | 48755 | 4 | 0.830 | 58741.0 |
588 | 2021-09-15 04:26:46 | gannet | 1 | 48755 | 4 | 0.766 | 63648.8 |
587 | 2021-09-07 19:48:55 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
586 | 2021-08-22 20:28:06 | gannet | 3 | 112716 | 773 | 4.670 | 24136.2 |
585 | 2021-08-19 00:40:11 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
584 | 2021-08-17 02:57:24 | gannet | 1 | 48755 | 4 | 0.860 | 56691.9 |
583 | 2021-07-26 10:57:11 | gannet | 3 | 112716 | 773 | 5.250 | 21469.7 |
582 | 2021-07-23 10:45:37 | gannet | 2 | 82551 | 68 | 2.203 | 37472.1 |
581 | 2021-07-08 15:21:12 | gannet | 3 | 112716 | 773 | 4.953 | 22757.1 |
580 | 2021-07-04 11:14:59 | gannet | 3 | 112716 | 773 | 5.326 | 21163.3 |
579 | 2021-06-10 16:51:10 | gannet | 3 | 112716 | 773 | 4.780 | 23580.8 |
578 | 2021-06-05 02:55:28 | gannet | 1 | 48755 | 4 | 0.763 | 63899.1 |
577 | 2021-05-27 15:49:33 | gannet | 3 | 112716 | 773 | 5.530 | 20382.6 |
576 | 2021-05-22 11:33:03 | gannet | 3 | 112716 | 773 | 5.623 | 20045.5 |
575 | 2021-05-16 10:52:59 | gannet | 1 | 48755 | 4 | 0.923 | 52822.3 |
574 | 2021-05-13 04:13:34 | gannet | 2 | 82551 | 68 | 2.483 | 33246.5 |
573 | 2021-05-13 02:04:23 | gannet | 1 | 48755 | 4 | 0.750 | 65006.7 |
572 | 2021-05-10 23:44:21 | gannet | 1 | 48755 | 4 | 0.843 | 57835.1 |
571 | 2021-04-24 13:17:08 | gannet | 1 | 48755 | 4 | 0.876 | 55656.4 |
570 | 2021-04-23 08:17:04 | gannet | 3 | 112716 | 773 | 5.576 | 20214.5 |
569 | 2021-04-17 03:39:04 | gannet | 3 | 112716 | 773 | 5.860 | 19234.8 |