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 |
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 |
424 | 2024-10-25 23:44:29 | ancestry | 3 | 146162 | 26 | 36.093 | 4049.6 |
423 | 2024-10-25 23:44:30 | ancestry | 2 | 121059 | 6 | 26.156 | 4628.3 |
422 | 2024-10-25 23:44:23 | ancestry | 1 | 82945 | 1 | 6.876 | 12063.0 |
421 | 2024-10-22 00:23:43 | ancestry | 3 | 146162 | 26 | 35.020 | 4173.7 |
420 | 2024-10-21 16:12:06 | ancestry | 3 | 146162 | 26 | 41.486 | 3523.2 |
419 | 2024-10-10 19:43:00 | ancestry | 2 | 121059 | 6 | 19.033 | 6360.5 |
418 | 2024-10-10 03:42:11 | ancestry | 3 | 146162 | 26 | 19.376 | 7543.5 |
417 | 2024-09-25 03:54:10 | ancestry | 3 | 146162 | 26 | 57.516 | 2541.2 |
416 | 2024-09-21 11:38:35 | ancestry | 3 | 146162 | 26 | 55.580 | 2629.8 |
415 | 2024-09-18 17:21:36 | ancestry | 3 | 146162 | 26 | 71.550 | 2042.8 |
414 | 2024-09-18 17:21:36 | ancestry | 2 | 121059 | 6 | 18.906 | 6403.2 |
413 | 2024-09-18 17:21:23 | ancestry | 1 | 82945 | 1 | 7.313 | 11342.1 |
412 | 2024-09-11 14:07:50 | ancestry | 1 | 82945 | 1 | 9.356 | 8865.4 |