History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rooty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
530 | 2024-05-02 00:03:27 | rooty | 1 | 28756 | 10 | 0.513 | 56054.6 |
529 | 2024-04-30 09:17:20 | rooty | 1 | 28756 | 10 | 1.750 | 16432.0 |
528 | 2024-04-29 18:04:14 | rooty | 1 | 28756 | 10 | 0.530 | 54256.6 |
527 | 2024-04-28 06:44:01 | rooty | 1 | 28756 | 10 | 0.703 | 40904.7 |
526 | 2024-04-28 05:28:37 | rooty | 2 | 53800 | 143 | 8.953 | 6009.2 |
525 | 2024-04-26 22:55:37 | rooty | 2 | 53800 | 143 | 2.373 | 22671.7 |
524 | 2024-04-17 11:13:47 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
523 | 2024-04-03 04:13:36 | rooty | 1 | 28756 | 10 | 1.156 | 24875.4 |
522 | 2024-04-02 00:52:18 | rooty | 1 | 28756 | 10 | 0.486 | 59168.7 |
521 | 2024-03-31 05:17:34 | rooty | 2 | 53800 | 143 | 3.920 | 13724.5 |
520 | 2024-03-31 04:04:53 | rooty | 1 | 28756 | 10 | 0.563 | 51076.4 |
519 | 2024-03-30 01:25:22 | rooty | 2 | 53800 | 143 | 6.203 | 8673.2 |
518 | 2024-03-29 05:12:28 | rooty | 2 | 53800 | 143 | 2.686 | 20029.8 |
517 | 2024-03-29 05:12:19 | rooty | 1 | 28756 | 10 | 0.563 | 51076.4 |
516 | 2024-03-29 05:12:10 | rooty | 2 | 53800 | 143 | 3.593 | 14973.6 |
515 | 2024-03-29 05:11:54 | rooty | 1 | 28756 | 10 | 0.576 | 49923.6 |
514 | 2024-03-28 03:23:55 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
513 | 2024-03-04 02:14:25 | rooty | 2 | 53800 | 143 | 1.673 | 32157.8 |
512 | 2024-03-04 02:13:40 | rooty | 1 | 28756 | 10 | 0.470 | 61183.0 |
511 | 2024-03-01 00:03:09 | rooty | 1 | 28756 | 10 | 0.716 | 40162.0 |
510 | 2024-02-28 01:05:22 | rooty | 1 | 28756 | 10 | 0.513 | 56054.6 |
509 | 2024-02-02 22:43:59 | rooty | 1 | 28756 | 10 | 1.110 | 25906.3 |
508 | 2024-01-28 21:55:21 | rooty | 1 | 28756 | 10 | 0.440 | 65354.5 |
507 | 2024-01-26 14:25:04 | rooty | 1 | 28756 | 10 | 0.516 | 55728.7 |
506 | 2024-01-10 08:49:15 | rooty | 2 | 53800 | 143 | 1.423 | 37807.4 |
505 | 2024-01-09 17:57:39 | rooty | 2 | 53800 | 143 | 1.403 | 38346.4 |
504 | 2023-12-31 19:37:14 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
503 | 2023-12-07 16:06:44 | rooty | 1 | 28756 | 10 | 0.436 | 65954.1 |
502 | 2023-11-16 07:38:59 | rooty | 1 | 28756 | 10 | 0.450 | 63902.2 |
501 | 2023-11-15 12:45:01 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
500 | 2023-11-09 23:41:18 | rooty | 1 | 28756 | 10 | 0.450 | 63902.2 |
499 | 2023-11-08 14:13:35 | rooty | 1 | 28756 | 10 | 0.483 | 59536.2 |
498 | 2023-11-05 18:21:05 | rooty | 1 | 28756 | 10 | 0.516 | 55728.7 |
497 | 2023-10-23 00:04:28 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
496 | 2023-10-19 21:45:53 | rooty | 1 | 28756 | 10 | 0.466 | 61708.2 |
495 | 2023-10-19 17:10:35 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
494 | 2023-10-14 10:40:52 | rooty | 1 | 28756 | 10 | 0.516 | 55728.7 |
493 | 2023-10-05 10:48:30 | rooty | 1 | 28756 | 10 | 0.436 | 65954.1 |
492 | 2023-09-29 09:02:58 | rooty | 1 | 28756 | 10 | 0.436 | 65954.1 |
491 | 2023-09-20 18:27:02 | rooty | 1 | 28756 | 10 | 0.560 | 51350.0 |
490 | 2023-09-19 17:54:54 | rooty | 1 | 28756 | 10 | 0.516 | 55728.7 |
489 | 2023-08-15 05:25:15 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
488 | 2023-08-08 05:30:13 | rooty | 1 | 28756 | 10 | 0.470 | 61183.0 |
487 | 2023-05-14 03:27:14 | rooty | 1 | 28756 | 10 | 0.470 | 61183.0 |
486 | 2023-04-15 23:00:58 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
485 | 2023-03-06 23:21:57 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
484 | 2022-12-30 16:28:58 | rooty | 1 | 28756 | 10 | 0.436 | 65954.1 |
483 | 2022-12-29 13:12:58 | rooty | 1 | 28756 | 10 | 0.436 | 65954.1 |
482 | 2022-12-04 04:48:38 | rooty | 2 | 53800 | 143 | 1.406 | 38264.6 |
481 | 2022-11-09 04:44:09 | rooty | 2 | 53800 | 143 | 1.423 | 37807.4 |
480 | 2022-09-29 21:21:08 | rooty | 2 | 53800 | 143 | 1.403 | 38346.4 |
479 | 2022-09-18 01:02:02 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
478 | 2022-09-17 13:12:41 | rooty | 1 | 28756 | 10 | 0.516 | 55728.7 |
477 | 2022-09-04 10:06:27 | rooty | 1 | 28756 | 10 | 0.436 | 65954.1 |
476 | 2022-08-30 01:16:41 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
475 | 2022-08-15 08:44:29 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
474 | 2022-08-07 00:20:44 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
473 | 2022-06-25 15:22:27 | rooty | 1 | 28756 | 10 | 0.440 | 65354.5 |
472 | 2022-04-26 00:26:06 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
471 | 2022-04-25 20:01:30 | rooty | 1 | 28756 | 10 | 0.513 | 56054.6 |
470 | 2022-04-23 13:35:30 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
469 | 2022-01-12 20:03:35 | rooty | 1 | 28756 | 10 | 0.513 | 56054.6 |
468 | 2022-01-10 17:09:00 | rooty | 1 | 28756 | 10 | 0.530 | 54256.6 |
467 | 2022-01-09 12:06:48 | rooty | 1 | 28756 | 10 | 0.533 | 53951.2 |
466 | 2021-11-06 18:55:17 | rooty | 1 | 28756 | 10 | 0.670 | 42919.4 |
465 | 2021-10-02 17:07:01 | rooty | 1 | 28756 | 10 | 0.470 | 61183.0 |
464 | 2021-09-30 14:49:25 | rooty | 1 | 28756 | 10 | 0.546 | 52666.7 |
463 | 2021-09-30 02:52:12 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
462 | 2021-08-31 07:29:32 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
461 | 2021-08-26 21:58:09 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
460 | 2021-06-30 17:10:26 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
459 | 2021-06-10 07:45:26 | rooty | 1 | 28756 | 10 | 0.456 | 63061.4 |
458 | 2021-03-30 15:00:32 | rooty | 1 | 28756 | 10 | 0.533 | 53951.2 |
457 | 2021-03-19 16:07:58 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
456 | 2021-02-03 09:03:12 | rooty | 1 | 28756 | 10 | 0.466 | 61708.2 |
455 | 2021-01-29 10:16:53 | rooty | 1 | 28756 | 10 | 0.466 | 61708.2 |
454 | 2020-12-19 00:45:32 | rooty | 1 | 28756 | 10 | 0.483 | 59536.2 |
453 | 2020-10-25 13:13:44 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
452 | 2020-10-22 01:08:39 | rooty | 1 | 28756 | 10 | 0.486 | 59168.7 |
451 | 2020-10-18 16:15:59 | rooty | 1 | 28756 | 10 | 0.456 | 63061.4 |
450 | 2020-10-17 20:37:58 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
449 | 2020-09-18 16:04:25 | rooty | 1 | 28756 | 10 | 0.500 | 57512.0 |
448 | 2020-09-06 20:58:06 | rooty | 1 | 28756 | 10 | 0.533 | 53951.2 |
447 | 2020-06-08 15:54:12 | rooty | 1 | 28756 | 10 | 0.483 | 59536.2 |
446 | 2020-04-19 09:58:25 | rooty | 2 | 53800 | 143 | 1.626 | 33087.3 |
445 | 2020-04-13 21:18:27 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
444 | 2020-03-31 07:59:45 | rooty | 1 | 28756 | 10 | 0.466 | 61708.2 |
443 | 2020-03-28 12:49:05 | rooty | 1 | 28756 | 10 | 0.546 | 52666.7 |
442 | 2020-03-25 01:56:40 | rooty | 1 | 28756 | 10 | 0.546 | 52666.7 |
441 | 2020-03-23 17:42:53 | rooty | 1 | 28756 | 10 | 0.453 | 63479.0 |
440 | 2020-03-22 12:15:35 | rooty | 1 | 28756 | 10 | 0.560 | 51350.0 |
439 | 2020-03-22 07:02:06 | rooty | 1 | 28756 | 10 | 0.810 | 35501.2 |
438 | 2020-03-21 08:21:03 | rooty | 1 | 28756 | 10 | 0.450 | 63902.2 |
437 | 2020-03-18 04:45:16 | rooty | 1 | 28756 | 10 | 0.436 | 65954.1 |
436 | 2020-03-07 02:56:20 | rooty | 1 | 28756 | 10 | 0.440 | 65354.5 |
435 | 2020-02-24 09:58:55 | rooty | 1 | 28756 | 10 | 1.140 | 25224.6 |
434 | 2020-02-23 00:44:41 | rooty | 1 | 28756 | 10 | 0.653 | 44036.8 |
433 | 2020-02-15 01:33:56 | rooty | 1 | 28756 | 10 | 0.906 | 31739.5 |
432 | 2020-02-14 22:18:17 | rooty | 1 | 28756 | 10 | 0.580 | 49579.3 |
431 | 2020-02-12 10:54:16 | rooty | 1 | 28756 | 10 | 0.560 | 51350.0 |