History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"heriot"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 626 | 2026-02-08 10:20:16 | heriot | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 625 | 2026-02-08 04:47:23 | heriot | 1 | 48755 | 2 | 1.660 | 29370.5 |
| 624 | 2026-02-07 00:52:29 | heriot | 1 | 48755 | 2 | 0.923 | 52822.3 |
| 623 | 2026-02-06 20:17:46 | heriot | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 622 | 2026-02-06 17:30:07 | heriot | 1 | 48755 | 2 | 0.813 | 59969.2 |
| 621 | 2026-02-06 14:09:56 | heriot | 1 | 48755 | 2 | 1.000 | 48755.0 |
| 620 | 2026-02-06 06:01:30 | heriot | 1 | 48755 | 2 | 1.330 | 36657.9 |
| 619 | 2026-02-06 04:28:12 | heriot | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 618 | 2026-02-06 02:32:35 | heriot | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 617 | 2026-02-01 09:29:21 | heriot | 1 | 48755 | 2 | 2.453 | 19875.7 |
| 616 | 2026-01-17 15:37:30 | heriot | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 615 | 2026-01-17 15:36:48 | heriot | 1 | 48755 | 2 | 0.783 | 62266.9 |
| 614 | 2026-01-14 15:56:51 | heriot | 1 | 48755 | 2 | 1.580 | 30857.6 |
| 613 | 2026-01-12 18:36:01 | heriot | 1 | 48755 | 2 | 1.703 | 28628.9 |
| 612 | 2026-01-09 13:51:29 | heriot | 1 | 48755 | 2 | 0.810 | 60191.4 |
| 611 | 2026-01-08 23:17:30 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
| 610 | 2026-01-08 18:43:08 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
| 609 | 2026-01-07 23:23:26 | heriot | 1 | 48755 | 2 | 0.783 | 62266.9 |
| 608 | 2026-01-07 21:15:44 | heriot | 1 | 48755 | 2 | 1.280 | 38089.8 |
| 607 | 2026-01-06 21:31:37 | heriot | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 606 | 2025-12-25 19:14:15 | heriot | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 605 | 2025-12-19 14:30:05 | heriot | 1 | 48755 | 2 | 1.296 | 37619.6 |
| 604 | 2025-12-19 14:26:27 | heriot | 1 | 48755 | 2 | 5.986 | 8144.8 |
| 603 | 2025-12-19 14:26:06 | heriot | 1 | 48755 | 2 | 6.076 | 8024.2 |
| 602 | 2025-12-17 04:58:38 | heriot | 2 | 82551 | 32 | 2.593 | 31836.1 |
| 601 | 2025-12-07 22:43:58 | heriot | 1 | 48755 | 2 | 0.813 | 59969.2 |
| 600 | 2025-12-03 12:05:23 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
| 599 | 2025-12-01 21:25:09 | heriot | 3 | 112716 | 453 | 5.403 | 20861.7 |
| 598 | 2025-11-28 11:14:54 | heriot | 2 | 82551 | 32 | 2.266 | 36430.3 |
| 597 | 2025-11-28 07:44:42 | heriot | 1 | 48755 | 2 | 5.236 | 9311.5 |
| 596 | 2025-11-26 14:44:12 | heriot | 1 | 48755 | 2 | 0.830 | 58741.0 |
| 595 | 2025-11-25 09:44:36 | heriot | 1 | 48755 | 2 | 1.610 | 30282.6 |
| 594 | 2025-11-20 12:24:23 | heriot | 2 | 82551 | 32 | 2.206 | 37421.1 |
| 593 | 2025-11-19 15:47:25 | heriot | 1 | 48755 | 2 | 1.843 | 26454.2 |
| 592 | 2025-11-19 06:25:56 | heriot | 1 | 48755 | 2 | 0.893 | 54596.9 |
| 591 | 2025-11-16 07:32:20 | heriot | 1 | 48755 | 2 | 0.826 | 59025.4 |
| 590 | 2025-11-15 12:40:16 | heriot | 1 | 48755 | 2 | 1.203 | 40527.8 |
| 589 | 2025-11-13 13:23:16 | heriot | 1 | 48755 | 2 | 0.876 | 55656.4 |
| 588 | 2025-11-12 05:32:24 | heriot | 1 | 48755 | 2 | 0.826 | 59025.4 |
| 587 | 2025-11-06 10:39:24 | heriot | 3 | 112716 | 453 | 5.016 | 22471.3 |
| 586 | 2025-10-08 00:47:12 | heriot | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 585 | 2025-10-03 23:50:14 | heriot | 3 | 112716 | 453 | 4.940 | 22817.0 |
| 584 | 2025-10-02 21:53:15 | heriot | 1 | 48755 | 2 | 0.780 | 62506.4 |
| 583 | 2025-09-28 20:18:43 | heriot | 2 | 82551 | 32 | 2.593 | 31836.1 |
| 582 | 2025-09-22 10:41:46 | heriot | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 581 | 2025-09-22 09:09:37 | heriot | 2 | 82551 | 32 | 2.466 | 33475.7 |
| 580 | 2025-09-16 07:48:52 | heriot | 1 | 48755 | 2 | 0.876 | 55656.4 |
| 579 | 2025-09-14 09:32:14 | heriot | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 578 | 2025-09-06 18:10:46 | heriot | 1 | 48755 | 2 | 0.780 | 62506.4 |
| 577 | 2025-08-16 21:11:33 | heriot | 3 | 112716 | 453 | 13.343 | 8447.6 |
| 576 | 2025-08-15 18:56:37 | heriot | 3 | 112716 | 453 | 20.750 | 5432.1 |
| 575 | 2025-08-14 17:43:52 | heriot | 1 | 48755 | 2 | 0.920 | 52994.6 |
| 574 | 2025-08-12 20:53:10 | heriot | 3 | 112716 | 453 | 13.690 | 8233.5 |
| 573 | 2025-08-12 17:31:06 | heriot | 3 | 112716 | 453 | 18.266 | 6170.8 |
| 572 | 2025-08-10 17:56:33 | heriot | 3 | 112716 | 453 | 17.923 | 6288.9 |
| 571 | 2025-08-10 10:24:43 | heriot | 1 | 48755 | 2 | 3.656 | 13335.6 |
| 570 | 2025-08-09 14:32:04 | heriot | 1 | 48755 | 2 | 4.796 | 10165.8 |
| 569 | 2025-08-06 15:02:47 | heriot | 2 | 82551 | 32 | 12.923 | 6387.9 |
| 568 | 2025-08-06 13:46:45 | heriot | 3 | 112716 | 453 | 23.110 | 4877.4 |
| 567 | 2025-08-05 01:59:09 | heriot | 1 | 48755 | 2 | 3.736 | 13050.1 |
| 566 | 2025-08-04 03:39:42 | heriot | 1 | 48755 | 2 | 4.046 | 12050.2 |
| 565 | 2025-07-31 06:31:15 | heriot | 1 | 48755 | 2 | 0.970 | 50262.9 |
| 564 | 2025-07-26 17:52:16 | heriot | 1 | 48755 | 2 | 4.186 | 11647.2 |
| 563 | 2025-07-25 20:18:12 | heriot | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 562 | 2025-07-24 02:44:36 | heriot | 1 | 48755 | 2 | 4.283 | 11383.4 |
| 561 | 2025-07-23 12:43:25 | heriot | 1 | 48755 | 2 | 6.656 | 7325.0 |
| 560 | 2025-07-20 08:42:45 | heriot | 1 | 48755 | 2 | 0.890 | 54780.9 |
| 559 | 2025-07-15 18:43:28 | heriot | 2 | 82551 | 32 | 2.296 | 35954.3 |
| 558 | 2025-07-10 18:58:58 | heriot | 1 | 48755 | 2 | 6.250 | 7800.8 |
| 557 | 2025-07-08 13:52:15 | heriot | 1 | 48755 | 2 | 1.946 | 25054.0 |
| 556 | 2025-07-07 16:57:07 | heriot | 1 | 48755 | 2 | 4.576 | 10654.5 |
| 555 | 2025-07-06 01:46:45 | heriot | 2 | 82551 | 32 | 9.610 | 8590.1 |
| 554 | 2025-07-03 22:23:39 | heriot | 2 | 82551 | 32 | 8.640 | 9554.5 |
| 553 | 2025-07-03 03:29:44 | heriot | 1 | 48755 | 2 | 4.483 | 10875.5 |
| 552 | 2025-07-01 21:59:54 | heriot | 3 | 112716 | 453 | 32.270 | 3492.9 |
| 551 | 2025-06-30 16:25:30 | heriot | 3 | 112716 | 453 | 25.330 | 4449.9 |
| 550 | 2025-06-29 20:30:34 | heriot | 3 | 112716 | 453 | 22.266 | 5062.2 |
| 549 | 2025-06-28 05:53:45 | heriot | 3 | 112716 | 453 | 43.270 | 2604.9 |
| 548 | 2025-06-28 02:52:58 | heriot | 2 | 82551 | 32 | 6.406 | 12886.5 |
| 547 | 2025-06-26 20:22:11 | heriot | 1 | 48755 | 2 | 4.250 | 11471.8 |
| 546 | 2025-06-25 21:48:06 | heriot | 1 | 48755 | 2 | 4.780 | 10199.8 |
| 545 | 2025-06-24 23:30:08 | heriot | 1 | 48755 | 2 | 2.266 | 21515.9 |
| 544 | 2025-06-24 02:45:06 | heriot | 1 | 48755 | 2 | 4.250 | 11471.8 |
| 543 | 2025-06-23 22:45:24 | heriot | 1 | 48755 | 2 | 3.763 | 12956.4 |
| 542 | 2025-06-19 19:24:10 | heriot | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 541 | 2025-06-14 17:50:27 | heriot | 1 | 48755 | 2 | 4.373 | 11149.1 |
| 540 | 2025-06-12 01:29:00 | heriot | 1 | 48755 | 2 | 2.300 | 21197.8 |
| 539 | 2025-06-10 09:40:40 | heriot | 1 | 48755 | 2 | 2.186 | 22303.3 |
| 538 | 2025-06-07 19:03:11 | heriot | 1 | 48755 | 2 | 1.970 | 24748.7 |
| 537 | 2025-06-02 02:59:51 | heriot | 1 | 48755 | 2 | 4.123 | 11825.1 |
| 536 | 2025-05-28 01:58:11 | heriot | 2 | 82551 | 32 | 2.390 | 34540.2 |
| 535 | 2025-05-27 23:06:02 | heriot | 3 | 112716 | 453 | 6.360 | 17722.6 |
| 534 | 2025-05-27 14:29:38 | heriot | 1 | 48755 | 2 | 2.626 | 18566.3 |
| 533 | 2025-05-22 02:46:10 | heriot | 1 | 48755 | 2 | 2.190 | 22262.6 |
| 532 | 2025-05-20 23:47:30 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
| 531 | 2025-05-17 22:48:37 | heriot | 1 | 48755 | 2 | 6.406 | 7610.8 |
| 530 | 2025-05-16 02:03:46 | heriot | 2 | 82551 | 32 | 17.563 | 4700.3 |
| 529 | 2025-05-15 05:56:17 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
| 528 | 2025-05-12 01:10:42 | heriot | 1 | 48755 | 2 | 3.766 | 12946.1 |
| 527 | 2025-05-11 15:49:14 | heriot | 1 | 48755 | 2 | 0.906 | 53813.5 |