History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nappies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 530 | 2024-04-28 10:32:12 | nappies | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 529 | 2024-04-22 15:14:01 | nappies | 1 | 69583 | 6 | 1.610 | 43219.3 |
| 528 | 2024-04-04 05:03:35 | nappies | 2 | 107671 | 53 | 3.300 | 32627.6 |
| 527 | 2024-02-23 05:18:35 | nappies | 1 | 69583 | 6 | 1.106 | 62914.1 |
| 526 | 2024-02-08 06:31:54 | nappies | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 525 | 2024-01-22 06:36:47 | nappies | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 524 | 2024-01-09 00:08:55 | nappies | 3 | 134027 | 491 | 6.420 | 20876.5 |
| 523 | 2024-01-09 00:08:49 | nappies | 2 | 107671 | 53 | 3.423 | 31455.2 |
| 522 | 2024-01-03 02:41:21 | nappies | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 521 | 2023-12-28 02:36:05 | nappies | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 520 | 2023-12-11 16:44:52 | nappies | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 519 | 2023-12-07 08:23:01 | nappies | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 518 | 2023-12-07 08:22:59 | nappies | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 517 | 2023-12-07 05:40:54 | nappies | 2 | 107671 | 53 | 2.826 | 38100.1 |
| 516 | 2023-11-23 01:07:40 | nappies | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 515 | 2023-11-19 12:04:38 | nappies | 1 | 69583 | 6 | 2.093 | 33245.6 |
| 514 | 2023-11-11 04:44:59 | nappies | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 513 | 2023-10-31 21:00:33 | nappies | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 512 | 2023-10-17 16:07:25 | nappies | 1 | 69583 | 6 | 1.280 | 54361.7 |
| 511 | 2023-10-16 15:19:24 | nappies | 1 | 69583 | 6 | 1.096 | 63488.1 |
| 510 | 2023-10-15 13:39:36 | nappies | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 509 | 2023-10-09 10:39:05 | nappies | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 508 | 2023-10-08 23:42:54 | nappies | 1 | 69583 | 6 | 1.060 | 65644.3 |
| 507 | 2023-09-29 11:05:53 | nappies | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 506 | 2023-09-04 10:19:31 | nappies | 2 | 107671 | 53 | 2.796 | 38508.9 |
| 505 | 2023-08-22 17:27:47 | nappies | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 504 | 2023-08-12 14:46:40 | nappies | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 503 | 2023-06-30 17:33:01 | nappies | 3 | 134027 | 491 | 5.750 | 23309.0 |
| 502 | 2023-06-22 09:42:21 | nappies | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 501 | 2023-05-08 20:11:50 | nappies | 1 | 69583 | 6 | 1.313 | 52995.4 |
| 500 | 2023-03-31 16:07:26 | nappies | 3 | 134027 | 491 | 5.766 | 23244.4 |
| 499 | 2023-03-06 23:23:27 | nappies | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 498 | 2023-01-25 08:54:51 | nappies | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 497 | 2023-01-13 09:51:51 | nappies | 3 | 134027 | 491 | 6.453 | 20769.7 |
| 496 | 2023-01-12 17:17:11 | nappies | 2 | 107671 | 53 | 2.860 | 37647.2 |
| 495 | 2023-01-12 03:01:55 | nappies | 3 | 134027 | 491 | 5.626 | 23822.8 |
| 494 | 2022-12-30 08:51:55 | nappies | 3 | 134027 | 491 | 7.190 | 18640.8 |
| 493 | 2022-12-21 21:14:21 | nappies | 2 | 107671 | 53 | 3.453 | 31181.9 |
| 492 | 2022-12-19 02:15:25 | nappies | 3 | 134027 | 491 | 5.750 | 23309.0 |
| 491 | 2022-12-11 03:57:14 | nappies | 1 | 69583 | 6 | 1.123 | 61961.7 |
| 490 | 2022-11-29 06:20:35 | nappies | 3 | 134027 | 491 | 5.640 | 23763.7 |
| 489 | 2022-11-28 14:03:08 | nappies | 2 | 107671 | 53 | 5.563 | 19354.8 |
| 488 | 2022-11-28 00:20:26 | nappies | 3 | 134027 | 491 | 7.016 | 19103.1 |
| 487 | 2022-11-20 05:32:52 | nappies | 3 | 134027 | 491 | 5.766 | 23244.4 |
| 486 | 2022-11-14 14:18:33 | nappies | 3 | 134027 | 491 | 7.516 | 17832.2 |
| 485 | 2022-11-11 06:13:50 | nappies | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 484 | 2022-11-10 22:07:00 | nappies | 2 | 107671 | 53 | 2.843 | 37872.3 |
| 483 | 2022-11-10 09:55:03 | nappies | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 482 | 2022-11-07 19:32:16 | nappies | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 481 | 2022-11-06 03:08:04 | nappies | 3 | 134027 | 491 | 7.046 | 19021.7 |
| 480 | 2022-11-05 05:07:35 | nappies | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 479 | 2022-10-31 17:55:17 | nappies | 2 | 107671 | 53 | 3.453 | 31181.9 |
| 478 | 2022-10-29 17:52:24 | nappies | 2 | 107671 | 53 | 2.923 | 36835.8 |
| 477 | 2022-10-27 17:09:27 | nappies | 2 | 107671 | 53 | 3.156 | 34116.3 |
| 476 | 2022-10-11 17:51:59 | nappies | 3 | 134027 | 491 | 5.766 | 23244.4 |
| 475 | 2022-10-10 08:45:15 | nappies | 3 | 134027 | 491 | 6.640 | 20184.8 |
| 474 | 2022-09-23 00:01:12 | nappies | 3 | 134027 | 491 | 5.643 | 23751.0 |
| 473 | 2022-09-20 05:47:51 | nappies | 2 | 107671 | 53 | 3.110 | 34620.9 |
| 472 | 2022-09-09 01:28:27 | nappies | 3 | 134027 | 491 | 6.843 | 19586.0 |
| 471 | 2022-09-02 22:34:20 | nappies | 3 | 134027 | 491 | 6.203 | 21606.8 |
| 470 | 2022-08-29 19:54:09 | nappies | 3 | 134027 | 491 | 6.703 | 19995.1 |
| 469 | 2022-08-28 14:53:03 | nappies | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 468 | 2022-08-26 23:16:51 | nappies | 2 | 107671 | 53 | 3.110 | 34620.9 |
| 467 | 2022-08-20 22:35:52 | nappies | 2 | 107671 | 53 | 3.220 | 33438.2 |
| 466 | 2022-07-20 08:43:02 | nappies | 3 | 134027 | 491 | 5.983 | 22401.3 |
| 465 | 2022-07-18 09:41:02 | nappies | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 464 | 2022-07-11 15:43:11 | nappies | 3 | 134027 | 491 | 5.736 | 23365.9 |
| 463 | 2022-07-10 09:16:11 | nappies | 3 | 134027 | 491 | 7.156 | 18729.3 |
| 462 | 2022-06-26 10:23:01 | nappies | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 461 | 2022-06-25 15:51:39 | nappies | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 460 | 2022-06-24 05:42:36 | nappies | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 459 | 2022-06-17 08:17:32 | nappies | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 458 | 2022-06-15 18:30:18 | nappies | 3 | 134027 | 491 | 6.983 | 19193.3 |
| 457 | 2022-06-14 11:35:51 | nappies | 3 | 134027 | 491 | 5.703 | 23501.1 |
| 456 | 2022-06-10 13:57:12 | nappies | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 455 | 2022-06-04 08:18:50 | nappies | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 454 | 2022-06-04 05:56:20 | nappies | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 453 | 2022-05-20 03:20:30 | nappies | 3 | 134027 | 491 | 6.530 | 20524.8 |
| 452 | 2022-05-07 20:06:07 | nappies | 3 | 134027 | 491 | 5.766 | 23244.4 |
| 451 | 2022-05-06 03:33:04 | nappies | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 450 | 2022-05-03 08:53:17 | nappies | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 449 | 2022-05-01 21:51:51 | nappies | 1 | 69583 | 6 | 2.470 | 28171.3 |
| 448 | 2022-04-30 21:51:25 | nappies | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 447 | 2022-04-29 17:56:56 | nappies | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 446 | 2022-04-28 21:56:11 | nappies | 1 | 69583 | 6 | 1.310 | 53116.8 |
| 445 | 2022-04-25 13:18:20 | nappies | 3 | 134027 | 491 | 6.750 | 19855.9 |
| 444 | 2022-04-20 03:20:09 | nappies | 3 | 134027 | 491 | 6.936 | 19323.4 |
| 443 | 2022-03-31 07:01:11 | nappies | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 442 | 2022-03-09 02:05:44 | nappies | 3 | 134027 | 491 | 7.593 | 17651.4 |
| 441 | 2022-03-01 10:47:05 | nappies | 1 | 69583 | 6 | 1.466 | 47464.5 |
| 440 | 2022-02-27 07:02:34 | nappies | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 439 | 2022-01-07 13:25:56 | nappies | 3 | 134027 | 491 | 7.843 | 17088.7 |
| 438 | 2021-12-28 04:46:40 | nappies | 3 | 134027 | 491 | 6.720 | 19944.5 |
| 437 | 2021-12-16 19:06:39 | nappies | 1 | 69583 | 6 | 2.563 | 27149.0 |
| 436 | 2021-12-16 05:59:56 | nappies | 1 | 69583 | 6 | 2.190 | 31773.1 |
| 435 | 2021-12-11 18:07:44 | nappies | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 434 | 2021-12-03 04:36:50 | nappies | 3 | 134027 | 491 | 7.606 | 17621.2 |
| 433 | 2021-11-19 07:14:54 | nappies | 1 | 69583 | 6 | 1.360 | 51164.0 |
| 432 | 2021-10-23 09:47:52 | nappies | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 431 | 2021-09-26 11:35:20 | nappies | 3 | 134027 | 491 | 6.096 | 21986.1 |