History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roger"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
557 | 2024-03-18 02:54:18 | roger | 1 | 28756 | 5 | 0.936 | 30722.2 |
556 | 2024-03-08 00:46:54 | roger | 2 | 53800 | 235 | 2.360 | 22796.6 |
555 | 2024-03-07 09:20:49 | roger | 2 | 53800 | 235 | 5.920 | 9087.8 |
554 | 2024-03-07 04:22:01 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
553 | 2024-03-02 02:02:36 | roger | 1 | 28756 | 5 | 0.580 | 49579.3 |
552 | 2024-02-28 07:06:33 | roger | 1 | 28756 | 5 | 0.750 | 38341.3 |
551 | 2024-02-14 16:49:50 | roger | 1 | 28756 | 5 | 0.576 | 49923.6 |
550 | 2024-02-03 22:05:47 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
549 | 2024-01-30 09:04:31 | roger | 2 | 53800 | 235 | 1.703 | 31591.3 |
548 | 2024-01-29 03:18:53 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
547 | 2024-01-17 03:21:27 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
546 | 2024-01-16 04:48:29 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
545 | 2024-01-14 23:49:09 | roger | 1 | 28756 | 5 | 0.673 | 42728.1 |
544 | 2024-01-14 04:35:12 | roger | 1 | 28756 | 5 | 0.486 | 59168.7 |
543 | 2024-01-12 14:22:22 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
542 | 2024-01-11 15:07:13 | roger | 1 | 28756 | 5 | 0.640 | 44931.3 |
541 | 2024-01-10 18:54:46 | roger | 1 | 28756 | 5 | 0.580 | 49579.3 |
540 | 2024-01-09 20:03:33 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
539 | 2024-01-09 15:24:06 | roger | 1 | 28756 | 5 | 0.486 | 59168.7 |
538 | 2024-01-08 21:03:43 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
537 | 2024-01-06 23:50:30 | roger | 1 | 28756 | 5 | 0.563 | 51076.4 |
536 | 2024-01-02 01:47:36 | roger | 1 | 28756 | 5 | 0.750 | 38341.3 |
535 | 2023-12-31 21:06:49 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
534 | 2023-12-30 20:36:22 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
533 | 2023-12-24 20:00:42 | roger | 1 | 28756 | 5 | 0.450 | 63902.2 |
532 | 2023-12-23 20:13:00 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
531 | 2023-12-22 18:10:32 | roger | 1 | 28756 | 5 | 0.470 | 61183.0 |
530 | 2023-12-16 18:36:24 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
529 | 2023-12-15 19:28:02 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
528 | 2023-12-14 18:34:34 | roger | 1 | 28756 | 5 | 0.470 | 61183.0 |
527 | 2023-12-13 18:53:50 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
526 | 2023-12-12 01:33:13 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
525 | 2023-12-10 21:49:20 | roger | 1 | 28756 | 5 | 1.110 | 25906.3 |
524 | 2023-12-10 05:38:58 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
523 | 2023-12-06 04:49:36 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
522 | 2023-12-05 06:36:32 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
521 | 2023-12-04 01:29:55 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
520 | 2023-12-03 05:05:50 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
519 | 2023-12-03 05:05:49 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
518 | 2023-12-02 21:15:38 | roger | 1 | 28756 | 5 | 0.656 | 43835.4 |
517 | 2023-12-01 20:20:51 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
516 | 2023-11-30 06:55:00 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
515 | 2023-11-29 09:06:05 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
514 | 2023-11-28 05:25:30 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
513 | 2023-11-21 16:39:19 | roger | 1 | 28756 | 5 | 0.456 | 63061.4 |
512 | 2023-11-15 02:16:24 | roger | 2 | 53800 | 235 | 1.703 | 31591.3 |
511 | 2023-11-13 11:08:38 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
510 | 2023-11-12 13:08:25 | roger | 1 | 28756 | 5 | 0.486 | 59168.7 |
509 | 2023-11-12 12:20:00 | roger | 2 | 53800 | 235 | 1.766 | 30464.3 |
508 | 2023-11-12 11:58:30 | roger | 2 | 53800 | 235 | 1.393 | 38621.7 |
507 | 2023-11-11 14:26:32 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
506 | 2023-11-07 22:31:50 | roger | 2 | 53800 | 235 | 1.403 | 38346.4 |
505 | 2023-11-04 14:09:29 | roger | 1 | 28756 | 5 | 1.046 | 27491.4 |
504 | 2023-10-21 08:59:30 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
503 | 2023-10-18 08:01:26 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
502 | 2023-10-13 19:00:40 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
501 | 2023-10-05 22:04:53 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
500 | 2023-10-04 04:36:05 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
499 | 2023-10-03 04:04:44 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
498 | 2023-10-02 19:13:43 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
497 | 2023-09-29 03:58:50 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
496 | 2023-09-24 21:54:46 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
495 | 2023-09-23 23:58:36 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
494 | 2023-08-13 03:27:00 | roger | 2 | 53800 | 235 | 1.423 | 37807.4 |
493 | 2023-07-18 02:17:24 | roger | 1 | 28756 | 5 | 0.450 | 63902.2 |
492 | 2023-07-09 08:45:00 | roger | 1 | 28756 | 5 | 0.533 | 53951.2 |
491 | 2023-04-27 08:57:37 | roger | 2 | 53800 | 235 | 1.733 | 31044.4 |
490 | 2023-04-20 18:57:37 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
489 | 2023-03-15 12:07:01 | roger | 1 | 28756 | 5 | 1.033 | 27837.4 |
488 | 2023-02-11 20:36:37 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
487 | 2023-01-31 06:07:57 | roger | 2 | 53800 | 235 | 1.656 | 32487.9 |
486 | 2022-12-09 03:45:28 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
485 | 2022-11-20 16:03:04 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
484 | 2022-11-12 17:08:53 | roger | 2 | 53800 | 235 | 1.420 | 37887.3 |
483 | 2022-09-19 23:55:15 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
482 | 2022-09-12 09:09:17 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
481 | 2022-08-16 18:59:31 | roger | 1 | 28756 | 5 | 1.060 | 27128.3 |
480 | 2022-08-14 20:48:03 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
479 | 2022-08-10 18:54:18 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
478 | 2022-08-07 00:13:51 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
477 | 2022-07-30 01:41:30 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
476 | 2022-07-29 05:00:25 | roger | 1 | 28756 | 5 | 0.436 | 65954.1 |
475 | 2022-07-11 02:42:16 | roger | 2 | 53800 | 235 | 1.423 | 37807.4 |
474 | 2022-07-07 20:32:39 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
473 | 2022-07-03 09:50:17 | roger | 1 | 28756 | 5 | 0.470 | 61183.0 |
472 | 2022-06-16 09:48:47 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
471 | 2022-06-15 16:58:30 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
470 | 2022-06-14 12:47:09 | roger | 2 | 53800 | 235 | 1.580 | 34050.6 |
469 | 2022-04-05 18:57:11 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
468 | 2022-04-04 09:10:58 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
467 | 2022-03-25 00:29:37 | roger | 1 | 28756 | 5 | 0.593 | 48492.4 |
466 | 2022-01-10 05:00:19 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |
465 | 2022-01-08 01:24:25 | roger | 1 | 28756 | 5 | 0.550 | 52283.6 |
464 | 2021-12-12 05:58:22 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
463 | 2021-11-10 09:02:18 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
462 | 2021-09-30 02:13:01 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
461 | 2021-09-10 22:20:29 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
460 | 2021-08-29 08:54:36 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
459 | 2021-06-22 17:30:44 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
458 | 2021-05-25 07:00:58 | roger | 1 | 28756 | 5 | 0.500 | 57512.0 |