History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piste"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
543 | 2024-04-27 10:41:44 | piste | 1 | 28756 | 3 | 0.656 | 43835.4 |
542 | 2024-04-27 10:41:32 | piste | 2 | 53800 | 151 | 2.063 | 26078.5 |
541 | 2024-04-27 09:02:06 | piste | 2 | 53800 | 151 | 1.656 | 32487.9 |
540 | 2024-04-27 08:47:38 | piste | 2 | 53800 | 151 | 1.750 | 30742.9 |
539 | 2024-04-23 07:21:18 | piste | 1 | 28756 | 3 | 1.170 | 24577.8 |
538 | 2024-04-23 07:18:51 | piste | 1 | 28756 | 3 | 1.063 | 27051.7 |
537 | 2024-04-19 17:08:50 | piste | 1 | 28756 | 3 | 1.186 | 24246.2 |
536 | 2024-04-05 17:50:15 | piste | 1 | 28756 | 3 | 0.563 | 51076.4 |
535 | 2024-04-04 19:53:46 | piste | 2 | 53800 | 151 | 2.173 | 24758.4 |
534 | 2024-04-03 11:26:01 | piste | 2 | 53800 | 151 | 3.846 | 13988.6 |
533 | 2024-04-03 11:22:58 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
532 | 2024-03-31 15:35:04 | piste | 1 | 28756 | 3 | 0.530 | 54256.6 |
531 | 2024-03-29 02:54:51 | piste | 1 | 28756 | 3 | 0.516 | 55728.7 |
530 | 2024-03-18 16:23:11 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
529 | 2024-03-04 08:22:43 | piste | 2 | 53800 | 151 | 4.093 | 13144.4 |
528 | 2024-03-04 08:22:39 | piste | 1 | 28756 | 3 | 1.690 | 17015.4 |
527 | 2024-03-01 12:53:13 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
526 | 2024-02-28 00:54:17 | piste | 2 | 53800 | 151 | 1.643 | 32745.0 |
525 | 2024-02-27 21:55:14 | piste | 2 | 53800 | 151 | 2.203 | 24421.2 |
524 | 2024-02-27 21:07:51 | piste | 1 | 28756 | 3 | 0.576 | 49923.6 |
523 | 2024-02-03 04:13:39 | piste | 1 | 28756 | 3 | 0.546 | 52666.7 |
522 | 2024-01-29 05:58:11 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
521 | 2024-01-28 20:55:33 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
520 | 2024-01-14 09:05:20 | piste | 2 | 53800 | 151 | 1.500 | 35866.7 |
519 | 2023-12-24 07:52:25 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
518 | 2023-12-21 03:08:04 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
517 | 2023-12-20 04:18:50 | piste | 2 | 53800 | 151 | 1.373 | 39184.3 |
516 | 2023-12-16 23:58:08 | piste | 2 | 53800 | 151 | 1.343 | 40059.6 |
515 | 2023-12-15 23:25:34 | piste | 1 | 28756 | 3 | 0.466 | 61708.2 |
514 | 2023-12-03 20:09:18 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
513 | 2023-12-03 20:09:17 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
512 | 2023-11-17 20:27:35 | piste | 2 | 53800 | 151 | 1.623 | 33148.5 |
511 | 2023-11-17 02:54:10 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
510 | 2023-11-11 17:53:18 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
509 | 2023-11-03 07:12:00 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
508 | 2023-10-21 13:41:44 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
507 | 2023-10-18 12:22:26 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
506 | 2023-10-04 17:13:44 | piste | 1 | 28756 | 3 | 0.530 | 54256.6 |
505 | 2023-10-01 17:25:56 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
504 | 2023-09-24 06:55:50 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
503 | 2023-09-17 23:07:25 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
502 | 2023-09-12 02:03:29 | piste | 1 | 28756 | 3 | 0.466 | 61708.2 |
501 | 2023-07-28 21:28:13 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
500 | 2023-06-07 08:01:26 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
499 | 2023-04-26 15:50:25 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
498 | 2023-02-25 21:04:08 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
497 | 2023-02-16 11:14:50 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
496 | 2022-12-15 14:26:45 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
495 | 2022-11-12 14:56:20 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
494 | 2022-08-23 12:57:07 | piste | 1 | 28756 | 3 | 0.873 | 32939.3 |
493 | 2022-07-23 09:57:01 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
492 | 2022-07-19 17:40:05 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
491 | 2022-04-15 05:14:43 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
490 | 2022-04-13 00:28:44 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
489 | 2022-03-25 16:06:39 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
488 | 2022-01-10 22:54:20 | piste | 1 | 28756 | 3 | 0.563 | 51076.4 |
487 | 2022-01-08 18:30:10 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
486 | 2021-12-11 13:51:24 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
485 | 2021-11-06 23:15:50 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
484 | 2021-10-21 20:27:36 | piste | 1 | 28756 | 3 | 0.513 | 56054.6 |
483 | 2021-10-20 22:56:46 | piste | 1 | 28756 | 3 | 0.486 | 59168.7 |
482 | 2021-09-26 13:16:09 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
481 | 2021-09-24 10:56:53 | piste | 1 | 28756 | 3 | 0.516 | 55728.7 |
480 | 2021-09-23 20:47:58 | piste | 1 | 28756 | 3 | 0.516 | 55728.7 |
479 | 2021-09-23 04:11:07 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
478 | 2021-09-16 21:34:26 | piste | 1 | 28756 | 3 | 0.516 | 55728.7 |
477 | 2021-09-07 11:59:09 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
476 | 2021-09-07 05:36:31 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
475 | 2021-06-06 14:16:06 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
474 | 2021-06-02 12:18:21 | piste | 1 | 28756 | 3 | 0.486 | 59168.7 |
473 | 2021-05-08 07:50:40 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
472 | 2021-04-06 17:10:31 | piste | 1 | 28756 | 3 | 0.470 | 61183.0 |
471 | 2021-03-24 00:51:26 | piste | 2 | 53800 | 151 | 1.376 | 39098.8 |
470 | 2021-03-04 11:15:58 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
469 | 2021-03-04 10:54:10 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
468 | 2021-02-26 07:24:10 | piste | 2 | 53800 | 151 | 1.513 | 35558.5 |
467 | 2021-01-29 02:07:29 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
466 | 2021-01-21 23:06:55 | piste | 1 | 28756 | 3 | 0.533 | 53951.2 |
465 | 2020-12-03 13:34:42 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
464 | 2020-11-26 16:22:27 | piste | 1 | 28756 | 3 | 0.656 | 43835.4 |
463 | 2020-11-20 01:30:11 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
462 | 2020-10-26 22:48:18 | piste | 2 | 53800 | 151 | 1.453 | 37026.8 |
461 | 2020-10-16 18:00:06 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
460 | 2020-10-06 13:46:29 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
459 | 2020-09-15 18:54:45 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
458 | 2020-08-29 01:23:02 | piste | 1 | 28756 | 3 | 0.516 | 55728.7 |
457 | 2020-08-27 04:51:43 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
456 | 2020-08-25 20:46:06 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
455 | 2020-07-29 09:37:49 | piste | 1 | 28756 | 3 | 0.500 | 57512.0 |
454 | 2020-07-26 16:01:33 | piste | 1 | 28756 | 3 | 0.483 | 59536.2 |
453 | 2020-07-26 02:34:09 | piste | 1 | 28756 | 3 | 0.456 | 63061.4 |
452 | 2020-07-22 10:07:23 | piste | 1 | 28756 | 3 | 0.470 | 61183.0 |
451 | 2020-05-24 11:17:02 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |
450 | 2020-04-20 17:44:13 | piste | 1 | 28756 | 3 | 0.470 | 61183.0 |
449 | 2020-03-24 22:55:21 | piste | 1 | 28756 | 3 | 0.936 | 30722.2 |
448 | 2020-03-23 09:13:03 | piste | 1 | 28756 | 3 | 0.533 | 53951.2 |
447 | 2020-03-23 08:58:40 | piste | 1 | 28756 | 3 | 0.453 | 63479.0 |
446 | 2020-03-22 16:45:46 | piste | 1 | 28756 | 3 | 0.530 | 54256.6 |
445 | 2020-03-21 04:21:55 | piste | 1 | 28756 | 3 | 0.530 | 54256.6 |
444 | 2020-03-18 01:25:14 | piste | 1 | 28756 | 3 | 0.436 | 65954.1 |