History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trooping"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
543 | 2024-04-24 19:30:34 | trooping | 3 | 146162 | 396 | 31.363 | 4660.3 |
542 | 2024-04-13 21:16:11 | trooping | 1 | 82945 | 4 | 1.326 | 62552.8 |
541 | 2024-04-09 05:29:27 | trooping | 2 | 121059 | 58 | 14.063 | 8608.3 |
540 | 2024-04-08 22:09:42 | trooping | 2 | 121059 | 58 | 4.126 | 29340.5 |
539 | 2024-04-07 17:30:28 | trooping | 3 | 146162 | 396 | 14.906 | 9805.6 |
538 | 2024-04-06 14:25:17 | trooping | 3 | 146162 | 396 | 14.956 | 9772.8 |
537 | 2024-04-04 04:40:28 | trooping | 3 | 146162 | 396 | 11.343 | 12885.7 |
536 | 2024-04-04 01:50:09 | trooping | 3 | 146162 | 396 | 21.190 | 6897.7 |
535 | 2024-04-04 01:50:20 | trooping | 1 | 82945 | 4 | 4.500 | 18432.2 |
534 | 2024-04-04 01:50:08 | trooping | 2 | 121059 | 58 | 8.843 | 13689.8 |
533 | 2024-03-30 07:17:08 | trooping | 1 | 82945 | 4 | 5.936 | 13973.2 |
532 | 2024-03-29 14:05:27 | trooping | 1 | 82945 | 4 | 3.250 | 25521.5 |
531 | 2024-03-07 06:39:06 | trooping | 3 | 146162 | 396 | 11.140 | 13120.5 |
530 | 2024-03-07 06:39:06 | trooping | 2 | 121059 | 58 | 9.390 | 12892.3 |
529 | 2024-03-07 04:15:38 | trooping | 1 | 82945 | 4 | 4.893 | 16951.8 |
528 | 2024-03-01 13:17:14 | trooping | 3 | 146162 | 396 | 16.626 | 8791.2 |
527 | 2024-03-01 13:15:41 | trooping | 1 | 82945 | 4 | 1.593 | 52068.4 |
526 | 2024-03-01 06:10:41 | trooping | 2 | 121059 | 58 | 4.970 | 24357.9 |
525 | 2024-03-01 06:10:24 | trooping | 3 | 146162 | 396 | 7.970 | 18339.0 |
524 | 2024-02-29 04:25:19 | trooping | 1 | 82945 | 4 | 1.516 | 54713.1 |
523 | 2024-02-28 16:33:28 | trooping | 2 | 121059 | 58 | 9.140 | 13245.0 |
522 | 2024-02-28 11:54:30 | trooping | 2 | 121059 | 58 | 7.783 | 15554.3 |
521 | 2024-02-28 11:54:25 | trooping | 3 | 146162 | 396 | 7.780 | 18786.9 |
520 | 2024-02-28 11:54:13 | trooping | 1 | 82945 | 4 | 1.610 | 51518.6 |
519 | 2024-01-28 05:27:03 | trooping | 3 | 146162 | 396 | 6.640 | 22012.3 |
518 | 2024-01-25 19:22:23 | trooping | 3 | 146162 | 396 | 6.343 | 23043.0 |
517 | 2024-01-25 16:40:43 | trooping | 3 | 146162 | 396 | 6.373 | 22934.6 |
516 | 2023-12-30 14:43:58 | trooping | 1 | 82945 | 4 | 1.266 | 65517.4 |
515 | 2023-12-29 21:46:58 | trooping | 1 | 82945 | 4 | 1.360 | 60989.0 |
514 | 2023-12-20 03:27:50 | trooping | 3 | 146162 | 396 | 6.983 | 20931.1 |
513 | 2023-12-11 03:49:41 | trooping | 2 | 121059 | 58 | 3.643 | 33230.6 |
512 | 2023-12-03 12:51:27 | trooping | 1 | 82945 | 4 | 2.313 | 35860.4 |
511 | 2023-11-30 05:39:04 | trooping | 1 | 82945 | 4 | 1.296 | 64000.8 |
510 | 2023-11-26 20:25:11 | trooping | 3 | 146162 | 396 | 9.110 | 16044.1 |
509 | 2023-11-19 08:43:31 | trooping | 1 | 82945 | 4 | 1.373 | 60411.5 |
508 | 2023-11-05 19:40:25 | trooping | 3 | 146162 | 396 | 7.233 | 20207.7 |
507 | 2023-11-03 05:46:53 | trooping | 1 | 82945 | 4 | 1.250 | 66356.0 |
506 | 2023-10-29 12:22:18 | trooping | 3 | 146162 | 396 | 6.906 | 21164.5 |
505 | 2023-10-20 16:08:26 | trooping | 1 | 82945 | 4 | 1.326 | 62552.8 |
504 | 2023-10-16 15:35:53 | trooping | 1 | 82945 | 4 | 1.263 | 65673.0 |
503 | 2023-10-06 20:45:29 | trooping | 1 | 82945 | 4 | 1.233 | 67270.9 |
502 | 2023-10-02 02:54:46 | trooping | 1 | 82945 | 4 | 1.423 | 58288.8 |
501 | 2023-09-22 15:33:08 | trooping | 1 | 82945 | 4 | 1.283 | 64649.3 |
500 | 2023-09-11 14:34:55 | trooping | 2 | 121059 | 58 | 3.220 | 37596.0 |
499 | 2023-09-10 05:33:35 | trooping | 2 | 121059 | 58 | 3.856 | 31395.0 |
498 | 2023-08-16 08:24:34 | trooping | 1 | 82945 | 4 | 1.250 | 66356.0 |
497 | 2023-08-11 03:11:38 | trooping | 3 | 146162 | 396 | 6.580 | 22213.1 |
496 | 2023-06-04 12:41:44 | trooping | 2 | 121059 | 58 | 3.250 | 37248.9 |
495 | 2023-05-23 03:32:44 | trooping | 1 | 82945 | 4 | 2.826 | 29350.7 |
494 | 2023-05-19 21:37:32 | trooping | 1 | 82945 | 4 | 1.280 | 64800.8 |
493 | 2023-05-09 23:24:09 | trooping | 1 | 82945 | 4 | 1.296 | 64000.8 |
492 | 2023-05-05 06:27:53 | trooping | 3 | 146162 | 396 | 6.326 | 23105.0 |
491 | 2023-04-26 02:04:52 | trooping | 3 | 146162 | 396 | 6.860 | 21306.4 |
490 | 2023-04-16 08:08:46 | trooping | 1 | 82945 | 4 | 1.233 | 67270.9 |
489 | 2023-03-12 11:17:09 | trooping | 2 | 121059 | 58 | 3.563 | 33976.7 |
488 | 2023-03-04 16:00:36 | trooping | 1 | 82945 | 4 | 1.250 | 66356.0 |
487 | 2023-02-01 04:28:06 | trooping | 3 | 146162 | 396 | 6.123 | 23871.0 |
486 | 2023-01-19 13:45:56 | trooping | 1 | 82945 | 4 | 1.280 | 64800.8 |
485 | 2023-01-15 10:46:09 | trooping | 3 | 146162 | 396 | 6.310 | 23163.5 |
484 | 2022-12-28 07:02:28 | trooping | 1 | 82945 | 4 | 1.436 | 57761.1 |
483 | 2022-12-20 11:27:11 | trooping | 3 | 146162 | 396 | 6.126 | 23859.3 |
482 | 2022-12-15 16:14:41 | trooping | 2 | 121059 | 58 | 3.563 | 33976.7 |
481 | 2022-12-13 00:07:55 | trooping | 3 | 146162 | 396 | 6.300 | 23200.3 |
480 | 2022-11-14 14:24:55 | trooping | 3 | 146162 | 396 | 6.220 | 23498.7 |
479 | 2022-10-10 18:05:13 | trooping | 1 | 82945 | 4 | 1.280 | 64800.8 |
478 | 2022-09-14 15:01:49 | trooping | 1 | 82945 | 4 | 1.266 | 65517.4 |
477 | 2022-09-10 05:57:03 | trooping | 1 | 82945 | 4 | 1.263 | 65673.0 |
476 | 2022-08-12 16:12:59 | trooping | 2 | 121059 | 58 | 3.296 | 36729.1 |
475 | 2022-06-29 14:38:48 | trooping | 3 | 146162 | 396 | 6.173 | 23677.6 |
474 | 2022-06-29 08:34:10 | trooping | 1 | 82945 | 4 | 1.250 | 66356.0 |
473 | 2022-06-25 18:12:34 | trooping | 3 | 146162 | 396 | 6.266 | 23326.2 |
472 | 2022-06-16 15:12:25 | trooping | 3 | 146162 | 396 | 6.343 | 23043.0 |
471 | 2022-04-23 14:10:11 | trooping | 1 | 82945 | 4 | 1.263 | 65673.0 |
470 | 2022-03-10 18:25:43 | trooping | 1 | 82945 | 4 | 1.763 | 47047.6 |
469 | 2021-12-28 17:17:26 | trooping | 1 | 82945 | 4 | 1.576 | 52630.1 |
468 | 2021-12-23 06:59:18 | trooping | 1 | 82945 | 4 | 1.250 | 66356.0 |
467 | 2021-12-21 03:20:13 | trooping | 1 | 82945 | 4 | 1.343 | 61761.0 |
466 | 2021-11-13 15:13:26 | trooping | 1 | 82945 | 4 | 1.530 | 54212.4 |
465 | 2021-11-09 15:12:09 | trooping | 1 | 82945 | 4 | 1.470 | 56425.2 |
464 | 2021-09-02 03:51:28 | trooping | 1 | 82945 | 4 | 1.266 | 65517.4 |
463 | 2021-07-08 01:26:20 | trooping | 1 | 82945 | 4 | 1.450 | 57203.4 |
462 | 2021-05-25 20:50:59 | trooping | 1 | 82945 | 4 | 1.500 | 55296.7 |
461 | 2021-05-20 12:54:04 | trooping | 1 | 82945 | 4 | 2.530 | 32784.6 |
460 | 2021-05-05 08:23:05 | trooping | 3 | 146162 | 396 | 8.046 | 18165.8 |
459 | 2021-04-20 20:05:11 | trooping | 1 | 82945 | 4 | 3.063 | 27079.7 |
458 | 2021-04-06 12:52:29 | trooping | 3 | 146162 | 396 | 14.580 | 10024.8 |
457 | 2021-02-26 19:06:37 | trooping | 1 | 82945 | 4 | 1.313 | 63172.1 |
456 | 2021-02-25 19:27:52 | trooping | 1 | 82945 | 4 | 2.843 | 29175.2 |
455 | 2021-02-16 02:44:18 | trooping | 1 | 82945 | 4 | 1.263 | 65673.0 |
454 | 2021-02-14 11:52:38 | trooping | 3 | 146162 | 396 | 6.423 | 22756.0 |
453 | 2021-01-11 20:27:45 | trooping | 3 | 146162 | 396 | 6.500 | 22486.5 |
452 | 2020-12-22 14:02:06 | trooping | 3 | 146162 | 396 | 6.423 | 22756.0 |
451 | 2020-11-06 15:57:41 | trooping | 1 | 82945 | 4 | 1.406 | 58993.6 |
450 | 2020-11-06 01:49:53 | trooping | 3 | 146162 | 396 | 6.593 | 22169.3 |
449 | 2020-10-25 09:25:31 | trooping | 1 | 82945 | 4 | 1.266 | 65517.4 |
448 | 2020-10-20 16:30:13 | trooping | 1 | 82945 | 4 | 1.376 | 60279.8 |
447 | 2020-10-20 12:47:32 | trooping | 1 | 82945 | 4 | 1.376 | 60279.8 |
446 | 2020-10-11 08:19:35 | trooping | 3 | 146162 | 396 | 6.360 | 22981.4 |
445 | 2020-10-09 13:34:50 | trooping | 1 | 82945 | 4 | 1.250 | 66356.0 |
444 | 2020-08-08 21:54:02 | trooping | 1 | 82945 | 4 | 1.296 | 64000.8 |