History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"happy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
551 | 2024-05-01 13:44:04 | happy | 3 | 83667 | 893 | 8.690 | 9628.0 |
550 | 2024-04-30 09:23:37 | happy | 1 | 28756 | 10 | 0.563 | 51076.4 |
549 | 2024-04-29 19:37:29 | happy | 1 | 28756 | 10 | 0.530 | 54256.6 |
548 | 2024-04-28 20:30:54 | happy | 3 | 83667 | 893 | 4.376 | 19119.5 |
547 | 2024-04-28 02:54:09 | happy | 1 | 28756 | 10 | 1.096 | 26237.2 |
546 | 2024-04-26 15:16:12 | happy | 3 | 83667 | 893 | 3.736 | 22394.8 |
545 | 2024-04-23 22:54:28 | happy | 1 | 28756 | 10 | 1.000 | 28756.0 |
544 | 2024-04-05 00:49:46 | happy | 1 | 28756 | 10 | 0.920 | 31256.5 |
543 | 2024-04-03 21:31:16 | happy | 2 | 53800 | 70 | 1.830 | 29398.9 |
542 | 2024-04-03 00:36:07 | happy | 1 | 28756 | 10 | 1.563 | 18398.0 |
541 | 2024-03-31 07:39:27 | happy | 1 | 28756 | 10 | 0.483 | 59536.2 |
540 | 2024-03-31 02:55:04 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
539 | 2024-03-29 01:47:27 | happy | 2 | 53800 | 70 | 3.046 | 17662.5 |
538 | 2024-03-29 01:47:25 | happy | 1 | 28756 | 10 | 1.643 | 17502.1 |
537 | 2024-03-29 01:46:56 | happy | 3 | 83667 | 893 | 8.766 | 9544.5 |
536 | 2024-03-28 23:43:04 | happy | 3 | 83667 | 893 | 11.640 | 7187.9 |
535 | 2024-03-28 23:43:04 | happy | 2 | 53800 | 70 | 3.720 | 14462.4 |
534 | 2024-03-28 23:24:43 | happy | 1 | 28756 | 10 | 0.563 | 51076.4 |
533 | 2024-03-03 21:16:17 | happy | 1 | 28756 | 10 | 0.483 | 59536.2 |
532 | 2024-02-28 16:51:34 | happy | 1 | 28756 | 10 | 0.610 | 47141.0 |
531 | 2024-02-27 20:08:15 | happy | 1 | 28756 | 10 | 1.033 | 27837.4 |
530 | 2024-02-15 13:53:34 | happy | 3 | 83667 | 893 | 3.796 | 22040.8 |
529 | 2024-02-05 03:09:42 | happy | 1 | 28756 | 10 | 1.030 | 27918.4 |
528 | 2024-02-01 07:48:05 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
527 | 2024-01-28 20:35:52 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
526 | 2024-01-28 17:34:13 | happy | 1 | 28756 | 10 | 0.983 | 29253.3 |
525 | 2023-12-20 01:13:27 | happy | 1 | 28756 | 10 | 0.530 | 54256.6 |
524 | 2023-12-08 06:18:31 | happy | 2 | 53800 | 70 | 1.470 | 36598.6 |
523 | 2023-12-03 07:36:12 | happy | 3 | 83667 | 893 | 3.266 | 25617.6 |
522 | 2023-12-03 07:36:10 | happy | 2 | 53800 | 70 | 1.436 | 37465.2 |
521 | 2023-12-01 14:49:58 | happy | 3 | 83667 | 893 | 4.826 | 17336.7 |
520 | 2023-12-01 14:50:00 | happy | 2 | 53800 | 70 | 2.763 | 19471.6 |
519 | 2023-12-01 10:29:04 | happy | 3 | 83667 | 893 | 3.783 | 22116.6 |
518 | 2023-11-29 04:12:50 | happy | 2 | 53800 | 70 | 1.516 | 35488.1 |
517 | 2023-11-29 04:12:47 | happy | 3 | 83667 | 893 | 3.750 | 22311.2 |
516 | 2023-11-16 16:33:34 | happy | 3 | 83667 | 893 | 3.263 | 25641.1 |
515 | 2023-11-10 05:40:23 | happy | 1 | 28756 | 10 | 0.483 | 59536.2 |
514 | 2023-11-10 02:51:01 | happy | 1 | 28756 | 10 | 0.423 | 67981.1 |
513 | 2023-11-03 10:10:36 | happy | 1 | 28756 | 10 | 0.440 | 65354.5 |
512 | 2023-10-22 05:04:55 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
511 | 2023-10-19 21:58:59 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
510 | 2023-10-13 08:48:59 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
509 | 2023-10-09 23:35:25 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
508 | 2023-10-07 09:29:22 | happy | 1 | 28756 | 10 | 0.436 | 65954.1 |
507 | 2023-10-06 16:48:47 | happy | 1 | 28756 | 10 | 0.513 | 56054.6 |
506 | 2023-10-03 16:32:20 | happy | 1 | 28756 | 10 | 0.516 | 55728.7 |
505 | 2023-09-26 14:19:25 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
504 | 2023-09-20 19:39:20 | happy | 1 | 28756 | 10 | 0.876 | 32826.5 |
503 | 2023-09-15 09:10:10 | happy | 2 | 53800 | 70 | 1.826 | 29463.3 |
502 | 2023-09-05 20:51:11 | happy | 2 | 53800 | 70 | 1.423 | 37807.4 |
501 | 2023-08-18 14:05:26 | happy | 3 | 83667 | 893 | 3.453 | 24230.2 |
500 | 2023-08-05 00:29:53 | happy | 1 | 28756 | 10 | 0.486 | 59168.7 |
499 | 2023-06-16 12:36:38 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
498 | 2023-05-18 11:20:28 | happy | 2 | 53800 | 70 | 1.360 | 39558.8 |
497 | 2023-05-02 19:36:01 | happy | 3 | 83667 | 893 | 3.326 | 25155.4 |
496 | 2023-04-29 06:09:59 | happy | 1 | 28756 | 10 | 0.440 | 65354.5 |
495 | 2023-02-28 18:03:55 | happy | 1 | 28756 | 10 | 0.486 | 59168.7 |
494 | 2023-02-25 19:36:46 | happy | 2 | 53800 | 70 | 1.546 | 34799.5 |
493 | 2023-02-19 06:29:19 | happy | 1 | 28756 | 10 | 0.486 | 59168.7 |
492 | 2023-02-09 14:29:13 | happy | 3 | 83667 | 893 | 3.376 | 24782.9 |
491 | 2023-02-06 01:36:03 | happy | 3 | 83667 | 893 | 3.233 | 25879.1 |
490 | 2022-12-18 12:41:04 | happy | 1 | 28756 | 10 | 0.436 | 65954.1 |
489 | 2022-12-06 14:41:29 | happy | 2 | 53800 | 70 | 1.343 | 40059.6 |
488 | 2022-11-18 13:59:00 | happy | 3 | 83667 | 893 | 4.033 | 20745.6 |
487 | 2022-11-08 09:37:39 | happy | 1 | 28756 | 10 | 0.436 | 65954.1 |
486 | 2022-09-18 15:01:05 | happy | 1 | 28756 | 10 | 0.436 | 65954.1 |
485 | 2022-09-14 23:17:11 | happy | 1 | 28756 | 10 | 0.436 | 65954.1 |
484 | 2022-08-26 05:57:19 | happy | 1 | 28756 | 10 | 0.440 | 65354.5 |
483 | 2022-08-14 05:42:20 | happy | 1 | 28756 | 10 | 0.436 | 65954.1 |
482 | 2022-08-05 22:14:19 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
481 | 2022-07-30 05:47:21 | happy | 1 | 28756 | 10 | 0.576 | 49923.6 |
480 | 2022-07-28 18:53:53 | happy | 1 | 28756 | 10 | 0.560 | 51350.0 |
479 | 2022-07-19 00:27:44 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
478 | 2022-07-10 23:34:23 | happy | 3 | 83667 | 893 | 3.250 | 25743.7 |
477 | 2022-07-03 12:23:18 | happy | 1 | 28756 | 10 | 0.470 | 61183.0 |
476 | 2022-06-29 08:22:06 | happy | 3 | 83667 | 893 | 3.343 | 25027.5 |
475 | 2022-06-21 15:02:30 | happy | 3 | 83667 | 893 | 3.266 | 25617.6 |
474 | 2022-06-16 12:21:37 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
473 | 2022-05-26 04:06:25 | happy | 1 | 28756 | 10 | 0.533 | 53951.2 |
472 | 2022-04-30 06:44:49 | happy | 1 | 28756 | 10 | 0.486 | 59168.7 |
471 | 2022-04-14 22:55:57 | happy | 2 | 53800 | 70 | 1.593 | 33772.8 |
470 | 2022-04-13 09:01:43 | happy | 1 | 28756 | 10 | 0.516 | 55728.7 |
469 | 2022-03-24 23:59:20 | happy | 1 | 28756 | 10 | 0.596 | 48248.3 |
468 | 2022-01-13 09:07:56 | happy | 1 | 28756 | 10 | 0.533 | 53951.2 |
467 | 2021-12-24 16:41:53 | happy | 2 | 53800 | 70 | 1.410 | 38156.0 |
466 | 2021-12-22 12:12:02 | happy | 1 | 28756 | 10 | 0.533 | 53951.2 |
465 | 2021-12-07 16:16:19 | happy | 1 | 28756 | 10 | 0.513 | 56054.6 |
464 | 2021-11-22 10:12:32 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
463 | 2021-11-13 14:17:24 | happy | 1 | 28756 | 10 | 0.563 | 51076.4 |
462 | 2021-11-11 09:25:31 | happy | 1 | 28756 | 10 | 0.516 | 55728.7 |
461 | 2021-10-01 03:02:08 | happy | 1 | 28756 | 10 | 0.453 | 63479.0 |
460 | 2021-08-29 16:06:08 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
459 | 2021-08-27 23:59:27 | happy | 1 | 28756 | 10 | 0.436 | 65954.1 |
458 | 2021-08-27 11:37:18 | happy | 1 | 28756 | 10 | 0.500 | 57512.0 |
457 | 2021-07-19 13:05:36 | happy | 3 | 83667 | 893 | 3.326 | 25155.4 |
456 | 2021-07-13 06:29:19 | happy | 3 | 83667 | 893 | 3.906 | 21420.1 |
455 | 2021-06-29 04:10:34 | happy | 1 | 28756 | 10 | 0.546 | 52666.7 |
454 | 2021-06-16 15:04:36 | happy | 1 | 28756 | 10 | 0.546 | 52666.7 |
453 | 2021-06-12 15:37:40 | happy | 3 | 83667 | 893 | 4.093 | 20441.5 |
452 | 2021-06-11 18:37:12 | happy | 3 | 83667 | 893 | 3.923 | 21327.3 |