History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subzone"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 544 | 2025-12-27 12:10:50 | subzone | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 543 | 2025-12-26 03:38:57 | subzone | 1 | 69583 | 3 | 1.483 | 46920.4 |
| 542 | 2025-12-26 03:38:26 | subzone | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 541 | 2025-12-26 03:38:10 | subzone | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 540 | 2025-12-25 22:54:36 | subzone | 1 | 69583 | 3 | 3.266 | 21305.3 |
| 539 | 2025-12-23 04:43:22 | subzone | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 538 | 2025-12-21 07:13:18 | subzone | 4 | 151207 | 1034 | 11.560 | 13080.2 |
| 537 | 2025-12-21 07:13:08 | subzone | 4 | 151207 | 1034 | 11.516 | 13130.2 |
| 536 | 2025-12-20 08:41:11 | subzone | 4 | 151207 | 1034 | 11.953 | 12650.1 |
| 535 | 2025-12-17 08:30:05 | subzone | 4 | 151207 | 1034 | 10.326 | 14643.3 |
| 534 | 2025-12-15 22:07:10 | subzone | 3 | 134027 | 91 | 10.796 | 12414.5 |
| 533 | 2025-12-14 14:06:53 | subzone | 4 | 151207 | 1034 | 30.973 | 4881.9 |
| 532 | 2025-12-14 01:10:29 | subzone | 3 | 134027 | 91 | 6.940 | 19312.2 |
| 531 | 2025-12-14 00:51:13 | subzone | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 530 | 2025-12-14 00:43:17 | subzone | 3 | 134027 | 91 | 31.486 | 4256.7 |
| 529 | 2025-12-13 23:06:32 | subzone | 2 | 107671 | 8 | 12.046 | 8938.3 |
| 528 | 2025-12-13 21:41:23 | subzone | 4 | 151207 | 1034 | 11.456 | 13198.9 |
| 527 | 2025-12-13 20:05:49 | subzone | 3 | 134027 | 91 | 6.346 | 21119.9 |
| 526 | 2025-12-13 01:37:16 | subzone | 4 | 151207 | 1034 | 11.466 | 13187.4 |
| 525 | 2025-12-12 07:26:47 | subzone | 4 | 151207 | 1034 | 10.530 | 14359.6 |
| 524 | 2025-12-12 04:05:25 | subzone | 4 | 151207 | 1034 | 44.316 | 3412.0 |
| 523 | 2025-12-11 23:33:29 | subzone | 3 | 134027 | 91 | 6.236 | 21492.5 |
| 522 | 2025-12-11 21:47:32 | subzone | 3 | 134027 | 91 | 28.483 | 4705.5 |
| 521 | 2025-12-11 18:27:17 | subzone | 2 | 107671 | 8 | 9.703 | 11096.7 |
| 520 | 2025-12-11 06:59:36 | subzone | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 519 | 2025-12-10 23:56:57 | subzone | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 518 | 2025-11-30 09:39:49 | subzone | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 517 | 2025-11-30 04:22:45 | subzone | 1 | 69583 | 3 | 2.826 | 24622.4 |
| 516 | 2025-11-29 05:17:29 | subzone | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 515 | 2025-11-28 15:58:18 | subzone | 1 | 69583 | 3 | 1.580 | 44039.9 |
| 514 | 2025-11-27 09:22:56 | subzone | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 513 | 2025-11-27 07:07:11 | subzone | 4 | 151207 | 1034 | 10.530 | 14359.6 |
| 512 | 2025-11-26 17:45:19 | subzone | 4 | 151207 | 1034 | 17.220 | 8780.9 |
| 511 | 2025-11-26 14:25:12 | subzone | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 510 | 2025-11-12 13:05:30 | subzone | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 509 | 2025-11-11 21:15:39 | subzone | 3 | 134027 | 91 | 6.876 | 19492.0 |
| 508 | 2025-11-09 23:59:01 | subzone | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 507 | 2025-11-05 10:59:33 | subzone | 3 | 134027 | 91 | 6.656 | 20136.3 |
| 506 | 2025-11-04 21:51:52 | subzone | 4 | 151207 | 1034 | 10.170 | 14867.9 |
| 505 | 2025-11-03 21:53:20 | subzone | 3 | 134027 | 91 | 7.906 | 16952.6 |
| 504 | 2025-11-03 11:07:51 | subzone | 1 | 69583 | 3 | 2.500 | 27833.2 |
| 503 | 2025-11-01 17:22:45 | subzone | 4 | 151207 | 1034 | 9.766 | 15483.0 |
| 502 | 2025-11-01 01:20:53 | subzone | 1 | 69583 | 3 | 1.920 | 36241.1 |
| 501 | 2025-10-30 09:41:07 | subzone | 1 | 69583 | 3 | 1.253 | 55533.1 |
| 500 | 2025-10-30 05:06:31 | subzone | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 499 | 2025-10-29 07:05:12 | subzone | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 498 | 2025-10-28 18:48:22 | subzone | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 497 | 2025-10-28 16:58:56 | subzone | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 496 | 2025-10-28 01:14:38 | subzone | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 495 | 2025-10-28 00:44:42 | subzone | 3 | 134027 | 91 | 7.143 | 18763.4 |
| 494 | 2025-10-27 10:11:06 | subzone | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 493 | 2025-10-27 07:51:44 | subzone | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 492 | 2025-10-25 01:06:00 | subzone | 3 | 134027 | 91 | 10.236 | 13093.7 |
| 491 | 2025-10-24 06:23:06 | subzone | 4 | 151207 | 1034 | 9.940 | 15212.0 |
| 490 | 2025-10-24 02:05:03 | subzone | 2 | 107671 | 8 | 3.063 | 35152.1 |
| 489 | 2025-10-23 13:23:19 | subzone | 3 | 134027 | 91 | 27.486 | 4876.2 |
| 488 | 2025-10-22 15:07:07 | subzone | 2 | 107671 | 8 | 8.453 | 12737.6 |
| 487 | 2025-10-12 13:59:49 | subzone | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 486 | 2025-10-11 08:13:53 | subzone | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 485 | 2025-10-10 01:00:52 | subzone | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 484 | 2025-09-29 10:10:15 | subzone | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 483 | 2025-09-29 05:27:43 | subzone | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 482 | 2025-09-27 16:51:43 | subzone | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 481 | 2025-09-26 10:27:50 | subzone | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 480 | 2025-09-26 07:27:15 | subzone | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 479 | 2025-09-22 07:59:28 | subzone | 1 | 69583 | 3 | 1.293 | 53815.2 |
| 478 | 2025-09-21 20:45:56 | subzone | 4 | 151207 | 1034 | 11.140 | 13573.3 |
| 477 | 2025-09-19 01:44:24 | subzone | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 476 | 2025-09-11 13:52:56 | subzone | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 475 | 2025-09-11 08:08:04 | subzone | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 474 | 2025-09-10 12:19:46 | subzone | 4 | 151207 | 1034 | 11.533 | 13110.8 |
| 473 | 2025-09-09 00:44:26 | subzone | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 472 | 2025-09-07 23:33:12 | subzone | 4 | 151207 | 1034 | 11.846 | 12764.4 |
| 471 | 2025-08-29 11:02:41 | subzone | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 470 | 2025-08-29 09:57:18 | subzone | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 469 | 2025-08-29 05:21:20 | subzone | 1 | 69583 | 3 | 1.436 | 48456.1 |
| 468 | 2025-08-28 12:43:23 | subzone | 2 | 107671 | 8 | 2.983 | 36094.9 |
| 467 | 2025-08-28 07:49:49 | subzone | 4 | 151207 | 1034 | 27.563 | 5485.9 |
| 466 | 2025-08-27 21:01:32 | subzone | 3 | 134027 | 91 | 6.703 | 19995.1 |
| 465 | 2025-08-27 16:49:00 | subzone | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 464 | 2025-08-27 09:52:12 | subzone | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 463 | 2025-08-27 06:01:51 | subzone | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 462 | 2025-08-13 15:17:01 | subzone | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 461 | 2025-08-09 14:06:04 | subzone | 1 | 69583 | 3 | 8.203 | 8482.6 |
| 460 | 2025-08-09 09:23:39 | subzone | 1 | 69583 | 3 | 7.703 | 9033.2 |
| 459 | 2025-08-09 01:26:17 | subzone | 1 | 69583 | 3 | 2.856 | 24363.8 |
| 458 | 2025-07-27 11:53:07 | subzone | 2 | 107671 | 8 | 7.373 | 14603.4 |
| 457 | 2025-07-27 00:06:51 | subzone | 3 | 134027 | 91 | 24.140 | 5552.1 |
| 456 | 2025-07-25 21:22:59 | subzone | 1 | 69583 | 3 | 2.656 | 26198.4 |
| 455 | 2025-07-25 08:32:20 | subzone | 1 | 69583 | 3 | 4.906 | 14183.2 |
| 454 | 2025-07-25 06:54:52 | subzone | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 453 | 2025-07-24 06:18:47 | subzone | 1 | 69583 | 3 | 4.330 | 16070.0 |
| 452 | 2025-06-24 02:12:36 | subzone | 3 | 134027 | 91 | 31.173 | 4299.5 |
| 451 | 2025-06-24 00:51:35 | subzone | 3 | 134027 | 91 | 26.766 | 5007.4 |
| 450 | 2025-06-22 08:07:04 | subzone | 3 | 134027 | 91 | 33.973 | 3945.1 |
| 449 | 2025-06-21 21:49:54 | subzone | 2 | 107671 | 8 | 16.343 | 6588.2 |
| 448 | 2025-06-21 05:05:53 | subzone | 1 | 69583 | 3 | 2.860 | 24329.7 |
| 447 | 2025-06-14 10:36:33 | subzone | 1 | 69583 | 3 | 4.513 | 15418.3 |
| 446 | 2025-06-10 11:56:32 | subzone | 1 | 69583 | 3 | 5.706 | 12194.7 |
| 445 | 2025-06-08 17:10:39 | subzone | 1 | 69583 | 3 | 8.970 | 7757.3 |