History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"decreed"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
643 | 2024-06-14 17:47:07 | decreed | 1 | 69583 | 6 | 2.346 | 29660.3 |
642 | 2024-06-14 05:52:53 | decreed | 1 | 69583 | 6 | 4.533 | 15350.3 |
641 | 2024-06-13 23:32:11 | decreed | 1 | 69583 | 6 | 2.263 | 30748.1 |
640 | 2024-06-13 19:20:12 | decreed | 3 | 134027 | 380 | 13.720 | 9768.7 |
639 | 2024-06-13 17:58:30 | decreed | 1 | 69583 | 6 | 4.813 | 14457.3 |
638 | 2024-06-12 17:43:24 | decreed | 1 | 69583 | 6 | 3.110 | 22374.0 |
637 | 2024-06-12 06:45:09 | decreed | 1 | 69583 | 6 | 5.563 | 12508.2 |
636 | 2024-06-11 23:48:07 | decreed | 3 | 134027 | 380 | 22.126 | 6057.4 |
635 | 2024-06-11 22:46:44 | decreed | 3 | 134027 | 380 | 12.970 | 10333.6 |
634 | 2024-06-11 17:56:16 | decreed | 1 | 69583 | 6 | 2.860 | 24329.7 |
633 | 2024-06-11 15:42:41 | decreed | 3 | 134027 | 380 | 22.930 | 5845.1 |
632 | 2024-06-11 11:44:57 | decreed | 3 | 134027 | 380 | 10.736 | 12483.9 |
631 | 2024-06-09 12:19:38 | decreed | 1 | 69583 | 6 | 2.653 | 26228.0 |
630 | 2024-06-09 07:35:07 | decreed | 1 | 69583 | 6 | 4.580 | 15192.8 |
629 | 2024-06-03 09:48:23 | decreed | 1 | 69583 | 6 | 1.236 | 56296.9 |
628 | 2024-06-02 17:55:42 | decreed | 1 | 69583 | 6 | 1.263 | 55093.4 |
627 | 2024-06-02 09:44:03 | decreed | 1 | 69583 | 6 | 2.516 | 27656.2 |
626 | 2024-06-01 09:33:55 | decreed | 1 | 69583 | 6 | 4.296 | 16197.2 |
625 | 2024-05-31 12:14:54 | decreed | 1 | 69583 | 6 | 1.376 | 50569.0 |
624 | 2024-05-30 22:28:58 | decreed | 1 | 69583 | 6 | 1.670 | 41666.5 |
623 | 2024-05-29 22:40:01 | decreed | 1 | 69583 | 6 | 3.860 | 18026.7 |
622 | 2024-05-28 22:32:18 | decreed | 1 | 69583 | 6 | 4.656 | 14944.8 |
621 | 2024-05-28 06:16:36 | decreed | 1 | 69583 | 6 | 5.236 | 13289.3 |
620 | 2024-05-27 06:21:41 | decreed | 1 | 69583 | 6 | 2.796 | 24886.6 |
619 | 2024-05-26 06:27:44 | decreed | 1 | 69583 | 6 | 1.986 | 35036.8 |
618 | 2024-05-25 13:58:18 | decreed | 1 | 69583 | 6 | 2.953 | 23563.5 |
617 | 2024-05-24 14:07:09 | decreed | 1 | 69583 | 6 | 1.513 | 45990.1 |
616 | 2024-05-23 14:16:03 | decreed | 1 | 69583 | 6 | 1.453 | 47889.2 |
615 | 2024-05-22 02:25:43 | decreed | 1 | 69583 | 6 | 2.936 | 23699.9 |
614 | 2024-05-21 10:51:19 | decreed | 1 | 69583 | 6 | 1.500 | 46388.7 |
613 | 2024-05-21 01:13:10 | decreed | 1 | 69583 | 6 | 2.720 | 25582.0 |
612 | 2024-05-20 01:44:49 | decreed | 1 | 69583 | 6 | 4.220 | 16488.9 |
611 | 2024-05-18 11:46:46 | decreed | 1 | 69583 | 6 | 2.906 | 23944.6 |
610 | 2024-05-18 01:31:30 | decreed | 1 | 69583 | 6 | 2.780 | 25029.9 |
609 | 2024-05-17 12:19:32 | decreed | 1 | 69583 | 6 | 1.796 | 38743.3 |
608 | 2024-05-17 01:19:25 | decreed | 1 | 69583 | 6 | 1.296 | 53690.6 |
607 | 2024-05-15 17:41:37 | decreed | 1 | 69583 | 6 | 2.953 | 23563.5 |
606 | 2024-05-14 20:38:55 | decreed | 1 | 69583 | 6 | 1.373 | 50679.5 |
605 | 2024-05-14 20:02:30 | decreed | 1 | 69583 | 6 | 1.283 | 54234.6 |
604 | 2024-05-13 16:46:36 | decreed | 1 | 69583 | 6 | 4.343 | 16021.9 |
603 | 2024-05-13 01:01:26 | decreed | 1 | 69583 | 6 | 2.220 | 31343.7 |
602 | 2024-05-12 11:49:11 | decreed | 1 | 69583 | 6 | 2.656 | 26198.4 |
601 | 2024-05-12 00:52:54 | decreed | 1 | 69583 | 6 | 2.763 | 25183.9 |
600 | 2024-05-11 10:33:09 | decreed | 1 | 69583 | 6 | 1.576 | 44151.6 |
599 | 2024-05-11 01:23:12 | decreed | 1 | 69583 | 6 | 2.796 | 24886.6 |
598 | 2024-05-10 10:28:05 | decreed | 1 | 69583 | 6 | 1.513 | 45990.1 |
597 | 2024-05-10 00:38:25 | decreed | 1 | 69583 | 6 | 2.783 | 25002.9 |
596 | 2024-05-09 14:57:14 | decreed | 2 | 107671 | 28 | 9.190 | 11716.1 |
595 | 2024-05-09 11:26:41 | decreed | 1 | 69583 | 6 | 4.263 | 16322.5 |
594 | 2024-05-09 00:38:51 | decreed | 1 | 69583 | 6 | 3.373 | 20629.4 |
593 | 2024-05-08 14:59:36 | decreed | 2 | 107671 | 28 | 3.453 | 31181.9 |
592 | 2024-05-08 11:12:00 | decreed | 1 | 69583 | 6 | 2.373 | 29322.8 |
591 | 2024-05-08 00:44:41 | decreed | 1 | 69583 | 6 | 1.283 | 54234.6 |
590 | 2024-05-07 10:39:21 | decreed | 1 | 69583 | 6 | 1.216 | 57222.9 |
589 | 2024-05-07 01:15:59 | decreed | 3 | 134027 | 380 | 7.580 | 17681.7 |
588 | 2024-05-07 01:01:49 | decreed | 1 | 69583 | 6 | 2.046 | 34009.3 |
587 | 2024-05-07 01:01:08 | decreed | 1 | 69583 | 6 | 4.143 | 16795.3 |
586 | 2024-05-06 20:11:09 | decreed | 3 | 134027 | 380 | 7.470 | 17942.0 |
585 | 2024-05-06 20:10:57 | decreed | 2 | 107671 | 28 | 7.266 | 14818.5 |
584 | 2024-05-06 10:50:08 | decreed | 1 | 69583 | 6 | 1.343 | 51811.6 |
583 | 2024-05-06 02:44:32 | decreed | 2 | 107671 | 28 | 3.876 | 27778.9 |
582 | 2024-05-06 00:41:52 | decreed | 1 | 69583 | 6 | 2.640 | 26357.2 |
581 | 2024-05-05 00:05:35 | decreed | 1 | 69583 | 6 | 2.656 | 26198.4 |
580 | 2024-05-04 19:05:35 | decreed | 1 | 69583 | 6 | 1.716 | 40549.5 |
579 | 2024-05-04 12:35:16 | decreed | 1 | 69583 | 6 | 1.326 | 52475.9 |
578 | 2024-05-04 00:40:52 | decreed | 1 | 69583 | 6 | 4.000 | 17395.8 |
577 | 2024-05-03 11:33:33 | decreed | 1 | 69583 | 6 | 4.330 | 16070.0 |
576 | 2024-05-03 00:51:00 | decreed | 1 | 69583 | 6 | 1.126 | 61796.6 |
575 | 2024-05-02 10:52:32 | decreed | 1 | 69583 | 6 | 3.970 | 17527.2 |
574 | 2024-05-02 00:30:12 | decreed | 1 | 69583 | 6 | 3.173 | 21929.7 |
573 | 2024-05-01 21:38:07 | decreed | 1 | 69583 | 6 | 1.233 | 56433.9 |
572 | 2024-04-29 13:32:41 | decreed | 2 | 107671 | 28 | 3.220 | 33438.2 |
571 | 2024-04-29 13:32:17 | decreed | 3 | 134027 | 380 | 7.203 | 18607.1 |
570 | 2024-04-28 08:09:08 | decreed | 3 | 134027 | 380 | 6.000 | 22337.8 |
569 | 2024-04-28 04:24:10 | decreed | 3 | 134027 | 380 | 13.686 | 9793.0 |
568 | 2024-04-27 12:22:01 | decreed | 1 | 69583 | 6 | 1.326 | 52475.9 |
567 | 2024-04-27 01:31:17 | decreed | 3 | 134027 | 380 | 16.690 | 8030.4 |
566 | 2024-04-26 12:10:04 | decreed | 1 | 69583 | 6 | 1.310 | 53116.8 |
565 | 2024-04-25 12:30:40 | decreed | 1 | 69583 | 6 | 1.360 | 51164.0 |
564 | 2024-04-24 12:31:41 | decreed | 1 | 69583 | 6 | 2.393 | 29077.7 |
563 | 2024-04-23 12:48:43 | decreed | 1 | 69583 | 6 | 1.236 | 56296.9 |
562 | 2024-04-16 19:57:14 | decreed | 1 | 69583 | 6 | 2.750 | 25302.9 |
561 | 2024-04-16 08:24:54 | decreed | 1 | 69583 | 6 | 1.220 | 57035.2 |
560 | 2024-04-15 19:28:57 | decreed | 1 | 69583 | 6 | 1.280 | 54361.7 |
559 | 2024-04-14 19:16:08 | decreed | 1 | 69583 | 6 | 4.936 | 14097.0 |
558 | 2024-04-14 08:52:36 | decreed | 1 | 69583 | 6 | 3.330 | 20895.8 |
557 | 2024-04-13 18:57:32 | decreed | 1 | 69583 | 6 | 2.830 | 24587.6 |
556 | 2024-04-07 10:39:53 | decreed | 1 | 69583 | 6 | 1.436 | 48456.1 |
555 | 2024-04-06 15:41:48 | decreed | 1 | 69583 | 6 | 1.330 | 52318.0 |
554 | 2024-04-05 21:01:42 | decreed | 1 | 69583 | 6 | 1.406 | 49490.0 |
553 | 2024-04-05 01:41:06 | decreed | 1 | 69583 | 6 | 1.250 | 55666.4 |
552 | 2024-04-04 06:11:35 | decreed | 1 | 69583 | 6 | 1.356 | 51314.9 |
551 | 2024-04-04 00:37:51 | decreed | 1 | 69583 | 6 | 1.390 | 50059.7 |
550 | 2024-04-03 17:22:41 | decreed | 1 | 69583 | 6 | 1.436 | 48456.1 |
549 | 2024-04-03 01:50:51 | decreed | 1 | 69583 | 6 | 1.500 | 46388.7 |
548 | 2024-03-27 09:05:49 | decreed | 2 | 107671 | 28 | 3.220 | 33438.2 |
547 | 2024-03-27 09:02:21 | decreed | 3 | 134027 | 380 | 6.830 | 19623.3 |
546 | 2024-03-26 13:18:56 | decreed | 1 | 69583 | 6 | 1.390 | 50059.7 |
545 | 2024-03-26 03:43:57 | decreed | 1 | 69583 | 6 | 1.110 | 62687.4 |
544 | 2024-03-25 21:21:27 | decreed | 3 | 134027 | 380 | 14.750 | 9086.6 |