History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tiara"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
525 | 2024-04-06 06:00:42 | tiara | 1 | 28756 | 2 | 0.530 | 54256.6 |
524 | 2024-04-03 02:57:52 | tiara | 2 | 53800 | 57 | 3.890 | 13830.3 |
523 | 2024-04-02 21:59:36 | tiara | 2 | 53800 | 57 | 3.780 | 14232.8 |
522 | 2024-04-02 21:59:18 | tiara | 3 | 83667 | 1154 | 13.843 | 6044.0 |
521 | 2024-04-02 21:59:20 | tiara | 2 | 53800 | 57 | 5.733 | 9384.3 |
520 | 2024-04-02 21:59:14 | tiara | 1 | 28756 | 2 | 0.560 | 51350.0 |
519 | 2024-04-02 21:58:43 | tiara | 3 | 83667 | 1154 | 6.733 | 12426.4 |
518 | 2024-04-02 16:03:02 | tiara | 3 | 83667 | 1154 | 4.263 | 19626.3 |
517 | 2024-03-31 15:46:11 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
516 | 2024-03-29 09:40:59 | tiara | 1 | 28756 | 2 | 0.906 | 31739.5 |
515 | 2024-03-18 16:47:21 | tiara | 1 | 28756 | 2 | 0.483 | 59536.2 |
514 | 2024-03-17 20:01:18 | tiara | 3 | 83667 | 1154 | 14.406 | 5807.8 |
513 | 2024-03-17 20:01:19 | tiara | 2 | 53800 | 57 | 1.890 | 28465.6 |
512 | 2024-03-07 04:09:23 | tiara | 1 | 28756 | 2 | 1.626 | 17685.1 |
511 | 2024-03-01 12:28:33 | tiara | 1 | 28756 | 2 | 0.483 | 59536.2 |
510 | 2024-03-01 10:31:03 | tiara | 1 | 28756 | 2 | 1.093 | 26309.2 |
509 | 2024-02-28 19:09:22 | tiara | 2 | 53800 | 57 | 1.373 | 39184.3 |
508 | 2024-02-28 18:21:34 | tiara | 3 | 83667 | 1154 | 3.533 | 23681.6 |
507 | 2024-02-28 11:08:59 | tiara | 2 | 53800 | 57 | 1.580 | 34050.6 |
506 | 2024-02-28 11:08:22 | tiara | 3 | 83667 | 1154 | 7.736 | 10815.3 |
505 | 2024-02-28 09:51:41 | tiara | 3 | 83667 | 1154 | 12.530 | 6677.3 |
504 | 2024-02-28 09:51:37 | tiara | 2 | 53800 | 57 | 5.733 | 9384.3 |
503 | 2024-02-28 08:01:40 | tiara | 1 | 28756 | 2 | 0.673 | 42728.1 |
502 | 2024-02-14 19:20:35 | tiara | 3 | 83667 | 1154 | 8.610 | 9717.4 |
501 | 2024-02-14 19:20:21 | tiara | 2 | 53800 | 57 | 1.783 | 30173.9 |
500 | 2024-02-13 03:11:19 | tiara | 2 | 53800 | 57 | 1.420 | 37887.3 |
499 | 2024-02-03 19:45:31 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
498 | 2024-01-29 09:03:47 | tiara | 1 | 28756 | 2 | 0.516 | 55728.7 |
497 | 2024-01-29 03:23:57 | tiara | 1 | 28756 | 2 | 0.483 | 59536.2 |
496 | 2024-01-19 13:57:39 | tiara | 1 | 28756 | 2 | 0.436 | 65954.1 |
495 | 2024-01-01 08:59:33 | tiara | 3 | 83667 | 1154 | 3.440 | 24321.8 |
494 | 2023-12-31 08:14:23 | tiara | 2 | 53800 | 57 | 1.516 | 35488.1 |
493 | 2023-12-30 06:30:31 | tiara | 3 | 83667 | 1154 | 3.440 | 24321.8 |
492 | 2023-12-26 13:26:43 | tiara | 2 | 53800 | 57 | 1.716 | 31352.0 |
491 | 2023-12-18 20:28:05 | tiara | 1 | 28756 | 2 | 0.483 | 59536.2 |
490 | 2023-12-06 20:53:31 | tiara | 3 | 83667 | 1154 | 3.860 | 21675.4 |
489 | 2023-11-29 22:16:31 | tiara | 3 | 83667 | 1154 | 6.800 | 12304.0 |
488 | 2023-11-29 22:16:29 | tiara | 2 | 53800 | 57 | 1.593 | 33772.8 |
487 | 2023-11-13 23:14:36 | tiara | 1 | 28756 | 2 | 0.500 | 57512.0 |
486 | 2023-11-13 16:09:37 | tiara | 1 | 28756 | 2 | 0.440 | 65354.5 |
485 | 2023-11-13 10:04:19 | tiara | 2 | 53800 | 57 | 1.390 | 38705.0 |
484 | 2023-11-03 07:13:11 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
483 | 2023-10-22 02:36:58 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
482 | 2023-10-18 15:37:06 | tiara | 1 | 28756 | 2 | 0.466 | 61708.2 |
481 | 2023-10-13 14:53:49 | tiara | 1 | 28756 | 2 | 0.483 | 59536.2 |
480 | 2023-10-06 20:36:46 | tiara | 1 | 28756 | 2 | 0.436 | 65954.1 |
479 | 2023-10-05 17:27:34 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
478 | 2023-09-28 08:10:56 | tiara | 1 | 28756 | 2 | 0.470 | 61183.0 |
477 | 2023-09-22 08:05:20 | tiara | 1 | 28756 | 2 | 0.483 | 59536.2 |
476 | 2023-09-12 19:36:31 | tiara | 3 | 83667 | 1154 | 4.080 | 20506.6 |
475 | 2023-09-10 16:03:52 | tiara | 3 | 83667 | 1154 | 3.860 | 21675.4 |
474 | 2023-09-09 06:16:43 | tiara | 1 | 28756 | 2 | 0.563 | 51076.4 |
473 | 2023-09-05 02:01:21 | tiara | 3 | 83667 | 1154 | 3.673 | 22778.9 |
472 | 2023-08-15 14:22:51 | tiara | 2 | 53800 | 57 | 1.390 | 38705.0 |
471 | 2023-08-02 10:24:09 | tiara | 1 | 28756 | 2 | 0.436 | 65954.1 |
470 | 2023-05-09 08:48:30 | tiara | 1 | 28756 | 2 | 0.470 | 61183.0 |
469 | 2023-04-30 13:41:17 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
468 | 2023-04-27 19:22:25 | tiara | 2 | 53800 | 57 | 1.373 | 39184.3 |
467 | 2023-02-23 11:25:54 | tiara | 1 | 28756 | 2 | 0.436 | 65954.1 |
466 | 2023-02-19 15:14:52 | tiara | 2 | 53800 | 57 | 1.360 | 39558.8 |
465 | 2023-02-09 07:26:55 | tiara | 3 | 83667 | 1154 | 3.950 | 21181.5 |
464 | 2023-02-02 05:31:31 | tiara | 2 | 53800 | 57 | 1.530 | 35163.4 |
463 | 2023-01-23 06:46:55 | tiara | 2 | 53800 | 57 | 1.373 | 39184.3 |
462 | 2023-01-16 00:07:05 | tiara | 1 | 28756 | 2 | 0.436 | 65954.1 |
461 | 2022-12-23 23:16:56 | tiara | 1 | 28756 | 2 | 1.000 | 28756.0 |
460 | 2022-12-16 02:34:59 | tiara | 3 | 83667 | 1154 | 3.733 | 22412.8 |
459 | 2022-12-10 07:26:44 | tiara | 2 | 53800 | 57 | 1.670 | 32215.6 |
458 | 2022-11-26 11:56:45 | tiara | 3 | 83667 | 1154 | 3.890 | 21508.2 |
457 | 2022-11-21 10:56:31 | tiara | 3 | 83667 | 1154 | 4.670 | 17915.8 |
456 | 2022-11-16 22:01:30 | tiara | 2 | 53800 | 57 | 1.406 | 38264.6 |
455 | 2022-11-16 05:31:42 | tiara | 3 | 83667 | 1154 | 3.563 | 23482.2 |
454 | 2022-11-11 05:57:57 | tiara | 3 | 83667 | 1154 | 4.423 | 18916.3 |
453 | 2022-11-01 13:31:29 | tiara | 3 | 83667 | 1154 | 3.983 | 21006.0 |
452 | 2022-10-29 14:48:02 | tiara | 3 | 83667 | 1154 | 4.000 | 20916.8 |
451 | 2022-10-21 17:07:58 | tiara | 3 | 83667 | 1154 | 7.750 | 10795.7 |
450 | 2022-09-29 16:16:35 | tiara | 3 | 83667 | 1154 | 3.296 | 25384.4 |
449 | 2022-09-10 09:04:16 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
448 | 2022-09-07 07:09:16 | tiara | 1 | 28756 | 2 | 0.423 | 67981.1 |
447 | 2022-09-02 15:10:26 | tiara | 3 | 83667 | 1154 | 3.533 | 23681.6 |
446 | 2022-09-01 05:11:36 | tiara | 1 | 28756 | 2 | 0.466 | 61708.2 |
445 | 2022-07-31 20:25:17 | tiara | 1 | 28756 | 2 | 0.530 | 54256.6 |
444 | 2022-06-13 18:38:42 | tiara | 1 | 28756 | 2 | 0.436 | 65954.1 |
443 | 2022-05-23 15:35:39 | tiara | 3 | 83667 | 1154 | 3.640 | 22985.4 |
442 | 2022-05-20 06:04:47 | tiara | 3 | 83667 | 1154 | 3.436 | 24350.1 |
441 | 2022-05-13 22:43:33 | tiara | 3 | 83667 | 1154 | 3.860 | 21675.4 |
440 | 2022-05-07 15:12:16 | tiara | 1 | 28756 | 2 | 0.440 | 65354.5 |
439 | 2022-04-27 10:26:09 | tiara | 1 | 28756 | 2 | 0.500 | 57512.0 |
438 | 2022-04-27 09:52:00 | tiara | 2 | 53800 | 57 | 1.640 | 32804.9 |
437 | 2022-04-25 00:13:08 | tiara | 1 | 28756 | 2 | 0.516 | 55728.7 |
436 | 2022-04-22 17:30:47 | tiara | 1 | 28756 | 2 | 0.500 | 57512.0 |
435 | 2022-01-20 14:47:43 | tiara | 1 | 28756 | 2 | 0.483 | 59536.2 |
434 | 2022-01-11 07:43:01 | tiara | 3 | 83667 | 1154 | 3.593 | 23286.1 |
433 | 2022-01-01 01:27:42 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
432 | 2021-12-23 15:29:00 | tiara | 1 | 28756 | 2 | 0.530 | 54256.6 |
431 | 2021-12-22 18:32:20 | tiara | 1 | 28756 | 2 | 0.530 | 54256.6 |
430 | 2021-12-21 19:05:12 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
429 | 2021-12-20 18:42:14 | tiara | 1 | 28756 | 2 | 0.533 | 53951.2 |
428 | 2021-11-16 06:13:04 | tiara | 1 | 28756 | 2 | 0.436 | 65954.1 |
427 | 2021-11-14 04:44:39 | tiara | 1 | 28756 | 2 | 0.453 | 63479.0 |
426 | 2021-10-21 23:16:45 | tiara | 3 | 83667 | 1154 | 4.013 | 20849.0 |