History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"laura"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
535 | 2024-04-27 19:24:33 | laura | 1 | 28756 | 5 | 0.606 | 47452.1 |
534 | 2024-04-18 02:34:28 | laura | 1 | 28756 | 5 | 1.000 | 28756.0 |
533 | 2024-04-18 02:26:16 | laura | 1 | 28756 | 5 | 1.563 | 18398.0 |
532 | 2024-04-05 00:13:37 | laura | 3 | 83667 | 1175 | 7.280 | 11492.7 |
531 | 2024-04-04 11:05:41 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
530 | 2024-04-03 07:38:45 | laura | 3 | 83667 | 1175 | 13.953 | 5996.3 |
529 | 2024-04-03 07:38:45 | laura | 2 | 53800 | 73 | 1.893 | 28420.5 |
528 | 2024-04-03 07:30:39 | laura | 1 | 28756 | 5 | 0.483 | 59536.2 |
527 | 2024-03-30 22:08:42 | laura | 3 | 83667 | 1175 | 4.046 | 20678.9 |
526 | 2024-03-30 22:08:44 | laura | 2 | 53800 | 73 | 1.703 | 31591.3 |
525 | 2024-03-30 22:08:37 | laura | 1 | 28756 | 5 | 0.516 | 55728.7 |
524 | 2024-03-30 22:08:13 | laura | 3 | 83667 | 1175 | 8.970 | 9327.4 |
523 | 2024-03-30 22:08:16 | laura | 2 | 53800 | 73 | 3.313 | 16239.1 |
522 | 2024-03-30 22:08:03 | laura | 1 | 28756 | 5 | 1.190 | 24164.7 |
521 | 2024-03-29 18:01:45 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
520 | 2024-03-28 04:40:40 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
519 | 2024-03-19 22:36:59 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
518 | 2024-03-03 22:45:44 | laura | 1 | 28756 | 5 | 1.140 | 25224.6 |
517 | 2024-02-28 07:34:43 | laura | 1 | 28756 | 5 | 0.580 | 49579.3 |
516 | 2024-01-29 03:37:45 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
515 | 2024-01-11 15:07:05 | laura | 2 | 53800 | 73 | 2.736 | 19663.7 |
514 | 2024-01-04 05:33:54 | laura | 2 | 53800 | 73 | 1.610 | 33416.1 |
513 | 2023-12-26 15:14:33 | laura | 1 | 28756 | 5 | 0.500 | 57512.0 |
512 | 2023-12-26 01:03:10 | laura | 3 | 83667 | 1175 | 3.360 | 24900.9 |
511 | 2023-12-21 13:17:49 | laura | 3 | 83667 | 1175 | 3.766 | 22216.4 |
510 | 2023-12-21 13:17:48 | laura | 2 | 53800 | 73 | 1.640 | 32804.9 |
509 | 2023-12-13 08:39:01 | laura | 3 | 83667 | 1175 | 3.860 | 21675.4 |
508 | 2023-12-12 18:18:22 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
507 | 2023-12-08 12:28:48 | laura | 3 | 83667 | 1175 | 4.563 | 18336.0 |
506 | 2023-12-08 12:28:42 | laura | 3 | 83667 | 1175 | 5.626 | 14871.5 |
505 | 2023-12-08 12:24:07 | laura | 3 | 83667 | 1175 | 8.670 | 9650.2 |
504 | 2023-12-04 17:32:52 | laura | 2 | 53800 | 73 | 1.686 | 31909.8 |
503 | 2023-12-04 17:32:48 | laura | 3 | 83667 | 1175 | 3.953 | 21165.4 |
502 | 2023-11-14 16:42:09 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
501 | 2023-11-12 03:04:55 | laura | 1 | 28756 | 5 | 0.516 | 55728.7 |
500 | 2023-11-10 19:37:22 | laura | 1 | 28756 | 5 | 0.530 | 54256.6 |
499 | 2023-11-03 05:39:47 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
498 | 2023-10-30 20:39:28 | laura | 2 | 53800 | 73 | 1.890 | 28465.6 |
497 | 2023-10-23 03:09:20 | laura | 1 | 28756 | 5 | 0.456 | 63061.4 |
496 | 2023-10-20 08:28:55 | laura | 2 | 53800 | 73 | 1.406 | 38264.6 |
495 | 2023-10-18 15:36:06 | laura | 1 | 28756 | 5 | 0.890 | 32310.1 |
494 | 2023-10-15 08:45:01 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
493 | 2023-10-13 17:38:43 | laura | 1 | 28756 | 5 | 0.470 | 61183.0 |
492 | 2023-10-05 19:13:13 | laura | 1 | 28756 | 5 | 0.470 | 61183.0 |
491 | 2023-10-04 13:57:57 | laura | 3 | 83667 | 1175 | 6.940 | 12055.8 |
490 | 2023-10-01 08:44:26 | laura | 3 | 83667 | 1175 | 4.143 | 20194.8 |
489 | 2023-09-28 23:52:41 | laura | 3 | 83667 | 1175 | 3.453 | 24230.2 |
488 | 2023-09-24 16:32:22 | laura | 1 | 28756 | 5 | 0.486 | 59168.7 |
487 | 2023-09-23 06:23:14 | laura | 1 | 28756 | 5 | 0.500 | 57512.0 |
486 | 2023-09-17 01:24:24 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
485 | 2023-08-26 17:16:07 | laura | 1 | 28756 | 5 | 0.500 | 57512.0 |
484 | 2023-08-10 22:02:17 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
483 | 2023-07-14 16:10:32 | laura | 3 | 83667 | 1175 | 3.406 | 24564.6 |
482 | 2023-07-10 07:17:38 | laura | 3 | 83667 | 1175 | 3.360 | 24900.9 |
481 | 2023-06-11 10:45:11 | laura | 3 | 83667 | 1175 | 3.340 | 25050.0 |
480 | 2023-05-20 13:35:05 | laura | 3 | 83667 | 1175 | 3.420 | 24464.0 |
479 | 2023-05-11 13:45:46 | laura | 1 | 28756 | 5 | 0.440 | 65354.5 |
478 | 2023-05-09 10:05:21 | laura | 1 | 28756 | 5 | 0.500 | 57512.0 |
477 | 2023-04-08 19:28:57 | laura | 2 | 53800 | 73 | 1.390 | 38705.0 |
476 | 2023-03-31 18:38:08 | laura | 3 | 83667 | 1175 | 3.783 | 22116.6 |
475 | 2023-03-28 10:54:53 | laura | 3 | 83667 | 1175 | 3.783 | 22116.6 |
474 | 2023-03-06 22:25:33 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
473 | 2023-02-04 17:13:33 | laura | 3 | 83667 | 1175 | 3.466 | 24139.4 |
472 | 2023-01-27 04:18:36 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
471 | 2023-01-24 03:05:19 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
470 | 2023-01-14 18:07:28 | laura | 2 | 53800 | 73 | 1.390 | 38705.0 |
469 | 2022-12-29 14:19:44 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
468 | 2022-12-28 16:57:26 | laura | 3 | 83667 | 1175 | 4.140 | 20209.4 |
467 | 2022-12-19 14:13:53 | laura | 3 | 83667 | 1175 | 3.576 | 23396.8 |
466 | 2022-12-09 20:52:35 | laura | 1 | 28756 | 5 | 0.486 | 59168.7 |
465 | 2022-11-29 02:22:53 | laura | 1 | 28756 | 5 | 0.873 | 32939.3 |
464 | 2022-11-27 20:39:31 | laura | 3 | 83667 | 1175 | 3.796 | 22040.8 |
463 | 2022-11-23 01:17:26 | laura | 1 | 28756 | 5 | 0.500 | 57512.0 |
462 | 2022-11-17 23:27:14 | laura | 3 | 83667 | 1175 | 3.440 | 24321.8 |
461 | 2022-11-16 02:49:25 | laura | 3 | 83667 | 1175 | 3.296 | 25384.4 |
460 | 2022-11-13 06:27:02 | laura | 3 | 83667 | 1175 | 3.873 | 21602.6 |
459 | 2022-11-05 11:22:42 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
458 | 2022-11-02 07:07:15 | laura | 3 | 83667 | 1175 | 3.280 | 25508.2 |
457 | 2022-10-31 01:49:47 | laura | 3 | 83667 | 1175 | 3.296 | 25384.4 |
456 | 2022-10-31 00:39:30 | laura | 3 | 83667 | 1175 | 3.326 | 25155.4 |
455 | 2022-10-28 01:36:15 | laura | 3 | 83667 | 1175 | 3.326 | 25155.4 |
454 | 2022-10-27 09:48:20 | laura | 2 | 53800 | 73 | 1.376 | 39098.8 |
453 | 2022-10-12 21:36:17 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
452 | 2022-10-02 13:27:35 | laura | 3 | 83667 | 1175 | 3.796 | 22040.8 |
451 | 2022-09-17 15:47:08 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
450 | 2022-09-12 06:53:25 | laura | 1 | 28756 | 5 | 0.500 | 57512.0 |
449 | 2022-08-30 11:31:05 | laura | 3 | 83667 | 1175 | 4.063 | 20592.4 |
448 | 2022-08-06 22:43:03 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
447 | 2022-07-07 16:20:40 | laura | 3 | 83667 | 1175 | 3.813 | 21942.6 |
446 | 2022-07-03 09:04:20 | laura | 1 | 28756 | 5 | 0.453 | 63479.0 |
445 | 2022-07-01 08:46:42 | laura | 1 | 28756 | 5 | 0.440 | 65354.5 |
444 | 2022-06-22 13:47:11 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
443 | 2022-06-16 09:02:37 | laura | 1 | 28756 | 5 | 0.436 | 65954.1 |
442 | 2022-06-15 16:48:15 | laura | 1 | 28756 | 5 | 0.483 | 59536.2 |
441 | 2022-06-04 19:37:21 | laura | 3 | 83667 | 1175 | 3.296 | 25384.4 |
440 | 2022-05-28 15:10:35 | laura | 2 | 53800 | 73 | 1.390 | 38705.0 |
439 | 2022-05-26 13:16:59 | laura | 1 | 28756 | 5 | 0.500 | 57512.0 |
438 | 2022-05-19 17:23:38 | laura | 3 | 83667 | 1175 | 3.563 | 23482.2 |
437 | 2022-05-06 03:13:07 | laura | 3 | 83667 | 1175 | 3.423 | 24442.6 |
436 | 2022-04-24 17:15:46 | laura | 3 | 83667 | 1175 | 3.893 | 21491.7 |