History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"towels"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
642 | 2024-04-29 04:43:49 | towels | 2 | 82551 | 88 | 2.343 | 35233.0 |
641 | 2024-04-29 04:43:18 | towels | 3 | 112716 | 1040 | 5.423 | 20784.8 |
640 | 2024-04-27 21:33:46 | towels | 3 | 112716 | 1040 | 10.733 | 10501.8 |
639 | 2024-04-27 10:01:49 | towels | 3 | 112716 | 1040 | 15.250 | 7391.2 |
638 | 2024-04-26 03:59:40 | towels | 2 | 82551 | 88 | 2.610 | 31628.7 |
637 | 2024-04-26 03:59:32 | towels | 1 | 48755 | 8 | 0.873 | 55847.7 |
636 | 2024-04-26 03:59:04 | towels | 3 | 112716 | 1040 | 5.313 | 21215.1 |
635 | 2024-04-25 19:29:11 | towels | 3 | 112716 | 1040 | 6.686 | 16858.5 |
634 | 2024-04-23 00:16:14 | towels | 1 | 48755 | 8 | 0.826 | 59025.4 |
633 | 2024-04-12 17:23:44 | towels | 1 | 48755 | 8 | 1.686 | 28917.6 |
632 | 2024-04-06 01:01:02 | towels | 1 | 48755 | 8 | 1.670 | 29194.6 |
631 | 2024-04-05 23:37:02 | towels | 3 | 112716 | 1040 | 15.156 | 7437.1 |
630 | 2024-04-04 19:44:39 | towels | 3 | 112716 | 1040 | 9.813 | 11486.4 |
629 | 2024-04-04 06:12:58 | towels | 3 | 112716 | 1040 | 9.160 | 12305.2 |
628 | 2024-04-04 04:12:59 | towels | 3 | 112716 | 1040 | 15.796 | 7135.7 |
627 | 2024-03-30 02:33:31 | towels | 3 | 112716 | 1040 | 7.156 | 15751.3 |
626 | 2024-03-30 02:33:27 | towels | 1 | 48755 | 8 | 1.623 | 30040.0 |
625 | 2024-03-29 04:55:01 | towels | 1 | 48755 | 8 | 2.703 | 18037.4 |
624 | 2024-03-06 23:28:23 | towels | 1 | 48755 | 8 | 2.970 | 16415.8 |
623 | 2024-03-04 20:43:01 | towels | 2 | 82551 | 88 | 2.330 | 35429.6 |
622 | 2024-03-04 20:43:00 | towels | 2 | 82551 | 88 | 2.406 | 34310.5 |
621 | 2024-03-04 20:42:56 | towels | 1 | 48755 | 8 | 0.826 | 59025.4 |
620 | 2024-03-04 20:42:22 | towels | 3 | 112716 | 1040 | 7.986 | 14114.2 |
619 | 2024-03-04 04:03:44 | towels | 3 | 112716 | 1040 | 18.483 | 6098.4 |
618 | 2024-03-03 13:29:08 | towels | 2 | 82551 | 88 | 2.516 | 32810.4 |
617 | 2024-03-03 13:28:24 | towels | 3 | 112716 | 1040 | 6.406 | 17595.4 |
616 | 2024-03-02 11:53:08 | towels | 3 | 112716 | 1040 | 10.940 | 10303.1 |
615 | 2024-02-03 06:22:32 | towels | 1 | 48755 | 8 | 1.873 | 26030.4 |
614 | 2024-01-21 09:02:13 | towels | 3 | 112716 | 1040 | 7.170 | 15720.5 |
613 | 2024-01-21 09:02:15 | towels | 2 | 82551 | 88 | 2.376 | 34743.7 |
612 | 2024-01-17 00:46:26 | towels | 3 | 112716 | 1040 | 4.783 | 23566.0 |
611 | 2024-01-17 00:46:21 | towels | 2 | 82551 | 88 | 2.373 | 34787.6 |
610 | 2024-01-10 14:07:41 | towels | 1 | 48755 | 8 | 0.813 | 59969.2 |
609 | 2023-12-30 05:55:48 | towels | 1 | 48755 | 8 | 0.766 | 63648.8 |
608 | 2023-12-22 19:51:53 | towels | 3 | 112716 | 1040 | 4.970 | 22679.3 |
607 | 2023-12-04 01:43:55 | towels | 3 | 112716 | 1040 | 6.766 | 16659.2 |
606 | 2023-12-04 01:43:48 | towels | 3 | 112716 | 1040 | 5.326 | 21163.3 |
605 | 2023-12-04 00:55:17 | towels | 3 | 112716 | 1040 | 8.110 | 13898.4 |
604 | 2023-12-04 00:51:33 | towels | 3 | 112716 | 1040 | 9.096 | 12391.8 |
603 | 2023-11-22 22:13:10 | towels | 3 | 112716 | 1040 | 5.313 | 21215.1 |
602 | 2023-11-18 12:34:41 | towels | 1 | 48755 | 8 | 0.733 | 66514.3 |
601 | 2023-11-16 12:08:19 | towels | 1 | 48755 | 8 | 0.733 | 66514.3 |
600 | 2023-11-12 08:58:56 | towels | 1 | 48755 | 8 | 0.843 | 57835.1 |
599 | 2023-11-09 23:51:39 | towels | 1 | 48755 | 8 | 1.623 | 30040.0 |
598 | 2023-10-20 03:49:21 | towels | 1 | 48755 | 8 | 0.733 | 66514.3 |
597 | 2023-10-19 22:34:05 | towels | 1 | 48755 | 8 | 0.830 | 58741.0 |
596 | 2023-10-15 00:49:09 | towels | 1 | 48755 | 8 | 0.826 | 59025.4 |
595 | 2023-09-29 05:43:51 | towels | 1 | 48755 | 8 | 0.736 | 66243.2 |
594 | 2023-09-23 18:44:36 | towels | 1 | 48755 | 8 | 0.843 | 57835.1 |
593 | 2023-08-28 14:35:27 | towels | 1 | 48755 | 8 | 0.766 | 63648.8 |
592 | 2023-08-22 17:05:38 | towels | 3 | 112716 | 1040 | 4.703 | 23966.8 |
591 | 2023-08-20 23:44:40 | towels | 3 | 112716 | 1040 | 5.873 | 19192.2 |
590 | 2023-08-17 01:46:57 | towels | 1 | 48755 | 8 | 0.810 | 60191.4 |
589 | 2023-08-11 11:13:12 | towels | 3 | 112716 | 1040 | 4.830 | 23336.6 |
588 | 2023-06-23 02:23:47 | towels | 3 | 112716 | 1040 | 5.436 | 20735.1 |
587 | 2023-06-15 20:25:32 | towels | 3 | 112716 | 1040 | 4.906 | 22975.1 |
586 | 2023-06-14 23:30:53 | towels | 3 | 112716 | 1040 | 4.986 | 22606.5 |
585 | 2023-06-13 19:24:07 | towels | 3 | 112716 | 1040 | 4.873 | 23130.7 |
584 | 2023-06-11 23:36:54 | towels | 3 | 112716 | 1040 | 5.200 | 21676.2 |
583 | 2023-05-19 09:28:50 | towels | 1 | 48755 | 8 | 0.750 | 65006.7 |
582 | 2023-04-26 18:01:00 | towels | 1 | 48755 | 8 | 0.830 | 58741.0 |
581 | 2023-03-15 06:23:56 | towels | 1 | 48755 | 8 | 0.826 | 59025.4 |
580 | 2023-01-14 14:27:30 | towels | 3 | 112716 | 1040 | 5.050 | 22320.0 |
579 | 2023-01-13 14:23:23 | towels | 3 | 112716 | 1040 | 5.220 | 21593.1 |
578 | 2023-01-13 08:47:43 | towels | 3 | 112716 | 1040 | 4.936 | 22835.5 |
577 | 2023-01-12 19:06:06 | towels | 3 | 112716 | 1040 | 4.733 | 23814.9 |
576 | 2023-01-12 14:28:21 | towels | 3 | 112716 | 1040 | 4.810 | 23433.7 |
575 | 2023-01-12 05:03:17 | towels | 3 | 112716 | 1040 | 5.703 | 19764.3 |
574 | 2023-01-11 17:13:11 | towels | 3 | 112716 | 1040 | 10.656 | 10577.7 |
573 | 2023-01-11 14:27:46 | towels | 3 | 112716 | 1040 | 4.690 | 24033.3 |
572 | 2023-01-11 03:42:25 | towels | 3 | 112716 | 1040 | 4.640 | 24292.2 |
571 | 2023-01-10 14:34:42 | towels | 3 | 112716 | 1040 | 4.796 | 23502.1 |
570 | 2023-01-09 20:28:37 | towels | 3 | 112716 | 1040 | 4.610 | 24450.3 |
569 | 2023-01-09 14:09:56 | towels | 3 | 112716 | 1040 | 5.093 | 22131.6 |
568 | 2023-01-08 14:07:59 | towels | 3 | 112716 | 1040 | 5.440 | 20719.9 |
567 | 2023-01-07 17:45:55 | towels | 3 | 112716 | 1040 | 4.640 | 24292.2 |
566 | 2023-01-07 17:07:01 | towels | 3 | 112716 | 1040 | 4.706 | 23951.6 |
565 | 2023-01-06 17:06:17 | towels | 3 | 112716 | 1040 | 4.830 | 23336.6 |
564 | 2023-01-05 17:02:49 | towels | 3 | 112716 | 1040 | 5.236 | 21527.1 |
563 | 2023-01-04 17:01:15 | towels | 3 | 112716 | 1040 | 5.626 | 20034.8 |
562 | 2023-01-03 20:17:38 | towels | 1 | 48755 | 8 | 0.843 | 57835.1 |
561 | 2023-01-03 16:52:05 | towels | 3 | 112716 | 1040 | 4.596 | 24524.8 |
560 | 2023-01-02 16:48:21 | towels | 3 | 112716 | 1040 | 4.720 | 23880.5 |
559 | 2023-01-01 16:47:49 | towels | 3 | 112716 | 1040 | 4.593 | 24540.8 |
558 | 2023-01-01 06:14:52 | towels | 3 | 112716 | 1040 | 5.546 | 20323.8 |
557 | 2022-12-31 10:48:47 | towels | 3 | 112716 | 1040 | 5.343 | 21096.0 |
556 | 2022-12-31 06:09:33 | towels | 3 | 112716 | 1040 | 5.016 | 22471.3 |
555 | 2022-12-30 10:05:38 | towels | 3 | 112716 | 1040 | 5.563 | 20261.7 |
554 | 2022-12-30 06:13:22 | towels | 3 | 112716 | 1040 | 4.733 | 23814.9 |
553 | 2022-12-29 06:12:54 | towels | 3 | 112716 | 1040 | 4.860 | 23192.6 |
552 | 2022-12-28 07:31:36 | towels | 3 | 112716 | 1040 | 11.033 | 10216.3 |
551 | 2022-12-26 18:17:22 | towels | 1 | 48755 | 8 | 0.733 | 66514.3 |
550 | 2022-12-06 06:46:48 | towels | 3 | 112716 | 1040 | 5.126 | 21989.1 |
549 | 2022-12-06 03:41:31 | towels | 3 | 112716 | 1040 | 6.000 | 18786.0 |
548 | 2022-11-29 05:58:00 | towels | 3 | 112716 | 1040 | 5.406 | 20850.2 |
547 | 2022-11-16 12:53:03 | towels | 3 | 112716 | 1040 | 4.843 | 23274.0 |
546 | 2022-11-05 20:51:01 | towels | 3 | 112716 | 1040 | 5.830 | 19333.8 |
545 | 2022-11-05 17:53:14 | towels | 3 | 112716 | 1040 | 5.406 | 20850.2 |
544 | 2022-10-31 10:25:04 | towels | 3 | 112716 | 1040 | 4.843 | 23274.0 |
543 | 2022-10-12 21:25:49 | towels | 3 | 112716 | 1040 | 4.673 | 24120.7 |