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 |
| 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 |
| 500 | 2025-05-21 15:10:17 | truncate | 1 | 82945 | 3 | 6.516 | 12729.4 |
| 499 | 2025-05-20 13:53:27 | truncate | 1 | 82945 | 3 | 2.920 | 28405.8 |
| 498 | 2025-05-12 00:36:51 | truncate | 1 | 82945 | 3 | 10.516 | 7887.5 |
| 497 | 2025-04-23 05:36:33 | truncate | 1 | 82945 | 3 | 3.486 | 23793.7 |
| 496 | 2025-04-16 16:39:14 | truncate | 1 | 82945 | 3 | 6.703 | 12374.3 |
| 495 | 2025-04-16 11:33:35 | truncate | 1 | 82945 | 3 | 3.876 | 21399.6 |
| 494 | 2025-04-06 00:12:17 | truncate | 1 | 82945 | 3 | 5.436 | 15258.5 |
| 493 | 2025-03-31 00:41:07 | truncate | 1 | 82945 | 3 | 8.063 | 10287.1 |
| 492 | 2025-03-17 08:52:28 | truncate | 1 | 82945 | 3 | 8.953 | 9264.5 |
| 491 | 2025-03-13 08:04:06 | truncate | 1 | 82945 | 3 | 10.126 | 8191.3 |
| 490 | 2025-03-09 01:09:44 | truncate | 1 | 82945 | 3 | 6.220 | 13335.2 |
| 489 | 2025-03-05 18:30:28 | truncate | 1 | 82945 | 3 | 4.326 | 19173.6 |
| 488 | 2025-02-28 08:44:46 | truncate | 2 | 121059 | 5 | 18.923 | 6397.5 |
| 487 | 2025-02-24 17:30:16 | truncate | 2 | 121059 | 5 | 3.796 | 31891.2 |
| 486 | 2025-02-23 15:35:36 | truncate | 3 | 146162 | 62 | 36.940 | 3956.7 |
| 485 | 2025-02-23 13:17:49 | truncate | 3 | 146162 | 62 | 34.736 | 4207.8 |
| 484 | 2025-02-22 04:14:28 | truncate | 3 | 146162 | 62 | 37.860 | 3860.6 |
| 483 | 2025-02-21 16:40:50 | truncate | 3 | 146162 | 62 | 37.660 | 3881.1 |
| 482 | 2025-02-21 16:40:48 | truncate | 3 | 146162 | 62 | 24.940 | 5860.5 |
| 481 | 2025-02-21 16:41:02 | truncate | 1 | 82945 | 3 | 7.920 | 10472.9 |
| 480 | 2025-02-21 16:40:47 | truncate | 2 | 121059 | 5 | 9.923 | 12199.8 |
| 479 | 2025-02-01 14:09:59 | truncate | 3 | 146162 | 62 | 31.546 | 4633.3 |
| 478 | 2025-02-01 12:16:25 | truncate | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 477 | 2025-01-25 19:23:32 | truncate | 1 | 82945 | 3 | 4.940 | 16790.5 |
| 476 | 2025-01-24 22:33:37 | truncate | 2 | 121059 | 5 | 6.296 | 19227.9 |
| 475 | 2025-01-23 00:53:47 | truncate | 2 | 121059 | 5 | 15.436 | 7842.6 |
| 474 | 2025-01-20 07:44:47 | truncate | 3 | 146162 | 62 | 38.800 | 3767.1 |
| 473 | 2025-01-19 13:20:51 | truncate | 3 | 146162 | 62 | 51.446 | 2841.1 |
| 472 | 2025-01-19 13:20:49 | truncate | 3 | 146162 | 62 | 34.586 | 4226.0 |
| 471 | 2025-01-19 13:20:49 | truncate | 2 | 121059 | 5 | 8.986 | 13472.0 |
| 470 | 2025-01-19 13:20:45 | truncate | 1 | 82945 | 3 | 8.580 | 9667.2 |
| 469 | 2025-01-18 03:52:07 | truncate | 3 | 146162 | 62 | 38.063 | 3840.0 |
| 468 | 2025-01-18 01:34:25 | truncate | 3 | 146162 | 62 | 31.066 | 4704.9 |
| 467 | 2025-01-18 01:34:12 | truncate | 3 | 146162 | 62 | 40.300 | 3626.8 |
| 466 | 2025-01-18 01:34:13 | truncate | 2 | 121059 | 5 | 15.890 | 7618.6 |
| 465 | 2025-01-18 01:33:53 | truncate | 1 | 82945 | 3 | 2.610 | 31779.7 |
| 464 | 2025-01-01 22:08:57 | truncate | 1 | 82945 | 3 | 10.686 | 7762.0 |
| 463 | 2024-12-19 18:42:13 | truncate | 1 | 82945 | 3 | 4.690 | 17685.5 |
| 462 | 2024-12-08 01:11:45 | truncate | 3 | 146162 | 62 | 37.953 | 3851.1 |
| 461 | 2024-12-04 08:21:01 | truncate | 3 | 146162 | 62 | 41.956 | 3483.7 |
| 460 | 2024-11-29 00:59:17 | truncate | 1 | 82945 | 3 | 3.516 | 23590.7 |
| 459 | 2024-11-29 00:58:26 | truncate | 2 | 121059 | 5 | 28.656 | 4224.6 |
| 458 | 2024-11-28 20:20:41 | truncate | 4 | 161609 | 713 | 65.533 | 2466.1 |
| 457 | 2024-11-28 13:06:38 | truncate | 4 | 161609 | 713 | 41.970 | 3850.6 |
| 456 | 2024-11-28 13:06:43 | truncate | 2 | 121059 | 5 | 17.706 | 6837.2 |
| 455 | 2024-11-28 10:29:37 | truncate | 3 | 146162 | 62 | 7.546 | 19369.5 |
| 454 | 2024-11-26 08:01:45 | truncate | 3 | 146162 | 62 | 11.546 | 12659.1 |
| 453 | 2024-11-26 02:31:55 | truncate | 3 | 146162 | 62 | 7.986 | 18302.3 |
| 452 | 2024-11-26 02:31:56 | truncate | 2 | 121059 | 5 | 4.186 | 28920.0 |
| 451 | 2024-11-25 16:20:18 | truncate | 1 | 82945 | 3 | 4.890 | 16962.2 |
| 450 | 2024-11-25 15:45:30 | truncate | 3 | 146162 | 62 | 39.720 | 3679.8 |
| 449 | 2024-11-25 03:17:52 | truncate | 1 | 82945 | 3 | 6.266 | 13237.3 |
| 448 | 2024-11-23 05:56:23 | truncate | 3 | 146162 | 62 | 33.923 | 4308.6 |
| 447 | 2024-11-08 11:12:50 | truncate | 1 | 82945 | 3 | 3.466 | 23931.0 |
| 446 | 2024-11-04 20:40:07 | truncate | 3 | 146162 | 62 | 23.906 | 6114.0 |
| 445 | 2024-10-28 20:44:01 | truncate | 2 | 121059 | 5 | 3.546 | 34139.6 |