History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subcode"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 725 | 2026-01-31 01:27:23 | subcode | 1 | 69583 | 2 | 1.280 | 54361.7 |
| 724 | 2026-01-24 08:48:49 | subcode | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 723 | 2026-01-23 21:42:29 | subcode | 3 | 134027 | 109 | 33.846 | 3959.9 |
| 722 | 2026-01-23 21:41:59 | subcode | 3 | 134027 | 109 | 28.656 | 4677.1 |
| 721 | 2026-01-23 21:42:09 | subcode | 3 | 134027 | 109 | 18.423 | 7275.0 |
| 720 | 2026-01-23 21:41:44 | subcode | 3 | 134027 | 109 | 22.126 | 6057.4 |
| 719 | 2026-01-23 17:47:09 | subcode | 3 | 134027 | 109 | 6.390 | 20974.5 |
| 718 | 2026-01-16 19:33:45 | subcode | 1 | 69583 | 2 | 3.640 | 19116.2 |
| 717 | 2026-01-16 19:33:13 | subcode | 1 | 69583 | 2 | 1.343 | 51811.6 |
| 716 | 2026-01-02 23:08:48 | subcode | 3 | 134027 | 109 | 37.516 | 3572.5 |
| 715 | 2026-01-02 23:08:29 | subcode | 3 | 134027 | 109 | 16.936 | 7913.7 |
| 714 | 2025-12-29 21:30:55 | subcode | 2 | 107671 | 7 | 3.283 | 32796.5 |
| 713 | 2025-12-29 18:30:38 | subcode | 3 | 134027 | 109 | 6.826 | 19634.8 |
| 712 | 2025-12-29 12:23:03 | subcode | 3 | 134027 | 109 | 12.326 | 10873.5 |
| 711 | 2025-12-29 11:14:35 | subcode | 3 | 134027 | 109 | 6.440 | 20811.6 |
| 710 | 2025-12-28 08:31:47 | subcode | 2 | 107671 | 7 | 3.406 | 31612.2 |
| 709 | 2025-12-28 06:37:29 | subcode | 3 | 134027 | 109 | 6.250 | 21444.3 |
| 708 | 2025-12-27 12:11:48 | subcode | 2 | 107671 | 7 | 3.390 | 31761.4 |
| 707 | 2025-12-27 10:54:10 | subcode | 3 | 134027 | 109 | 6.970 | 19229.1 |
| 706 | 2025-12-27 10:21:23 | subcode | 3 | 134027 | 109 | 6.500 | 20619.5 |
| 705 | 2025-12-27 08:56:50 | subcode | 2 | 107671 | 7 | 3.576 | 30109.3 |
| 704 | 2025-12-27 05:53:16 | subcode | 1 | 69583 | 2 | 1.906 | 36507.3 |
| 703 | 2025-12-27 05:51:27 | subcode | 1 | 69583 | 2 | 1.310 | 53116.8 |
| 702 | 2025-12-27 05:33:06 | subcode | 3 | 134027 | 109 | 6.813 | 19672.2 |
| 701 | 2025-12-27 02:00:58 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 700 | 2025-12-27 00:11:34 | subcode | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 699 | 2025-12-18 15:47:05 | subcode | 2 | 107671 | 7 | 3.470 | 31029.1 |
| 698 | 2025-12-18 10:13:45 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 697 | 2025-12-17 10:35:10 | subcode | 2 | 107671 | 7 | 3.376 | 31893.1 |
| 696 | 2025-12-14 14:15:06 | subcode | 1 | 69583 | 2 | 2.483 | 28023.8 |
| 695 | 2025-12-09 12:25:41 | subcode | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 694 | 2025-12-07 21:45:45 | subcode | 1 | 69583 | 2 | 1.280 | 54361.7 |
| 693 | 2025-11-25 12:16:07 | subcode | 1 | 69583 | 2 | 1.423 | 48898.8 |
| 692 | 2025-11-25 11:02:21 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 691 | 2025-11-24 13:03:20 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 690 | 2025-11-23 08:24:11 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 689 | 2025-11-21 11:48:21 | subcode | 1 | 69583 | 2 | 1.406 | 49490.0 |
| 688 | 2025-11-21 03:04:56 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 687 | 2025-11-16 09:12:07 | subcode | 1 | 69583 | 2 | 1.376 | 50569.0 |
| 686 | 2025-11-16 05:31:53 | subcode | 2 | 107671 | 7 | 3.076 | 35003.6 |
| 685 | 2025-11-14 17:09:19 | subcode | 2 | 107671 | 7 | 3.346 | 32179.0 |
| 684 | 2025-11-14 11:49:39 | subcode | 3 | 134027 | 109 | 6.390 | 20974.5 |
| 683 | 2025-11-13 08:38:01 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 682 | 2025-11-13 05:35:29 | subcode | 2 | 107671 | 7 | 3.106 | 34665.5 |
| 681 | 2025-11-13 01:13:45 | subcode | 3 | 134027 | 109 | 6.500 | 20619.5 |
| 680 | 2025-11-11 22:00:32 | subcode | 1 | 69583 | 2 | 1.390 | 50059.7 |
| 679 | 2025-11-09 23:08:02 | subcode | 2 | 107671 | 7 | 2.940 | 36622.8 |
| 678 | 2025-11-09 19:14:31 | subcode | 2 | 107671 | 7 | 3.280 | 32826.5 |
| 677 | 2025-11-09 17:34:17 | subcode | 3 | 134027 | 109 | 6.296 | 21287.6 |
| 676 | 2025-11-09 07:54:20 | subcode | 3 | 134027 | 109 | 7.096 | 18887.7 |
| 675 | 2025-11-07 15:35:04 | subcode | 2 | 107671 | 7 | 3.250 | 33129.5 |
| 674 | 2025-11-06 13:03:02 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 673 | 2025-11-06 11:11:31 | subcode | 1 | 69583 | 2 | 1.326 | 52475.9 |
| 672 | 2025-11-05 21:03:08 | subcode | 1 | 69583 | 2 | 2.580 | 26970.2 |
| 671 | 2025-11-03 22:58:58 | subcode | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 670 | 2025-10-26 12:22:06 | subcode | 1 | 69583 | 2 | 1.376 | 50569.0 |
| 669 | 2025-10-25 13:12:56 | subcode | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 668 | 2025-10-21 22:09:29 | subcode | 1 | 69583 | 2 | 3.516 | 19790.4 |
| 667 | 2025-10-21 13:39:24 | subcode | 1 | 69583 | 2 | 6.470 | 10754.7 |
| 666 | 2025-10-19 12:29:33 | subcode | 1 | 69583 | 2 | 2.940 | 23667.7 |
| 665 | 2025-10-19 07:24:23 | subcode | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 664 | 2025-10-16 10:50:10 | subcode | 1 | 69583 | 2 | 1.153 | 60349.5 |
| 663 | 2025-10-06 13:53:51 | subcode | 1 | 69583 | 2 | 1.263 | 55093.4 |
| 662 | 2025-10-04 04:21:30 | subcode | 3 | 134027 | 109 | 6.750 | 19855.9 |
| 661 | 2025-10-03 12:31:34 | subcode | 1 | 69583 | 2 | 1.280 | 54361.7 |
| 660 | 2025-10-01 00:52:44 | subcode | 3 | 134027 | 109 | 6.156 | 21771.8 |
| 659 | 2025-09-28 23:09:56 | subcode | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 658 | 2025-09-28 19:59:27 | subcode | 2 | 107671 | 7 | 2.923 | 36835.8 |
| 657 | 2025-09-28 12:22:13 | subcode | 3 | 134027 | 109 | 6.170 | 21722.4 |
| 656 | 2025-09-28 07:46:57 | subcode | 1 | 69583 | 2 | 1.263 | 55093.4 |
| 655 | 2025-09-25 12:27:54 | subcode | 1 | 69583 | 2 | 1.373 | 50679.5 |
| 654 | 2025-09-24 13:09:01 | subcode | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 653 | 2025-09-21 12:53:32 | subcode | 1 | 69583 | 2 | 1.123 | 61961.7 |
| 652 | 2025-09-20 22:07:15 | subcode | 1 | 69583 | 2 | 1.346 | 51696.1 |
| 651 | 2025-09-19 08:40:03 | subcode | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 650 | 2025-09-19 01:38:53 | subcode | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 649 | 2025-09-18 08:57:09 | subcode | 3 | 134027 | 109 | 10.343 | 12958.2 |
| 648 | 2025-09-17 11:13:03 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 647 | 2025-09-17 05:21:11 | subcode | 2 | 107671 | 7 | 3.283 | 32796.5 |
| 646 | 2025-09-15 10:12:04 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 645 | 2025-09-14 18:40:55 | subcode | 1 | 69583 | 2 | 1.360 | 51164.0 |
| 644 | 2025-09-14 03:06:02 | subcode | 3 | 134027 | 109 | 6.686 | 20045.9 |
| 643 | 2025-09-13 19:25:28 | subcode | 3 | 134027 | 109 | 6.780 | 19768.0 |
| 642 | 2025-09-13 07:57:58 | subcode | 3 | 134027 | 109 | 5.716 | 23447.7 |
| 641 | 2025-09-08 16:18:52 | subcode | 2 | 107671 | 7 | 3.173 | 33933.5 |
| 640 | 2025-09-08 16:16:55 | subcode | 3 | 134027 | 109 | 8.360 | 16031.9 |
| 639 | 2025-09-08 01:14:13 | subcode | 2 | 107671 | 7 | 3.220 | 33438.2 |
| 638 | 2025-09-06 13:04:14 | subcode | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 637 | 2025-09-04 20:19:59 | subcode | 3 | 134027 | 109 | 7.373 | 18178.1 |
| 636 | 2025-09-04 10:31:33 | subcode | 2 | 107671 | 7 | 6.313 | 17055.4 |
| 635 | 2025-09-04 06:47:13 | subcode | 2 | 107671 | 7 | 3.220 | 33438.2 |
| 634 | 2025-09-02 22:12:40 | subcode | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 633 | 2025-09-02 03:07:17 | subcode | 1 | 69583 | 2 | 1.360 | 51164.0 |
| 632 | 2025-08-28 23:14:30 | subcode | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 631 | 2025-08-25 13:11:45 | subcode | 1 | 69583 | 2 | 8.200 | 8485.7 |
| 630 | 2025-08-25 13:00:36 | subcode | 1 | 69583 | 2 | 6.003 | 11591.4 |
| 629 | 2025-08-24 12:22:34 | subcode | 1 | 69583 | 2 | 2.813 | 24736.2 |
| 628 | 2025-08-21 16:40:23 | subcode | 1 | 69583 | 2 | 2.123 | 32775.8 |
| 627 | 2025-08-21 12:59:51 | subcode | 1 | 69583 | 2 | 3.013 | 23094.3 |
| 626 | 2025-08-20 14:29:25 | subcode | 1 | 69583 | 2 | 1.250 | 55666.4 |