History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roofing"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
680 | 2025-01-04 21:54:25 | roofing | 1 | 69583 | 11 | 2.156 | 32274.1 |
679 | 2024-12-30 07:28:19 | roofing | 1 | 69583 | 11 | 2.983 | 23326.5 |
678 | 2024-12-28 11:44:58 | roofing | 1 | 69583 | 11 | 5.190 | 13407.1 |
677 | 2024-12-16 12:21:22 | roofing | 1 | 69583 | 11 | 4.780 | 14557.1 |
676 | 2024-11-28 23:56:20 | roofing | 1 | 69583 | 11 | 6.143 | 11327.2 |
675 | 2024-11-15 13:31:07 | roofing | 1 | 69583 | 11 | 2.610 | 26660.2 |
674 | 2024-11-11 02:53:28 | roofing | 1 | 69583 | 11 | 3.153 | 22068.8 |
673 | 2024-10-27 23:28:03 | roofing | 1 | 69583 | 11 | 2.826 | 24622.4 |
672 | 2024-10-15 19:03:15 | roofing | 2 | 107671 | 106 | 13.343 | 8069.5 |
671 | 2024-10-15 19:03:18 | roofing | 1 | 69583 | 11 | 5.953 | 11688.7 |
670 | 2024-10-13 22:32:47 | roofing | 2 | 107671 | 106 | 16.190 | 6650.5 |
669 | 2024-10-11 20:48:56 | roofing | 2 | 107671 | 106 | 14.843 | 7254.0 |
668 | 2024-10-11 20:26:08 | roofing | 2 | 107671 | 106 | 17.190 | 6263.6 |
667 | 2024-10-11 20:25:55 | roofing | 1 | 69583 | 11 | 5.203 | 13373.6 |
666 | 2024-09-24 12:06:38 | roofing | 1 | 69583 | 11 | 4.530 | 15360.5 |
665 | 2024-09-24 01:16:39 | roofing | 1 | 69583 | 11 | 16.940 | 4107.6 |
664 | 2024-09-11 17:52:42 | roofing | 1 | 69583 | 11 | 3.843 | 18106.4 |
663 | 2024-09-06 03:59:31 | roofing | 1 | 69583 | 11 | 9.703 | 7171.3 |
662 | 2024-09-04 22:24:50 | roofing | 1 | 69583 | 11 | 12.643 | 5503.7 |
661 | 2024-08-19 19:29:36 | roofing | 1 | 69583 | 11 | 4.236 | 16426.6 |
660 | 2024-08-16 01:17:22 | roofing | 1 | 69583 | 11 | 8.266 | 8418.0 |
659 | 2024-08-01 07:47:19 | roofing | 1 | 69583 | 11 | 5.330 | 13055.0 |
658 | 2024-07-31 01:52:05 | roofing | 1 | 69583 | 11 | 4.373 | 15912.0 |
657 | 2024-07-31 01:18:33 | roofing | 1 | 69583 | 11 | 4.780 | 14557.1 |
656 | 2024-07-25 10:35:37 | roofing | 1 | 69583 | 11 | 5.470 | 12720.8 |
655 | 2024-07-12 11:07:39 | roofing | 1 | 69583 | 11 | 1.453 | 47889.2 |
654 | 2024-07-08 21:26:15 | roofing | 1 | 69583 | 11 | 5.000 | 13916.6 |
653 | 2024-07-05 21:51:47 | roofing | 1 | 69583 | 11 | 4.033 | 17253.4 |
652 | 2024-07-05 08:42:18 | roofing | 1 | 69583 | 11 | 2.253 | 30884.6 |
651 | 2024-07-01 23:04:41 | roofing | 1 | 69583 | 11 | 5.860 | 11874.2 |
650 | 2024-06-30 12:18:15 | roofing | 1 | 69583 | 11 | 3.986 | 17456.8 |
649 | 2024-06-30 09:21:22 | roofing | 1 | 69583 | 11 | 5.986 | 11624.3 |
648 | 2024-06-27 01:16:52 | roofing | 1 | 69583 | 11 | 3.596 | 19350.1 |
647 | 2024-06-23 23:03:30 | roofing | 1 | 69583 | 11 | 6.190 | 11241.2 |
646 | 2024-06-21 07:32:29 | roofing | 1 | 69583 | 11 | 2.733 | 25460.3 |
645 | 2024-06-09 09:31:01 | roofing | 1 | 69583 | 11 | 2.233 | 31161.2 |
644 | 2024-05-27 10:23:30 | roofing | 1 | 69583 | 11 | 1.393 | 49951.9 |
643 | 2024-05-24 12:44:06 | roofing | 1 | 69583 | 11 | 2.813 | 24736.2 |
642 | 2024-04-20 23:34:14 | roofing | 1 | 69583 | 11 | 3.250 | 21410.2 |
641 | 2024-04-20 22:15:25 | roofing | 2 | 107671 | 106 | 8.576 | 12554.9 |
640 | 2024-04-19 20:16:31 | roofing | 2 | 107671 | 106 | 5.140 | 20947.7 |
639 | 2024-04-16 15:58:51 | roofing | 2 | 107671 | 106 | 13.033 | 8261.4 |
638 | 2024-04-14 10:01:11 | roofing | 2 | 107671 | 106 | 2.843 | 37872.3 |
637 | 2024-04-06 09:29:38 | roofing | 1 | 69583 | 11 | 3.673 | 18944.5 |
636 | 2024-04-04 15:38:48 | roofing | 1 | 69583 | 11 | 2.780 | 25029.9 |
635 | 2024-04-02 11:14:29 | roofing | 1 | 69583 | 11 | 1.123 | 61961.7 |
634 | 2024-03-28 16:42:12 | roofing | 1 | 69583 | 11 | 1.233 | 56433.9 |
633 | 2024-03-20 19:53:48 | roofing | 1 | 69583 | 11 | 1.423 | 48898.8 |
632 | 2024-02-18 21:18:15 | roofing | 2 | 107671 | 106 | 7.686 | 14008.7 |
631 | 2024-02-18 13:48:47 | roofing | 1 | 69583 | 11 | 1.173 | 59320.5 |
630 | 2024-01-18 01:14:34 | roofing | 1 | 69583 | 11 | 1.250 | 55666.4 |
629 | 2023-12-25 15:09:37 | roofing | 1 | 69583 | 11 | 1.076 | 64668.2 |
628 | 2023-12-17 02:55:17 | roofing | 2 | 107671 | 106 | 3.670 | 29338.1 |
627 | 2023-12-15 05:19:36 | roofing | 1 | 69583 | 11 | 1.233 | 56433.9 |
626 | 2023-12-12 14:29:10 | roofing | 1 | 69583 | 11 | 1.360 | 51164.0 |
625 | 2023-12-11 19:26:18 | roofing | 1 | 69583 | 11 | 1.216 | 57222.9 |
624 | 2023-12-09 10:38:10 | roofing | 2 | 107671 | 106 | 2.796 | 38508.9 |
623 | 2023-11-12 04:57:58 | roofing | 1 | 69583 | 11 | 1.080 | 64428.7 |
622 | 2023-11-03 13:18:07 | roofing | 1 | 69583 | 11 | 1.063 | 65459.1 |
621 | 2023-11-02 18:10:03 | roofing | 1 | 69583 | 11 | 1.313 | 52995.4 |
620 | 2023-10-13 12:56:59 | roofing | 1 | 69583 | 11 | 1.313 | 52995.4 |
619 | 2023-10-06 21:14:41 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
618 | 2023-09-11 13:02:24 | roofing | 2 | 107671 | 106 | 3.483 | 30913.3 |
617 | 2023-09-07 11:26:10 | roofing | 2 | 107671 | 106 | 2.983 | 36094.9 |
616 | 2023-08-09 04:37:37 | roofing | 1 | 69583 | 11 | 1.173 | 59320.5 |
615 | 2023-08-04 23:23:54 | roofing | 1 | 69583 | 11 | 1.250 | 55666.4 |
614 | 2023-05-28 15:10:28 | roofing | 2 | 107671 | 106 | 3.546 | 30364.1 |
613 | 2023-05-06 20:41:33 | roofing | 1 | 69583 | 11 | 1.076 | 64668.2 |
612 | 2023-04-09 04:34:56 | roofing | 1 | 69583 | 11 | 1.236 | 56296.9 |
611 | 2023-03-06 15:35:44 | roofing | 2 | 107671 | 106 | 2.860 | 37647.2 |
610 | 2023-02-27 09:43:05 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
609 | 2022-12-24 22:49:09 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
608 | 2022-12-20 03:59:15 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
607 | 2022-12-16 19:54:03 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
606 | 2022-12-14 16:42:40 | roofing | 2 | 107671 | 106 | 3.220 | 33438.2 |
605 | 2022-09-19 14:34:33 | roofing | 1 | 69583 | 11 | 1.200 | 57985.8 |
604 | 2022-09-18 11:02:34 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
603 | 2022-09-13 10:27:57 | roofing | 2 | 107671 | 106 | 2.813 | 38276.2 |
602 | 2022-09-11 18:29:22 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
601 | 2022-09-09 16:58:10 | roofing | 1 | 69583 | 11 | 1.096 | 63488.1 |
600 | 2022-09-09 10:55:44 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
599 | 2022-08-10 04:23:32 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
598 | 2022-08-07 01:02:49 | roofing | 1 | 69583 | 11 | 1.203 | 57841.2 |
597 | 2022-08-06 22:27:36 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
596 | 2022-08-06 05:11:44 | roofing | 1 | 69583 | 11 | 1.110 | 62687.4 |
595 | 2022-08-05 21:13:07 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
594 | 2022-08-04 16:32:04 | roofing | 2 | 107671 | 106 | 2.873 | 37476.9 |
593 | 2022-07-27 00:13:58 | roofing | 1 | 69583 | 11 | 1.423 | 48898.8 |
592 | 2022-07-10 02:45:22 | roofing | 1 | 69583 | 11 | 1.123 | 61961.7 |
591 | 2022-07-02 14:45:49 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
590 | 2022-06-29 00:22:00 | roofing | 2 | 107671 | 106 | 2.893 | 37217.8 |
589 | 2022-04-20 20:55:42 | roofing | 1 | 69583 | 11 | 1.250 | 55666.4 |
588 | 2022-04-18 17:07:23 | roofing | 1 | 69583 | 11 | 1.156 | 60192.9 |
587 | 2022-03-26 17:24:00 | roofing | 1 | 69583 | 11 | 1.343 | 51811.6 |
586 | 2022-03-26 05:57:39 | roofing | 1 | 69583 | 11 | 1.106 | 62914.1 |
585 | 2022-03-23 23:42:28 | roofing | 1 | 69583 | 11 | 1.410 | 49349.6 |
584 | 2022-03-23 20:08:52 | roofing | 1 | 69583 | 11 | 1.720 | 40455.2 |
583 | 2021-12-30 13:02:37 | roofing | 1 | 69583 | 11 | 1.500 | 46388.7 |
582 | 2021-12-28 08:52:36 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
581 | 2021-12-26 06:18:42 | roofing | 1 | 69583 | 11 | 1.406 | 49490.0 |