History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"captions"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
544 | 2024-04-30 02:38:56 | captions | 1 | 82945 | 5 | 4.000 | 20736.3 |
543 | 2024-04-29 11:02:15 | captions | 1 | 82945 | 5 | 5.580 | 14864.7 |
542 | 2024-04-27 02:45:59 | captions | 1 | 82945 | 5 | 2.093 | 39629.7 |
541 | 2024-04-06 07:08:42 | captions | 3 | 146162 | 287 | 25.470 | 5738.6 |
540 | 2024-04-05 08:45:14 | captions | 3 | 146162 | 287 | 10.610 | 13775.9 |
539 | 2024-04-05 08:45:11 | captions | 2 | 121059 | 35 | 10.656 | 11360.6 |
538 | 2024-04-05 08:45:08 | captions | 1 | 82945 | 5 | 3.390 | 24467.6 |
537 | 2024-03-31 22:06:22 | captions | 3 | 146162 | 287 | 13.563 | 10776.5 |
536 | 2024-03-30 21:14:12 | captions | 2 | 121059 | 35 | 10.593 | 11428.2 |
535 | 2024-03-30 21:06:09 | captions | 3 | 146162 | 287 | 13.563 | 10776.5 |
534 | 2024-03-30 08:07:47 | captions | 3 | 146162 | 287 | 7.983 | 18309.2 |
533 | 2024-03-30 07:36:48 | captions | 3 | 146162 | 287 | 15.580 | 9381.4 |
532 | 2024-03-30 07:36:49 | captions | 2 | 121059 | 35 | 10.016 | 12086.6 |
531 | 2024-03-30 07:31:10 | captions | 1 | 82945 | 5 | 1.483 | 55930.5 |
530 | 2024-03-06 22:34:44 | captions | 1 | 82945 | 5 | 3.190 | 26001.6 |
529 | 2024-02-28 21:53:35 | captions | 1 | 82945 | 5 | 1.576 | 52630.1 |
528 | 2024-01-12 20:09:36 | captions | 1 | 82945 | 5 | 1.486 | 55817.6 |
527 | 2024-01-09 08:52:49 | captions | 2 | 121059 | 35 | 3.670 | 32986.1 |
526 | 2024-01-06 12:44:07 | captions | 3 | 146162 | 287 | 7.546 | 19369.5 |
525 | 2024-01-06 12:44:09 | captions | 2 | 121059 | 35 | 4.140 | 29241.3 |
524 | 2023-11-27 03:44:08 | captions | 1 | 82945 | 5 | 1.530 | 54212.4 |
523 | 2023-11-22 23:29:03 | captions | 1 | 82945 | 5 | 1.486 | 55817.6 |
522 | 2023-11-08 02:28:21 | captions | 1 | 82945 | 5 | 1.390 | 59672.7 |
521 | 2023-11-01 06:03:23 | captions | 1 | 82945 | 5 | 1.326 | 62552.8 |
520 | 2023-10-31 13:59:08 | captions | 1 | 82945 | 5 | 1.406 | 58993.6 |
519 | 2023-10-24 21:50:50 | captions | 1 | 82945 | 5 | 1.483 | 55930.5 |
518 | 2023-10-24 14:22:07 | captions | 1 | 82945 | 5 | 1.360 | 60989.0 |
517 | 2023-10-16 14:35:56 | captions | 2 | 121059 | 35 | 3.640 | 33258.0 |
516 | 2023-10-15 12:32:42 | captions | 1 | 82945 | 5 | 1.483 | 55930.5 |
515 | 2023-10-12 01:53:37 | captions | 1 | 82945 | 5 | 1.516 | 54713.1 |
514 | 2023-10-06 14:39:29 | captions | 1 | 82945 | 5 | 1.283 | 64649.3 |
513 | 2023-09-25 17:14:56 | captions | 1 | 82945 | 5 | 1.343 | 61761.0 |
512 | 2023-09-14 20:54:10 | captions | 1 | 82945 | 5 | 1.470 | 56425.2 |
511 | 2023-08-27 07:59:30 | captions | 1 | 82945 | 5 | 1.423 | 58288.8 |
510 | 2023-07-27 10:09:30 | captions | 2 | 121059 | 35 | 3.216 | 37642.7 |
509 | 2023-07-02 10:37:21 | captions | 1 | 82945 | 5 | 1.483 | 55930.5 |
508 | 2023-06-01 00:56:57 | captions | 1 | 82945 | 5 | 1.346 | 61623.3 |
507 | 2023-04-05 22:22:27 | captions | 2 | 121059 | 35 | 3.203 | 37795.5 |
506 | 2023-03-28 00:32:08 | captions | 1 | 82945 | 5 | 1.483 | 55930.5 |
505 | 2023-03-25 23:41:29 | captions | 1 | 82945 | 5 | 1.326 | 62552.8 |
504 | 2023-02-03 22:56:34 | captions | 1 | 82945 | 5 | 1.296 | 64000.8 |
503 | 2023-01-11 02:35:47 | captions | 1 | 82945 | 5 | 1.296 | 64000.8 |
502 | 2023-01-02 19:12:15 | captions | 2 | 121059 | 35 | 3.470 | 34887.3 |
501 | 2022-12-20 20:51:27 | captions | 1 | 82945 | 5 | 1.313 | 63172.1 |
500 | 2022-12-18 21:46:14 | captions | 1 | 82945 | 5 | 1.266 | 65517.4 |
499 | 2022-11-08 02:46:11 | captions | 1 | 82945 | 5 | 1.453 | 57085.3 |
498 | 2022-10-16 15:02:37 | captions | 1 | 82945 | 5 | 1.280 | 64800.8 |
497 | 2022-09-14 11:34:45 | captions | 1 | 82945 | 5 | 1.500 | 55296.7 |
496 | 2022-09-07 20:50:19 | captions | 2 | 121059 | 35 | 3.453 | 35059.1 |
495 | 2022-09-01 18:10:02 | captions | 1 | 82945 | 5 | 1.436 | 57761.1 |
494 | 2022-08-31 02:10:38 | captions | 1 | 82945 | 5 | 1.330 | 62364.7 |
493 | 2022-08-28 07:19:41 | captions | 1 | 82945 | 5 | 1.406 | 58993.6 |
492 | 2022-08-27 19:15:44 | captions | 1 | 82945 | 5 | 1.423 | 58288.8 |
491 | 2022-08-14 20:41:33 | captions | 1 | 82945 | 5 | 1.500 | 55296.7 |
490 | 2022-08-06 13:57:15 | captions | 1 | 82945 | 5 | 1.453 | 57085.3 |
489 | 2022-06-06 16:04:27 | captions | 1 | 82945 | 5 | 1.470 | 56425.2 |
488 | 2022-05-15 03:13:13 | captions | 1 | 82945 | 5 | 1.313 | 63172.1 |
487 | 2022-04-12 13:08:49 | captions | 2 | 121059 | 35 | 3.470 | 34887.3 |
486 | 2022-02-12 03:52:01 | captions | 1 | 82945 | 5 | 1.313 | 63172.1 |
485 | 2022-02-10 08:04:36 | captions | 1 | 82945 | 5 | 1.313 | 63172.1 |
484 | 2022-02-10 00:37:10 | captions | 1 | 82945 | 5 | 1.296 | 64000.8 |
483 | 2021-12-01 15:26:14 | captions | 1 | 82945 | 5 | 1.423 | 58288.8 |
482 | 2021-11-29 13:03:13 | captions | 1 | 82945 | 5 | 1.440 | 57600.7 |
481 | 2021-11-06 10:35:13 | captions | 1 | 82945 | 5 | 2.626 | 31586.1 |
480 | 2021-11-06 01:38:47 | captions | 1 | 82945 | 5 | 1.466 | 56579.1 |
479 | 2021-10-30 15:20:00 | captions | 1 | 82945 | 5 | 1.516 | 54713.1 |
478 | 2021-10-29 13:59:34 | captions | 1 | 82945 | 5 | 1.300 | 63803.8 |
477 | 2021-10-27 22:27:37 | captions | 1 | 82945 | 5 | 1.310 | 63316.8 |
476 | 2021-10-15 05:06:30 | captions | 1 | 82945 | 5 | 1.313 | 63172.1 |
475 | 2021-09-22 02:53:46 | captions | 1 | 82945 | 5 | 1.516 | 54713.1 |
474 | 2021-09-20 21:21:48 | captions | 1 | 82945 | 5 | 1.546 | 53651.4 |
473 | 2021-09-20 04:09:04 | captions | 1 | 82945 | 5 | 1.813 | 45750.1 |
472 | 2021-09-19 22:54:08 | captions | 1 | 82945 | 5 | 1.373 | 60411.5 |
471 | 2021-09-13 07:24:19 | captions | 1 | 82945 | 5 | 1.326 | 62552.8 |
470 | 2021-08-06 08:49:24 | captions | 1 | 82945 | 5 | 1.563 | 53067.8 |
469 | 2021-08-02 20:53:07 | captions | 1 | 82945 | 5 | 1.330 | 62364.7 |
468 | 2021-07-22 16:05:43 | captions | 3 | 146162 | 287 | 7.280 | 20077.2 |
467 | 2021-06-06 13:00:16 | captions | 1 | 82945 | 5 | 1.296 | 64000.8 |
466 | 2021-06-06 09:21:49 | captions | 3 | 146162 | 287 | 7.623 | 19173.8 |
465 | 2021-05-28 11:13:57 | captions | 1 | 82945 | 5 | 1.406 | 58993.6 |
464 | 2021-05-27 06:33:07 | captions | 3 | 146162 | 287 | 8.233 | 17753.2 |
463 | 2021-05-18 11:16:48 | captions | 1 | 82945 | 5 | 1.563 | 53067.8 |
462 | 2021-05-12 10:57:26 | captions | 3 | 146162 | 287 | 7.656 | 19091.2 |
461 | 2021-05-08 21:22:26 | captions | 1 | 82945 | 5 | 1.516 | 54713.1 |
460 | 2021-05-08 17:34:15 | captions | 1 | 82945 | 5 | 1.563 | 53067.8 |
459 | 2021-05-02 18:07:22 | captions | 1 | 82945 | 5 | 1.576 | 52630.1 |
458 | 2021-04-28 04:15:19 | captions | 3 | 146162 | 287 | 7.686 | 19016.7 |
457 | 2021-04-24 22:15:36 | captions | 1 | 82945 | 5 | 1.423 | 58288.8 |
456 | 2021-04-11 11:01:51 | captions | 1 | 82945 | 5 | 1.470 | 56425.2 |
455 | 2021-04-11 06:13:33 | captions | 3 | 146162 | 287 | 6.390 | 22873.6 |
454 | 2021-02-21 11:50:04 | captions | 1 | 82945 | 5 | 1.533 | 54106.3 |
453 | 2021-02-18 08:54:39 | captions | 3 | 146162 | 287 | 6.920 | 21121.7 |
452 | 2021-01-24 00:27:58 | captions | 1 | 82945 | 5 | 1.343 | 61761.0 |
451 | 2021-01-15 22:58:17 | captions | 1 | 82945 | 5 | 1.516 | 54713.1 |
450 | 2021-01-03 12:11:41 | captions | 3 | 146162 | 287 | 8.173 | 17883.5 |
449 | 2020-11-30 07:28:16 | captions | 3 | 146162 | 287 | 8.000 | 18270.3 |
448 | 2020-11-08 20:15:59 | captions | 1 | 82945 | 5 | 1.360 | 60989.0 |
447 | 2020-11-02 06:50:32 | captions | 1 | 82945 | 5 | 1.500 | 55296.7 |
446 | 2020-11-01 08:20:13 | captions | 1 | 82945 | 5 | 1.530 | 54212.4 |
445 | 2020-10-22 07:19:59 | captions | 1 | 82945 | 5 | 1.343 | 61761.0 |