History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pennines"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 535 | 2025-12-08 12:41:18 | pennines | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 534 | 2025-11-19 08:03:32 | pennines | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 533 | 2025-10-20 19:55:24 | pennines | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 532 | 2025-10-09 14:26:49 | pennines | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 531 | 2025-10-05 15:05:49 | pennines | 1 | 82945 | 3 | 3.033 | 27347.5 |
| 530 | 2025-09-22 20:26:26 | pennines | 2 | 121059 | 31 | 3.736 | 32403.4 |
| 529 | 2025-09-10 01:34:37 | pennines | 3 | 146162 | 317 | 6.966 | 20982.2 |
| 528 | 2025-09-08 02:00:43 | pennines | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 527 | 2025-09-02 08:31:59 | pennines | 2 | 121059 | 31 | 3.716 | 32577.8 |
| 526 | 2025-08-28 13:35:43 | pennines | 3 | 146162 | 317 | 7.626 | 19166.3 |
| 525 | 2025-08-27 19:55:02 | pennines | 2 | 121059 | 31 | 3.623 | 33414.0 |
| 524 | 2025-08-25 23:45:59 | pennines | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 523 | 2025-08-25 18:12:28 | pennines | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 522 | 2025-08-18 03:36:01 | pennines | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 521 | 2025-08-17 20:48:29 | pennines | 3 | 146162 | 317 | 20.126 | 7262.3 |
| 520 | 2025-08-05 05:23:33 | pennines | 1 | 82945 | 3 | 6.733 | 12319.2 |
| 519 | 2025-08-01 06:11:40 | pennines | 1 | 82945 | 3 | 6.923 | 11981.1 |
| 518 | 2025-07-28 16:02:26 | pennines | 2 | 121059 | 31 | 8.170 | 14817.5 |
| 517 | 2025-07-25 03:31:04 | pennines | 1 | 82945 | 3 | 3.513 | 23610.9 |
| 516 | 2025-07-24 23:30:13 | pennines | 1 | 82945 | 3 | 5.890 | 14082.3 |
| 515 | 2025-07-23 17:15:23 | pennines | 1 | 82945 | 3 | 7.690 | 10786.1 |
| 514 | 2025-07-18 02:44:10 | pennines | 1 | 82945 | 3 | 6.596 | 12575.0 |
| 513 | 2025-07-17 16:06:37 | pennines | 1 | 82945 | 3 | 8.796 | 9429.9 |
| 512 | 2025-07-10 21:37:29 | pennines | 1 | 82945 | 3 | 5.686 | 14587.6 |
| 511 | 2025-07-10 16:43:44 | pennines | 1 | 82945 | 3 | 7.203 | 11515.3 |
| 510 | 2025-07-10 07:54:48 | pennines | 2 | 121059 | 31 | 28.516 | 4245.3 |
| 509 | 2025-07-08 20:10:26 | pennines | 1 | 82945 | 3 | 1.560 | 53169.9 |
| 508 | 2025-07-07 07:04:38 | pennines | 2 | 121059 | 31 | 12.673 | 9552.5 |
| 507 | 2025-07-04 04:38:36 | pennines | 1 | 82945 | 3 | 5.593 | 14830.1 |
| 506 | 2025-07-01 23:36:05 | pennines | 2 | 121059 | 31 | 22.813 | 5306.6 |
| 505 | 2025-07-01 11:24:01 | pennines | 1 | 82945 | 3 | 1.906 | 43517.8 |
| 504 | 2025-07-01 07:35:27 | pennines | 2 | 121059 | 31 | 3.546 | 34139.6 |
| 503 | 2025-06-20 22:56:00 | pennines | 1 | 82945 | 3 | 3.720 | 22297.0 |
| 502 | 2025-06-20 10:12:01 | pennines | 1 | 82945 | 3 | 9.483 | 8746.7 |
| 501 | 2025-06-19 14:32:22 | pennines | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 500 | 2025-06-13 19:17:38 | pennines | 3 | 146162 | 317 | 7.940 | 18408.3 |
| 499 | 2025-06-12 00:56:19 | pennines | 1 | 82945 | 3 | 5.610 | 14785.2 |
| 498 | 2025-06-10 15:50:54 | pennines | 3 | 146162 | 317 | 46.376 | 3151.7 |
| 497 | 2025-06-10 13:59:52 | pennines | 1 | 82945 | 3 | 7.513 | 11040.2 |
| 496 | 2025-06-10 00:59:43 | pennines | 3 | 146162 | 317 | 24.873 | 5876.3 |
| 495 | 2025-06-09 21:05:54 | pennines | 3 | 146162 | 317 | 48.286 | 3027.0 |
| 494 | 2025-06-08 09:36:00 | pennines | 3 | 146162 | 317 | 25.516 | 5728.2 |
| 493 | 2025-06-08 03:43:55 | pennines | 3 | 146162 | 317 | 26.453 | 5525.3 |
| 492 | 2025-06-07 08:36:31 | pennines | 3 | 146162 | 317 | 8.376 | 17450.1 |
| 491 | 2025-06-04 04:12:09 | pennines | 1 | 82945 | 3 | 7.610 | 10899.5 |
| 490 | 2025-05-31 01:04:05 | pennines | 1 | 82945 | 3 | 7.420 | 11178.6 |
| 489 | 2025-05-29 00:03:25 | pennines | 1 | 82945 | 3 | 6.970 | 11900.3 |
| 488 | 2025-05-28 20:26:47 | pennines | 1 | 82945 | 3 | 7.033 | 11793.7 |
| 487 | 2025-05-27 04:50:27 | pennines | 1 | 82945 | 3 | 8.126 | 10207.4 |
| 486 | 2025-05-24 21:05:40 | pennines | 1 | 82945 | 3 | 6.953 | 11929.4 |
| 485 | 2025-05-23 21:20:10 | pennines | 2 | 121059 | 31 | 28.233 | 4287.9 |
| 484 | 2025-05-21 22:02:15 | pennines | 1 | 82945 | 3 | 7.373 | 11249.8 |
| 483 | 2025-05-20 12:00:22 | pennines | 1 | 82945 | 3 | 6.906 | 12010.6 |
| 482 | 2025-05-12 14:31:50 | pennines | 1 | 82945 | 3 | 10.986 | 7550.1 |
| 481 | 2025-05-10 15:26:49 | pennines | 1 | 82945 | 3 | 10.546 | 7865.1 |
| 480 | 2025-05-02 04:22:38 | pennines | 1 | 82945 | 3 | 9.986 | 8306.1 |
| 479 | 2025-05-01 12:35:39 | pennines | 1 | 82945 | 3 | 4.190 | 19795.9 |
| 478 | 2025-05-01 00:26:35 | pennines | 1 | 82945 | 3 | 5.830 | 14227.3 |
| 477 | 2025-04-26 04:18:31 | pennines | 1 | 82945 | 3 | 5.923 | 14003.9 |
| 476 | 2025-04-22 11:15:00 | pennines | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 475 | 2025-04-20 21:28:32 | pennines | 1 | 82945 | 3 | 5.983 | 13863.4 |
| 474 | 2025-04-17 15:17:25 | pennines | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 473 | 2025-04-08 13:19:24 | pennines | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 472 | 2025-04-08 07:30:38 | pennines | 2 | 121059 | 31 | 18.906 | 6403.2 |
| 471 | 2025-04-01 19:20:21 | pennines | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 470 | 2025-03-31 05:40:05 | pennines | 1 | 82945 | 3 | 3.470 | 23903.5 |
| 469 | 2025-03-21 20:42:11 | pennines | 2 | 121059 | 31 | 5.190 | 23325.4 |
| 468 | 2025-03-21 19:55:40 | pennines | 3 | 146162 | 317 | 29.246 | 4997.7 |
| 467 | 2025-03-20 05:28:42 | pennines | 1 | 82945 | 3 | 8.766 | 9462.1 |
| 466 | 2025-03-18 21:50:54 | pennines | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 465 | 2025-03-12 10:27:37 | pennines | 2 | 121059 | 31 | 18.390 | 6582.9 |
| 464 | 2025-03-11 14:58:21 | pennines | 2 | 121059 | 31 | 9.326 | 12980.8 |
| 463 | 2025-03-10 19:03:03 | pennines | 3 | 146162 | 317 | 29.610 | 4936.2 |
| 462 | 2025-03-10 01:47:50 | pennines | 3 | 146162 | 317 | 6.860 | 21306.4 |
| 461 | 2025-03-10 01:37:24 | pennines | 2 | 121059 | 31 | 7.766 | 15588.3 |
| 460 | 2025-03-07 23:41:35 | pennines | 1 | 82945 | 3 | 10.643 | 7793.4 |
| 459 | 2025-03-04 16:48:53 | pennines | 3 | 146162 | 317 | 54.550 | 2679.4 |
| 458 | 2025-03-03 05:34:21 | pennines | 3 | 146162 | 317 | 23.620 | 6188.1 |
| 457 | 2025-03-03 04:29:53 | pennines | 3 | 146162 | 317 | 53.753 | 2719.1 |
| 456 | 2025-03-02 17:46:31 | pennines | 3 | 146162 | 317 | 38.440 | 3802.3 |
| 455 | 2025-03-02 17:46:23 | pennines | 2 | 121059 | 31 | 28.393 | 4263.7 |
| 454 | 2025-03-02 17:45:58 | pennines | 1 | 82945 | 3 | 5.500 | 15080.9 |
| 453 | 2025-02-24 18:24:10 | pennines | 1 | 82945 | 3 | 3.703 | 22399.4 |
| 452 | 2025-02-16 07:45:45 | pennines | 3 | 146162 | 317 | 35.470 | 4120.7 |
| 451 | 2025-02-13 11:43:29 | pennines | 2 | 121059 | 31 | 14.890 | 8130.2 |
| 450 | 2025-02-13 11:43:22 | pennines | 1 | 82945 | 3 | 3.076 | 26965.2 |
| 449 | 2025-02-05 23:07:26 | pennines | 1 | 82945 | 3 | 1.610 | 51518.6 |
| 448 | 2025-01-27 13:17:56 | pennines | 3 | 146162 | 317 | 30.406 | 4807.0 |
| 447 | 2025-01-27 09:07:51 | pennines | 3 | 146162 | 317 | 36.626 | 3990.7 |
| 446 | 2025-01-27 00:13:32 | pennines | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 445 | 2025-01-27 00:12:44 | pennines | 2 | 121059 | 31 | 3.670 | 32986.1 |
| 444 | 2025-01-26 21:39:55 | pennines | 3 | 146162 | 317 | 30.986 | 4717.0 |
| 443 | 2025-01-25 09:54:10 | pennines | 1 | 82945 | 3 | 7.453 | 11129.1 |
| 442 | 2025-01-24 06:47:33 | pennines | 3 | 146162 | 317 | 30.110 | 4854.3 |
| 441 | 2025-01-24 06:47:36 | pennines | 2 | 121059 | 31 | 19.266 | 6283.6 |
| 440 | 2025-01-24 06:47:01 | pennines | 1 | 82945 | 3 | 4.910 | 16893.1 |
| 439 | 2025-01-20 21:05:41 | pennines | 1 | 82945 | 3 | 5.406 | 15343.1 |
| 438 | 2025-01-10 13:09:06 | pennines | 1 | 82945 | 3 | 3.596 | 23065.9 |
| 437 | 2024-12-23 13:41:47 | pennines | 1 | 82945 | 3 | 9.330 | 8890.1 |
| 436 | 2024-12-21 15:52:34 | pennines | 1 | 82945 | 3 | 5.733 | 14468.0 |