History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"video"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
553 | 2024-04-03 06:42:46 | video | 1 | 28756 | 4 | 0.560 | 51350.0 |
552 | 2024-04-03 05:17:05 | video | 3 | 83667 | 1027 | 11.440 | 7313.5 |
551 | 2024-04-01 16:58:06 | video | 3 | 83667 | 1027 | 7.483 | 11180.9 |
550 | 2024-04-01 16:58:05 | video | 2 | 53800 | 74 | 3.703 | 14528.8 |
549 | 2024-04-01 16:57:55 | video | 1 | 28756 | 4 | 1.530 | 18794.8 |
548 | 2024-03-31 15:43:17 | video | 1 | 28756 | 4 | 0.500 | 57512.0 |
547 | 2024-03-29 03:07:38 | video | 3 | 83667 | 1027 | 4.360 | 19189.7 |
546 | 2024-03-29 03:07:39 | video | 2 | 53800 | 74 | 1.783 | 30173.9 |
545 | 2024-03-29 03:07:33 | video | 1 | 28756 | 4 | 0.486 | 59168.7 |
544 | 2024-03-29 03:07:22 | video | 3 | 83667 | 1027 | 4.170 | 20064.0 |
543 | 2024-03-29 03:07:23 | video | 2 | 53800 | 74 | 1.766 | 30464.3 |
542 | 2024-03-29 03:07:20 | video | 1 | 28756 | 4 | 1.000 | 28756.0 |
541 | 2024-03-04 00:17:50 | video | 2 | 53800 | 74 | 5.406 | 9951.9 |
540 | 2024-03-04 00:17:48 | video | 3 | 83667 | 1027 | 4.440 | 18843.9 |
539 | 2024-03-04 00:11:38 | video | 1 | 28756 | 4 | 0.593 | 48492.4 |
538 | 2024-03-01 13:09:14 | video | 1 | 28756 | 4 | 0.483 | 59536.2 |
537 | 2024-02-27 20:12:02 | video | 1 | 28756 | 4 | 0.466 | 61708.2 |
536 | 2024-01-29 08:07:11 | video | 1 | 28756 | 4 | 0.423 | 67981.1 |
535 | 2024-01-28 18:08:05 | video | 1 | 28756 | 4 | 0.846 | 33990.5 |
534 | 2024-01-14 23:18:49 | video | 2 | 53800 | 74 | 2.690 | 20000.0 |
533 | 2024-01-14 23:16:16 | video | 3 | 83667 | 1027 | 3.906 | 21420.1 |
532 | 2024-01-11 15:24:44 | video | 3 | 83667 | 1027 | 3.780 | 22134.1 |
531 | 2024-01-03 14:12:49 | video | 1 | 28756 | 4 | 0.466 | 61708.2 |
530 | 2023-12-26 05:00:10 | video | 2 | 53800 | 74 | 1.560 | 34487.2 |
529 | 2023-12-26 03:18:33 | video | 3 | 83667 | 1027 | 3.593 | 23286.1 |
528 | 2023-12-16 02:28:58 | video | 3 | 83667 | 1027 | 3.423 | 24442.6 |
527 | 2023-12-16 02:28:59 | video | 2 | 53800 | 74 | 1.530 | 35163.4 |
526 | 2023-11-16 14:18:58 | video | 1 | 28756 | 4 | 0.856 | 33593.5 |
525 | 2023-11-15 03:00:28 | video | 3 | 83667 | 1027 | 3.970 | 21074.8 |
524 | 2023-11-15 03:00:30 | video | 2 | 53800 | 74 | 1.640 | 32804.9 |
523 | 2023-11-12 09:39:15 | video | 1 | 28756 | 4 | 0.500 | 57512.0 |
522 | 2023-11-11 23:43:55 | video | 1 | 28756 | 4 | 0.466 | 61708.2 |
521 | 2023-11-01 21:24:15 | video | 1 | 28756 | 4 | 0.453 | 63479.0 |
520 | 2023-10-24 09:31:01 | video | 1 | 28756 | 4 | 0.983 | 29253.3 |
519 | 2023-10-21 10:15:41 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
518 | 2023-10-18 11:41:47 | video | 1 | 28756 | 4 | 0.486 | 59168.7 |
517 | 2023-10-13 14:56:31 | video | 1 | 28756 | 4 | 0.486 | 59168.7 |
516 | 2023-09-26 05:59:53 | video | 1 | 28756 | 4 | 0.483 | 59536.2 |
515 | 2023-09-13 12:27:02 | video | 1 | 28756 | 4 | 0.423 | 67981.1 |
514 | 2023-08-19 00:32:49 | video | 1 | 28756 | 4 | 0.423 | 67981.1 |
513 | 2023-08-16 02:10:04 | video | 1 | 28756 | 4 | 0.423 | 67981.1 |
512 | 2023-07-15 00:19:44 | video | 1 | 28756 | 4 | 0.470 | 61183.0 |
511 | 2023-06-26 05:10:53 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
510 | 2023-05-19 15:34:36 | video | 1 | 28756 | 4 | 0.423 | 67981.1 |
509 | 2023-03-15 06:49:47 | video | 1 | 28756 | 4 | 0.453 | 63479.0 |
508 | 2023-03-03 01:54:50 | video | 1 | 28756 | 4 | 0.423 | 67981.1 |
507 | 2023-02-07 17:54:51 | video | 1 | 28756 | 4 | 0.470 | 61183.0 |
506 | 2023-01-03 20:47:28 | video | 1 | 28756 | 4 | 0.423 | 67981.1 |
505 | 2022-09-26 09:10:26 | video | 1 | 28756 | 4 | 0.470 | 61183.0 |
504 | 2022-09-19 21:13:28 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
503 | 2022-09-18 15:50:05 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
502 | 2022-09-17 18:11:04 | video | 1 | 28756 | 4 | 0.466 | 61708.2 |
501 | 2022-09-12 06:21:48 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
500 | 2022-09-10 15:11:22 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
499 | 2022-08-31 02:34:59 | video | 1 | 28756 | 4 | 0.470 | 61183.0 |
498 | 2022-04-28 12:53:11 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
497 | 2021-12-20 06:41:48 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
496 | 2021-08-17 15:49:06 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
495 | 2021-06-27 22:22:58 | video | 1 | 28756 | 4 | 0.440 | 65354.5 |
494 | 2021-05-03 09:07:15 | video | 1 | 28756 | 4 | 0.483 | 59536.2 |
493 | 2021-04-29 17:25:26 | video | 1 | 28756 | 4 | 0.936 | 30722.2 |
492 | 2021-04-09 17:27:22 | video | 1 | 28756 | 4 | 0.483 | 59536.2 |
491 | 2021-02-27 14:47:57 | video | 3 | 83667 | 1027 | 3.313 | 25254.2 |
490 | 2021-02-18 20:33:43 | video | 3 | 83667 | 1027 | 3.673 | 22778.9 |
489 | 2021-02-12 04:07:16 | video | 1 | 28756 | 4 | 0.466 | 61708.2 |
488 | 2021-01-24 08:32:53 | video | 1 | 28756 | 4 | 0.546 | 52666.7 |
487 | 2021-01-23 08:50:25 | video | 3 | 83667 | 1027 | 3.530 | 23701.7 |
486 | 2021-01-13 19:07:16 | video | 1 | 28756 | 4 | 0.500 | 57512.0 |
485 | 2020-12-24 19:20:57 | video | 3 | 83667 | 1027 | 3.250 | 25743.7 |
484 | 2020-10-31 01:50:47 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
483 | 2020-10-24 12:09:26 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
482 | 2020-10-09 21:02:31 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
481 | 2020-10-03 19:22:20 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
480 | 2020-08-10 04:58:46 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
479 | 2020-06-10 15:01:29 | video | 1 | 28756 | 4 | 0.436 | 65954.1 |
478 | 2020-06-09 06:17:51 | video | 1 | 28756 | 4 | 0.420 | 68466.7 |
477 | 2020-03-28 21:32:25 | video | 1 | 28756 | 4 | 0.500 | 57512.0 |
476 | 2020-03-26 21:00:00 | video | 1 | 28756 | 4 | 1.000 | 28756.0 |
475 | 2020-03-25 12:20:12 | video | 1 | 28756 | 4 | 0.673 | 42728.1 |
474 | 2020-03-23 01:31:41 | video | 1 | 28756 | 4 | 0.496 | 57975.8 |
473 | 2020-03-21 23:23:32 | video | 1 | 28756 | 4 | 0.500 | 57512.0 |
472 | 2020-03-20 18:46:03 | video | 1 | 28756 | 4 | 0.440 | 65354.5 |
471 | 2020-03-18 08:16:07 | video | 1 | 28756 | 4 | 0.516 | 55728.7 |
470 | 2020-02-26 09:06:38 | video | 1 | 28756 | 4 | 0.596 | 48248.3 |
469 | 2020-02-26 02:50:37 | video | 1 | 28756 | 4 | 0.530 | 54256.6 |
468 | 2020-02-17 21:53:21 | video | 1 | 28756 | 4 | 0.530 | 54256.6 |
467 | 2020-02-11 23:15:09 | video | 1 | 28756 | 4 | 1.670 | 17219.2 |
466 | 2020-02-02 20:17:11 | video | 1 | 28756 | 4 | 1.093 | 26309.2 |
465 | 2020-02-02 05:26:38 | video | 1 | 28756 | 4 | 0.533 | 53951.2 |
464 | 2020-02-02 02:51:26 | video | 1 | 28756 | 4 | 0.483 | 59536.2 |
463 | 2020-02-01 13:04:55 | video | 1 | 28756 | 4 | 0.623 | 46157.3 |
462 | 2020-02-01 03:33:25 | video | 1 | 28756 | 4 | 0.500 | 57512.0 |
461 | 2020-01-27 14:11:16 | video | 1 | 28756 | 4 | 1.000 | 28756.0 |
460 | 2020-01-26 14:25:02 | video | 1 | 28756 | 4 | 0.466 | 61708.2 |
459 | 2020-01-25 12:16:44 | video | 1 | 28756 | 4 | 1.063 | 27051.7 |
458 | 2020-01-21 19:27:52 | video | 1 | 28756 | 4 | 0.750 | 38341.3 |
457 | 2020-01-13 10:12:14 | video | 1 | 28756 | 4 | 0.483 | 59536.2 |
456 | 2020-01-12 11:34:53 | video | 1 | 28756 | 4 | 1.016 | 28303.1 |
455 | 2020-01-11 03:22:43 | video | 1 | 28756 | 4 | 0.513 | 56054.6 |
454 | 2020-01-05 03:50:42 | video | 1 | 28756 | 4 | 0.500 | 57512.0 |