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 |
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 |
454 | 2021-09-21 02:50:12 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
453 | 2021-09-15 20:07:29 | fault | 1 | 28756 | 7 | 0.486 | 59168.7 |
452 | 2021-09-13 17:08:33 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
451 | 2021-08-13 05:54:44 | fault | 1 | 28756 | 7 | 0.470 | 61183.0 |
450 | 2021-05-12 12:36:35 | fault | 1 | 28756 | 7 | 0.516 | 55728.7 |
449 | 2021-04-03 07:24:32 | fault | 3 | 83667 | 1053 | 3.733 | 22412.8 |
448 | 2021-02-11 18:08:56 | fault | 3 | 83667 | 1053 | 4.376 | 19119.5 |
447 | 2021-02-08 11:51:21 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
446 | 2021-01-03 09:22:08 | fault | 3 | 83667 | 1053 | 3.766 | 22216.4 |
445 | 2020-12-19 01:11:47 | fault | 3 | 83667 | 1053 | 3.576 | 23396.8 |
444 | 2020-11-06 17:06:18 | fault | 1 | 28756 | 7 | 0.516 | 55728.7 |
443 | 2020-11-04 23:41:02 | fault | 2 | 53800 | 85 | 1.470 | 36598.6 |
442 | 2020-10-21 12:38:56 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
441 | 2020-09-28 03:39:42 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
440 | 2020-09-17 05:53:02 | fault | 1 | 28756 | 7 | 0.453 | 63479.0 |
439 | 2020-08-05 12:13:41 | fault | 1 | 28756 | 7 | 0.436 | 65954.1 |
438 | 2020-07-22 16:29:57 | fault | 1 | 28756 | 7 | 0.500 | 57512.0 |
437 | 2020-07-21 07:00:46 | fault | 1 | 28756 | 7 | 0.483 | 59536.2 |
436 | 2020-05-04 00:28:25 | fault | 1 | 28756 | 7 | 0.516 | 55728.7 |