History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ancestry"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 524 | 2026-01-01 01:12:31 | ancestry | 1 | 82945 | 1 | 1.513 | 54821.5 |
| 523 | 2025-12-23 12:41:39 | ancestry | 1 | 82945 | 1 | 1.950 | 42535.9 |
| 522 | 2025-12-23 08:46:23 | ancestry | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 521 | 2025-12-21 23:17:55 | ancestry | 1 | 82945 | 1 | 1.530 | 54212.4 |
| 520 | 2025-12-19 21:13:18 | ancestry | 1 | 82945 | 1 | 3.703 | 22399.4 |
| 519 | 2025-11-24 15:34:45 | ancestry | 3 | 146162 | 26 | 7.563 | 19325.9 |
| 518 | 2025-11-23 21:01:47 | ancestry | 1 | 82945 | 1 | 2.626 | 31586.1 |
| 517 | 2025-11-21 19:07:32 | ancestry | 3 | 146162 | 26 | 14.830 | 9855.8 |
| 516 | 2025-11-17 17:29:20 | ancestry | 2 | 121059 | 6 | 3.780 | 32026.2 |
| 515 | 2025-11-15 15:57:38 | ancestry | 1 | 82945 | 1 | 1.466 | 56579.1 |
| 514 | 2025-11-12 03:01:04 | ancestry | 3 | 146162 | 26 | 7.983 | 18309.2 |
| 513 | 2025-09-28 17:24:51 | ancestry | 1 | 82945 | 1 | 1.440 | 57600.7 |
| 512 | 2025-09-26 06:35:20 | ancestry | 1 | 82945 | 1 | 1.516 | 54713.1 |
| 511 | 2025-09-16 07:56:27 | ancestry | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 510 | 2025-08-28 13:46:25 | ancestry | 1 | 82945 | 1 | 1.516 | 54713.1 |
| 509 | 2025-08-28 06:11:49 | ancestry | 1 | 82945 | 1 | 1.516 | 54713.1 |
| 508 | 2025-08-27 16:15:36 | ancestry | 1 | 82945 | 1 | 1.326 | 62552.8 |
| 507 | 2025-08-26 11:36:39 | ancestry | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 506 | 2025-08-09 13:37:29 | ancestry | 1 | 82945 | 1 | 3.203 | 25896.0 |
| 505 | 2025-07-24 07:45:17 | ancestry | 1 | 82945 | 1 | 7.700 | 10772.1 |
| 504 | 2025-07-20 12:13:30 | ancestry | 2 | 121059 | 6 | 3.813 | 31749.0 |
| 503 | 2025-07-20 00:04:13 | ancestry | 1 | 82945 | 1 | 8.190 | 10127.6 |
| 502 | 2025-07-17 05:34:39 | ancestry | 1 | 82945 | 1 | 5.063 | 16382.6 |
| 501 | 2025-06-30 17:48:53 | ancestry | 1 | 82945 | 1 | 7.216 | 11494.6 |
| 500 | 2025-06-29 01:25:38 | ancestry | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 499 | 2025-06-27 12:04:07 | ancestry | 1 | 82945 | 1 | 6.483 | 12794.2 |
| 498 | 2025-06-24 12:54:27 | ancestry | 4 | 161609 | 354 | 57.203 | 2825.2 |
| 497 | 2025-06-21 18:25:14 | ancestry | 4 | 161609 | 354 | 13.613 | 11871.7 |
| 496 | 2025-06-21 09:12:18 | ancestry | 4 | 161609 | 354 | 18.346 | 8809.0 |
| 495 | 2025-06-13 19:21:47 | ancestry | 1 | 82945 | 1 | 8.220 | 10090.6 |
| 494 | 2025-06-13 03:08:41 | ancestry | 1 | 82945 | 1 | 3.283 | 25265.0 |
| 493 | 2025-06-08 18:13:11 | ancestry | 4 | 161609 | 354 | 67.520 | 2393.5 |
| 492 | 2025-06-08 01:59:24 | ancestry | 4 | 161609 | 354 | 64.506 | 2505.3 |
| 491 | 2025-06-06 23:36:38 | ancestry | 4 | 161609 | 354 | 57.160 | 2827.3 |
| 490 | 2025-06-05 09:51:59 | ancestry | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 489 | 2025-05-27 12:27:41 | ancestry | 1 | 82945 | 1 | 4.606 | 18008.0 |
| 488 | 2025-05-11 22:06:21 | ancestry | 1 | 82945 | 1 | 6.843 | 12121.1 |
| 487 | 2025-04-30 12:30:59 | ancestry | 1 | 82945 | 1 | 7.030 | 11798.7 |
| 486 | 2025-04-27 21:50:45 | ancestry | 3 | 146162 | 26 | 27.363 | 5341.6 |
| 485 | 2025-04-25 19:30:35 | ancestry | 3 | 146162 | 26 | 33.773 | 4327.8 |
| 484 | 2025-04-25 15:48:31 | ancestry | 4 | 161609 | 354 | 15.783 | 10239.4 |
| 483 | 2025-04-25 11:09:49 | ancestry | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 482 | 2025-04-15 22:46:16 | ancestry | 1 | 82945 | 1 | 7.046 | 11771.9 |
| 481 | 2025-03-31 16:21:46 | ancestry | 1 | 82945 | 1 | 3.373 | 24590.9 |
| 480 | 2025-03-31 15:57:45 | ancestry | 2 | 121059 | 6 | 18.156 | 6667.7 |
| 479 | 2025-03-30 12:23:56 | ancestry | 3 | 146162 | 26 | 6.123 | 23871.0 |
| 478 | 2025-03-23 13:19:22 | ancestry | 1 | 82945 | 1 | 7.173 | 11563.5 |
| 477 | 2025-03-13 12:36:57 | ancestry | 3 | 146162 | 26 | 37.296 | 3919.0 |
| 476 | 2025-03-12 21:32:23 | ancestry | 3 | 146162 | 26 | 48.363 | 3022.2 |
| 475 | 2025-03-12 00:24:10 | ancestry | 1 | 82945 | 1 | 6.563 | 12638.3 |
| 474 | 2025-03-11 21:25:14 | ancestry | 1 | 82945 | 1 | 6.360 | 13041.7 |
| 473 | 2025-03-11 20:21:07 | ancestry | 3 | 146162 | 26 | 34.770 | 4203.7 |
| 472 | 2025-03-11 20:21:01 | ancestry | 2 | 121059 | 6 | 25.876 | 4678.4 |
| 471 | 2025-03-11 00:04:22 | ancestry | 3 | 146162 | 26 | 19.713 | 7414.5 |
| 470 | 2025-03-10 22:16:25 | ancestry | 3 | 146162 | 26 | 34.533 | 4232.5 |
| 469 | 2025-03-10 21:55:01 | ancestry | 4 | 161609 | 354 | 56.706 | 2849.9 |
| 468 | 2025-03-10 21:54:53 | ancestry | 3 | 146162 | 26 | 40.613 | 3598.9 |
| 467 | 2025-03-10 21:54:49 | ancestry | 2 | 121059 | 6 | 26.893 | 4501.5 |
| 466 | 2025-03-10 21:46:58 | ancestry | 1 | 82945 | 1 | 1.516 | 54713.1 |
| 465 | 2025-03-07 08:01:58 | ancestry | 1 | 82945 | 1 | 4.923 | 16848.5 |
| 464 | 2025-02-07 20:43:03 | ancestry | 2 | 121059 | 6 | 3.703 | 32692.1 |
| 463 | 2025-02-07 14:46:58 | ancestry | 2 | 121059 | 6 | 9.970 | 12142.3 |
| 462 | 2025-02-05 06:39:31 | ancestry | 1 | 82945 | 1 | 5.403 | 15351.7 |
| 461 | 2025-02-05 00:32:56 | ancestry | 4 | 161609 | 354 | 73.236 | 2206.7 |
| 460 | 2025-02-04 22:39:45 | ancestry | 4 | 161609 | 354 | 61.720 | 2618.4 |
| 459 | 2025-02-04 17:06:40 | ancestry | 4 | 161609 | 354 | 45.000 | 3591.3 |
| 458 | 2025-02-04 15:07:36 | ancestry | 4 | 161609 | 354 | 60.740 | 2660.7 |
| 457 | 2025-02-04 15:07:37 | ancestry | 2 | 121059 | 6 | 18.483 | 6549.7 |
| 456 | 2025-02-03 19:44:23 | ancestry | 1 | 82945 | 1 | 9.203 | 9012.8 |
| 455 | 2025-01-27 19:55:53 | ancestry | 1 | 82945 | 1 | 4.143 | 20020.5 |
| 454 | 2025-01-17 03:20:04 | ancestry | 1 | 82945 | 1 | 10.610 | 7817.6 |
| 453 | 2025-01-09 16:24:18 | ancestry | 3 | 146162 | 26 | 19.750 | 7400.6 |
| 452 | 2025-01-07 23:50:01 | ancestry | 3 | 146162 | 26 | 12.066 | 12113.5 |
| 451 | 2025-01-03 06:22:29 | ancestry | 2 | 121059 | 6 | 18.423 | 6571.1 |
| 450 | 2025-01-03 04:41:14 | ancestry | 3 | 146162 | 26 | 25.000 | 5846.5 |
| 449 | 2024-12-30 21:13:35 | ancestry | 3 | 146162 | 26 | 13.576 | 10766.2 |
| 448 | 2024-12-30 21:13:34 | ancestry | 3 | 146162 | 26 | 7.986 | 18302.3 |
| 447 | 2024-12-30 21:13:36 | ancestry | 2 | 121059 | 6 | 3.986 | 30371.0 |
| 446 | 2024-12-30 16:29:43 | ancestry | 1 | 82945 | 1 | 7.016 | 11822.3 |
| 445 | 2024-12-30 06:34:07 | ancestry | 1 | 82945 | 1 | 3.533 | 23477.2 |
| 444 | 2024-12-17 00:09:54 | ancestry | 1 | 82945 | 1 | 10.346 | 8017.1 |
| 443 | 2024-12-01 18:55:12 | ancestry | 2 | 121059 | 6 | 25.936 | 4667.6 |
| 442 | 2024-12-01 18:53:56 | ancestry | 1 | 82945 | 1 | 7.030 | 11798.7 |
| 441 | 2024-11-29 01:51:11 | ancestry | 2 | 121059 | 6 | 12.766 | 9482.9 |
| 440 | 2024-11-28 21:25:28 | ancestry | 3 | 146162 | 26 | 36.236 | 4033.6 |
| 439 | 2024-11-28 21:24:22 | ancestry | 4 | 161609 | 354 | 19.940 | 8104.8 |
| 438 | 2024-11-28 07:15:15 | ancestry | 4 | 161609 | 354 | 40.486 | 3991.7 |
| 437 | 2024-11-26 09:03:10 | ancestry | 3 | 146162 | 26 | 6.733 | 21708.3 |
| 436 | 2024-11-26 09:02:33 | ancestry | 3 | 146162 | 26 | 9.063 | 16127.3 |
| 435 | 2024-11-26 04:46:59 | ancestry | 4 | 161609 | 354 | 49.426 | 3269.7 |
| 434 | 2024-11-26 04:47:02 | ancestry | 3 | 146162 | 26 | 31.766 | 4601.2 |
| 433 | 2024-11-26 04:47:01 | ancestry | 2 | 121059 | 6 | 16.906 | 7160.7 |
| 432 | 2024-11-26 04:41:57 | ancestry | 1 | 82945 | 1 | 1.516 | 54713.1 |
| 431 | 2024-11-03 09:27:16 | ancestry | 3 | 146162 | 26 | 17.846 | 8190.2 |
| 430 | 2024-10-29 20:20:47 | ancestry | 3 | 146162 | 26 | 42.750 | 3419.0 |
| 429 | 2024-10-29 20:20:45 | ancestry | 3 | 146162 | 26 | 33.826 | 4321.0 |
| 428 | 2024-10-29 20:21:07 | ancestry | 1 | 82945 | 1 | 8.110 | 10227.5 |
| 427 | 2024-10-29 20:20:47 | ancestry | 2 | 121059 | 6 | 18.016 | 6719.5 |
| 426 | 2024-10-28 04:07:03 | ancestry | 1 | 82945 | 1 | 7.076 | 11722.0 |
| 425 | 2024-10-28 02:58:05 | ancestry | 2 | 121059 | 6 | 6.546 | 18493.6 |