History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiliating"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 489 | 2025-10-22 08:28:06 | affiliating | 1 | 49908 | 1 | 4.563 | 10937.5 |
| 488 | 2025-10-22 08:27:55 | affiliating | 1 | 49908 | 1 | 4.000 | 12477.0 |
| 487 | 2025-10-22 08:27:39 | affiliating | 1 | 49908 | 1 | 3.233 | 15437.1 |
| 486 | 2025-10-22 08:27:30 | affiliating | 1 | 49908 | 1 | 3.470 | 14382.7 |
| 485 | 2025-10-02 05:41:09 | affiliating | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 484 | 2025-08-19 08:22:43 | affiliating | 1 | 49908 | 1 | 4.733 | 10544.7 |
| 483 | 2025-08-19 03:27:01 | affiliating | 4 | 148819 | 112 | 21.736 | 6846.7 |
| 482 | 2025-08-18 20:33:19 | affiliating | 4 | 148819 | 112 | 34.923 | 4261.3 |
| 481 | 2025-08-17 05:35:18 | affiliating | 1 | 49908 | 1 | 1.766 | 28260.5 |
| 480 | 2025-08-16 15:51:46 | affiliating | 2 | 86808 | 6 | 2.390 | 36321.3 |
| 479 | 2025-08-16 11:33:19 | affiliating | 3 | 121633 | 16 | 6.813 | 17853.1 |
| 478 | 2025-08-16 01:31:04 | affiliating | 4 | 148819 | 112 | 9.296 | 16008.9 |
| 477 | 2025-08-14 22:16:29 | affiliating | 1 | 49908 | 1 | 1.766 | 28260.5 |
| 476 | 2025-08-14 18:01:52 | affiliating | 1 | 49908 | 1 | 1.986 | 25129.9 |
| 475 | 2025-08-09 19:40:25 | affiliating | 1 | 49908 | 1 | 4.780 | 10441.0 |
| 474 | 2025-08-06 14:19:51 | affiliating | 3 | 121633 | 16 | 11.796 | 10311.4 |
| 473 | 2025-07-25 22:08:52 | affiliating | 4 | 148819 | 112 | 11.156 | 13339.8 |
| 472 | 2025-07-24 19:07:27 | affiliating | 1 | 49908 | 1 | 4.813 | 10369.4 |
| 471 | 2025-07-17 20:38:08 | affiliating | 3 | 121633 | 16 | 13.393 | 9081.8 |
| 470 | 2025-07-17 02:54:18 | affiliating | 4 | 148819 | 112 | 33.426 | 4452.2 |
| 469 | 2025-07-16 22:24:32 | affiliating | 2 | 86808 | 6 | 5.390 | 16105.4 |
| 468 | 2025-07-16 05:45:14 | affiliating | 1 | 49908 | 1 | 0.856 | 58303.7 |
| 467 | 2025-07-14 15:10:45 | affiliating | 3 | 121633 | 16 | 21.903 | 5553.3 |
| 466 | 2025-07-14 03:07:40 | affiliating | 2 | 86808 | 6 | 14.190 | 6117.5 |
| 465 | 2025-07-13 08:03:35 | affiliating | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 464 | 2025-07-07 13:20:31 | affiliating | 1 | 49908 | 1 | 2.546 | 19602.5 |
| 463 | 2025-07-06 02:47:47 | affiliating | 1 | 49908 | 1 | 4.110 | 12143.1 |
| 462 | 2025-07-04 04:24:34 | affiliating | 1 | 49908 | 1 | 2.686 | 18580.8 |
| 461 | 2025-06-16 06:35:33 | affiliating | 1 | 49908 | 1 | 5.780 | 8634.6 |
| 460 | 2025-06-12 04:01:15 | affiliating | 1 | 49908 | 1 | 2.766 | 18043.4 |
| 459 | 2025-06-10 00:49:11 | affiliating | 1 | 49908 | 1 | 4.686 | 10650.4 |
| 458 | 2025-06-08 02:34:27 | affiliating | 3 | 121633 | 16 | 31.653 | 3842.7 |
| 457 | 2025-06-07 21:36:33 | affiliating | 4 | 148819 | 112 | 30.000 | 4960.6 |
| 456 | 2025-05-28 11:07:07 | affiliating | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 455 | 2025-05-28 05:33:30 | affiliating | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 454 | 2025-05-20 17:29:42 | affiliating | 3 | 121633 | 16 | 24.170 | 5032.4 |
| 453 | 2025-05-20 01:39:38 | affiliating | 4 | 148819 | 112 | 47.580 | 3127.8 |
| 452 | 2025-05-19 21:27:57 | affiliating | 2 | 86808 | 6 | 9.360 | 9274.4 |
| 451 | 2025-05-19 05:19:15 | affiliating | 1 | 49908 | 1 | 0.830 | 60130.1 |
| 450 | 2025-05-19 02:08:25 | affiliating | 4 | 148819 | 112 | 9.000 | 16535.4 |
| 449 | 2025-05-16 06:01:34 | affiliating | 1 | 49908 | 1 | 2.390 | 20882.0 |
| 448 | 2025-05-08 08:42:44 | affiliating | 1 | 49908 | 1 | 4.063 | 12283.5 |
| 447 | 2025-05-02 12:08:10 | affiliating | 1 | 49908 | 1 | 1.733 | 28798.6 |
| 446 | 2025-04-18 11:35:24 | affiliating | 1 | 49908 | 1 | 1.936 | 25778.9 |
| 445 | 2025-04-07 23:58:01 | affiliating | 1 | 49908 | 1 | 3.843 | 12986.7 |
| 444 | 2025-04-06 04:57:28 | affiliating | 1 | 49908 | 1 | 4.686 | 10650.4 |
| 443 | 2025-04-05 15:50:08 | affiliating | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 442 | 2025-04-03 13:48:55 | affiliating | 4 | 148819 | 112 | 25.283 | 5886.1 |
| 441 | 2025-04-02 11:34:28 | affiliating | 1 | 49908 | 1 | 3.593 | 13890.3 |
| 440 | 2025-03-24 23:15:51 | affiliating | 3 | 121633 | 16 | 13.133 | 9261.6 |
| 439 | 2025-03-21 08:39:51 | affiliating | 3 | 121633 | 16 | 18.393 | 6613.0 |
| 438 | 2025-03-18 18:49:32 | affiliating | 2 | 86808 | 6 | 2.000 | 43404.0 |
| 437 | 2025-03-18 11:24:51 | affiliating | 4 | 148819 | 112 | 48.783 | 3050.6 |
| 436 | 2025-03-17 11:51:16 | affiliating | 4 | 148819 | 112 | 51.346 | 2898.4 |
| 435 | 2025-03-17 11:49:37 | affiliating | 4 | 148819 | 112 | 55.786 | 2667.7 |
| 434 | 2025-03-16 18:12:12 | affiliating | 4 | 148819 | 112 | 44.520 | 3342.7 |
| 433 | 2025-03-16 10:15:37 | affiliating | 4 | 148819 | 112 | 30.030 | 4955.7 |
| 432 | 2025-03-13 23:30:36 | affiliating | 4 | 148819 | 112 | 50.986 | 2918.8 |
| 431 | 2025-03-13 23:30:35 | affiliating | 3 | 121633 | 16 | 26.500 | 4589.9 |
| 430 | 2025-03-13 23:30:26 | affiliating | 2 | 86808 | 6 | 6.063 | 14317.7 |
| 429 | 2025-03-13 23:29:15 | affiliating | 1 | 49908 | 1 | 3.580 | 13940.8 |
| 428 | 2025-03-05 10:56:09 | affiliating | 1 | 49908 | 1 | 2.466 | 20238.4 |
| 427 | 2025-02-23 16:21:42 | affiliating | 1 | 49908 | 1 | 2.483 | 20099.9 |
| 426 | 2025-02-22 05:31:02 | affiliating | 1 | 49908 | 1 | 6.220 | 8023.8 |
| 425 | 2025-02-08 07:21:24 | affiliating | 1 | 49908 | 1 | 4.110 | 12143.1 |
| 424 | 2025-01-30 13:41:27 | affiliating | 2 | 86808 | 6 | 13.783 | 6298.2 |
| 423 | 2025-01-23 06:48:10 | affiliating | 3 | 121633 | 16 | 25.656 | 4740.9 |
| 422 | 2025-01-22 22:04:59 | affiliating | 1 | 49908 | 1 | 3.720 | 13416.1 |
| 421 | 2025-01-22 14:51:47 | affiliating | 3 | 121633 | 16 | 28.346 | 4291.0 |
| 420 | 2025-01-22 14:51:49 | affiliating | 2 | 86808 | 6 | 14.110 | 6152.2 |
| 419 | 2025-01-22 14:51:36 | affiliating | 1 | 49908 | 1 | 1.673 | 29831.4 |
| 418 | 2025-01-16 15:00:05 | affiliating | 4 | 148819 | 112 | 43.986 | 3383.3 |
| 417 | 2025-01-16 05:13:21 | affiliating | 3 | 121633 | 16 | 27.846 | 4368.1 |
| 416 | 2025-01-16 00:23:54 | affiliating | 3 | 121633 | 16 | 29.636 | 4104.2 |
| 415 | 2025-01-16 00:23:52 | affiliating | 3 | 121633 | 16 | 20.266 | 6001.8 |
| 414 | 2025-01-16 00:23:52 | affiliating | 2 | 86808 | 6 | 11.360 | 7641.5 |
| 413 | 2025-01-15 19:02:15 | affiliating | 3 | 121633 | 16 | 29.410 | 4135.8 |
| 412 | 2025-01-15 19:02:06 | affiliating | 4 | 148819 | 112 | 29.596 | 5028.3 |
| 411 | 2025-01-15 19:02:16 | affiliating | 2 | 86808 | 6 | 11.423 | 7599.4 |
| 410 | 2025-01-15 18:57:55 | affiliating | 1 | 49908 | 1 | 4.360 | 11446.8 |
| 409 | 2025-01-06 09:47:08 | affiliating | 1 | 49908 | 1 | 3.690 | 13525.2 |
| 408 | 2024-12-14 05:20:21 | affiliating | 1 | 49908 | 1 | 5.733 | 8705.4 |
| 407 | 2024-12-14 03:52:24 | affiliating | 1 | 49908 | 1 | 2.610 | 19121.8 |
| 406 | 2024-12-05 00:33:22 | affiliating | 1 | 49908 | 1 | 5.673 | 8797.5 |
| 405 | 2024-11-30 23:27:01 | affiliating | 1 | 49908 | 1 | 1.843 | 27079.8 |
| 404 | 2024-11-12 09:25:11 | affiliating | 1 | 49908 | 1 | 6.000 | 8318.0 |
| 403 | 2024-11-12 03:12:46 | affiliating | 3 | 121633 | 16 | 4.190 | 29029.4 |
| 402 | 2024-11-11 23:25:23 | affiliating | 3 | 121633 | 16 | 23.016 | 5284.7 |
| 401 | 2024-11-04 05:00:25 | affiliating | 2 | 86808 | 6 | 17.016 | 5101.6 |
| 400 | 2024-11-04 05:00:13 | affiliating | 3 | 121633 | 16 | 23.813 | 5107.8 |
| 399 | 2024-11-04 04:54:33 | affiliating | 1 | 49908 | 1 | 0.720 | 69316.7 |
| 398 | 2024-10-28 00:09:06 | affiliating | 1 | 49908 | 1 | 2.436 | 20487.7 |
| 397 | 2024-10-25 06:11:08 | affiliating | 1 | 49908 | 1 | 3.640 | 13711.0 |
| 396 | 2024-10-07 00:55:22 | affiliating | 4 | 148819 | 112 | 89.100 | 1670.2 |
| 395 | 2024-10-06 05:52:32 | affiliating | 4 | 148819 | 112 | 54.176 | 2747.0 |
| 394 | 2024-10-01 19:35:49 | affiliating | 4 | 148819 | 112 | 111.823 | 1330.8 |
| 393 | 2024-09-10 12:24:21 | affiliating | 4 | 148819 | 112 | 76.753 | 1938.9 |
| 392 | 2024-09-10 11:31:43 | affiliating | 1 | 49908 | 1 | 7.390 | 6753.5 |
| 391 | 2024-09-05 15:02:50 | affiliating | 4 | 148819 | 112 | 107.280 | 1387.2 |
| 390 | 2024-09-03 05:21:06 | affiliating | 4 | 148819 | 112 | 65.956 | 2256.3 |