History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canyons"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
550 | 2024-04-25 23:37:30 | canyons | 2 | 107671 | 41 | 5.470 | 19683.9 |
549 | 2024-04-25 20:37:22 | canyons | 3 | 134027 | 414 | 23.766 | 5639.4 |
548 | 2024-04-25 17:16:22 | canyons | 3 | 134027 | 414 | 21.690 | 6179.2 |
547 | 2024-04-25 15:54:48 | canyons | 3 | 134027 | 414 | 7.140 | 18771.3 |
546 | 2024-04-25 04:51:32 | canyons | 2 | 107671 | 41 | 8.190 | 13146.6 |
545 | 2024-04-25 04:48:59 | canyons | 2 | 107671 | 41 | 3.983 | 27032.6 |
544 | 2024-04-25 04:48:56 | canyons | 1 | 69583 | 6 | 2.140 | 32515.4 |
543 | 2024-04-25 04:32:42 | canyons | 1 | 69583 | 6 | 3.500 | 19880.9 |
542 | 2024-04-24 23:15:45 | canyons | 1 | 69583 | 6 | 1.406 | 49490.0 |
541 | 2024-04-23 03:37:16 | canyons | 3 | 134027 | 414 | 11.783 | 11374.6 |
540 | 2024-04-23 03:37:15 | canyons | 1 | 69583 | 6 | 1.360 | 51164.0 |
539 | 2024-04-23 03:37:05 | canyons | 2 | 107671 | 41 | 4.003 | 26897.6 |
538 | 2024-04-21 11:40:54 | canyons | 2 | 107671 | 41 | 3.343 | 32207.9 |
537 | 2024-04-11 00:56:40 | canyons | 1 | 69583 | 6 | 1.360 | 51164.0 |
536 | 2024-04-01 18:42:58 | canyons | 1 | 69583 | 6 | 2.436 | 28564.4 |
535 | 2024-02-15 21:37:32 | canyons | 3 | 134027 | 414 | 9.080 | 14760.7 |
534 | 2024-02-13 18:17:53 | canyons | 3 | 134027 | 414 | 8.610 | 15566.4 |
533 | 2024-02-12 15:58:29 | canyons | 3 | 134027 | 414 | 14.080 | 9519.0 |
532 | 2024-02-11 18:02:23 | canyons | 3 | 134027 | 414 | 21.270 | 6301.2 |
531 | 2024-02-11 14:12:15 | canyons | 3 | 134027 | 414 | 5.780 | 23188.1 |
530 | 2024-02-09 06:04:13 | canyons | 1 | 69583 | 6 | 1.093 | 63662.4 |
529 | 2024-01-13 10:35:47 | canyons | 2 | 107671 | 41 | 3.343 | 32207.9 |
528 | 2024-01-09 10:11:00 | canyons | 3 | 134027 | 414 | 8.610 | 15566.4 |
527 | 2024-01-06 22:20:53 | canyons | 3 | 134027 | 414 | 6.406 | 20922.1 |
526 | 2024-01-06 22:20:48 | canyons | 2 | 107671 | 41 | 3.263 | 32997.5 |
525 | 2023-12-26 13:43:02 | canyons | 1 | 69583 | 6 | 1.093 | 63662.4 |
524 | 2023-12-23 09:10:06 | canyons | 1 | 69583 | 6 | 1.170 | 59472.6 |
523 | 2023-12-20 16:49:01 | canyons | 3 | 134027 | 414 | 6.423 | 20866.7 |
522 | 2023-12-20 16:49:04 | canyons | 2 | 107671 | 41 | 3.373 | 31921.4 |
521 | 2023-12-14 19:41:28 | canyons | 2 | 107671 | 41 | 2.970 | 36252.9 |
520 | 2023-11-26 03:51:18 | canyons | 1 | 69583 | 6 | 1.220 | 57035.2 |
519 | 2023-11-17 12:26:24 | canyons | 1 | 69583 | 6 | 1.126 | 61796.6 |
518 | 2023-11-15 12:25:40 | canyons | 3 | 134027 | 414 | 6.016 | 22278.4 |
517 | 2023-11-15 12:25:35 | canyons | 2 | 107671 | 41 | 3.093 | 34811.2 |
516 | 2023-11-15 10:41:50 | canyons | 3 | 134027 | 414 | 6.750 | 19855.9 |
515 | 2023-11-12 06:38:03 | canyons | 1 | 69583 | 6 | 1.096 | 63488.1 |
514 | 2023-11-07 02:17:16 | canyons | 1 | 69583 | 6 | 1.186 | 58670.3 |
513 | 2023-11-01 06:19:51 | canyons | 1 | 69583 | 6 | 2.610 | 26660.2 |
512 | 2023-10-31 14:57:56 | canyons | 1 | 69583 | 6 | 2.593 | 26834.9 |
511 | 2023-10-22 01:39:01 | canyons | 1 | 69583 | 6 | 1.266 | 54962.9 |
510 | 2023-10-15 13:48:13 | canyons | 1 | 69583 | 6 | 1.296 | 53690.6 |
509 | 2023-10-13 12:43:53 | canyons | 1 | 69583 | 6 | 1.233 | 56433.9 |
508 | 2023-09-25 00:23:11 | canyons | 1 | 69583 | 6 | 1.140 | 61037.7 |
507 | 2023-09-23 11:52:50 | canyons | 1 | 69583 | 6 | 1.266 | 54962.9 |
506 | 2023-09-20 02:11:48 | canyons | 1 | 69583 | 6 | 1.106 | 62914.1 |
505 | 2023-09-14 12:47:42 | canyons | 2 | 107671 | 41 | 3.580 | 30075.7 |
504 | 2023-08-16 21:43:23 | canyons | 3 | 134027 | 414 | 6.500 | 20619.5 |
503 | 2023-08-09 22:08:59 | canyons | 1 | 69583 | 6 | 1.126 | 61796.6 |
502 | 2023-08-01 18:43:34 | canyons | 1 | 69583 | 6 | 1.233 | 56433.9 |
501 | 2023-07-30 22:48:26 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
500 | 2023-07-23 10:53:32 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
499 | 2023-07-09 19:31:24 | canyons | 1 | 69583 | 6 | 1.203 | 57841.2 |
498 | 2023-07-08 05:33:39 | canyons | 1 | 69583 | 6 | 1.220 | 57035.2 |
497 | 2023-07-07 01:36:56 | canyons | 1 | 69583 | 6 | 1.250 | 55666.4 |
496 | 2023-07-06 09:13:37 | canyons | 1 | 69583 | 6 | 1.266 | 54962.9 |
495 | 2023-07-04 16:29:26 | canyons | 1 | 69583 | 6 | 1.266 | 54962.9 |
494 | 2023-07-03 20:01:19 | canyons | 1 | 69583 | 6 | 2.236 | 31119.4 |
493 | 2023-07-02 22:10:58 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
492 | 2023-07-02 02:38:52 | canyons | 1 | 69583 | 6 | 1.236 | 56296.9 |
491 | 2023-07-01 12:03:29 | canyons | 1 | 69583 | 6 | 2.373 | 29322.8 |
490 | 2023-06-30 18:30:45 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
489 | 2023-06-30 02:15:07 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
488 | 2023-06-29 02:30:23 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
487 | 2023-06-28 05:53:57 | canyons | 1 | 69583 | 6 | 1.093 | 63662.4 |
486 | 2023-06-27 11:10:39 | canyons | 1 | 69583 | 6 | 1.126 | 61796.6 |
485 | 2023-06-26 22:52:04 | canyons | 1 | 69583 | 6 | 1.093 | 63662.4 |
484 | 2023-06-26 01:37:50 | canyons | 1 | 69583 | 6 | 1.250 | 55666.4 |
483 | 2023-06-25 05:25:47 | canyons | 1 | 69583 | 6 | 1.236 | 56296.9 |
482 | 2023-06-24 15:56:51 | canyons | 1 | 69583 | 6 | 1.236 | 56296.9 |
481 | 2023-06-23 20:36:39 | canyons | 1 | 69583 | 6 | 1.283 | 54234.6 |
480 | 2023-06-22 07:44:18 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
479 | 2023-06-21 15:47:56 | canyons | 1 | 69583 | 6 | 1.220 | 57035.2 |
478 | 2023-06-20 23:23:38 | canyons | 1 | 69583 | 6 | 1.076 | 64668.2 |
477 | 2023-06-20 05:11:39 | canyons | 1 | 69583 | 6 | 1.236 | 56296.9 |
476 | 2023-06-19 11:05:44 | canyons | 1 | 69583 | 6 | 1.093 | 63662.4 |
475 | 2023-06-18 22:10:27 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
474 | 2023-06-18 00:45:19 | canyons | 2 | 107671 | 41 | 2.923 | 36835.8 |
473 | 2023-06-17 23:21:38 | canyons | 1 | 69583 | 6 | 1.096 | 63488.1 |
472 | 2023-06-17 02:24:23 | canyons | 1 | 69583 | 6 | 1.156 | 60192.9 |
471 | 2023-06-16 08:31:14 | canyons | 1 | 69583 | 6 | 1.076 | 64668.2 |
470 | 2023-06-15 15:25:39 | canyons | 1 | 69583 | 6 | 1.220 | 57035.2 |
469 | 2023-06-14 01:46:32 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
468 | 2023-06-13 05:07:20 | canyons | 1 | 69583 | 6 | 1.233 | 56433.9 |
467 | 2023-06-12 13:22:12 | canyons | 1 | 69583 | 6 | 1.220 | 57035.2 |
466 | 2023-06-11 13:37:57 | canyons | 1 | 69583 | 6 | 1.110 | 62687.4 |
465 | 2023-06-10 04:05:37 | canyons | 1 | 69583 | 6 | 1.076 | 64668.2 |
464 | 2023-06-09 11:26:54 | canyons | 1 | 69583 | 6 | 1.220 | 57035.2 |
463 | 2023-06-08 06:31:44 | canyons | 1 | 69583 | 6 | 1.093 | 63662.4 |
462 | 2023-05-30 09:50:16 | canyons | 3 | 134027 | 414 | 5.763 | 23256.5 |
461 | 2023-05-09 11:05:38 | canyons | 1 | 69583 | 6 | 1.296 | 53690.6 |
460 | 2023-04-23 21:00:14 | canyons | 3 | 134027 | 414 | 6.796 | 19721.5 |
459 | 2023-04-22 20:10:29 | canyons | 1 | 69583 | 6 | 1.093 | 63662.4 |
458 | 2023-04-21 20:34:20 | canyons | 1 | 69583 | 6 | 1.250 | 55666.4 |
457 | 2023-04-20 20:02:10 | canyons | 1 | 69583 | 6 | 1.140 | 61037.7 |
456 | 2023-04-11 17:34:47 | canyons | 1 | 69583 | 6 | 1.080 | 64428.7 |
455 | 2023-03-27 17:14:50 | canyons | 3 | 134027 | 414 | 7.156 | 18729.3 |
454 | 2023-03-20 21:49:12 | canyons | 2 | 107671 | 41 | 2.876 | 37437.8 |
453 | 2023-03-04 10:32:51 | canyons | 1 | 69583 | 6 | 1.106 | 62914.1 |
452 | 2023-02-28 05:19:12 | canyons | 3 | 134027 | 414 | 7.716 | 17370.0 |
451 | 2023-01-30 11:24:11 | canyons | 3 | 134027 | 414 | 6.533 | 20515.4 |