History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"teachers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 492 | 2024-04-27 09:05:06 | teachers | 1 | 82945 | 6 | 3.393 | 24445.9 |
| 491 | 2024-04-11 14:46:22 | teachers | 1 | 82945 | 6 | 3.080 | 26930.2 |
| 490 | 2024-03-30 00:43:46 | teachers | 1 | 82945 | 6 | 1.706 | 48619.6 |
| 489 | 2024-03-29 20:10:42 | teachers | 1 | 82945 | 6 | 1.563 | 53067.8 |
| 488 | 2024-03-15 13:32:52 | teachers | 1 | 82945 | 6 | 4.156 | 19957.9 |
| 487 | 2024-02-28 21:28:58 | teachers | 2 | 121059 | 51 | 4.283 | 28265.0 |
| 486 | 2024-02-28 21:28:01 | teachers | 3 | 146162 | 438 | 8.703 | 16794.4 |
| 485 | 2024-02-28 21:03:26 | teachers | 2 | 121059 | 51 | 4.016 | 30144.2 |
| 484 | 2024-02-28 19:19:03 | teachers | 2 | 121059 | 51 | 3.923 | 30858.8 |
| 483 | 2024-02-28 18:36:01 | teachers | 3 | 146162 | 438 | 7.593 | 19249.6 |
| 482 | 2024-02-28 16:27:16 | teachers | 3 | 146162 | 438 | 23.316 | 6268.7 |
| 481 | 2024-02-28 16:27:16 | teachers | 2 | 121059 | 51 | 13.656 | 8864.9 |
| 480 | 2024-02-28 14:03:02 | teachers | 1 | 82945 | 6 | 3.203 | 25896.0 |
| 479 | 2024-02-13 03:40:05 | teachers | 2 | 121059 | 51 | 3.390 | 35710.6 |
| 478 | 2024-02-07 06:42:10 | teachers | 1 | 82945 | 6 | 1.436 | 57761.1 |
| 477 | 2024-01-23 01:30:58 | teachers | 2 | 121059 | 51 | 4.440 | 27265.5 |
| 476 | 2024-01-22 08:30:14 | teachers | 2 | 121059 | 51 | 3.203 | 37795.5 |
| 475 | 2024-01-15 07:25:02 | teachers | 2 | 121059 | 51 | 3.873 | 31257.2 |
| 474 | 2024-01-09 14:10:02 | teachers | 1 | 82945 | 6 | 1.580 | 52496.8 |
| 473 | 2023-12-29 05:21:51 | teachers | 1 | 82945 | 6 | 1.453 | 57085.3 |
| 472 | 2023-12-15 01:55:20 | teachers | 3 | 146162 | 438 | 6.783 | 21548.3 |
| 471 | 2023-11-29 17:50:55 | teachers | 1 | 82945 | 6 | 1.360 | 60989.0 |
| 470 | 2023-11-28 00:21:04 | teachers | 1 | 82945 | 6 | 1.280 | 64800.8 |
| 469 | 2023-11-22 23:55:27 | teachers | 1 | 82945 | 6 | 1.343 | 61761.0 |
| 468 | 2023-11-01 21:17:06 | teachers | 2 | 121059 | 51 | 4.750 | 25486.1 |
| 467 | 2023-10-25 12:03:32 | teachers | 1 | 82945 | 6 | 2.736 | 30316.2 |
| 466 | 2023-10-17 01:56:03 | teachers | 1 | 82945 | 6 | 1.610 | 51518.6 |
| 465 | 2023-09-30 23:18:19 | teachers | 3 | 146162 | 438 | 14.843 | 9847.2 |
| 464 | 2023-09-29 18:03:08 | teachers | 1 | 82945 | 6 | 1.436 | 57761.1 |
| 463 | 2023-09-27 20:03:21 | teachers | 3 | 146162 | 438 | 8.206 | 17811.6 |
| 462 | 2023-09-26 02:27:22 | teachers | 1 | 82945 | 6 | 1.266 | 65517.4 |
| 461 | 2023-09-15 12:19:11 | teachers | 3 | 146162 | 438 | 6.753 | 21644.0 |
| 460 | 2023-09-14 01:36:20 | teachers | 1 | 82945 | 6 | 1.420 | 58412.0 |
| 459 | 2023-09-03 07:12:26 | teachers | 1 | 82945 | 6 | 1.516 | 54713.1 |
| 458 | 2023-08-26 11:49:20 | teachers | 2 | 121059 | 51 | 4.000 | 30264.8 |
| 457 | 2023-08-08 08:18:42 | teachers | 2 | 121059 | 51 | 3.703 | 32692.1 |
| 456 | 2023-06-30 15:26:19 | teachers | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 455 | 2023-06-20 00:09:15 | teachers | 3 | 146162 | 438 | 7.283 | 20068.9 |
| 454 | 2023-05-14 02:33:07 | teachers | 1 | 82945 | 6 | 1.250 | 66356.0 |
| 453 | 2023-04-19 10:23:22 | teachers | 2 | 121059 | 51 | 3.250 | 37248.9 |
| 452 | 2023-04-09 12:01:43 | teachers | 1 | 82945 | 6 | 1.250 | 66356.0 |
| 451 | 2023-03-18 09:19:26 | teachers | 3 | 146162 | 438 | 6.906 | 21164.5 |
| 450 | 2023-03-06 11:47:42 | teachers | 1 | 82945 | 6 | 1.266 | 65517.4 |
| 449 | 2023-03-04 10:32:30 | teachers | 1 | 82945 | 6 | 1.423 | 58288.8 |
| 448 | 2023-03-04 05:54:53 | teachers | 1 | 82945 | 6 | 1.250 | 66356.0 |
| 447 | 2023-01-30 13:57:30 | teachers | 1 | 82945 | 6 | 1.233 | 67270.9 |
| 446 | 2023-01-18 13:49:31 | teachers | 2 | 121059 | 51 | 3.186 | 37997.2 |
| 445 | 2023-01-17 03:17:12 | teachers | 1 | 82945 | 6 | 1.283 | 64649.3 |
| 444 | 2022-12-25 13:33:02 | teachers | 3 | 146162 | 438 | 6.313 | 23152.5 |
| 443 | 2022-12-19 10:14:51 | teachers | 3 | 146162 | 438 | 6.500 | 22486.5 |
| 442 | 2022-11-28 11:45:46 | teachers | 1 | 82945 | 6 | 1.280 | 64800.8 |
| 441 | 2022-11-10 08:46:32 | teachers | 3 | 146162 | 438 | 7.266 | 20115.9 |
| 440 | 2022-10-28 20:51:58 | teachers | 2 | 121059 | 51 | 3.640 | 33258.0 |
| 439 | 2022-10-19 08:59:15 | teachers | 3 | 146162 | 438 | 7.123 | 20519.7 |
| 438 | 2022-09-17 03:08:48 | teachers | 3 | 146162 | 438 | 6.296 | 23215.1 |
| 437 | 2022-09-15 00:36:33 | teachers | 1 | 82945 | 6 | 1.516 | 54713.1 |
| 436 | 2022-08-16 08:22:27 | teachers | 3 | 146162 | 438 | 6.563 | 22270.6 |
| 435 | 2022-08-15 02:47:40 | teachers | 1 | 82945 | 6 | 1.406 | 58993.6 |
| 434 | 2022-07-29 10:17:15 | teachers | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 433 | 2022-07-22 15:40:15 | teachers | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 432 | 2022-05-27 22:42:52 | teachers | 2 | 121059 | 51 | 3.250 | 37248.9 |
| 431 | 2022-05-12 19:09:36 | teachers | 1 | 82945 | 6 | 1.500 | 55296.7 |
| 430 | 2022-03-15 14:12:26 | teachers | 1 | 82945 | 6 | 1.750 | 47397.1 |
| 429 | 2022-03-12 10:19:45 | teachers | 3 | 146162 | 438 | 6.470 | 22590.7 |
| 428 | 2022-02-10 15:14:48 | teachers | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 427 | 2022-01-25 03:33:44 | teachers | 1 | 82945 | 6 | 1.486 | 55817.6 |
| 426 | 2022-01-02 18:16:45 | teachers | 2 | 121059 | 51 | 3.626 | 33386.4 |
| 425 | 2022-01-01 15:27:40 | teachers | 2 | 121059 | 51 | 4.420 | 27388.9 |
| 424 | 2021-12-30 01:08:25 | teachers | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 423 | 2021-12-27 22:16:39 | teachers | 1 | 82945 | 6 | 1.576 | 52630.1 |
| 422 | 2021-12-08 01:43:17 | teachers | 3 | 146162 | 438 | 7.310 | 19994.8 |
| 421 | 2021-11-11 09:36:00 | teachers | 1 | 82945 | 6 | 1.450 | 57203.4 |
| 420 | 2021-11-10 15:47:11 | teachers | 1 | 82945 | 6 | 1.483 | 55930.5 |
| 419 | 2021-11-08 22:42:35 | teachers | 1 | 82945 | 6 | 1.440 | 57600.7 |
| 418 | 2021-10-30 15:36:09 | teachers | 1 | 82945 | 6 | 1.470 | 56425.2 |
| 417 | 2021-10-08 15:47:10 | teachers | 1 | 82945 | 6 | 1.296 | 64000.8 |
| 416 | 2021-09-26 10:45:10 | teachers | 3 | 146162 | 438 | 6.830 | 21400.0 |
| 415 | 2021-09-26 00:07:44 | teachers | 2 | 121059 | 51 | 3.390 | 35710.6 |
| 414 | 2021-09-25 22:10:23 | teachers | 3 | 146162 | 438 | 7.470 | 19566.5 |
| 413 | 2021-09-25 10:13:27 | teachers | 2 | 121059 | 51 | 3.216 | 37642.7 |
| 412 | 2021-09-25 09:04:03 | teachers | 3 | 146162 | 438 | 7.326 | 19951.1 |
| 411 | 2021-09-23 05:10:42 | teachers | 1 | 82945 | 6 | 1.296 | 64000.8 |
| 410 | 2021-09-21 02:47:22 | teachers | 1 | 82945 | 6 | 1.533 | 54106.3 |
| 409 | 2021-09-20 08:50:36 | teachers | 1 | 82945 | 6 | 1.546 | 53651.4 |
| 408 | 2021-09-19 20:34:54 | teachers | 3 | 146162 | 438 | 18.876 | 7743.3 |
| 407 | 2021-09-19 20:28:09 | teachers | 2 | 121059 | 51 | 3.826 | 31641.1 |
| 406 | 2021-09-19 20:08:53 | teachers | 1 | 82945 | 6 | 1.390 | 59672.7 |
| 405 | 2021-09-13 12:01:10 | teachers | 1 | 82945 | 6 | 1.280 | 64800.8 |
| 404 | 2021-09-03 18:07:41 | teachers | 1 | 82945 | 6 | 1.470 | 56425.2 |
| 403 | 2021-09-01 11:07:37 | teachers | 1 | 82945 | 6 | 1.470 | 56425.2 |
| 402 | 2021-07-06 12:06:06 | teachers | 1 | 82945 | 6 | 1.296 | 64000.8 |
| 401 | 2021-07-02 22:58:14 | teachers | 1 | 82945 | 6 | 1.500 | 55296.7 |
| 400 | 2021-04-19 16:58:55 | teachers | 1 | 82945 | 6 | 1.453 | 57085.3 |
| 399 | 2021-03-29 03:25:01 | teachers | 1 | 82945 | 6 | 1.296 | 64000.8 |
| 398 | 2021-03-24 19:05:56 | teachers | 1 | 82945 | 6 | 1.423 | 58288.8 |
| 397 | 2021-03-22 12:55:37 | teachers | 1 | 82945 | 6 | 1.376 | 60279.8 |
| 396 | 2021-01-04 09:08:18 | teachers | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 395 | 2020-12-21 10:50:56 | teachers | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 394 | 2020-11-17 05:31:27 | teachers | 1 | 82945 | 6 | 1.420 | 58412.0 |
| 393 | 2020-11-13 19:43:25 | teachers | 1 | 82945 | 6 | 1.470 | 56425.2 |