History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fault"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
554 | 2024-05-09 22:35:35 | fault | 2 | 53800 | 85 | 1.686 | 31909.8 |
553 | 2024-05-06 14:50:37 | fault | 2 | 53800 | 85 | 2.330 | 23090.1 |
552 | 2024-05-06 14:49:59 | fault | 3 | 83667 | 1053 | 6.300 | 13280.5 |
551 | 2024-05-05 02:40:34 | fault | 3 | 83667 | 1053 | 4.483 | 18663.2 |
550 | 2024-05-04 07:27:31 | fault | 1 | 28756 | 7 | 0.516 | 55728.7 |
549 | 2024-04-30 16:16:55 | fault | 1 | 28756 | 7 | 0.546 | 52666.7 |
548 | 2024-04-29 16:25:49 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
547 | 2024-04-28 03:54:19 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
546 | 2024-04-26 16:19:18 | fault | 1 | 28756 | 7 | 0.483 | 59536.2 |
545 | 2024-04-26 09:49:08 | fault | 2 | 53800 | 85 | 1.923 | 27977.1 |
544 | 2024-04-26 09:48:00 | fault | 3 | 83667 | 1053 | 4.486 | 18650.7 |
543 | 2024-04-25 15:25:48 | fault | 3 | 83667 | 1053 | 4.190 | 19968.3 |
542 | 2024-04-24 20:53:47 | fault | 2 | 53800 | 85 | 6.170 | 8719.6 |
541 | 2024-04-23 17:39:35 | fault | 2 | 53800 | 85 | 1.530 | 35163.4 |
540 | 2024-04-23 15:15:16 | fault | 3 | 83667 | 1053 | 5.030 | 16633.6 |
539 | 2024-04-23 15:14:33 | fault | 1 | 28756 | 7 | 2.156 | 13337.7 |
538 | 2024-04-23 15:14:06 | fault | 2 | 53800 | 85 | 3.250 | 16553.8 |
537 | 2024-04-23 15:10:05 | fault | 3 | 83667 | 1053 | 15.440 | 5418.8 |
536 | 2024-04-23 15:01:18 | fault | 1 | 28756 | 7 | 0.580 | 49579.3 |
535 | 2024-04-03 01:15:07 | fault | 3 | 83667 | 1053 | 14.206 | 5889.6 |
534 | 2024-04-03 01:15:09 | fault | 2 | 53800 | 85 | 5.783 | 9303.1 |
533 | 2024-04-03 01:09:50 | fault | 1 | 28756 | 7 | 0.533 | 53951.2 |
532 | 2024-03-31 02:41:59 | fault | 1 | 28756 | 7 | 0.546 | 52666.7 |
531 | 2024-03-29 02:37:41 | fault | 1 | 28756 | 7 | 1.486 | 19351.3 |
530 | 2024-03-05 20:03:21 | fault | 2 | 53800 | 85 | 1.890 | 28465.6 |
529 | 2024-03-05 19:59:29 | fault | 3 | 83667 | 1053 | 4.673 | 17904.3 |
528 | 2024-03-05 06:41:52 | fault | 3 | 83667 | 1053 | 13.096 | 6388.7 |
527 | 2024-03-04 11:52:01 | fault | 2 | 53800 | 85 | 2.076 | 25915.2 |
526 | 2024-03-04 11:52:00 | fault | 1 | 28756 | 7 | 0.550 | 52283.6 |
525 | 2024-03-04 11:51:36 | fault | 3 | 83667 | 1053 | 4.313 | 19398.8 |
524 | 2024-03-03 23:35:24 | fault | 3 | 83667 | 1053 | 14.140 | 5917.0 |
523 | 2024-03-03 23:35:23 | fault | 2 | 53800 | 85 | 6.143 | 8757.9 |
522 | 2024-03-03 22:12:23 | fault | 1 | 28756 | 7 | 0.453 | 63479.0 |
521 | 2024-02-27 20:22:29 | fault | 1 | 28756 | 7 | 0.546 | 52666.7 |
520 | 2024-02-02 18:40:03 | fault | 1 | 28756 | 7 | 0.516 | 55728.7 |
519 | 2024-01-30 18:06:26 | fault | 1 | 28756 | 7 | 0.970 | 29645.4 |
518 | 2024-01-28 20:23:33 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
517 | 2024-01-28 18:28:03 | fault | 1 | 28756 | 7 | 0.440 | 65354.5 |
516 | 2024-01-27 00:31:19 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
515 | 2024-01-18 07:56:30 | fault | 3 | 83667 | 1053 | 3.533 | 23681.6 |
514 | 2024-01-18 07:56:29 | fault | 2 | 53800 | 85 | 1.640 | 32804.9 |
513 | 2024-01-04 20:07:41 | fault | 3 | 83667 | 1053 | 3.516 | 23796.1 |
512 | 2023-11-30 00:34:47 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
511 | 2023-11-26 07:20:46 | fault | 2 | 53800 | 85 | 1.533 | 35094.6 |
510 | 2023-11-24 11:19:29 | fault | 1 | 28756 | 7 | 0.453 | 63479.0 |
509 | 2023-11-17 13:58:06 | fault | 1 | 28756 | 7 | 0.470 | 61183.0 |
508 | 2023-11-03 15:33:18 | fault | 1 | 28756 | 7 | 0.483 | 59536.2 |
507 | 2023-10-23 02:02:01 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
506 | 2023-10-21 22:37:22 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
505 | 2023-10-20 18:14:33 | fault | 3 | 83667 | 1053 | 3.330 | 25125.2 |
504 | 2023-10-18 16:49:57 | fault | 1 | 28756 | 7 | 0.440 | 65354.5 |
503 | 2023-10-17 13:44:05 | fault | 3 | 83667 | 1053 | 3.420 | 24464.0 |
502 | 2023-10-14 03:11:30 | fault | 3 | 83667 | 1053 | 7.970 | 10497.7 |
501 | 2023-10-13 06:49:21 | fault | 1 | 28756 | 7 | 0.466 | 61708.2 |
500 | 2023-10-10 17:23:10 | fault | 3 | 83667 | 1053 | 4.970 | 16834.4 |
499 | 2023-10-05 05:15:45 | fault | 1 | 28756 | 7 | 0.513 | 56054.6 |
498 | 2023-09-27 15:28:01 | fault | 1 | 28756 | 7 | 0.483 | 59536.2 |
497 | 2023-09-23 15:47:56 | fault | 1 | 28756 | 7 | 0.530 | 54256.6 |
496 | 2023-09-09 22:48:11 | fault | 1 | 28756 | 7 | 0.420 | 68466.7 |
495 | 2023-07-27 07:04:10 | fault | 3 | 83667 | 1053 | 3.250 | 25743.7 |
494 | 2023-07-20 19:42:28 | fault | 3 | 83667 | 1053 | 3.236 | 25855.1 |
493 | 2023-07-13 18:40:47 | fault | 1 | 28756 | 7 | 0.890 | 32310.1 |
492 | 2023-06-14 19:19:19 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
491 | 2023-04-06 04:34:00 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
490 | 2023-04-03 22:39:13 | fault | 3 | 83667 | 1053 | 3.190 | 26227.9 |
489 | 2023-03-31 18:20:37 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
488 | 2023-01-15 13:04:15 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
487 | 2023-01-12 01:04:47 | fault | 3 | 83667 | 1053 | 3.203 | 26121.4 |
486 | 2023-01-01 03:55:43 | fault | 3 | 83667 | 1053 | 3.266 | 25617.6 |
485 | 2022-12-31 22:50:45 | fault | 1 | 28756 | 7 | 0.483 | 59536.2 |
484 | 2022-12-20 04:23:25 | fault | 3 | 83667 | 1053 | 3.470 | 24111.5 |
483 | 2022-12-10 06:30:24 | fault | 3 | 83667 | 1053 | 3.766 | 22216.4 |
482 | 2022-11-16 10:17:43 | fault | 3 | 83667 | 1053 | 3.513 | 23816.4 |
481 | 2022-11-12 06:11:01 | fault | 3 | 83667 | 1053 | 3.470 | 24111.5 |
480 | 2022-11-08 06:35:27 | fault | 3 | 83667 | 1053 | 3.580 | 23370.7 |
479 | 2022-11-07 05:22:22 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
478 | 2022-11-02 23:47:40 | fault | 3 | 83667 | 1053 | 3.673 | 22778.9 |
477 | 2022-10-11 05:37:47 | fault | 3 | 83667 | 1053 | 3.296 | 25384.4 |
476 | 2022-09-13 20:59:32 | fault | 1 | 28756 | 7 | 1.030 | 27918.4 |
475 | 2022-09-03 18:18:02 | fault | 3 | 83667 | 1053 | 3.236 | 25855.1 |
474 | 2022-08-15 01:45:48 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
473 | 2022-07-29 09:49:23 | fault | 1 | 28756 | 7 | 0.470 | 61183.0 |
472 | 2022-07-10 10:51:19 | fault | 1 | 28756 | 7 | 0.453 | 63479.0 |
471 | 2022-07-02 20:02:45 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
470 | 2022-06-30 17:15:12 | fault | 2 | 53800 | 85 | 1.373 | 39184.3 |
469 | 2022-06-28 20:30:07 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
468 | 2022-06-26 14:54:43 | fault | 1 | 28756 | 7 | 0.453 | 63479.0 |
467 | 2022-06-15 22:00:14 | fault | 1 | 28756 | 7 | 0.516 | 55728.7 |
466 | 2022-05-31 22:30:59 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
465 | 2022-03-29 07:30:31 | fault | 3 | 83667 | 1053 | 3.766 | 22216.4 |
464 | 2022-02-27 10:46:07 | fault | 1 | 28756 | 7 | 0.516 | 55728.7 |
463 | 2022-02-20 19:46:51 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
462 | 2022-01-01 16:21:29 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
461 | 2021-12-14 08:16:23 | fault | 1 | 28756 | 7 | 0.453 | 63479.0 |
460 | 2021-12-11 21:29:08 | fault | 3 | 83667 | 1053 | 3.453 | 24230.2 |
459 | 2021-11-26 17:25:37 | fault | 1 | 28756 | 7 | 0.546 | 52666.7 |
458 | 2021-11-19 09:36:00 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
457 | 2021-11-16 02:02:16 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
456 | 2021-10-21 14:15:26 | fault | 1 | 28756 | 7 | 0.456 | 63061.4 |
455 | 2021-10-01 17:04:55 | fault | 1 | 28756 | 7 | 0.656 | 43835.4 |