History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harpers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 634 | 2025-11-23 11:23:30 | harpers | 2 | 107671 | 136 | 4.390 | 24526.4 |
| 633 | 2025-11-18 19:40:47 | harpers | 2 | 107671 | 136 | 3.140 | 34290.1 |
| 632 | 2025-11-06 00:15:51 | harpers | 2 | 107671 | 136 | 3.186 | 33795.0 |
| 631 | 2025-11-05 05:02:55 | harpers | 2 | 107671 | 136 | 7.173 | 15010.6 |
| 630 | 2025-11-01 12:11:51 | harpers | 1 | 69583 | 7 | 1.343 | 51811.6 |
| 629 | 2025-10-24 05:01:07 | harpers | 2 | 107671 | 136 | 3.060 | 35186.6 |
| 628 | 2025-10-22 22:51:56 | harpers | 1 | 69583 | 7 | 1.170 | 59472.6 |
| 627 | 2025-10-21 03:58:46 | harpers | 2 | 107671 | 136 | 3.733 | 28843.0 |
| 626 | 2025-10-06 10:30:04 | harpers | 2 | 107671 | 136 | 4.000 | 26917.8 |
| 625 | 2025-10-02 09:14:47 | harpers | 1 | 69583 | 7 | 1.110 | 62687.4 |
| 624 | 2025-09-21 14:47:13 | harpers | 1 | 69583 | 7 | 1.266 | 54962.9 |
| 623 | 2025-09-19 02:44:26 | harpers | 2 | 107671 | 136 | 3.216 | 33479.8 |
| 622 | 2025-09-15 18:42:40 | harpers | 2 | 107671 | 136 | 3.500 | 30763.1 |
| 621 | 2025-09-12 11:22:56 | harpers | 2 | 107671 | 136 | 5.626 | 19138.1 |
| 620 | 2025-09-11 05:56:11 | harpers | 2 | 107671 | 136 | 5.546 | 19414.2 |
| 619 | 2025-09-09 03:44:20 | harpers | 2 | 107671 | 136 | 3.670 | 29338.1 |
| 618 | 2025-09-07 14:14:18 | harpers | 2 | 107671 | 136 | 3.576 | 30109.3 |
| 617 | 2025-09-05 20:38:42 | harpers | 2 | 107671 | 136 | 3.046 | 35348.3 |
| 616 | 2025-09-05 02:02:08 | harpers | 1 | 69583 | 7 | 1.190 | 58473.1 |
| 615 | 2025-09-02 13:46:36 | harpers | 2 | 107671 | 136 | 3.140 | 34290.1 |
| 614 | 2025-08-30 06:09:23 | harpers | 2 | 107671 | 136 | 3.326 | 32372.5 |
| 613 | 2025-08-26 22:56:45 | harpers | 2 | 107671 | 136 | 3.610 | 29825.8 |
| 612 | 2025-08-24 00:41:03 | harpers | 2 | 107671 | 136 | 8.110 | 13276.3 |
| 611 | 2025-08-23 21:44:51 | harpers | 1 | 69583 | 7 | 3.360 | 20709.2 |
| 610 | 2025-08-23 08:15:45 | harpers | 1 | 69583 | 7 | 2.546 | 27330.3 |
| 609 | 2025-08-20 22:12:36 | harpers | 2 | 107671 | 136 | 8.016 | 13432.0 |
| 608 | 2025-08-20 06:37:52 | harpers | 2 | 107671 | 136 | 3.356 | 32083.1 |
| 607 | 2025-08-16 22:14:48 | harpers | 1 | 69583 | 7 | 2.986 | 23303.1 |
| 606 | 2025-08-03 05:40:53 | harpers | 2 | 107671 | 136 | 20.783 | 5180.7 |
| 605 | 2025-08-02 06:10:39 | harpers | 1 | 69583 | 7 | 3.143 | 22139.0 |
| 604 | 2025-08-01 10:32:58 | harpers | 1 | 69583 | 7 | 2.936 | 23699.9 |
| 603 | 2025-08-01 10:18:29 | harpers | 1 | 69583 | 7 | 3.436 | 20251.2 |
| 602 | 2025-07-31 22:27:39 | harpers | 2 | 107671 | 136 | 25.296 | 4256.4 |
| 601 | 2025-07-31 14:40:36 | harpers | 1 | 69583 | 7 | 2.826 | 24622.4 |
| 600 | 2025-07-31 02:52:37 | harpers | 2 | 107671 | 136 | 4.563 | 23596.5 |
| 599 | 2025-07-27 07:59:56 | harpers | 2 | 107671 | 136 | 10.953 | 9830.3 |
| 598 | 2025-07-25 10:51:43 | harpers | 1 | 69583 | 7 | 7.766 | 8960.0 |
| 597 | 2025-07-24 18:28:27 | harpers | 1 | 69583 | 7 | 4.140 | 16807.5 |
| 596 | 2025-07-24 14:31:54 | harpers | 2 | 107671 | 136 | 16.893 | 6373.7 |
| 595 | 2025-07-24 10:29:22 | harpers | 2 | 107671 | 136 | 11.266 | 9557.2 |
| 594 | 2025-07-24 07:24:16 | harpers | 2 | 107671 | 136 | 9.843 | 10938.8 |
| 593 | 2025-07-23 23:29:23 | harpers | 1 | 69583 | 7 | 3.953 | 17602.6 |
| 592 | 2025-07-23 02:30:26 | harpers | 1 | 69583 | 7 | 5.420 | 12838.2 |
| 591 | 2025-07-21 02:11:41 | harpers | 2 | 107671 | 136 | 3.356 | 32083.1 |
| 590 | 2025-07-18 13:03:18 | harpers | 1 | 69583 | 7 | 3.953 | 17602.6 |
| 589 | 2025-07-14 03:24:37 | harpers | 2 | 107671 | 136 | 17.050 | 6315.0 |
| 588 | 2025-07-12 22:06:04 | harpers | 1 | 69583 | 7 | 2.046 | 34009.3 |
| 587 | 2025-07-08 07:42:41 | harpers | 1 | 69583 | 7 | 4.203 | 16555.6 |
| 586 | 2025-07-06 02:13:13 | harpers | 2 | 107671 | 136 | 10.470 | 10283.8 |
| 585 | 2025-07-04 10:03:07 | harpers | 2 | 107671 | 136 | 12.750 | 8444.8 |
| 584 | 2025-07-03 18:38:13 | harpers | 1 | 69583 | 7 | 2.516 | 27656.2 |
| 583 | 2025-07-01 01:47:17 | harpers | 2 | 107671 | 136 | 3.736 | 28819.9 |
| 582 | 2025-06-30 11:14:22 | harpers | 1 | 69583 | 7 | 6.266 | 11104.9 |
| 581 | 2025-06-28 15:19:28 | harpers | 2 | 107671 | 136 | 17.533 | 6141.0 |
| 580 | 2025-06-24 19:07:49 | harpers | 1 | 69583 | 7 | 1.173 | 59320.5 |
| 579 | 2025-06-22 18:44:14 | harpers | 2 | 107671 | 136 | 3.373 | 31921.4 |
| 578 | 2025-06-21 22:16:17 | harpers | 2 | 107671 | 136 | 15.830 | 6801.7 |
| 577 | 2025-06-21 15:59:32 | harpers | 1 | 69583 | 7 | 2.310 | 30122.5 |
| 576 | 2025-06-21 15:48:11 | harpers | 2 | 107671 | 136 | 11.516 | 9349.7 |
| 575 | 2025-06-21 15:27:36 | harpers | 2 | 107671 | 136 | 17.376 | 6196.5 |
| 574 | 2025-06-21 04:48:45 | harpers | 2 | 107671 | 136 | 17.890 | 6018.5 |
| 573 | 2025-06-20 11:06:06 | harpers | 1 | 69583 | 7 | 1.263 | 55093.4 |
| 572 | 2025-06-19 21:22:51 | harpers | 2 | 107671 | 136 | 14.110 | 7630.8 |
| 571 | 2025-06-18 14:16:42 | harpers | 2 | 107671 | 136 | 8.516 | 12643.4 |
| 570 | 2025-06-18 09:29:05 | harpers | 1 | 69583 | 7 | 5.203 | 13373.6 |
| 569 | 2025-06-17 16:24:22 | harpers | 2 | 107671 | 136 | 3.326 | 32372.5 |
| 568 | 2025-06-16 22:19:33 | harpers | 2 | 107671 | 136 | 15.936 | 6756.5 |
| 567 | 2025-06-15 21:48:06 | harpers | 2 | 107671 | 136 | 8.673 | 12414.5 |
| 566 | 2025-06-15 16:50:22 | harpers | 1 | 69583 | 7 | 3.093 | 22496.9 |
| 565 | 2025-06-15 13:32:14 | harpers | 1 | 69583 | 7 | 6.500 | 10705.1 |
| 564 | 2025-06-14 06:08:34 | harpers | 2 | 107671 | 136 | 14.890 | 7231.1 |
| 563 | 2025-06-13 19:32:22 | harpers | 2 | 107671 | 136 | 5.080 | 21195.1 |
| 562 | 2025-06-13 00:42:50 | harpers | 2 | 107671 | 136 | 3.640 | 29579.9 |
| 561 | 2025-06-11 22:09:09 | harpers | 1 | 69583 | 7 | 4.546 | 15306.4 |
| 560 | 2025-06-11 01:19:05 | harpers | 2 | 107671 | 136 | 8.690 | 12390.2 |
| 559 | 2025-06-09 09:59:29 | harpers | 2 | 107671 | 136 | 3.610 | 29825.8 |
| 558 | 2025-06-07 10:49:40 | harpers | 1 | 69583 | 7 | 2.513 | 27689.2 |
| 557 | 2025-06-03 21:50:05 | harpers | 1 | 69583 | 7 | 5.920 | 11753.9 |
| 556 | 2025-05-29 20:58:46 | harpers | 2 | 107671 | 136 | 3.220 | 33438.2 |
| 555 | 2025-05-28 21:10:44 | harpers | 1 | 69583 | 7 | 5.656 | 12302.5 |
| 554 | 2025-05-27 05:23:35 | harpers | 1 | 69583 | 7 | 10.953 | 6352.9 |
| 553 | 2025-05-23 17:03:12 | harpers | 1 | 69583 | 7 | 6.393 | 10884.2 |
| 552 | 2025-05-22 05:21:55 | harpers | 1 | 69583 | 7 | 5.673 | 12265.6 |
| 551 | 2025-05-21 22:20:51 | harpers | 2 | 107671 | 136 | 17.783 | 6054.7 |
| 550 | 2025-05-21 10:48:43 | harpers | 2 | 107671 | 136 | 2.986 | 36058.6 |
| 549 | 2025-05-20 12:38:37 | harpers | 1 | 69583 | 7 | 4.516 | 15408.1 |
| 548 | 2025-05-17 10:12:10 | harpers | 1 | 69583 | 7 | 1.296 | 53690.6 |
| 547 | 2025-05-15 15:24:02 | harpers | 1 | 69583 | 7 | 3.000 | 23194.3 |
| 546 | 2025-05-11 22:19:57 | harpers | 1 | 69583 | 7 | 4.846 | 14358.9 |
| 545 | 2025-05-10 11:45:10 | harpers | 1 | 69583 | 7 | 1.313 | 52995.4 |
| 544 | 2025-05-08 21:16:13 | harpers | 1 | 69583 | 7 | 8.500 | 8186.2 |
| 543 | 2025-05-05 05:40:26 | harpers | 2 | 107671 | 136 | 3.576 | 30109.3 |
| 542 | 2025-05-04 16:37:52 | harpers | 2 | 107671 | 136 | 17.936 | 6003.1 |
| 541 | 2025-05-04 01:24:05 | harpers | 2 | 107671 | 136 | 11.643 | 9247.7 |
| 540 | 2025-05-03 21:55:13 | harpers | 2 | 107671 | 136 | 17.313 | 6219.1 |
| 539 | 2025-05-03 09:43:15 | harpers | 2 | 107671 | 136 | 15.546 | 6926.0 |
| 538 | 2025-05-02 21:29:14 | harpers | 1 | 69583 | 7 | 3.093 | 22496.9 |
| 537 | 2025-04-30 08:42:17 | harpers | 1 | 69583 | 7 | 5.153 | 13503.4 |
| 536 | 2025-04-20 10:39:15 | harpers | 1 | 69583 | 7 | 1.263 | 55093.4 |
| 535 | 2025-04-18 04:20:47 | harpers | 2 | 107671 | 136 | 24.246 | 4440.8 |