History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prentice"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 448 | 2025-08-27 11:13:17 | prentice | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 447 | 2025-08-17 10:28:33 | prentice | 1 | 82945 | 3 | 3.626 | 22875.1 |
| 446 | 2025-08-11 23:58:10 | prentice | 3 | 146162 | 160 | 17.390 | 8404.9 |
| 445 | 2025-08-10 18:51:34 | prentice | 2 | 121059 | 9 | 9.923 | 12199.8 |
| 444 | 2025-08-10 09:23:58 | prentice | 3 | 146162 | 160 | 38.223 | 3823.9 |
| 443 | 2025-08-10 07:06:43 | prentice | 3 | 146162 | 160 | 19.610 | 7453.4 |
| 442 | 2025-08-09 15:49:16 | prentice | 1 | 82945 | 3 | 7.186 | 11542.6 |
| 441 | 2025-08-06 10:20:57 | prentice | 3 | 146162 | 160 | 36.723 | 3980.1 |
| 440 | 2025-08-06 09:38:06 | prentice | 2 | 121059 | 9 | 9.030 | 13406.3 |
| 439 | 2025-08-04 02:07:57 | prentice | 1 | 82945 | 3 | 1.543 | 53755.7 |
| 438 | 2025-07-27 12:16:48 | prentice | 1 | 82945 | 3 | 5.953 | 13933.3 |
| 437 | 2025-07-27 09:18:44 | prentice | 1 | 82945 | 3 | 5.936 | 13973.2 |
| 436 | 2025-07-26 23:24:50 | prentice | 1 | 82945 | 3 | 4.640 | 17876.1 |
| 435 | 2025-07-19 17:15:26 | prentice | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 434 | 2025-07-12 08:13:40 | prentice | 3 | 146162 | 160 | 13.143 | 11120.9 |
| 433 | 2025-07-12 00:06:28 | prentice | 3 | 146162 | 160 | 10.126 | 14434.3 |
| 432 | 2025-07-02 16:24:00 | prentice | 3 | 146162 | 160 | 37.690 | 3878.0 |
| 431 | 2025-07-02 12:23:10 | prentice | 1 | 82945 | 3 | 6.173 | 13436.7 |
| 430 | 2025-06-29 05:37:54 | prentice | 3 | 146162 | 160 | 20.843 | 7012.5 |
| 429 | 2025-06-27 22:44:07 | prentice | 3 | 146162 | 160 | 40.580 | 3601.8 |
| 428 | 2025-06-26 01:05:29 | prentice | 3 | 146162 | 160 | 30.046 | 4864.6 |
| 427 | 2025-06-24 08:15:28 | prentice | 1 | 82945 | 3 | 10.626 | 7805.9 |
| 426 | 2025-06-16 04:51:09 | prentice | 1 | 82945 | 3 | 11.156 | 7435.0 |
| 425 | 2025-06-08 08:03:22 | prentice | 1 | 82945 | 3 | 10.326 | 8032.6 |
| 424 | 2025-06-04 07:46:37 | prentice | 1 | 82945 | 3 | 6.450 | 12859.7 |
| 423 | 2025-05-27 19:25:46 | prentice | 1 | 82945 | 3 | 3.000 | 27648.3 |
| 422 | 2025-05-27 12:21:29 | prentice | 1 | 82945 | 3 | 4.343 | 19098.5 |
| 421 | 2025-05-26 21:07:45 | prentice | 1 | 82945 | 3 | 6.440 | 12879.7 |
| 420 | 2025-05-24 05:35:14 | prentice | 2 | 121059 | 9 | 17.093 | 7082.4 |
| 419 | 2025-05-23 23:36:21 | prentice | 3 | 146162 | 160 | 36.673 | 3985.5 |
| 418 | 2025-05-23 10:52:07 | prentice | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 417 | 2025-05-22 19:33:03 | prentice | 3 | 146162 | 160 | 7.580 | 19282.6 |
| 416 | 2025-05-16 05:32:31 | prentice | 3 | 146162 | 160 | 44.940 | 3252.4 |
| 415 | 2025-05-16 03:05:24 | prentice | 3 | 146162 | 160 | 28.640 | 5103.4 |
| 414 | 2025-05-15 22:09:20 | prentice | 3 | 146162 | 160 | 31.380 | 4657.8 |
| 413 | 2025-05-15 21:26:36 | prentice | 3 | 146162 | 160 | 19.050 | 7672.5 |
| 412 | 2025-05-14 17:20:47 | prentice | 2 | 121059 | 9 | 16.300 | 7426.9 |
| 411 | 2025-05-14 08:33:13 | prentice | 3 | 146162 | 160 | 26.906 | 5432.3 |
| 410 | 2025-05-13 04:31:47 | prentice | 1 | 82945 | 3 | 3.763 | 22042.3 |
| 409 | 2025-05-11 11:43:28 | prentice | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 408 | 2025-05-03 03:04:06 | prentice | 1 | 82945 | 3 | 6.030 | 13755.4 |
| 407 | 2025-05-02 07:49:08 | prentice | 1 | 82945 | 3 | 11.610 | 7144.3 |
| 406 | 2025-05-02 03:21:13 | prentice | 1 | 82945 | 3 | 8.830 | 9393.5 |
| 405 | 2025-05-01 03:00:33 | prentice | 1 | 82945 | 3 | 4.016 | 20653.6 |
| 404 | 2025-04-30 07:50:12 | prentice | 1 | 82945 | 3 | 10.343 | 8019.4 |
| 403 | 2025-04-20 09:42:59 | prentice | 1 | 82945 | 3 | 6.546 | 12671.1 |
| 402 | 2025-04-14 21:18:09 | prentice | 3 | 146162 | 160 | 43.016 | 3397.9 |
| 401 | 2025-04-14 02:46:37 | prentice | 3 | 146162 | 160 | 41.390 | 3531.3 |
| 400 | 2025-04-13 18:43:39 | prentice | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 399 | 2025-04-11 21:18:55 | prentice | 3 | 146162 | 160 | 45.143 | 3237.8 |
| 398 | 2025-04-11 20:38:13 | prentice | 3 | 146162 | 160 | 53.940 | 2709.7 |
| 397 | 2025-04-11 08:02:33 | prentice | 3 | 146162 | 160 | 40.536 | 3605.7 |
| 396 | 2025-04-10 03:39:10 | prentice | 3 | 146162 | 160 | 9.966 | 14666.1 |
| 395 | 2025-03-20 12:10:10 | prentice | 1 | 82945 | 3 | 7.296 | 11368.6 |
| 394 | 2025-03-20 08:06:02 | prentice | 1 | 82945 | 3 | 9.406 | 8818.3 |
| 393 | 2025-03-12 14:30:11 | prentice | 1 | 82945 | 3 | 8.233 | 10074.7 |
| 392 | 2025-03-10 02:04:45 | prentice | 3 | 146162 | 160 | 47.613 | 3069.8 |
| 391 | 2025-03-08 14:51:42 | prentice | 3 | 146162 | 160 | 53.033 | 2756.1 |
| 390 | 2025-03-08 06:40:03 | prentice | 3 | 146162 | 160 | 24.843 | 5883.4 |
| 389 | 2025-03-07 11:16:29 | prentice | 3 | 146162 | 160 | 25.893 | 5644.8 |
| 388 | 2025-03-07 11:16:24 | prentice | 2 | 121059 | 9 | 28.783 | 4205.9 |
| 387 | 2025-03-07 11:16:22 | prentice | 1 | 82945 | 3 | 7.236 | 11462.8 |
| 386 | 2025-03-05 21:33:56 | prentice | 1 | 82945 | 3 | 3.703 | 22399.4 |
| 385 | 2025-02-23 22:18:43 | prentice | 1 | 82945 | 3 | 5.813 | 14268.9 |
| 384 | 2025-01-27 22:17:34 | prentice | 1 | 82945 | 3 | 7.080 | 11715.4 |
| 383 | 2025-01-27 09:58:13 | prentice | 1 | 82945 | 3 | 7.253 | 11436.0 |
| 382 | 2025-01-27 00:52:26 | prentice | 1 | 82945 | 3 | 10.453 | 7935.0 |
| 381 | 2025-01-26 22:32:13 | prentice | 1 | 82945 | 3 | 3.873 | 21416.2 |
| 380 | 2025-01-10 07:47:06 | prentice | 3 | 146162 | 160 | 39.000 | 3747.7 |
| 379 | 2025-01-10 03:27:40 | prentice | 2 | 121059 | 9 | 10.030 | 12069.7 |
| 378 | 2025-01-10 03:14:19 | prentice | 3 | 146162 | 160 | 6.906 | 21164.5 |
| 377 | 2025-01-09 17:13:50 | prentice | 3 | 146162 | 160 | 31.660 | 4616.6 |
| 376 | 2025-01-09 13:27:35 | prentice | 2 | 121059 | 9 | 17.390 | 6961.4 |
| 375 | 2025-01-09 13:27:29 | prentice | 1 | 82945 | 3 | 11.453 | 7242.2 |
| 374 | 2025-01-09 00:20:03 | prentice | 3 | 146162 | 160 | 38.750 | 3771.9 |
| 373 | 2025-01-04 17:58:29 | prentice | 3 | 146162 | 160 | 34.213 | 4272.1 |
| 372 | 2024-12-27 16:34:53 | prentice | 1 | 82945 | 3 | 4.546 | 18245.7 |
| 371 | 2024-12-25 10:23:48 | prentice | 1 | 82945 | 3 | 3.656 | 22687.4 |
| 370 | 2024-12-23 13:10:19 | prentice | 2 | 121059 | 9 | 18.156 | 6667.7 |
| 369 | 2024-12-20 01:42:24 | prentice | 2 | 121059 | 9 | 17.546 | 6899.5 |
| 368 | 2024-12-10 23:48:52 | prentice | 3 | 146162 | 160 | 23.783 | 6145.7 |
| 367 | 2024-12-10 18:44:35 | prentice | 3 | 146162 | 160 | 19.156 | 7630.1 |
| 366 | 2024-12-09 19:09:38 | prentice | 3 | 146162 | 160 | 35.550 | 4111.4 |
| 365 | 2024-12-09 18:20:20 | prentice | 3 | 146162 | 160 | 7.923 | 18447.8 |
| 364 | 2024-12-09 18:20:22 | prentice | 2 | 121059 | 9 | 4.046 | 29920.7 |
| 363 | 2024-12-09 18:20:19 | prentice | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 362 | 2024-11-25 09:47:31 | prentice | 1 | 82945 | 3 | 4.830 | 17172.9 |
| 361 | 2024-11-12 01:20:12 | prentice | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 360 | 2024-11-11 23:44:37 | prentice | 1 | 82945 | 3 | 10.266 | 8079.6 |
| 359 | 2024-10-27 09:58:46 | prentice | 2 | 121059 | 9 | 7.000 | 17294.1 |
| 358 | 2024-10-27 02:02:32 | prentice | 1 | 82945 | 3 | 9.826 | 8441.4 |
| 357 | 2024-10-26 09:08:51 | prentice | 2 | 121059 | 9 | 22.830 | 5302.6 |
| 356 | 2024-10-26 09:08:39 | prentice | 1 | 82945 | 3 | 4.653 | 17826.1 |
| 355 | 2024-10-09 01:18:14 | prentice | 3 | 146162 | 160 | 53.503 | 2731.8 |
| 354 | 2024-10-08 23:03:26 | prentice | 3 | 146162 | 160 | 26.110 | 5597.9 |
| 353 | 2024-10-04 17:54:57 | prentice | 3 | 146162 | 160 | 54.270 | 2693.2 |
| 352 | 2024-10-03 03:06:37 | prentice | 3 | 146162 | 160 | 48.486 | 3014.5 |
| 351 | 2024-10-03 03:06:30 | prentice | 2 | 121059 | 9 | 26.143 | 4630.6 |
| 350 | 2024-10-03 03:06:07 | prentice | 1 | 82945 | 3 | 6.546 | 12671.1 |
| 349 | 2024-09-23 17:49:04 | prentice | 1 | 82945 | 3 | 7.500 | 11059.3 |