History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nasties"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 522 | 2024-04-27 05:16:44 | nasties | 1 | 69583 | 4 | 4.780 | 14557.1 |
| 521 | 2024-04-04 20:07:11 | nasties | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 520 | 2024-04-02 13:49:21 | nasties | 1 | 69583 | 4 | 2.580 | 26970.2 |
| 519 | 2024-02-28 10:26:24 | nasties | 1 | 69583 | 4 | 1.720 | 40455.2 |
| 518 | 2024-01-20 09:28:36 | nasties | 3 | 134027 | 820 | 6.983 | 19193.3 |
| 517 | 2024-01-04 02:14:34 | nasties | 3 | 134027 | 820 | 7.453 | 17983.0 |
| 516 | 2023-12-24 15:49:22 | nasties | 1 | 69583 | 4 | 1.096 | 63488.1 |
| 515 | 2023-12-20 11:15:39 | nasties | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 514 | 2023-12-09 11:43:34 | nasties | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 513 | 2023-11-29 11:24:57 | nasties | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 512 | 2023-11-23 14:06:32 | nasties | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 511 | 2023-11-19 12:04:31 | nasties | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 510 | 2023-11-12 16:36:07 | nasties | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 509 | 2023-11-10 19:33:06 | nasties | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 508 | 2023-10-31 07:30:27 | nasties | 3 | 134027 | 820 | 6.890 | 19452.4 |
| 507 | 2023-10-25 11:51:56 | nasties | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 506 | 2023-09-29 11:06:01 | nasties | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 505 | 2023-08-20 05:13:48 | nasties | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 504 | 2023-08-16 20:33:50 | nasties | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 503 | 2023-08-08 08:10:38 | nasties | 3 | 134027 | 820 | 5.970 | 22450.1 |
| 502 | 2023-05-06 06:45:59 | nasties | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 501 | 2023-04-21 16:40:24 | nasties | 3 | 134027 | 820 | 5.796 | 23124.1 |
| 500 | 2023-01-27 10:23:32 | nasties | 3 | 134027 | 820 | 7.236 | 18522.2 |
| 499 | 2023-01-26 23:38:31 | nasties | 3 | 134027 | 820 | 5.766 | 23244.4 |
| 498 | 2023-01-23 23:02:22 | nasties | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 497 | 2022-12-12 21:02:12 | nasties | 3 | 134027 | 820 | 7.906 | 16952.6 |
| 496 | 2022-12-10 10:34:23 | nasties | 3 | 134027 | 820 | 7.173 | 18684.9 |
| 495 | 2022-11-25 01:17:37 | nasties | 3 | 134027 | 820 | 5.953 | 22514.2 |
| 494 | 2022-11-22 02:19:05 | nasties | 3 | 134027 | 820 | 6.940 | 19312.2 |
| 493 | 2022-11-17 07:02:31 | nasties | 3 | 134027 | 820 | 5.893 | 22743.4 |
| 492 | 2022-11-09 06:34:45 | nasties | 3 | 134027 | 820 | 5.750 | 23309.0 |
| 491 | 2022-10-26 10:23:19 | nasties | 3 | 134027 | 820 | 6.546 | 20474.6 |
| 490 | 2022-10-09 14:33:30 | nasties | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 489 | 2022-09-17 06:33:28 | nasties | 3 | 134027 | 820 | 5.843 | 22938.0 |
| 488 | 2022-09-15 01:42:48 | nasties | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 487 | 2022-09-12 16:47:27 | nasties | 3 | 134027 | 820 | 5.970 | 22450.1 |
| 486 | 2022-09-12 02:04:29 | nasties | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 485 | 2022-08-25 19:06:43 | nasties | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 484 | 2022-08-23 10:23:41 | nasties | 3 | 134027 | 820 | 7.376 | 18170.7 |
| 483 | 2022-08-21 03:10:38 | nasties | 3 | 134027 | 820 | 6.016 | 22278.4 |
| 482 | 2022-08-19 05:50:03 | nasties | 3 | 134027 | 820 | 5.876 | 22809.2 |
| 481 | 2022-07-25 14:55:45 | nasties | 3 | 134027 | 820 | 6.093 | 21996.9 |
| 480 | 2022-07-11 14:04:00 | nasties | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 479 | 2022-07-06 04:45:15 | nasties | 3 | 134027 | 820 | 7.296 | 18369.9 |
| 478 | 2022-07-03 09:46:09 | nasties | 3 | 134027 | 820 | 6.046 | 22167.9 |
| 477 | 2022-06-28 16:31:59 | nasties | 3 | 134027 | 820 | 5.970 | 22450.1 |
| 476 | 2022-06-26 18:49:56 | nasties | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 475 | 2022-06-26 06:06:06 | nasties | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 474 | 2022-06-25 02:54:24 | nasties | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 473 | 2022-05-13 17:32:32 | nasties | 3 | 134027 | 820 | 9.110 | 14712.1 |
| 472 | 2022-04-25 08:50:21 | nasties | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 471 | 2022-03-13 19:49:12 | nasties | 1 | 69583 | 4 | 2.466 | 28217.0 |
| 470 | 2022-01-18 20:15:00 | nasties | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 469 | 2021-12-03 12:24:50 | nasties | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 468 | 2021-11-24 16:50:01 | nasties | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 467 | 2021-11-23 14:06:38 | nasties | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 466 | 2021-11-22 17:12:43 | nasties | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 465 | 2021-11-19 21:07:00 | nasties | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 464 | 2021-11-14 12:55:50 | nasties | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 463 | 2021-11-12 12:00:15 | nasties | 1 | 69583 | 4 | 2.563 | 27149.0 |
| 462 | 2021-09-28 00:54:53 | nasties | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 461 | 2021-09-26 01:59:34 | nasties | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 460 | 2021-09-25 21:17:03 | nasties | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 459 | 2021-09-25 16:31:52 | nasties | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 458 | 2021-09-19 20:11:52 | nasties | 1 | 69583 | 4 | 1.410 | 49349.6 |
| 457 | 2021-09-06 13:01:55 | nasties | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 456 | 2021-09-02 17:11:49 | nasties | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 455 | 2021-06-22 20:39:25 | nasties | 2 | 107671 | 67 | 3.420 | 31482.7 |
| 454 | 2021-05-31 06:40:33 | nasties | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 453 | 2021-05-29 17:39:48 | nasties | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 452 | 2021-05-06 01:25:09 | nasties | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 451 | 2021-04-04 04:25:14 | nasties | 1 | 69583 | 4 | 2.126 | 32729.5 |
| 450 | 2021-04-03 14:46:32 | nasties | 2 | 107671 | 67 | 3.266 | 32967.2 |
| 449 | 2021-02-26 23:35:11 | nasties | 1 | 69583 | 4 | 2.486 | 27989.9 |
| 448 | 2021-02-16 19:07:25 | nasties | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 447 | 2021-02-12 00:22:56 | nasties | 2 | 107671 | 67 | 3.233 | 33303.7 |
| 446 | 2021-01-18 16:35:29 | nasties | 2 | 107671 | 67 | 2.876 | 37437.8 |
| 445 | 2021-01-18 13:47:00 | nasties | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 444 | 2020-11-23 12:15:29 | nasties | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 443 | 2020-11-22 06:47:03 | nasties | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 442 | 2020-10-30 03:54:20 | nasties | 2 | 107671 | 67 | 3.310 | 32529.0 |
| 441 | 2020-10-22 17:06:32 | nasties | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 440 | 2020-10-20 04:01:45 | nasties | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 439 | 2020-10-03 20:10:48 | nasties | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 438 | 2020-08-29 10:28:24 | nasties | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 437 | 2020-08-25 23:36:34 | nasties | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 436 | 2020-08-24 06:10:10 | nasties | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 435 | 2020-08-18 09:46:54 | nasties | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 434 | 2020-08-14 22:34:54 | nasties | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 433 | 2020-07-24 04:20:42 | nasties | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 432 | 2020-06-02 04:49:13 | nasties | 1 | 69583 | 4 | 2.220 | 31343.7 |
| 431 | 2020-06-01 05:23:22 | nasties | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 430 | 2020-05-20 17:11:30 | nasties | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 429 | 2020-05-16 04:28:34 | nasties | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 428 | 2020-05-14 06:36:24 | nasties | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 427 | 2020-05-13 17:24:58 | nasties | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 426 | 2020-05-13 07:54:26 | nasties | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 425 | 2020-05-12 08:38:13 | nasties | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 424 | 2020-05-11 09:22:09 | nasties | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 423 | 2020-05-10 08:37:12 | nasties | 1 | 69583 | 4 | 1.140 | 61037.7 |