History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clothing"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 270 | 2024-05-06 12:40:09 | clothing | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 269 | 2024-05-05 00:13:13 | clothing | 3 | 146162 | 383 | 9.890 | 14778.8 |
| 268 | 2024-05-03 17:23:12 | clothing | 2 | 121059 | 39 | 3.236 | 37410.1 |
| 267 | 2024-05-03 16:44:28 | clothing | 3 | 146162 | 383 | 8.596 | 17003.5 |
| 266 | 2024-05-03 09:50:59 | clothing | 2 | 121059 | 39 | 4.126 | 29340.5 |
| 265 | 2024-05-03 06:59:35 | clothing | 3 | 146162 | 383 | 6.766 | 21602.4 |
| 264 | 2024-05-02 13:13:51 | clothing | 3 | 146162 | 383 | 13.456 | 10862.2 |
| 263 | 2024-05-02 04:20:07 | clothing | 3 | 146162 | 383 | 7.533 | 19402.9 |
| 262 | 2024-05-02 04:20:03 | clothing | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 261 | 2024-05-02 04:19:55 | clothing | 2 | 121059 | 39 | 4.016 | 30144.2 |
| 260 | 2024-05-01 11:58:00 | clothing | 2 | 121059 | 39 | 3.796 | 31891.2 |
| 259 | 2024-04-29 16:22:17 | clothing | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 258 | 2024-04-10 23:43:32 | clothing | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 257 | 2024-03-31 03:33:53 | clothing | 2 | 121059 | 39 | 5.826 | 20779.1 |
| 256 | 2024-03-31 03:33:08 | clothing | 3 | 146162 | 383 | 9.046 | 16157.6 |
| 255 | 2024-03-30 10:25:21 | clothing | 3 | 146162 | 383 | 14.346 | 10188.3 |
| 254 | 2024-03-30 06:11:03 | clothing | 2 | 121059 | 39 | 5.406 | 22393.5 |
| 253 | 2024-03-30 05:46:01 | clothing | 3 | 146162 | 383 | 8.843 | 16528.6 |
| 252 | 2024-03-30 03:43:31 | clothing | 3 | 146162 | 383 | 25.390 | 5756.7 |
| 251 | 2024-03-30 03:43:31 | clothing | 2 | 121059 | 39 | 12.800 | 9457.7 |
| 250 | 2024-03-30 03:05:52 | clothing | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 249 | 2024-03-28 09:48:41 | clothing | 1 | 82945 | 3 | 3.390 | 24467.6 |
| 248 | 2024-01-18 08:06:33 | clothing | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 247 | 2024-01-01 15:14:12 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 246 | 2023-12-25 06:31:26 | clothing | 2 | 121059 | 39 | 3.343 | 36212.7 |
| 245 | 2023-11-27 15:17:31 | clothing | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 244 | 2023-11-25 23:21:06 | clothing | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 243 | 2023-11-13 17:57:35 | clothing | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 242 | 2023-11-11 02:27:19 | clothing | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 241 | 2023-11-10 18:28:57 | clothing | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 240 | 2023-10-24 21:58:33 | clothing | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 239 | 2023-10-17 12:24:55 | clothing | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 238 | 2023-10-06 23:54:31 | clothing | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 237 | 2023-10-06 23:50:38 | clothing | 2 | 121059 | 39 | 3.846 | 31476.6 |
| 236 | 2023-10-04 18:03:36 | clothing | 3 | 146162 | 383 | 15.983 | 9144.8 |
| 235 | 2023-09-30 20:53:33 | clothing | 3 | 146162 | 383 | 6.953 | 21021.4 |
| 234 | 2023-09-30 20:53:32 | clothing | 2 | 121059 | 39 | 3.643 | 33230.6 |
| 233 | 2023-09-28 00:10:21 | clothing | 2 | 121059 | 39 | 4.063 | 29795.5 |
| 232 | 2023-09-27 09:46:29 | clothing | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 231 | 2023-09-24 22:27:24 | clothing | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 230 | 2023-09-06 04:33:43 | clothing | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 229 | 2023-09-02 04:07:03 | clothing | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 228 | 2023-07-10 11:35:28 | clothing | 2 | 121059 | 39 | 3.216 | 37642.7 |
| 227 | 2023-06-03 09:39:10 | clothing | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 226 | 2023-05-23 17:05:40 | clothing | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 225 | 2023-04-01 15:52:49 | clothing | 2 | 121059 | 39 | 3.123 | 38763.7 |
| 224 | 2023-03-26 04:52:34 | clothing | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 223 | 2023-02-03 12:48:02 | clothing | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 222 | 2023-01-31 02:55:53 | clothing | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 221 | 2023-01-10 11:56:44 | clothing | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 220 | 2022-12-30 09:02:42 | clothing | 2 | 121059 | 39 | 3.656 | 33112.4 |
| 219 | 2022-11-07 00:17:34 | clothing | 3 | 146162 | 383 | 6.203 | 23563.1 |
| 218 | 2022-10-13 07:50:24 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 217 | 2022-10-12 11:48:12 | clothing | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 216 | 2022-09-01 05:32:32 | clothing | 2 | 121059 | 39 | 3.266 | 37066.4 |
| 215 | 2022-06-26 18:43:41 | clothing | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 214 | 2022-05-30 11:41:10 | clothing | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 213 | 2022-05-28 05:58:01 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 212 | 2022-05-12 05:52:06 | clothing | 3 | 146162 | 383 | 6.406 | 22816.4 |
| 211 | 2022-03-10 09:45:13 | clothing | 1 | 82945 | 3 | 1.733 | 47862.1 |
| 210 | 2022-03-07 01:11:15 | clothing | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 209 | 2022-02-22 10:18:19 | clothing | 1 | 82945 | 3 | 1.830 | 45325.1 |
| 208 | 2022-02-11 15:03:04 | clothing | 2 | 121059 | 39 | 3.233 | 37444.8 |
| 207 | 2022-01-31 19:58:36 | clothing | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 206 | 2021-11-24 20:38:36 | clothing | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 205 | 2021-11-23 10:01:23 | clothing | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 204 | 2021-11-22 18:16:07 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 203 | 2021-11-14 12:17:28 | clothing | 2 | 121059 | 39 | 3.720 | 32542.7 |
| 202 | 2021-11-12 11:39:56 | clothing | 2 | 121059 | 39 | 5.326 | 22729.8 |
| 201 | 2021-11-09 17:21:27 | clothing | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 200 | 2021-10-06 10:35:36 | clothing | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 199 | 2021-09-25 20:31:09 | clothing | 2 | 121059 | 39 | 3.810 | 31774.0 |
| 198 | 2021-09-02 00:45:08 | clothing | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 197 | 2021-08-30 18:48:46 | clothing | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 196 | 2021-08-20 09:31:22 | clothing | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 195 | 2021-05-29 00:55:08 | clothing | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 194 | 2021-05-26 10:11:12 | clothing | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 193 | 2021-05-19 17:22:50 | clothing | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 192 | 2021-05-03 09:50:08 | clothing | 1 | 82945 | 3 | 1.733 | 47862.1 |
| 191 | 2021-04-01 14:57:13 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 190 | 2021-02-16 20:25:42 | clothing | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 189 | 2021-02-10 05:39:47 | clothing | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 188 | 2021-01-16 17:04:53 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 187 | 2020-11-21 21:28:17 | clothing | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 186 | 2020-11-17 15:07:57 | clothing | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 185 | 2020-10-08 21:02:11 | clothing | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 184 | 2020-10-02 22:09:14 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 183 | 2020-09-26 07:33:13 | clothing | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 182 | 2020-08-29 22:44:49 | clothing | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 181 | 2020-08-14 11:14:49 | clothing | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 180 | 2020-08-02 19:46:06 | clothing | 1 | 82945 | 3 | 1.456 | 56967.7 |
| 179 | 2020-07-31 17:46:11 | clothing | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 178 | 2020-07-24 03:03:38 | clothing | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 177 | 2020-07-22 07:54:26 | clothing | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 176 | 2020-07-14 00:05:11 | clothing | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 175 | 2020-05-04 12:53:00 | clothing | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 174 | 2020-03-22 12:18:52 | clothing | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 173 | 2020-03-05 20:42:39 | clothing | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 172 | 2020-03-05 19:43:38 | clothing | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 171 | 2020-02-26 12:09:03 | clothing | 1 | 82945 | 3 | 1.500 | 55296.7 |