History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mecca"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
556 | 2025-04-20 07:21:52 | mecca | 1 | 28756 | 2 | 0.516 | 55728.7 |
555 | 2025-04-20 04:44:28 | mecca | 1 | 28756 | 2 | 2.530 | 11366.0 |
554 | 2025-04-16 10:27:35 | mecca | 3 | 83667 | 528 | 9.706 | 8620.1 |
553 | 2025-04-16 06:34:49 | mecca | 3 | 83667 | 528 | 15.876 | 5270.0 |
552 | 2025-04-14 16:02:20 | mecca | 3 | 83667 | 528 | 18.440 | 4537.3 |
551 | 2025-04-13 21:57:49 | mecca | 2 | 53800 | 28 | 7.970 | 6750.3 |
550 | 2025-04-13 05:47:55 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
549 | 2025-03-31 12:41:39 | mecca | 1 | 28756 | 2 | 2.406 | 11951.8 |
548 | 2025-03-31 05:41:24 | mecca | 1 | 28756 | 2 | 1.983 | 14501.3 |
547 | 2025-03-20 09:11:27 | mecca | 1 | 28756 | 2 | 1.250 | 23004.8 |
546 | 2025-03-20 07:03:37 | mecca | 1 | 28756 | 2 | 1.123 | 25606.4 |
545 | 2025-03-12 20:31:20 | mecca | 1 | 28756 | 2 | 2.220 | 12953.2 |
544 | 2025-03-11 15:58:25 | mecca | 1 | 28756 | 2 | 0.936 | 30722.2 |
543 | 2025-03-01 15:58:54 | mecca | 2 | 53800 | 28 | 7.563 | 7113.6 |
542 | 2025-02-28 02:23:15 | mecca | 1 | 28756 | 2 | 1.076 | 26724.9 |
541 | 2025-02-28 01:23:50 | mecca | 2 | 53800 | 28 | 6.546 | 8218.8 |
540 | 2025-02-27 15:42:23 | mecca | 3 | 83667 | 528 | 26.046 | 3212.3 |
539 | 2025-02-27 15:42:16 | mecca | 2 | 53800 | 28 | 6.186 | 8697.1 |
538 | 2025-02-27 15:40:01 | mecca | 1 | 28756 | 2 | 2.360 | 12184.7 |
537 | 2025-02-27 12:20:13 | mecca | 1 | 28756 | 2 | 2.250 | 12780.4 |
536 | 2025-02-23 01:16:27 | mecca | 3 | 83667 | 528 | 28.076 | 2980.0 |
535 | 2025-02-23 01:16:25 | mecca | 2 | 53800 | 28 | 7.656 | 7027.2 |
534 | 2025-02-14 07:28:16 | mecca | 1 | 28756 | 2 | 2.530 | 11366.0 |
533 | 2025-02-14 01:07:35 | mecca | 3 | 83667 | 528 | 23.910 | 3499.2 |
532 | 2025-02-12 16:33:20 | mecca | 3 | 83667 | 528 | 16.330 | 5123.5 |
531 | 2025-02-11 20:02:20 | mecca | 3 | 83667 | 528 | 13.970 | 5989.0 |
530 | 2025-02-11 07:16:32 | mecca | 1 | 28756 | 2 | 2.843 | 10114.7 |
529 | 2025-02-08 09:50:11 | mecca | 1 | 28756 | 2 | 1.576 | 18246.2 |
528 | 2025-01-28 21:43:54 | mecca | 2 | 53800 | 28 | 1.530 | 35163.4 |
527 | 2025-01-28 21:43:47 | mecca | 1 | 28756 | 2 | 0.530 | 54256.6 |
526 | 2025-01-28 09:56:17 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
525 | 2025-01-09 01:25:14 | mecca | 3 | 83667 | 528 | 23.000 | 3637.7 |
524 | 2025-01-07 11:57:25 | mecca | 1 | 28756 | 2 | 3.736 | 7697.0 |
523 | 2025-01-05 07:28:49 | mecca | 3 | 83667 | 528 | 13.656 | 6126.8 |
522 | 2025-01-02 18:15:33 | mecca | 3 | 83667 | 528 | 19.313 | 4332.2 |
521 | 2024-12-30 03:35:23 | mecca | 3 | 83667 | 528 | 15.000 | 5577.8 |
520 | 2024-12-29 10:42:26 | mecca | 1 | 28756 | 2 | 0.436 | 65954.1 |
519 | 2024-12-29 04:30:36 | mecca | 3 | 83667 | 528 | 14.143 | 5915.8 |
518 | 2024-12-29 04:30:36 | mecca | 2 | 53800 | 28 | 5.986 | 8987.6 |
517 | 2024-12-29 04:14:50 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
516 | 2024-12-27 11:50:01 | mecca | 3 | 83667 | 528 | 23.613 | 3543.3 |
515 | 2024-12-10 00:25:03 | mecca | 3 | 83667 | 528 | 18.860 | 4436.2 |
514 | 2024-12-10 00:25:02 | mecca | 2 | 53800 | 28 | 7.360 | 7309.8 |
513 | 2024-12-10 00:24:59 | mecca | 1 | 28756 | 2 | 1.203 | 23903.6 |
512 | 2024-12-05 14:25:55 | mecca | 1 | 28756 | 2 | 2.186 | 13154.6 |
511 | 2024-12-05 11:58:43 | mecca | 3 | 83667 | 528 | 27.296 | 3065.2 |
510 | 2024-12-04 11:21:09 | mecca | 3 | 83667 | 528 | 29.406 | 2845.2 |
509 | 2024-11-29 06:31:00 | mecca | 2 | 53800 | 28 | 8.050 | 6683.2 |
508 | 2024-11-29 06:13:34 | mecca | 1 | 28756 | 2 | 0.500 | 57512.0 |
507 | 2024-11-29 06:08:01 | mecca | 3 | 83667 | 528 | 13.733 | 6092.4 |
506 | 2024-11-29 04:08:39 | mecca | 3 | 83667 | 528 | 9.800 | 8537.4 |
505 | 2024-11-29 04:08:38 | mecca | 2 | 53800 | 28 | 6.080 | 8848.7 |
504 | 2024-11-29 03:49:51 | mecca | 1 | 28756 | 2 | 0.860 | 33437.2 |
503 | 2024-11-18 18:08:04 | mecca | 1 | 28756 | 2 | 2.300 | 12502.6 |
502 | 2024-11-16 12:28:18 | mecca | 3 | 83667 | 528 | 19.610 | 4266.5 |
501 | 2024-11-09 09:48:40 | mecca | 3 | 83667 | 528 | 5.296 | 15798.1 |
500 | 2024-11-09 09:48:42 | mecca | 2 | 53800 | 28 | 2.376 | 22643.1 |
499 | 2024-11-09 06:49:03 | mecca | 1 | 28756 | 2 | 1.313 | 21901.0 |
498 | 2024-11-03 16:23:33 | mecca | 2 | 53800 | 28 | 1.626 | 33087.3 |
497 | 2024-11-03 16:23:16 | mecca | 3 | 83667 | 528 | 4.140 | 20209.4 |
496 | 2024-10-30 05:37:29 | mecca | 3 | 83667 | 528 | 19.330 | 4328.3 |
495 | 2024-10-30 05:37:26 | mecca | 2 | 53800 | 28 | 11.593 | 4640.7 |
494 | 2024-10-30 04:46:32 | mecca | 1 | 28756 | 2 | 0.450 | 63902.2 |
493 | 2024-10-30 04:27:50 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
492 | 2024-10-20 07:42:25 | mecca | 1 | 28756 | 2 | 1.220 | 23570.5 |
491 | 2024-10-06 17:54:58 | mecca | 3 | 83667 | 528 | 36.063 | 2320.0 |
490 | 2024-10-06 17:54:55 | mecca | 2 | 53800 | 28 | 10.670 | 5042.2 |
489 | 2024-10-06 03:32:25 | mecca | 3 | 83667 | 528 | 30.360 | 2755.8 |
488 | 2024-10-04 17:17:44 | mecca | 1 | 28756 | 2 | 2.376 | 12102.7 |
487 | 2024-10-04 17:07:36 | mecca | 2 | 53800 | 28 | 9.716 | 5537.3 |
486 | 2024-10-04 17:07:13 | mecca | 3 | 83667 | 528 | 7.346 | 11389.5 |
485 | 2024-10-03 00:14:52 | mecca | 3 | 83667 | 528 | 27.486 | 3044.0 |
484 | 2024-10-03 00:14:51 | mecca | 2 | 53800 | 28 | 11.123 | 4836.8 |
483 | 2024-09-29 23:48:22 | mecca | 1 | 28756 | 2 | 0.486 | 59168.7 |
482 | 2024-09-29 23:47:19 | mecca | 1 | 28756 | 2 | 0.530 | 54256.6 |
481 | 2024-09-07 13:37:22 | mecca | 1 | 28756 | 2 | 1.986 | 14479.4 |
480 | 2024-08-30 23:42:15 | mecca | 3 | 83667 | 528 | 34.000 | 2460.8 |
479 | 2024-08-30 23:40:21 | mecca | 2 | 53800 | 28 | 19.736 | 2726.0 |
478 | 2024-08-30 21:30:00 | mecca | 3 | 83667 | 528 | 21.906 | 3819.4 |
477 | 2024-08-30 21:29:58 | mecca | 2 | 53800 | 28 | 7.576 | 7101.4 |
476 | 2024-08-30 21:26:36 | mecca | 1 | 28756 | 2 | 3.106 | 9258.2 |
475 | 2024-08-30 20:43:18 | mecca | 1 | 28756 | 2 | 2.000 | 14378.0 |
474 | 2024-08-30 20:08:21 | mecca | 1 | 28756 | 2 | 4.470 | 6433.1 |
473 | 2024-08-27 05:18:46 | mecca | 1 | 28756 | 2 | 3.576 | 8041.4 |
472 | 2024-08-19 20:10:19 | mecca | 3 | 83667 | 528 | 15.126 | 5531.3 |
471 | 2024-08-18 03:15:31 | mecca | 3 | 83667 | 528 | 30.610 | 2733.3 |
470 | 2024-08-17 07:19:10 | mecca | 3 | 83667 | 528 | 24.923 | 3357.0 |
469 | 2024-08-17 07:19:10 | mecca | 2 | 53800 | 28 | 14.376 | 3742.3 |
468 | 2024-08-17 07:18:34 | mecca | 1 | 28756 | 2 | 3.203 | 8977.8 |
467 | 2024-08-08 09:57:16 | mecca | 1 | 28756 | 2 | 1.983 | 14501.3 |
466 | 2024-08-07 21:34:15 | mecca | 1 | 28756 | 2 | 1.890 | 15214.8 |
465 | 2024-07-30 13:31:20 | mecca | 1 | 28756 | 2 | 1.953 | 14724.0 |
464 | 2024-07-30 13:29:40 | mecca | 3 | 83667 | 528 | 9.220 | 9074.5 |
463 | 2024-07-30 13:29:32 | mecca | 2 | 53800 | 28 | 8.030 | 6699.9 |
462 | 2024-07-30 13:14:49 | mecca | 3 | 83667 | 528 | 9.970 | 8391.9 |
461 | 2024-07-30 13:14:48 | mecca | 2 | 53800 | 28 | 8.860 | 6072.2 |
460 | 2024-07-30 12:53:07 | mecca | 1 | 28756 | 2 | 0.453 | 63479.0 |
459 | 2024-07-28 09:50:44 | mecca | 1 | 28756 | 2 | 2.280 | 12612.3 |
458 | 2024-07-28 03:56:40 | mecca | 1 | 28756 | 2 | 0.970 | 29645.4 |
457 | 2024-07-17 04:26:52 | mecca | 1 | 28756 | 2 | 1.940 | 14822.7 |