History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rooftops"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1058 | 2025-11-06 11:49:19 | rooftops | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 1057 | 2025-10-22 19:25:33 | rooftops | 1 | 82945 | 2 | 6.640 | 12491.7 |
| 1056 | 2025-10-22 19:25:02 | rooftops | 1 | 82945 | 2 | 6.813 | 12174.5 |
| 1055 | 2025-10-22 19:24:34 | rooftops | 1 | 82945 | 2 | 10.690 | 7759.1 |
| 1054 | 2025-10-22 19:24:04 | rooftops | 1 | 82945 | 2 | 9.533 | 8700.8 |
| 1053 | 2025-10-13 06:18:35 | rooftops | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 1052 | 2025-09-30 23:24:17 | rooftops | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 1051 | 2025-09-27 02:15:30 | rooftops | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 1050 | 2025-09-16 18:32:32 | rooftops | 2 | 121059 | 3 | 3.456 | 35028.6 |
| 1049 | 2025-09-08 05:07:00 | rooftops | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 1048 | 2025-08-19 14:14:14 | rooftops | 1 | 82945 | 2 | 2.983 | 27805.9 |
| 1047 | 2025-08-01 03:09:59 | rooftops | 1 | 82945 | 2 | 4.750 | 17462.1 |
| 1046 | 2025-08-01 01:25:05 | rooftops | 1 | 82945 | 2 | 2.783 | 29804.2 |
| 1045 | 2025-07-24 04:30:10 | rooftops | 1 | 82945 | 2 | 4.860 | 17066.9 |
| 1044 | 2025-07-19 13:07:25 | rooftops | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 1043 | 2025-07-19 12:52:14 | rooftops | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 1042 | 2025-07-14 06:08:22 | rooftops | 3 | 146162 | 34 | 28.766 | 5081.1 |
| 1041 | 2025-07-12 12:47:15 | rooftops | 2 | 121059 | 3 | 3.783 | 32000.8 |
| 1040 | 2025-07-12 12:34:53 | rooftops | 3 | 146162 | 34 | 7.610 | 19206.6 |
| 1039 | 2025-07-12 12:09:45 | rooftops | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 1038 | 2025-06-30 22:27:11 | rooftops | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 1037 | 2025-06-22 06:07:53 | rooftops | 1 | 82945 | 2 | 4.690 | 17685.5 |
| 1036 | 2025-06-07 00:33:18 | rooftops | 1 | 82945 | 2 | 3.503 | 23678.3 |
| 1035 | 2025-05-27 06:36:25 | rooftops | 1 | 82945 | 2 | 7.296 | 11368.6 |
| 1034 | 2025-05-24 04:55:39 | rooftops | 1 | 82945 | 2 | 6.620 | 12529.5 |
| 1033 | 2025-05-05 01:28:26 | rooftops | 1 | 82945 | 2 | 6.813 | 12174.5 |
| 1032 | 2025-05-02 02:26:17 | rooftops | 1 | 82945 | 2 | 8.076 | 10270.6 |
| 1031 | 2025-04-24 01:56:07 | rooftops | 2 | 121059 | 3 | 9.703 | 12476.5 |
| 1030 | 2025-04-22 04:28:27 | rooftops | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 1029 | 2025-04-18 00:24:48 | rooftops | 1 | 82945 | 2 | 4.766 | 17403.5 |
| 1028 | 2025-04-08 12:10:06 | rooftops | 3 | 146162 | 34 | 36.566 | 3997.2 |
| 1027 | 2025-04-08 11:00:02 | rooftops | 3 | 146162 | 34 | 29.046 | 5032.1 |
| 1026 | 2025-04-08 01:17:02 | rooftops | 2 | 121059 | 3 | 10.156 | 11919.9 |
| 1025 | 2025-04-07 14:23:24 | rooftops | 2 | 121059 | 3 | 11.953 | 10127.9 |
| 1024 | 2025-04-04 01:15:25 | rooftops | 2 | 121059 | 3 | 17.176 | 7048.1 |
| 1023 | 2025-04-03 02:00:47 | rooftops | 3 | 146162 | 34 | 7.470 | 19566.5 |
| 1022 | 2025-04-01 23:28:57 | rooftops | 1 | 82945 | 2 | 5.720 | 14500.9 |
| 1021 | 2025-03-31 18:38:37 | rooftops | 2 | 121059 | 3 | 16.000 | 7566.2 |
| 1020 | 2025-03-31 06:08:31 | rooftops | 3 | 146162 | 34 | 37.673 | 3879.8 |
| 1019 | 2025-03-31 01:51:19 | rooftops | 3 | 146162 | 34 | 33.470 | 4367.0 |
| 1018 | 2025-03-30 03:49:10 | rooftops | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 1017 | 2025-03-25 13:39:47 | rooftops | 1 | 82945 | 2 | 3.783 | 21925.7 |
| 1016 | 2025-03-20 06:46:01 | rooftops | 1 | 82945 | 2 | 6.750 | 12288.1 |
| 1015 | 2025-03-20 01:00:48 | rooftops | 1 | 82945 | 2 | 6.670 | 12435.5 |
| 1014 | 2025-03-12 00:47:44 | rooftops | 1 | 82945 | 2 | 10.436 | 7948.0 |
| 1013 | 2025-03-05 23:13:20 | rooftops | 3 | 146162 | 34 | 31.410 | 4653.4 |
| 1012 | 2025-03-02 02:49:40 | rooftops | 2 | 121059 | 3 | 9.543 | 12685.6 |
| 1011 | 2025-03-01 16:59:40 | rooftops | 3 | 146162 | 34 | 32.983 | 4431.4 |
| 1010 | 2025-02-24 18:44:52 | rooftops | 3 | 146162 | 34 | 43.533 | 3357.5 |
| 1009 | 2025-02-24 15:25:15 | rooftops | 3 | 146162 | 34 | 48.906 | 2988.6 |
| 1008 | 2025-02-18 10:04:54 | rooftops | 3 | 146162 | 34 | 40.236 | 3632.6 |
| 1007 | 2025-02-18 01:44:40 | rooftops | 3 | 146162 | 34 | 36.826 | 3969.0 |
| 1006 | 2025-02-14 08:53:54 | rooftops | 3 | 146162 | 34 | 37.363 | 3911.9 |
| 1005 | 2025-02-14 05:57:57 | rooftops | 1 | 82945 | 2 | 4.453 | 18626.8 |
| 1004 | 2025-02-13 18:14:02 | rooftops | 3 | 146162 | 34 | 36.530 | 4001.1 |
| 1003 | 2025-02-09 08:35:03 | rooftops | 1 | 82945 | 2 | 5.406 | 15343.1 |
| 1002 | 2025-02-04 14:38:49 | rooftops | 2 | 121059 | 3 | 17.376 | 6967.0 |
| 1001 | 2025-02-04 14:38:26 | rooftops | 1 | 82945 | 2 | 4.783 | 17341.6 |
| 1000 | 2025-01-24 22:06:04 | rooftops | 1 | 82945 | 2 | 3.220 | 25759.3 |
| 999 | 2025-01-24 22:01:28 | rooftops | 4 | 161609 | 370 | 44.250 | 3652.2 |
| 998 | 2025-01-24 22:01:27 | rooftops | 3 | 146162 | 34 | 34.673 | 4215.4 |
| 997 | 2025-01-24 21:30:05 | rooftops | 4 | 161609 | 370 | 52.970 | 3051.0 |
| 996 | 2025-01-24 21:16:26 | rooftops | 2 | 121059 | 3 | 7.233 | 16737.0 |
| 995 | 2025-01-24 21:15:57 | rooftops | 4 | 161609 | 370 | 16.733 | 9658.1 |
| 994 | 2025-01-24 21:15:31 | rooftops | 3 | 146162 | 34 | 7.953 | 18378.2 |
| 993 | 2025-01-22 14:30:19 | rooftops | 3 | 146162 | 34 | 22.330 | 6545.5 |
| 992 | 2025-01-12 05:52:15 | rooftops | 3 | 146162 | 34 | 39.973 | 3656.5 |
| 991 | 2025-01-11 14:00:54 | rooftops | 3 | 146162 | 34 | 24.233 | 6031.5 |
| 990 | 2025-01-11 14:00:37 | rooftops | 3 | 146162 | 34 | 34.986 | 4177.7 |
| 989 | 2025-01-11 14:00:41 | rooftops | 2 | 121059 | 3 | 9.016 | 13427.1 |
| 988 | 2025-01-11 13:59:29 | rooftops | 1 | 82945 | 2 | 7.080 | 11715.4 |
| 987 | 2024-12-23 22:43:16 | rooftops | 3 | 146162 | 34 | 31.793 | 4597.3 |
| 986 | 2024-12-23 22:43:18 | rooftops | 2 | 121059 | 3 | 24.140 | 5014.9 |
| 985 | 2024-12-23 22:43:07 | rooftops | 1 | 82945 | 2 | 1.906 | 43517.8 |
| 984 | 2024-12-23 22:35:31 | rooftops | 3 | 146162 | 34 | 14.220 | 10278.6 |
| 983 | 2024-12-20 02:18:28 | rooftops | 3 | 146162 | 34 | 37.953 | 3851.1 |
| 982 | 2024-12-20 02:18:31 | rooftops | 2 | 121059 | 3 | 18.530 | 6533.1 |
| 981 | 2024-12-20 02:18:16 | rooftops | 1 | 82945 | 2 | 5.000 | 16589.0 |
| 980 | 2024-12-10 17:30:58 | rooftops | 1 | 82945 | 2 | 7.233 | 11467.6 |
| 979 | 2024-12-09 19:04:59 | rooftops | 3 | 146162 | 34 | 49.266 | 2966.8 |
| 978 | 2024-12-05 21:32:34 | rooftops | 3 | 146162 | 34 | 19.080 | 7660.5 |
| 977 | 2024-12-05 17:46:07 | rooftops | 4 | 161609 | 370 | 52.330 | 3088.3 |
| 976 | 2024-12-05 17:46:07 | rooftops | 3 | 146162 | 34 | 30.440 | 4801.6 |
| 975 | 2024-12-05 17:46:02 | rooftops | 2 | 121059 | 3 | 18.876 | 6413.4 |
| 974 | 2024-12-05 17:45:57 | rooftops | 1 | 82945 | 2 | 7.890 | 10512.7 |
| 973 | 2024-11-16 19:39:21 | rooftops | 1 | 82945 | 2 | 7.326 | 11322.0 |
| 972 | 2024-11-11 10:47:07 | rooftops | 3 | 146162 | 34 | 26.890 | 5435.6 |
| 971 | 2024-11-11 02:57:12 | rooftops | 4 | 161609 | 370 | 71.123 | 2272.2 |
| 970 | 2024-11-11 02:57:16 | rooftops | 3 | 146162 | 34 | 37.500 | 3897.7 |
| 969 | 2024-11-11 02:57:18 | rooftops | 2 | 121059 | 3 | 9.140 | 13245.0 |
| 968 | 2024-11-10 14:47:30 | rooftops | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 967 | 2024-11-04 04:17:09 | rooftops | 2 | 121059 | 3 | 3.486 | 34727.2 |
| 966 | 2024-11-04 02:28:09 | rooftops | 3 | 146162 | 34 | 8.690 | 16819.6 |
| 965 | 2024-11-04 02:27:51 | rooftops | 3 | 146162 | 34 | 7.186 | 20339.8 |
| 964 | 2024-10-31 01:54:45 | rooftops | 2 | 121059 | 3 | 4.000 | 30264.8 |
| 963 | 2024-10-31 01:54:41 | rooftops | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 962 | 2024-10-28 03:02:06 | rooftops | 3 | 146162 | 34 | 40.566 | 3603.1 |
| 961 | 2024-10-27 23:27:14 | rooftops | 3 | 146162 | 34 | 31.596 | 4626.0 |
| 960 | 2024-10-27 15:25:37 | rooftops | 3 | 146162 | 34 | 35.300 | 4140.6 |
| 959 | 2024-10-10 05:37:28 | rooftops | 1 | 82945 | 2 | 6.376 | 13008.9 |