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 |
| 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 |
| 524 | 2025-07-07 09:54:04 | truncate | 1 | 82945 | 3 | 8.096 | 10245.2 |
| 523 | 2025-07-01 17:09:57 | truncate | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 522 | 2025-06-27 06:41:08 | truncate | 1 | 82945 | 3 | 9.970 | 8319.5 |
| 521 | 2025-06-27 06:25:01 | truncate | 1 | 82945 | 3 | 4.703 | 17636.6 |
| 520 | 2025-06-25 11:21:32 | truncate | 1 | 82945 | 3 | 3.203 | 25896.0 |
| 519 | 2025-06-25 01:10:23 | truncate | 1 | 82945 | 3 | 6.533 | 12696.3 |
| 518 | 2025-06-22 02:45:01 | truncate | 4 | 161609 | 713 | 64.286 | 2513.9 |
| 517 | 2025-06-20 01:32:19 | truncate | 4 | 161609 | 713 | 42.580 | 3795.4 |
| 516 | 2025-06-18 17:10:36 | truncate | 2 | 121059 | 5 | 19.810 | 6111.0 |
| 515 | 2025-06-18 12:53:41 | truncate | 4 | 161609 | 713 | 49.550 | 3261.5 |
| 514 | 2025-06-18 11:56:33 | truncate | 4 | 161609 | 713 | 48.160 | 3355.7 |
| 513 | 2025-06-18 04:32:06 | truncate | 1 | 82945 | 3 | 7.213 | 11499.4 |
| 512 | 2025-06-17 08:28:38 | truncate | 3 | 146162 | 62 | 7.313 | 19986.6 |
| 511 | 2025-06-16 12:12:53 | truncate | 2 | 121059 | 5 | 17.266 | 7011.4 |
| 510 | 2025-06-16 00:55:23 | truncate | 4 | 161609 | 713 | 46.706 | 3460.1 |
| 509 | 2025-06-15 10:57:15 | truncate | 3 | 146162 | 62 | 7.906 | 18487.5 |
| 508 | 2025-06-14 10:12:35 | truncate | 3 | 146162 | 62 | 39.583 | 3692.5 |
| 507 | 2025-06-13 10:50:07 | truncate | 3 | 146162 | 62 | 7.796 | 18748.3 |
| 506 | 2025-06-08 05:17:46 | truncate | 1 | 82945 | 3 | 3.500 | 23698.6 |
| 505 | 2025-06-05 16:48:09 | truncate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 504 | 2025-05-27 06:36:05 | truncate | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 503 | 2025-05-27 06:15:58 | truncate | 1 | 82945 | 3 | 5.250 | 15799.0 |
| 502 | 2025-05-24 16:54:48 | truncate | 1 | 82945 | 3 | 5.156 | 16087.1 |
| 501 | 2025-05-24 14:28:09 | truncate | 1 | 82945 | 3 | 7.253 | 11436.0 |