History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smiths"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 629 | 2025-10-29 06:48:50 | smiths | 3 | 112716 | 696 | 5.190 | 21717.9 |
| 628 | 2025-10-27 05:19:52 | smiths | 3 | 112716 | 696 | 5.390 | 20912.1 |
| 627 | 2025-10-24 09:39:13 | smiths | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 626 | 2025-10-19 20:15:24 | smiths | 3 | 112716 | 696 | 37.116 | 3036.9 |
| 625 | 2025-10-19 20:14:46 | smiths | 3 | 112716 | 696 | 33.816 | 3333.2 |
| 624 | 2025-10-19 20:14:27 | smiths | 3 | 112716 | 696 | 29.860 | 3774.8 |
| 623 | 2025-10-17 00:58:34 | smiths | 3 | 112716 | 696 | 5.406 | 20850.2 |
| 622 | 2025-10-13 05:26:46 | smiths | 3 | 112716 | 696 | 5.720 | 19705.6 |
| 621 | 2025-10-01 04:09:34 | smiths | 2 | 82551 | 62 | 2.403 | 34353.3 |
| 620 | 2025-09-29 13:49:13 | smiths | 2 | 82551 | 62 | 2.780 | 29694.6 |
| 619 | 2025-09-17 19:31:43 | smiths | 3 | 112716 | 696 | 5.920 | 19039.9 |
| 618 | 2025-09-09 15:06:11 | smiths | 3 | 112716 | 696 | 5.156 | 21861.1 |
| 617 | 2025-09-09 15:05:55 | smiths | 2 | 82551 | 62 | 2.626 | 31436.0 |
| 616 | 2025-09-08 12:41:02 | smiths | 2 | 82551 | 62 | 2.453 | 33653.1 |
| 615 | 2025-09-08 12:26:52 | smiths | 3 | 112716 | 696 | 5.470 | 20606.2 |
| 614 | 2025-09-04 02:16:03 | smiths | 1 | 48755 | 4 | 0.856 | 56956.8 |
| 613 | 2025-09-01 06:17:52 | smiths | 3 | 112716 | 696 | 5.326 | 21163.3 |
| 612 | 2025-08-27 15:56:03 | smiths | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 611 | 2025-08-26 22:09:41 | smiths | 3 | 112716 | 696 | 8.313 | 13559.0 |
| 610 | 2025-08-26 09:07:44 | smiths | 1 | 48755 | 4 | 0.920 | 52994.6 |
| 609 | 2025-08-25 15:41:51 | smiths | 3 | 112716 | 696 | 15.343 | 7346.4 |
| 608 | 2025-08-23 22:57:29 | smiths | 3 | 112716 | 696 | 12.733 | 8852.3 |
| 607 | 2025-08-12 13:05:56 | smiths | 1 | 48755 | 4 | 1.733 | 28133.3 |
| 606 | 2025-08-11 17:06:22 | smiths | 1 | 48755 | 4 | 1.733 | 28133.3 |
| 605 | 2025-08-11 04:44:03 | smiths | 1 | 48755 | 4 | 2.453 | 19875.7 |
| 604 | 2025-08-04 23:02:47 | smiths | 1 | 48755 | 4 | 2.420 | 20146.7 |
| 603 | 2025-08-03 03:59:09 | smiths | 2 | 82551 | 62 | 8.703 | 9485.3 |
| 602 | 2025-08-01 20:13:04 | smiths | 2 | 82551 | 62 | 11.236 | 7347.0 |
| 601 | 2025-07-31 20:59:38 | smiths | 1 | 48755 | 4 | 2.110 | 23106.6 |
| 600 | 2025-07-31 11:55:25 | smiths | 1 | 48755 | 4 | 3.513 | 13878.5 |
| 599 | 2025-07-30 23:43:11 | smiths | 1 | 48755 | 4 | 5.296 | 9206.0 |
| 598 | 2025-07-30 08:50:58 | smiths | 1 | 48755 | 4 | 1.750 | 27860.0 |
| 597 | 2025-07-25 03:23:06 | smiths | 1 | 48755 | 4 | 2.940 | 16583.3 |
| 596 | 2025-07-24 04:22:36 | smiths | 1 | 48755 | 4 | 3.856 | 12643.9 |
| 595 | 2025-07-23 10:44:00 | smiths | 1 | 48755 | 4 | 4.500 | 10834.4 |
| 594 | 2025-07-23 04:23:51 | smiths | 3 | 112716 | 696 | 14.406 | 7824.2 |
| 593 | 2025-07-22 19:36:00 | smiths | 1 | 48755 | 4 | 2.250 | 21668.9 |
| 592 | 2025-07-21 23:06:01 | smiths | 3 | 112716 | 696 | 26.970 | 4179.3 |
| 591 | 2025-07-18 18:09:39 | smiths | 3 | 112716 | 696 | 17.926 | 6287.9 |
| 590 | 2025-07-18 16:32:52 | smiths | 1 | 48755 | 4 | 5.423 | 8990.4 |
| 589 | 2025-07-18 11:37:04 | smiths | 3 | 112716 | 696 | 23.876 | 4720.9 |
| 588 | 2025-07-18 01:42:08 | smiths | 2 | 82551 | 62 | 7.190 | 11481.4 |
| 587 | 2025-07-17 13:46:13 | smiths | 1 | 48755 | 4 | 6.046 | 8064.0 |
| 586 | 2025-07-17 10:11:01 | smiths | 3 | 112716 | 696 | 16.250 | 6936.4 |
| 585 | 2025-07-16 17:32:52 | smiths | 3 | 112716 | 696 | 23.643 | 4767.4 |
| 584 | 2025-07-16 16:36:36 | smiths | 3 | 112716 | 696 | 5.173 | 21789.3 |
| 583 | 2025-07-16 01:53:13 | smiths | 2 | 82551 | 62 | 2.500 | 33020.4 |
| 582 | 2025-07-14 20:24:46 | smiths | 1 | 48755 | 4 | 6.266 | 7780.9 |
| 581 | 2025-07-13 11:15:09 | smiths | 1 | 48755 | 4 | 3.233 | 15080.4 |
| 580 | 2025-07-12 07:36:36 | smiths | 2 | 82551 | 62 | 2.500 | 33020.4 |
| 579 | 2025-07-11 12:17:52 | smiths | 2 | 82551 | 62 | 18.720 | 4409.8 |
| 578 | 2025-07-10 21:10:32 | smiths | 1 | 48755 | 4 | 5.626 | 8666.0 |
| 577 | 2025-07-09 23:54:57 | smiths | 3 | 112716 | 696 | 19.096 | 5902.6 |
| 576 | 2025-07-09 21:18:45 | smiths | 2 | 82551 | 62 | 8.036 | 10272.6 |
| 575 | 2025-07-09 21:03:50 | smiths | 3 | 112716 | 696 | 24.893 | 4528.0 |
| 574 | 2025-07-09 19:37:24 | smiths | 3 | 112716 | 696 | 5.173 | 21789.3 |
| 573 | 2025-07-07 20:31:48 | smiths | 1 | 48755 | 4 | 4.220 | 11553.3 |
| 572 | 2025-07-07 00:14:10 | smiths | 3 | 112716 | 696 | 25.420 | 4434.1 |
| 571 | 2025-07-02 06:14:16 | smiths | 1 | 48755 | 4 | 4.156 | 11731.2 |
| 570 | 2025-07-01 22:16:56 | smiths | 1 | 48755 | 4 | 2.313 | 21078.7 |
| 569 | 2025-06-30 20:32:33 | smiths | 1 | 48755 | 4 | 4.436 | 10990.8 |
| 568 | 2025-06-24 13:31:56 | smiths | 3 | 112716 | 696 | 29.626 | 3804.6 |
| 567 | 2025-06-20 03:55:49 | smiths | 1 | 48755 | 4 | 4.266 | 11428.7 |
| 566 | 2025-06-18 07:46:49 | smiths | 3 | 112716 | 696 | 19.203 | 5869.7 |
| 565 | 2025-06-16 15:24:22 | smiths | 3 | 112716 | 696 | 40.550 | 2779.7 |
| 564 | 2025-06-16 10:06:26 | smiths | 1 | 48755 | 4 | 4.546 | 10724.8 |
| 563 | 2025-06-16 08:10:13 | smiths | 3 | 112716 | 696 | 21.423 | 5261.4 |
| 562 | 2025-06-14 12:10:57 | smiths | 3 | 112716 | 696 | 34.533 | 3264.0 |
| 561 | 2025-06-13 16:07:25 | smiths | 3 | 112716 | 696 | 8.376 | 13457.0 |
| 560 | 2025-06-12 10:56:55 | smiths | 1 | 48755 | 4 | 1.983 | 24586.5 |
| 559 | 2025-06-10 14:26:02 | smiths | 1 | 48755 | 4 | 3.390 | 14382.0 |
| 558 | 2025-06-07 16:00:09 | smiths | 1 | 48755 | 4 | 1.296 | 37619.6 |
| 557 | 2025-06-06 04:11:38 | smiths | 1 | 48755 | 4 | 3.703 | 13166.4 |
| 556 | 2025-06-04 04:00:23 | smiths | 3 | 112716 | 696 | 28.186 | 3999.0 |
| 555 | 2025-06-02 10:21:04 | smiths | 2 | 82551 | 62 | 12.220 | 6755.4 |
| 554 | 2025-06-02 07:05:06 | smiths | 2 | 82551 | 62 | 6.596 | 12515.3 |
| 553 | 2025-06-01 17:08:09 | smiths | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 552 | 2025-05-31 21:09:49 | smiths | 2 | 82551 | 62 | 7.110 | 11610.5 |
| 551 | 2025-05-30 21:52:23 | smiths | 1 | 48755 | 4 | 2.076 | 23485.1 |
| 550 | 2025-05-30 20:15:31 | smiths | 1 | 48755 | 4 | 3.250 | 15001.5 |
| 549 | 2025-05-30 02:42:55 | smiths | 3 | 112716 | 696 | 5.626 | 20034.8 |
| 548 | 2025-05-20 20:21:09 | smiths | 2 | 82551 | 62 | 2.623 | 31472.0 |
| 547 | 2025-05-20 17:49:24 | smiths | 1 | 48755 | 4 | 4.483 | 10875.5 |
| 546 | 2025-05-18 22:46:24 | smiths | 2 | 82551 | 62 | 2.390 | 34540.2 |
| 545 | 2025-05-18 01:11:57 | smiths | 2 | 82551 | 62 | 10.736 | 7689.2 |
| 544 | 2025-05-17 22:43:55 | smiths | 3 | 112716 | 696 | 27.670 | 4073.6 |
| 543 | 2025-05-17 20:39:56 | smiths | 2 | 82551 | 62 | 15.093 | 5469.5 |
| 542 | 2025-05-17 08:31:54 | smiths | 3 | 112716 | 696 | 5.783 | 19490.9 |
| 541 | 2025-05-17 03:30:33 | smiths | 2 | 82551 | 62 | 12.733 | 6483.2 |
| 540 | 2025-05-16 15:26:51 | smiths | 3 | 112716 | 696 | 20.736 | 5435.8 |
| 539 | 2025-05-16 08:11:01 | smiths | 3 | 112716 | 696 | 22.403 | 5031.3 |
| 538 | 2025-05-16 07:58:32 | smiths | 3 | 112716 | 696 | 24.033 | 4690.1 |
| 537 | 2025-05-15 23:36:50 | smiths | 2 | 82551 | 62 | 14.720 | 5608.1 |
| 536 | 2025-05-15 11:23:56 | smiths | 3 | 112716 | 696 | 22.910 | 4919.9 |
| 535 | 2025-05-15 10:25:07 | smiths | 1 | 48755 | 4 | 1.750 | 27860.0 |
| 534 | 2025-05-15 01:27:36 | smiths | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 533 | 2025-05-11 15:46:12 | smiths | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 532 | 2025-05-11 08:56:09 | smiths | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 531 | 2025-05-09 14:11:15 | smiths | 1 | 48755 | 4 | 3.576 | 13633.9 |
| 530 | 2025-05-05 05:48:31 | smiths | 3 | 112716 | 696 | 7.376 | 15281.5 |