History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scotch"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 379 | 2024-04-23 12:53:56 | scotch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 378 | 2024-04-06 11:01:25 | scotch | 1 | 48755 | 5 | 0.983 | 49598.2 |
| 377 | 2024-04-05 03:04:38 | scotch | 1 | 48755 | 5 | 1.686 | 28917.6 |
| 376 | 2024-04-03 06:32:41 | scotch | 3 | 112716 | 320 | 19.610 | 5747.9 |
| 375 | 2024-04-03 06:15:35 | scotch | 3 | 112716 | 320 | 13.406 | 8407.9 |
| 374 | 2024-03-31 17:15:03 | scotch | 1 | 48755 | 5 | 2.110 | 23106.6 |
| 373 | 2024-03-30 22:27:09 | scotch | 2 | 82551 | 45 | 11.643 | 7090.2 |
| 372 | 2024-03-30 20:13:12 | scotch | 3 | 112716 | 320 | 7.986 | 14114.2 |
| 371 | 2024-03-30 09:29:20 | scotch | 2 | 82551 | 45 | 8.906 | 9269.1 |
| 370 | 2024-03-30 09:27:50 | scotch | 3 | 112716 | 320 | 17.873 | 6306.5 |
| 369 | 2024-03-30 08:43:52 | scotch | 1 | 48755 | 5 | 1.986 | 24549.3 |
| 368 | 2024-03-29 00:11:20 | scotch | 3 | 112716 | 320 | 11.686 | 9645.4 |
| 367 | 2024-03-29 00:11:16 | scotch | 2 | 82551 | 45 | 4.266 | 19350.9 |
| 366 | 2024-03-28 22:29:46 | scotch | 1 | 48755 | 5 | 2.360 | 20658.9 |
| 365 | 2024-03-28 22:29:32 | scotch | 3 | 112716 | 320 | 14.656 | 7690.8 |
| 364 | 2024-03-28 22:29:35 | scotch | 2 | 82551 | 45 | 8.580 | 9621.3 |
| 363 | 2024-03-07 07:33:26 | scotch | 1 | 48755 | 5 | 0.983 | 49598.2 |
| 362 | 2024-02-29 01:48:54 | scotch | 2 | 82551 | 45 | 2.640 | 31269.3 |
| 361 | 2024-02-27 16:29:59 | scotch | 2 | 82551 | 45 | 2.356 | 35038.6 |
| 360 | 2024-02-27 16:29:58 | scotch | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 359 | 2024-02-14 18:35:16 | scotch | 2 | 82551 | 45 | 5.763 | 14324.3 |
| 358 | 2024-02-14 16:52:58 | scotch | 3 | 112716 | 320 | 6.343 | 17770.1 |
| 357 | 2024-02-09 17:21:49 | scotch | 2 | 82551 | 45 | 2.936 | 28116.8 |
| 356 | 2024-02-09 17:17:16 | scotch | 3 | 112716 | 320 | 6.596 | 17088.5 |
| 355 | 2024-02-07 01:33:50 | scotch | 2 | 82551 | 45 | 2.513 | 32849.6 |
| 354 | 2024-02-07 01:31:50 | scotch | 3 | 112716 | 320 | 6.076 | 18551.0 |
| 353 | 2024-02-05 20:47:14 | scotch | 3 | 112716 | 320 | 5.360 | 21029.1 |
| 352 | 2024-02-05 04:53:41 | scotch | 3 | 112716 | 320 | 12.236 | 9211.8 |
| 351 | 2024-02-05 00:06:36 | scotch | 3 | 112716 | 320 | 12.766 | 8829.4 |
| 350 | 2024-01-18 12:45:44 | scotch | 2 | 82551 | 45 | 2.156 | 38289.0 |
| 349 | 2024-01-03 02:03:38 | scotch | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 348 | 2023-12-31 16:59:43 | scotch | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 347 | 2023-12-15 15:00:15 | scotch | 3 | 112716 | 320 | 5.123 | 22002.0 |
| 346 | 2023-12-10 19:49:24 | scotch | 3 | 112716 | 320 | 5.440 | 20719.9 |
| 345 | 2023-11-19 11:57:03 | scotch | 3 | 112716 | 320 | 5.610 | 20092.0 |
| 344 | 2023-11-19 11:57:05 | scotch | 2 | 82551 | 45 | 2.563 | 32208.7 |
| 343 | 2023-11-18 04:51:02 | scotch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 342 | 2023-11-17 11:36:18 | scotch | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 341 | 2023-11-11 13:40:25 | scotch | 3 | 112716 | 320 | 5.593 | 20153.0 |
| 340 | 2023-11-08 18:27:46 | scotch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 339 | 2023-11-08 02:17:58 | scotch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 338 | 2023-11-05 08:29:12 | scotch | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 337 | 2023-10-20 20:20:16 | scotch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 336 | 2023-10-20 16:48:30 | scotch | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 335 | 2023-10-17 22:26:00 | scotch | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 334 | 2023-10-07 11:25:14 | scotch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 333 | 2023-09-24 22:36:54 | scotch | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 332 | 2023-09-24 05:31:53 | scotch | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 331 | 2023-09-15 11:52:35 | scotch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 330 | 2023-08-16 06:44:08 | scotch | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 329 | 2023-08-13 23:26:20 | scotch | 3 | 112716 | 320 | 5.156 | 21861.1 |
| 328 | 2023-07-09 16:14:58 | scotch | 3 | 112716 | 320 | 5.313 | 21215.1 |
| 327 | 2023-05-31 13:45:12 | scotch | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 326 | 2023-05-28 07:41:12 | scotch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 325 | 2023-05-17 03:37:41 | scotch | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 324 | 2023-04-25 20:47:08 | scotch | 3 | 112716 | 320 | 4.640 | 24292.2 |
| 323 | 2023-03-13 06:21:40 | scotch | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 322 | 2023-03-04 03:56:18 | scotch | 3 | 112716 | 320 | 4.563 | 24702.2 |
| 321 | 2023-02-06 05:01:39 | scotch | 3 | 112716 | 320 | 4.640 | 24292.2 |
| 320 | 2023-01-31 21:12:00 | scotch | 3 | 112716 | 320 | 5.280 | 21347.7 |
| 319 | 2023-01-25 10:21:43 | scotch | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 318 | 2023-01-21 18:00:43 | scotch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 317 | 2022-11-25 08:58:09 | scotch | 1 | 48755 | 5 | 2.236 | 21804.6 |
| 316 | 2022-11-13 03:12:51 | scotch | 3 | 112716 | 320 | 4.610 | 24450.3 |
| 315 | 2022-09-15 21:30:14 | scotch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 314 | 2022-07-29 07:33:39 | scotch | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 313 | 2022-07-07 14:41:59 | scotch | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 312 | 2022-06-03 20:07:22 | scotch | 3 | 112716 | 320 | 4.593 | 24540.8 |
| 311 | 2022-05-16 03:07:37 | scotch | 3 | 112716 | 320 | 5.296 | 21283.2 |
| 310 | 2022-05-16 00:24:07 | scotch | 3 | 112716 | 320 | 5.220 | 21593.1 |
| 309 | 2022-05-03 10:14:56 | scotch | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 308 | 2022-05-02 23:15:28 | scotch | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 307 | 2022-05-01 09:23:35 | scotch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 306 | 2022-04-03 22:51:54 | scotch | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 305 | 2022-01-15 21:46:25 | scotch | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 304 | 2022-01-12 10:24:16 | scotch | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 303 | 2022-01-09 04:05:14 | scotch | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 302 | 2021-11-21 05:59:00 | scotch | 2 | 82551 | 45 | 2.220 | 37185.1 |
| 301 | 2021-11-20 06:38:25 | scotch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 300 | 2021-11-20 04:58:10 | scotch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 299 | 2021-11-11 17:39:29 | scotch | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 298 | 2021-11-09 15:57:10 | scotch | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 297 | 2021-09-26 13:07:55 | scotch | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 296 | 2021-09-23 00:34:31 | scotch | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 295 | 2021-09-03 11:42:06 | scotch | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 294 | 2021-06-24 17:22:01 | scotch | 3 | 112716 | 320 | 5.436 | 20735.1 |
| 293 | 2021-06-23 13:38:55 | scotch | 1 | 48755 | 5 | 1.860 | 26212.4 |
| 292 | 2021-06-17 22:14:07 | scotch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 291 | 2021-05-28 08:53:52 | scotch | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 290 | 2021-05-27 12:34:52 | scotch | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 289 | 2021-05-07 10:49:52 | scotch | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 288 | 2021-04-05 04:38:16 | scotch | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 287 | 2021-03-24 05:30:40 | scotch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 286 | 2021-03-21 10:30:49 | scotch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 285 | 2021-01-26 07:16:36 | scotch | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 284 | 2021-01-06 20:11:24 | scotch | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 283 | 2020-12-09 00:38:09 | scotch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 282 | 2020-12-07 10:09:25 | scotch | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 281 | 2020-11-11 20:39:36 | scotch | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 280 | 2020-10-27 06:58:50 | scotch | 1 | 48755 | 5 | 0.843 | 57835.1 |