History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"songs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
566 | 2024-04-27 03:50:23 | songs | 1 | 28756 | 13 | 1.156 | 24875.4 |
565 | 2024-04-03 08:26:25 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
564 | 2024-04-03 08:26:19 | songs | 2 | 53800 | 242 | 1.936 | 27789.3 |
563 | 2024-04-03 03:48:11 | songs | 2 | 53800 | 242 | 5.780 | 9308.0 |
562 | 2024-04-03 02:29:04 | songs | 1 | 28756 | 13 | 1.736 | 16564.5 |
561 | 2024-04-01 14:19:10 | songs | 1 | 28756 | 13 | 0.530 | 54256.6 |
560 | 2024-03-30 20:52:28 | songs | 2 | 53800 | 242 | 6.563 | 8197.5 |
559 | 2024-03-30 20:49:58 | songs | 1 | 28756 | 13 | 1.190 | 24164.7 |
558 | 2024-03-27 03:24:06 | songs | 1 | 28756 | 13 | 2.326 | 12362.9 |
557 | 2024-03-04 00:54:18 | songs | 2 | 53800 | 242 | 4.750 | 11326.3 |
556 | 2024-03-04 00:51:49 | songs | 1 | 28756 | 13 | 1.186 | 24246.2 |
555 | 2024-02-25 17:56:25 | songs | 1 | 28756 | 13 | 1.783 | 16127.9 |
554 | 2024-01-25 22:53:49 | songs | 1 | 28756 | 13 | 0.546 | 52666.7 |
553 | 2023-12-23 02:24:17 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
552 | 2023-12-07 22:14:44 | songs | 1 | 28756 | 13 | 0.660 | 43569.7 |
551 | 2023-12-07 22:14:43 | songs | 1 | 28756 | 13 | 0.513 | 56054.6 |
550 | 2023-12-07 02:15:34 | songs | 2 | 53800 | 242 | 1.546 | 34799.5 |
549 | 2023-11-28 15:47:01 | songs | 2 | 53800 | 242 | 1.453 | 37026.8 |
548 | 2023-11-19 01:29:08 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
547 | 2023-11-10 15:42:22 | songs | 1 | 28756 | 13 | 0.470 | 61183.0 |
546 | 2023-10-30 21:35:21 | songs | 2 | 53800 | 242 | 1.626 | 33087.3 |
545 | 2023-10-25 23:34:31 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
544 | 2023-10-22 02:28:50 | songs | 1 | 28756 | 13 | 0.533 | 53951.2 |
543 | 2023-10-21 23:52:30 | songs | 2 | 53800 | 242 | 1.610 | 33416.1 |
542 | 2023-10-17 00:16:32 | songs | 1 | 28756 | 13 | 0.483 | 59536.2 |
541 | 2023-10-11 13:53:19 | songs | 1 | 28756 | 13 | 0.436 | 65954.1 |
540 | 2023-10-10 09:53:55 | songs | 1 | 28756 | 13 | 1.356 | 21206.5 |
539 | 2023-10-05 15:51:42 | songs | 1 | 28756 | 13 | 0.533 | 53951.2 |
538 | 2023-10-02 05:22:30 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
537 | 2023-09-29 17:25:46 | songs | 1 | 28756 | 13 | 0.903 | 31845.0 |
536 | 2023-08-05 04:30:41 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
535 | 2023-05-29 20:50:05 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
534 | 2023-05-07 05:04:36 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
533 | 2023-03-29 11:45:08 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
532 | 2023-02-28 16:41:31 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
531 | 2023-02-03 01:53:52 | songs | 1 | 28756 | 13 | 0.450 | 63902.2 |
530 | 2023-01-30 16:34:23 | songs | 1 | 28756 | 13 | 0.436 | 65954.1 |
529 | 2022-12-26 15:07:47 | songs | 1 | 28756 | 13 | 0.440 | 65354.5 |
528 | 2022-10-01 23:48:31 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
527 | 2022-09-14 04:48:38 | songs | 1 | 28756 | 13 | 0.533 | 53951.2 |
526 | 2022-08-06 10:17:02 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
525 | 2022-07-29 08:08:37 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
524 | 2022-07-19 09:33:22 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
523 | 2022-07-17 21:55:41 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
522 | 2022-06-26 08:05:04 | songs | 1 | 28756 | 13 | 0.470 | 61183.0 |
521 | 2022-06-08 22:11:54 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
520 | 2022-05-28 20:08:49 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
519 | 2022-03-27 13:58:42 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
518 | 2022-03-25 10:04:35 | songs | 1 | 28756 | 13 | 0.640 | 44931.3 |
517 | 2022-02-14 15:11:38 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
516 | 2022-02-12 13:22:40 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
515 | 2022-01-30 23:49:31 | songs | 1 | 28756 | 13 | 0.530 | 54256.6 |
514 | 2022-01-27 12:52:53 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
513 | 2021-12-27 01:59:04 | songs | 1 | 28756 | 13 | 0.466 | 61708.2 |
512 | 2021-12-25 10:15:01 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
511 | 2021-11-02 21:42:29 | songs | 1 | 28756 | 13 | 0.470 | 61183.0 |
510 | 2021-10-14 03:01:06 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
509 | 2021-10-10 20:56:11 | songs | 1 | 28756 | 13 | 0.466 | 61708.2 |
508 | 2021-09-26 15:06:47 | songs | 1 | 28756 | 13 | 0.513 | 56054.6 |
507 | 2021-09-24 12:19:04 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
506 | 2021-09-05 02:55:07 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
505 | 2021-07-09 04:46:12 | songs | 1 | 28756 | 13 | 0.470 | 61183.0 |
504 | 2021-05-28 12:07:59 | songs | 1 | 28756 | 13 | 0.610 | 47141.0 |
503 | 2021-05-02 18:19:51 | songs | 1 | 28756 | 13 | 0.656 | 43835.4 |
502 | 2021-04-05 07:29:28 | songs | 1 | 28756 | 13 | 0.530 | 54256.6 |
501 | 2021-04-01 03:56:52 | songs | 1 | 28756 | 13 | 0.466 | 61708.2 |
500 | 2021-02-23 21:34:57 | songs | 1 | 28756 | 13 | 0.470 | 61183.0 |
499 | 2021-02-09 15:20:30 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
498 | 2021-01-15 21:36:09 | songs | 1 | 28756 | 13 | 0.530 | 54256.6 |
497 | 2020-12-23 23:22:46 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
496 | 2020-12-15 10:11:44 | songs | 1 | 28756 | 13 | 0.513 | 56054.6 |
495 | 2020-10-26 12:21:21 | songs | 1 | 28756 | 13 | 0.530 | 54256.6 |
494 | 2020-10-22 10:47:31 | songs | 1 | 28756 | 13 | 1.063 | 27051.7 |
493 | 2020-10-21 12:39:12 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
492 | 2020-10-17 16:32:30 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
491 | 2020-10-06 14:41:40 | songs | 1 | 28756 | 13 | 0.466 | 61708.2 |
490 | 2020-09-20 02:10:43 | songs | 1 | 28756 | 13 | 0.483 | 59536.2 |
489 | 2020-08-11 13:19:44 | songs | 1 | 28756 | 13 | 0.470 | 61183.0 |
488 | 2020-08-08 08:39:01 | songs | 1 | 28756 | 13 | 0.513 | 56054.6 |
487 | 2020-07-31 21:47:24 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
486 | 2020-07-23 20:19:56 | songs | 1 | 28756 | 13 | 0.483 | 59536.2 |
485 | 2020-07-20 02:17:45 | songs | 1 | 28756 | 13 | 0.483 | 59536.2 |
484 | 2020-07-19 02:16:47 | songs | 1 | 28756 | 13 | 0.546 | 52666.7 |
483 | 2020-07-17 17:30:44 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
482 | 2020-06-09 17:40:20 | songs | 1 | 28756 | 13 | 0.516 | 55728.7 |
481 | 2020-05-15 02:29:35 | songs | 1 | 28756 | 13 | 0.500 | 57512.0 |
480 | 2020-05-02 05:04:01 | songs | 1 | 28756 | 13 | 0.546 | 52666.7 |
479 | 2020-03-25 14:26:24 | songs | 1 | 28756 | 13 | 0.453 | 63479.0 |
478 | 2020-03-25 08:00:41 | songs | 1 | 28756 | 13 | 0.530 | 54256.6 |
477 | 2020-03-24 01:58:29 | songs | 1 | 28756 | 13 | 0.533 | 53951.2 |
476 | 2020-03-22 21:17:41 | songs | 1 | 28756 | 13 | 0.470 | 61183.0 |
475 | 2020-03-21 09:25:20 | songs | 1 | 28756 | 13 | 0.546 | 52666.7 |
474 | 2020-03-18 07:25:13 | songs | 1 | 28756 | 13 | 0.906 | 31739.5 |
473 | 2020-03-08 08:18:56 | songs | 1 | 28756 | 13 | 0.436 | 65954.1 |
472 | 2020-03-05 07:25:23 | songs | 1 | 28756 | 13 | 0.563 | 51076.4 |
471 | 2020-02-26 10:48:31 | songs | 1 | 28756 | 13 | 0.456 | 63061.4 |
470 | 2020-02-21 11:41:09 | songs | 1 | 28756 | 13 | 1.203 | 23903.6 |
469 | 2020-02-21 08:46:16 | songs | 1 | 28756 | 13 | 0.563 | 51076.4 |
468 | 2020-02-18 23:15:45 | songs | 1 | 28756 | 13 | 0.596 | 48248.3 |
467 | 2020-02-13 22:23:55 | songs | 1 | 28756 | 13 | 0.530 | 54256.6 |