History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pretype"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 479 | 2025-11-13 14:21:17 | pretype | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 478 | 2025-11-12 14:42:44 | pretype | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 477 | 2025-11-11 12:15:36 | pretype | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 476 | 2025-11-10 12:18:09 | pretype | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 475 | 2025-10-31 12:35:40 | pretype | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 474 | 2025-10-29 13:21:24 | pretype | 1 | 69583 | 5 | 1.373 | 50679.5 |
| 473 | 2025-10-27 20:55:22 | pretype | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 472 | 2025-10-25 22:34:50 | pretype | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 471 | 2025-10-25 21:15:34 | pretype | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 470 | 2025-10-23 08:01:55 | pretype | 1 | 69583 | 5 | 4.063 | 17126.0 |
| 469 | 2025-10-23 08:01:43 | pretype | 1 | 69583 | 5 | 5.780 | 12038.6 |
| 468 | 2025-10-23 08:01:34 | pretype | 1 | 69583 | 5 | 4.576 | 15206.1 |
| 467 | 2025-10-23 08:01:20 | pretype | 1 | 69583 | 5 | 6.093 | 11420.2 |
| 466 | 2025-10-16 12:42:15 | pretype | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 465 | 2025-10-16 07:11:17 | pretype | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 464 | 2025-10-15 11:49:51 | pretype | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 463 | 2025-10-07 13:33:03 | pretype | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 462 | 2025-10-05 13:25:06 | pretype | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 461 | 2025-09-27 12:50:21 | pretype | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 460 | 2025-09-27 12:49:55 | pretype | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 459 | 2025-09-26 20:46:03 | pretype | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 458 | 2025-09-24 21:19:04 | pretype | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 457 | 2025-09-15 15:04:48 | pretype | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 456 | 2025-09-15 07:05:49 | pretype | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 455 | 2025-09-15 04:23:42 | pretype | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 454 | 2025-09-14 12:15:52 | pretype | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 453 | 2025-09-07 16:20:43 | pretype | 1 | 69583 | 5 | 2.156 | 32274.1 |
| 452 | 2025-09-04 14:20:19 | pretype | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 451 | 2025-09-04 13:18:33 | pretype | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 450 | 2025-09-01 05:59:52 | pretype | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 449 | 2025-08-28 11:56:32 | pretype | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 448 | 2025-08-24 22:46:21 | pretype | 1 | 69583 | 5 | 5.330 | 13055.0 |
| 447 | 2025-08-24 20:59:11 | pretype | 1 | 69583 | 5 | 8.736 | 7965.1 |
| 446 | 2025-08-24 20:58:24 | pretype | 1 | 69583 | 5 | 3.923 | 17737.2 |
| 445 | 2025-08-15 07:19:06 | pretype | 1 | 69583 | 5 | 3.423 | 20328.1 |
| 444 | 2025-08-14 19:15:03 | pretype | 1 | 69583 | 5 | 5.906 | 11781.7 |
| 443 | 2025-08-05 20:23:08 | pretype | 2 | 107671 | 12 | 10.796 | 9973.2 |
| 442 | 2025-08-05 04:10:47 | pretype | 2 | 107671 | 12 | 12.563 | 8570.5 |
| 441 | 2025-08-04 15:34:39 | pretype | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 440 | 2025-08-04 14:56:33 | pretype | 1 | 69583 | 5 | 1.846 | 37693.9 |
| 439 | 2025-08-04 13:50:27 | pretype | 1 | 69583 | 5 | 2.920 | 23829.8 |
| 438 | 2025-07-28 16:29:07 | pretype | 2 | 107671 | 12 | 16.610 | 6482.3 |
| 437 | 2025-07-28 15:18:09 | pretype | 3 | 134027 | 146 | 16.703 | 8024.1 |
| 436 | 2025-07-25 00:33:44 | pretype | 1 | 69583 | 5 | 3.703 | 18791.0 |
| 435 | 2025-07-25 00:24:54 | pretype | 1 | 69583 | 5 | 3.826 | 18186.9 |
| 434 | 2025-07-23 04:17:55 | pretype | 1 | 69583 | 5 | 5.313 | 13096.7 |
| 433 | 2025-07-22 16:01:17 | pretype | 1 | 69583 | 5 | 3.173 | 21929.7 |
| 432 | 2025-07-17 09:20:30 | pretype | 3 | 134027 | 146 | 22.296 | 6011.3 |
| 431 | 2025-07-17 07:19:53 | pretype | 2 | 107671 | 12 | 7.390 | 14569.8 |
| 430 | 2025-07-16 10:05:11 | pretype | 3 | 134027 | 146 | 8.956 | 14965.1 |
| 429 | 2025-07-15 23:56:56 | pretype | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 428 | 2025-07-15 23:24:30 | pretype | 1 | 69583 | 5 | 4.546 | 15306.4 |
| 427 | 2025-07-14 22:59:28 | pretype | 1 | 69583 | 5 | 11.220 | 6201.7 |
| 426 | 2025-07-14 08:23:00 | pretype | 1 | 69583 | 5 | 7.030 | 9898.0 |
| 425 | 2025-07-09 08:01:36 | pretype | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 424 | 2025-07-04 14:36:02 | pretype | 1 | 69583 | 5 | 5.780 | 12038.6 |
| 423 | 2025-06-15 22:26:21 | pretype | 1 | 69583 | 5 | 6.373 | 10918.4 |
| 422 | 2025-06-14 08:03:56 | pretype | 1 | 69583 | 5 | 2.796 | 24886.6 |
| 421 | 2025-06-07 22:57:46 | pretype | 1 | 69583 | 5 | 12.110 | 5745.9 |
| 420 | 2025-06-03 13:16:30 | pretype | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 419 | 2025-05-25 22:52:07 | pretype | 1 | 69583 | 5 | 5.970 | 11655.4 |
| 418 | 2025-05-21 21:58:32 | pretype | 1 | 69583 | 5 | 5.740 | 12122.5 |
| 417 | 2025-05-18 13:56:53 | pretype | 1 | 69583 | 5 | 5.220 | 13330.1 |
| 416 | 2025-05-15 23:15:29 | pretype | 1 | 69583 | 5 | 8.063 | 8629.9 |
| 415 | 2025-05-12 07:48:27 | pretype | 1 | 69583 | 5 | 3.000 | 23194.3 |
| 414 | 2025-05-11 19:50:00 | pretype | 1 | 69583 | 5 | 6.593 | 10554.1 |
| 413 | 2025-05-09 03:11:56 | pretype | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 412 | 2025-05-07 22:54:47 | pretype | 1 | 69583 | 5 | 6.416 | 10845.2 |
| 411 | 2025-05-02 14:31:00 | pretype | 1 | 69583 | 5 | 11.796 | 5898.9 |
| 410 | 2025-04-15 01:50:18 | pretype | 1 | 69583 | 5 | 3.063 | 22717.3 |
| 409 | 2025-04-10 08:17:18 | pretype | 3 | 134027 | 146 | 6.546 | 20474.6 |
| 408 | 2025-04-09 08:34:23 | pretype | 2 | 107671 | 12 | 17.906 | 6013.1 |
| 407 | 2025-04-09 06:55:14 | pretype | 2 | 107671 | 12 | 16.736 | 6433.5 |
| 406 | 2025-04-08 22:32:28 | pretype | 1 | 69583 | 5 | 9.046 | 7692.1 |
| 405 | 2025-04-08 12:01:32 | pretype | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 404 | 2025-04-08 07:06:53 | pretype | 1 | 69583 | 5 | 2.000 | 34791.5 |
| 403 | 2025-04-05 23:01:46 | pretype | 1 | 69583 | 5 | 3.080 | 22591.9 |
| 402 | 2025-03-23 12:41:26 | pretype | 3 | 134027 | 146 | 39.533 | 3390.3 |
| 401 | 2025-03-23 06:46:30 | pretype | 2 | 107671 | 12 | 9.156 | 11759.6 |
| 400 | 2025-03-21 12:18:29 | pretype | 2 | 107671 | 12 | 11.876 | 9066.3 |
| 399 | 2025-03-21 10:12:34 | pretype | 3 | 134027 | 146 | 33.673 | 3980.3 |
| 398 | 2025-03-20 15:12:53 | pretype | 1 | 69583 | 5 | 5.940 | 11714.3 |
| 397 | 2025-03-18 21:49:19 | pretype | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 396 | 2025-03-14 07:10:38 | pretype | 1 | 69583 | 5 | 3.190 | 21812.9 |
| 395 | 2025-03-09 01:41:49 | pretype | 1 | 69583 | 5 | 7.266 | 9576.5 |
| 394 | 2025-03-08 12:23:18 | pretype | 3 | 134027 | 146 | 34.250 | 3913.2 |
| 393 | 2025-03-07 23:52:50 | pretype | 1 | 69583 | 5 | 5.156 | 13495.5 |
| 392 | 2025-03-06 18:28:35 | pretype | 3 | 134027 | 146 | 45.553 | 2942.2 |
| 391 | 2025-03-06 00:47:20 | pretype | 1 | 69583 | 5 | 3.233 | 21522.7 |
| 390 | 2025-03-06 00:45:27 | pretype | 3 | 134027 | 146 | 32.876 | 4076.7 |
| 389 | 2025-03-06 00:45:24 | pretype | 2 | 107671 | 12 | 25.186 | 4275.0 |
| 388 | 2025-02-18 09:06:51 | pretype | 1 | 69583 | 5 | 2.936 | 23699.9 |
| 387 | 2025-02-10 10:41:13 | pretype | 3 | 134027 | 146 | 38.176 | 3510.8 |
| 386 | 2025-02-09 02:23:06 | pretype | 3 | 134027 | 146 | 27.470 | 4879.0 |
| 385 | 2025-02-07 09:14:06 | pretype | 3 | 134027 | 146 | 29.626 | 4524.0 |
| 384 | 2025-02-07 09:14:03 | pretype | 2 | 107671 | 12 | 8.033 | 13403.6 |
| 383 | 2025-01-20 11:56:45 | pretype | 1 | 69583 | 5 | 2.983 | 23326.5 |
| 382 | 2024-12-19 15:50:48 | pretype | 3 | 134027 | 146 | 33.406 | 4012.1 |
| 381 | 2024-12-15 16:11:47 | pretype | 3 | 134027 | 146 | 33.356 | 4018.1 |
| 380 | 2024-12-14 19:10:42 | pretype | 3 | 134027 | 146 | 47.270 | 2835.4 |