History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"primrose"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 455 | 2025-10-26 15:51:35 | primrose | 3 | 146162 | 64 | 7.063 | 20694.0 |
| 454 | 2025-10-25 16:37:42 | primrose | 1 | 82945 | 2 | 1.576 | 52630.1 |
| 453 | 2025-10-21 02:28:09 | primrose | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 452 | 2025-10-18 19:28:06 | primrose | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 451 | 2025-10-17 14:55:21 | primrose | 3 | 146162 | 64 | 7.173 | 20376.7 |
| 450 | 2025-09-26 22:12:47 | primrose | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 449 | 2025-09-21 20:45:43 | primrose | 3 | 146162 | 64 | 10.110 | 14457.2 |
| 448 | 2025-09-08 20:19:44 | primrose | 1 | 82945 | 2 | 2.296 | 36125.9 |
| 447 | 2025-09-03 13:54:55 | primrose | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 446 | 2025-08-27 19:05:24 | primrose | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 445 | 2025-08-27 12:24:45 | primrose | 1 | 82945 | 2 | 1.716 | 48336.2 |
| 444 | 2025-08-27 00:19:19 | primrose | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 443 | 2025-08-24 08:45:10 | primrose | 1 | 82945 | 2 | 3.403 | 24374.1 |
| 442 | 2025-08-18 00:01:17 | primrose | 1 | 82945 | 2 | 1.340 | 61899.3 |
| 441 | 2025-08-17 22:47:21 | primrose | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 440 | 2025-08-16 16:57:43 | primrose | 2 | 121059 | 7 | 3.456 | 35028.6 |
| 439 | 2025-08-12 13:39:38 | primrose | 1 | 82945 | 2 | 3.456 | 24000.3 |
| 438 | 2025-08-12 11:24:58 | primrose | 3 | 146162 | 64 | 33.733 | 4332.9 |
| 437 | 2025-08-11 09:27:03 | primrose | 3 | 146162 | 64 | 47.893 | 3051.8 |
| 436 | 2025-08-11 08:37:29 | primrose | 2 | 121059 | 7 | 9.893 | 12236.8 |
| 435 | 2025-08-09 12:17:33 | primrose | 1 | 82945 | 2 | 3.253 | 25498.0 |
| 434 | 2025-08-09 06:40:20 | primrose | 4 | 161609 | 562 | 42.580 | 3795.4 |
| 433 | 2025-08-09 03:49:23 | primrose | 1 | 82945 | 2 | 2.690 | 30834.6 |
| 432 | 2025-08-09 03:07:21 | primrose | 1 | 82945 | 2 | 7.016 | 11822.3 |
| 431 | 2025-08-08 13:18:30 | primrose | 1 | 82945 | 2 | 1.593 | 52068.4 |
| 430 | 2025-08-05 22:09:44 | primrose | 4 | 161609 | 562 | 40.376 | 4002.6 |
| 429 | 2025-08-05 22:09:42 | primrose | 4 | 161609 | 562 | 33.783 | 4783.7 |
| 428 | 2025-07-24 14:52:44 | primrose | 1 | 82945 | 2 | 7.060 | 11748.6 |
| 427 | 2025-07-22 11:55:22 | primrose | 1 | 82945 | 2 | 10.173 | 8153.4 |
| 426 | 2025-07-21 07:08:04 | primrose | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 425 | 2025-07-21 04:23:02 | primrose | 1 | 82945 | 2 | 2.873 | 28870.5 |
| 424 | 2025-07-19 06:09:45 | primrose | 4 | 161609 | 562 | 17.093 | 9454.7 |
| 423 | 2025-07-17 07:57:53 | primrose | 2 | 121059 | 7 | 7.856 | 15409.8 |
| 422 | 2025-07-15 12:49:17 | primrose | 4 | 161609 | 562 | 65.470 | 2468.4 |
| 421 | 2025-07-13 12:33:38 | primrose | 2 | 121059 | 7 | 5.483 | 22079.0 |
| 420 | 2025-07-13 02:20:14 | primrose | 1 | 82945 | 2 | 3.000 | 27648.3 |
| 419 | 2025-07-13 01:39:44 | primrose | 1 | 82945 | 2 | 3.580 | 23169.0 |
| 418 | 2025-07-12 05:00:21 | primrose | 4 | 161609 | 562 | 11.766 | 13735.3 |
| 417 | 2025-07-10 22:10:11 | primrose | 1 | 82945 | 2 | 6.660 | 12454.2 |
| 416 | 2025-07-10 14:44:25 | primrose | 1 | 82945 | 2 | 7.860 | 10552.8 |
| 415 | 2025-07-10 07:49:34 | primrose | 4 | 161609 | 562 | 70.626 | 2288.2 |
| 414 | 2025-07-07 04:19:23 | primrose | 1 | 82945 | 2 | 4.576 | 18126.1 |
| 413 | 2025-07-03 12:56:05 | primrose | 1 | 82945 | 2 | 2.736 | 30316.2 |
| 412 | 2025-07-02 02:54:08 | primrose | 4 | 161609 | 562 | 99.113 | 1630.6 |
| 411 | 2025-06-28 15:49:40 | primrose | 4 | 161609 | 562 | 45.893 | 3521.4 |
| 410 | 2025-06-28 06:18:01 | primrose | 4 | 161609 | 562 | 33.720 | 4792.7 |
| 409 | 2025-06-28 01:03:48 | primrose | 2 | 121059 | 7 | 15.310 | 7907.2 |
| 408 | 2025-06-27 23:22:36 | primrose | 3 | 146162 | 64 | 22.390 | 6528.0 |
| 407 | 2025-06-27 14:48:51 | primrose | 1 | 82945 | 2 | 7.233 | 11467.6 |
| 406 | 2025-06-27 09:06:53 | primrose | 4 | 161609 | 562 | 67.406 | 2397.5 |
| 405 | 2025-06-27 02:43:29 | primrose | 1 | 82945 | 2 | 6.313 | 13138.8 |
| 404 | 2025-06-24 21:44:51 | primrose | 4 | 161609 | 562 | 16.923 | 9549.7 |
| 403 | 2025-06-24 18:33:00 | primrose | 3 | 146162 | 64 | 7.970 | 18339.0 |
| 402 | 2025-06-23 21:30:03 | primrose | 2 | 121059 | 7 | 21.033 | 5755.7 |
| 401 | 2025-06-23 09:46:19 | primrose | 1 | 82945 | 2 | 1.440 | 57600.7 |
| 400 | 2025-06-19 13:45:58 | primrose | 1 | 82945 | 2 | 1.310 | 63316.8 |
| 399 | 2025-06-16 17:48:40 | primrose | 1 | 82945 | 2 | 7.033 | 11793.7 |
| 398 | 2025-06-13 17:59:55 | primrose | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 397 | 2025-06-12 09:19:04 | primrose | 1 | 82945 | 2 | 9.063 | 9152.0 |
| 396 | 2025-06-10 15:28:10 | primrose | 1 | 82945 | 2 | 10.093 | 8218.1 |
| 395 | 2025-06-08 01:54:45 | primrose | 1 | 82945 | 2 | 11.063 | 7497.5 |
| 394 | 2025-06-01 17:20:30 | primrose | 1 | 82945 | 2 | 6.920 | 11986.3 |
| 393 | 2025-05-31 07:08:33 | primrose | 1 | 82945 | 2 | 9.376 | 8846.5 |
| 392 | 2025-05-31 06:56:52 | primrose | 1 | 82945 | 2 | 5.813 | 14268.9 |
| 391 | 2025-05-31 06:50:27 | primrose | 1 | 82945 | 2 | 3.466 | 23931.0 |
| 390 | 2025-05-27 03:56:54 | primrose | 1 | 82945 | 2 | 6.740 | 12306.4 |
| 389 | 2025-05-23 10:21:01 | primrose | 1 | 82945 | 2 | 6.596 | 12575.0 |
| 388 | 2025-05-22 04:10:25 | primrose | 1 | 82945 | 2 | 7.076 | 11722.0 |
| 387 | 2025-05-18 11:21:18 | primrose | 1 | 82945 | 2 | 6.703 | 12374.3 |
| 386 | 2025-05-04 07:40:46 | primrose | 3 | 146162 | 64 | 33.393 | 4377.0 |
| 385 | 2025-05-03 13:16:41 | primrose | 1 | 82945 | 2 | 4.686 | 17700.6 |
| 384 | 2025-05-03 08:16:42 | primrose | 1 | 82945 | 2 | 7.656 | 10834.0 |
| 383 | 2025-05-02 20:39:04 | primrose | 3 | 146162 | 64 | 34.940 | 4183.2 |
| 382 | 2025-05-01 23:12:55 | primrose | 3 | 146162 | 64 | 36.223 | 4035.1 |
| 381 | 2025-05-01 21:47:14 | primrose | 2 | 121059 | 7 | 18.713 | 6469.2 |
| 380 | 2025-04-30 17:48:01 | primrose | 3 | 146162 | 64 | 7.233 | 20207.7 |
| 379 | 2025-04-30 01:40:29 | primrose | 1 | 82945 | 2 | 7.736 | 10721.9 |
| 378 | 2025-04-28 00:46:09 | primrose | 3 | 146162 | 64 | 27.016 | 5410.2 |
| 377 | 2025-04-26 09:51:10 | primrose | 3 | 146162 | 64 | 18.863 | 7748.6 |
| 376 | 2025-04-23 20:44:33 | primrose | 3 | 146162 | 64 | 47.016 | 3108.8 |
| 375 | 2025-04-22 20:54:40 | primrose | 2 | 121059 | 7 | 18.970 | 6381.6 |
| 374 | 2025-04-22 09:18:27 | primrose | 1 | 82945 | 2 | 3.686 | 22502.7 |
| 373 | 2025-03-29 03:09:02 | primrose | 1 | 82945 | 2 | 6.936 | 11958.6 |
| 372 | 2025-03-21 02:13:14 | primrose | 1 | 82945 | 2 | 5.106 | 16244.6 |
| 371 | 2025-03-20 10:43:23 | primrose | 1 | 82945 | 2 | 7.903 | 10495.4 |
| 370 | 2025-03-15 11:31:35 | primrose | 4 | 161609 | 562 | 75.790 | 2132.3 |
| 369 | 2025-03-15 10:13:52 | primrose | 4 | 161609 | 562 | 51.736 | 3123.7 |
| 368 | 2025-03-11 12:44:34 | primrose | 1 | 82945 | 2 | 3.500 | 23698.6 |
| 367 | 2025-03-05 20:21:36 | primrose | 1 | 82945 | 2 | 8.250 | 10053.9 |
| 366 | 2025-03-03 02:18:46 | primrose | 1 | 82945 | 2 | 4.140 | 20035.0 |
| 365 | 2025-03-03 00:10:35 | primrose | 3 | 146162 | 64 | 25.080 | 5827.8 |
| 364 | 2025-02-28 16:13:19 | primrose | 1 | 82945 | 2 | 7.783 | 10657.2 |
| 363 | 2025-02-28 07:08:10 | primrose | 3 | 146162 | 64 | 53.066 | 2754.3 |
| 362 | 2025-02-26 20:21:29 | primrose | 3 | 146162 | 64 | 31.063 | 4705.3 |
| 361 | 2025-02-26 06:26:32 | primrose | 3 | 146162 | 64 | 114.160 | 1280.3 |
| 360 | 2025-02-26 03:39:24 | primrose | 3 | 146162 | 64 | 41.566 | 3516.4 |
| 359 | 2025-02-19 06:13:34 | primrose | 4 | 161609 | 562 | 60.320 | 2679.2 |
| 358 | 2025-02-18 12:05:03 | primrose | 4 | 161609 | 562 | 64.676 | 2498.7 |
| 357 | 2025-02-18 09:52:22 | primrose | 4 | 161609 | 562 | 35.816 | 4512.2 |
| 356 | 2025-02-18 06:23:09 | primrose | 4 | 161609 | 562 | 51.346 | 3147.5 |