History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pianist"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 447 | 2025-11-28 14:10:01 | pianist | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 446 | 2025-11-22 05:19:18 | pianist | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 445 | 2025-11-20 23:45:00 | pianist | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 444 | 2025-11-14 22:58:54 | pianist | 1 | 69583 | 3 | 1.420 | 49002.1 |
| 443 | 2025-11-09 01:39:35 | pianist | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 442 | 2025-11-03 08:20:17 | pianist | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 441 | 2025-11-02 07:42:47 | pianist | 3 | 134027 | 269 | 8.610 | 15566.4 |
| 440 | 2025-10-31 05:26:22 | pianist | 3 | 134027 | 269 | 7.143 | 18763.4 |
| 439 | 2025-10-31 02:51:54 | pianist | 3 | 134027 | 269 | 7.063 | 18975.9 |
| 438 | 2025-10-31 01:27:28 | pianist | 3 | 134027 | 269 | 6.143 | 21817.8 |
| 437 | 2025-10-29 13:00:25 | pianist | 3 | 134027 | 269 | 11.330 | 11829.4 |
| 436 | 2025-10-24 09:53:22 | pianist | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 435 | 2025-10-16 05:11:18 | pianist | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 434 | 2025-10-11 01:44:28 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 433 | 2025-10-09 06:40:18 | pianist | 2 | 107671 | 19 | 3.390 | 31761.4 |
| 432 | 2025-10-06 12:56:31 | pianist | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 431 | 2025-10-05 02:30:35 | pianist | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 430 | 2025-09-30 14:59:40 | pianist | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 429 | 2025-09-27 08:53:18 | pianist | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 428 | 2025-09-26 23:27:41 | pianist | 3 | 134027 | 269 | 6.253 | 21434.0 |
| 427 | 2025-09-26 06:20:58 | pianist | 3 | 134027 | 269 | 7.003 | 19138.5 |
| 426 | 2025-09-21 18:42:08 | pianist | 3 | 134027 | 269 | 12.610 | 10628.6 |
| 425 | 2025-09-21 09:28:28 | pianist | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 424 | 2025-09-17 00:35:33 | pianist | 3 | 134027 | 269 | 9.500 | 14108.1 |
| 423 | 2025-09-15 23:59:45 | pianist | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 422 | 2025-09-10 04:49:12 | pianist | 3 | 134027 | 269 | 7.470 | 17942.0 |
| 421 | 2025-09-07 15:32:43 | pianist | 1 | 69583 | 3 | 2.220 | 31343.7 |
| 420 | 2025-09-06 03:24:19 | pianist | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 419 | 2025-09-02 17:47:47 | pianist | 3 | 134027 | 269 | 5.966 | 22465.1 |
| 418 | 2025-09-01 15:51:42 | pianist | 3 | 134027 | 269 | 6.656 | 20136.3 |
| 417 | 2025-08-31 22:42:50 | pianist | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 416 | 2025-08-27 23:27:20 | pianist | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 415 | 2025-08-26 15:30:15 | pianist | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 414 | 2025-08-21 13:14:01 | pianist | 1 | 69583 | 3 | 2.156 | 32274.1 |
| 413 | 2025-08-19 09:22:40 | pianist | 2 | 107671 | 19 | 10.610 | 10148.1 |
| 412 | 2025-08-19 04:33:53 | pianist | 3 | 134027 | 269 | 30.563 | 4385.3 |
| 411 | 2025-08-17 12:00:47 | pianist | 1 | 69583 | 3 | 2.610 | 26660.2 |
| 410 | 2025-08-17 07:50:22 | pianist | 1 | 69583 | 3 | 2.640 | 26357.2 |
| 409 | 2025-08-09 14:57:13 | pianist | 1 | 69583 | 3 | 5.966 | 11663.3 |
| 408 | 2025-08-09 08:06:54 | pianist | 2 | 107671 | 19 | 14.516 | 7417.4 |
| 407 | 2025-08-03 13:38:58 | pianist | 1 | 69583 | 3 | 6.050 | 11501.3 |
| 406 | 2025-07-31 22:00:33 | pianist | 1 | 69583 | 3 | 5.126 | 13574.5 |
| 405 | 2025-07-31 19:02:37 | pianist | 3 | 134027 | 269 | 37.953 | 3531.4 |
| 404 | 2025-07-29 14:00:25 | pianist | 3 | 134027 | 269 | 37.470 | 3576.9 |
| 403 | 2025-07-26 06:21:00 | pianist | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 402 | 2025-07-26 02:16:36 | pianist | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 401 | 2025-07-18 23:44:27 | pianist | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 400 | 2025-07-18 14:28:33 | pianist | 2 | 107671 | 19 | 16.783 | 6415.5 |
| 399 | 2025-07-15 09:09:47 | pianist | 3 | 134027 | 269 | 31.516 | 4252.7 |
| 398 | 2025-07-15 07:22:05 | pianist | 2 | 107671 | 19 | 17.796 | 6050.3 |
| 397 | 2025-07-14 12:32:13 | pianist | 3 | 134027 | 269 | 52.940 | 2531.7 |
| 396 | 2025-07-13 21:30:12 | pianist | 1 | 69583 | 3 | 5.610 | 12403.4 |
| 395 | 2025-07-13 13:58:52 | pianist | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 394 | 2025-07-12 21:51:02 | pianist | 3 | 134027 | 269 | 8.720 | 15370.1 |
| 393 | 2025-07-12 17:05:02 | pianist | 1 | 69583 | 3 | 1.483 | 46920.4 |
| 392 | 2025-06-27 11:55:07 | pianist | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 391 | 2025-06-26 15:47:52 | pianist | 1 | 69583 | 3 | 5.466 | 12730.2 |
| 390 | 2025-06-25 05:05:44 | pianist | 1 | 69583 | 3 | 6.330 | 10992.6 |
| 389 | 2025-06-24 08:09:59 | pianist | 1 | 69583 | 3 | 5.826 | 11943.5 |
| 388 | 2025-06-23 15:52:33 | pianist | 1 | 69583 | 3 | 4.596 | 15139.9 |
| 387 | 2025-06-22 17:25:13 | pianist | 1 | 69583 | 3 | 5.483 | 12690.7 |
| 386 | 2025-06-20 05:59:03 | pianist | 3 | 134027 | 269 | 29.160 | 4596.3 |
| 385 | 2025-06-18 19:37:34 | pianist | 3 | 134027 | 269 | 37.796 | 3546.1 |
| 384 | 2025-06-16 12:03:19 | pianist | 1 | 69583 | 3 | 4.300 | 16182.1 |
| 383 | 2025-06-14 13:04:08 | pianist | 1 | 69583 | 3 | 5.626 | 12368.1 |
| 382 | 2025-06-12 12:36:58 | pianist | 1 | 69583 | 3 | 6.203 | 11217.6 |
| 381 | 2025-06-12 08:42:52 | pianist | 1 | 69583 | 3 | 6.313 | 11022.2 |
| 380 | 2025-06-11 13:31:52 | pianist | 1 | 69583 | 3 | 6.076 | 11452.1 |
| 379 | 2025-06-10 18:16:08 | pianist | 2 | 107671 | 19 | 16.123 | 6678.1 |
| 378 | 2025-06-10 10:22:40 | pianist | 1 | 69583 | 3 | 5.360 | 12981.9 |
| 377 | 2025-06-04 07:16:33 | pianist | 1 | 69583 | 3 | 5.720 | 12164.9 |
| 376 | 2025-05-31 22:48:24 | pianist | 1 | 69583 | 3 | 5.766 | 12067.8 |
| 375 | 2025-05-31 01:37:34 | pianist | 1 | 69583 | 3 | 3.500 | 19880.9 |
| 374 | 2025-05-25 21:48:09 | pianist | 1 | 69583 | 3 | 3.280 | 21214.3 |
| 373 | 2025-05-23 22:29:03 | pianist | 2 | 107671 | 19 | 7.530 | 14298.9 |
| 372 | 2025-05-23 10:34:31 | pianist | 1 | 69583 | 3 | 4.060 | 17138.7 |
| 371 | 2025-05-21 18:40:54 | pianist | 2 | 107671 | 19 | 5.690 | 18922.8 |
| 370 | 2025-05-18 07:33:37 | pianist | 3 | 134027 | 269 | 30.766 | 4356.3 |
| 369 | 2025-05-18 04:18:45 | pianist | 3 | 134027 | 269 | 44.750 | 2995.0 |
| 368 | 2025-05-17 19:41:18 | pianist | 3 | 134027 | 269 | 10.220 | 13114.2 |
| 367 | 2025-05-16 14:16:25 | pianist | 3 | 134027 | 269 | 53.050 | 2526.4 |
| 366 | 2025-05-16 11:57:18 | pianist | 3 | 134027 | 269 | 27.033 | 4957.9 |
| 365 | 2025-05-16 01:17:22 | pianist | 3 | 134027 | 269 | 46.143 | 2904.6 |
| 364 | 2025-05-15 10:48:30 | pianist | 3 | 134027 | 269 | 26.050 | 5145.0 |
| 363 | 2025-05-11 10:04:11 | pianist | 1 | 69583 | 3 | 4.923 | 14134.3 |
| 362 | 2025-05-11 03:50:21 | pianist | 1 | 69583 | 3 | 4.546 | 15306.4 |
| 361 | 2025-05-08 12:24:22 | pianist | 1 | 69583 | 3 | 4.736 | 14692.4 |
| 360 | 2025-05-04 12:19:06 | pianist | 1 | 69583 | 3 | 4.076 | 17071.4 |
| 359 | 2025-05-04 01:22:19 | pianist | 1 | 69583 | 3 | 5.673 | 12265.6 |
| 358 | 2025-05-03 00:21:44 | pianist | 2 | 107671 | 19 | 14.966 | 7194.4 |
| 357 | 2025-04-30 17:39:40 | pianist | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 356 | 2025-04-27 02:15:38 | pianist | 2 | 107671 | 19 | 3.453 | 31181.9 |
| 355 | 2025-04-23 08:54:37 | pianist | 2 | 107671 | 19 | 17.330 | 6213.0 |
| 354 | 2025-04-21 16:52:29 | pianist | 1 | 69583 | 3 | 5.813 | 11970.2 |
| 353 | 2025-04-19 09:07:30 | pianist | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 352 | 2025-04-11 14:16:55 | pianist | 3 | 134027 | 269 | 42.330 | 3166.2 |
| 351 | 2025-04-08 19:34:42 | pianist | 3 | 134027 | 269 | 34.750 | 3856.9 |
| 350 | 2025-04-06 09:01:26 | pianist | 2 | 107671 | 19 | 10.956 | 9827.6 |
| 349 | 2025-04-06 03:59:52 | pianist | 3 | 134027 | 269 | 36.766 | 3645.4 |
| 348 | 2025-03-23 03:35:37 | pianist | 1 | 69583 | 3 | 3.500 | 19880.9 |