History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unswept"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 229 | 2024-05-02 19:11:16 | unswept | 1 | 69583 | 4 | 2.406 | 28920.6 |
| 228 | 2024-04-05 02:06:01 | unswept | 2 | 107671 | 16 | 7.343 | 14663.1 |
| 227 | 2024-02-27 12:31:00 | unswept | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 226 | 2024-02-18 10:29:34 | unswept | 1 | 69583 | 4 | 2.626 | 26497.7 |
| 225 | 2024-01-23 13:03:23 | unswept | 3 | 134027 | 104 | 14.453 | 9273.3 |
| 224 | 2024-01-21 23:37:16 | unswept | 3 | 134027 | 104 | 7.233 | 18529.9 |
| 223 | 2024-01-12 17:05:13 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 222 | 2024-01-11 17:00:10 | unswept | 2 | 107671 | 16 | 6.110 | 17622.1 |
| 221 | 2024-01-11 17:00:08 | unswept | 3 | 134027 | 104 | 6.296 | 21287.6 |
| 220 | 2023-12-26 05:54:06 | unswept | 3 | 134027 | 104 | 11.860 | 11300.8 |
| 219 | 2023-12-26 05:54:07 | unswept | 2 | 107671 | 16 | 3.046 | 35348.3 |
| 218 | 2023-12-24 18:52:37 | unswept | 1 | 69583 | 4 | 2.140 | 32515.4 |
| 217 | 2023-12-08 12:42:39 | unswept | 2 | 107671 | 16 | 3.436 | 31336.1 |
| 216 | 2023-11-21 04:52:45 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 215 | 2023-11-17 17:39:28 | unswept | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 214 | 2023-11-13 05:37:49 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 213 | 2023-11-07 23:11:15 | unswept | 1 | 69583 | 4 | 1.030 | 67556.3 |
| 212 | 2023-11-05 02:52:56 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 211 | 2023-11-03 00:55:50 | unswept | 3 | 134027 | 104 | 5.486 | 24430.7 |
| 210 | 2023-10-24 15:07:13 | unswept | 1 | 69583 | 4 | 1.016 | 68487.2 |
| 209 | 2023-10-15 07:34:54 | unswept | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 208 | 2023-09-07 07:49:20 | unswept | 2 | 107671 | 16 | 2.700 | 39878.1 |
| 207 | 2023-08-28 02:41:30 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 206 | 2023-08-09 15:18:47 | unswept | 3 | 134027 | 104 | 5.500 | 24368.5 |
| 205 | 2023-07-20 13:40:58 | unswept | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 204 | 2023-05-31 14:06:33 | unswept | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 203 | 2023-05-29 02:04:54 | unswept | 2 | 107671 | 16 | 2.703 | 39833.9 |
| 202 | 2023-04-24 15:31:58 | unswept | 3 | 134027 | 104 | 5.423 | 24714.5 |
| 201 | 2023-03-25 09:54:35 | unswept | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 200 | 2023-03-09 05:47:17 | unswept | 2 | 107671 | 16 | 3.266 | 32967.2 |
| 199 | 2023-03-08 16:08:21 | unswept | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 198 | 2023-01-27 16:27:00 | unswept | 3 | 134027 | 104 | 5.390 | 24865.9 |
| 197 | 2023-01-10 21:01:57 | unswept | 1 | 69583 | 4 | 1.030 | 67556.3 |
| 196 | 2022-12-13 21:29:04 | unswept | 2 | 107671 | 16 | 2.720 | 39584.9 |
| 195 | 2022-11-09 00:26:56 | unswept | 3 | 134027 | 104 | 6.843 | 19586.0 |
| 194 | 2022-10-19 21:50:59 | unswept | 1 | 69583 | 4 | 1.050 | 66269.5 |
| 193 | 2022-10-08 03:42:53 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 192 | 2022-08-02 07:22:55 | unswept | 2 | 107671 | 16 | 3.046 | 35348.3 |
| 191 | 2022-06-10 10:44:22 | unswept | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 190 | 2022-05-18 16:32:26 | unswept | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 189 | 2022-05-15 04:26:12 | unswept | 3 | 134027 | 104 | 5.656 | 23696.4 |
| 188 | 2022-05-07 09:24:26 | unswept | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 187 | 2022-02-13 16:58:58 | unswept | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 186 | 2021-12-27 23:08:22 | unswept | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 185 | 2021-12-24 19:35:51 | unswept | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 184 | 2021-12-11 13:51:48 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 183 | 2021-12-09 09:32:24 | unswept | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 182 | 2021-11-04 03:46:48 | unswept | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 181 | 2021-08-22 12:59:11 | unswept | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 180 | 2021-05-04 21:24:59 | unswept | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 179 | 2021-04-24 18:34:42 | unswept | 3 | 134027 | 104 | 6.313 | 21230.3 |
| 178 | 2021-04-24 18:34:13 | unswept | 2 | 107671 | 16 | 2.783 | 38688.8 |
| 177 | 2021-04-05 04:34:32 | unswept | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 176 | 2021-02-27 17:59:03 | unswept | 2 | 107671 | 16 | 2.783 | 38688.8 |
| 175 | 2021-02-13 08:00:43 | unswept | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 174 | 2021-02-02 07:19:04 | unswept | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 173 | 2021-01-09 22:12:34 | unswept | 2 | 107671 | 16 | 2.873 | 37476.9 |
| 172 | 2020-12-11 13:00:04 | unswept | 3 | 134027 | 104 | 6.703 | 19995.1 |
| 171 | 2020-10-31 09:15:32 | unswept | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 170 | 2020-10-25 00:34:05 | unswept | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 169 | 2020-09-10 20:53:38 | unswept | 3 | 134027 | 104 | 5.643 | 23751.0 |
| 168 | 2020-09-07 02:13:25 | unswept | 3 | 134027 | 104 | 6.673 | 20085.0 |
| 167 | 2020-09-07 01:55:33 | unswept | 2 | 107671 | 16 | 3.733 | 28843.0 |
| 166 | 2020-07-28 06:19:12 | unswept | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 165 | 2020-07-25 23:26:13 | unswept | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 164 | 2020-07-24 22:19:08 | unswept | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 163 | 2020-07-18 17:30:43 | unswept | 2 | 107671 | 16 | 2.893 | 37217.8 |
| 162 | 2020-07-17 19:25:16 | unswept | 3 | 134027 | 104 | 5.983 | 22401.3 |
| 161 | 2020-04-20 16:54:46 | unswept | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 160 | 2020-03-29 20:37:53 | unswept | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 159 | 2020-03-29 09:23:55 | unswept | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 158 | 2020-03-28 23:49:49 | unswept | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 157 | 2020-03-28 01:30:42 | unswept | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 156 | 2020-03-23 01:13:06 | unswept | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 155 | 2020-02-28 23:20:57 | unswept | 1 | 69583 | 4 | 1.373 | 50679.5 |
| 154 | 2020-02-26 02:26:15 | unswept | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 153 | 2020-02-25 11:55:09 | unswept | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 152 | 2020-02-24 09:12:48 | unswept | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 151 | 2020-02-20 13:03:42 | unswept | 1 | 69583 | 4 | 2.203 | 31585.6 |
| 150 | 2020-02-11 11:45:17 | unswept | 1 | 69583 | 4 | 3.940 | 17660.7 |
| 149 | 2020-01-27 18:25:12 | unswept | 1 | 69583 | 4 | 2.516 | 27656.2 |
| 148 | 2020-01-27 05:53:26 | unswept | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 147 | 2020-01-25 16:54:56 | unswept | 1 | 69583 | 4 | 1.623 | 42873.1 |
| 146 | 2020-01-22 18:18:31 | unswept | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 145 | 2020-01-19 00:21:58 | unswept | 1 | 69583 | 4 | 1.300 | 53525.4 |
| 144 | 2020-01-13 09:35:15 | unswept | 1 | 69583 | 4 | 2.640 | 26357.2 |
| 143 | 2020-01-02 12:36:03 | unswept | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 142 | 2019-12-31 13:51:59 | unswept | 1 | 69583 | 4 | 2.390 | 29114.2 |
| 141 | 2019-12-29 20:26:21 | unswept | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 140 | 2019-12-27 23:58:28 | unswept | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 139 | 2019-10-03 16:23:51 | unswept | 1 | 69583 | 4 | 0.963 | 72256.5 |
| 138 | 2019-09-10 20:45:31 | unswept | 1 | 69583 | 4 | 1.050 | 66269.5 |
| 137 | 2019-06-18 06:05:24 | unswept | 1 | 69583 | 4 | 1.036 | 67165.1 |
| 136 | 2019-06-17 23:07:24 | unswept | 1 | 69583 | 4 | 1.090 | 63837.6 |
| 135 | 2019-02-21 05:20:27 | unswept | 1 | 69583 | 4 | 1.043 | 66714.3 |
| 134 | 2019-02-12 05:31:11 | unswept | 3 | 134027 | 104 | 6.313 | 21230.3 |
| 133 | 2019-02-11 20:04:35 | unswept | 1 | 69583 | 4 | 1.120 | 62127.7 |
| 132 | 2019-01-30 13:22:31 | unswept | 1 | 69583 | 4 | 1.013 | 68690.0 |
| 131 | 2019-01-14 21:35:08 | unswept | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 130 | 2018-12-15 13:18:55 | unswept | 1 | 69583 | 4 | 2.250 | 30925.8 |