History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sterile"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 419 | 2025-08-09 04:59:01 | sterile | 1 | 69583 | 1 | 5.706 | 12194.7 |
| 418 | 2025-08-03 09:07:36 | sterile | 3 | 134027 | 380 | 32.266 | 4153.8 |
| 417 | 2025-08-03 09:07:35 | sterile | 3 | 134027 | 380 | 22.080 | 6070.1 |
| 416 | 2025-08-02 02:25:35 | sterile | 1 | 69583 | 1 | 5.000 | 13916.6 |
| 415 | 2025-08-01 21:21:37 | sterile | 3 | 134027 | 380 | 35.106 | 3817.8 |
| 414 | 2025-07-31 22:27:06 | sterile | 1 | 69583 | 1 | 11.203 | 6211.1 |
| 413 | 2025-07-30 23:29:52 | sterile | 3 | 134027 | 380 | 42.846 | 3128.1 |
| 412 | 2025-07-27 13:38:23 | sterile | 2 | 107671 | 31 | 16.173 | 6657.5 |
| 411 | 2025-07-25 02:37:08 | sterile | 1 | 69583 | 1 | 3.140 | 22160.2 |
| 410 | 2025-07-24 17:56:25 | sterile | 1 | 69583 | 1 | 5.296 | 13138.8 |
| 409 | 2025-07-23 22:54:07 | sterile | 1 | 69583 | 1 | 6.360 | 10940.7 |
| 408 | 2025-07-22 21:37:33 | sterile | 1 | 69583 | 1 | 4.563 | 15249.4 |
| 407 | 2025-07-22 19:46:40 | sterile | 1 | 69583 | 1 | 6.063 | 11476.7 |
| 406 | 2025-07-22 11:08:26 | sterile | 1 | 69583 | 1 | 4.390 | 15850.3 |
| 405 | 2025-07-21 21:04:47 | sterile | 1 | 69583 | 1 | 2.000 | 34791.5 |
| 404 | 2025-07-17 13:08:36 | sterile | 1 | 69583 | 1 | 3.126 | 22259.4 |
| 403 | 2025-07-14 15:36:16 | sterile | 1 | 69583 | 1 | 7.783 | 8940.4 |
| 402 | 2025-07-10 17:34:37 | sterile | 2 | 107671 | 31 | 21.610 | 4982.5 |
| 401 | 2025-07-08 00:44:15 | sterile | 1 | 69583 | 1 | 5.876 | 11841.9 |
| 400 | 2025-07-01 21:38:17 | sterile | 1 | 69583 | 1 | 5.470 | 12720.8 |
| 399 | 2025-06-27 10:14:16 | sterile | 1 | 69583 | 1 | 5.626 | 12368.1 |
| 398 | 2025-06-26 13:40:08 | sterile | 3 | 134027 | 380 | 27.970 | 4791.8 |
| 397 | 2025-06-26 11:14:23 | sterile | 1 | 69583 | 1 | 5.813 | 11970.2 |
| 396 | 2025-06-24 23:53:29 | sterile | 3 | 134027 | 380 | 36.313 | 3690.9 |
| 395 | 2025-06-23 21:42:28 | sterile | 3 | 134027 | 380 | 29.200 | 4590.0 |
| 394 | 2025-06-22 05:37:57 | sterile | 3 | 134027 | 380 | 35.453 | 3780.4 |
| 393 | 2025-06-21 19:48:14 | sterile | 1 | 69583 | 1 | 3.610 | 19275.1 |
| 392 | 2025-06-20 04:19:44 | sterile | 3 | 134027 | 380 | 33.253 | 4030.5 |
| 391 | 2025-06-19 13:16:25 | sterile | 3 | 134027 | 380 | 26.500 | 5057.6 |
| 390 | 2025-06-16 10:31:57 | sterile | 1 | 69583 | 1 | 5.030 | 13833.6 |
| 389 | 2025-06-14 13:50:33 | sterile | 1 | 69583 | 1 | 4.796 | 14508.5 |
| 388 | 2025-06-10 22:33:24 | sterile | 1 | 69583 | 1 | 3.016 | 23071.3 |
| 387 | 2025-06-10 15:35:22 | sterile | 1 | 69583 | 1 | 3.360 | 20709.2 |
| 386 | 2025-05-31 19:15:53 | sterile | 1 | 69583 | 1 | 6.716 | 10360.8 |
| 385 | 2025-05-23 22:46:09 | sterile | 3 | 134027 | 380 | 44.643 | 3002.2 |
| 384 | 2025-05-23 10:57:43 | sterile | 2 | 107671 | 31 | 11.046 | 9747.5 |
| 383 | 2025-05-23 01:03:05 | sterile | 3 | 134027 | 380 | 20.110 | 6664.7 |
| 382 | 2025-05-21 19:33:56 | sterile | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 381 | 2025-05-16 10:44:05 | sterile | 1 | 69583 | 1 | 3.876 | 17952.3 |
| 380 | 2025-05-13 12:57:30 | sterile | 1 | 69583 | 1 | 3.220 | 21609.6 |
| 379 | 2025-05-06 00:01:00 | sterile | 1 | 69583 | 1 | 6.360 | 10940.7 |
| 378 | 2025-05-05 13:05:55 | sterile | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 377 | 2025-04-30 01:09:17 | sterile | 1 | 69583 | 1 | 3.063 | 22717.3 |
| 376 | 2025-04-29 16:06:54 | sterile | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 375 | 2025-04-28 21:12:07 | sterile | 1 | 69583 | 1 | 4.376 | 15901.1 |
| 374 | 2025-04-22 01:49:29 | sterile | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 373 | 2025-04-20 19:41:05 | sterile | 1 | 69583 | 1 | 4.643 | 14986.6 |
| 372 | 2025-04-19 19:41:49 | sterile | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 371 | 2025-04-12 13:01:14 | sterile | 1 | 69583 | 1 | 7.206 | 9656.3 |
| 370 | 2025-04-09 15:06:08 | sterile | 1 | 69583 | 1 | 3.060 | 22739.5 |
| 369 | 2025-04-05 23:25:18 | sterile | 1 | 69583 | 1 | 6.860 | 10143.3 |
| 368 | 2025-03-19 20:32:18 | sterile | 1 | 69583 | 1 | 6.110 | 11388.4 |
| 367 | 2025-03-13 12:12:41 | sterile | 1 | 69583 | 1 | 3.140 | 22160.2 |
| 366 | 2025-03-08 23:06:42 | sterile | 1 | 69583 | 1 | 4.846 | 14358.9 |
| 365 | 2025-03-05 21:12:38 | sterile | 1 | 69583 | 1 | 5.753 | 12095.1 |
| 364 | 2025-03-05 16:41:12 | sterile | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 363 | 2025-03-03 15:03:30 | sterile | 1 | 69583 | 1 | 7.936 | 8768.0 |
| 362 | 2025-02-25 17:49:37 | sterile | 1 | 69583 | 1 | 5.110 | 13617.0 |
| 361 | 2025-02-24 20:03:38 | sterile | 1 | 69583 | 1 | 7.640 | 9107.7 |
| 360 | 2025-01-25 17:45:20 | sterile | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 359 | 2025-01-24 19:34:53 | sterile | 1 | 69583 | 1 | 6.156 | 11303.3 |
| 358 | 2025-01-20 16:21:03 | sterile | 1 | 69583 | 1 | 5.343 | 13023.2 |
| 357 | 2025-01-08 12:56:28 | sterile | 2 | 107671 | 31 | 3.263 | 32997.5 |
| 356 | 2025-01-06 06:32:47 | sterile | 2 | 107671 | 31 | 16.720 | 6439.7 |
| 355 | 2025-01-01 16:01:46 | sterile | 2 | 107671 | 31 | 25.173 | 4277.2 |
| 354 | 2024-12-27 03:20:58 | sterile | 3 | 134027 | 380 | 26.706 | 5018.6 |
| 353 | 2024-12-27 01:13:05 | sterile | 3 | 134027 | 380 | 31.940 | 4196.2 |
| 352 | 2024-12-26 12:26:31 | sterile | 3 | 134027 | 380 | 29.723 | 4509.2 |
| 351 | 2024-12-26 10:14:56 | sterile | 3 | 134027 | 380 | 26.800 | 5001.0 |
| 350 | 2024-12-26 10:14:57 | sterile | 2 | 107671 | 31 | 16.423 | 6556.1 |
| 349 | 2024-12-26 09:51:27 | sterile | 1 | 69583 | 1 | 5.906 | 11781.7 |
| 348 | 2024-12-25 10:44:25 | sterile | 1 | 69583 | 1 | 6.313 | 11022.2 |
| 347 | 2024-12-20 16:23:03 | sterile | 1 | 69583 | 1 | 5.826 | 11943.5 |
| 346 | 2024-11-21 21:37:14 | sterile | 1 | 69583 | 1 | 8.750 | 7952.3 |
| 345 | 2024-11-13 18:42:10 | sterile | 1 | 69583 | 1 | 6.483 | 10733.1 |
| 344 | 2024-11-09 11:45:59 | sterile | 1 | 69583 | 1 | 5.703 | 12201.1 |
| 343 | 2024-10-22 21:20:53 | sterile | 1 | 69583 | 1 | 6.236 | 11158.3 |
| 342 | 2024-10-14 18:26:08 | sterile | 1 | 69583 | 1 | 7.250 | 9597.7 |
| 341 | 2024-10-12 15:18:00 | sterile | 1 | 69583 | 1 | 6.033 | 11533.7 |
| 340 | 2024-09-21 23:44:10 | sterile | 1 | 69583 | 1 | 8.906 | 7813.0 |
| 339 | 2024-09-21 00:46:53 | sterile | 1 | 69583 | 1 | 12.313 | 5651.2 |
| 338 | 2024-09-14 04:16:52 | sterile | 1 | 69583 | 1 | 12.613 | 5516.8 |
| 337 | 2024-09-07 03:56:31 | sterile | 1 | 69583 | 1 | 8.656 | 8038.7 |
| 336 | 2024-08-20 03:28:11 | sterile | 3 | 134027 | 380 | 27.206 | 4926.4 |
| 335 | 2024-08-19 19:16:33 | sterile | 3 | 134027 | 380 | 39.923 | 3357.1 |
| 334 | 2024-08-16 15:37:19 | sterile | 1 | 69583 | 1 | 9.393 | 7408.0 |
| 333 | 2024-08-15 09:15:52 | sterile | 1 | 69583 | 1 | 6.686 | 10407.3 |
| 332 | 2024-08-13 01:45:31 | sterile | 1 | 69583 | 1 | 8.873 | 7842.1 |
| 331 | 2024-08-11 13:16:21 | sterile | 1 | 69583 | 1 | 8.126 | 8563.0 |
| 330 | 2024-08-06 17:02:04 | sterile | 3 | 134027 | 380 | 34.520 | 3882.6 |
| 329 | 2024-08-06 04:50:35 | sterile | 3 | 134027 | 380 | 17.016 | 7876.5 |
| 328 | 2024-08-05 08:08:28 | sterile | 3 | 134027 | 380 | 33.063 | 4053.7 |
| 327 | 2024-08-04 14:05:00 | sterile | 3 | 134027 | 380 | 27.953 | 4794.7 |
| 326 | 2024-08-04 14:04:16 | sterile | 1 | 69583 | 1 | 2.596 | 26803.9 |
| 325 | 2024-08-02 14:27:43 | sterile | 1 | 69583 | 1 | 2.750 | 25302.9 |
| 324 | 2024-07-24 23:42:47 | sterile | 2 | 107671 | 31 | 12.186 | 8835.6 |
| 323 | 2024-07-13 11:34:07 | sterile | 1 | 69583 | 1 | 4.156 | 16742.8 |
| 322 | 2024-07-10 14:22:26 | sterile | 1 | 69583 | 1 | 5.593 | 12441.1 |
| 321 | 2024-07-07 16:25:28 | sterile | 1 | 69583 | 1 | 5.296 | 13138.8 |
| 320 | 2024-07-07 16:23:59 | sterile | 1 | 69583 | 1 | 2.356 | 29534.4 |