History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truncate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 648 | 2026-04-19 07:59:23 | truncate | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 647 | 2026-04-05 14:23:56 | truncate | 3 | 146162 | 62 | 7.533 | 19402.9 |
| 646 | 2026-04-05 14:23:52 | truncate | 3 | 146162 | 62 | 10.110 | 14457.2 |
| 645 | 2026-04-05 11:46:25 | truncate | 2 | 121059 | 5 | 19.436 | 6228.6 |
| 644 | 2026-04-05 11:46:16 | truncate | 2 | 121059 | 5 | 18.266 | 6627.6 |
| 643 | 2026-04-02 19:04:08 | truncate | 1 | 82945 | 3 | 3.343 | 24811.5 |
| 642 | 2026-04-02 16:19:00 | truncate | 1 | 82945 | 3 | 7.093 | 11693.9 |
| 641 | 2026-03-30 05:35:11 | truncate | 1 | 82945 | 3 | 6.610 | 12548.4 |
| 640 | 2026-03-27 12:17:55 | truncate | 3 | 146162 | 62 | 32.390 | 4512.6 |
| 639 | 2026-03-27 08:18:18 | truncate | 2 | 121059 | 5 | 17.750 | 6820.2 |
| 638 | 2026-03-25 17:26:16 | truncate | 3 | 146162 | 62 | 47.660 | 3066.8 |
| 637 | 2026-03-24 21:10:33 | truncate | 1 | 82945 | 3 | 10.263 | 8081.9 |
| 636 | 2026-03-24 16:14:52 | truncate | 2 | 121059 | 5 | 14.783 | 8189.1 |
| 635 | 2026-03-22 04:17:33 | truncate | 3 | 146162 | 62 | 35.720 | 4091.9 |
| 634 | 2026-03-20 07:35:59 | truncate | 1 | 82945 | 3 | 7.250 | 11440.7 |
| 633 | 2026-03-17 03:28:37 | truncate | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 632 | 2026-03-16 16:34:59 | truncate | 1 | 82945 | 3 | 1.780 | 46598.3 |
| 631 | 2026-03-16 14:59:44 | truncate | 1 | 82945 | 3 | 2.953 | 28088.4 |
| 630 | 2026-03-01 06:20:18 | truncate | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 629 | 2026-02-27 19:51:21 | truncate | 1 | 82945 | 3 | 3.513 | 23610.9 |
| 628 | 2026-02-27 12:10:41 | truncate | 3 | 146162 | 62 | 27.626 | 5290.7 |
| 627 | 2026-02-27 06:42:42 | truncate | 4 | 161609 | 713 | 71.176 | 2270.6 |
| 626 | 2026-02-26 13:06:08 | truncate | 4 | 161609 | 713 | 14.390 | 11230.6 |
| 625 | 2026-02-23 05:12:15 | truncate | 3 | 146162 | 62 | 8.233 | 17753.2 |
| 624 | 2026-02-20 22:57:55 | truncate | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 623 | 2026-02-20 07:05:46 | truncate | 1 | 82945 | 3 | 1.826 | 45424.4 |
| 622 | 2026-02-19 06:00:32 | truncate | 2 | 121059 | 5 | 3.673 | 32959.2 |
| 621 | 2026-02-16 06:30:04 | truncate | 2 | 121059 | 5 | 4.390 | 27576.1 |
| 620 | 2026-02-15 20:44:14 | truncate | 4 | 161609 | 713 | 21.360 | 7566.0 |
| 619 | 2026-02-15 13:10:54 | truncate | 4 | 161609 | 713 | 12.320 | 13117.6 |
| 618 | 2026-02-15 13:10:29 | truncate | 4 | 161609 | 713 | 17.020 | 9495.2 |
| 617 | 2026-02-14 21:39:51 | truncate | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 616 | 2026-02-14 18:04:36 | truncate | 4 | 161609 | 713 | 36.380 | 4442.2 |
| 615 | 2026-02-14 18:04:10 | truncate | 4 | 161609 | 713 | 54.040 | 2990.5 |
| 614 | 2026-02-14 18:04:00 | truncate | 4 | 161609 | 713 | 36.913 | 4378.1 |
| 613 | 2026-02-12 10:14:12 | truncate | 4 | 161609 | 713 | 61.113 | 2644.4 |
| 612 | 2026-02-12 10:13:36 | truncate | 4 | 161609 | 713 | 47.176 | 3425.7 |
| 611 | 2026-02-08 07:41:59 | truncate | 1 | 82945 | 3 | 6.610 | 12548.4 |
| 610 | 2026-01-30 22:11:03 | truncate | 1 | 82945 | 3 | 6.796 | 12205.0 |
| 609 | 2026-01-30 19:33:08 | truncate | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 608 | 2026-01-25 11:12:16 | truncate | 1 | 82945 | 3 | 2.106 | 39385.1 |
| 607 | 2026-01-25 08:37:00 | truncate | 1 | 82945 | 3 | 6.096 | 13606.5 |
| 606 | 2026-01-19 00:54:26 | truncate | 1 | 82945 | 3 | 3.390 | 24467.6 |
| 605 | 2026-01-14 05:52:55 | truncate | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 604 | 2026-01-11 20:30:26 | truncate | 1 | 82945 | 3 | 3.566 | 23260.0 |
| 603 | 2026-01-08 07:48:42 | truncate | 1 | 82945 | 3 | 5.720 | 14500.9 |
| 602 | 2026-01-08 07:48:34 | truncate | 1 | 82945 | 3 | 9.640 | 8604.3 |
| 601 | 2026-01-07 11:51:35 | truncate | 1 | 82945 | 3 | 2.533 | 32745.8 |
| 600 | 2026-01-05 12:31:14 | truncate | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 599 | 2026-01-01 01:23:11 | truncate | 4 | 161609 | 713 | 11.266 | 14344.8 |
| 598 | 2026-01-01 01:23:02 | truncate | 4 | 161609 | 713 | 12.750 | 12675.2 |
| 597 | 2025-12-31 15:31:10 | truncate | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 596 | 2025-12-29 19:30:29 | truncate | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 595 | 2025-12-27 00:26:40 | truncate | 4 | 161609 | 713 | 19.830 | 8149.7 |
| 594 | 2025-12-25 22:45:41 | truncate | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 593 | 2025-12-24 06:40:44 | truncate | 1 | 82945 | 3 | 2.966 | 27965.3 |
| 592 | 2025-12-18 23:32:20 | truncate | 1 | 82945 | 3 | 7.593 | 10923.9 |
| 591 | 2025-12-18 09:45:57 | truncate | 4 | 161609 | 713 | 81.676 | 1978.7 |
| 590 | 2025-12-18 06:25:08 | truncate | 4 | 161609 | 713 | 10.953 | 14754.8 |
| 589 | 2025-12-15 22:00:43 | truncate | 1 | 82945 | 3 | 4.643 | 17864.5 |
| 588 | 2025-12-13 04:05:34 | truncate | 1 | 82945 | 3 | 2.373 | 34953.6 |
| 587 | 2025-12-13 00:34:06 | truncate | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 586 | 2025-12-09 06:30:54 | truncate | 4 | 161609 | 713 | 13.486 | 11983.5 |
| 585 | 2025-12-09 06:30:44 | truncate | 4 | 161609 | 713 | 12.313 | 13125.1 |
| 584 | 2025-12-07 02:00:39 | truncate | 1 | 82945 | 3 | 5.016 | 16536.1 |
| 583 | 2025-12-05 12:46:28 | truncate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 582 | 2025-11-29 15:27:16 | truncate | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 581 | 2025-11-23 16:14:40 | truncate | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 580 | 2025-11-22 13:50:05 | truncate | 1 | 82945 | 3 | 2.373 | 34953.6 |
| 579 | 2025-11-16 08:40:07 | truncate | 4 | 161609 | 713 | 18.220 | 8869.9 |
| 578 | 2025-11-15 15:23:33 | truncate | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 577 | 2025-11-14 19:21:17 | truncate | 3 | 146162 | 62 | 6.830 | 21400.0 |
| 576 | 2025-11-13 16:28:01 | truncate | 3 | 146162 | 62 | 7.826 | 18676.5 |
| 575 | 2025-11-13 00:27:52 | truncate | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 574 | 2025-11-11 21:20:55 | truncate | 4 | 161609 | 713 | 18.220 | 8869.9 |
| 573 | 2025-11-10 15:09:35 | truncate | 4 | 161609 | 713 | 12.826 | 12600.1 |
| 572 | 2025-11-08 18:51:56 | truncate | 4 | 161609 | 713 | 11.593 | 13940.2 |
| 571 | 2025-11-05 13:11:02 | truncate | 2 | 121059 | 5 | 3.936 | 30756.9 |
| 570 | 2025-11-04 23:07:07 | truncate | 4 | 161609 | 713 | 11.173 | 14464.2 |
| 569 | 2025-11-04 17:13:14 | truncate | 2 | 121059 | 5 | 3.440 | 35191.6 |
| 568 | 2025-11-02 01:10:55 | truncate | 2 | 121059 | 5 | 4.096 | 29555.4 |
| 567 | 2025-10-30 11:22:27 | truncate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 566 | 2025-10-29 21:18:21 | truncate | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 565 | 2025-10-28 03:09:32 | truncate | 4 | 161609 | 713 | 19.500 | 8287.6 |
| 564 | 2025-10-24 18:24:18 | truncate | 4 | 161609 | 713 | 38.050 | 4247.3 |
| 563 | 2025-10-24 02:30:27 | truncate | 4 | 161609 | 713 | 11.906 | 13573.7 |
| 562 | 2025-10-20 20:13:47 | truncate | 1 | 82945 | 3 | 9.533 | 8700.8 |
| 561 | 2025-10-15 00:06:25 | truncate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 560 | 2025-10-07 05:48:10 | truncate | 4 | 161609 | 713 | 11.530 | 14016.4 |
| 559 | 2025-10-02 19:09:34 | truncate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 558 | 2025-10-02 02:50:03 | truncate | 4 | 161609 | 713 | 11.076 | 14590.9 |
| 557 | 2025-10-01 15:44:29 | truncate | 4 | 161609 | 713 | 11.703 | 13809.2 |
| 556 | 2025-10-01 07:21:10 | truncate | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 555 | 2025-09-27 09:11:30 | truncate | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 554 | 2025-09-22 14:30:26 | truncate | 4 | 161609 | 713 | 12.563 | 12863.9 |
| 553 | 2025-09-20 07:22:06 | truncate | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 552 | 2025-09-16 14:18:04 | truncate | 4 | 161609 | 713 | 10.813 | 14945.8 |
| 551 | 2025-09-16 06:12:07 | truncate | 3 | 146162 | 62 | 7.310 | 19994.8 |
| 550 | 2025-09-15 01:23:56 | truncate | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 549 | 2025-09-14 10:56:28 | truncate | 1 | 82945 | 3 | 1.500 | 55296.7 |