History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"itemises"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 542 | 2024-04-28 04:44:46 | itemises | 1 | 82945 | 4 | 1.626 | 51011.7 |
| 541 | 2024-04-15 06:12:20 | itemises | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 540 | 2024-04-13 09:47:04 | itemises | 1 | 82945 | 4 | 1.283 | 64649.3 |
| 539 | 2024-04-09 10:06:10 | itemises | 1 | 82945 | 4 | 1.310 | 63316.8 |
| 538 | 2024-04-08 10:32:26 | itemises | 3 | 146162 | 140 | 20.266 | 7212.2 |
| 537 | 2024-04-07 22:37:33 | itemises | 3 | 146162 | 140 | 12.736 | 11476.3 |
| 536 | 2024-04-06 15:59:05 | itemises | 3 | 146162 | 140 | 15.453 | 9458.5 |
| 535 | 2024-04-05 15:09:19 | itemises | 3 | 146162 | 140 | 9.670 | 15115.0 |
| 534 | 2024-04-05 13:16:32 | itemises | 1 | 82945 | 4 | 4.706 | 17625.4 |
| 533 | 2024-04-05 12:10:28 | itemises | 3 | 146162 | 140 | 20.736 | 7048.7 |
| 532 | 2024-04-05 12:10:31 | itemises | 2 | 121059 | 15 | 10.986 | 11019.4 |
| 531 | 2024-04-05 12:10:13 | itemises | 1 | 82945 | 4 | 3.516 | 23590.7 |
| 530 | 2024-04-05 12:10:04 | itemises | 3 | 146162 | 140 | 8.110 | 18022.4 |
| 529 | 2024-04-05 12:10:06 | itemises | 2 | 121059 | 15 | 4.390 | 27576.1 |
| 528 | 2024-03-30 20:18:28 | itemises | 1 | 82945 | 4 | 2.780 | 29836.3 |
| 527 | 2024-03-10 13:06:36 | itemises | 1 | 82945 | 4 | 1.593 | 52068.4 |
| 526 | 2024-03-05 00:30:10 | itemises | 1 | 82945 | 4 | 1.656 | 50087.6 |
| 525 | 2024-02-29 01:44:52 | itemises | 3 | 146162 | 140 | 6.170 | 23689.1 |
| 524 | 2024-02-28 13:31:24 | itemises | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 523 | 2024-02-28 12:00:07 | itemises | 3 | 146162 | 140 | 10.890 | 13421.7 |
| 522 | 2024-02-28 12:00:06 | itemises | 2 | 121059 | 15 | 6.846 | 17683.2 |
| 521 | 2024-02-10 21:21:10 | itemises | 1 | 82945 | 4 | 2.046 | 40540.1 |
| 520 | 2024-01-18 17:56:49 | itemises | 1 | 82945 | 4 | 1.263 | 65673.0 |
| 519 | 2024-01-06 19:53:11 | itemises | 3 | 146162 | 140 | 7.250 | 20160.3 |
| 518 | 2024-01-06 19:53:09 | itemises | 2 | 121059 | 15 | 3.560 | 34005.3 |
| 517 | 2024-01-03 16:53:47 | itemises | 1 | 82945 | 4 | 2.640 | 31418.6 |
| 516 | 2023-12-31 09:27:05 | itemises | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 515 | 2023-12-23 09:07:40 | itemises | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 514 | 2023-12-14 16:32:17 | itemises | 3 | 146162 | 140 | 6.860 | 21306.4 |
| 513 | 2023-11-24 20:34:21 | itemises | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 512 | 2023-11-19 00:51:02 | itemises | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 511 | 2023-11-14 07:59:03 | itemises | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 510 | 2023-11-08 11:30:38 | itemises | 1 | 82945 | 4 | 1.216 | 68211.3 |
| 509 | 2023-11-05 07:12:18 | itemises | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 508 | 2023-10-21 01:18:15 | itemises | 1 | 82945 | 4 | 1.236 | 67107.6 |
| 507 | 2023-10-19 03:50:42 | itemises | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 506 | 2023-09-28 23:20:00 | itemises | 1 | 82945 | 4 | 3.016 | 27501.7 |
| 505 | 2023-09-27 10:02:38 | itemises | 1 | 82945 | 4 | 1.283 | 64649.3 |
| 504 | 2023-09-14 02:48:45 | itemises | 3 | 146162 | 140 | 7.080 | 20644.4 |
| 503 | 2023-09-08 06:56:02 | itemises | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 502 | 2023-08-17 15:46:53 | itemises | 1 | 82945 | 4 | 1.216 | 68211.3 |
| 501 | 2023-07-20 16:29:11 | itemises | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 500 | 2023-06-23 04:49:47 | itemises | 3 | 146162 | 140 | 6.563 | 22270.6 |
| 499 | 2023-06-13 07:54:13 | itemises | 3 | 146162 | 140 | 6.173 | 23677.6 |
| 498 | 2023-05-22 06:58:53 | itemises | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 497 | 2023-05-20 05:08:04 | itemises | 1 | 82945 | 4 | 1.083 | 76588.2 |
| 496 | 2023-05-18 21:34:11 | itemises | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 495 | 2023-03-28 20:17:24 | itemises | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 494 | 2023-03-15 15:50:08 | itemises | 1 | 82945 | 4 | 1.266 | 65517.4 |
| 493 | 2023-03-13 19:44:30 | itemises | 3 | 146162 | 140 | 6.063 | 24107.2 |
| 492 | 2023-02-09 06:10:29 | itemises | 1 | 82945 | 4 | 1.393 | 59544.1 |
| 491 | 2023-02-07 01:20:32 | itemises | 1 | 82945 | 4 | 2.733 | 30349.4 |
| 490 | 2023-01-05 17:55:45 | itemises | 1 | 82945 | 4 | 1.346 | 61623.3 |
| 489 | 2022-12-21 15:54:46 | itemises | 1 | 82945 | 4 | 1.236 | 67107.6 |
| 488 | 2022-12-16 07:28:55 | itemises | 3 | 146162 | 140 | 7.000 | 20880.3 |
| 487 | 2022-11-29 11:12:48 | itemises | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 486 | 2022-11-19 14:21:19 | itemises | 3 | 146162 | 140 | 6.406 | 22816.4 |
| 485 | 2022-11-10 04:29:56 | itemises | 1 | 82945 | 4 | 1.266 | 65517.4 |
| 484 | 2022-11-08 15:14:09 | itemises | 3 | 146162 | 140 | 7.360 | 19859.0 |
| 483 | 2022-10-19 04:34:17 | itemises | 1 | 82945 | 4 | 1.220 | 67987.7 |
| 482 | 2022-10-14 09:18:32 | itemises | 1 | 82945 | 4 | 1.346 | 61623.3 |
| 481 | 2022-10-11 07:49:54 | itemises | 3 | 146162 | 140 | 6.096 | 23976.7 |
| 480 | 2022-10-10 09:18:38 | itemises | 3 | 146162 | 140 | 6.186 | 23627.9 |
| 479 | 2022-10-03 23:27:50 | itemises | 3 | 146162 | 140 | 6.110 | 23921.8 |
| 478 | 2022-09-30 22:45:51 | itemises | 1 | 82945 | 4 | 1.236 | 67107.6 |
| 477 | 2022-09-08 14:18:16 | itemises | 3 | 146162 | 140 | 6.733 | 21708.3 |
| 476 | 2022-09-07 14:22:25 | itemises | 3 | 146162 | 140 | 7.156 | 20425.1 |
| 475 | 2022-09-06 14:18:14 | itemises | 3 | 146162 | 140 | 6.300 | 23200.3 |
| 474 | 2022-09-05 14:20:37 | itemises | 3 | 146162 | 140 | 6.156 | 23743.0 |
| 473 | 2022-09-04 19:25:09 | itemises | 3 | 146162 | 140 | 6.533 | 22372.9 |
| 472 | 2022-09-04 14:18:20 | itemises | 3 | 146162 | 140 | 6.406 | 22816.4 |
| 471 | 2022-09-03 14:13:23 | itemises | 3 | 146162 | 140 | 6.143 | 23793.3 |
| 470 | 2022-09-02 23:20:56 | itemises | 3 | 146162 | 140 | 6.266 | 23326.2 |
| 469 | 2022-09-02 14:06:45 | itemises | 3 | 146162 | 140 | 6.466 | 22604.7 |
| 468 | 2022-09-01 18:46:26 | itemises | 3 | 146162 | 140 | 6.373 | 22934.6 |
| 467 | 2022-09-01 14:05:10 | itemises | 3 | 146162 | 140 | 6.313 | 23152.5 |
| 466 | 2022-08-31 14:04:23 | itemises | 3 | 146162 | 140 | 8.016 | 18233.8 |
| 465 | 2022-08-30 14:03:36 | itemises | 3 | 146162 | 140 | 6.890 | 21213.6 |
| 464 | 2022-08-29 13:59:16 | itemises | 3 | 146162 | 140 | 6.093 | 23988.5 |
| 463 | 2022-08-28 13:56:35 | itemises | 3 | 146162 | 140 | 6.423 | 22756.0 |
| 462 | 2022-08-27 13:57:50 | itemises | 3 | 146162 | 140 | 7.063 | 20694.0 |
| 461 | 2022-08-27 07:22:45 | itemises | 3 | 146162 | 140 | 6.360 | 22981.4 |
| 460 | 2022-08-27 06:44:09 | itemises | 3 | 146162 | 140 | 7.080 | 20644.4 |
| 459 | 2022-08-26 18:25:37 | itemises | 3 | 146162 | 140 | 6.736 | 21698.6 |
| 458 | 2022-08-26 13:53:11 | itemises | 3 | 146162 | 140 | 6.966 | 20982.2 |
| 457 | 2022-08-26 07:21:52 | itemises | 3 | 146162 | 140 | 6.203 | 23563.1 |
| 456 | 2022-08-26 06:43:41 | itemises | 3 | 146162 | 140 | 7.296 | 20033.2 |
| 455 | 2022-08-25 13:50:59 | itemises | 3 | 146162 | 140 | 7.250 | 20160.3 |
| 454 | 2022-08-25 07:22:58 | itemises | 3 | 146162 | 140 | 6.156 | 23743.0 |
| 453 | 2022-08-25 06:43:57 | itemises | 3 | 146162 | 140 | 6.093 | 23988.5 |
| 452 | 2022-08-24 13:46:14 | itemises | 3 | 146162 | 140 | 7.216 | 20255.3 |
| 451 | 2022-08-24 08:01:29 | itemises | 3 | 146162 | 140 | 6.640 | 22012.3 |
| 450 | 2022-08-24 06:47:01 | itemises | 3 | 146162 | 140 | 6.936 | 21073.0 |
| 449 | 2022-08-23 13:45:44 | itemises | 3 | 146162 | 140 | 6.390 | 22873.6 |
| 448 | 2022-08-23 07:19:53 | itemises | 3 | 146162 | 140 | 6.906 | 21164.5 |
| 447 | 2022-08-23 06:38:38 | itemises | 3 | 146162 | 140 | 6.830 | 21400.0 |
| 446 | 2022-08-22 07:11:35 | itemises | 3 | 146162 | 140 | 6.186 | 23627.9 |
| 445 | 2022-08-22 06:32:01 | itemises | 3 | 146162 | 140 | 6.236 | 23438.4 |
| 444 | 2022-08-21 07:19:49 | itemises | 3 | 146162 | 140 | 7.093 | 20606.5 |
| 443 | 2022-08-21 06:31:14 | itemises | 3 | 146162 | 140 | 6.656 | 21959.4 |