History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trade"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
545 | 2024-05-04 23:47:12 | trade | 1 | 28756 | 12 | 1.830 | 15713.7 |
544 | 2024-05-04 02:03:11 | trade | 1 | 28756 | 12 | 0.516 | 55728.7 |
543 | 2024-05-01 21:19:53 | trade | 1 | 28756 | 12 | 0.546 | 52666.7 |
542 | 2024-04-21 07:23:23 | trade | 1 | 28756 | 12 | 1.626 | 17685.1 |
541 | 2024-04-10 06:27:42 | trade | 1 | 28756 | 12 | 1.063 | 27051.7 |
540 | 2024-04-03 04:46:38 | trade | 2 | 53800 | 187 | 2.046 | 26295.2 |
539 | 2024-04-03 04:14:05 | trade | 1 | 28756 | 12 | 1.016 | 28303.1 |
538 | 2024-03-29 03:00:54 | trade | 1 | 28756 | 12 | 1.110 | 25906.3 |
537 | 2024-03-23 01:20:24 | trade | 1 | 28756 | 12 | 0.516 | 55728.7 |
536 | 2024-03-22 04:14:54 | trade | 1 | 28756 | 12 | 0.513 | 56054.6 |
535 | 2024-03-03 20:52:15 | trade | 1 | 28756 | 12 | 0.516 | 55728.7 |
534 | 2024-02-27 20:23:44 | trade | 1 | 28756 | 12 | 0.576 | 49923.6 |
533 | 2024-02-20 23:44:44 | trade | 1 | 28756 | 12 | 0.563 | 51076.4 |
532 | 2024-01-28 23:58:17 | trade | 1 | 28756 | 12 | 0.966 | 29768.1 |
531 | 2024-01-20 08:48:55 | trade | 1 | 28756 | 12 | 0.500 | 57512.0 |
530 | 2024-01-06 03:57:07 | trade | 2 | 53800 | 187 | 1.410 | 38156.0 |
529 | 2023-12-31 23:49:20 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
528 | 2023-12-26 03:54:20 | trade | 2 | 53800 | 187 | 1.656 | 32487.9 |
527 | 2023-12-20 02:47:50 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
526 | 2023-12-19 07:14:17 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
525 | 2023-12-15 01:54:27 | trade | 2 | 53800 | 187 | 1.560 | 34487.2 |
524 | 2023-12-06 13:56:07 | trade | 2 | 53800 | 187 | 1.610 | 33416.1 |
523 | 2023-12-03 07:48:07 | trade | 1 | 28756 | 12 | 0.530 | 54256.6 |
522 | 2023-12-03 07:48:06 | trade | 1 | 28756 | 12 | 0.533 | 53951.2 |
521 | 2023-11-29 04:22:24 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
520 | 2023-11-17 20:21:03 | trade | 1 | 28756 | 12 | 1.080 | 26625.9 |
519 | 2023-11-13 05:53:41 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
518 | 2023-11-11 19:48:17 | trade | 2 | 53800 | 187 | 1.593 | 33772.8 |
517 | 2023-11-11 05:30:27 | trade | 1 | 28756 | 12 | 0.440 | 65354.5 |
516 | 2023-10-31 13:05:55 | trade | 1 | 28756 | 12 | 1.656 | 17364.7 |
515 | 2023-10-21 09:38:56 | trade | 1 | 28756 | 12 | 0.500 | 57512.0 |
514 | 2023-10-18 21:37:50 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
513 | 2023-10-14 18:30:56 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
512 | 2023-10-06 05:34:31 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
511 | 2023-10-03 16:11:39 | trade | 1 | 28756 | 12 | 0.450 | 63902.2 |
510 | 2023-09-26 13:10:47 | trade | 1 | 28756 | 12 | 0.486 | 59168.7 |
509 | 2023-09-11 05:28:54 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
508 | 2023-08-29 21:38:17 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
507 | 2023-08-01 12:33:19 | trade | 1 | 28756 | 12 | 0.440 | 65354.5 |
506 | 2023-05-01 18:53:10 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
505 | 2023-04-30 08:52:04 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
504 | 2023-02-19 16:19:28 | trade | 1 | 28756 | 12 | 0.440 | 65354.5 |
503 | 2023-01-08 07:36:27 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
502 | 2022-12-17 16:26:48 | trade | 1 | 28756 | 12 | 0.423 | 67981.1 |
501 | 2022-09-10 21:01:09 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
500 | 2022-09-06 14:26:11 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
499 | 2022-09-03 06:06:13 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
498 | 2022-09-01 03:06:32 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
497 | 2022-08-27 07:45:56 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
496 | 2022-08-15 02:22:49 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
495 | 2022-07-10 11:13:11 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
494 | 2022-07-02 20:20:12 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
493 | 2022-06-07 00:50:30 | trade | 1 | 28756 | 12 | 0.423 | 67981.1 |
492 | 2022-04-23 12:31:29 | trade | 1 | 28756 | 12 | 0.440 | 65354.5 |
491 | 2022-04-14 08:09:46 | trade | 1 | 28756 | 12 | 0.486 | 59168.7 |
490 | 2022-02-03 06:30:44 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
489 | 2022-02-03 01:14:16 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
488 | 2022-01-10 01:46:19 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
487 | 2021-12-28 16:11:34 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
486 | 2021-11-04 02:30:00 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
485 | 2021-10-22 05:15:34 | trade | 1 | 28756 | 12 | 0.440 | 65354.5 |
484 | 2021-10-22 04:59:14 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
483 | 2021-10-20 19:31:39 | trade | 1 | 28756 | 12 | 0.440 | 65354.5 |
482 | 2021-10-20 19:24:29 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
481 | 2021-10-20 02:15:17 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
480 | 2021-09-27 20:33:14 | trade | 1 | 28756 | 12 | 0.530 | 54256.6 |
479 | 2021-09-25 17:20:07 | trade | 1 | 28756 | 12 | 0.546 | 52666.7 |
478 | 2021-09-24 00:39:38 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
477 | 2021-09-22 12:11:14 | trade | 1 | 28756 | 12 | 0.450 | 63902.2 |
476 | 2021-09-15 02:40:10 | trade | 1 | 28756 | 12 | 0.500 | 57512.0 |
475 | 2021-08-19 18:27:28 | trade | 1 | 28756 | 12 | 0.470 | 61183.0 |
474 | 2021-08-17 14:08:58 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
473 | 2021-07-06 10:59:36 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
472 | 2021-06-15 03:02:26 | trade | 1 | 28756 | 12 | 0.470 | 61183.0 |
471 | 2021-05-05 20:25:33 | trade | 1 | 28756 | 12 | 0.516 | 55728.7 |
470 | 2021-04-03 15:42:52 | trade | 2 | 53800 | 187 | 1.406 | 38264.6 |
469 | 2021-03-15 17:33:12 | trade | 1 | 28756 | 12 | 0.626 | 45936.1 |
468 | 2021-02-12 14:07:52 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
467 | 2021-02-12 00:42:04 | trade | 2 | 53800 | 187 | 1.406 | 38264.6 |
466 | 2020-12-09 00:41:13 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
465 | 2020-11-08 16:24:36 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
464 | 2020-10-30 22:47:07 | trade | 1 | 28756 | 12 | 0.516 | 55728.7 |
463 | 2020-10-30 21:03:52 | trade | 1 | 28756 | 12 | 0.500 | 57512.0 |
462 | 2020-10-24 08:58:34 | trade | 1 | 28756 | 12 | 0.500 | 57512.0 |
461 | 2020-10-10 21:27:53 | trade | 1 | 28756 | 12 | 0.486 | 59168.7 |
460 | 2020-10-04 14:54:47 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
459 | 2020-09-02 09:22:40 | trade | 1 | 28756 | 12 | 0.593 | 48492.4 |
458 | 2020-06-21 23:04:58 | trade | 1 | 28756 | 12 | 0.640 | 44931.3 |
457 | 2020-05-16 05:06:48 | trade | 1 | 28756 | 12 | 0.470 | 61183.0 |
456 | 2020-05-13 04:16:51 | trade | 1 | 28756 | 12 | 0.453 | 63479.0 |
455 | 2020-03-29 03:12:55 | trade | 1 | 28756 | 12 | 0.653 | 44036.8 |
454 | 2020-03-24 22:03:04 | trade | 1 | 28756 | 12 | 0.533 | 53951.2 |
453 | 2020-03-23 05:00:53 | trade | 1 | 28756 | 12 | 0.530 | 54256.6 |
452 | 2020-03-22 04:26:40 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
451 | 2020-03-21 16:37:52 | trade | 1 | 28756 | 12 | 0.483 | 59536.2 |
450 | 2020-03-20 17:16:19 | trade | 1 | 28756 | 12 | 0.516 | 55728.7 |
449 | 2020-03-17 22:58:44 | trade | 1 | 28756 | 12 | 0.436 | 65954.1 |
448 | 2020-02-24 01:31:42 | trade | 1 | 28756 | 12 | 1.546 | 18600.3 |
447 | 2020-02-22 21:19:13 | trade | 1 | 28756 | 12 | 0.593 | 48492.4 |
446 | 2020-02-14 22:18:36 | trade | 1 | 28756 | 12 | 1.126 | 25538.2 |