History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shires"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
641 | 2024-04-01 23:27:46 | shires | 1 | 48755 | 14 | 1.686 | 28917.6 |
640 | 2024-03-31 09:19:46 | shires | 1 | 48755 | 14 | 1.546 | 31536.2 |
639 | 2024-03-05 12:33:50 | shires | 1 | 48755 | 14 | 0.953 | 51159.5 |
638 | 2024-03-04 02:24:33 | shires | 2 | 82551 | 216 | 3.780 | 21838.9 |
637 | 2024-03-04 02:24:28 | shires | 1 | 48755 | 14 | 0.860 | 56691.9 |
636 | 2024-02-11 05:12:38 | shires | 1 | 48755 | 14 | 0.736 | 66243.2 |
635 | 2024-02-11 01:51:27 | shires | 1 | 48755 | 14 | 0.736 | 66243.2 |
634 | 2024-01-26 11:09:53 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
633 | 2024-01-03 20:37:12 | shires | 2 | 82551 | 216 | 2.656 | 31080.9 |
632 | 2023-12-21 01:39:03 | shires | 1 | 48755 | 14 | 0.936 | 52088.7 |
631 | 2023-12-12 12:51:45 | shires | 1 | 48755 | 14 | 0.796 | 61250.0 |
630 | 2023-12-03 03:43:37 | shires | 2 | 82551 | 216 | 2.406 | 34310.5 |
629 | 2023-12-02 10:25:10 | shires | 2 | 82551 | 216 | 2.233 | 36968.7 |
628 | 2023-11-21 02:29:33 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
627 | 2023-11-18 15:36:19 | shires | 2 | 82551 | 216 | 2.170 | 38041.9 |
626 | 2023-11-17 18:39:59 | shires | 1 | 48755 | 14 | 0.780 | 62506.4 |
625 | 2023-11-17 17:35:36 | shires | 1 | 48755 | 14 | 0.876 | 55656.4 |
624 | 2023-11-14 01:54:50 | shires | 1 | 48755 | 14 | 0.813 | 59969.2 |
623 | 2023-11-10 22:52:33 | shires | 1 | 48755 | 14 | 0.783 | 62266.9 |
622 | 2023-10-27 21:14:58 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
621 | 2023-10-21 13:38:07 | shires | 1 | 48755 | 14 | 0.783 | 62266.9 |
620 | 2023-10-19 05:11:36 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
619 | 2023-10-11 04:47:05 | shires | 1 | 48755 | 14 | 0.796 | 61250.0 |
618 | 2023-10-11 01:31:27 | shires | 2 | 82551 | 216 | 3.406 | 24236.9 |
617 | 2023-10-09 08:29:00 | shires | 2 | 82551 | 216 | 2.140 | 38575.2 |
616 | 2023-10-03 15:32:31 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
615 | 2023-09-29 17:45:06 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
614 | 2023-09-23 20:56:42 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
613 | 2023-09-14 14:20:50 | shires | 2 | 82551 | 216 | 2.703 | 30540.5 |
612 | 2023-09-10 14:28:46 | shires | 1 | 48755 | 14 | 0.763 | 63899.1 |
611 | 2023-07-31 18:39:38 | shires | 1 | 48755 | 14 | 0.796 | 61250.0 |
610 | 2023-07-27 15:41:04 | shires | 1 | 48755 | 14 | 0.796 | 61250.0 |
609 | 2023-04-23 09:50:47 | shires | 1 | 48755 | 14 | 0.890 | 54780.9 |
608 | 2023-04-23 02:01:27 | shires | 1 | 48755 | 14 | 0.856 | 56956.8 |
607 | 2023-02-13 20:00:21 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
606 | 2023-01-22 05:56:45 | shires | 1 | 48755 | 14 | 0.826 | 59025.4 |
605 | 2022-12-10 20:11:14 | shires | 1 | 48755 | 14 | 0.763 | 63899.1 |
604 | 2022-10-11 14:01:36 | shires | 1 | 48755 | 14 | 0.763 | 63899.1 |
603 | 2022-08-25 16:23:37 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
602 | 2022-08-13 22:39:57 | shires | 1 | 48755 | 14 | 0.763 | 63899.1 |
601 | 2022-07-02 16:33:02 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
600 | 2022-06-28 18:59:58 | shires | 1 | 48755 | 14 | 0.763 | 63899.1 |
599 | 2022-04-05 00:28:01 | shires | 1 | 48755 | 14 | 0.846 | 57630.0 |
598 | 2022-03-25 17:02:32 | shires | 1 | 48755 | 14 | 0.980 | 49750.0 |
597 | 2022-03-24 22:40:37 | shires | 1 | 48755 | 14 | 1.080 | 45143.5 |
596 | 2022-03-23 13:46:26 | shires | 1 | 48755 | 14 | 1.096 | 44484.5 |
595 | 2022-03-19 00:59:27 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
594 | 2022-01-06 13:52:57 | shires | 1 | 48755 | 14 | 0.876 | 55656.4 |
593 | 2021-12-11 18:43:30 | shires | 1 | 48755 | 14 | 0.873 | 55847.7 |
592 | 2021-11-18 16:29:12 | shires | 1 | 48755 | 14 | 0.783 | 62266.9 |
591 | 2021-11-17 20:34:58 | shires | 1 | 48755 | 14 | 0.830 | 58741.0 |
590 | 2021-11-09 19:30:53 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
589 | 2021-11-08 09:27:05 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
588 | 2021-10-31 16:46:23 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
587 | 2021-09-24 09:13:56 | shires | 1 | 48755 | 14 | 1.500 | 32503.3 |
586 | 2021-09-21 18:03:57 | shires | 1 | 48755 | 14 | 0.890 | 54780.9 |
585 | 2021-09-20 21:44:10 | shires | 1 | 48755 | 14 | 0.906 | 53813.5 |
584 | 2021-09-20 04:33:11 | shires | 1 | 48755 | 14 | 0.986 | 49447.3 |
583 | 2021-09-13 20:06:09 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
582 | 2021-09-10 23:30:13 | shires | 1 | 48755 | 14 | 0.826 | 59025.4 |
581 | 2021-09-10 09:45:48 | shires | 1 | 48755 | 14 | 0.860 | 56691.9 |
580 | 2021-09-09 19:19:15 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
579 | 2021-09-08 03:52:17 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
578 | 2021-09-07 17:17:37 | shires | 1 | 48755 | 14 | 0.830 | 58741.0 |
577 | 2021-09-07 16:39:08 | shires | 1 | 48755 | 14 | 1.750 | 27860.0 |
576 | 2021-09-06 18:01:55 | shires | 1 | 48755 | 14 | 0.860 | 56691.9 |
575 | 2021-08-24 21:18:44 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
574 | 2021-08-22 16:59:52 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
573 | 2021-06-06 20:10:19 | shires | 1 | 48755 | 14 | 0.826 | 59025.4 |
572 | 2021-06-03 15:51:21 | shires | 1 | 48755 | 14 | 0.826 | 59025.4 |
571 | 2021-05-31 02:28:14 | shires | 1 | 48755 | 14 | 0.763 | 63899.1 |
570 | 2021-05-05 21:05:50 | shires | 1 | 48755 | 14 | 0.920 | 52994.6 |
569 | 2021-04-04 00:01:29 | shires | 1 | 48755 | 14 | 0.810 | 60191.4 |
568 | 2021-03-10 19:33:28 | shires | 2 | 82551 | 216 | 2.173 | 37989.4 |
567 | 2021-03-01 05:23:02 | shires | 1 | 48755 | 14 | 0.873 | 55847.7 |
566 | 2021-02-26 04:10:19 | shires | 1 | 48755 | 14 | 0.873 | 55847.7 |
565 | 2021-02-10 20:39:10 | shires | 1 | 48755 | 14 | 0.860 | 56691.9 |
564 | 2021-01-19 02:15:38 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
563 | 2020-11-29 12:49:26 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
562 | 2020-11-24 11:26:12 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
561 | 2020-11-01 18:21:13 | shires | 2 | 82551 | 216 | 2.453 | 33653.1 |
560 | 2020-10-22 16:57:44 | shires | 1 | 48755 | 14 | 0.923 | 52822.3 |
559 | 2020-10-18 01:37:03 | shires | 1 | 48755 | 14 | 0.860 | 56691.9 |
558 | 2020-10-18 01:25:54 | shires | 1 | 48755 | 14 | 0.843 | 57835.1 |
557 | 2020-10-04 16:51:33 | shires | 1 | 48755 | 14 | 0.780 | 62506.4 |
556 | 2020-09-06 22:56:52 | shires | 1 | 48755 | 14 | 0.736 | 66243.2 |
555 | 2020-08-26 02:02:36 | shires | 1 | 48755 | 14 | 0.780 | 62506.4 |
554 | 2020-08-22 22:19:30 | shires | 1 | 48755 | 14 | 0.780 | 62506.4 |
553 | 2020-06-17 01:06:25 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
552 | 2020-06-14 06:08:52 | shires | 1 | 48755 | 14 | 0.766 | 63648.8 |
551 | 2020-06-13 12:45:17 | shires | 1 | 48755 | 14 | 0.780 | 62506.4 |
550 | 2020-06-11 09:58:15 | shires | 1 | 48755 | 14 | 0.830 | 58741.0 |
549 | 2020-05-21 14:51:41 | shires | 1 | 48755 | 14 | 0.750 | 65006.7 |
548 | 2020-03-26 20:05:12 | shires | 1 | 48755 | 14 | 0.876 | 55656.4 |
547 | 2020-03-26 15:09:00 | shires | 1 | 48755 | 14 | 0.856 | 56956.8 |
546 | 2020-03-23 19:31:41 | shires | 1 | 48755 | 14 | 0.923 | 52822.3 |
545 | 2020-03-23 05:55:58 | shires | 1 | 48755 | 14 | 0.860 | 56691.9 |
544 | 2020-03-22 13:40:52 | shires | 1 | 48755 | 14 | 1.940 | 25131.4 |
543 | 2020-03-18 17:47:58 | shires | 1 | 48755 | 14 | 0.906 | 53813.5 |
542 | 2020-03-15 17:06:07 | shires | 1 | 48755 | 14 | 0.846 | 57630.0 |