History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opals"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
545 | 2024-04-21 07:15:03 | opals | 1 | 28756 | 8 | 0.483 | 59536.2 |
544 | 2024-04-19 09:32:07 | opals | 2 | 53800 | 123 | 1.500 | 35866.7 |
543 | 2024-04-13 18:07:51 | opals | 1 | 28756 | 8 | 0.580 | 49579.3 |
542 | 2024-04-05 17:26:13 | opals | 2 | 53800 | 123 | 6.813 | 7896.7 |
541 | 2024-04-05 17:16:14 | opals | 1 | 28756 | 8 | 1.123 | 25606.4 |
540 | 2024-04-01 13:03:16 | opals | 1 | 28756 | 8 | 1.126 | 25538.2 |
539 | 2024-03-31 13:59:27 | opals | 2 | 53800 | 123 | 2.030 | 26502.5 |
538 | 2024-03-31 13:59:10 | opals | 1 | 28756 | 8 | 1.203 | 23903.6 |
537 | 2024-03-31 13:58:52 | opals | 2 | 53800 | 123 | 3.843 | 13999.5 |
536 | 2024-03-31 10:16:06 | opals | 2 | 53800 | 123 | 2.830 | 19010.6 |
535 | 2024-03-31 08:19:17 | opals | 1 | 28756 | 8 | 0.750 | 38341.3 |
534 | 2024-03-29 02:36:53 | opals | 1 | 28756 | 8 | 0.576 | 49923.6 |
533 | 2024-03-23 15:17:46 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
532 | 2024-03-04 18:38:33 | opals | 2 | 53800 | 123 | 5.216 | 10314.4 |
531 | 2024-03-04 18:16:25 | opals | 1 | 28756 | 8 | 1.013 | 28387.0 |
530 | 2024-03-01 03:59:44 | opals | 1 | 28756 | 8 | 1.046 | 27491.4 |
529 | 2024-02-27 22:00:14 | opals | 2 | 53800 | 123 | 2.660 | 20225.6 |
528 | 2024-02-27 21:05:57 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
527 | 2024-02-25 05:26:28 | opals | 1 | 28756 | 8 | 0.533 | 53951.2 |
526 | 2024-02-12 12:11:26 | opals | 1 | 28756 | 8 | 0.546 | 52666.7 |
525 | 2024-02-03 17:24:15 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
524 | 2024-01-29 03:48:15 | opals | 1 | 28756 | 8 | 0.453 | 63479.0 |
523 | 2024-01-28 20:08:05 | opals | 1 | 28756 | 8 | 0.423 | 67981.1 |
522 | 2023-12-22 23:31:18 | opals | 2 | 53800 | 123 | 1.533 | 35094.6 |
521 | 2023-12-22 14:08:52 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
520 | 2023-12-20 06:48:56 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
519 | 2023-12-15 19:47:39 | opals | 2 | 53800 | 123 | 1.390 | 38705.0 |
518 | 2023-12-09 13:23:11 | opals | 1 | 28756 | 8 | 0.560 | 51350.0 |
517 | 2023-12-07 09:42:30 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
516 | 2023-12-07 03:22:05 | opals | 1 | 28756 | 8 | 0.593 | 48492.4 |
515 | 2023-12-07 03:22:03 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
514 | 2023-11-27 03:53:02 | opals | 1 | 28756 | 8 | 0.420 | 68466.7 |
513 | 2023-11-18 21:12:05 | opals | 1 | 28756 | 8 | 0.576 | 49923.6 |
512 | 2023-11-12 07:42:15 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
511 | 2023-11-03 13:30:31 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
510 | 2023-11-01 07:59:35 | opals | 1 | 28756 | 8 | 0.470 | 61183.0 |
509 | 2023-10-19 22:31:49 | opals | 1 | 28756 | 8 | 0.453 | 63479.0 |
508 | 2023-10-19 21:42:24 | opals | 1 | 28756 | 8 | 0.440 | 65354.5 |
507 | 2023-10-11 02:21:46 | opals | 1 | 28756 | 8 | 0.453 | 63479.0 |
506 | 2023-10-05 17:34:02 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
505 | 2023-10-05 06:20:43 | opals | 1 | 28756 | 8 | 0.486 | 59168.7 |
504 | 2023-09-28 22:50:30 | opals | 1 | 28756 | 8 | 0.440 | 65354.5 |
503 | 2023-09-16 15:48:04 | opals | 2 | 53800 | 123 | 1.596 | 33709.3 |
502 | 2023-09-15 17:20:58 | opals | 1 | 28756 | 8 | 0.423 | 67981.1 |
501 | 2023-08-12 20:08:41 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
500 | 2023-08-11 14:18:07 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
499 | 2023-08-11 02:52:53 | opals | 1 | 28756 | 8 | 0.420 | 68466.7 |
498 | 2023-08-07 22:48:35 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
497 | 2023-07-11 22:13:32 | opals | 1 | 28756 | 8 | 0.483 | 59536.2 |
496 | 2023-06-21 12:39:46 | opals | 2 | 53800 | 123 | 1.546 | 34799.5 |
495 | 2023-06-17 15:34:39 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
494 | 2023-05-09 23:23:56 | opals | 1 | 28756 | 8 | 0.440 | 65354.5 |
493 | 2023-04-29 08:45:58 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
492 | 2023-04-28 04:38:59 | opals | 1 | 28756 | 8 | 0.440 | 65354.5 |
491 | 2023-04-26 16:01:28 | opals | 1 | 28756 | 8 | 0.450 | 63902.2 |
490 | 2023-03-31 12:43:59 | opals | 1 | 28756 | 8 | 0.483 | 59536.2 |
489 | 2023-03-20 04:31:31 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
488 | 2023-03-17 06:37:11 | opals | 2 | 53800 | 123 | 1.360 | 39558.8 |
487 | 2023-02-19 14:32:57 | opals | 1 | 28756 | 8 | 0.483 | 59536.2 |
486 | 2023-01-24 18:50:08 | opals | 1 | 28756 | 8 | 0.423 | 67981.1 |
485 | 2023-01-06 21:05:47 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
484 | 2022-12-20 04:23:49 | opals | 2 | 53800 | 123 | 1.516 | 35488.1 |
483 | 2022-12-19 04:41:38 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
482 | 2022-12-10 09:40:18 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
481 | 2022-12-01 02:51:15 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
480 | 2022-10-24 04:35:24 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
479 | 2022-10-15 00:50:44 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
478 | 2022-09-12 08:06:12 | opals | 1 | 28756 | 8 | 0.440 | 65354.5 |
477 | 2022-09-10 14:29:31 | opals | 1 | 28756 | 8 | 0.453 | 63479.0 |
476 | 2022-09-08 17:58:52 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
475 | 2022-09-01 15:22:21 | opals | 1 | 28756 | 8 | 0.516 | 55728.7 |
474 | 2022-08-30 10:44:20 | opals | 1 | 28756 | 8 | 0.453 | 63479.0 |
473 | 2022-08-15 18:05:33 | opals | 2 | 53800 | 123 | 1.420 | 37887.3 |
472 | 2022-07-22 19:26:44 | opals | 1 | 28756 | 8 | 0.483 | 59536.2 |
471 | 2022-07-11 15:22:34 | opals | 1 | 28756 | 8 | 0.423 | 67981.1 |
470 | 2022-07-10 04:00:44 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
469 | 2022-06-16 05:58:10 | opals | 1 | 28756 | 8 | 0.423 | 67981.1 |
468 | 2022-06-09 22:58:30 | opals | 1 | 28756 | 8 | 0.453 | 63479.0 |
467 | 2022-06-01 15:25:03 | opals | 1 | 28756 | 8 | 0.440 | 65354.5 |
466 | 2022-05-24 03:32:53 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
465 | 2022-05-10 08:17:32 | opals | 1 | 28756 | 8 | 0.516 | 55728.7 |
464 | 2022-05-10 04:00:21 | opals | 1 | 28756 | 8 | 0.483 | 59536.2 |
463 | 2022-04-14 22:46:22 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
462 | 2022-04-05 06:54:20 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
461 | 2022-03-22 12:49:32 | opals | 1 | 28756 | 8 | 0.563 | 51076.4 |
460 | 2022-03-18 09:24:15 | opals | 2 | 53800 | 123 | 1.563 | 34421.0 |
459 | 2022-01-22 09:24:59 | opals | 1 | 28756 | 8 | 0.470 | 61183.0 |
458 | 2022-01-10 17:08:01 | opals | 1 | 28756 | 8 | 0.470 | 61183.0 |
457 | 2022-01-08 13:31:58 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
456 | 2021-12-05 13:59:49 | opals | 1 | 28756 | 8 | 0.513 | 56054.6 |
455 | 2021-12-03 08:51:08 | opals | 2 | 53800 | 123 | 1.390 | 38705.0 |
454 | 2021-11-02 14:53:03 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
453 | 2021-10-31 16:21:31 | opals | 1 | 28756 | 8 | 0.500 | 57512.0 |
452 | 2021-10-12 15:47:53 | opals | 1 | 28756 | 8 | 1.000 | 28756.0 |
451 | 2021-09-26 08:46:57 | opals | 1 | 28756 | 8 | 0.453 | 63479.0 |
450 | 2021-09-24 05:29:21 | opals | 1 | 28756 | 8 | 0.513 | 56054.6 |
449 | 2021-08-18 05:41:37 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |
448 | 2021-08-16 00:37:40 | opals | 1 | 28756 | 8 | 0.420 | 68466.7 |
447 | 2021-07-28 15:53:59 | opals | 1 | 28756 | 8 | 0.440 | 65354.5 |
446 | 2021-07-11 13:45:37 | opals | 1 | 28756 | 8 | 0.436 | 65954.1 |