History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prepared"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 299 | 2024-03-29 22:15:23 | prepared | 1 | 82945 | 5 | 3.436 | 24140.0 |
| 298 | 2024-03-27 20:17:39 | prepared | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 297 | 2024-03-01 15:34:38 | prepared | 2 | 121059 | 34 | 4.313 | 28068.4 |
| 296 | 2024-02-28 23:17:53 | prepared | 2 | 121059 | 34 | 3.983 | 30393.9 |
| 295 | 2024-02-28 22:14:38 | prepared | 3 | 146162 | 293 | 7.923 | 18447.8 |
| 294 | 2024-02-28 10:25:28 | prepared | 1 | 82945 | 5 | 7.140 | 11616.9 |
| 293 | 2024-02-28 08:11:25 | prepared | 1 | 82945 | 5 | 3.016 | 27501.7 |
| 292 | 2024-02-27 05:13:20 | prepared | 2 | 121059 | 34 | 4.016 | 30144.2 |
| 291 | 2024-02-27 05:06:24 | prepared | 3 | 146162 | 293 | 9.156 | 15963.5 |
| 290 | 2024-02-26 19:55:04 | prepared | 3 | 146162 | 293 | 10.406 | 14045.9 |
| 289 | 2024-02-26 17:06:51 | prepared | 3 | 146162 | 293 | 8.283 | 17646.0 |
| 288 | 2023-12-20 06:48:01 | prepared | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 287 | 2023-12-09 13:32:55 | prepared | 1 | 82945 | 5 | 1.673 | 49578.6 |
| 286 | 2023-12-08 22:35:38 | prepared | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 285 | 2023-12-04 11:55:14 | prepared | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 284 | 2023-12-01 02:30:01 | prepared | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 283 | 2023-11-22 11:42:54 | prepared | 1 | 82945 | 5 | 1.450 | 57203.4 |
| 282 | 2023-11-21 00:23:20 | prepared | 3 | 146162 | 293 | 6.453 | 22650.2 |
| 281 | 2023-11-03 18:30:23 | prepared | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 280 | 2023-10-14 09:35:02 | prepared | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 279 | 2023-10-07 13:45:21 | prepared | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 278 | 2023-10-07 03:22:52 | prepared | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 277 | 2023-09-24 07:59:49 | prepared | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 276 | 2023-09-14 19:14:29 | prepared | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 275 | 2023-08-21 17:28:16 | prepared | 3 | 146162 | 293 | 6.500 | 22486.5 |
| 274 | 2023-08-13 14:32:14 | prepared | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 273 | 2023-08-03 22:11:43 | prepared | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 272 | 2023-05-06 18:38:38 | prepared | 3 | 146162 | 293 | 6.376 | 22923.8 |
| 271 | 2023-05-02 03:54:16 | prepared | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 270 | 2023-04-25 04:44:32 | prepared | 1 | 82945 | 5 | 2.673 | 31030.7 |
| 269 | 2023-02-24 09:54:46 | prepared | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 268 | 2023-02-11 03:35:12 | prepared | 3 | 146162 | 293 | 6.250 | 23385.9 |
| 267 | 2023-01-01 14:34:06 | prepared | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 266 | 2022-12-21 09:25:38 | prepared | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 265 | 2022-11-23 09:55:09 | prepared | 3 | 146162 | 293 | 7.033 | 20782.3 |
| 264 | 2022-09-03 22:09:47 | prepared | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 263 | 2022-09-03 06:33:33 | prepared | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 262 | 2022-05-05 04:56:45 | prepared | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 261 | 2022-04-22 23:13:29 | prepared | 3 | 146162 | 293 | 8.983 | 16271.0 |
| 260 | 2022-04-16 12:33:04 | prepared | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 259 | 2022-01-25 03:49:52 | prepared | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 258 | 2022-01-20 23:44:31 | prepared | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 257 | 2022-01-17 17:17:39 | prepared | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 256 | 2022-01-14 10:27:15 | prepared | 1 | 82945 | 5 | 3.140 | 26415.6 |
| 255 | 2021-12-28 06:57:49 | prepared | 3 | 146162 | 293 | 6.500 | 22486.5 |
| 254 | 2021-10-24 20:28:33 | prepared | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 253 | 2021-10-11 08:29:06 | prepared | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 252 | 2021-10-08 10:30:43 | prepared | 3 | 146162 | 293 | 7.890 | 18525.0 |
| 251 | 2021-09-27 20:49:13 | prepared | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 250 | 2021-07-09 19:44:03 | prepared | 1 | 82945 | 5 | 1.503 | 55186.3 |
| 249 | 2021-06-06 10:41:13 | prepared | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 248 | 2021-05-12 10:59:03 | prepared | 1 | 82945 | 5 | 1.403 | 59119.7 |
| 247 | 2021-04-11 05:32:02 | prepared | 1 | 82945 | 5 | 1.670 | 49667.7 |
| 246 | 2021-04-05 23:13:00 | prepared | 1 | 82945 | 5 | 3.076 | 26965.2 |
| 245 | 2021-04-01 18:53:58 | prepared | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 244 | 2021-02-23 04:26:14 | prepared | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 243 | 2020-12-20 21:14:01 | prepared | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 242 | 2020-11-30 06:42:32 | prepared | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 241 | 2020-10-29 04:50:08 | prepared | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 240 | 2020-10-22 04:36:26 | prepared | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 239 | 2020-09-20 22:07:47 | prepared | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 238 | 2020-09-16 22:31:55 | prepared | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 237 | 2020-08-13 06:02:36 | prepared | 1 | 82945 | 5 | 1.410 | 58826.2 |
| 236 | 2020-06-04 08:54:47 | prepared | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 235 | 2020-03-29 05:37:45 | prepared | 1 | 82945 | 5 | 2.483 | 33405.2 |
| 234 | 2020-03-28 16:32:38 | prepared | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 233 | 2020-03-25 03:06:25 | prepared | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 232 | 2020-03-22 15:36:05 | prepared | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 231 | 2020-03-20 08:35:15 | prepared | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 230 | 2020-03-02 20:27:58 | prepared | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 229 | 2020-03-02 11:00:20 | prepared | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 228 | 2020-02-28 22:30:26 | prepared | 1 | 82945 | 5 | 2.126 | 39014.6 |
| 227 | 2020-02-25 12:05:35 | prepared | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 226 | 2020-02-23 15:34:31 | prepared | 1 | 82945 | 5 | 1.780 | 46598.3 |
| 225 | 2020-02-22 05:07:08 | prepared | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 224 | 2020-02-10 18:21:32 | prepared | 1 | 82945 | 5 | 1.593 | 52068.4 |
| 223 | 2020-02-10 03:54:32 | prepared | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 222 | 2020-02-04 20:02:01 | prepared | 1 | 82945 | 5 | 4.560 | 18189.7 |
| 221 | 2020-01-31 12:20:25 | prepared | 1 | 82945 | 5 | 1.656 | 50087.6 |
| 220 | 2020-01-31 11:20:55 | prepared | 1 | 82945 | 5 | 1.673 | 49578.6 |
| 219 | 2020-01-27 21:55:55 | prepared | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 218 | 2020-01-20 16:26:44 | prepared | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 217 | 2020-01-18 06:28:09 | prepared | 1 | 82945 | 5 | 1.580 | 52496.8 |
| 216 | 2020-01-13 15:20:39 | prepared | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 215 | 2020-01-06 21:18:08 | prepared | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 214 | 2020-01-01 17:28:41 | prepared | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 213 | 2019-12-28 14:00:26 | prepared | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 212 | 2019-12-28 09:47:53 | prepared | 1 | 82945 | 5 | 1.550 | 53512.9 |
| 211 | 2019-11-26 23:01:05 | prepared | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 210 | 2019-08-25 05:47:58 | prepared | 1 | 82945 | 5 | 1.660 | 49966.9 |
| 209 | 2019-06-27 07:42:46 | prepared | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 208 | 2019-05-25 13:23:59 | prepared | 1 | 82945 | 5 | 1.583 | 52397.3 |
| 207 | 2019-03-16 08:36:02 | prepared | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 206 | 2019-03-10 00:22:58 | prepared | 1 | 82945 | 5 | 1.476 | 56195.8 |
| 205 | 2019-02-28 17:19:56 | prepared | 1 | 82945 | 5 | 1.473 | 56310.3 |
| 204 | 2019-02-19 10:07:45 | prepared | 1 | 82945 | 5 | 1.466 | 56579.1 |
| 203 | 2019-02-11 17:42:01 | prepared | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 202 | 2019-02-04 17:56:08 | prepared | 1 | 82945 | 5 | 1.383 | 59974.7 |
| 201 | 2019-01-25 05:00:11 | prepared | 1 | 82945 | 5 | 1.380 | 60105.1 |
| 200 | 2019-01-23 10:12:28 | prepared | 1 | 82945 | 5 | 1.540 | 53860.4 |