History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pianos"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 535 | 2024-05-03 22:07:28 | pianos | 1 | 48755 | 3 | 1.936 | 25183.4 |
| 534 | 2024-04-27 20:39:03 | pianos | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 533 | 2024-04-25 14:38:44 | pianos | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 532 | 2024-04-22 10:17:36 | pianos | 1 | 48755 | 3 | 1.063 | 45865.5 |
| 531 | 2024-04-10 22:05:36 | pianos | 3 | 112716 | 942 | 11.656 | 9670.2 |
| 530 | 2024-04-09 18:44:09 | pianos | 3 | 112716 | 942 | 19.733 | 5712.1 |
| 529 | 2024-04-08 21:59:47 | pianos | 3 | 112716 | 942 | 6.843 | 16471.7 |
| 528 | 2024-04-08 21:59:47 | pianos | 2 | 82551 | 70 | 6.983 | 11821.7 |
| 527 | 2024-04-07 02:05:34 | pianos | 1 | 48755 | 3 | 2.250 | 21668.9 |
| 526 | 2024-04-03 04:45:54 | pianos | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 525 | 2024-03-31 11:10:12 | pianos | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 524 | 2024-03-31 06:27:06 | pianos | 1 | 48755 | 3 | 0.986 | 49447.3 |
| 523 | 2024-03-05 18:06:55 | pianos | 3 | 112716 | 942 | 15.640 | 7206.9 |
| 522 | 2024-03-05 09:06:42 | pianos | 3 | 112716 | 942 | 6.796 | 16585.6 |
| 521 | 2024-03-04 16:42:33 | pianos | 3 | 112716 | 942 | 15.033 | 7497.9 |
| 520 | 2024-03-04 16:37:57 | pianos | 3 | 112716 | 942 | 13.813 | 8160.1 |
| 519 | 2024-03-04 12:27:39 | pianos | 2 | 82551 | 70 | 2.780 | 29694.6 |
| 518 | 2024-03-04 12:27:38 | pianos | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 517 | 2024-03-04 12:26:59 | pianos | 3 | 112716 | 942 | 6.050 | 18630.7 |
| 516 | 2024-03-04 02:30:50 | pianos | 2 | 82551 | 70 | 2.483 | 33246.5 |
| 515 | 2024-03-04 02:29:28 | pianos | 3 | 112716 | 942 | 6.093 | 18499.3 |
| 514 | 2024-03-04 02:18:05 | pianos | 3 | 112716 | 942 | 5.703 | 19764.3 |
| 513 | 2024-03-03 23:48:36 | pianos | 1 | 48755 | 3 | 1.030 | 47335.0 |
| 512 | 2024-03-01 14:59:15 | pianos | 1 | 48755 | 3 | 0.956 | 50999.0 |
| 511 | 2024-01-30 10:02:42 | pianos | 2 | 82551 | 70 | 2.656 | 31080.9 |
| 510 | 2024-01-30 10:01:50 | pianos | 3 | 112716 | 942 | 7.500 | 15028.8 |
| 509 | 2024-01-28 22:01:39 | pianos | 3 | 112716 | 942 | 5.596 | 20142.2 |
| 508 | 2024-01-28 14:09:44 | pianos | 3 | 112716 | 942 | 5.420 | 20796.3 |
| 507 | 2024-01-27 23:15:27 | pianos | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 506 | 2024-01-19 08:47:24 | pianos | 3 | 112716 | 942 | 5.330 | 21147.5 |
| 505 | 2024-01-17 08:00:10 | pianos | 3 | 112716 | 942 | 5.093 | 22131.6 |
| 504 | 2024-01-17 08:00:12 | pianos | 2 | 82551 | 70 | 2.406 | 34310.5 |
| 503 | 2024-01-12 08:34:44 | pianos | 3 | 112716 | 942 | 11.813 | 9541.7 |
| 502 | 2024-01-12 08:34:46 | pianos | 2 | 82551 | 70 | 2.610 | 31628.7 |
| 501 | 2024-01-09 15:24:07 | pianos | 3 | 112716 | 942 | 4.923 | 22895.8 |
| 500 | 2024-01-03 04:26:38 | pianos | 3 | 112716 | 942 | 7.000 | 16102.3 |
| 499 | 2024-01-03 04:26:40 | pianos | 2 | 82551 | 70 | 2.690 | 30688.1 |
| 498 | 2023-12-30 01:12:34 | pianos | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 497 | 2023-12-27 08:05:06 | pianos | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 496 | 2023-12-20 10:00:29 | pianos | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 495 | 2023-11-21 07:21:15 | pianos | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 494 | 2023-11-17 05:40:11 | pianos | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 493 | 2023-11-16 20:45:43 | pianos | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 492 | 2023-11-14 00:53:13 | pianos | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 491 | 2023-11-02 07:40:39 | pianos | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 490 | 2023-10-29 23:25:43 | pianos | 1 | 48755 | 3 | 1.626 | 29984.6 |
| 489 | 2023-10-29 22:29:46 | pianos | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 488 | 2023-10-20 01:49:56 | pianos | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 487 | 2023-10-19 01:53:22 | pianos | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 486 | 2023-10-18 02:46:46 | pianos | 3 | 112716 | 942 | 5.626 | 20034.8 |
| 485 | 2023-10-13 23:04:40 | pianos | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 484 | 2023-10-05 17:46:51 | pianos | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 483 | 2023-09-29 18:15:00 | pianos | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 482 | 2023-09-26 21:24:29 | pianos | 3 | 112716 | 942 | 5.063 | 22262.7 |
| 481 | 2023-09-26 21:24:30 | pianos | 2 | 82551 | 70 | 2.466 | 33475.7 |
| 480 | 2023-09-26 12:40:42 | pianos | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 479 | 2023-09-12 18:43:04 | pianos | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 478 | 2023-08-15 02:13:02 | pianos | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 477 | 2023-07-28 16:18:15 | pianos | 3 | 112716 | 942 | 11.330 | 9948.5 |
| 476 | 2023-06-30 06:25:38 | pianos | 3 | 112716 | 942 | 4.733 | 23814.9 |
| 475 | 2023-06-15 23:23:23 | pianos | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 474 | 2023-05-15 11:25:17 | pianos | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 473 | 2023-04-08 23:40:01 | pianos | 3 | 112716 | 942 | 5.576 | 20214.5 |
| 472 | 2023-03-13 22:51:13 | pianos | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 471 | 2023-02-28 03:06:50 | pianos | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 470 | 2023-01-12 00:56:32 | pianos | 3 | 112716 | 942 | 5.016 | 22471.3 |
| 469 | 2023-01-05 00:20:15 | pianos | 3 | 112716 | 942 | 5.640 | 19985.1 |
| 468 | 2023-01-03 00:03:44 | pianos | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 467 | 2022-12-10 10:48:01 | pianos | 3 | 112716 | 942 | 5.486 | 20546.1 |
| 466 | 2022-11-27 20:10:02 | pianos | 3 | 112716 | 942 | 4.690 | 24033.3 |
| 465 | 2022-11-23 02:55:04 | pianos | 3 | 112716 | 942 | 5.033 | 22395.4 |
| 464 | 2022-11-16 12:59:22 | pianos | 3 | 112716 | 942 | 5.000 | 22543.2 |
| 463 | 2022-11-06 11:21:33 | pianos | 3 | 112716 | 942 | 5.436 | 20735.1 |
| 462 | 2022-11-04 08:22:25 | pianos | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 461 | 2022-10-16 17:24:59 | pianos | 3 | 112716 | 942 | 4.656 | 24208.8 |
| 460 | 2022-09-26 04:14:34 | pianos | 3 | 112716 | 942 | 4.656 | 24208.8 |
| 459 | 2022-09-20 23:45:37 | pianos | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 458 | 2022-09-13 20:03:57 | pianos | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 457 | 2022-09-07 05:31:10 | pianos | 3 | 112716 | 942 | 4.720 | 23880.5 |
| 456 | 2022-09-05 02:16:28 | pianos | 3 | 112716 | 942 | 4.796 | 23502.1 |
| 455 | 2022-07-18 09:30:55 | pianos | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 454 | 2022-06-14 08:26:27 | pianos | 3 | 112716 | 942 | 5.153 | 21873.9 |
| 453 | 2022-05-01 23:47:06 | pianos | 3 | 112716 | 942 | 5.220 | 21593.1 |
| 452 | 2022-04-30 17:55:50 | pianos | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 451 | 2022-04-04 07:47:02 | pianos | 3 | 112716 | 942 | 4.733 | 23814.9 |
| 450 | 2022-03-31 06:54:14 | pianos | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 449 | 2022-03-30 16:21:03 | pianos | 3 | 112716 | 942 | 5.970 | 18880.4 |
| 448 | 2022-02-12 13:14:04 | pianos | 3 | 112716 | 942 | 5.126 | 21989.1 |
| 447 | 2022-01-26 06:18:01 | pianos | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 446 | 2022-01-14 11:21:23 | pianos | 3 | 112716 | 942 | 9.986 | 11287.4 |
| 445 | 2021-12-23 22:46:33 | pianos | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 444 | 2021-12-23 12:19:31 | pianos | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 443 | 2021-12-23 04:27:43 | pianos | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 442 | 2021-12-22 17:38:41 | pianos | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 441 | 2021-12-22 10:09:10 | pianos | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 440 | 2021-12-21 23:03:37 | pianos | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 439 | 2021-12-21 14:17:54 | pianos | 1 | 48755 | 3 | 1.220 | 39963.1 |
| 438 | 2021-12-21 01:03:08 | pianos | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 437 | 2021-12-20 17:31:24 | pianos | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 436 | 2021-12-20 06:44:56 | pianos | 1 | 48755 | 3 | 1.733 | 28133.3 |