History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"adviser"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 523 | 2025-10-23 05:18:25 | adviser | 1 | 69583 | 7 | 5.703 | 12201.1 |
| 522 | 2025-10-21 01:07:05 | adviser | 1 | 69583 | 7 | 5.076 | 13708.2 |
| 521 | 2025-10-20 12:53:23 | adviser | 1 | 69583 | 7 | 1.106 | 62914.1 |
| 520 | 2025-10-07 07:44:53 | adviser | 1 | 69583 | 7 | 1.266 | 54962.9 |
| 519 | 2025-09-28 17:24:38 | adviser | 1 | 69583 | 7 | 1.110 | 62687.4 |
| 518 | 2025-09-27 15:44:56 | adviser | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 517 | 2025-09-27 06:06:07 | adviser | 1 | 69583 | 7 | 1.173 | 59320.5 |
| 516 | 2025-09-26 11:51:14 | adviser | 1 | 69583 | 7 | 1.216 | 57222.9 |
| 515 | 2025-09-26 11:50:16 | adviser | 1 | 69583 | 7 | 1.266 | 54962.9 |
| 514 | 2025-09-04 20:17:19 | adviser | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 513 | 2025-08-28 05:06:30 | adviser | 1 | 69583 | 7 | 1.233 | 56433.9 |
| 512 | 2025-08-27 11:04:05 | adviser | 1 | 69583 | 7 | 3.296 | 21111.3 |
| 511 | 2025-08-27 05:42:36 | adviser | 1 | 69583 | 7 | 1.296 | 53690.6 |
| 510 | 2025-08-26 23:47:00 | adviser | 1 | 69583 | 7 | 1.203 | 57841.2 |
| 509 | 2025-08-17 12:09:12 | adviser | 1 | 69583 | 7 | 2.936 | 23699.9 |
| 508 | 2025-08-02 04:42:26 | adviser | 1 | 69583 | 7 | 4.563 | 15249.4 |
| 507 | 2025-07-27 12:13:48 | adviser | 1 | 69583 | 7 | 2.483 | 28023.8 |
| 506 | 2025-07-17 15:39:19 | adviser | 1 | 69583 | 7 | 5.563 | 12508.2 |
| 505 | 2025-07-14 07:14:49 | adviser | 1 | 69583 | 7 | 5.703 | 12201.1 |
| 504 | 2025-07-07 03:32:23 | adviser | 1 | 69583 | 7 | 3.843 | 18106.4 |
| 503 | 2025-07-05 06:00:10 | adviser | 1 | 69583 | 7 | 5.686 | 12237.6 |
| 502 | 2025-06-26 01:49:48 | adviser | 3 | 134027 | 176 | 33.690 | 3978.2 |
| 501 | 2025-06-24 06:29:03 | adviser | 3 | 134027 | 176 | 40.613 | 3300.1 |
| 500 | 2025-06-23 19:41:01 | adviser | 1 | 69583 | 7 | 1.266 | 54962.9 |
| 499 | 2025-06-22 13:51:16 | adviser | 3 | 134027 | 176 | 31.626 | 4237.9 |
| 498 | 2025-06-15 23:29:39 | adviser | 3 | 134027 | 176 | 38.750 | 3458.8 |
| 497 | 2025-06-15 00:11:57 | adviser | 1 | 69583 | 7 | 3.330 | 20895.8 |
| 496 | 2025-06-14 06:19:42 | adviser | 1 | 69583 | 7 | 5.453 | 12760.5 |
| 495 | 2025-06-04 05:53:47 | adviser | 1 | 69583 | 7 | 2.983 | 23326.5 |
| 494 | 2025-05-31 02:35:50 | adviser | 1 | 69583 | 7 | 4.403 | 15803.5 |
| 493 | 2025-05-22 07:48:00 | adviser | 2 | 107671 | 16 | 19.686 | 5469.4 |
| 492 | 2025-05-20 11:14:47 | adviser | 1 | 69583 | 7 | 3.093 | 22496.9 |
| 491 | 2025-05-20 08:59:43 | adviser | 2 | 107671 | 16 | 8.453 | 12737.6 |
| 490 | 2025-05-15 00:12:31 | adviser | 1 | 69583 | 7 | 1.390 | 50059.7 |
| 489 | 2025-05-14 01:02:50 | adviser | 2 | 107671 | 16 | 10.406 | 10347.0 |
| 488 | 2025-05-13 11:33:52 | adviser | 1 | 69583 | 7 | 5.530 | 12582.8 |
| 487 | 2025-05-13 06:31:05 | adviser | 1 | 69583 | 7 | 5.766 | 12067.8 |
| 486 | 2025-05-13 05:11:08 | adviser | 2 | 107671 | 16 | 14.813 | 7268.7 |
| 485 | 2025-05-09 11:30:08 | adviser | 3 | 134027 | 176 | 6.670 | 20094.0 |
| 484 | 2025-05-04 05:41:35 | adviser | 1 | 69583 | 7 | 6.126 | 11358.6 |
| 483 | 2025-05-03 16:22:01 | adviser | 3 | 134027 | 176 | 6.546 | 20474.6 |
| 482 | 2025-04-25 13:46:44 | adviser | 3 | 134027 | 176 | 12.436 | 10777.3 |
| 481 | 2025-04-24 05:34:38 | adviser | 3 | 134027 | 176 | 34.206 | 3918.2 |
| 480 | 2025-04-23 21:00:02 | adviser | 3 | 134027 | 176 | 31.173 | 4299.5 |
| 479 | 2025-04-23 07:04:56 | adviser | 2 | 107671 | 16 | 16.110 | 6683.5 |
| 478 | 2025-04-22 16:53:08 | adviser | 3 | 134027 | 176 | 7.046 | 19021.7 |
| 477 | 2025-04-22 00:38:33 | adviser | 3 | 134027 | 176 | 6.156 | 21771.8 |
| 476 | 2025-04-20 15:02:27 | adviser | 3 | 134027 | 176 | 15.860 | 8450.6 |
| 475 | 2025-04-20 05:51:05 | adviser | 2 | 107671 | 16 | 13.860 | 7768.5 |
| 474 | 2025-04-19 10:30:06 | adviser | 1 | 69583 | 7 | 5.703 | 12201.1 |
| 473 | 2025-04-12 11:52:30 | adviser | 1 | 69583 | 7 | 6.280 | 11080.1 |
| 472 | 2025-03-29 03:36:32 | adviser | 1 | 69583 | 7 | 6.936 | 10032.2 |
| 471 | 2025-03-20 12:32:12 | adviser | 2 | 107671 | 16 | 14.156 | 7606.0 |
| 470 | 2025-03-19 13:06:51 | adviser | 1 | 69583 | 7 | 1.186 | 58670.3 |
| 469 | 2025-03-16 08:00:41 | adviser | 3 | 134027 | 176 | 36.393 | 3682.8 |
| 468 | 2025-03-16 05:52:26 | adviser | 3 | 134027 | 176 | 32.406 | 4135.9 |
| 467 | 2025-03-10 20:52:24 | adviser | 1 | 69583 | 7 | 5.873 | 11847.9 |
| 466 | 2025-03-05 18:02:37 | adviser | 1 | 69583 | 7 | 2.890 | 24077.2 |
| 465 | 2025-02-27 09:45:38 | adviser | 3 | 134027 | 176 | 11.373 | 11784.7 |
| 464 | 2025-02-27 08:53:33 | adviser | 2 | 107671 | 16 | 8.516 | 12643.4 |
| 463 | 2025-02-27 08:53:20 | adviser | 1 | 69583 | 7 | 6.656 | 10454.2 |
| 462 | 2025-02-27 06:12:36 | adviser | 3 | 134027 | 176 | 28.750 | 4661.8 |
| 461 | 2025-02-27 05:28:34 | adviser | 3 | 134027 | 176 | 32.566 | 4115.5 |
| 460 | 2025-02-26 07:09:44 | adviser | 3 | 134027 | 176 | 24.423 | 5487.7 |
| 459 | 2025-02-25 23:31:06 | adviser | 3 | 134027 | 176 | 27.940 | 4797.0 |
| 458 | 2025-02-25 15:48:34 | adviser | 3 | 134027 | 176 | 5.546 | 24166.4 |
| 457 | 2025-01-28 18:37:22 | adviser | 1 | 69583 | 7 | 6.890 | 10099.1 |
| 456 | 2025-01-25 15:46:55 | adviser | 1 | 69583 | 7 | 7.343 | 9476.1 |
| 455 | 2025-01-06 06:56:57 | adviser | 2 | 107671 | 16 | 13.503 | 7973.9 |
| 454 | 2025-01-05 22:40:35 | adviser | 3 | 134027 | 176 | 10.500 | 12764.5 |
| 453 | 2025-01-05 15:00:22 | adviser | 2 | 107671 | 16 | 3.203 | 33615.7 |
| 452 | 2025-01-04 18:46:08 | adviser | 3 | 134027 | 176 | 16.576 | 8085.6 |
| 451 | 2025-01-04 14:29:12 | adviser | 3 | 134027 | 176 | 24.456 | 5480.3 |
| 450 | 2025-01-04 14:29:10 | adviser | 2 | 107671 | 16 | 13.923 | 7733.3 |
| 449 | 2024-12-26 08:12:28 | adviser | 1 | 69583 | 7 | 6.170 | 11277.6 |
| 448 | 2024-12-22 02:32:14 | adviser | 1 | 69583 | 7 | 2.233 | 31161.2 |
| 447 | 2024-12-09 02:32:52 | adviser | 1 | 69583 | 7 | 3.546 | 19623.0 |
| 446 | 2024-12-04 14:54:11 | adviser | 3 | 134027 | 176 | 31.063 | 4314.7 |
| 445 | 2024-12-04 04:12:13 | adviser | 3 | 134027 | 176 | 48.236 | 2778.6 |
| 444 | 2024-12-02 15:13:56 | adviser | 3 | 134027 | 176 | 35.206 | 3806.9 |
| 443 | 2024-11-28 14:03:08 | adviser | 3 | 134027 | 176 | 17.093 | 7841.0 |
| 442 | 2024-11-19 13:25:13 | adviser | 1 | 69583 | 7 | 8.530 | 8157.4 |
| 441 | 2024-11-11 21:42:37 | adviser | 2 | 107671 | 16 | 16.516 | 6519.2 |
| 440 | 2024-11-11 03:56:33 | adviser | 2 | 107671 | 16 | 2.920 | 36873.6 |
| 439 | 2024-11-08 15:49:49 | adviser | 1 | 69583 | 7 | 7.453 | 9336.2 |
| 438 | 2024-10-31 16:25:38 | adviser | 3 | 134027 | 176 | 31.986 | 4190.2 |
| 437 | 2024-10-29 19:26:55 | adviser | 1 | 69583 | 7 | 5.720 | 12164.9 |
| 436 | 2024-10-26 18:56:05 | adviser | 1 | 69583 | 7 | 2.106 | 33040.4 |
| 435 | 2024-10-26 09:12:10 | adviser | 1 | 69583 | 7 | 5.216 | 13340.3 |
| 434 | 2024-10-21 09:41:16 | adviser | 2 | 107671 | 16 | 13.313 | 8087.7 |
| 433 | 2024-10-21 09:37:14 | adviser | 3 | 134027 | 176 | 26.326 | 5091.1 |
| 432 | 2024-10-20 19:44:02 | adviser | 3 | 134027 | 176 | 35.600 | 3764.8 |
| 431 | 2024-10-20 07:18:04 | adviser | 3 | 134027 | 176 | 48.550 | 2760.6 |
| 430 | 2024-10-20 07:18:04 | adviser | 2 | 107671 | 16 | 12.750 | 8444.8 |
| 429 | 2024-10-20 07:17:51 | adviser | 1 | 69583 | 7 | 5.546 | 12546.5 |
| 428 | 2024-09-20 03:04:53 | adviser | 1 | 69583 | 7 | 5.300 | 13128.9 |
| 427 | 2024-09-18 23:33:15 | adviser | 1 | 69583 | 7 | 4.783 | 14548.0 |
| 426 | 2024-09-18 23:22:56 | adviser | 1 | 69583 | 7 | 7.050 | 9869.9 |
| 425 | 2024-08-28 21:49:00 | adviser | 1 | 69583 | 7 | 1.110 | 62687.4 |
| 424 | 2024-08-16 07:11:51 | adviser | 1 | 69583 | 7 | 10.736 | 6481.3 |