History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yellows"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 513 | 2025-11-23 00:17:15 | yellows | 3 | 134027 | 224 | 10.046 | 13341.3 |
| 512 | 2025-11-22 18:43:25 | yellows | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 511 | 2025-11-13 10:55:26 | yellows | 3 | 134027 | 224 | 13.096 | 10234.2 |
| 510 | 2025-11-10 08:49:19 | yellows | 3 | 134027 | 224 | 5.813 | 23056.4 |
| 509 | 2025-10-17 21:33:15 | yellows | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 508 | 2025-09-19 04:19:22 | yellows | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 507 | 2025-08-27 13:35:31 | yellows | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 506 | 2025-08-25 03:06:38 | yellows | 1 | 69583 | 6 | 2.660 | 26159.0 |
| 505 | 2025-08-13 16:20:38 | yellows | 1 | 69583 | 6 | 2.000 | 34791.5 |
| 504 | 2025-08-05 12:40:56 | yellows | 1 | 69583 | 6 | 2.340 | 29736.3 |
| 503 | 2025-08-01 16:18:14 | yellows | 1 | 69583 | 6 | 5.296 | 13138.8 |
| 502 | 2025-07-31 03:26:16 | yellows | 1 | 69583 | 6 | 1.280 | 54361.7 |
| 501 | 2025-07-27 18:19:35 | yellows | 1 | 69583 | 6 | 5.703 | 12201.1 |
| 500 | 2025-07-27 14:32:37 | yellows | 1 | 69583 | 6 | 2.623 | 26528.0 |
| 499 | 2025-07-27 07:31:13 | yellows | 1 | 69583 | 6 | 2.923 | 23805.3 |
| 498 | 2025-07-27 02:49:43 | yellows | 1 | 69583 | 6 | 5.143 | 13529.7 |
| 497 | 2025-07-26 06:05:11 | yellows | 1 | 69583 | 6 | 5.440 | 12791.0 |
| 496 | 2025-07-25 12:38:02 | yellows | 1 | 69583 | 6 | 3.593 | 19366.3 |
| 495 | 2025-07-25 03:58:58 | yellows | 1 | 69583 | 6 | 3.216 | 21636.5 |
| 494 | 2025-07-23 02:25:19 | yellows | 1 | 69583 | 6 | 4.110 | 16930.2 |
| 493 | 2025-07-22 21:10:37 | yellows | 1 | 69583 | 6 | 2.826 | 24622.4 |
| 492 | 2025-07-19 04:42:02 | yellows | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 491 | 2025-07-15 03:10:17 | yellows | 3 | 134027 | 224 | 34.596 | 3874.1 |
| 490 | 2025-07-01 17:20:44 | yellows | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 489 | 2025-07-01 00:23:35 | yellows | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 488 | 2025-06-29 15:36:23 | yellows | 3 | 134027 | 224 | 35.236 | 3803.7 |
| 487 | 2025-06-27 22:57:35 | yellows | 3 | 134027 | 224 | 45.330 | 2956.7 |
| 486 | 2025-06-27 01:16:27 | yellows | 2 | 107671 | 39 | 8.920 | 12070.7 |
| 485 | 2025-06-27 00:52:59 | yellows | 3 | 134027 | 224 | 30.000 | 4467.6 |
| 484 | 2025-06-24 03:42:13 | yellows | 1 | 69583 | 6 | 4.873 | 14279.3 |
| 483 | 2025-06-18 11:15:17 | yellows | 1 | 69583 | 6 | 6.390 | 10889.4 |
| 482 | 2025-06-14 13:55:15 | yellows | 1 | 69583 | 6 | 9.360 | 7434.1 |
| 481 | 2025-06-11 06:50:31 | yellows | 1 | 69583 | 6 | 5.623 | 12374.7 |
| 480 | 2025-06-08 05:27:11 | yellows | 3 | 134027 | 224 | 24.126 | 5555.3 |
| 479 | 2025-06-07 01:45:40 | yellows | 3 | 134027 | 224 | 6.766 | 19808.9 |
| 478 | 2025-06-06 05:32:07 | yellows | 1 | 69583 | 6 | 2.766 | 25156.5 |
| 477 | 2025-06-01 03:41:18 | yellows | 3 | 134027 | 224 | 26.736 | 5013.0 |
| 476 | 2025-06-01 02:02:13 | yellows | 3 | 134027 | 224 | 35.130 | 3815.2 |
| 475 | 2025-05-30 04:45:40 | yellows | 3 | 134027 | 224 | 6.076 | 22058.4 |
| 474 | 2025-05-28 18:36:37 | yellows | 2 | 107671 | 39 | 3.393 | 31733.3 |
| 473 | 2025-05-26 15:19:47 | yellows | 1 | 69583 | 6 | 4.750 | 14649.1 |
| 472 | 2025-05-26 15:16:50 | yellows | 3 | 134027 | 224 | 39.593 | 3385.1 |
| 471 | 2025-05-25 22:55:49 | yellows | 3 | 134027 | 224 | 43.563 | 3076.6 |
| 470 | 2025-05-24 21:40:24 | yellows | 2 | 107671 | 39 | 3.453 | 31181.9 |
| 469 | 2025-05-24 21:16:27 | yellows | 3 | 134027 | 224 | 9.160 | 14631.8 |
| 468 | 2025-05-22 15:32:19 | yellows | 1 | 69583 | 6 | 5.986 | 11624.3 |
| 467 | 2025-05-22 03:42:58 | yellows | 1 | 69583 | 6 | 5.573 | 12485.7 |
| 466 | 2025-05-21 09:04:17 | yellows | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 465 | 2025-05-19 09:26:34 | yellows | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 464 | 2025-05-13 18:26:18 | yellows | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 463 | 2025-05-12 14:10:48 | yellows | 1 | 69583 | 6 | 6.000 | 11597.2 |
| 462 | 2025-05-09 10:46:49 | yellows | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 461 | 2025-05-08 06:32:04 | yellows | 1 | 69583 | 6 | 6.516 | 10678.8 |
| 460 | 2025-04-27 15:40:11 | yellows | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 459 | 2025-04-26 14:26:04 | yellows | 1 | 69583 | 6 | 6.110 | 11388.4 |
| 458 | 2025-04-22 22:20:21 | yellows | 1 | 69583 | 6 | 6.140 | 11332.7 |
| 457 | 2025-04-22 02:09:03 | yellows | 1 | 69583 | 6 | 2.250 | 30925.8 |
| 456 | 2025-04-06 06:25:54 | yellows | 1 | 69583 | 6 | 3.516 | 19790.4 |
| 455 | 2025-03-28 05:55:36 | yellows | 2 | 107671 | 39 | 21.893 | 4918.1 |
| 454 | 2025-03-26 15:58:42 | yellows | 1 | 69583 | 6 | 3.283 | 21194.9 |
| 453 | 2025-03-23 10:28:18 | yellows | 1 | 69583 | 6 | 8.560 | 8128.9 |
| 452 | 2025-03-20 05:10:31 | yellows | 1 | 69583 | 6 | 5.186 | 13417.5 |
| 451 | 2025-03-19 08:52:05 | yellows | 1 | 69583 | 6 | 5.453 | 12760.5 |
| 450 | 2025-03-17 03:45:44 | yellows | 3 | 134027 | 224 | 32.220 | 4159.7 |
| 449 | 2025-03-16 20:39:51 | yellows | 3 | 134027 | 224 | 35.096 | 3818.9 |
| 448 | 2025-03-12 19:08:02 | yellows | 2 | 107671 | 39 | 8.373 | 12859.3 |
| 447 | 2025-03-12 17:38:46 | yellows | 2 | 107671 | 39 | 10.470 | 10283.8 |
| 446 | 2025-03-12 05:15:29 | yellows | 2 | 107671 | 39 | 14.576 | 7386.9 |
| 445 | 2025-03-05 20:38:28 | yellows | 1 | 69583 | 6 | 6.860 | 10143.3 |
| 444 | 2025-03-03 02:43:49 | yellows | 2 | 107671 | 39 | 31.096 | 3462.5 |
| 443 | 2025-02-28 03:50:50 | yellows | 3 | 134027 | 224 | 36.190 | 3703.4 |
| 442 | 2025-02-27 19:09:46 | yellows | 3 | 134027 | 224 | 42.110 | 3182.8 |
| 441 | 2025-02-27 08:59:08 | yellows | 3 | 134027 | 224 | 29.703 | 4512.2 |
| 440 | 2025-02-25 21:03:08 | yellows | 3 | 134027 | 224 | 32.563 | 4115.9 |
| 439 | 2025-02-23 21:53:51 | yellows | 3 | 134027 | 224 | 41.580 | 3223.4 |
| 438 | 2025-02-23 21:53:49 | yellows | 2 | 107671 | 39 | 19.716 | 5461.1 |
| 437 | 2025-02-23 21:46:42 | yellows | 1 | 69583 | 6 | 8.516 | 8170.9 |
| 436 | 2025-02-13 20:23:34 | yellows | 1 | 69583 | 6 | 7.046 | 9875.5 |
| 435 | 2025-02-10 16:38:50 | yellows | 2 | 107671 | 39 | 21.033 | 5119.1 |
| 434 | 2025-02-10 06:51:02 | yellows | 1 | 69583 | 6 | 3.220 | 21609.6 |
| 433 | 2025-02-10 06:45:22 | yellows | 2 | 107671 | 39 | 9.190 | 11716.1 |
| 432 | 2025-02-09 05:45:59 | yellows | 2 | 107671 | 39 | 18.190 | 5919.2 |
| 431 | 2025-02-09 05:33:42 | yellows | 1 | 69583 | 6 | 6.250 | 11133.3 |
| 430 | 2025-02-01 13:37:49 | yellows | 1 | 69583 | 6 | 8.406 | 8277.8 |
| 429 | 2025-01-26 16:48:34 | yellows | 1 | 69583 | 6 | 4.296 | 16197.2 |
| 428 | 2025-01-18 07:34:19 | yellows | 3 | 134027 | 224 | 25.770 | 5200.9 |
| 427 | 2025-01-18 07:30:59 | yellows | 3 | 134027 | 224 | 35.936 | 3729.6 |
| 426 | 2025-01-17 03:00:13 | yellows | 3 | 134027 | 224 | 25.530 | 5249.8 |
| 425 | 2025-01-15 05:07:14 | yellows | 3 | 134027 | 224 | 9.280 | 14442.6 |
| 424 | 2025-01-14 00:49:07 | yellows | 1 | 69583 | 6 | 2.810 | 24762.6 |
| 423 | 2025-01-10 05:36:06 | yellows | 1 | 69583 | 6 | 4.610 | 15093.9 |
| 422 | 2025-01-08 08:37:17 | yellows | 2 | 107671 | 39 | 14.376 | 7489.6 |
| 421 | 2024-12-24 22:25:00 | yellows | 2 | 107671 | 39 | 20.986 | 5130.6 |
| 420 | 2024-12-24 22:24:49 | yellows | 1 | 69583 | 6 | 3.580 | 19436.6 |
| 419 | 2024-12-11 14:28:07 | yellows | 3 | 134027 | 224 | 7.140 | 18771.3 |
| 418 | 2024-12-11 14:28:08 | yellows | 2 | 107671 | 39 | 3.763 | 28613.1 |
| 417 | 2024-12-11 14:27:57 | yellows | 1 | 69583 | 6 | 2.483 | 28023.8 |
| 416 | 2024-12-11 03:36:13 | yellows | 3 | 134027 | 224 | 22.250 | 6023.7 |
| 415 | 2024-12-11 01:33:04 | yellows | 1 | 69583 | 6 | 6.813 | 10213.3 |
| 414 | 2024-12-01 23:37:09 | yellows | 3 | 134027 | 224 | 35.140 | 3814.1 |