History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crystal"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 553 | 2025-10-08 10:27:35 | crystal | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 552 | 2025-09-25 12:35:12 | crystal | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 551 | 2025-09-19 12:29:58 | crystal | 2 | 107671 | 11 | 3.373 | 31921.4 |
| 550 | 2025-09-18 12:49:52 | crystal | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 549 | 2025-09-01 14:53:15 | crystal | 2 | 107671 | 11 | 4.610 | 23356.0 |
| 548 | 2025-08-28 23:50:33 | crystal | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 547 | 2025-08-28 17:02:14 | crystal | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 546 | 2025-08-11 17:11:48 | crystal | 3 | 134027 | 107 | 17.643 | 7596.6 |
| 545 | 2025-08-01 06:55:58 | crystal | 1 | 69583 | 5 | 7.136 | 9751.0 |
| 544 | 2025-07-31 10:00:50 | crystal | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 543 | 2025-07-27 06:49:11 | crystal | 1 | 69583 | 5 | 2.876 | 24194.4 |
| 542 | 2025-07-26 00:20:07 | crystal | 3 | 134027 | 107 | 15.626 | 8577.2 |
| 541 | 2025-07-24 22:38:31 | crystal | 1 | 69583 | 5 | 5.640 | 12337.4 |
| 540 | 2025-07-22 21:08:42 | crystal | 1 | 69583 | 5 | 2.783 | 25002.9 |
| 539 | 2025-07-22 14:08:09 | crystal | 1 | 69583 | 5 | 3.220 | 21609.6 |
| 538 | 2025-07-21 21:55:10 | crystal | 3 | 134027 | 107 | 5.660 | 23679.7 |
| 537 | 2025-07-12 17:39:12 | crystal | 3 | 134027 | 107 | 10.720 | 12502.5 |
| 536 | 2025-07-12 15:31:11 | crystal | 3 | 134027 | 107 | 12.406 | 10803.4 |
| 535 | 2025-07-09 00:17:37 | crystal | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 534 | 2025-07-07 13:03:34 | crystal | 1 | 69583 | 5 | 5.966 | 11663.3 |
| 533 | 2025-06-27 04:58:16 | crystal | 1 | 69583 | 5 | 5.140 | 13537.5 |
| 532 | 2025-06-26 04:25:21 | crystal | 3 | 134027 | 107 | 18.156 | 7382.0 |
| 531 | 2025-06-25 21:56:17 | crystal | 2 | 107671 | 11 | 8.783 | 12259.0 |
| 530 | 2025-06-24 21:37:57 | crystal | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 529 | 2025-06-24 18:30:46 | crystal | 3 | 134027 | 107 | 9.266 | 14464.4 |
| 528 | 2025-06-24 06:45:30 | crystal | 1 | 69583 | 5 | 5.653 | 12309.0 |
| 527 | 2025-06-23 22:42:22 | crystal | 3 | 134027 | 107 | 34.220 | 3916.6 |
| 526 | 2025-06-22 10:25:51 | crystal | 2 | 107671 | 11 | 9.173 | 11737.8 |
| 525 | 2025-06-22 08:36:47 | crystal | 1 | 69583 | 5 | 4.123 | 16876.8 |
| 524 | 2025-06-22 00:12:12 | crystal | 3 | 134027 | 107 | 27.750 | 4829.8 |
| 523 | 2025-06-20 23:30:44 | crystal | 1 | 69583 | 5 | 4.766 | 14599.9 |
| 522 | 2025-06-18 04:10:55 | crystal | 1 | 69583 | 5 | 6.656 | 10454.2 |
| 521 | 2025-06-16 22:25:03 | crystal | 1 | 69583 | 5 | 6.250 | 11133.3 |
| 520 | 2025-05-22 19:59:07 | crystal | 3 | 134027 | 107 | 6.310 | 21240.4 |
| 519 | 2025-05-22 06:56:38 | crystal | 1 | 69583 | 5 | 5.750 | 12101.4 |
| 518 | 2025-05-21 22:07:28 | crystal | 2 | 107671 | 11 | 19.940 | 5399.7 |
| 517 | 2025-05-20 16:27:19 | crystal | 3 | 134027 | 107 | 46.406 | 2888.1 |
| 516 | 2025-05-20 07:47:47 | crystal | 2 | 107671 | 11 | 16.063 | 6703.0 |
| 515 | 2025-05-18 08:54:26 | crystal | 2 | 107671 | 11 | 11.376 | 9464.8 |
| 514 | 2025-05-18 01:42:56 | crystal | 3 | 134027 | 107 | 17.766 | 7544.0 |
| 513 | 2025-05-18 00:15:16 | crystal | 3 | 134027 | 107 | 30.516 | 4392.0 |
| 512 | 2025-05-17 23:11:10 | crystal | 1 | 69583 | 5 | 6.296 | 11051.9 |
| 511 | 2025-05-16 22:14:52 | crystal | 1 | 69583 | 5 | 2.186 | 31831.2 |
| 510 | 2025-05-16 13:47:16 | crystal | 2 | 107671 | 11 | 19.190 | 5610.8 |
| 509 | 2025-05-16 05:37:24 | crystal | 3 | 134027 | 107 | 35.473 | 3778.3 |
| 508 | 2025-05-15 04:32:37 | crystal | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 507 | 2025-05-12 06:31:58 | crystal | 1 | 69583 | 5 | 6.720 | 10354.6 |
| 506 | 2025-05-05 18:27:50 | crystal | 1 | 69583 | 5 | 2.530 | 27503.2 |
| 505 | 2025-04-26 05:26:46 | crystal | 1 | 69583 | 5 | 2.670 | 26061.0 |
| 504 | 2025-04-18 06:55:42 | crystal | 1 | 69583 | 5 | 3.110 | 22374.0 |
| 503 | 2025-04-16 04:14:30 | crystal | 1 | 69583 | 5 | 2.576 | 27012.0 |
| 502 | 2025-04-13 23:19:15 | crystal | 1 | 69583 | 5 | 4.623 | 15051.5 |
| 501 | 2025-04-03 21:57:32 | crystal | 1 | 69583 | 5 | 6.656 | 10454.2 |
| 500 | 2025-03-21 03:01:33 | crystal | 3 | 134027 | 107 | 30.003 | 4467.1 |
| 499 | 2025-03-19 21:24:41 | crystal | 2 | 107671 | 11 | 3.140 | 34290.1 |
| 498 | 2025-03-19 07:43:43 | crystal | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 497 | 2025-03-17 15:53:38 | crystal | 1 | 69583 | 5 | 2.126 | 32729.5 |
| 496 | 2025-03-12 22:55:50 | crystal | 1 | 69583 | 5 | 6.233 | 11163.6 |
| 495 | 2025-02-26 19:50:16 | crystal | 1 | 69583 | 5 | 8.860 | 7853.6 |
| 494 | 2025-02-25 21:19:53 | crystal | 1 | 69583 | 5 | 5.563 | 12508.2 |
| 493 | 2025-02-07 08:09:13 | crystal | 1 | 69583 | 5 | 8.440 | 8244.4 |
| 492 | 2025-01-25 14:11:40 | crystal | 1 | 69583 | 5 | 2.233 | 31161.2 |
| 491 | 2025-01-24 17:09:23 | crystal | 1 | 69583 | 5 | 5.313 | 13096.7 |
| 490 | 2025-01-19 03:24:38 | crystal | 1 | 69583 | 5 | 2.920 | 23829.8 |
| 489 | 2025-01-07 17:24:51 | crystal | 3 | 134027 | 107 | 34.300 | 3907.5 |
| 488 | 2025-01-07 17:24:48 | crystal | 2 | 107671 | 11 | 22.516 | 4782.0 |
| 487 | 2025-01-06 03:06:04 | crystal | 1 | 69583 | 5 | 5.986 | 11624.3 |
| 486 | 2024-12-26 21:34:48 | crystal | 1 | 69583 | 5 | 5.673 | 12265.6 |
| 485 | 2024-12-26 12:46:35 | crystal | 1 | 69583 | 5 | 5.423 | 12831.1 |
| 484 | 2024-12-24 00:28:14 | crystal | 3 | 134027 | 107 | 43.083 | 3110.9 |
| 483 | 2024-12-19 16:31:58 | crystal | 2 | 107671 | 11 | 3.016 | 35699.9 |
| 482 | 2024-12-19 10:44:32 | crystal | 3 | 134027 | 107 | 31.860 | 4206.7 |
| 481 | 2024-12-18 23:17:18 | crystal | 3 | 134027 | 107 | 48.583 | 2758.7 |
| 480 | 2024-12-18 23:17:26 | crystal | 2 | 107671 | 11 | 16.123 | 6678.1 |
| 479 | 2024-12-18 23:16:40 | crystal | 1 | 69583 | 5 | 5.830 | 11935.3 |
| 478 | 2024-11-25 09:43:33 | crystal | 1 | 69583 | 5 | 5.030 | 13833.6 |
| 477 | 2024-11-16 06:30:06 | crystal | 1 | 69583 | 5 | 2.986 | 23303.1 |
| 476 | 2024-11-07 06:57:50 | crystal | 1 | 69583 | 5 | 6.860 | 10143.3 |
| 475 | 2024-10-26 00:05:27 | crystal | 2 | 107671 | 11 | 16.953 | 6351.1 |
| 474 | 2024-10-25 15:43:51 | crystal | 1 | 69583 | 5 | 4.470 | 15566.7 |
| 473 | 2024-10-15 16:43:34 | crystal | 2 | 107671 | 11 | 16.266 | 6619.4 |
| 472 | 2024-10-15 16:43:07 | crystal | 1 | 69583 | 5 | 4.550 | 15293.0 |
| 471 | 2024-10-09 15:36:35 | crystal | 3 | 134027 | 107 | 28.296 | 4736.6 |
| 470 | 2024-10-08 06:31:57 | crystal | 3 | 134027 | 107 | 51.213 | 2617.1 |
| 469 | 2024-10-07 19:45:33 | crystal | 3 | 134027 | 107 | 6.453 | 20769.7 |
| 468 | 2024-10-07 19:45:31 | crystal | 2 | 107671 | 11 | 3.503 | 30736.8 |
| 467 | 2024-10-02 21:35:47 | crystal | 1 | 69583 | 5 | 5.123 | 13582.5 |
| 466 | 2024-09-29 13:22:14 | crystal | 1 | 69583 | 5 | 12.283 | 5665.0 |
| 465 | 2024-09-23 19:12:28 | crystal | 1 | 69583 | 5 | 9.436 | 7374.2 |
| 464 | 2024-09-23 13:28:57 | crystal | 1 | 69583 | 5 | 10.826 | 6427.4 |
| 463 | 2024-09-08 06:00:01 | crystal | 1 | 69583 | 5 | 6.656 | 10454.2 |
| 462 | 2024-08-23 17:36:34 | crystal | 1 | 69583 | 5 | 7.063 | 9851.8 |
| 461 | 2024-08-04 01:42:52 | crystal | 1 | 69583 | 5 | 4.593 | 15149.8 |
| 460 | 2024-07-26 08:26:24 | crystal | 1 | 69583 | 5 | 4.373 | 15912.0 |
| 459 | 2024-07-18 10:19:59 | crystal | 1 | 69583 | 5 | 4.326 | 16084.8 |
| 458 | 2024-07-16 10:52:21 | crystal | 1 | 69583 | 5 | 2.266 | 30707.4 |
| 457 | 2024-07-16 08:47:31 | crystal | 1 | 69583 | 5 | 3.266 | 21305.3 |
| 456 | 2024-07-09 22:30:39 | crystal | 1 | 69583 | 5 | 4.063 | 17126.0 |
| 455 | 2024-07-06 19:11:29 | crystal | 1 | 69583 | 5 | 3.123 | 22280.8 |
| 454 | 2024-07-02 19:54:41 | crystal | 1 | 69583 | 5 | 4.920 | 14142.9 |