History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opticist"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 519 | 2025-12-27 09:33:22 | opticist | 1 | 82945 | 3 | 2.533 | 32745.8 |
| 518 | 2025-12-25 07:45:57 | opticist | 1 | 82945 | 3 | 2.483 | 33405.2 |
| 517 | 2025-12-24 05:50:27 | opticist | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 516 | 2025-12-23 21:32:21 | opticist | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 515 | 2025-12-23 19:01:45 | opticist | 4 | 161609 | 468 | 13.233 | 12212.6 |
| 514 | 2025-12-23 12:28:21 | opticist | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 513 | 2025-12-20 08:37:04 | opticist | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 512 | 2025-12-20 08:36:19 | opticist | 1 | 82945 | 3 | 3.296 | 25165.4 |
| 511 | 2025-12-20 08:36:03 | opticist | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 510 | 2025-12-17 14:14:15 | opticist | 4 | 161609 | 468 | 42.940 | 3763.6 |
| 509 | 2025-12-16 20:07:33 | opticist | 4 | 161609 | 468 | 62.070 | 2603.7 |
| 508 | 2025-12-14 06:07:44 | opticist | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 507 | 2025-12-13 05:02:32 | opticist | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 506 | 2025-12-12 15:52:31 | opticist | 4 | 161609 | 468 | 61.350 | 2634.2 |
| 505 | 2025-12-11 19:39:13 | opticist | 4 | 161609 | 468 | 59.646 | 2709.5 |
| 504 | 2025-12-11 17:59:38 | opticist | 4 | 161609 | 468 | 60.160 | 2686.3 |
| 503 | 2025-12-08 03:13:46 | opticist | 4 | 161609 | 468 | 10.890 | 14840.1 |
| 502 | 2025-11-27 02:43:35 | opticist | 4 | 161609 | 468 | 28.563 | 5658.0 |
| 501 | 2025-11-22 18:16:38 | opticist | 1 | 82945 | 3 | 1.940 | 42755.2 |
| 500 | 2025-11-22 11:34:21 | opticist | 3 | 146162 | 43 | 20.013 | 7303.4 |
| 499 | 2025-11-20 19:38:09 | opticist | 4 | 161609 | 468 | 26.453 | 6109.3 |
| 498 | 2025-11-20 07:38:04 | opticist | 1 | 82945 | 3 | 2.420 | 34274.8 |
| 497 | 2025-11-19 20:56:01 | opticist | 4 | 161609 | 468 | 27.780 | 5817.5 |
| 496 | 2025-11-15 15:46:57 | opticist | 4 | 161609 | 468 | 12.016 | 13449.5 |
| 495 | 2025-11-06 02:16:30 | opticist | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 494 | 2025-11-03 21:37:16 | opticist | 4 | 161609 | 468 | 11.360 | 14226.1 |
| 493 | 2025-10-29 11:17:36 | opticist | 4 | 161609 | 468 | 13.376 | 12082.0 |
| 492 | 2025-10-25 09:08:58 | opticist | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 491 | 2025-10-13 06:56:35 | opticist | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 490 | 2025-10-06 19:10:44 | opticist | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 489 | 2025-09-13 22:46:25 | opticist | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 488 | 2025-09-10 18:55:35 | opticist | 2 | 121059 | 10 | 3.610 | 33534.3 |
| 487 | 2025-09-08 00:47:35 | opticist | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 486 | 2025-09-01 16:01:00 | opticist | 2 | 121059 | 10 | 3.483 | 34757.1 |
| 485 | 2025-08-27 20:29:24 | opticist | 3 | 146162 | 43 | 7.343 | 19904.9 |
| 484 | 2025-08-27 05:59:01 | opticist | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 483 | 2025-08-21 10:27:17 | opticist | 3 | 146162 | 43 | 18.453 | 7920.8 |
| 482 | 2025-08-17 04:11:41 | opticist | 3 | 146162 | 43 | 19.846 | 7364.8 |
| 481 | 2025-08-16 07:19:27 | opticist | 1 | 82945 | 3 | 6.530 | 12702.1 |
| 480 | 2025-08-10 15:26:59 | opticist | 1 | 82945 | 3 | 3.656 | 22687.4 |
| 479 | 2025-07-27 09:19:59 | opticist | 1 | 82945 | 3 | 3.110 | 26670.4 |
| 478 | 2025-07-25 08:38:26 | opticist | 1 | 82945 | 3 | 2.700 | 30720.4 |
| 477 | 2025-07-10 14:48:20 | opticist | 1 | 82945 | 3 | 6.406 | 12948.0 |
| 476 | 2025-07-07 09:09:45 | opticist | 3 | 146162 | 43 | 34.330 | 4257.6 |
| 475 | 2025-07-03 13:17:13 | opticist | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 474 | 2025-06-25 07:00:43 | opticist | 1 | 82945 | 3 | 6.876 | 12063.0 |
| 473 | 2025-06-16 01:52:55 | opticist | 3 | 146162 | 43 | 42.160 | 3466.8 |
| 472 | 2025-06-16 00:51:35 | opticist | 2 | 121059 | 10 | 13.593 | 8906.0 |
| 471 | 2025-06-15 06:38:51 | opticist | 1 | 82945 | 3 | 3.436 | 24140.0 |
| 470 | 2025-06-11 01:25:20 | opticist | 3 | 146162 | 43 | 33.800 | 4324.3 |
| 469 | 2025-06-10 06:08:09 | opticist | 1 | 82945 | 3 | 6.110 | 13575.3 |
| 468 | 2025-06-09 16:35:34 | opticist | 3 | 146162 | 43 | 8.530 | 17135.1 |
| 467 | 2025-06-05 23:03:01 | opticist | 2 | 121059 | 10 | 18.376 | 6587.9 |
| 466 | 2025-06-05 22:54:57 | opticist | 3 | 146162 | 43 | 44.736 | 3267.2 |
| 465 | 2025-06-05 15:20:52 | opticist | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 464 | 2025-06-03 08:39:45 | opticist | 1 | 82945 | 3 | 6.343 | 13076.6 |
| 463 | 2025-05-31 07:34:53 | opticist | 1 | 82945 | 3 | 4.313 | 19231.4 |
| 462 | 2025-05-18 09:05:23 | opticist | 2 | 121059 | 10 | 17.470 | 6929.5 |
| 461 | 2025-05-18 03:13:29 | opticist | 3 | 146162 | 43 | 36.936 | 3957.2 |
| 460 | 2025-05-16 23:50:35 | opticist | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 459 | 2025-05-15 08:05:47 | opticist | 1 | 82945 | 3 | 6.843 | 12121.1 |
| 458 | 2025-05-10 05:54:30 | opticist | 1 | 82945 | 3 | 5.440 | 15247.2 |
| 457 | 2025-05-08 10:39:59 | opticist | 1 | 82945 | 3 | 6.736 | 12313.7 |
| 456 | 2025-05-01 00:36:48 | opticist | 3 | 146162 | 43 | 24.970 | 5853.5 |
| 455 | 2025-04-30 09:58:06 | opticist | 3 | 146162 | 43 | 40.940 | 3570.2 |
| 454 | 2025-04-26 19:30:10 | opticist | 3 | 146162 | 43 | 46.800 | 3123.1 |
| 453 | 2025-04-26 09:37:04 | opticist | 3 | 146162 | 43 | 36.143 | 4044.0 |
| 452 | 2025-04-22 10:11:01 | opticist | 3 | 146162 | 43 | 7.500 | 19488.3 |
| 451 | 2025-04-22 05:05:14 | opticist | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 450 | 2025-04-17 11:55:57 | opticist | 4 | 161609 | 468 | 13.220 | 12224.6 |
| 449 | 2025-04-14 07:27:32 | opticist | 1 | 82945 | 3 | 3.766 | 22024.7 |
| 448 | 2025-04-12 15:36:37 | opticist | 1 | 82945 | 3 | 7.016 | 11822.3 |
| 447 | 2025-04-09 15:24:07 | opticist | 4 | 161609 | 468 | 58.693 | 2753.5 |
| 446 | 2025-04-01 22:29:33 | opticist | 1 | 82945 | 3 | 3.486 | 23793.7 |
| 445 | 2025-03-29 11:53:02 | opticist | 4 | 161609 | 468 | 70.473 | 2293.2 |
| 444 | 2025-03-28 05:25:17 | opticist | 4 | 161609 | 468 | 62.580 | 2582.4 |
| 443 | 2025-03-26 09:07:55 | opticist | 4 | 161609 | 468 | 66.893 | 2415.9 |
| 442 | 2025-03-24 20:19:42 | opticist | 2 | 121059 | 10 | 3.343 | 36212.7 |
| 441 | 2025-03-24 18:07:46 | opticist | 3 | 146162 | 43 | 7.156 | 20425.1 |
| 440 | 2025-03-22 06:27:00 | opticist | 1 | 82945 | 3 | 7.233 | 11467.6 |
| 439 | 2025-03-17 10:59:14 | opticist | 1 | 82945 | 3 | 6.780 | 12233.8 |
| 438 | 2025-03-13 00:56:19 | opticist | 1 | 82945 | 3 | 3.410 | 24324.0 |
| 437 | 2025-03-10 15:37:14 | opticist | 1 | 82945 | 3 | 5.236 | 15841.3 |
| 436 | 2025-03-08 11:08:05 | opticist | 1 | 82945 | 3 | 8.483 | 9777.8 |
| 435 | 2025-03-04 11:12:17 | opticist | 1 | 82945 | 3 | 7.000 | 11849.3 |
| 434 | 2025-02-19 23:46:23 | opticist | 1 | 82945 | 3 | 6.703 | 12374.3 |
| 433 | 2025-02-04 03:35:51 | opticist | 1 | 82945 | 3 | 6.686 | 12405.8 |
| 432 | 2025-02-02 11:31:00 | opticist | 1 | 82945 | 3 | 10.686 | 7762.0 |
| 431 | 2025-01-28 14:51:30 | opticist | 1 | 82945 | 3 | 5.330 | 15561.9 |
| 430 | 2025-01-10 04:33:13 | opticist | 3 | 146162 | 43 | 17.110 | 8542.5 |
| 429 | 2025-01-08 13:42:43 | opticist | 3 | 146162 | 43 | 32.250 | 4532.2 |
| 428 | 2025-01-07 07:35:22 | opticist | 3 | 146162 | 43 | 18.796 | 7776.2 |
| 427 | 2025-01-06 17:55:38 | opticist | 3 | 146162 | 43 | 44.406 | 3291.5 |
| 426 | 2025-01-06 17:55:37 | opticist | 2 | 121059 | 10 | 11.986 | 10100.0 |
| 425 | 2025-01-06 17:40:24 | opticist | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 424 | 2025-01-04 17:11:20 | opticist | 1 | 82945 | 3 | 3.096 | 26791.0 |
| 423 | 2025-01-02 22:19:38 | opticist | 1 | 82945 | 3 | 4.486 | 18489.7 |
| 422 | 2024-12-29 08:30:42 | opticist | 1 | 82945 | 3 | 5.423 | 15295.0 |
| 421 | 2024-12-17 03:49:07 | opticist | 1 | 82945 | 3 | 7.206 | 11510.5 |
| 420 | 2024-12-04 13:25:19 | opticist | 3 | 146162 | 43 | 36.516 | 4002.7 |