History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pennine"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 487 | 2025-12-07 18:46:19 | pennine | 3 | 134027 | 407 | 7.233 | 18529.9 |
| 486 | 2025-12-03 05:37:10 | pennine | 3 | 134027 | 407 | 15.080 | 8887.7 |
| 485 | 2025-11-30 04:20:35 | pennine | 3 | 134027 | 407 | 6.856 | 19548.9 |
| 484 | 2025-11-28 19:36:36 | pennine | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 483 | 2025-11-26 15:11:14 | pennine | 2 | 107671 | 43 | 3.720 | 28943.8 |
| 482 | 2025-11-09 05:49:02 | pennine | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 481 | 2025-11-04 20:42:31 | pennine | 3 | 134027 | 407 | 7.046 | 19021.7 |
| 480 | 2025-10-31 06:04:57 | pennine | 2 | 107671 | 43 | 2.983 | 36094.9 |
| 479 | 2025-09-18 22:09:14 | pennine | 1 | 69583 | 3 | 1.656 | 42018.7 |
| 478 | 2025-09-05 06:57:21 | pennine | 2 | 107671 | 43 | 2.920 | 36873.6 |
| 477 | 2025-08-24 19:58:31 | pennine | 1 | 69583 | 3 | 8.470 | 8215.2 |
| 476 | 2025-08-24 12:17:01 | pennine | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 475 | 2025-08-11 19:27:31 | pennine | 3 | 134027 | 407 | 19.673 | 6812.7 |
| 474 | 2025-08-09 17:35:03 | pennine | 1 | 69583 | 3 | 5.533 | 12576.0 |
| 473 | 2025-08-06 12:43:31 | pennine | 2 | 107671 | 43 | 8.623 | 12486.5 |
| 472 | 2025-08-06 11:49:32 | pennine | 3 | 134027 | 407 | 44.750 | 2995.0 |
| 471 | 2025-08-05 11:38:56 | pennine | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 470 | 2025-08-04 01:28:20 | pennine | 1 | 69583 | 3 | 2.626 | 26497.7 |
| 469 | 2025-07-26 20:15:24 | pennine | 1 | 69583 | 3 | 3.700 | 18806.2 |
| 468 | 2025-07-24 23:36:12 | pennine | 1 | 69583 | 3 | 4.453 | 15626.1 |
| 467 | 2025-07-23 11:06:36 | pennine | 1 | 69583 | 3 | 4.813 | 14457.3 |
| 466 | 2025-07-22 17:34:31 | pennine | 1 | 69583 | 3 | 3.953 | 17602.6 |
| 465 | 2025-07-17 18:55:28 | pennine | 1 | 69583 | 3 | 4.876 | 14270.5 |
| 464 | 2025-07-16 05:35:51 | pennine | 1 | 69583 | 3 | 9.500 | 7324.5 |
| 463 | 2025-07-15 09:11:42 | pennine | 1 | 69583 | 3 | 5.780 | 12038.6 |
| 462 | 2025-07-05 04:51:55 | pennine | 3 | 134027 | 407 | 23.326 | 5745.8 |
| 461 | 2025-07-04 16:07:05 | pennine | 1 | 69583 | 3 | 5.766 | 12067.8 |
| 460 | 2025-07-04 10:07:33 | pennine | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 459 | 2025-06-27 23:21:36 | pennine | 2 | 107671 | 43 | 18.390 | 5854.9 |
| 458 | 2025-06-21 20:44:26 | pennine | 1 | 69583 | 3 | 6.780 | 10263.0 |
| 457 | 2025-06-16 15:54:19 | pennine | 1 | 69583 | 3 | 5.856 | 11882.3 |
| 456 | 2025-06-13 04:08:02 | pennine | 3 | 134027 | 407 | 7.920 | 16922.6 |
| 455 | 2025-06-12 11:17:09 | pennine | 3 | 134027 | 407 | 28.050 | 4778.1 |
| 454 | 2025-06-10 09:41:19 | pennine | 3 | 134027 | 407 | 39.203 | 3418.8 |
| 453 | 2025-06-04 16:17:32 | pennine | 1 | 69583 | 3 | 4.716 | 14754.7 |
| 452 | 2025-06-04 04:32:59 | pennine | 3 | 134027 | 407 | 41.720 | 3212.5 |
| 451 | 2025-06-03 09:29:26 | pennine | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 450 | 2025-05-28 07:29:15 | pennine | 1 | 69583 | 3 | 3.220 | 21609.6 |
| 449 | 2025-05-21 20:32:35 | pennine | 1 | 69583 | 3 | 4.830 | 14406.4 |
| 448 | 2025-05-20 12:52:54 | pennine | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 447 | 2025-05-18 09:48:09 | pennine | 2 | 107671 | 43 | 25.376 | 4243.0 |
| 446 | 2025-05-16 10:24:17 | pennine | 3 | 134027 | 407 | 24.923 | 5377.6 |
| 445 | 2025-05-16 04:02:45 | pennine | 2 | 107671 | 43 | 25.126 | 4285.2 |
| 444 | 2025-05-12 15:21:28 | pennine | 1 | 69583 | 3 | 4.736 | 14692.4 |
| 443 | 2025-05-12 12:35:51 | pennine | 3 | 134027 | 407 | 31.563 | 4246.3 |
| 442 | 2025-05-07 17:56:21 | pennine | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 441 | 2025-05-04 16:31:57 | pennine | 1 | 69583 | 3 | 3.656 | 19032.5 |
| 440 | 2025-05-02 10:27:03 | pennine | 1 | 69583 | 3 | 6.076 | 11452.1 |
| 439 | 2025-05-01 09:35:09 | pennine | 1 | 69583 | 3 | 5.016 | 13872.2 |
| 438 | 2025-04-30 21:03:43 | pennine | 2 | 107671 | 43 | 8.703 | 12371.7 |
| 437 | 2025-04-30 20:31:10 | pennine | 3 | 134027 | 407 | 25.750 | 5204.9 |
| 436 | 2025-04-28 22:57:25 | pennine | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 435 | 2025-04-24 04:32:18 | pennine | 3 | 134027 | 407 | 36.796 | 3642.4 |
| 434 | 2025-04-19 20:22:05 | pennine | 1 | 69583 | 3 | 5.780 | 12038.6 |
| 433 | 2025-04-13 17:47:35 | pennine | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 432 | 2025-04-12 18:19:52 | pennine | 3 | 134027 | 407 | 7.313 | 18327.2 |
| 431 | 2025-04-11 15:32:09 | pennine | 1 | 69583 | 3 | 3.156 | 22047.8 |
| 430 | 2025-04-08 08:23:49 | pennine | 3 | 134027 | 407 | 7.296 | 18369.9 |
| 429 | 2025-04-06 16:52:44 | pennine | 3 | 134027 | 407 | 57.440 | 2333.3 |
| 428 | 2025-04-06 03:01:19 | pennine | 2 | 107671 | 43 | 11.003 | 9785.6 |
| 427 | 2025-04-04 17:22:24 | pennine | 2 | 107671 | 43 | 8.283 | 12999.0 |
| 426 | 2025-04-02 23:08:23 | pennine | 1 | 69583 | 3 | 1.703 | 40859.1 |
| 425 | 2025-04-02 07:05:30 | pennine | 2 | 107671 | 43 | 11.450 | 9403.6 |
| 424 | 2025-04-01 12:06:43 | pennine | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 423 | 2025-03-29 11:29:50 | pennine | 1 | 69583 | 3 | 6.250 | 11133.3 |
| 422 | 2025-03-27 05:48:40 | pennine | 3 | 134027 | 407 | 32.690 | 4099.9 |
| 421 | 2025-03-27 05:15:40 | pennine | 3 | 134027 | 407 | 29.423 | 4555.2 |
| 420 | 2025-03-27 00:29:43 | pennine | 3 | 134027 | 407 | 32.206 | 4161.6 |
| 419 | 2025-03-26 23:56:43 | pennine | 1 | 69583 | 3 | 5.910 | 11773.8 |
| 418 | 2025-03-26 03:47:17 | pennine | 3 | 134027 | 407 | 6.046 | 22167.9 |
| 417 | 2025-03-25 13:18:57 | pennine | 3 | 134027 | 407 | 32.220 | 4159.7 |
| 416 | 2025-03-21 21:27:35 | pennine | 2 | 107671 | 43 | 20.733 | 5193.2 |
| 415 | 2025-03-21 20:06:09 | pennine | 3 | 134027 | 407 | 15.656 | 8560.7 |
| 414 | 2025-03-18 21:42:06 | pennine | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 413 | 2025-03-13 23:43:07 | pennine | 1 | 69583 | 3 | 5.923 | 11747.9 |
| 412 | 2025-03-12 06:12:03 | pennine | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 411 | 2025-03-09 01:03:22 | pennine | 3 | 134027 | 407 | 17.376 | 7713.3 |
| 410 | 2025-03-02 17:45:56 | pennine | 3 | 134027 | 407 | 32.516 | 4121.9 |
| 409 | 2025-03-02 17:46:00 | pennine | 2 | 107671 | 43 | 21.986 | 4897.3 |
| 408 | 2025-03-02 17:45:39 | pennine | 1 | 69583 | 3 | 5.216 | 13340.3 |
| 407 | 2025-02-24 14:26:18 | pennine | 1 | 69583 | 3 | 5.453 | 12760.5 |
| 406 | 2025-02-24 10:23:05 | pennine | 3 | 134027 | 407 | 30.446 | 4402.1 |
| 405 | 2025-02-24 03:31:28 | pennine | 3 | 134027 | 407 | 38.363 | 3493.7 |
| 404 | 2025-02-23 22:59:24 | pennine | 1 | 69583 | 3 | 12.546 | 5546.2 |
| 403 | 2025-02-23 22:58:17 | pennine | 3 | 134027 | 407 | 28.250 | 4744.3 |
| 402 | 2025-02-23 22:58:17 | pennine | 2 | 107671 | 43 | 19.173 | 5615.8 |
| 401 | 2025-02-17 02:34:21 | pennine | 3 | 134027 | 407 | 19.703 | 6802.4 |
| 400 | 2025-02-05 14:54:05 | pennine | 1 | 69583 | 3 | 9.080 | 7663.3 |
| 399 | 2025-01-27 00:12:46 | pennine | 2 | 107671 | 43 | 3.156 | 34116.3 |
| 398 | 2025-01-25 08:12:23 | pennine | 3 | 134027 | 407 | 31.503 | 4254.4 |
| 397 | 2025-01-24 22:09:19 | pennine | 3 | 134027 | 407 | 35.663 | 3758.2 |
| 396 | 2025-01-24 15:56:58 | pennine | 3 | 134027 | 407 | 17.686 | 7578.1 |
| 395 | 2025-01-24 06:50:11 | pennine | 3 | 134027 | 407 | 40.503 | 3309.1 |
| 394 | 2025-01-24 06:50:14 | pennine | 2 | 107671 | 43 | 15.593 | 6905.1 |
| 393 | 2025-01-24 06:46:45 | pennine | 1 | 69583 | 3 | 4.156 | 16742.8 |
| 392 | 2025-01-12 06:31:15 | pennine | 1 | 69583 | 3 | 6.983 | 9964.6 |
| 391 | 2024-12-30 18:44:26 | pennine | 2 | 107671 | 43 | 18.956 | 5680.0 |
| 390 | 2024-12-12 02:06:48 | pennine | 3 | 134027 | 407 | 34.890 | 3841.4 |
| 389 | 2024-12-12 02:06:55 | pennine | 2 | 107671 | 43 | 17.766 | 6060.5 |
| 388 | 2024-12-12 02:06:24 | pennine | 1 | 69583 | 3 | 6.186 | 11248.5 |