History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"defectives"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 515 | 2025-10-21 11:02:19 | defectives | 1 | 67641 | 3 | 5.820 | 11622.2 |
| 514 | 2025-10-14 17:47:44 | defectives | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 513 | 2025-10-11 09:53:40 | defectives | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 512 | 2025-10-07 12:51:41 | defectives | 1 | 67641 | 3 | 1.043 | 64852.3 |
| 511 | 2025-09-30 20:34:33 | defectives | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 510 | 2025-09-25 16:50:47 | defectives | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 509 | 2025-09-20 06:19:57 | defectives | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 508 | 2025-09-14 13:02:54 | defectives | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 507 | 2025-09-13 18:38:32 | defectives | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 506 | 2025-09-05 21:01:44 | defectives | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 505 | 2025-09-05 14:15:56 | defectives | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 504 | 2025-08-25 13:38:26 | defectives | 1 | 67641 | 3 | 3.720 | 18183.1 |
| 503 | 2025-08-24 22:34:50 | defectives | 1 | 67641 | 3 | 3.313 | 20416.8 |
| 502 | 2025-08-23 11:50:48 | defectives | 3 | 140603 | 53 | 33.376 | 4212.7 |
| 501 | 2025-08-21 14:10:04 | defectives | 2 | 108824 | 14 | 7.623 | 14275.7 |
| 500 | 2025-08-20 10:37:51 | defectives | 2 | 108824 | 14 | 3.250 | 33484.3 |
| 499 | 2025-08-20 06:53:53 | defectives | 3 | 140603 | 53 | 5.920 | 23750.5 |
| 498 | 2025-08-20 01:12:24 | defectives | 3 | 140603 | 53 | 6.356 | 22121.3 |
| 497 | 2025-08-18 01:46:12 | defectives | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 496 | 2025-08-09 14:19:53 | defectives | 1 | 67641 | 3 | 5.516 | 12262.7 |
| 495 | 2025-08-09 05:29:59 | defectives | 1 | 67641 | 3 | 6.516 | 10380.8 |
| 494 | 2025-07-25 09:24:54 | defectives | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 493 | 2025-07-25 01:28:32 | defectives | 1 | 67641 | 3 | 3.750 | 18037.6 |
| 492 | 2025-07-22 14:04:02 | defectives | 1 | 67641 | 3 | 5.050 | 13394.3 |
| 491 | 2025-07-21 21:08:02 | defectives | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 490 | 2025-07-19 12:15:13 | defectives | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 489 | 2025-07-12 14:35:14 | defectives | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 488 | 2025-07-11 17:31:02 | defectives | 1 | 67641 | 3 | 3.096 | 21847.9 |
| 487 | 2025-07-11 01:47:18 | defectives | 1 | 67641 | 3 | 5.670 | 11929.6 |
| 486 | 2025-07-07 02:17:47 | defectives | 1 | 67641 | 3 | 3.530 | 19161.8 |
| 485 | 2025-07-02 13:38:45 | defectives | 1 | 67641 | 3 | 6.000 | 11273.5 |
| 484 | 2025-06-30 04:52:43 | defectives | 1 | 67641 | 3 | 5.173 | 13075.8 |
| 483 | 2025-06-25 07:39:43 | defectives | 1 | 67641 | 3 | 6.170 | 10962.9 |
| 482 | 2025-06-24 09:25:45 | defectives | 1 | 67641 | 3 | 6.986 | 9682.4 |
| 481 | 2025-06-20 23:43:17 | defectives | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 480 | 2025-05-24 10:31:54 | defectives | 1 | 67641 | 3 | 4.563 | 14823.8 |
| 479 | 2025-05-21 21:45:08 | defectives | 2 | 108824 | 14 | 14.096 | 7720.2 |
| 478 | 2025-05-18 13:58:09 | defectives | 2 | 108824 | 14 | 17.236 | 6313.8 |
| 477 | 2025-05-17 13:20:01 | defectives | 1 | 67641 | 3 | 5.283 | 12803.5 |
| 476 | 2025-04-24 01:11:21 | defectives | 3 | 140603 | 53 | 32.830 | 4282.8 |
| 475 | 2025-04-24 00:22:33 | defectives | 3 | 140603 | 53 | 36.910 | 3809.3 |
| 474 | 2025-04-23 03:27:20 | defectives | 1 | 67641 | 3 | 8.326 | 8124.1 |
| 473 | 2025-04-22 21:07:25 | defectives | 3 | 140603 | 53 | 19.550 | 7192.0 |
| 472 | 2025-04-21 10:33:15 | defectives | 3 | 140603 | 53 | 23.330 | 6026.7 |
| 471 | 2025-04-21 05:24:27 | defectives | 3 | 140603 | 53 | 31.860 | 4413.2 |
| 470 | 2025-04-20 01:10:18 | defectives | 1 | 67641 | 3 | 4.830 | 14004.3 |
| 469 | 2025-04-17 17:56:02 | defectives | 3 | 140603 | 53 | 6.860 | 20496.1 |
| 468 | 2025-04-09 17:10:12 | defectives | 3 | 140603 | 53 | 26.096 | 5387.9 |
| 467 | 2025-04-09 08:27:55 | defectives | 1 | 67641 | 3 | 6.326 | 10692.5 |
| 466 | 2025-04-08 21:59:21 | defectives | 2 | 108824 | 14 | 15.940 | 6827.1 |
| 465 | 2025-04-08 12:44:35 | defectives | 1 | 67641 | 3 | 5.436 | 12443.2 |
| 464 | 2025-04-03 23:22:59 | defectives | 1 | 67641 | 3 | 7.250 | 9329.8 |
| 463 | 2025-03-26 14:06:22 | defectives | 3 | 140603 | 53 | 8.516 | 16510.5 |
| 462 | 2025-03-22 04:50:46 | defectives | 3 | 140603 | 53 | 25.516 | 5510.4 |
| 461 | 2025-03-20 02:21:36 | defectives | 1 | 67641 | 3 | 2.796 | 24192.1 |
| 460 | 2025-03-17 21:05:33 | defectives | 3 | 140603 | 53 | 16.216 | 8670.6 |
| 459 | 2025-03-13 12:50:47 | defectives | 3 | 140603 | 53 | 29.330 | 4793.8 |
| 458 | 2025-03-10 22:01:21 | defectives | 1 | 67641 | 3 | 2.940 | 23007.1 |
| 457 | 2025-03-05 09:01:00 | defectives | 3 | 140603 | 53 | 32.440 | 4334.2 |
| 456 | 2025-03-03 13:28:03 | defectives | 3 | 140603 | 53 | 42.550 | 3304.4 |
| 455 | 2025-03-03 13:27:57 | defectives | 2 | 108824 | 14 | 20.406 | 5332.9 |
| 454 | 2025-03-03 13:27:32 | defectives | 3 | 140603 | 53 | 29.313 | 4796.6 |
| 453 | 2025-03-03 12:39:29 | defectives | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 452 | 2025-02-25 16:39:54 | defectives | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 451 | 2025-02-11 23:02:38 | defectives | 1 | 67641 | 3 | 6.016 | 11243.5 |
| 450 | 2025-02-04 01:27:15 | defectives | 1 | 67641 | 3 | 7.673 | 8815.5 |
| 449 | 2025-02-01 20:36:58 | defectives | 3 | 140603 | 53 | 32.783 | 4288.9 |
| 448 | 2025-02-01 20:36:47 | defectives | 2 | 108824 | 14 | 16.453 | 6614.2 |
| 447 | 2025-02-01 13:14:49 | defectives | 3 | 140603 | 53 | 6.936 | 20271.5 |
| 446 | 2025-01-30 11:01:35 | defectives | 2 | 108824 | 14 | 15.606 | 6973.2 |
| 445 | 2025-01-30 10:59:51 | defectives | 1 | 67641 | 3 | 3.110 | 21749.5 |
| 444 | 2025-01-30 03:10:23 | defectives | 3 | 140603 | 53 | 32.096 | 4380.7 |
| 443 | 2025-01-30 03:10:24 | defectives | 3 | 140603 | 53 | 30.610 | 4593.4 |
| 442 | 2025-01-27 12:29:43 | defectives | 3 | 140603 | 53 | 35.330 | 3979.7 |
| 441 | 2025-01-27 10:04:38 | defectives | 4 | 161450 | 271 | 63.216 | 2553.9 |
| 440 | 2025-01-27 10:04:35 | defectives | 3 | 140603 | 53 | 32.570 | 4316.9 |
| 439 | 2025-01-27 10:04:35 | defectives | 2 | 108824 | 14 | 14.863 | 7321.8 |
| 438 | 2025-01-27 09:43:09 | defectives | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 437 | 2025-01-02 18:48:41 | defectives | 1 | 67641 | 3 | 8.860 | 7634.4 |
| 436 | 2024-12-18 21:50:19 | defectives | 1 | 67641 | 3 | 8.033 | 8420.4 |
| 435 | 2024-12-04 21:08:04 | defectives | 4 | 161450 | 271 | 54.096 | 2984.5 |
| 434 | 2024-12-04 05:40:59 | defectives | 4 | 161450 | 271 | 53.000 | 3046.2 |
| 433 | 2024-12-04 05:41:19 | defectives | 3 | 140603 | 53 | 29.253 | 4806.4 |
| 432 | 2024-12-04 05:41:23 | defectives | 2 | 108824 | 14 | 15.470 | 7034.5 |
| 431 | 2024-12-04 05:40:23 | defectives | 1 | 67641 | 3 | 5.956 | 11356.8 |
| 430 | 2024-12-04 02:31:52 | defectives | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 429 | 2024-11-28 14:02:36 | defectives | 2 | 108824 | 14 | 20.640 | 5272.5 |
| 428 | 2024-11-28 14:02:33 | defectives | 3 | 140603 | 53 | 16.670 | 8434.5 |
| 427 | 2024-11-28 13:07:49 | defectives | 1 | 67641 | 3 | 5.580 | 12122.0 |
| 426 | 2024-11-13 07:39:43 | defectives | 2 | 108824 | 14 | 11.593 | 9387.0 |
| 425 | 2024-11-13 07:36:05 | defectives | 1 | 67641 | 3 | 8.110 | 8340.4 |
| 424 | 2024-11-02 05:48:34 | defectives | 3 | 140603 | 53 | 31.173 | 4510.4 |
| 423 | 2024-11-02 01:57:10 | defectives | 1 | 67641 | 3 | 2.096 | 32271.5 |
| 422 | 2024-11-01 15:01:40 | defectives | 3 | 140603 | 53 | 30.440 | 4619.0 |
| 421 | 2024-11-01 15:01:38 | defectives | 2 | 108824 | 14 | 18.563 | 5862.4 |
| 420 | 2024-11-01 06:30:53 | defectives | 4 | 161450 | 271 | 46.720 | 3455.7 |
| 419 | 2024-10-31 21:30:19 | defectives | 4 | 161450 | 271 | 47.596 | 3392.1 |
| 418 | 2024-10-31 14:44:11 | defectives | 4 | 161450 | 271 | 56.940 | 2835.4 |
| 417 | 2024-10-31 04:31:23 | defectives | 4 | 161450 | 271 | 39.580 | 4079.1 |
| 416 | 2024-10-31 04:31:25 | defectives | 3 | 140603 | 53 | 28.160 | 4993.0 |