History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roofs"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 717 | 2025-10-23 06:43:24 | roofs | 1 | 28756 | 14 | 0.970 | 29645.4 |
| 716 | 2025-10-19 22:55:59 | roofs | 1 | 28756 | 14 | 0.516 | 55728.7 |
| 715 | 2025-10-19 14:08:46 | roofs | 1 | 28756 | 14 | 0.513 | 56054.6 |
| 714 | 2025-10-18 14:29:14 | roofs | 1 | 28756 | 14 | 0.546 | 52666.7 |
| 713 | 2025-10-17 10:47:01 | roofs | 1 | 28756 | 14 | 1.030 | 27918.4 |
| 712 | 2025-10-16 06:05:29 | roofs | 1 | 28756 | 14 | 1.063 | 27051.7 |
| 711 | 2025-10-15 18:24:44 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
| 710 | 2025-10-15 00:54:53 | roofs | 1 | 28756 | 14 | 0.483 | 59536.2 |
| 709 | 2025-10-14 17:52:00 | roofs | 1 | 28756 | 14 | 0.466 | 61708.2 |
| 708 | 2025-10-14 05:58:43 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
| 707 | 2025-10-13 14:29:54 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 706 | 2025-09-28 15:13:36 | roofs | 1 | 28756 | 14 | 0.533 | 53951.2 |
| 705 | 2025-09-27 17:11:50 | roofs | 1 | 28756 | 14 | 0.546 | 52666.7 |
| 704 | 2025-09-26 10:04:47 | roofs | 1 | 28756 | 14 | 0.546 | 52666.7 |
| 703 | 2025-09-24 17:53:19 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 702 | 2025-09-15 15:56:52 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 701 | 2025-09-15 07:20:45 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 700 | 2025-09-13 17:27:47 | roofs | 1 | 28756 | 14 | 1.033 | 27837.4 |
| 699 | 2025-09-13 13:04:27 | roofs | 1 | 28756 | 14 | 0.563 | 51076.4 |
| 698 | 2025-09-13 04:21:31 | roofs | 1 | 28756 | 14 | 0.513 | 56054.6 |
| 697 | 2025-09-12 19:47:03 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 696 | 2025-09-12 17:29:19 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
| 695 | 2025-09-11 03:00:03 | roofs | 1 | 28756 | 14 | 0.580 | 49579.3 |
| 694 | 2025-09-10 00:41:03 | roofs | 1 | 28756 | 14 | 1.030 | 27918.4 |
| 693 | 2025-09-09 04:12:54 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
| 692 | 2025-09-08 12:28:02 | roofs | 1 | 28756 | 14 | 0.580 | 49579.3 |
| 691 | 2025-09-07 09:56:22 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 690 | 2025-09-06 04:02:22 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
| 689 | 2025-09-04 00:15:19 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 688 | 2025-09-01 22:48:15 | roofs | 1 | 28756 | 14 | 0.580 | 49579.3 |
| 687 | 2025-08-30 23:04:52 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
| 686 | 2025-08-29 00:45:03 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 685 | 2025-08-28 22:03:25 | roofs | 1 | 28756 | 14 | 0.530 | 54256.6 |
| 684 | 2025-08-28 15:10:59 | roofs | 1 | 28756 | 14 | 0.610 | 47141.0 |
| 683 | 2025-08-27 16:22:26 | roofs | 1 | 28756 | 14 | 1.156 | 24875.4 |
| 682 | 2025-08-25 09:44:03 | roofs | 1 | 28756 | 14 | 2.970 | 9682.2 |
| 681 | 2025-08-11 04:48:11 | roofs | 1 | 28756 | 14 | 2.283 | 12595.7 |
| 680 | 2025-08-04 03:27:02 | roofs | 1 | 28756 | 14 | 1.500 | 19170.7 |
| 679 | 2025-08-01 17:53:34 | roofs | 2 | 53800 | 179 | 9.596 | 5606.5 |
| 678 | 2025-08-01 15:37:32 | roofs | 1 | 28756 | 14 | 1.220 | 23570.5 |
| 677 | 2025-08-01 13:28:45 | roofs | 1 | 28756 | 14 | 1.360 | 21144.1 |
| 676 | 2025-07-31 07:13:24 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 675 | 2025-07-27 16:51:13 | roofs | 1 | 28756 | 14 | 1.406 | 20452.3 |
| 674 | 2025-07-24 14:26:09 | roofs | 1 | 28756 | 14 | 1.670 | 17219.2 |
| 673 | 2025-07-23 07:51:00 | roofs | 1 | 28756 | 14 | 3.406 | 8442.7 |
| 672 | 2025-07-22 13:49:41 | roofs | 1 | 28756 | 14 | 1.533 | 18758.0 |
| 671 | 2025-07-22 03:58:14 | roofs | 1 | 28756 | 14 | 0.516 | 55728.7 |
| 670 | 2025-07-12 12:48:04 | roofs | 2 | 53800 | 179 | 1.720 | 31279.1 |
| 669 | 2025-07-11 12:26:19 | roofs | 2 | 53800 | 179 | 4.063 | 13241.4 |
| 668 | 2025-07-10 12:20:15 | roofs | 1 | 28756 | 14 | 2.406 | 11951.8 |
| 667 | 2025-07-10 11:32:18 | roofs | 1 | 28756 | 14 | 0.516 | 55728.7 |
| 666 | 2025-07-09 08:38:05 | roofs | 1 | 28756 | 14 | 0.470 | 61183.0 |
| 665 | 2025-07-09 06:18:41 | roofs | 1 | 28756 | 14 | 3.516 | 8178.6 |
| 664 | 2025-07-04 10:55:23 | roofs | 2 | 53800 | 179 | 1.643 | 32745.0 |
| 663 | 2025-07-04 02:16:17 | roofs | 1 | 28756 | 14 | 2.830 | 10161.1 |
| 662 | 2025-07-02 18:41:04 | roofs | 2 | 53800 | 179 | 8.843 | 6083.9 |
| 661 | 2025-07-02 14:39:38 | roofs | 1 | 28756 | 14 | 2.500 | 11502.4 |
| 660 | 2025-07-01 12:08:20 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 659 | 2025-06-30 19:34:07 | roofs | 2 | 53800 | 179 | 8.563 | 6282.8 |
| 658 | 2025-06-26 00:18:25 | roofs | 1 | 28756 | 14 | 2.576 | 11163.0 |
| 657 | 2025-06-18 17:02:54 | roofs | 1 | 28756 | 14 | 1.343 | 21411.8 |
| 656 | 2025-06-14 10:35:47 | roofs | 1 | 28756 | 14 | 2.360 | 12184.7 |
| 655 | 2025-06-11 13:27:18 | roofs | 1 | 28756 | 14 | 1.330 | 21621.1 |
| 654 | 2025-06-10 08:28:23 | roofs | 2 | 53800 | 179 | 8.173 | 6582.7 |
| 653 | 2025-06-09 09:04:01 | roofs | 1 | 28756 | 14 | 0.533 | 53951.2 |
| 652 | 2025-06-04 01:52:07 | roofs | 1 | 28756 | 14 | 3.406 | 8442.7 |
| 651 | 2025-06-02 14:15:01 | roofs | 1 | 28756 | 14 | 2.843 | 10114.7 |
| 650 | 2025-06-02 02:40:34 | roofs | 2 | 53800 | 179 | 8.720 | 6169.7 |
| 649 | 2025-06-01 11:33:39 | roofs | 1 | 28756 | 14 | 0.453 | 63479.0 |
| 648 | 2025-06-01 02:22:26 | roofs | 2 | 53800 | 179 | 6.440 | 8354.0 |
| 647 | 2025-05-30 14:37:24 | roofs | 2 | 53800 | 179 | 5.470 | 9835.5 |
| 646 | 2025-05-28 17:39:43 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 645 | 2025-05-28 16:03:21 | roofs | 2 | 53800 | 179 | 1.716 | 31352.0 |
| 644 | 2025-05-27 02:34:51 | roofs | 1 | 28756 | 14 | 1.580 | 18200.0 |
| 643 | 2025-05-26 08:12:29 | roofs | 1 | 28756 | 14 | 3.436 | 8369.0 |
| 642 | 2025-05-16 18:04:22 | roofs | 1 | 28756 | 14 | 2.626 | 10950.5 |
| 641 | 2025-05-15 02:22:53 | roofs | 1 | 28756 | 14 | 0.500 | 57512.0 |
| 640 | 2025-05-12 10:45:34 | roofs | 1 | 28756 | 14 | 1.236 | 23265.4 |
| 639 | 2025-05-10 08:35:57 | roofs | 2 | 53800 | 179 | 4.626 | 11629.9 |
| 638 | 2025-05-09 09:13:26 | roofs | 1 | 28756 | 14 | 1.190 | 24164.7 |
| 637 | 2025-05-07 05:11:54 | roofs | 1 | 28756 | 14 | 0.580 | 49579.3 |
| 636 | 2025-05-04 03:33:34 | roofs | 1 | 28756 | 14 | 3.000 | 9585.3 |
| 635 | 2025-05-02 13:51:29 | roofs | 1 | 28756 | 14 | 1.483 | 19390.4 |
| 634 | 2025-04-30 11:40:23 | roofs | 1 | 28756 | 14 | 2.890 | 9950.2 |
| 633 | 2025-04-19 22:36:48 | roofs | 1 | 28756 | 14 | 1.813 | 15861.0 |
| 632 | 2025-04-18 21:28:36 | roofs | 1 | 28756 | 14 | 2.500 | 11502.4 |
| 631 | 2025-04-18 01:50:34 | roofs | 2 | 53800 | 179 | 5.673 | 9483.5 |
| 630 | 2025-04-16 10:29:32 | roofs | 2 | 53800 | 179 | 8.373 | 6425.4 |
| 629 | 2025-04-15 16:45:00 | roofs | 1 | 28756 | 14 | 0.440 | 65354.5 |
| 628 | 2025-04-11 09:44:16 | roofs | 1 | 28756 | 14 | 3.483 | 8256.1 |
| 627 | 2025-04-04 01:23:19 | roofs | 1 | 28756 | 14 | 1.296 | 22188.3 |
| 626 | 2025-03-29 14:05:55 | roofs | 1 | 28756 | 14 | 1.580 | 18200.0 |
| 625 | 2025-03-15 17:57:29 | roofs | 1 | 28756 | 14 | 1.640 | 17534.1 |
| 624 | 2025-03-13 20:55:37 | roofs | 1 | 28756 | 14 | 2.343 | 12273.2 |
| 623 | 2025-03-10 23:35:43 | roofs | 1 | 28756 | 14 | 3.390 | 8482.6 |
| 622 | 2025-03-09 06:36:30 | roofs | 1 | 28756 | 14 | 2.076 | 13851.6 |
| 621 | 2025-03-04 06:16:40 | roofs | 1 | 28756 | 14 | 2.936 | 9794.3 |
| 620 | 2025-02-27 23:35:43 | roofs | 2 | 53800 | 179 | 10.550 | 5099.5 |
| 619 | 2025-02-27 20:11:16 | roofs | 2 | 53800 | 179 | 1.563 | 34421.0 |
| 618 | 2025-02-27 20:11:15 | roofs | 1 | 28756 | 14 | 0.533 | 53951.2 |