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 |
| 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 |
| 625 | 2025-08-19 04:33:38 | subcode | 3 | 134027 | 109 | 22.580 | 5935.7 |
| 624 | 2025-08-19 03:14:06 | subcode | 3 | 134027 | 109 | 19.436 | 6895.8 |
| 623 | 2025-08-17 14:40:20 | subcode | 3 | 134027 | 109 | 19.910 | 6731.6 |
| 622 | 2025-08-17 12:46:52 | subcode | 3 | 134027 | 109 | 17.250 | 7769.7 |
| 621 | 2025-08-16 04:44:51 | subcode | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 620 | 2025-08-15 00:11:54 | subcode | 3 | 134027 | 109 | 28.940 | 4631.2 |
| 619 | 2025-08-14 09:18:06 | subcode | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 618 | 2025-08-13 11:01:57 | subcode | 1 | 69583 | 2 | 6.423 | 10833.4 |
| 617 | 2025-08-08 19:44:47 | subcode | 2 | 107671 | 7 | 6.936 | 15523.5 |
| 616 | 2025-08-08 16:11:03 | subcode | 1 | 69583 | 2 | 1.140 | 61037.7 |
| 615 | 2025-08-01 14:05:31 | subcode | 1 | 69583 | 2 | 3.093 | 22496.9 |
| 614 | 2025-07-25 16:41:59 | subcode | 1 | 69583 | 2 | 2.623 | 26528.0 |
| 613 | 2025-07-24 18:09:18 | subcode | 1 | 69583 | 2 | 6.720 | 10354.6 |
| 612 | 2025-07-23 20:03:05 | subcode | 1 | 69583 | 2 | 5.686 | 12237.6 |
| 611 | 2025-07-17 17:58:12 | subcode | 3 | 134027 | 109 | 32.046 | 4182.3 |
| 610 | 2025-07-16 06:29:15 | subcode | 3 | 134027 | 109 | 26.533 | 5051.3 |
| 609 | 2025-07-13 12:03:39 | subcode | 3 | 134027 | 109 | 15.093 | 8880.1 |
| 608 | 2025-07-08 13:45:15 | subcode | 1 | 69583 | 2 | 9.170 | 7588.1 |
| 607 | 2025-06-24 14:17:11 | subcode | 1 | 69583 | 2 | 6.936 | 10032.2 |
| 606 | 2025-06-23 18:30:57 | subcode | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 605 | 2025-06-21 11:58:06 | subcode | 1 | 69583 | 2 | 4.846 | 14358.9 |
| 604 | 2025-06-20 12:34:22 | subcode | 1 | 69583 | 2 | 5.890 | 11813.8 |
| 603 | 2025-06-14 00:11:43 | subcode | 1 | 69583 | 2 | 6.126 | 11358.6 |
| 602 | 2025-06-10 08:32:37 | subcode | 1 | 69583 | 2 | 3.033 | 22942.0 |
| 601 | 2025-06-08 13:24:21 | subcode | 1 | 69583 | 2 | 8.776 | 7928.8 |
| 600 | 2025-06-04 13:39:56 | subcode | 1 | 69583 | 2 | 6.890 | 10099.1 |
| 599 | 2025-05-27 23:03:04 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 598 | 2025-05-26 14:48:24 | subcode | 3 | 134027 | 109 | 32.410 | 4135.4 |
| 597 | 2025-05-24 14:15:08 | subcode | 1 | 69583 | 2 | 4.186 | 16622.8 |
| 596 | 2025-05-21 22:45:51 | subcode | 2 | 107671 | 7 | 16.300 | 6605.6 |
| 595 | 2025-05-21 12:32:09 | subcode | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 594 | 2025-05-20 13:09:47 | subcode | 3 | 134027 | 109 | 28.750 | 4661.8 |
| 593 | 2025-05-20 11:35:14 | subcode | 1 | 69583 | 2 | 3.923 | 17737.2 |
| 592 | 2025-05-17 18:54:18 | subcode | 1 | 69583 | 2 | 1.703 | 40859.1 |
| 591 | 2025-05-17 02:15:12 | subcode | 3 | 134027 | 109 | 6.843 | 19586.0 |
| 590 | 2025-05-08 13:43:06 | subcode | 1 | 69583 | 2 | 6.033 | 11533.7 |
| 589 | 2025-04-28 13:44:15 | subcode | 1 | 69583 | 2 | 8.906 | 7813.0 |
| 588 | 2025-04-23 15:12:17 | subcode | 1 | 69583 | 2 | 5.733 | 12137.3 |
| 587 | 2025-04-23 13:15:40 | subcode | 3 | 134027 | 109 | 41.423 | 3235.6 |
| 586 | 2025-04-20 12:07:09 | subcode | 1 | 69583 | 2 | 3.936 | 17678.6 |
| 585 | 2025-04-18 12:19:04 | subcode | 3 | 134027 | 109 | 38.393 | 3490.9 |
| 584 | 2025-04-17 22:27:19 | subcode | 2 | 107671 | 7 | 8.890 | 12111.5 |
| 583 | 2025-04-03 23:37:41 | subcode | 1 | 69583 | 2 | 4.640 | 14996.3 |
| 582 | 2025-04-02 12:20:40 | subcode | 1 | 69583 | 2 | 7.873 | 8838.2 |
| 581 | 2025-03-31 12:18:19 | subcode | 1 | 69583 | 2 | 6.703 | 10380.9 |
| 580 | 2025-03-23 14:50:35 | subcode | 3 | 134027 | 109 | 23.173 | 5783.8 |
| 579 | 2025-03-22 15:27:20 | subcode | 1 | 69583 | 2 | 8.750 | 7952.3 |
| 578 | 2025-03-20 14:53:23 | subcode | 1 | 69583 | 2 | 3.203 | 21724.3 |
| 577 | 2025-03-07 16:59:05 | subcode | 1 | 69583 | 2 | 4.706 | 14786.0 |
| 576 | 2025-03-01 16:54:21 | subcode | 3 | 134027 | 109 | 34.580 | 3875.9 |
| 575 | 2025-03-01 15:15:52 | subcode | 3 | 134027 | 109 | 30.816 | 4349.3 |
| 574 | 2025-02-28 00:41:46 | subcode | 3 | 134027 | 109 | 34.143 | 3925.5 |
| 573 | 2025-02-27 19:04:38 | subcode | 3 | 134027 | 109 | 34.423 | 3893.5 |
| 572 | 2025-02-27 05:48:43 | subcode | 1 | 69583 | 2 | 8.063 | 8629.9 |
| 571 | 2025-02-26 02:00:22 | subcode | 1 | 69583 | 2 | 4.063 | 17126.0 |