History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"barret"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
644 | 2024-04-15 22:03:23 | barret | 2 | 82551 | 91 | 2.940 | 28078.6 |
643 | 2024-04-15 22:02:14 | barret | 3 | 112716 | 951 | 8.563 | 13163.1 |
642 | 2024-04-15 08:52:11 | barret | 1 | 48755 | 9 | 0.750 | 65006.7 |
641 | 2024-04-13 16:22:21 | barret | 3 | 112716 | 951 | 6.486 | 17378.4 |
640 | 2024-04-03 13:08:59 | barret | 1 | 48755 | 9 | 2.953 | 16510.3 |
639 | 2024-03-31 18:01:10 | barret | 3 | 112716 | 951 | 55.800 | 2020.0 |
638 | 2024-03-31 09:31:37 | barret | 1 | 48755 | 9 | 0.936 | 52088.7 |
637 | 2024-03-31 09:30:49 | barret | 3 | 112716 | 951 | 10.550 | 10684.0 |
636 | 2024-03-31 09:30:51 | barret | 2 | 82551 | 91 | 5.750 | 14356.7 |
635 | 2024-03-31 09:30:46 | barret | 1 | 48755 | 9 | 0.920 | 52994.6 |
634 | 2024-03-31 09:30:36 | barret | 2 | 82551 | 91 | 6.046 | 13653.8 |
633 | 2024-03-31 06:00:45 | barret | 1 | 48755 | 9 | 2.686 | 18151.5 |
632 | 2024-03-29 06:26:25 | barret | 1 | 48755 | 9 | 1.000 | 48755.0 |
631 | 2024-03-04 13:58:57 | barret | 3 | 112716 | 951 | 11.156 | 10103.6 |
630 | 2024-03-04 08:16:16 | barret | 3 | 112716 | 951 | 5.296 | 21283.2 |
629 | 2024-03-04 08:16:17 | barret | 2 | 82551 | 91 | 2.500 | 33020.4 |
628 | 2024-03-04 08:16:16 | barret | 1 | 48755 | 9 | 0.860 | 56691.9 |
627 | 2024-02-28 05:56:17 | barret | 2 | 82551 | 91 | 3.453 | 23907.0 |
626 | 2024-02-28 05:55:30 | barret | 3 | 112716 | 951 | 6.250 | 18034.6 |
625 | 2024-02-28 01:24:28 | barret | 3 | 112716 | 951 | 13.783 | 8177.9 |
624 | 2024-02-28 01:14:17 | barret | 1 | 48755 | 9 | 1.953 | 24964.2 |
623 | 2024-02-28 01:13:52 | barret | 3 | 112716 | 951 | 7.156 | 15751.3 |
622 | 2024-02-28 01:13:50 | barret | 2 | 82551 | 91 | 2.890 | 28564.4 |
621 | 2024-02-13 19:18:46 | barret | 1 | 48755 | 9 | 0.860 | 56691.9 |
620 | 2024-01-06 15:15:43 | barret | 3 | 112716 | 951 | 5.563 | 20261.7 |
619 | 2024-01-06 15:15:44 | barret | 2 | 82551 | 91 | 2.610 | 31628.7 |
618 | 2024-01-01 03:45:51 | barret | 1 | 48755 | 9 | 0.766 | 63648.8 |
617 | 2023-12-29 23:50:09 | barret | 3 | 112716 | 951 | 4.940 | 22817.0 |
616 | 2023-12-29 23:50:07 | barret | 2 | 82551 | 91 | 2.393 | 34496.9 |
615 | 2023-12-15 11:09:52 | barret | 3 | 112716 | 951 | 8.360 | 13482.8 |
614 | 2023-12-15 11:09:54 | barret | 2 | 82551 | 91 | 5.123 | 16113.8 |
613 | 2023-12-12 22:01:00 | barret | 3 | 112716 | 951 | 4.733 | 23814.9 |
612 | 2023-12-05 08:53:59 | barret | 1 | 48755 | 9 | 0.986 | 49447.3 |
611 | 2023-11-25 15:32:03 | barret | 2 | 82551 | 91 | 2.173 | 37989.4 |
610 | 2023-11-13 20:10:58 | barret | 1 | 48755 | 9 | 0.906 | 53813.5 |
609 | 2023-11-12 03:44:14 | barret | 1 | 48755 | 9 | 0.766 | 63648.8 |
608 | 2023-10-31 14:16:56 | barret | 1 | 48755 | 9 | 1.483 | 32875.9 |
607 | 2023-10-26 08:20:13 | barret | 1 | 48755 | 9 | 0.763 | 63899.1 |
606 | 2023-10-26 03:06:38 | barret | 1 | 48755 | 9 | 0.750 | 65006.7 |
605 | 2023-10-23 03:28:47 | barret | 1 | 48755 | 9 | 0.766 | 63648.8 |
604 | 2023-10-21 23:18:37 | barret | 1 | 48755 | 9 | 0.890 | 54780.9 |
603 | 2023-10-20 15:24:06 | barret | 3 | 112716 | 951 | 10.783 | 10453.1 |
602 | 2023-10-17 12:30:57 | barret | 3 | 112716 | 951 | 6.843 | 16471.7 |
601 | 2023-10-17 11:01:20 | barret | 1 | 48755 | 9 | 1.000 | 48755.0 |
600 | 2023-10-17 09:39:35 | barret | 2 | 82551 | 91 | 3.190 | 25878.1 |
599 | 2023-10-12 11:01:18 | barret | 3 | 112716 | 951 | 6.890 | 16359.4 |
598 | 2023-10-10 23:34:31 | barret | 1 | 48755 | 9 | 0.953 | 51159.5 |
597 | 2023-10-05 06:04:37 | barret | 1 | 48755 | 9 | 0.763 | 63899.1 |
596 | 2023-10-04 03:04:25 | barret | 3 | 112716 | 951 | 7.096 | 15884.4 |
595 | 2023-09-26 23:00:52 | barret | 3 | 112716 | 951 | 5.843 | 19290.8 |
594 | 2023-09-26 05:54:15 | barret | 1 | 48755 | 9 | 0.763 | 63899.1 |
593 | 2023-09-23 03:17:29 | barret | 3 | 112716 | 951 | 6.356 | 17733.8 |
592 | 2023-09-13 15:18:00 | barret | 1 | 48755 | 9 | 0.763 | 63899.1 |
591 | 2023-09-12 04:27:20 | barret | 3 | 112716 | 951 | 4.843 | 23274.0 |
590 | 2023-08-18 20:31:31 | barret | 1 | 48755 | 9 | 0.763 | 63899.1 |
589 | 2023-07-13 05:40:28 | barret | 1 | 48755 | 9 | 0.840 | 58041.7 |
588 | 2023-06-06 18:54:36 | barret | 3 | 112716 | 951 | 4.673 | 24120.7 |
587 | 2023-05-19 02:41:12 | barret | 1 | 48755 | 9 | 0.750 | 65006.7 |
586 | 2023-04-01 21:53:57 | barret | 1 | 48755 | 9 | 0.826 | 59025.4 |
585 | 2023-03-15 00:28:16 | barret | 1 | 48755 | 9 | 0.733 | 66514.3 |
584 | 2023-03-12 01:12:45 | barret | 3 | 112716 | 951 | 4.670 | 24136.2 |
583 | 2023-01-03 16:30:52 | barret | 1 | 48755 | 9 | 0.876 | 55656.4 |
582 | 2022-12-27 17:22:05 | barret | 1 | 48755 | 9 | 0.750 | 65006.7 |
581 | 2022-12-15 05:32:36 | barret | 3 | 112716 | 951 | 4.686 | 24053.8 |
580 | 2022-11-25 14:30:16 | barret | 1 | 48755 | 9 | 0.766 | 63648.8 |
579 | 2022-09-25 08:28:31 | barret | 1 | 48755 | 9 | 0.873 | 55847.7 |
578 | 2022-09-16 22:50:53 | barret | 1 | 48755 | 9 | 0.783 | 62266.9 |
577 | 2022-09-01 12:35:44 | barret | 1 | 48755 | 9 | 0.860 | 56691.9 |
576 | 2022-08-03 17:00:45 | barret | 3 | 112716 | 951 | 5.000 | 22543.2 |
575 | 2022-08-01 09:30:24 | barret | 3 | 112716 | 951 | 5.580 | 20200.0 |
574 | 2022-05-31 12:00:26 | barret | 1 | 48755 | 9 | 0.846 | 57630.0 |
573 | 2022-05-09 16:43:06 | barret | 1 | 48755 | 9 | 0.780 | 62506.4 |
572 | 2022-05-07 12:20:06 | barret | 1 | 48755 | 9 | 0.780 | 62506.4 |
571 | 2022-02-20 07:56:29 | barret | 1 | 48755 | 9 | 0.826 | 59025.4 |
570 | 2022-02-16 23:30:33 | barret | 1 | 48755 | 9 | 0.763 | 63899.1 |
569 | 2022-01-24 08:18:52 | barret | 1 | 48755 | 9 | 0.846 | 57630.0 |
568 | 2022-01-22 04:10:32 | barret | 1 | 48755 | 9 | 0.750 | 65006.7 |
567 | 2022-01-19 23:49:45 | barret | 1 | 48755 | 9 | 0.783 | 62266.9 |
566 | 2021-12-23 15:24:47 | barret | 2 | 82551 | 91 | 2.470 | 33421.5 |
565 | 2021-12-23 07:48:57 | barret | 2 | 82551 | 91 | 2.330 | 35429.6 |
564 | 2021-12-22 19:58:02 | barret | 2 | 82551 | 91 | 2.513 | 32849.6 |
563 | 2021-12-22 09:04:36 | barret | 2 | 82551 | 91 | 2.563 | 32208.7 |
562 | 2021-12-22 01:13:31 | barret | 2 | 82551 | 91 | 2.656 | 31080.9 |
561 | 2021-12-21 14:32:19 | barret | 2 | 82551 | 91 | 3.220 | 25637.0 |
560 | 2021-12-21 06:30:55 | barret | 2 | 82551 | 91 | 2.860 | 28864.0 |
559 | 2021-12-20 21:10:25 | barret | 2 | 82551 | 91 | 2.440 | 33832.4 |
558 | 2021-12-20 10:32:40 | barret | 2 | 82551 | 91 | 2.313 | 35690.0 |
557 | 2021-12-19 21:47:31 | barret | 2 | 82551 | 91 | 2.310 | 35736.4 |
556 | 2021-12-10 22:05:32 | barret | 2 | 82551 | 91 | 2.236 | 36919.1 |
555 | 2021-12-09 22:43:02 | barret | 2 | 82551 | 91 | 2.423 | 34069.7 |
554 | 2021-12-08 23:12:52 | barret | 2 | 82551 | 91 | 2.220 | 37185.1 |
553 | 2021-12-05 02:50:25 | barret | 2 | 82551 | 91 | 2.720 | 30349.6 |
552 | 2021-12-04 06:49:55 | barret | 2 | 82551 | 91 | 2.640 | 31269.3 |
551 | 2021-12-03 02:07:44 | barret | 2 | 82551 | 91 | 2.766 | 29844.9 |
550 | 2021-11-28 22:17:17 | barret | 2 | 82551 | 91 | 2.266 | 36430.3 |
549 | 2021-11-27 19:26:00 | barret | 2 | 82551 | 91 | 2.456 | 33612.0 |
548 | 2021-11-22 06:26:42 | barret | 2 | 82551 | 91 | 2.530 | 32628.9 |
547 | 2021-11-21 18:45:43 | barret | 2 | 82551 | 91 | 2.203 | 37472.1 |
546 | 2021-11-15 16:47:34 | barret | 1 | 48755 | 9 | 0.893 | 54596.9 |
545 | 2021-11-15 14:37:36 | barret | 1 | 48755 | 9 | 0.840 | 58041.7 |