History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hanse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
530 | 2024-04-03 06:28:32 | hanse | 1 | 28756 | 7 | 1.156 | 24875.4 |
529 | 2024-03-31 03:05:42 | hanse | 1 | 28756 | 7 | 1.703 | 16885.5 |
528 | 2024-03-29 02:51:34 | hanse | 1 | 28756 | 7 | 0.530 | 54256.6 |
527 | 2024-03-25 03:30:16 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
526 | 2024-03-11 06:01:46 | hanse | 1 | 28756 | 7 | 0.593 | 48492.4 |
525 | 2024-03-05 02:53:39 | hanse | 1 | 28756 | 7 | 1.110 | 25906.3 |
524 | 2024-03-03 23:55:55 | hanse | 1 | 28756 | 7 | 0.560 | 51350.0 |
523 | 2024-03-03 21:51:50 | hanse | 1 | 28756 | 7 | 0.486 | 59168.7 |
522 | 2024-03-01 00:11:00 | hanse | 1 | 28756 | 7 | 0.546 | 52666.7 |
521 | 2024-02-27 23:37:29 | hanse | 2 | 53800 | 184 | 1.623 | 33148.5 |
520 | 2024-02-27 22:25:06 | hanse | 2 | 53800 | 184 | 1.813 | 29674.6 |
519 | 2024-02-27 20:57:59 | hanse | 1 | 28756 | 7 | 0.970 | 29645.4 |
518 | 2024-02-27 08:44:00 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
517 | 2024-02-15 05:17:33 | hanse | 1 | 28756 | 7 | 0.533 | 53951.2 |
516 | 2024-01-28 21:26:39 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
515 | 2024-01-28 20:57:49 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
514 | 2024-01-19 14:33:08 | hanse | 1 | 28756 | 7 | 0.530 | 54256.6 |
513 | 2023-12-22 03:21:24 | hanse | 1 | 28756 | 7 | 0.483 | 59536.2 |
512 | 2023-12-07 14:59:18 | hanse | 2 | 53800 | 184 | 1.373 | 39184.3 |
511 | 2023-12-07 14:59:16 | hanse | 2 | 53800 | 184 | 1.436 | 37465.2 |
510 | 2023-12-06 21:06:03 | hanse | 2 | 53800 | 184 | 1.686 | 31909.8 |
509 | 2023-12-04 17:29:59 | hanse | 2 | 53800 | 184 | 2.953 | 18218.8 |
508 | 2023-12-01 10:12:33 | hanse | 1 | 28756 | 7 | 0.483 | 59536.2 |
507 | 2023-11-23 09:46:38 | hanse | 2 | 53800 | 184 | 1.376 | 39098.8 |
506 | 2023-11-11 00:51:22 | hanse | 1 | 28756 | 7 | 0.486 | 59168.7 |
505 | 2023-11-09 03:21:38 | hanse | 1 | 28756 | 7 | 0.436 | 65954.1 |
504 | 2023-11-03 10:10:34 | hanse | 1 | 28756 | 7 | 0.440 | 65354.5 |
503 | 2023-11-02 11:14:38 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
502 | 2023-10-28 03:27:01 | hanse | 2 | 53800 | 184 | 1.610 | 33416.1 |
501 | 2023-10-19 20:38:59 | hanse | 1 | 28756 | 7 | 0.436 | 65954.1 |
500 | 2023-10-18 15:50:42 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
499 | 2023-10-14 17:07:04 | hanse | 1 | 28756 | 7 | 0.470 | 61183.0 |
498 | 2023-10-05 21:54:59 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
497 | 2023-09-26 14:08:00 | hanse | 1 | 28756 | 7 | 0.503 | 57169.0 |
496 | 2023-09-15 23:45:24 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
495 | 2023-09-13 15:16:06 | hanse | 1 | 28756 | 7 | 0.513 | 56054.6 |
494 | 2023-07-21 19:17:53 | hanse | 1 | 28756 | 7 | 0.470 | 61183.0 |
493 | 2023-07-12 08:33:28 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
492 | 2023-07-03 18:47:39 | hanse | 1 | 28756 | 7 | 0.546 | 52666.7 |
491 | 2023-04-13 19:41:40 | hanse | 1 | 28756 | 7 | 0.530 | 54256.6 |
490 | 2023-04-09 21:24:09 | hanse | 1 | 28756 | 7 | 0.436 | 65954.1 |
489 | 2023-03-31 13:03:21 | hanse | 1 | 28756 | 7 | 0.483 | 59536.2 |
488 | 2023-01-28 23:19:55 | hanse | 1 | 28756 | 7 | 0.440 | 65354.5 |
487 | 2023-01-08 17:37:33 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
486 | 2022-11-27 02:40:42 | hanse | 1 | 28756 | 7 | 0.470 | 61183.0 |
485 | 2022-09-24 22:36:36 | hanse | 1 | 28756 | 7 | 0.483 | 59536.2 |
484 | 2022-09-12 01:55:15 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
483 | 2022-08-25 17:16:32 | hanse | 2 | 53800 | 184 | 1.393 | 38621.7 |
482 | 2022-08-07 22:29:05 | hanse | 2 | 53800 | 184 | 1.546 | 34799.5 |
481 | 2022-08-06 18:25:57 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
480 | 2022-07-29 23:28:08 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
479 | 2022-07-20 20:55:57 | hanse | 1 | 28756 | 7 | 0.440 | 65354.5 |
478 | 2022-07-18 16:07:40 | hanse | 1 | 28756 | 7 | 0.470 | 61183.0 |
477 | 2022-07-03 06:28:11 | hanse | 1 | 28756 | 7 | 0.486 | 59168.7 |
476 | 2022-06-16 06:31:05 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
475 | 2022-06-15 16:04:58 | hanse | 1 | 28756 | 7 | 0.436 | 65954.1 |
474 | 2022-06-11 12:59:50 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
473 | 2022-06-07 22:32:59 | hanse | 1 | 28756 | 7 | 0.436 | 65954.1 |
472 | 2022-03-13 23:02:40 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
471 | 2022-03-11 18:03:59 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
470 | 2022-02-27 23:04:55 | hanse | 1 | 28756 | 7 | 0.530 | 54256.6 |
469 | 2022-01-23 21:38:37 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
468 | 2022-01-09 08:18:13 | hanse | 1 | 28756 | 7 | 0.530 | 54256.6 |
467 | 2022-01-08 17:52:50 | hanse | 1 | 28756 | 7 | 0.513 | 56054.6 |
466 | 2022-01-07 09:18:08 | hanse | 1 | 28756 | 7 | 0.530 | 54256.6 |
465 | 2021-12-24 05:43:22 | hanse | 1 | 28756 | 7 | 0.456 | 63061.4 |
464 | 2021-11-23 03:22:48 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
463 | 2021-11-11 17:37:39 | hanse | 1 | 28756 | 7 | 0.670 | 42919.4 |
462 | 2021-10-31 02:15:31 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
461 | 2021-09-15 05:24:58 | hanse | 1 | 28756 | 7 | 0.483 | 59536.2 |
460 | 2021-08-28 14:59:59 | hanse | 1 | 28756 | 7 | 0.440 | 65354.5 |
459 | 2021-08-26 10:49:14 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
458 | 2021-08-16 19:52:54 | hanse | 1 | 28756 | 7 | 0.440 | 65354.5 |
457 | 2021-07-24 10:03:31 | hanse | 1 | 28756 | 7 | 0.890 | 32310.1 |
456 | 2021-06-03 23:15:20 | hanse | 1 | 28756 | 7 | 0.470 | 61183.0 |
455 | 2021-06-03 02:05:35 | hanse | 1 | 28756 | 7 | 0.533 | 53951.2 |
454 | 2021-06-02 15:34:32 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
453 | 2021-06-02 04:49:28 | hanse | 1 | 28756 | 7 | 0.546 | 52666.7 |
452 | 2021-05-16 03:19:43 | hanse | 1 | 28756 | 7 | 0.483 | 59536.2 |
451 | 2021-05-14 10:56:25 | hanse | 1 | 28756 | 7 | 0.530 | 54256.6 |
450 | 2021-05-12 18:54:30 | hanse | 1 | 28756 | 7 | 0.483 | 59536.2 |
449 | 2021-04-23 01:20:21 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
448 | 2021-04-18 22:55:53 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
447 | 2021-04-17 21:11:58 | hanse | 1 | 28756 | 7 | 0.546 | 52666.7 |
446 | 2021-04-13 20:20:09 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
445 | 2021-04-13 11:43:43 | hanse | 1 | 28756 | 7 | 0.546 | 52666.7 |
444 | 2021-04-13 00:02:52 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
443 | 2021-02-20 04:53:12 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
442 | 2021-02-18 22:37:38 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
441 | 2021-02-08 21:30:50 | hanse | 1 | 28756 | 7 | 0.436 | 65954.1 |
440 | 2021-02-08 06:20:22 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
439 | 2021-02-03 15:50:31 | hanse | 1 | 28756 | 7 | 0.453 | 63479.0 |
438 | 2020-12-01 20:26:53 | hanse | 1 | 28756 | 7 | 0.436 | 65954.1 |
437 | 2020-11-08 08:19:32 | hanse | 1 | 28756 | 7 | 0.470 | 61183.0 |
436 | 2020-11-06 07:41:39 | hanse | 1 | 28756 | 7 | 0.466 | 61708.2 |
435 | 2020-11-05 20:48:11 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
434 | 2020-11-01 22:40:39 | hanse | 1 | 28756 | 7 | 0.596 | 48248.3 |
433 | 2020-10-30 05:05:22 | hanse | 1 | 28756 | 7 | 0.516 | 55728.7 |
432 | 2020-10-21 11:12:35 | hanse | 1 | 28756 | 7 | 0.500 | 57512.0 |
431 | 2020-10-14 06:26:12 | hanse | 1 | 28756 | 7 | 0.456 | 63061.4 |