History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"insurers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 593 | 2024-12-27 13:08:40 | insurers | 1 | 82945 | 6 | 8.843 | 9379.7 |
| 592 | 2024-12-21 10:54:09 | insurers | 1 | 82945 | 6 | 6.986 | 11873.0 |
| 591 | 2024-12-19 07:18:24 | insurers | 3 | 146162 | 194 | 35.720 | 4091.9 |
| 590 | 2024-12-19 05:13:14 | insurers | 3 | 146162 | 194 | 18.190 | 8035.3 |
| 589 | 2024-12-15 17:09:30 | insurers | 1 | 82945 | 6 | 3.220 | 25759.3 |
| 588 | 2024-12-15 10:51:27 | insurers | 3 | 146162 | 194 | 28.753 | 5083.4 |
| 587 | 2024-12-14 21:04:40 | insurers | 3 | 146162 | 194 | 37.300 | 3918.6 |
| 586 | 2024-12-14 01:37:31 | insurers | 1 | 82945 | 6 | 8.046 | 10308.8 |
| 585 | 2024-12-09 15:41:40 | insurers | 2 | 121059 | 30 | 23.173 | 5224.1 |
| 584 | 2024-12-09 15:41:37 | insurers | 1 | 82945 | 6 | 7.093 | 11693.9 |
| 583 | 2024-12-01 00:02:58 | insurers | 3 | 146162 | 194 | 12.063 | 12116.6 |
| 582 | 2024-11-18 03:33:29 | insurers | 1 | 82945 | 6 | 3.830 | 21656.7 |
| 581 | 2024-11-18 02:20:37 | insurers | 3 | 146162 | 194 | 54.016 | 2705.9 |
| 580 | 2024-11-17 04:43:03 | insurers | 3 | 146162 | 194 | 48.203 | 3032.2 |
| 579 | 2024-11-17 04:42:34 | insurers | 1 | 82945 | 6 | 7.563 | 10967.2 |
| 578 | 2024-11-13 13:43:52 | insurers | 1 | 82945 | 6 | 4.233 | 19594.8 |
| 577 | 2024-11-12 10:31:55 | insurers | 2 | 121059 | 30 | 20.313 | 5959.7 |
| 576 | 2024-11-11 17:14:02 | insurers | 3 | 146162 | 194 | 37.733 | 3873.6 |
| 575 | 2024-11-11 17:14:03 | insurers | 2 | 121059 | 30 | 22.466 | 5388.5 |
| 574 | 2024-11-11 07:50:09 | insurers | 1 | 82945 | 6 | 1.423 | 58288.8 |
| 573 | 2024-10-18 04:21:48 | insurers | 2 | 121059 | 30 | 3.830 | 31608.1 |
| 572 | 2024-10-15 10:44:14 | insurers | 2 | 121059 | 30 | 17.173 | 7049.4 |
| 571 | 2024-10-15 10:43:08 | insurers | 1 | 82945 | 6 | 1.390 | 59672.7 |
| 570 | 2024-10-15 09:43:34 | insurers | 3 | 146162 | 194 | 35.220 | 4150.0 |
| 569 | 2024-10-14 01:37:12 | insurers | 3 | 146162 | 194 | 33.110 | 4414.4 |
| 568 | 2024-10-12 04:11:05 | insurers | 2 | 121059 | 30 | 11.076 | 10929.8 |
| 567 | 2024-10-12 04:10:47 | insurers | 1 | 82945 | 6 | 6.626 | 12518.1 |
| 566 | 2024-10-11 21:18:45 | insurers | 3 | 146162 | 194 | 37.360 | 3912.3 |
| 565 | 2024-10-11 21:11:04 | insurers | 3 | 146162 | 194 | 35.376 | 4131.7 |
| 564 | 2024-10-11 21:11:03 | insurers | 2 | 121059 | 30 | 22.643 | 5346.4 |
| 563 | 2024-10-11 21:11:00 | insurers | 1 | 82945 | 6 | 7.093 | 11693.9 |
| 562 | 2024-10-08 19:59:15 | insurers | 1 | 82945 | 6 | 5.623 | 14751.0 |
| 561 | 2024-09-05 23:51:41 | insurers | 1 | 82945 | 6 | 14.030 | 5912.0 |
| 560 | 2024-09-05 08:15:01 | insurers | 1 | 82945 | 6 | 8.423 | 9847.4 |
| 559 | 2024-09-01 15:43:42 | insurers | 1 | 82945 | 6 | 5.936 | 13973.2 |
| 558 | 2024-08-30 08:08:38 | insurers | 1 | 82945 | 6 | 5.796 | 14310.7 |
| 557 | 2024-08-17 13:19:07 | insurers | 1 | 82945 | 6 | 6.656 | 12461.7 |
| 556 | 2024-08-08 16:48:32 | insurers | 3 | 146162 | 194 | 31.283 | 4672.3 |
| 555 | 2024-08-05 13:58:37 | insurers | 3 | 146162 | 194 | 13.876 | 10533.4 |
| 554 | 2024-08-05 11:08:46 | insurers | 1 | 82945 | 6 | 5.346 | 15515.3 |
| 553 | 2024-08-03 18:02:12 | insurers | 2 | 121059 | 30 | 6.313 | 19176.1 |
| 552 | 2024-08-03 02:08:40 | insurers | 3 | 146162 | 194 | 16.753 | 8724.5 |
| 551 | 2024-08-02 23:28:21 | insurers | 2 | 121059 | 30 | 15.436 | 7842.6 |
| 550 | 2024-08-02 22:39:50 | insurers | 3 | 146162 | 194 | 19.516 | 7489.3 |
| 549 | 2024-08-02 15:20:38 | insurers | 3 | 146162 | 194 | 39.216 | 3727.1 |
| 548 | 2024-08-02 08:11:57 | insurers | 3 | 146162 | 194 | 36.330 | 4023.2 |
| 547 | 2024-08-02 07:58:04 | insurers | 2 | 121059 | 30 | 4.263 | 28397.6 |
| 546 | 2024-08-02 05:41:49 | insurers | 3 | 146162 | 194 | 29.236 | 4999.4 |
| 545 | 2024-08-02 05:41:50 | insurers | 2 | 121059 | 30 | 18.643 | 6493.5 |
| 544 | 2024-08-02 05:41:26 | insurers | 1 | 82945 | 6 | 4.453 | 18626.8 |
| 543 | 2024-08-02 04:58:26 | insurers | 1 | 82945 | 6 | 5.766 | 14385.2 |
| 542 | 2024-07-11 15:48:49 | insurers | 1 | 82945 | 6 | 2.233 | 37145.1 |
| 541 | 2024-07-02 20:08:55 | insurers | 1 | 82945 | 6 | 5.486 | 15119.4 |
| 540 | 2024-07-01 13:57:36 | insurers | 2 | 121059 | 30 | 12.156 | 9958.8 |
| 539 | 2024-07-01 13:51:21 | insurers | 1 | 82945 | 6 | 12.203 | 6797.1 |
| 538 | 2024-07-01 13:35:18 | insurers | 3 | 146162 | 194 | 31.466 | 4645.1 |
| 537 | 2024-07-01 12:04:17 | insurers | 1 | 82945 | 6 | 5.076 | 16340.6 |
| 536 | 2024-07-01 12:04:11 | insurers | 1 | 82945 | 6 | 4.953 | 16746.4 |
| 535 | 2024-07-01 08:25:36 | insurers | 3 | 146162 | 194 | 30.270 | 4828.6 |
| 534 | 2024-07-01 06:32:35 | insurers | 1 | 82945 | 6 | 8.860 | 9361.7 |
| 533 | 2024-07-01 06:32:19 | insurers | 2 | 121059 | 30 | 19.533 | 6197.7 |
| 532 | 2024-07-01 02:53:44 | insurers | 2 | 121059 | 30 | 23.093 | 5242.2 |
| 531 | 2024-07-01 02:53:06 | insurers | 2 | 121059 | 30 | 30.723 | 3940.3 |
| 530 | 2024-07-01 02:53:10 | insurers | 1 | 82945 | 6 | 7.470 | 11103.7 |
| 529 | 2024-06-30 21:59:07 | insurers | 2 | 121059 | 30 | 3.716 | 32577.8 |
| 528 | 2024-06-30 17:06:01 | insurers | 1 | 82945 | 6 | 5.110 | 16231.9 |
| 527 | 2024-06-27 10:39:44 | insurers | 2 | 121059 | 30 | 8.936 | 13547.3 |
| 526 | 2024-06-27 10:39:18 | insurers | 3 | 146162 | 194 | 24.643 | 5931.2 |
| 525 | 2024-06-26 13:10:41 | insurers | 2 | 121059 | 30 | 15.876 | 7625.3 |
| 524 | 2024-06-26 13:07:47 | insurers | 2 | 121059 | 30 | 14.220 | 8513.3 |
| 523 | 2024-06-25 07:03:38 | insurers | 3 | 146162 | 194 | 38.283 | 3817.9 |
| 522 | 2024-06-25 04:25:28 | insurers | 3 | 146162 | 194 | 11.203 | 13046.7 |
| 521 | 2024-06-23 20:08:14 | insurers | 3 | 146162 | 194 | 28.000 | 5220.1 |
| 520 | 2024-06-23 20:08:15 | insurers | 2 | 121059 | 30 | 13.750 | 8804.3 |
| 519 | 2024-06-04 05:59:36 | insurers | 1 | 82945 | 6 | 4.906 | 16906.8 |
| 518 | 2024-05-31 19:26:52 | insurers | 1 | 82945 | 6 | 1.686 | 49196.3 |
| 517 | 2024-05-30 13:37:07 | insurers | 1 | 82945 | 6 | 6.970 | 11900.3 |
| 516 | 2024-05-03 10:03:44 | insurers | 3 | 146162 | 194 | 14.486 | 10089.9 |
| 515 | 2024-05-03 10:03:47 | insurers | 2 | 121059 | 30 | 4.450 | 27204.3 |
| 514 | 2024-05-01 10:00:22 | insurers | 2 | 121059 | 30 | 13.000 | 9312.2 |
| 513 | 2024-05-01 04:04:42 | insurers | 3 | 146162 | 194 | 7.546 | 19369.5 |
| 512 | 2024-04-30 23:02:09 | insurers | 1 | 82945 | 6 | 2.893 | 28670.9 |
| 511 | 2024-04-28 09:34:50 | insurers | 1 | 82945 | 6 | 2.766 | 29987.3 |
| 510 | 2024-04-24 19:52:07 | insurers | 3 | 146162 | 194 | 21.893 | 6676.2 |
| 509 | 2024-04-21 04:21:01 | insurers | 2 | 121059 | 30 | 9.000 | 13451.0 |
| 508 | 2024-04-21 04:20:49 | insurers | 3 | 146162 | 194 | 8.890 | 16441.2 |
| 507 | 2024-04-21 03:50:45 | insurers | 1 | 82945 | 6 | 1.546 | 53651.4 |
| 506 | 2024-04-21 03:34:51 | insurers | 1 | 82945 | 6 | 3.343 | 24811.5 |
| 505 | 2024-04-20 22:31:20 | insurers | 1 | 82945 | 6 | 1.796 | 46183.2 |
| 504 | 2024-04-20 22:31:08 | insurers | 3 | 146162 | 194 | 11.906 | 12276.3 |
| 503 | 2024-04-20 22:31:04 | insurers | 2 | 121059 | 30 | 8.250 | 14673.8 |
| 502 | 2024-04-03 09:19:56 | insurers | 1 | 82945 | 6 | 1.406 | 58993.6 |
| 501 | 2024-04-03 09:19:39 | insurers | 2 | 121059 | 30 | 5.826 | 20779.1 |
| 500 | 2024-04-03 09:08:48 | insurers | 3 | 146162 | 194 | 9.220 | 15852.7 |
| 499 | 2024-04-03 08:55:10 | insurers | 3 | 146162 | 194 | 15.753 | 9278.4 |
| 498 | 2024-04-03 08:55:09 | insurers | 2 | 121059 | 30 | 8.546 | 14165.6 |
| 497 | 2024-03-30 07:41:22 | insurers | 1 | 82945 | 6 | 4.830 | 17172.9 |
| 496 | 2024-03-30 03:22:09 | insurers | 1 | 82945 | 6 | 4.016 | 20653.6 |
| 495 | 2024-03-20 18:30:32 | insurers | 3 | 146162 | 194 | 12.360 | 11825.4 |
| 494 | 2024-03-20 18:30:31 | insurers | 2 | 121059 | 30 | 6.783 | 17847.4 |