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 |
| 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 |
| 548 | 2025-09-08 09:14:18 | truncate | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 547 | 2025-09-05 04:50:33 | truncate | 4 | 161609 | 713 | 12.520 | 12908.1 |
| 546 | 2025-09-04 09:35:56 | truncate | 4 | 161609 | 713 | 12.296 | 13143.2 |
| 545 | 2025-09-04 04:13:54 | truncate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 544 | 2025-08-27 23:31:11 | truncate | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 543 | 2025-08-22 14:16:33 | truncate | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 542 | 2025-08-19 05:09:09 | truncate | 1 | 82945 | 3 | 2.640 | 31418.6 |
| 541 | 2025-08-19 00:18:41 | truncate | 1 | 82945 | 3 | 2.703 | 30686.3 |
| 540 | 2025-08-17 06:20:02 | truncate | 1 | 82945 | 3 | 2.843 | 29175.2 |
| 539 | 2025-08-16 04:50:04 | truncate | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 538 | 2025-08-06 01:45:20 | truncate | 1 | 82945 | 3 | 10.153 | 8169.5 |
| 537 | 2025-08-01 02:45:12 | truncate | 1 | 82945 | 3 | 6.906 | 12010.6 |
| 536 | 2025-07-27 09:54:39 | truncate | 3 | 146162 | 62 | 27.893 | 5240.1 |
| 535 | 2025-07-27 07:09:22 | truncate | 1 | 82945 | 3 | 7.496 | 11065.2 |
| 534 | 2025-07-26 22:33:48 | truncate | 1 | 82945 | 3 | 3.580 | 23169.0 |
| 533 | 2025-07-25 02:12:42 | truncate | 1 | 82945 | 3 | 5.826 | 14237.0 |
| 532 | 2025-07-24 18:43:55 | truncate | 1 | 82945 | 3 | 3.610 | 22976.5 |
| 531 | 2025-07-23 16:13:41 | truncate | 3 | 146162 | 62 | 31.016 | 4712.5 |
| 530 | 2025-07-22 12:25:45 | truncate | 1 | 82945 | 3 | 8.940 | 9278.0 |
| 529 | 2025-07-21 22:43:31 | truncate | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 528 | 2025-07-13 20:23:36 | truncate | 1 | 82945 | 3 | 7.030 | 11798.7 |
| 527 | 2025-07-09 23:03:25 | truncate | 1 | 82945 | 3 | 3.423 | 24231.7 |
| 526 | 2025-07-08 23:15:29 | truncate | 1 | 82945 | 3 | 10.170 | 8155.9 |
| 525 | 2025-07-08 06:00:26 | truncate | 1 | 82945 | 3 | 6.466 | 12827.9 |