History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiliate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 506 | 2025-12-29 18:45:33 | affiliate | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 505 | 2025-12-19 14:23:10 | affiliate | 3 | 148641 | 30 | 7.016 | 21186.0 |
| 504 | 2025-12-15 14:27:57 | affiliate | 4 | 165329 | 205 | 12.626 | 13094.3 |
| 503 | 2025-12-14 08:01:22 | affiliate | 2 | 121436 | 5 | 3.640 | 33361.5 |
| 502 | 2025-12-14 07:51:08 | affiliate | 3 | 148641 | 30 | 6.766 | 21968.8 |
| 501 | 2025-12-14 07:50:53 | affiliate | 4 | 165329 | 205 | 13.966 | 11838.0 |
| 500 | 2025-12-14 05:31:24 | affiliate | 1 | 81242 | 3 | 1.346 | 60358.1 |
| 499 | 2025-12-13 17:25:18 | affiliate | 4 | 165329 | 205 | 20.186 | 8190.3 |
| 498 | 2025-12-13 01:25:56 | affiliate | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 497 | 2025-12-12 22:27:28 | affiliate | 3 | 148641 | 30 | 6.373 | 23323.6 |
| 496 | 2025-12-12 08:27:00 | affiliate | 4 | 165329 | 205 | 55.290 | 2990.2 |
| 495 | 2025-12-12 07:56:04 | affiliate | 4 | 165329 | 205 | 49.843 | 3317.0 |
| 494 | 2025-12-12 07:48:45 | affiliate | 3 | 148641 | 30 | 24.593 | 6044.0 |
| 493 | 2025-12-12 04:37:07 | affiliate | 4 | 165329 | 205 | 13.470 | 12273.9 |
| 492 | 2025-12-11 23:36:43 | affiliate | 4 | 165329 | 205 | 39.593 | 4175.7 |
| 491 | 2025-12-11 20:08:00 | affiliate | 4 | 165329 | 205 | 37.970 | 4354.2 |
| 490 | 2025-12-10 16:19:50 | affiliate | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 489 | 2025-12-05 17:40:52 | affiliate | 3 | 148641 | 30 | 7.376 | 20152.0 |
| 488 | 2025-12-05 17:40:48 | affiliate | 2 | 121436 | 5 | 3.533 | 34371.9 |
| 487 | 2025-12-05 17:40:35 | affiliate | 4 | 165329 | 205 | 11.626 | 14220.6 |
| 486 | 2025-12-05 16:47:27 | affiliate | 2 | 121436 | 5 | 2.970 | 40887.5 |
| 485 | 2025-12-05 16:47:20 | affiliate | 3 | 148641 | 30 | 6.343 | 23433.9 |
| 484 | 2025-12-05 16:10:12 | affiliate | 4 | 165329 | 205 | 11.603 | 14248.8 |
| 483 | 2025-12-02 06:06:05 | affiliate | 4 | 165329 | 205 | 17.110 | 9662.7 |
| 482 | 2025-12-02 00:34:23 | affiliate | 4 | 165329 | 205 | 11.546 | 14319.2 |
| 481 | 2025-11-23 20:14:01 | affiliate | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 480 | 2025-10-28 15:52:52 | affiliate | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 479 | 2025-10-25 16:59:59 | affiliate | 1 | 81242 | 3 | 2.373 | 34236.0 |
| 478 | 2025-10-24 10:13:51 | affiliate | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 477 | 2025-10-23 00:01:44 | affiliate | 1 | 81242 | 3 | 6.686 | 12151.1 |
| 476 | 2025-10-22 01:33:00 | affiliate | 1 | 81242 | 3 | 6.063 | 13399.6 |
| 475 | 2025-10-15 04:48:00 | affiliate | 2 | 121436 | 5 | 3.300 | 36798.8 |
| 474 | 2025-10-11 07:52:12 | affiliate | 3 | 148641 | 30 | 5.956 | 24956.5 |
| 473 | 2025-10-07 13:04:48 | affiliate | 4 | 165329 | 205 | 12.783 | 12933.5 |
| 472 | 2025-10-03 07:33:31 | affiliate | 4 | 165329 | 205 | 10.140 | 16304.6 |
| 471 | 2025-10-03 07:24:36 | affiliate | 3 | 148641 | 30 | 7.080 | 20994.5 |
| 470 | 2025-09-28 23:12:14 | affiliate | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 469 | 2025-09-20 23:24:04 | affiliate | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 468 | 2025-08-17 06:46:19 | affiliate | 1 | 81242 | 3 | 3.016 | 26937.0 |
| 467 | 2025-08-10 17:07:44 | affiliate | 1 | 81242 | 3 | 3.500 | 23212.0 |
| 466 | 2025-08-05 19:30:55 | affiliate | 1 | 81242 | 3 | 4.033 | 20144.3 |
| 465 | 2025-07-25 05:10:25 | affiliate | 1 | 81242 | 3 | 8.800 | 9232.0 |
| 464 | 2025-07-25 03:14:30 | affiliate | 1 | 81242 | 3 | 3.530 | 23014.7 |
| 463 | 2025-07-15 17:50:34 | affiliate | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 462 | 2025-07-14 11:17:40 | affiliate | 2 | 121436 | 5 | 12.703 | 9559.6 |
| 461 | 2025-07-13 07:45:50 | affiliate | 1 | 81242 | 3 | 3.296 | 24648.7 |
| 460 | 2025-07-02 14:44:44 | affiliate | 1 | 81242 | 3 | 7.236 | 11227.5 |
| 459 | 2025-06-25 22:41:38 | affiliate | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 458 | 2025-06-22 04:54:36 | affiliate | 1 | 81242 | 3 | 2.906 | 27956.6 |
| 457 | 2025-06-22 04:38:01 | affiliate | 1 | 81242 | 3 | 4.956 | 16392.7 |
| 456 | 2025-06-15 21:38:37 | affiliate | 1 | 81242 | 3 | 6.750 | 12035.9 |
| 455 | 2025-06-01 20:52:07 | affiliate | 2 | 121436 | 5 | 12.063 | 10066.8 |
| 454 | 2025-05-31 22:58:08 | affiliate | 1 | 81242 | 3 | 6.920 | 11740.2 |
| 453 | 2025-05-30 09:10:35 | affiliate | 1 | 81242 | 3 | 4.783 | 16985.6 |
| 452 | 2025-05-29 07:21:55 | affiliate | 1 | 81242 | 3 | 7.063 | 11502.5 |
| 451 | 2025-05-09 07:56:22 | affiliate | 1 | 81242 | 3 | 2.593 | 31331.3 |
| 450 | 2025-05-01 22:08:01 | affiliate | 1 | 81242 | 3 | 6.530 | 12441.3 |
| 449 | 2025-04-29 05:52:11 | affiliate | 4 | 165329 | 205 | 63.080 | 2620.9 |
| 448 | 2025-04-28 08:06:15 | affiliate | 4 | 165329 | 205 | 47.786 | 3459.8 |
| 447 | 2025-04-27 21:14:03 | affiliate | 4 | 165329 | 205 | 51.673 | 3199.5 |
| 446 | 2025-04-25 10:32:43 | affiliate | 4 | 165329 | 205 | 31.346 | 5274.3 |
| 445 | 2025-04-16 02:14:10 | affiliate | 2 | 121436 | 5 | 15.393 | 7889.0 |
| 444 | 2025-04-14 06:03:39 | affiliate | 1 | 81242 | 3 | 6.126 | 13261.8 |
| 443 | 2025-04-11 12:13:35 | affiliate | 4 | 165329 | 205 | 55.706 | 2967.9 |
| 442 | 2025-03-28 23:06:40 | affiliate | 1 | 81242 | 3 | 6.406 | 12682.2 |
| 441 | 2025-03-27 07:42:12 | affiliate | 4 | 165329 | 205 | 49.656 | 3329.5 |
| 440 | 2025-03-26 09:08:18 | affiliate | 1 | 81242 | 3 | 5.280 | 15386.7 |
| 439 | 2025-03-25 02:02:23 | affiliate | 4 | 165329 | 205 | 50.973 | 3243.5 |
| 438 | 2025-03-24 22:07:10 | affiliate | 4 | 165329 | 205 | 55.736 | 2966.3 |
| 437 | 2025-03-23 19:37:39 | affiliate | 4 | 165329 | 205 | 58.783 | 2812.5 |
| 436 | 2025-03-23 15:39:39 | affiliate | 3 | 148641 | 30 | 28.486 | 5218.0 |
| 435 | 2025-03-23 00:58:43 | affiliate | 3 | 148641 | 30 | 30.720 | 4838.6 |
| 434 | 2025-03-22 04:55:16 | affiliate | 1 | 81242 | 3 | 9.736 | 8344.5 |
| 433 | 2025-03-20 08:08:42 | affiliate | 1 | 81242 | 3 | 3.090 | 26291.9 |
| 432 | 2025-03-19 11:21:39 | affiliate | 3 | 148641 | 30 | 6.766 | 21968.8 |
| 431 | 2025-03-18 09:29:33 | affiliate | 1 | 81242 | 3 | 8.780 | 9253.1 |
| 430 | 2025-03-12 11:03:35 | affiliate | 3 | 148641 | 30 | 41.033 | 3622.5 |
| 429 | 2025-02-27 09:29:25 | affiliate | 3 | 148641 | 30 | 40.270 | 3691.1 |
| 428 | 2025-02-25 01:39:09 | affiliate | 3 | 148641 | 30 | 36.283 | 4096.7 |
| 427 | 2025-02-24 17:35:50 | affiliate | 3 | 148641 | 30 | 6.750 | 22020.9 |
| 426 | 2025-02-23 10:32:10 | affiliate | 4 | 165329 | 205 | 14.860 | 11125.8 |
| 425 | 2025-02-22 14:21:52 | affiliate | 4 | 165329 | 205 | 75.803 | 2181.0 |
| 424 | 2025-02-22 05:29:55 | affiliate | 4 | 165329 | 205 | 80.066 | 2064.9 |
| 423 | 2025-02-13 10:11:14 | affiliate | 1 | 81242 | 3 | 8.843 | 9187.2 |
| 422 | 2025-02-11 00:39:07 | affiliate | 4 | 165329 | 205 | 70.083 | 2359.0 |
| 421 | 2025-02-08 07:07:15 | affiliate | 1 | 81242 | 3 | 5.080 | 15992.5 |
| 420 | 2025-02-08 00:02:46 | affiliate | 4 | 165329 | 205 | 57.533 | 2873.6 |
| 419 | 2025-02-05 11:05:23 | affiliate | 1 | 81242 | 3 | 4.970 | 16346.5 |
| 418 | 2025-01-21 11:20:34 | affiliate | 4 | 165329 | 205 | 61.393 | 2693.0 |
| 417 | 2025-01-21 02:43:58 | affiliate | 4 | 165329 | 205 | 60.693 | 2724.0 |
| 416 | 2025-01-21 02:44:04 | affiliate | 2 | 121436 | 5 | 8.690 | 13974.2 |
| 415 | 2025-01-17 16:20:51 | affiliate | 3 | 148641 | 30 | 23.860 | 6229.7 |
| 414 | 2025-01-13 14:58:08 | affiliate | 3 | 148641 | 30 | 30.233 | 4916.5 |
| 413 | 2025-01-11 09:14:14 | affiliate | 3 | 148641 | 30 | 38.186 | 3892.6 |
| 412 | 2025-01-11 09:14:00 | affiliate | 3 | 148641 | 30 | 38.720 | 3838.9 |
| 411 | 2025-01-11 09:14:11 | affiliate | 2 | 121436 | 5 | 16.720 | 7262.9 |
| 410 | 2025-01-11 09:12:41 | affiliate | 1 | 81242 | 3 | 5.610 | 14481.6 |
| 409 | 2025-01-08 10:26:11 | affiliate | 3 | 148641 | 30 | 40.643 | 3657.2 |
| 408 | 2025-01-06 16:29:42 | affiliate | 3 | 148641 | 30 | 26.830 | 5540.1 |
| 407 | 2025-01-06 16:29:15 | affiliate | 3 | 148641 | 30 | 40.986 | 3626.6 |