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 |
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 |
580 | 2021-12-08 21:36:37 | roofing | 1 | 69583 | 11 | 1.080 | 64428.7 |
579 | 2021-12-04 07:03:34 | roofing | 1 | 69583 | 11 | 1.233 | 56433.9 |
578 | 2021-11-09 14:34:05 | roofing | 1 | 69583 | 11 | 1.280 | 54361.7 |
577 | 2021-10-29 00:30:55 | roofing | 1 | 69583 | 11 | 1.173 | 59320.5 |
576 | 2021-10-26 23:00:29 | roofing | 1 | 69583 | 11 | 1.216 | 57222.9 |
575 | 2021-09-14 11:38:55 | roofing | 1 | 69583 | 11 | 1.720 | 40455.2 |
574 | 2021-09-12 23:33:50 | roofing | 1 | 69583 | 11 | 1.110 | 62687.4 |
573 | 2021-09-10 19:53:44 | roofing | 1 | 69583 | 11 | 1.203 | 57841.2 |
572 | 2021-08-22 16:09:33 | roofing | 1 | 69583 | 11 | 1.076 | 64668.2 |
571 | 2021-05-15 05:51:47 | roofing | 1 | 69583 | 11 | 1.126 | 61796.6 |
570 | 2021-03-28 09:03:20 | roofing | 1 | 69583 | 11 | 2.173 | 32021.6 |
569 | 2021-03-24 00:24:54 | roofing | 1 | 69583 | 11 | 2.500 | 27833.2 |
568 | 2021-02-26 07:01:55 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
567 | 2021-02-12 14:08:35 | roofing | 1 | 69583 | 11 | 1.203 | 57841.2 |
566 | 2020-12-10 08:05:23 | roofing | 1 | 69583 | 11 | 1.076 | 64668.2 |
565 | 2020-11-17 21:53:15 | roofing | 2 | 107671 | 106 | 3.016 | 35699.9 |
564 | 2020-11-10 21:25:22 | roofing | 1 | 69583 | 11 | 1.310 | 53116.8 |
563 | 2020-11-08 12:08:09 | roofing | 1 | 69583 | 11 | 1.156 | 60192.9 |
562 | 2020-10-28 13:01:41 | roofing | 1 | 69583 | 11 | 1.203 | 57841.2 |
561 | 2020-10-27 02:30:51 | roofing | 1 | 69583 | 11 | 1.310 | 53116.8 |
560 | 2020-10-25 19:57:17 | roofing | 1 | 69583 | 11 | 1.266 | 54962.9 |
559 | 2020-10-21 18:17:05 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
558 | 2020-10-09 09:40:09 | roofing | 1 | 69583 | 11 | 1.063 | 65459.1 |
557 | 2020-09-02 15:20:15 | roofing | 1 | 69583 | 11 | 1.186 | 58670.3 |
556 | 2020-08-10 21:09:32 | roofing | 1 | 69583 | 11 | 1.390 | 50059.7 |
555 | 2020-08-07 23:25:27 | roofing | 1 | 69583 | 11 | 1.170 | 59472.6 |
554 | 2020-07-13 19:27:35 | roofing | 1 | 69583 | 11 | 1.140 | 61037.7 |
553 | 2020-05-06 14:28:33 | roofing | 1 | 69583 | 11 | 1.173 | 59320.5 |
552 | 2020-04-05 19:15:31 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
551 | 2020-03-29 02:54:31 | roofing | 1 | 69583 | 11 | 1.266 | 54962.9 |
550 | 2020-03-26 05:37:18 | roofing | 1 | 69583 | 11 | 1.233 | 56433.9 |
549 | 2020-03-24 13:51:03 | roofing | 1 | 69583 | 11 | 2.296 | 30306.2 |
548 | 2020-03-20 22:54:22 | roofing | 1 | 69583 | 11 | 1.063 | 65459.1 |
547 | 2020-02-27 17:08:20 | roofing | 1 | 69583 | 11 | 1.280 | 54361.7 |
546 | 2020-02-23 01:27:38 | roofing | 1 | 69583 | 11 | 2.580 | 26970.2 |
545 | 2020-02-15 03:04:20 | roofing | 1 | 69583 | 11 | 1.390 | 50059.7 |
544 | 2020-02-11 10:48:48 | roofing | 1 | 69583 | 11 | 4.126 | 16864.5 |
543 | 2020-02-05 14:05:43 | roofing | 1 | 69583 | 11 | 2.796 | 24886.6 |