History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truffles"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 439 | 2025-10-25 16:20:31 | truffles | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 438 | 2025-10-22 02:11:31 | truffles | 1 | 82945 | 5 | 6.843 | 12121.1 |
| 437 | 2025-10-18 16:28:14 | truffles | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 436 | 2025-10-12 20:04:22 | truffles | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 435 | 2025-09-29 01:09:23 | truffles | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 434 | 2025-09-26 10:39:27 | truffles | 1 | 82945 | 5 | 1.580 | 52496.8 |
| 433 | 2025-09-23 17:31:21 | truffles | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 432 | 2025-09-23 06:56:54 | truffles | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 431 | 2025-09-23 06:56:44 | truffles | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 430 | 2025-09-17 15:07:45 | truffles | 2 | 121059 | 22 | 3.983 | 30393.9 |
| 429 | 2025-09-12 00:38:49 | truffles | 3 | 146162 | 160 | 7.326 | 19951.1 |
| 428 | 2025-09-10 07:32:04 | truffles | 2 | 121059 | 22 | 3.593 | 33693.0 |
| 427 | 2025-09-08 09:13:53 | truffles | 1 | 82945 | 5 | 1.466 | 56579.1 |
| 426 | 2025-09-04 08:31:16 | truffles | 2 | 121059 | 22 | 3.266 | 37066.4 |
| 425 | 2025-09-04 07:48:20 | truffles | 1 | 82945 | 5 | 1.300 | 63803.8 |
| 424 | 2025-09-04 07:29:23 | truffles | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 423 | 2025-08-28 03:48:22 | truffles | 1 | 82945 | 5 | 1.610 | 51518.6 |
| 422 | 2025-08-28 00:43:15 | truffles | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 421 | 2025-08-27 10:09:20 | truffles | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 420 | 2025-08-24 08:55:13 | truffles | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 419 | 2025-08-17 07:33:16 | truffles | 3 | 146162 | 160 | 31.656 | 4617.2 |
| 418 | 2025-08-16 05:24:31 | truffles | 3 | 146162 | 160 | 7.486 | 19524.7 |
| 417 | 2025-08-15 19:52:13 | truffles | 1 | 82945 | 5 | 2.623 | 31622.2 |
| 416 | 2025-08-04 11:01:42 | truffles | 3 | 146162 | 160 | 25.733 | 5679.9 |
| 415 | 2025-08-03 02:16:22 | truffles | 3 | 146162 | 160 | 35.876 | 4074.1 |
| 414 | 2025-08-03 02:16:22 | truffles | 3 | 146162 | 160 | 22.623 | 6460.8 |
| 413 | 2025-08-01 11:10:14 | truffles | 1 | 82945 | 5 | 4.173 | 19876.6 |
| 412 | 2025-08-01 07:23:15 | truffles | 1 | 82945 | 5 | 4.453 | 18626.8 |
| 411 | 2025-07-30 02:48:53 | truffles | 3 | 146162 | 160 | 31.596 | 4626.0 |
| 410 | 2025-07-25 03:46:23 | truffles | 1 | 82945 | 5 | 3.173 | 26140.9 |
| 409 | 2025-07-25 01:39:37 | truffles | 1 | 82945 | 5 | 5.156 | 16087.1 |
| 408 | 2025-07-24 03:54:20 | truffles | 1 | 82945 | 5 | 5.063 | 16382.6 |
| 407 | 2025-07-23 15:04:14 | truffles | 1 | 82945 | 5 | 5.373 | 15437.4 |
| 406 | 2025-07-23 04:39:10 | truffles | 1 | 82945 | 5 | 3.373 | 24590.9 |
| 405 | 2025-07-22 20:44:29 | truffles | 1 | 82945 | 5 | 4.393 | 18881.2 |
| 404 | 2025-07-22 17:23:18 | truffles | 1 | 82945 | 5 | 6.313 | 13138.8 |
| 403 | 2025-07-14 11:47:12 | truffles | 2 | 121059 | 22 | 18.733 | 6462.3 |
| 402 | 2025-07-12 21:12:47 | truffles | 2 | 121059 | 22 | 3.876 | 31233.0 |
| 401 | 2025-07-07 22:10:34 | truffles | 1 | 82945 | 5 | 3.750 | 22118.7 |
| 400 | 2025-07-07 10:30:54 | truffles | 1 | 82945 | 5 | 3.486 | 23793.7 |
| 399 | 2025-07-05 16:40:12 | truffles | 1 | 82945 | 5 | 9.143 | 9072.0 |
| 398 | 2025-07-02 12:57:30 | truffles | 1 | 82945 | 5 | 4.296 | 19307.5 |
| 397 | 2025-06-30 02:11:01 | truffles | 3 | 146162 | 160 | 39.410 | 3708.8 |
| 396 | 2025-06-27 00:33:05 | truffles | 3 | 146162 | 160 | 30.063 | 4861.9 |
| 395 | 2025-06-22 10:29:14 | truffles | 1 | 82945 | 5 | 7.766 | 10680.5 |
| 394 | 2025-06-21 22:25:05 | truffles | 3 | 146162 | 160 | 33.456 | 4368.8 |
| 393 | 2025-06-21 05:23:33 | truffles | 3 | 146162 | 160 | 6.140 | 23804.9 |
| 392 | 2025-06-20 16:30:44 | truffles | 3 | 146162 | 160 | 54.566 | 2678.6 |
| 391 | 2025-06-18 01:25:38 | truffles | 1 | 82945 | 5 | 5.046 | 16437.8 |
| 390 | 2025-06-15 21:56:26 | truffles | 3 | 146162 | 160 | 44.766 | 3265.0 |
| 389 | 2025-06-15 20:57:36 | truffles | 3 | 146162 | 160 | 38.783 | 3768.7 |
| 388 | 2025-06-14 08:44:22 | truffles | 3 | 146162 | 160 | 51.796 | 2821.9 |
| 387 | 2025-06-14 07:06:18 | truffles | 3 | 146162 | 160 | 24.250 | 6027.3 |
| 386 | 2025-06-13 18:33:37 | truffles | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 385 | 2025-06-12 01:29:31 | truffles | 3 | 146162 | 160 | 44.593 | 3277.7 |
| 384 | 2025-06-10 10:03:00 | truffles | 1 | 82945 | 5 | 7.440 | 11148.5 |
| 383 | 2025-06-08 19:48:55 | truffles | 1 | 82945 | 5 | 7.593 | 10923.9 |
| 382 | 2025-06-07 22:08:00 | truffles | 1 | 82945 | 5 | 3.673 | 22582.4 |
| 381 | 2025-06-07 14:50:47 | truffles | 1 | 82945 | 5 | 3.296 | 25165.4 |
| 380 | 2025-06-06 03:02:08 | truffles | 1 | 82945 | 5 | 4.050 | 20480.2 |
| 379 | 2025-06-04 16:39:31 | truffles | 1 | 82945 | 5 | 6.423 | 12913.7 |
| 378 | 2025-06-01 09:12:31 | truffles | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 377 | 2025-05-27 17:18:12 | truffles | 3 | 146162 | 160 | 8.266 | 17682.3 |
| 376 | 2025-05-22 10:33:05 | truffles | 1 | 82945 | 5 | 3.236 | 25632.0 |
| 375 | 2025-05-18 00:40:59 | truffles | 3 | 146162 | 160 | 19.500 | 7495.5 |
| 374 | 2025-05-15 22:13:35 | truffles | 3 | 146162 | 160 | 42.300 | 3455.4 |
| 373 | 2025-05-15 06:09:35 | truffles | 3 | 146162 | 160 | 6.983 | 20931.1 |
| 372 | 2025-05-15 00:24:59 | truffles | 3 | 146162 | 160 | 31.266 | 4674.8 |
| 371 | 2025-05-14 03:46:38 | truffles | 1 | 82945 | 5 | 7.426 | 11169.5 |
| 370 | 2025-05-13 20:42:53 | truffles | 3 | 146162 | 160 | 34.910 | 4186.8 |
| 369 | 2025-05-13 10:06:49 | truffles | 3 | 146162 | 160 | 7.063 | 20694.0 |
| 368 | 2025-05-05 20:58:43 | truffles | 2 | 121059 | 22 | 17.283 | 7004.5 |
| 367 | 2025-05-04 17:08:28 | truffles | 1 | 82945 | 5 | 7.483 | 11084.5 |
| 366 | 2025-05-04 01:11:52 | truffles | 1 | 82945 | 5 | 6.123 | 13546.5 |
| 365 | 2025-05-02 12:22:50 | truffles | 1 | 82945 | 5 | 4.110 | 20181.3 |
| 364 | 2025-04-12 03:57:08 | truffles | 1 | 82945 | 5 | 6.906 | 12010.6 |
| 363 | 2025-04-11 07:50:23 | truffles | 3 | 146162 | 160 | 26.953 | 5422.8 |
| 362 | 2025-04-09 06:18:46 | truffles | 3 | 146162 | 160 | 30.220 | 4836.6 |
| 361 | 2025-04-07 21:49:45 | truffles | 3 | 146162 | 160 | 24.686 | 5920.8 |
| 360 | 2025-04-04 16:04:30 | truffles | 1 | 82945 | 5 | 3.296 | 25165.4 |
| 359 | 2025-03-31 14:22:51 | truffles | 1 | 82945 | 5 | 9.783 | 8478.5 |
| 358 | 2025-03-29 02:39:56 | truffles | 1 | 82945 | 5 | 5.593 | 14830.1 |
| 357 | 2025-03-23 20:29:22 | truffles | 3 | 146162 | 160 | 32.423 | 4508.0 |
| 356 | 2025-03-20 11:54:55 | truffles | 1 | 82945 | 5 | 7.373 | 11249.8 |
| 355 | 2025-03-12 21:16:56 | truffles | 2 | 121059 | 22 | 11.156 | 10851.5 |
| 354 | 2025-03-12 19:41:59 | truffles | 1 | 82945 | 5 | 6.890 | 12038.5 |
| 353 | 2025-03-12 18:37:07 | truffles | 2 | 121059 | 22 | 18.186 | 6656.7 |
| 352 | 2025-03-12 18:27:24 | truffles | 1 | 82945 | 5 | 1.843 | 45005.4 |
| 351 | 2025-03-05 09:56:35 | truffles | 3 | 146162 | 160 | 36.986 | 3951.8 |
| 350 | 2025-03-05 01:32:26 | truffles | 3 | 146162 | 160 | 36.190 | 4038.7 |
| 349 | 2025-03-03 04:54:01 | truffles | 1 | 82945 | 5 | 6.826 | 12151.3 |
| 348 | 2025-03-01 17:17:58 | truffles | 3 | 146162 | 160 | 46.770 | 3125.1 |
| 347 | 2025-03-01 17:15:55 | truffles | 1 | 82945 | 5 | 6.030 | 13755.4 |
| 346 | 2025-03-01 12:28:59 | truffles | 3 | 146162 | 160 | 36.296 | 4026.9 |
| 345 | 2025-02-28 23:20:51 | truffles | 3 | 146162 | 160 | 32.710 | 4468.4 |
| 344 | 2025-02-27 21:12:49 | truffles | 1 | 82945 | 5 | 4.063 | 20414.7 |
| 343 | 2025-02-26 17:32:08 | truffles | 1 | 82945 | 5 | 3.376 | 24569.0 |
| 342 | 2025-02-01 15:35:08 | truffles | 3 | 146162 | 160 | 42.610 | 3430.2 |
| 341 | 2025-01-28 07:42:09 | truffles | 3 | 146162 | 160 | 22.003 | 6642.8 |
| 340 | 2025-01-27 00:44:16 | truffles | 1 | 82945 | 5 | 9.780 | 8481.1 |