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 |
| 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 |
| 435 | 2024-12-19 13:22:58 | pennines | 2 | 121059 | 31 | 14.610 | 8286.0 |
| 434 | 2024-12-19 13:21:47 | pennines | 1 | 82945 | 3 | 2.390 | 34705.0 |
| 433 | 2024-12-18 01:49:00 | pennines | 3 | 146162 | 317 | 44.890 | 3256.0 |
| 432 | 2024-12-17 02:19:47 | pennines | 3 | 146162 | 317 | 41.660 | 3508.4 |
| 431 | 2024-12-16 17:44:22 | pennines | 3 | 146162 | 317 | 45.033 | 3245.7 |
| 430 | 2024-12-16 17:43:34 | pennines | 2 | 121059 | 31 | 8.953 | 13521.6 |
| 429 | 2024-12-16 16:31:37 | pennines | 3 | 146162 | 317 | 6.966 | 20982.2 |
| 428 | 2024-12-16 16:31:29 | pennines | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 427 | 2024-12-09 18:19:28 | pennines | 2 | 121059 | 31 | 3.593 | 33693.0 |
| 426 | 2024-12-09 18:19:24 | pennines | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 425 | 2024-11-15 21:27:50 | pennines | 3 | 146162 | 317 | 37.453 | 3902.5 |
| 424 | 2024-11-15 10:50:45 | pennines | 2 | 121059 | 31 | 20.016 | 6048.1 |
| 423 | 2024-11-15 10:50:30 | pennines | 1 | 82945 | 3 | 5.923 | 14003.9 |
| 422 | 2024-11-15 07:04:45 | pennines | 3 | 146162 | 317 | 41.253 | 3543.1 |
| 421 | 2024-11-14 23:06:38 | pennines | 3 | 146162 | 317 | 38.096 | 3836.7 |
| 420 | 2024-11-14 21:30:38 | pennines | 3 | 146162 | 317 | 38.596 | 3787.0 |
| 419 | 2024-11-14 21:30:39 | pennines | 2 | 121059 | 31 | 26.566 | 4556.9 |
| 418 | 2024-11-14 21:26:13 | pennines | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 417 | 2024-11-09 17:32:56 | pennines | 1 | 82945 | 3 | 3.703 | 22399.4 |
| 416 | 2024-10-23 05:23:42 | pennines | 1 | 82945 | 3 | 7.096 | 11689.0 |
| 415 | 2024-10-15 18:12:43 | pennines | 1 | 82945 | 3 | 6.890 | 12038.5 |
| 414 | 2024-10-14 19:48:35 | pennines | 1 | 82945 | 3 | 10.953 | 7572.8 |
| 413 | 2024-09-20 04:44:15 | pennines | 1 | 82945 | 3 | 11.873 | 6986.0 |
| 412 | 2024-09-09 12:50:42 | pennines | 1 | 82945 | 3 | 8.250 | 10053.9 |
| 411 | 2024-08-28 13:07:30 | pennines | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 410 | 2024-08-09 15:55:35 | pennines | 1 | 82945 | 3 | 2.890 | 28700.7 |
| 409 | 2024-08-07 01:20:59 | pennines | 3 | 146162 | 317 | 32.066 | 4558.2 |
| 408 | 2024-08-06 17:11:23 | pennines | 3 | 146162 | 317 | 10.216 | 14307.2 |
| 407 | 2024-08-06 03:26:50 | pennines | 3 | 146162 | 317 | 14.390 | 10157.2 |
| 406 | 2024-08-06 03:26:35 | pennines | 2 | 121059 | 31 | 22.346 | 5417.5 |
| 405 | 2024-08-06 02:39:13 | pennines | 3 | 146162 | 317 | 14.956 | 9772.8 |
| 404 | 2024-08-05 09:24:24 | pennines | 2 | 121059 | 31 | 11.343 | 10672.6 |
| 403 | 2024-08-05 09:24:15 | pennines | 3 | 146162 | 317 | 19.516 | 7489.3 |
| 402 | 2024-08-05 09:19:57 | pennines | 1 | 82945 | 3 | 3.766 | 22024.7 |
| 401 | 2024-07-31 12:01:23 | pennines | 1 | 82945 | 3 | 6.766 | 12259.1 |
| 400 | 2024-07-14 23:03:05 | pennines | 1 | 82945 | 3 | 10.016 | 8281.3 |
| 399 | 2024-07-13 12:01:21 | pennines | 1 | 82945 | 3 | 8.050 | 10303.7 |
| 398 | 2024-07-03 08:05:15 | pennines | 1 | 82945 | 3 | 5.250 | 15799.0 |
| 397 | 2024-07-01 19:01:42 | pennines | 1 | 82945 | 3 | 2.546 | 32578.6 |
| 396 | 2024-07-01 00:51:56 | pennines | 1 | 82945 | 3 | 7.390 | 11224.0 |
| 395 | 2024-06-28 01:29:49 | pennines | 1 | 82945 | 3 | 6.030 | 13755.4 |
| 394 | 2024-06-21 22:06:11 | pennines | 1 | 82945 | 3 | 4.236 | 19581.0 |
| 393 | 2024-06-18 02:28:27 | pennines | 3 | 146162 | 317 | 34.190 | 4275.0 |
| 392 | 2024-06-06 01:14:16 | pennines | 1 | 82945 | 3 | 5.436 | 15258.5 |
| 391 | 2024-06-05 03:00:34 | pennines | 1 | 82945 | 3 | 1.893 | 43816.7 |
| 390 | 2024-06-04 23:00:57 | pennines | 3 | 146162 | 317 | 9.563 | 15284.1 |
| 389 | 2024-06-02 21:57:37 | pennines | 2 | 121059 | 31 | 5.860 | 20658.5 |
| 388 | 2024-06-02 12:26:44 | pennines | 2 | 121059 | 31 | 7.466 | 16214.7 |
| 387 | 2024-06-02 09:36:10 | pennines | 3 | 146162 | 317 | 13.940 | 10485.1 |
| 386 | 2024-06-02 08:47:12 | pennines | 3 | 146162 | 317 | 7.360 | 19859.0 |
| 385 | 2024-06-02 08:22:20 | pennines | 3 | 146162 | 317 | 15.376 | 9505.9 |
| 384 | 2024-06-02 03:19:19 | pennines | 3 | 146162 | 317 | 22.203 | 6583.0 |
| 383 | 2024-06-02 03:19:07 | pennines | 2 | 121059 | 31 | 14.350 | 8436.2 |
| 382 | 2024-06-02 02:17:29 | pennines | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 381 | 2024-06-01 18:14:52 | pennines | 1 | 82945 | 3 | 3.140 | 26415.6 |
| 380 | 2024-05-02 04:13:26 | pennines | 3 | 146162 | 317 | 7.923 | 18447.8 |
| 379 | 2024-05-02 04:13:30 | pennines | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 378 | 2024-05-02 04:13:22 | pennines | 2 | 121059 | 31 | 4.233 | 28598.9 |
| 377 | 2024-05-01 08:43:39 | pennines | 3 | 146162 | 317 | 20.483 | 7135.8 |
| 376 | 2024-05-01 08:43:37 | pennines | 2 | 121059 | 31 | 4.313 | 28068.4 |
| 375 | 2024-04-30 23:53:38 | pennines | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 374 | 2024-04-17 01:54:47 | pennines | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 373 | 2024-04-09 08:36:03 | pennines | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 372 | 2024-04-09 07:28:07 | pennines | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 371 | 2024-04-07 18:36:51 | pennines | 3 | 146162 | 317 | 14.643 | 9981.7 |
| 370 | 2024-04-06 09:56:00 | pennines | 1 | 82945 | 3 | 4.560 | 18189.7 |
| 369 | 2024-04-06 06:24:43 | pennines | 3 | 146162 | 317 | 14.890 | 9816.1 |
| 368 | 2024-04-05 10:13:49 | pennines | 3 | 146162 | 317 | 18.096 | 8077.0 |
| 367 | 2024-04-01 14:29:28 | pennines | 1 | 82945 | 3 | 1.686 | 49196.3 |
| 366 | 2024-04-01 14:29:11 | pennines | 2 | 121059 | 31 | 7.546 | 16042.8 |
| 365 | 2024-03-31 05:20:40 | pennines | 3 | 146162 | 317 | 22.766 | 6420.2 |
| 364 | 2024-03-30 23:46:14 | pennines | 3 | 146162 | 317 | 14.330 | 10199.7 |
| 363 | 2024-03-30 19:20:27 | pennines | 3 | 146162 | 317 | 11.390 | 12832.5 |
| 362 | 2024-03-30 19:20:22 | pennines | 2 | 121059 | 31 | 12.110 | 9996.6 |
| 361 | 2024-03-30 19:18:08 | pennines | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 360 | 2024-03-30 04:13:46 | pennines | 1 | 82945 | 3 | 3.983 | 20824.8 |
| 359 | 2024-03-15 23:36:19 | pennines | 1 | 82945 | 3 | 2.013 | 41204.7 |
| 358 | 2024-03-12 00:19:05 | pennines | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 357 | 2024-02-29 22:06:53 | pennines | 3 | 146162 | 317 | 10.643 | 13733.2 |
| 356 | 2024-02-29 14:12:07 | pennines | 2 | 121059 | 31 | 3.893 | 31096.6 |
| 355 | 2024-02-29 09:57:39 | pennines | 1 | 82945 | 3 | 3.186 | 26034.2 |
| 354 | 2024-02-28 09:27:20 | pennines | 3 | 146162 | 317 | 16.436 | 8892.8 |
| 353 | 2024-02-28 07:06:23 | pennines | 3 | 146162 | 317 | 10.376 | 14086.5 |
| 352 | 2024-02-28 06:27:40 | pennines | 3 | 146162 | 317 | 7.813 | 18707.5 |
| 351 | 2024-02-28 06:27:31 | pennines | 2 | 121059 | 31 | 4.013 | 30166.7 |
| 350 | 2024-02-23 11:21:23 | pennines | 2 | 121059 | 31 | 3.250 | 37248.9 |