History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canoes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
651 | 2024-12-12 08:38:34 | canoes | 1 | 48755 | 7 | 6.720 | 7255.2 |
650 | 2024-12-09 16:24:52 | canoes | 1 | 48755 | 7 | 5.953 | 8190.0 |
649 | 2024-12-06 18:34:53 | canoes | 1 | 48755 | 7 | 4.140 | 11776.6 |
648 | 2024-11-27 12:52:18 | canoes | 1 | 48755 | 7 | 3.890 | 12533.4 |
647 | 2024-11-20 21:48:38 | canoes | 1 | 48755 | 7 | 3.640 | 13394.2 |
646 | 2024-11-09 08:14:05 | canoes | 2 | 82551 | 158 | 13.750 | 6003.7 |
645 | 2024-11-08 23:18:58 | canoes | 2 | 82551 | 158 | 17.920 | 4606.6 |
644 | 2024-11-08 15:27:32 | canoes | 2 | 82551 | 158 | 7.686 | 10740.4 |
643 | 2024-11-08 15:20:44 | canoes | 1 | 48755 | 7 | 0.763 | 63899.1 |
642 | 2024-11-06 16:33:49 | canoes | 1 | 48755 | 7 | 1.936 | 25183.4 |
641 | 2024-10-28 09:15:47 | canoes | 1 | 48755 | 7 | 4.283 | 11383.4 |
640 | 2024-09-28 07:14:48 | canoes | 1 | 48755 | 7 | 3.063 | 15917.4 |
639 | 2024-09-08 16:32:22 | canoes | 1 | 48755 | 7 | 3.873 | 12588.4 |
638 | 2024-09-06 02:27:43 | canoes | 1 | 48755 | 7 | 9.516 | 5123.5 |
637 | 2024-09-04 20:58:23 | canoes | 1 | 48755 | 7 | 3.296 | 14792.2 |
636 | 2024-08-29 16:34:12 | canoes | 1 | 48755 | 7 | 8.360 | 5831.9 |
635 | 2024-08-29 00:06:35 | canoes | 1 | 48755 | 7 | 12.080 | 4036.0 |
634 | 2024-08-28 23:01:33 | canoes | 1 | 48755 | 7 | 3.046 | 16006.2 |
633 | 2024-08-15 08:10:36 | canoes | 1 | 48755 | 7 | 6.110 | 7979.5 |
632 | 2024-08-10 23:36:48 | canoes | 1 | 48755 | 7 | 4.046 | 12050.2 |
631 | 2024-08-04 11:17:33 | canoes | 1 | 48755 | 7 | 3.673 | 13273.9 |
630 | 2024-07-31 08:07:16 | canoes | 1 | 48755 | 7 | 2.000 | 24377.5 |
629 | 2024-07-30 20:25:32 | canoes | 1 | 48755 | 7 | 2.436 | 20014.4 |
628 | 2024-07-28 11:00:35 | canoes | 1 | 48755 | 7 | 2.000 | 24377.5 |
627 | 2024-07-26 17:32:32 | canoes | 1 | 48755 | 7 | 2.143 | 22750.8 |
626 | 2024-07-11 07:06:17 | canoes | 1 | 48755 | 7 | 3.140 | 15527.1 |
625 | 2024-07-09 21:54:49 | canoes | 1 | 48755 | 7 | 3.283 | 14850.7 |
624 | 2024-07-08 11:52:52 | canoes | 1 | 48755 | 7 | 4.126 | 11816.5 |
623 | 2024-07-01 16:25:55 | canoes | 1 | 48755 | 7 | 1.360 | 35849.3 |
622 | 2024-06-29 22:18:03 | canoes | 1 | 48755 | 7 | 4.110 | 11862.5 |
621 | 2024-06-28 07:25:51 | canoes | 1 | 48755 | 7 | 2.140 | 22782.7 |
620 | 2024-06-26 14:23:58 | canoes | 1 | 48755 | 7 | 3.030 | 16090.8 |
619 | 2024-06-08 18:36:09 | canoes | 1 | 48755 | 7 | 1.763 | 27654.6 |
618 | 2024-05-29 05:02:42 | canoes | 1 | 48755 | 7 | 3.923 | 12428.0 |
617 | 2024-05-27 15:33:37 | canoes | 1 | 48755 | 7 | 2.263 | 21544.4 |
616 | 2024-05-27 12:33:35 | canoes | 1 | 48755 | 7 | 1.250 | 39004.0 |
615 | 2024-05-07 12:59:58 | canoes | 1 | 48755 | 7 | 0.890 | 54780.9 |
614 | 2024-05-04 08:39:58 | canoes | 1 | 48755 | 7 | 0.970 | 50262.9 |
613 | 2024-04-27 12:02:12 | canoes | 1 | 48755 | 7 | 1.376 | 35432.4 |
612 | 2024-04-10 17:38:10 | canoes | 1 | 48755 | 7 | 0.936 | 52088.7 |
611 | 2024-04-03 07:14:08 | canoes | 1 | 48755 | 7 | 3.030 | 16090.8 |
610 | 2024-03-31 12:08:28 | canoes | 1 | 48755 | 7 | 2.923 | 16679.8 |
609 | 2024-03-20 16:59:31 | canoes | 1 | 48755 | 7 | 0.793 | 61481.7 |
608 | 2024-03-16 22:25:22 | canoes | 1 | 48755 | 7 | 0.920 | 52994.6 |
607 | 2024-03-13 01:02:33 | canoes | 1 | 48755 | 7 | 2.033 | 23981.8 |
606 | 2024-03-03 23:48:19 | canoes | 1 | 48755 | 7 | 2.970 | 16415.8 |
605 | 2024-02-28 10:27:36 | canoes | 1 | 48755 | 7 | 5.876 | 8297.3 |
604 | 2024-01-31 19:00:16 | canoes | 2 | 82551 | 158 | 2.530 | 32628.9 |
603 | 2024-01-31 05:27:11 | canoes | 2 | 82551 | 158 | 2.453 | 33653.1 |
602 | 2024-01-31 03:11:20 | canoes | 2 | 82551 | 158 | 2.406 | 34310.5 |
601 | 2024-01-29 07:07:15 | canoes | 1 | 48755 | 7 | 0.876 | 55656.4 |
600 | 2024-01-24 22:09:21 | canoes | 1 | 48755 | 7 | 0.780 | 62506.4 |
599 | 2024-01-17 19:40:20 | canoes | 1 | 48755 | 7 | 0.780 | 62506.4 |
598 | 2024-01-05 23:50:46 | canoes | 1 | 48755 | 7 | 0.796 | 61250.0 |
597 | 2023-12-13 11:02:19 | canoes | 1 | 48755 | 7 | 0.796 | 61250.0 |
596 | 2023-11-30 03:12:55 | canoes | 2 | 82551 | 158 | 2.736 | 30172.1 |
595 | 2023-11-30 02:31:20 | canoes | 2 | 82551 | 158 | 2.483 | 33246.5 |
594 | 2023-11-27 23:25:02 | canoes | 2 | 82551 | 158 | 2.596 | 31799.3 |
593 | 2023-11-25 14:45:43 | canoes | 1 | 48755 | 7 | 0.796 | 61250.0 |
592 | 2023-11-17 06:27:59 | canoes | 1 | 48755 | 7 | 0.873 | 55847.7 |
591 | 2023-11-16 04:33:05 | canoes | 1 | 48755 | 7 | 0.796 | 61250.0 |
590 | 2023-11-10 01:31:32 | canoes | 2 | 82551 | 158 | 2.500 | 33020.4 |
589 | 2023-11-04 16:21:20 | canoes | 1 | 48755 | 7 | 0.843 | 57835.1 |
588 | 2023-10-26 00:15:26 | canoes | 2 | 82551 | 158 | 2.313 | 35690.0 |
587 | 2023-10-25 19:16:46 | canoes | 1 | 48755 | 7 | 1.903 | 25620.1 |
586 | 2023-10-25 19:04:20 | canoes | 1 | 48755 | 7 | 0.783 | 62266.9 |
585 | 2023-10-22 01:31:43 | canoes | 2 | 82551 | 158 | 2.686 | 30733.8 |
584 | 2023-10-17 00:20:07 | canoes | 1 | 48755 | 7 | 1.750 | 27860.0 |
583 | 2023-10-13 12:21:23 | canoes | 1 | 48755 | 7 | 0.830 | 58741.0 |
582 | 2023-10-08 10:16:30 | canoes | 1 | 48755 | 7 | 0.860 | 56691.9 |
581 | 2023-09-30 01:52:13 | canoes | 2 | 82551 | 158 | 2.546 | 32423.8 |
580 | 2023-09-24 21:37:06 | canoes | 1 | 48755 | 7 | 0.860 | 56691.9 |
579 | 2023-09-20 13:08:19 | canoes | 1 | 48755 | 7 | 0.876 | 55656.4 |
578 | 2023-09-16 12:40:39 | canoes | 1 | 48755 | 7 | 0.766 | 63648.8 |
577 | 2023-09-11 13:45:15 | canoes | 1 | 48755 | 7 | 0.890 | 54780.9 |
576 | 2023-09-06 11:51:34 | canoes | 1 | 48755 | 7 | 0.843 | 57835.1 |
575 | 2023-08-12 19:47:51 | canoes | 2 | 82551 | 158 | 2.236 | 36919.1 |
574 | 2023-06-06 02:25:08 | canoes | 1 | 48755 | 7 | 0.843 | 57835.1 |
573 | 2023-06-02 19:15:50 | canoes | 1 | 48755 | 7 | 0.750 | 65006.7 |
572 | 2023-04-27 03:17:12 | canoes | 2 | 82551 | 158 | 2.216 | 37252.3 |
571 | 2023-04-07 16:28:53 | canoes | 1 | 48755 | 7 | 0.750 | 65006.7 |
570 | 2023-02-28 03:12:50 | canoes | 1 | 48755 | 7 | 0.750 | 65006.7 |
569 | 2023-01-31 01:44:45 | canoes | 2 | 82551 | 158 | 2.190 | 37694.5 |
568 | 2023-01-29 04:14:17 | canoes | 1 | 48755 | 7 | 0.750 | 65006.7 |
567 | 2022-11-26 01:45:13 | canoes | 1 | 48755 | 7 | 0.923 | 52822.3 |
566 | 2022-11-25 11:03:57 | canoes | 1 | 48755 | 7 | 0.846 | 57630.0 |
565 | 2022-11-11 07:30:42 | canoes | 2 | 82551 | 158 | 2.173 | 37989.4 |
564 | 2022-08-25 06:20:00 | canoes | 1 | 48755 | 7 | 0.906 | 53813.5 |
563 | 2022-08-15 04:44:51 | canoes | 1 | 48755 | 7 | 0.763 | 63899.1 |
562 | 2022-08-06 19:02:36 | canoes | 1 | 48755 | 7 | 0.986 | 49447.3 |
561 | 2022-07-29 12:07:09 | canoes | 1 | 48755 | 7 | 0.783 | 62266.9 |
560 | 2022-07-20 18:59:33 | canoes | 1 | 48755 | 7 | 0.800 | 60943.8 |
559 | 2022-07-10 11:39:04 | canoes | 1 | 48755 | 7 | 0.766 | 63648.8 |
558 | 2022-07-02 20:43:58 | canoes | 1 | 48755 | 7 | 0.813 | 59969.2 |
557 | 2022-06-15 22:27:11 | canoes | 1 | 48755 | 7 | 0.780 | 62506.4 |
556 | 2022-06-04 15:16:35 | canoes | 2 | 82551 | 158 | 2.216 | 37252.3 |
555 | 2022-05-22 22:31:11 | canoes | 1 | 48755 | 7 | 0.860 | 56691.9 |
554 | 2022-05-20 05:11:54 | canoes | 1 | 48755 | 7 | 0.813 | 59969.2 |
553 | 2022-05-19 12:25:31 | canoes | 1 | 48755 | 7 | 0.783 | 62266.9 |
552 | 2022-04-26 00:54:50 | canoes | 1 | 48755 | 7 | 0.906 | 53813.5 |