History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cotton"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 438 | 2024-04-23 13:58:13 | cotton | 1 | 48755 | 3 | 1.593 | 30605.8 |
| 437 | 2024-04-06 12:40:16 | cotton | 1 | 48755 | 3 | 2.580 | 18897.3 |
| 436 | 2024-03-31 16:18:53 | cotton | 1 | 48755 | 3 | 1.173 | 41564.4 |
| 435 | 2024-02-07 11:24:44 | cotton | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 434 | 2023-12-16 15:32:38 | cotton | 3 | 112716 | 497 | 5.593 | 20153.0 |
| 433 | 2023-12-16 15:32:39 | cotton | 2 | 82551 | 55 | 2.593 | 31836.1 |
| 432 | 2023-11-28 23:22:10 | cotton | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 431 | 2023-11-20 09:03:45 | cotton | 3 | 112716 | 497 | 5.670 | 19879.4 |
| 430 | 2023-11-20 09:03:48 | cotton | 2 | 82551 | 55 | 2.530 | 32628.9 |
| 429 | 2023-11-11 23:20:54 | cotton | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 428 | 2023-11-10 16:45:13 | cotton | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 427 | 2023-11-09 00:26:54 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 426 | 2023-11-08 15:17:15 | cotton | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 425 | 2023-10-23 00:46:42 | cotton | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 424 | 2023-10-20 04:05:13 | cotton | 3 | 112716 | 497 | 6.876 | 16392.7 |
| 423 | 2023-10-19 18:04:50 | cotton | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 422 | 2023-10-17 12:14:22 | cotton | 3 | 112716 | 497 | 13.016 | 8659.8 |
| 421 | 2023-10-14 12:54:49 | cotton | 3 | 112716 | 497 | 9.063 | 12436.9 |
| 420 | 2023-10-14 12:54:44 | cotton | 2 | 82551 | 55 | 2.156 | 38289.0 |
| 419 | 2023-10-10 19:40:38 | cotton | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 418 | 2023-09-23 06:52:01 | cotton | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 417 | 2023-09-13 05:57:30 | cotton | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 416 | 2023-09-11 03:57:13 | cotton | 1 | 48755 | 3 | 1.626 | 29984.6 |
| 415 | 2023-07-29 02:11:03 | cotton | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 414 | 2023-06-29 00:44:56 | cotton | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 413 | 2023-04-20 17:56:59 | cotton | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 412 | 2023-04-07 16:39:10 | cotton | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 411 | 2023-01-08 08:49:02 | cotton | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 410 | 2022-09-24 13:20:45 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 409 | 2022-09-20 23:04:25 | cotton | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 408 | 2022-08-31 22:49:53 | cotton | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 407 | 2022-05-31 21:11:32 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 406 | 2022-05-26 02:31:04 | cotton | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 405 | 2022-05-23 20:59:12 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 404 | 2022-02-13 20:47:44 | cotton | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 403 | 2022-02-05 06:27:58 | cotton | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 402 | 2022-02-03 01:44:11 | cotton | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 401 | 2021-12-09 06:00:12 | cotton | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 400 | 2021-12-04 05:20:43 | cotton | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 399 | 2021-11-24 22:23:23 | cotton | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 398 | 2021-11-06 00:55:37 | cotton | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 397 | 2021-10-06 12:42:37 | cotton | 1 | 48755 | 3 | 1.016 | 47987.2 |
| 396 | 2021-10-04 10:07:59 | cotton | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 395 | 2021-09-22 15:32:57 | cotton | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 394 | 2021-09-21 23:21:20 | cotton | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 393 | 2021-09-21 18:28:34 | cotton | 1 | 48755 | 3 | 1.733 | 28133.3 |
| 392 | 2021-09-15 06:21:11 | cotton | 1 | 48755 | 3 | 0.800 | 60943.8 |
| 391 | 2021-09-15 03:17:15 | cotton | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 390 | 2021-08-06 08:01:37 | cotton | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 389 | 2021-08-02 20:04:28 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 388 | 2021-05-29 10:49:28 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 387 | 2021-05-03 22:21:53 | cotton | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 386 | 2021-04-24 21:06:59 | cotton | 1 | 48755 | 3 | 1.090 | 44729.4 |
| 385 | 2021-02-24 15:23:40 | cotton | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 384 | 2021-02-10 16:15:03 | cotton | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 383 | 2021-01-23 23:30:54 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 382 | 2021-01-17 03:11:06 | cotton | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 381 | 2020-12-18 04:58:07 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 380 | 2020-11-22 19:33:19 | cotton | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 379 | 2020-10-29 04:13:25 | cotton | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 378 | 2020-10-22 21:15:54 | cotton | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 377 | 2020-10-22 06:03:01 | cotton | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 376 | 2020-10-18 18:36:01 | cotton | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 375 | 2020-10-08 18:21:28 | cotton | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 374 | 2020-09-12 03:10:28 | cotton | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 373 | 2020-08-03 23:26:54 | cotton | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 372 | 2020-07-28 04:20:54 | cotton | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 371 | 2020-07-20 02:32:17 | cotton | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 370 | 2020-07-10 17:35:12 | cotton | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 369 | 2020-04-30 05:56:58 | cotton | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 368 | 2020-04-18 03:40:38 | cotton | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 367 | 2020-03-27 07:28:58 | cotton | 1 | 48755 | 3 | 1.783 | 27344.4 |
| 366 | 2020-03-24 13:38:57 | cotton | 1 | 48755 | 3 | 1.640 | 29728.7 |
| 365 | 2020-03-24 13:01:31 | cotton | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 364 | 2020-03-23 05:35:19 | cotton | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 363 | 2020-03-22 00:43:56 | cotton | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 362 | 2020-03-18 18:10:07 | cotton | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 361 | 2020-02-26 00:29:24 | cotton | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 360 | 2020-02-25 21:55:19 | cotton | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 359 | 2020-02-24 20:23:59 | cotton | 1 | 48755 | 3 | 1.110 | 43923.4 |
| 358 | 2020-02-22 21:28:31 | cotton | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 357 | 2020-02-19 08:19:54 | cotton | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 356 | 2020-02-17 11:57:48 | cotton | 1 | 48755 | 3 | 1.670 | 29194.6 |
| 355 | 2020-02-03 02:18:21 | cotton | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 354 | 2020-02-02 21:24:40 | cotton | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 353 | 2020-02-02 00:45:18 | cotton | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 352 | 2020-01-30 11:16:33 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 351 | 2020-01-25 19:50:46 | cotton | 1 | 48755 | 3 | 1.013 | 48129.3 |
| 350 | 2020-01-22 16:07:42 | cotton | 1 | 48755 | 3 | 0.966 | 50471.0 |
| 349 | 2020-01-14 19:34:18 | cotton | 1 | 48755 | 3 | 1.016 | 47987.2 |
| 348 | 2020-01-13 18:05:17 | cotton | 1 | 48755 | 3 | 1.143 | 42655.3 |
| 347 | 2020-01-12 02:34:30 | cotton | 1 | 48755 | 3 | 1.953 | 24964.2 |
| 346 | 2020-01-11 03:55:39 | cotton | 1 | 48755 | 3 | 1.843 | 26454.2 |
| 345 | 2020-01-06 19:09:34 | cotton | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 344 | 2019-12-26 20:30:10 | cotton | 1 | 48755 | 3 | 1.796 | 27146.4 |
| 343 | 2019-12-26 08:45:09 | cotton | 1 | 48755 | 3 | 0.986 | 49447.3 |
| 342 | 2019-12-25 13:43:50 | cotton | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 341 | 2019-12-25 09:38:50 | cotton | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 340 | 2019-12-25 08:57:17 | cotton | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 339 | 2019-12-03 15:59:58 | cotton | 3 | 112716 | 497 | 4.783 | 23566.0 |