History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roosts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
643 | 2024-04-29 05:52:46 | roosts | 1 | 48755 | 7 | 0.750 | 65006.7 |
642 | 2024-04-27 23:46:10 | roosts | 1 | 48755 | 7 | 1.593 | 30605.8 |
641 | 2024-04-20 22:34:36 | roosts | 1 | 48755 | 7 | 3.093 | 15763.0 |
640 | 2024-04-08 22:00:45 | roosts | 1 | 48755 | 7 | 2.610 | 18680.1 |
639 | 2024-04-03 11:06:53 | roosts | 1 | 48755 | 7 | 1.033 | 47197.5 |
638 | 2024-03-20 18:20:44 | roosts | 3 | 112716 | 809 | 6.233 | 18083.7 |
637 | 2024-03-20 18:20:37 | roosts | 2 | 82551 | 70 | 2.436 | 33887.9 |
636 | 2024-03-20 18:20:18 | roosts | 1 | 48755 | 7 | 1.800 | 27086.1 |
635 | 2024-03-20 18:19:45 | roosts | 2 | 82551 | 70 | 6.063 | 13615.5 |
634 | 2024-03-20 18:19:40 | roosts | 3 | 112716 | 809 | 6.830 | 16503.1 |
633 | 2024-03-20 18:19:16 | roosts | 1 | 48755 | 7 | 0.970 | 50262.9 |
632 | 2024-03-08 06:44:41 | roosts | 1 | 48755 | 7 | 2.030 | 24017.2 |
631 | 2024-03-04 07:13:26 | roosts | 1 | 48755 | 7 | 2.860 | 17047.2 |
630 | 2024-02-25 21:09:20 | roosts | 1 | 48755 | 7 | 1.966 | 24799.1 |
629 | 2024-02-17 21:42:52 | roosts | 1 | 48755 | 7 | 2.030 | 24017.2 |
628 | 2024-02-06 23:06:19 | roosts | 2 | 82551 | 70 | 2.470 | 33421.5 |
627 | 2024-02-06 23:04:43 | roosts | 3 | 112716 | 809 | 5.860 | 19234.8 |
626 | 2024-02-05 20:27:46 | roosts | 1 | 48755 | 7 | 0.923 | 52822.3 |
625 | 2024-02-05 20:25:34 | roosts | 1 | 48755 | 7 | 0.906 | 53813.5 |
624 | 2024-02-05 20:25:26 | roosts | 2 | 82551 | 70 | 2.843 | 29036.6 |
623 | 2024-02-05 20:25:22 | roosts | 3 | 112716 | 809 | 5.736 | 19650.6 |
622 | 2024-02-05 20:25:18 | roosts | 1 | 48755 | 7 | 0.846 | 57630.0 |
621 | 2024-02-04 13:57:34 | roosts | 1 | 48755 | 7 | 2.846 | 17131.1 |
620 | 2024-01-26 01:41:09 | roosts | 1 | 48755 | 7 | 0.906 | 53813.5 |
619 | 2024-01-19 23:54:44 | roosts | 1 | 48755 | 7 | 0.936 | 52088.7 |
618 | 2024-01-17 02:45:38 | roosts | 1 | 48755 | 7 | 0.763 | 63899.1 |
617 | 2024-01-15 23:19:12 | roosts | 3 | 112716 | 809 | 5.296 | 21283.2 |
616 | 2024-01-14 00:15:49 | roosts | 3 | 112716 | 809 | 6.046 | 18643.1 |
615 | 2024-01-06 20:15:16 | roosts | 1 | 48755 | 7 | 0.890 | 54780.9 |
614 | 2023-12-24 23:32:05 | roosts | 2 | 82551 | 70 | 2.436 | 33887.9 |
613 | 2023-12-09 06:10:24 | roosts | 3 | 112716 | 809 | 5.313 | 21215.1 |
612 | 2023-12-09 06:10:25 | roosts | 2 | 82551 | 70 | 2.623 | 31472.0 |
611 | 2023-12-05 01:25:56 | roosts | 3 | 112716 | 809 | 5.753 | 19592.6 |
610 | 2023-12-05 01:25:54 | roosts | 2 | 82551 | 70 | 2.593 | 31836.1 |
609 | 2023-11-22 15:15:55 | roosts | 1 | 48755 | 7 | 0.923 | 52822.3 |
608 | 2023-11-16 16:31:46 | roosts | 2 | 82551 | 70 | 2.440 | 33832.4 |
607 | 2023-11-16 00:52:39 | roosts | 3 | 112716 | 809 | 5.500 | 20493.8 |
606 | 2023-11-11 07:04:12 | roosts | 1 | 48755 | 7 | 0.860 | 56691.9 |
605 | 2023-11-10 09:50:22 | roosts | 1 | 48755 | 7 | 0.733 | 66514.3 |
604 | 2023-10-29 01:39:18 | roosts | 3 | 112716 | 809 | 5.076 | 22205.7 |
603 | 2023-10-26 22:28:42 | roosts | 1 | 48755 | 7 | 0.750 | 65006.7 |
602 | 2023-10-26 20:21:14 | roosts | 3 | 112716 | 809 | 4.923 | 22895.8 |
601 | 2023-10-20 13:09:24 | roosts | 1 | 48755 | 7 | 0.826 | 59025.4 |
600 | 2023-10-17 12:09:14 | roosts | 1 | 48755 | 7 | 0.876 | 55656.4 |
599 | 2023-10-12 08:37:58 | roosts | 1 | 48755 | 7 | 0.890 | 54780.9 |
598 | 2023-10-04 03:53:18 | roosts | 1 | 48755 | 7 | 0.766 | 63648.8 |
597 | 2023-09-26 13:26:03 | roosts | 2 | 82551 | 70 | 2.733 | 30205.3 |
596 | 2023-09-25 02:09:09 | roosts | 1 | 48755 | 7 | 0.843 | 57835.1 |
595 | 2023-09-21 22:18:56 | roosts | 1 | 48755 | 7 | 0.766 | 63648.8 |
594 | 2023-09-19 15:31:08 | roosts | 1 | 48755 | 7 | 1.826 | 26700.4 |
593 | 2023-09-08 00:31:35 | roosts | 1 | 48755 | 7 | 0.766 | 63648.8 |
592 | 2023-08-03 23:13:08 | roosts | 3 | 112716 | 809 | 5.470 | 20606.2 |
591 | 2023-07-07 06:59:22 | roosts | 2 | 82551 | 70 | 2.203 | 37472.1 |
590 | 2023-06-17 23:53:48 | roosts | 1 | 48755 | 7 | 0.876 | 55656.4 |
589 | 2023-05-20 07:23:18 | roosts | 1 | 48755 | 7 | 0.733 | 66514.3 |
588 | 2023-04-16 10:04:54 | roosts | 3 | 112716 | 809 | 4.623 | 24381.6 |
587 | 2023-04-01 21:40:19 | roosts | 1 | 48755 | 7 | 1.500 | 32503.3 |
586 | 2023-03-26 05:25:49 | roosts | 2 | 82551 | 70 | 2.296 | 35954.3 |
585 | 2023-02-09 07:03:41 | roosts | 3 | 112716 | 809 | 4.640 | 24292.2 |
584 | 2023-01-23 11:37:15 | roosts | 3 | 112716 | 809 | 4.640 | 24292.2 |
583 | 2023-01-20 03:53:08 | roosts | 1 | 48755 | 7 | 0.766 | 63648.8 |
582 | 2023-01-17 00:26:45 | roosts | 3 | 112716 | 809 | 4.766 | 23650.0 |
581 | 2023-01-14 16:57:13 | roosts | 1 | 48755 | 7 | 0.736 | 66243.2 |
580 | 2022-12-24 12:30:52 | roosts | 2 | 82551 | 70 | 2.123 | 38884.1 |
579 | 2022-12-24 06:22:56 | roosts | 3 | 112716 | 809 | 9.173 | 12287.8 |
578 | 2022-11-05 18:53:48 | roosts | 1 | 48755 | 7 | 0.736 | 66243.2 |
577 | 2022-11-04 13:32:45 | roosts | 3 | 112716 | 809 | 5.716 | 19719.4 |
576 | 2022-09-14 08:43:25 | roosts | 1 | 48755 | 7 | 0.763 | 63899.1 |
575 | 2022-08-22 11:06:22 | roosts | 2 | 82551 | 70 | 2.123 | 38884.1 |
574 | 2022-08-20 00:42:32 | roosts | 2 | 82551 | 70 | 2.203 | 37472.1 |
573 | 2022-08-17 16:47:31 | roosts | 2 | 82551 | 70 | 2.173 | 37989.4 |
572 | 2022-07-10 04:19:49 | roosts | 1 | 48755 | 7 | 0.780 | 62506.4 |
571 | 2022-06-25 16:40:08 | roosts | 1 | 48755 | 7 | 0.843 | 57835.1 |
570 | 2022-06-25 09:25:27 | roosts | 1 | 48755 | 7 | 0.796 | 61250.0 |
569 | 2022-06-25 07:57:24 | roosts | 1 | 48755 | 7 | 0.766 | 63648.8 |
568 | 2022-06-17 16:25:05 | roosts | 3 | 112716 | 809 | 5.000 | 22543.2 |
567 | 2022-06-13 23:28:10 | roosts | 3 | 112716 | 809 | 4.703 | 23966.8 |
566 | 2022-06-05 22:00:55 | roosts | 3 | 112716 | 809 | 5.296 | 21283.2 |
565 | 2022-06-01 20:54:33 | roosts | 1 | 48755 | 7 | 0.796 | 61250.0 |
564 | 2022-06-01 15:33:55 | roosts | 1 | 48755 | 7 | 0.736 | 66243.2 |
563 | 2022-05-16 03:32:31 | roosts | 1 | 48755 | 7 | 0.843 | 57835.1 |
562 | 2022-05-15 14:46:09 | roosts | 1 | 48755 | 7 | 0.856 | 56956.8 |
561 | 2022-03-17 22:22:58 | roosts | 2 | 82551 | 70 | 2.843 | 29036.6 |
560 | 2022-02-28 08:15:44 | roosts | 1 | 48755 | 7 | 1.233 | 39541.8 |
559 | 2022-01-27 21:37:25 | roosts | 1 | 48755 | 7 | 0.750 | 65006.7 |
558 | 2022-01-25 03:02:49 | roosts | 3 | 112716 | 809 | 5.313 | 21215.1 |
557 | 2021-12-13 03:08:33 | roosts | 1 | 48755 | 7 | 0.783 | 62266.9 |
556 | 2021-12-11 08:00:22 | roosts | 2 | 82551 | 70 | 2.830 | 29170.0 |
555 | 2021-12-11 00:55:44 | roosts | 1 | 48755 | 7 | 0.843 | 57835.1 |
554 | 2021-11-10 15:42:19 | roosts | 1 | 48755 | 7 | 0.780 | 62506.4 |
553 | 2021-10-28 21:05:53 | roosts | 3 | 112716 | 809 | 4.936 | 22835.5 |
552 | 2021-10-20 08:14:15 | roosts | 1 | 48755 | 7 | 0.763 | 63899.1 |
551 | 2021-10-13 04:52:45 | roosts | 3 | 112716 | 809 | 5.436 | 20735.1 |
550 | 2021-10-11 05:31:35 | roosts | 1 | 48755 | 7 | 0.860 | 56691.9 |
549 | 2021-10-02 11:20:24 | roosts | 3 | 112716 | 809 | 5.720 | 19705.6 |
548 | 2021-09-20 22:36:36 | roosts | 3 | 112716 | 809 | 5.423 | 20784.8 |
547 | 2021-09-20 21:23:41 | roosts | 3 | 112716 | 809 | 6.033 | 18683.2 |
546 | 2021-09-10 06:38:40 | roosts | 1 | 48755 | 7 | 0.766 | 63648.8 |
545 | 2021-08-30 15:05:00 | roosts | 3 | 112716 | 809 | 5.923 | 19030.2 |
544 | 2021-08-21 11:32:07 | roosts | 1 | 48755 | 7 | 0.843 | 57835.1 |