History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pearly"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 669 | 2025-10-19 13:33:50 | pearly | 1 | 48755 | 8 | 1.156 | 42175.6 |
| 668 | 2025-10-19 00:30:06 | pearly | 1 | 48755 | 8 | 0.966 | 50471.0 |
| 667 | 2025-10-08 22:50:18 | pearly | 1 | 48755 | 8 | 0.920 | 52994.6 |
| 666 | 2025-10-08 16:39:50 | pearly | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 665 | 2025-10-04 18:30:05 | pearly | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 664 | 2025-09-30 20:13:36 | pearly | 1 | 48755 | 8 | 0.873 | 55847.7 |
| 663 | 2025-09-30 04:45:10 | pearly | 1 | 48755 | 8 | 0.936 | 52088.7 |
| 662 | 2025-09-28 14:12:03 | pearly | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 661 | 2025-09-25 05:54:30 | pearly | 3 | 112716 | 706 | 15.736 | 7162.9 |
| 660 | 2025-09-25 05:54:16 | pearly | 3 | 112716 | 706 | 27.580 | 4086.9 |
| 659 | 2025-09-25 05:54:30 | pearly | 2 | 82551 | 65 | 12.936 | 6381.5 |
| 658 | 2025-09-25 05:54:08 | pearly | 3 | 112716 | 706 | 32.050 | 3516.9 |
| 657 | 2025-09-25 05:54:22 | pearly | 3 | 112716 | 706 | 16.016 | 7037.7 |
| 656 | 2025-09-25 05:54:21 | pearly | 2 | 82551 | 65 | 9.906 | 8333.4 |
| 655 | 2025-09-25 05:54:16 | pearly | 2 | 82551 | 65 | 14.533 | 5680.2 |
| 654 | 2025-09-25 05:54:05 | pearly | 2 | 82551 | 65 | 6.890 | 11981.3 |
| 653 | 2025-09-25 04:40:00 | pearly | 1 | 48755 | 8 | 0.903 | 53992.2 |
| 652 | 2025-09-16 21:00:23 | pearly | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 651 | 2025-09-15 03:22:05 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 650 | 2025-09-14 11:09:20 | pearly | 1 | 48755 | 8 | 0.923 | 52822.3 |
| 649 | 2025-09-05 04:49:59 | pearly | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 648 | 2025-08-26 20:11:10 | pearly | 1 | 48755 | 8 | 0.923 | 52822.3 |
| 647 | 2025-08-25 12:14:28 | pearly | 1 | 48755 | 8 | 2.060 | 23667.5 |
| 646 | 2025-08-25 05:10:37 | pearly | 1 | 48755 | 8 | 1.890 | 25796.3 |
| 645 | 2025-08-09 03:35:32 | pearly | 1 | 48755 | 8 | 2.046 | 23829.4 |
| 644 | 2025-08-07 17:44:13 | pearly | 1 | 48755 | 8 | 1.970 | 24748.7 |
| 643 | 2025-08-04 19:20:29 | pearly | 1 | 48755 | 8 | 3.563 | 13683.7 |
| 642 | 2025-08-04 12:32:47 | pearly | 3 | 112716 | 706 | 16.390 | 6877.1 |
| 641 | 2025-08-04 06:51:57 | pearly | 3 | 112716 | 706 | 12.610 | 8938.6 |
| 640 | 2025-08-03 23:34:20 | pearly | 1 | 48755 | 8 | 2.203 | 22131.2 |
| 639 | 2025-08-03 00:29:50 | pearly | 2 | 82551 | 65 | 16.876 | 4891.6 |
| 638 | 2025-08-03 00:28:12 | pearly | 3 | 112716 | 706 | 32.046 | 3517.3 |
| 637 | 2025-08-01 08:26:38 | pearly | 3 | 112716 | 706 | 39.783 | 2833.3 |
| 636 | 2025-07-31 15:38:41 | pearly | 1 | 48755 | 8 | 0.856 | 56956.8 |
| 635 | 2025-07-31 00:31:01 | pearly | 1 | 48755 | 8 | 4.720 | 10329.4 |
| 634 | 2025-07-27 21:43:37 | pearly | 3 | 112716 | 706 | 26.456 | 4260.5 |
| 633 | 2025-07-27 21:36:31 | pearly | 2 | 82551 | 65 | 5.643 | 14628.9 |
| 632 | 2025-07-25 07:23:54 | pearly | 1 | 48755 | 8 | 2.076 | 23485.1 |
| 631 | 2025-07-24 15:53:44 | pearly | 1 | 48755 | 8 | 1.986 | 24549.3 |
| 630 | 2025-07-24 00:26:19 | pearly | 1 | 48755 | 8 | 3.576 | 13633.9 |
| 629 | 2025-07-23 18:56:51 | pearly | 1 | 48755 | 8 | 2.186 | 22303.3 |
| 628 | 2025-07-23 04:03:19 | pearly | 1 | 48755 | 8 | 2.550 | 19119.6 |
| 627 | 2025-07-23 01:27:16 | pearly | 1 | 48755 | 8 | 4.483 | 10875.5 |
| 626 | 2025-07-23 00:34:35 | pearly | 1 | 48755 | 8 | 3.546 | 13749.3 |
| 625 | 2025-07-22 13:57:45 | pearly | 1 | 48755 | 8 | 1.860 | 26212.4 |
| 624 | 2025-07-19 03:27:28 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 623 | 2025-07-13 12:04:09 | pearly | 1 | 48755 | 8 | 3.953 | 12333.7 |
| 622 | 2025-07-09 20:45:53 | pearly | 1 | 48755 | 8 | 4.110 | 11862.5 |
| 621 | 2025-07-08 02:29:03 | pearly | 1 | 48755 | 8 | 6.000 | 8125.8 |
| 620 | 2025-07-04 17:02:44 | pearly | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 619 | 2025-07-01 22:37:15 | pearly | 1 | 48755 | 8 | 2.373 | 20545.7 |
| 618 | 2025-06-25 22:25:29 | pearly | 1 | 48755 | 8 | 2.796 | 17437.4 |
| 617 | 2025-06-24 16:51:42 | pearly | 1 | 48755 | 8 | 3.643 | 13383.2 |
| 616 | 2025-06-20 17:11:22 | pearly | 1 | 48755 | 8 | 3.156 | 15448.4 |
| 615 | 2025-06-20 10:08:25 | pearly | 1 | 48755 | 8 | 5.516 | 8838.8 |
| 614 | 2025-06-19 21:33:57 | pearly | 1 | 48755 | 8 | 4.156 | 11731.2 |
| 613 | 2025-06-11 13:56:06 | pearly | 1 | 48755 | 8 | 4.436 | 10990.8 |
| 612 | 2025-06-07 06:58:22 | pearly | 3 | 112716 | 706 | 19.173 | 5878.9 |
| 611 | 2025-06-07 06:18:45 | pearly | 3 | 112716 | 706 | 17.906 | 6294.9 |
| 610 | 2025-06-06 11:12:46 | pearly | 3 | 112716 | 706 | 29.826 | 3779.1 |
| 609 | 2025-06-06 02:19:48 | pearly | 3 | 112716 | 706 | 34.313 | 3284.9 |
| 608 | 2025-06-05 09:06:07 | pearly | 3 | 112716 | 706 | 27.126 | 4155.3 |
| 607 | 2025-06-04 00:31:51 | pearly | 3 | 112716 | 706 | 26.860 | 4196.4 |
| 606 | 2025-06-01 21:41:37 | pearly | 1 | 48755 | 8 | 4.610 | 10575.9 |
| 605 | 2025-05-28 12:49:54 | pearly | 1 | 48755 | 8 | 2.530 | 19270.8 |
| 604 | 2025-05-28 04:28:41 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 603 | 2025-05-23 20:28:42 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 602 | 2025-05-22 06:27:55 | pearly | 1 | 48755 | 8 | 3.720 | 13106.2 |
| 601 | 2025-05-20 07:05:22 | pearly | 1 | 48755 | 8 | 2.423 | 20121.7 |
| 600 | 2025-05-19 22:07:48 | pearly | 1 | 48755 | 8 | 1.983 | 24586.5 |
| 599 | 2025-05-18 11:51:37 | pearly | 1 | 48755 | 8 | 4.046 | 12050.2 |
| 598 | 2025-05-15 18:23:13 | pearly | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 597 | 2025-05-12 18:38:19 | pearly | 3 | 112716 | 706 | 6.516 | 17298.3 |
| 596 | 2025-05-06 11:34:06 | pearly | 3 | 112716 | 706 | 32.906 | 3425.4 |
| 595 | 2025-05-05 10:09:15 | pearly | 3 | 112716 | 706 | 5.203 | 21663.7 |
| 594 | 2025-05-03 02:49:12 | pearly | 1 | 48755 | 8 | 2.890 | 16870.2 |
| 593 | 2025-05-01 21:37:17 | pearly | 1 | 48755 | 8 | 6.046 | 8064.0 |
| 592 | 2025-04-26 16:11:03 | pearly | 2 | 82551 | 65 | 16.140 | 5114.7 |
| 591 | 2025-04-24 22:44:59 | pearly | 2 | 82551 | 65 | 2.796 | 29524.7 |
| 590 | 2025-04-23 18:16:11 | pearly | 3 | 112716 | 706 | 8.656 | 13021.7 |
| 589 | 2025-04-23 06:24:24 | pearly | 3 | 112716 | 706 | 30.016 | 3755.2 |
| 588 | 2025-04-21 02:14:29 | pearly | 3 | 112716 | 706 | 14.703 | 7666.2 |
| 587 | 2025-04-20 06:17:40 | pearly | 1 | 48755 | 8 | 2.250 | 21668.9 |
| 586 | 2025-04-20 05:25:31 | pearly | 1 | 48755 | 8 | 2.470 | 19738.9 |
| 585 | 2025-04-19 20:19:36 | pearly | 1 | 48755 | 8 | 0.873 | 55847.7 |
| 584 | 2025-04-19 06:42:11 | pearly | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 583 | 2025-04-17 13:36:10 | pearly | 1 | 48755 | 8 | 3.656 | 13335.6 |
| 582 | 2025-04-15 11:24:14 | pearly | 1 | 48755 | 8 | 1.923 | 25353.6 |
| 581 | 2025-04-12 09:31:49 | pearly | 3 | 112716 | 706 | 40.673 | 2771.3 |
| 580 | 2025-04-10 07:39:56 | pearly | 3 | 112716 | 706 | 5.830 | 19333.8 |
| 579 | 2025-04-08 16:56:27 | pearly | 1 | 48755 | 8 | 0.876 | 55656.4 |
| 578 | 2025-04-03 01:31:56 | pearly | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 577 | 2025-03-30 21:21:07 | pearly | 2 | 82551 | 65 | 18.300 | 4511.0 |
| 576 | 2025-03-21 22:35:03 | pearly | 2 | 82551 | 65 | 22.016 | 3749.6 |
| 575 | 2025-03-21 16:49:01 | pearly | 2 | 82551 | 65 | 11.796 | 6998.2 |
| 574 | 2025-03-20 21:23:10 | pearly | 3 | 112716 | 706 | 8.893 | 12674.7 |
| 573 | 2025-03-20 13:21:45 | pearly | 3 | 112716 | 706 | 23.703 | 4755.3 |
| 572 | 2025-03-20 08:13:56 | pearly | 1 | 48755 | 8 | 4.470 | 10907.2 |
| 571 | 2025-03-20 07:30:18 | pearly | 3 | 112716 | 706 | 25.796 | 4369.5 |
| 570 | 2025-03-20 06:29:44 | pearly | 1 | 48755 | 8 | 4.016 | 12140.2 |