History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roofing"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 757 | 2025-11-22 21:55:47 | roofing | 1 | 69583 | 11 | 11.686 | 5954.4 |
| 756 | 2025-11-16 04:36:08 | roofing | 1 | 69583 | 11 | 1.296 | 53690.6 |
| 755 | 2025-10-25 10:14:51 | roofing | 1 | 69583 | 11 | 1.330 | 52318.0 |
| 754 | 2025-10-20 20:16:38 | roofing | 1 | 69583 | 11 | 4.830 | 14406.4 |
| 753 | 2025-10-20 20:16:26 | roofing | 1 | 69583 | 11 | 3.220 | 21609.6 |
| 752 | 2025-10-20 20:16:16 | roofing | 1 | 69583 | 11 | 6.470 | 10754.7 |
| 751 | 2025-10-20 20:16:07 | roofing | 1 | 69583 | 11 | 6.376 | 10913.3 |
| 750 | 2025-10-02 01:05:21 | roofing | 1 | 69583 | 11 | 1.140 | 61037.7 |
| 749 | 2025-09-18 23:56:40 | roofing | 1 | 69583 | 11 | 1.203 | 57841.2 |
| 748 | 2025-09-18 04:29:51 | roofing | 1 | 69583 | 11 | 1.310 | 53116.8 |
| 747 | 2025-09-14 20:37:03 | roofing | 1 | 69583 | 11 | 1.250 | 55666.4 |
| 746 | 2025-09-11 13:12:21 | roofing | 1 | 69583 | 11 | 1.126 | 61796.6 |
| 745 | 2025-09-08 05:38:01 | roofing | 1 | 69583 | 11 | 1.236 | 56296.9 |
| 744 | 2025-09-04 22:35:37 | roofing | 1 | 69583 | 11 | 1.296 | 53690.6 |
| 743 | 2025-09-02 10:35:52 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
| 742 | 2025-09-01 15:20:22 | roofing | 1 | 69583 | 11 | 1.330 | 52318.0 |
| 741 | 2025-08-29 07:41:46 | roofing | 1 | 69583 | 11 | 1.220 | 57035.2 |
| 740 | 2025-08-26 01:01:05 | roofing | 1 | 69583 | 11 | 1.203 | 57841.2 |
| 739 | 2025-08-25 11:37:56 | roofing | 1 | 69583 | 11 | 5.110 | 13617.0 |
| 738 | 2025-08-22 16:41:51 | roofing | 1 | 69583 | 11 | 1.266 | 54962.9 |
| 737 | 2025-08-15 23:08:21 | roofing | 1 | 69583 | 11 | 2.593 | 26834.9 |
| 736 | 2025-08-07 06:34:08 | roofing | 1 | 69583 | 11 | 2.750 | 25302.9 |
| 735 | 2025-08-06 04:00:40 | roofing | 2 | 107671 | 106 | 8.470 | 12712.0 |
| 734 | 2025-08-04 19:04:32 | roofing | 1 | 69583 | 11 | 2.796 | 24886.6 |
| 733 | 2025-08-02 16:40:10 | roofing | 1 | 69583 | 11 | 2.466 | 28217.0 |
| 732 | 2025-08-02 06:50:54 | roofing | 2 | 107671 | 106 | 19.876 | 5417.1 |
| 731 | 2025-07-31 23:27:52 | roofing | 1 | 69583 | 11 | 8.123 | 8566.2 |
| 730 | 2025-07-28 18:12:05 | roofing | 2 | 107671 | 106 | 8.343 | 12905.5 |
| 729 | 2025-07-27 11:20:04 | roofing | 1 | 69583 | 11 | 2.700 | 25771.5 |
| 728 | 2025-07-26 12:56:04 | roofing | 1 | 69583 | 11 | 1.110 | 62687.4 |
| 727 | 2025-07-26 09:24:53 | roofing | 1 | 69583 | 11 | 3.313 | 21003.0 |
| 726 | 2025-07-25 08:23:21 | roofing | 1 | 69583 | 11 | 2.593 | 26834.9 |
| 725 | 2025-07-25 06:44:35 | roofing | 1 | 69583 | 11 | 2.453 | 28366.5 |
| 724 | 2025-07-20 03:31:19 | roofing | 1 | 69583 | 11 | 1.296 | 53690.6 |
| 723 | 2025-07-19 07:00:27 | roofing | 1 | 69583 | 11 | 1.110 | 62687.4 |
| 722 | 2025-07-19 04:45:49 | roofing | 1 | 69583 | 11 | 1.313 | 52995.4 |
| 721 | 2025-07-13 11:53:04 | roofing | 1 | 69583 | 11 | 1.266 | 54962.9 |
| 720 | 2025-07-08 03:17:32 | roofing | 1 | 69583 | 11 | 2.720 | 25582.0 |
| 719 | 2025-07-06 19:34:58 | roofing | 1 | 69583 | 11 | 1.236 | 56296.9 |
| 718 | 2025-07-06 05:07:19 | roofing | 1 | 69583 | 11 | 3.543 | 19639.6 |
| 717 | 2025-07-02 11:18:12 | roofing | 2 | 107671 | 106 | 8.970 | 12003.5 |
| 716 | 2025-06-30 22:30:50 | roofing | 1 | 69583 | 11 | 2.516 | 27656.2 |
| 715 | 2025-06-30 22:22:57 | roofing | 1 | 69583 | 11 | 3.610 | 19275.1 |
| 714 | 2025-06-29 12:57:29 | roofing | 1 | 69583 | 11 | 1.093 | 63662.4 |
| 713 | 2025-06-22 10:30:49 | roofing | 1 | 69583 | 11 | 5.673 | 12265.6 |
| 712 | 2025-06-22 05:05:23 | roofing | 1 | 69583 | 11 | 3.016 | 23071.3 |
| 711 | 2025-06-10 09:29:04 | roofing | 1 | 69583 | 11 | 5.580 | 12470.1 |
| 710 | 2025-05-30 22:12:08 | roofing | 1 | 69583 | 11 | 11.860 | 5867.0 |
| 709 | 2025-05-28 09:14:49 | roofing | 1 | 69583 | 11 | 1.140 | 61037.7 |
| 708 | 2025-05-22 00:48:31 | roofing | 1 | 69583 | 11 | 5.640 | 12337.4 |
| 707 | 2025-05-20 11:05:07 | roofing | 1 | 69583 | 11 | 5.906 | 11781.7 |
| 706 | 2025-05-13 10:39:29 | roofing | 1 | 69583 | 11 | 1.266 | 54962.9 |
| 705 | 2025-05-11 20:12:39 | roofing | 1 | 69583 | 11 | 4.046 | 17198.0 |
| 704 | 2025-04-29 21:49:22 | roofing | 1 | 69583 | 11 | 4.093 | 17000.5 |
| 703 | 2025-04-28 13:06:25 | roofing | 1 | 69583 | 11 | 2.733 | 25460.3 |
| 702 | 2025-04-20 08:57:18 | roofing | 1 | 69583 | 11 | 2.906 | 23944.6 |
| 701 | 2025-04-11 11:07:03 | roofing | 1 | 69583 | 11 | 4.656 | 14944.8 |
| 700 | 2025-04-06 10:46:03 | roofing | 1 | 69583 | 11 | 4.923 | 14134.3 |
| 699 | 2025-04-02 15:17:42 | roofing | 2 | 107671 | 106 | 17.250 | 6241.8 |
| 698 | 2025-03-31 12:41:49 | roofing | 2 | 107671 | 106 | 17.483 | 6158.6 |
| 697 | 2025-03-29 22:16:34 | roofing | 1 | 69583 | 11 | 6.033 | 11533.7 |
| 696 | 2025-03-29 05:03:41 | roofing | 1 | 69583 | 11 | 8.656 | 8038.7 |
| 695 | 2025-03-28 13:42:11 | roofing | 1 | 69583 | 11 | 6.580 | 10574.9 |
| 694 | 2025-03-24 11:32:27 | roofing | 1 | 69583 | 11 | 6.626 | 10501.5 |
| 693 | 2025-03-21 07:02:55 | roofing | 1 | 69583 | 11 | 3.080 | 22591.9 |
| 692 | 2025-03-20 10:41:01 | roofing | 1 | 69583 | 11 | 2.750 | 25302.9 |
| 691 | 2025-03-16 22:50:55 | roofing | 1 | 69583 | 11 | 4.063 | 17126.0 |
| 690 | 2025-03-10 13:06:33 | roofing | 2 | 107671 | 106 | 10.876 | 9899.9 |
| 689 | 2025-03-10 12:57:08 | roofing | 1 | 69583 | 11 | 1.123 | 61961.7 |
| 688 | 2025-03-05 11:34:01 | roofing | 1 | 69583 | 11 | 5.626 | 12368.1 |
| 687 | 2025-02-27 12:14:18 | roofing | 2 | 107671 | 106 | 13.436 | 8013.6 |
| 686 | 2025-02-27 08:58:59 | roofing | 2 | 107671 | 106 | 22.953 | 4690.9 |
| 685 | 2025-02-27 08:58:35 | roofing | 1 | 69583 | 11 | 5.813 | 11970.2 |
| 684 | 2025-02-19 22:39:15 | roofing | 1 | 69583 | 11 | 8.233 | 8451.7 |
| 683 | 2025-02-04 19:48:09 | roofing | 1 | 69583 | 11 | 3.093 | 22496.9 |
| 682 | 2025-01-28 15:11:36 | roofing | 1 | 69583 | 11 | 8.750 | 7952.3 |
| 681 | 2025-01-17 09:34:38 | roofing | 1 | 69583 | 11 | 4.346 | 16010.8 |
| 680 | 2025-01-04 21:54:25 | roofing | 1 | 69583 | 11 | 2.156 | 32274.1 |
| 679 | 2024-12-30 07:28:19 | roofing | 1 | 69583 | 11 | 2.983 | 23326.5 |
| 678 | 2024-12-28 11:44:58 | roofing | 1 | 69583 | 11 | 5.190 | 13407.1 |
| 677 | 2024-12-16 12:21:22 | roofing | 1 | 69583 | 11 | 4.780 | 14557.1 |
| 676 | 2024-11-28 23:56:20 | roofing | 1 | 69583 | 11 | 6.143 | 11327.2 |
| 675 | 2024-11-15 13:31:07 | roofing | 1 | 69583 | 11 | 2.610 | 26660.2 |
| 674 | 2024-11-11 02:53:28 | roofing | 1 | 69583 | 11 | 3.153 | 22068.8 |
| 673 | 2024-10-27 23:28:03 | roofing | 1 | 69583 | 11 | 2.826 | 24622.4 |
| 672 | 2024-10-15 19:03:15 | roofing | 2 | 107671 | 106 | 13.343 | 8069.5 |
| 671 | 2024-10-15 19:03:18 | roofing | 1 | 69583 | 11 | 5.953 | 11688.7 |
| 670 | 2024-10-13 22:32:47 | roofing | 2 | 107671 | 106 | 16.190 | 6650.5 |
| 669 | 2024-10-11 20:48:56 | roofing | 2 | 107671 | 106 | 14.843 | 7254.0 |
| 668 | 2024-10-11 20:26:08 | roofing | 2 | 107671 | 106 | 17.190 | 6263.6 |
| 667 | 2024-10-11 20:25:55 | roofing | 1 | 69583 | 11 | 5.203 | 13373.6 |
| 666 | 2024-09-24 12:06:38 | roofing | 1 | 69583 | 11 | 4.530 | 15360.5 |
| 665 | 2024-09-24 01:16:39 | roofing | 1 | 69583 | 11 | 16.940 | 4107.6 |
| 664 | 2024-09-11 17:52:42 | roofing | 1 | 69583 | 11 | 3.843 | 18106.4 |
| 663 | 2024-09-06 03:59:31 | roofing | 1 | 69583 | 11 | 9.703 | 7171.3 |
| 662 | 2024-09-04 22:24:50 | roofing | 1 | 69583 | 11 | 12.643 | 5503.7 |
| 661 | 2024-08-19 19:29:36 | roofing | 1 | 69583 | 11 | 4.236 | 16426.6 |
| 660 | 2024-08-16 01:17:22 | roofing | 1 | 69583 | 11 | 8.266 | 8418.0 |
| 659 | 2024-08-01 07:47:19 | roofing | 1 | 69583 | 11 | 5.330 | 13055.0 |
| 658 | 2024-07-31 01:52:05 | roofing | 1 | 69583 | 11 | 4.373 | 15912.0 |