History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"apatite"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 518 | 2025-10-24 13:08:35 | apatite | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 517 | 2025-09-22 00:22:20 | apatite | 3 | 134027 | 204 | 12.716 | 10540.0 |
| 516 | 2025-09-21 17:54:47 | apatite | 1 | 69583 | 2 | 1.123 | 61961.7 |
| 515 | 2025-09-01 19:38:58 | apatite | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 514 | 2025-08-27 13:50:54 | apatite | 1 | 69583 | 2 | 1.106 | 62914.1 |
| 513 | 2025-08-27 03:58:12 | apatite | 1 | 69583 | 2 | 1.750 | 39761.7 |
| 512 | 2025-08-25 05:36:19 | apatite | 1 | 69583 | 2 | 4.516 | 15408.1 |
| 511 | 2025-08-19 10:02:41 | apatite | 1 | 69583 | 2 | 3.000 | 23194.3 |
| 510 | 2025-08-09 11:46:59 | apatite | 1 | 69583 | 2 | 8.673 | 8022.9 |
| 509 | 2025-08-04 11:03:08 | apatite | 1 | 69583 | 2 | 3.360 | 20709.2 |
| 508 | 2025-08-01 10:52:54 | apatite | 1 | 69583 | 2 | 3.173 | 21929.7 |
| 507 | 2025-08-01 03:29:58 | apatite | 1 | 69583 | 2 | 5.766 | 12067.8 |
| 506 | 2025-07-23 03:08:34 | apatite | 1 | 69583 | 2 | 4.966 | 14011.9 |
| 505 | 2025-07-22 23:18:55 | apatite | 1 | 69583 | 2 | 3.080 | 22591.9 |
| 504 | 2025-07-05 11:32:56 | apatite | 1 | 69583 | 2 | 3.893 | 17873.9 |
| 503 | 2025-07-02 18:54:03 | apatite | 1 | 69583 | 2 | 5.783 | 12032.3 |
| 502 | 2025-06-30 13:28:22 | apatite | 2 | 107671 | 13 | 19.800 | 5437.9 |
| 501 | 2025-06-30 12:12:20 | apatite | 2 | 107671 | 13 | 21.876 | 4921.9 |
| 500 | 2025-06-30 10:13:12 | apatite | 1 | 69583 | 2 | 5.313 | 13096.7 |
| 499 | 2025-06-21 03:13:03 | apatite | 1 | 69583 | 2 | 4.826 | 14418.4 |
| 498 | 2025-06-18 06:12:18 | apatite | 1 | 69583 | 2 | 7.796 | 8925.5 |
| 497 | 2025-06-05 13:05:20 | apatite | 1 | 69583 | 2 | 2.780 | 25029.9 |
| 496 | 2025-06-04 11:08:52 | apatite | 1 | 69583 | 2 | 3.876 | 17952.3 |
| 495 | 2025-06-02 17:33:15 | apatite | 1 | 69583 | 2 | 3.313 | 21003.0 |
| 494 | 2025-05-29 09:01:06 | apatite | 1 | 69583 | 2 | 9.000 | 7731.4 |
| 493 | 2025-05-23 21:45:32 | apatite | 2 | 107671 | 13 | 17.546 | 6136.5 |
| 492 | 2025-05-02 17:31:18 | apatite | 1 | 69583 | 2 | 5.500 | 12651.5 |
| 491 | 2025-05-02 10:36:13 | apatite | 1 | 69583 | 2 | 6.593 | 10554.1 |
| 490 | 2025-05-01 11:18:27 | apatite | 2 | 107671 | 13 | 3.203 | 33615.7 |
| 489 | 2025-04-30 16:30:14 | apatite | 2 | 107671 | 13 | 9.093 | 11841.1 |
| 488 | 2025-04-30 13:22:05 | apatite | 1 | 69583 | 2 | 6.826 | 10193.8 |
| 487 | 2025-04-20 02:46:19 | apatite | 1 | 69583 | 2 | 7.076 | 9833.7 |
| 486 | 2025-04-17 12:18:57 | apatite | 2 | 107671 | 13 | 3.063 | 35152.1 |
| 485 | 2025-04-17 06:57:22 | apatite | 3 | 134027 | 204 | 26.546 | 5048.9 |
| 484 | 2025-04-16 15:51:43 | apatite | 3 | 134027 | 204 | 32.346 | 4143.5 |
| 483 | 2025-04-15 08:38:50 | apatite | 1 | 69583 | 2 | 1.236 | 56296.9 |
| 482 | 2025-04-10 08:12:27 | apatite | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 481 | 2025-03-31 19:56:57 | apatite | 1 | 69583 | 2 | 3.513 | 19807.3 |
| 480 | 2025-03-27 12:55:59 | apatite | 1 | 69583 | 2 | 7.206 | 9656.3 |
| 479 | 2025-03-21 01:45:55 | apatite | 2 | 107671 | 13 | 16.500 | 6525.5 |
| 478 | 2025-03-21 00:27:05 | apatite | 3 | 134027 | 204 | 20.766 | 6454.2 |
| 477 | 2025-03-19 04:16:48 | apatite | 1 | 69583 | 2 | 1.060 | 65644.3 |
| 476 | 2025-03-16 00:44:38 | apatite | 1 | 69583 | 2 | 5.860 | 11874.2 |
| 475 | 2025-03-13 07:58:35 | apatite | 1 | 69583 | 2 | 6.030 | 11539.5 |
| 474 | 2025-03-11 12:36:57 | apatite | 1 | 69583 | 2 | 2.500 | 27833.2 |
| 473 | 2025-02-25 23:03:06 | apatite | 1 | 69583 | 2 | 13.500 | 5154.3 |
| 472 | 2025-02-23 19:44:46 | apatite | 1 | 69583 | 2 | 5.656 | 12302.5 |
| 471 | 2025-02-23 18:49:04 | apatite | 1 | 69583 | 2 | 2.860 | 24329.7 |
| 470 | 2025-02-10 14:27:35 | apatite | 1 | 69583 | 2 | 5.220 | 13330.1 |
| 469 | 2025-01-18 05:18:37 | apatite | 1 | 69583 | 2 | 8.423 | 8261.1 |
| 468 | 2025-01-10 03:58:08 | apatite | 1 | 69583 | 2 | 4.143 | 16795.3 |
| 467 | 2025-01-09 01:29:53 | apatite | 1 | 69583 | 2 | 4.126 | 16864.5 |
| 466 | 2024-12-21 10:54:29 | apatite | 1 | 69583 | 2 | 5.986 | 11624.3 |
| 465 | 2024-12-20 12:04:26 | apatite | 3 | 134027 | 204 | 37.096 | 3613.0 |
| 464 | 2024-12-19 17:28:21 | apatite | 1 | 69583 | 2 | 5.673 | 12265.6 |
| 463 | 2024-12-18 12:10:06 | apatite | 2 | 107671 | 13 | 16.170 | 6658.7 |
| 462 | 2024-12-18 12:09:55 | apatite | 1 | 69583 | 2 | 3.266 | 21305.3 |
| 461 | 2024-12-17 19:34:30 | apatite | 3 | 134027 | 204 | 19.626 | 6829.1 |
| 460 | 2024-12-16 09:31:45 | apatite | 3 | 134027 | 204 | 27.063 | 4952.4 |
| 459 | 2024-12-16 03:37:10 | apatite | 3 | 134027 | 204 | 40.643 | 3297.7 |
| 458 | 2024-12-12 21:00:28 | apatite | 2 | 107671 | 13 | 8.406 | 12808.8 |
| 457 | 2024-12-10 19:24:59 | apatite | 2 | 107671 | 13 | 3.716 | 28975.0 |
| 456 | 2024-12-09 11:06:55 | apatite | 2 | 107671 | 13 | 15.983 | 6736.6 |
| 455 | 2024-12-09 11:05:54 | apatite | 1 | 69583 | 2 | 3.110 | 22374.0 |
| 454 | 2024-12-04 03:04:39 | apatite | 3 | 134027 | 204 | 6.623 | 20236.6 |
| 453 | 2024-11-14 03:48:12 | apatite | 3 | 134027 | 204 | 47.600 | 2815.7 |
| 452 | 2024-11-12 11:32:29 | apatite | 3 | 134027 | 204 | 34.093 | 3931.2 |
| 451 | 2024-11-12 07:55:01 | apatite | 3 | 134027 | 204 | 33.890 | 3954.8 |
| 450 | 2024-11-11 14:55:12 | apatite | 3 | 134027 | 204 | 33.986 | 3943.6 |
| 449 | 2024-11-11 14:55:13 | apatite | 2 | 107671 | 13 | 15.910 | 6767.5 |
| 448 | 2024-11-11 08:55:46 | apatite | 1 | 69583 | 2 | 1.343 | 51811.6 |
| 447 | 2024-11-08 21:00:49 | apatite | 1 | 69583 | 2 | 3.373 | 20629.4 |
| 446 | 2024-10-23 09:51:09 | apatite | 1 | 69583 | 2 | 2.906 | 23944.6 |
| 445 | 2024-10-08 08:05:58 | apatite | 1 | 69583 | 2 | 5.703 | 12201.1 |
| 444 | 2024-09-26 16:30:59 | apatite | 1 | 69583 | 2 | 9.030 | 7705.8 |
| 443 | 2024-09-22 07:27:26 | apatite | 1 | 69583 | 2 | 8.720 | 7979.7 |
| 442 | 2024-09-06 05:43:15 | apatite | 1 | 69583 | 2 | 12.813 | 5430.7 |
| 441 | 2024-09-04 04:39:37 | apatite | 1 | 69583 | 2 | 12.206 | 5700.7 |
| 440 | 2024-08-28 10:57:28 | apatite | 1 | 69583 | 2 | 13.160 | 5287.5 |
| 439 | 2024-08-17 22:55:53 | apatite | 1 | 69583 | 2 | 5.656 | 12302.5 |
| 438 | 2024-08-09 18:29:39 | apatite | 1 | 69583 | 2 | 2.220 | 31343.7 |
| 437 | 2024-08-09 15:19:15 | apatite | 1 | 69583 | 2 | 2.453 | 28366.5 |
| 436 | 2024-07-30 01:02:49 | apatite | 1 | 69583 | 2 | 2.580 | 26970.2 |
| 435 | 2024-07-29 06:11:40 | apatite | 1 | 69583 | 2 | 1.766 | 39401.5 |
| 434 | 2024-07-26 18:33:25 | apatite | 1 | 69583 | 2 | 2.830 | 24587.6 |
| 433 | 2024-07-22 22:43:34 | apatite | 1 | 69583 | 2 | 3.953 | 17602.6 |
| 432 | 2024-07-21 06:01:59 | apatite | 1 | 69583 | 2 | 3.326 | 20920.9 |
| 431 | 2024-07-20 21:17:41 | apatite | 1 | 69583 | 2 | 4.186 | 16622.8 |
| 430 | 2024-06-29 19:33:15 | apatite | 1 | 69583 | 2 | 5.300 | 13128.9 |
| 429 | 2024-06-19 14:00:14 | apatite | 1 | 69583 | 2 | 4.393 | 15839.5 |
| 428 | 2024-06-16 13:14:36 | apatite | 1 | 69583 | 2 | 3.410 | 20405.6 |
| 427 | 2024-06-06 20:18:00 | apatite | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 426 | 2024-05-11 00:12:06 | apatite | 1 | 69583 | 2 | 3.126 | 22259.4 |
| 425 | 2024-03-28 08:41:02 | apatite | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 424 | 2024-03-01 18:37:13 | apatite | 1 | 69583 | 2 | 1.280 | 54361.7 |
| 423 | 2024-01-27 00:56:19 | apatite | 2 | 107671 | 13 | 6.563 | 16405.8 |
| 422 | 2024-01-27 00:55:27 | apatite | 3 | 134027 | 204 | 7.000 | 19146.7 |
| 421 | 2024-01-26 06:09:53 | apatite | 3 | 134027 | 204 | 14.033 | 9550.8 |
| 420 | 2024-01-15 18:24:36 | apatite | 3 | 134027 | 204 | 6.610 | 20276.4 |
| 419 | 2024-01-15 18:24:37 | apatite | 2 | 107671 | 13 | 3.330 | 32333.6 |