History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subtext"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 416 | 2025-07-11 15:43:00 | subtext | 3 | 134027 | 111 | 49.363 | 2715.1 |
| 415 | 2025-07-09 05:05:18 | subtext | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 414 | 2025-07-08 14:17:26 | subtext | 3 | 134027 | 111 | 27.880 | 4807.3 |
| 413 | 2025-07-08 06:04:58 | subtext | 1 | 69583 | 3 | 3.390 | 20526.0 |
| 412 | 2025-07-07 17:42:43 | subtext | 1 | 69583 | 3 | 3.393 | 20507.8 |
| 411 | 2025-07-07 02:18:17 | subtext | 1 | 69583 | 3 | 3.906 | 17814.4 |
| 410 | 2025-07-06 14:36:09 | subtext | 3 | 134027 | 111 | 7.140 | 18771.3 |
| 409 | 2025-07-05 07:33:35 | subtext | 2 | 107671 | 16 | 16.483 | 6532.2 |
| 408 | 2025-07-04 17:03:03 | subtext | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 407 | 2025-07-03 23:24:52 | subtext | 1 | 69583 | 3 | 8.360 | 8323.3 |
| 406 | 2025-07-02 15:09:12 | subtext | 2 | 107671 | 16 | 17.190 | 6263.6 |
| 405 | 2025-06-30 20:58:43 | subtext | 2 | 107671 | 16 | 3.266 | 32967.2 |
| 404 | 2025-06-26 11:57:51 | subtext | 1 | 69583 | 3 | 3.906 | 17814.4 |
| 403 | 2025-06-17 16:50:23 | subtext | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 402 | 2025-06-13 22:34:15 | subtext | 1 | 69583 | 3 | 3.750 | 18555.5 |
| 401 | 2025-06-07 07:03:41 | subtext | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 400 | 2025-06-05 01:43:26 | subtext | 1 | 69583 | 3 | 5.750 | 12101.4 |
| 399 | 2025-06-03 23:08:37 | subtext | 1 | 69583 | 3 | 6.470 | 10754.7 |
| 398 | 2025-05-27 21:36:05 | subtext | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 397 | 2025-05-27 06:21:58 | subtext | 1 | 69583 | 3 | 3.296 | 21111.3 |
| 396 | 2025-05-26 11:37:14 | subtext | 1 | 69583 | 3 | 5.733 | 12137.3 |
| 395 | 2025-05-24 11:43:19 | subtext | 1 | 69583 | 3 | 3.203 | 21724.3 |
| 394 | 2025-05-20 17:34:09 | subtext | 1 | 69583 | 3 | 6.580 | 10574.9 |
| 393 | 2025-05-03 23:05:28 | subtext | 1 | 69583 | 3 | 7.690 | 9048.5 |
| 392 | 2025-04-23 11:39:50 | subtext | 1 | 69583 | 3 | 5.720 | 12164.9 |
| 391 | 2025-04-20 15:50:14 | subtext | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 390 | 2025-04-16 05:00:55 | subtext | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 389 | 2025-04-14 03:14:44 | subtext | 1 | 69583 | 3 | 4.563 | 15249.4 |
| 388 | 2025-04-02 18:01:28 | subtext | 1 | 69583 | 3 | 9.390 | 7410.3 |
| 387 | 2025-03-30 23:26:33 | subtext | 1 | 69583 | 3 | 6.030 | 11539.5 |
| 386 | 2025-03-23 12:25:41 | subtext | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 385 | 2025-03-20 18:17:37 | subtext | 1 | 69583 | 3 | 7.593 | 9164.1 |
| 384 | 2025-03-12 02:15:41 | subtext | 1 | 69583 | 3 | 6.030 | 11539.5 |
| 383 | 2025-02-26 01:57:14 | subtext | 1 | 69583 | 3 | 5.626 | 12368.1 |
| 382 | 2025-02-17 08:46:10 | subtext | 2 | 107671 | 16 | 16.736 | 6433.5 |
| 381 | 2025-02-17 08:46:00 | subtext | 1 | 69583 | 3 | 3.546 | 19623.0 |
| 380 | 2025-02-14 10:10:22 | subtext | 1 | 69583 | 3 | 6.050 | 11501.3 |
| 379 | 2025-02-12 14:56:59 | subtext | 1 | 69583 | 3 | 3.970 | 17527.2 |
| 378 | 2025-02-10 10:52:47 | subtext | 1 | 69583 | 3 | 5.763 | 12074.1 |
| 377 | 2025-02-08 16:33:54 | subtext | 3 | 134027 | 111 | 40.673 | 3295.2 |
| 376 | 2025-02-04 13:22:31 | subtext | 3 | 134027 | 111 | 7.060 | 18984.0 |
| 375 | 2025-02-01 16:17:07 | subtext | 3 | 134027 | 111 | 25.766 | 5201.7 |
| 374 | 2025-01-27 12:45:44 | subtext | 3 | 134027 | 111 | 10.393 | 12895.9 |
| 373 | 2025-01-15 10:58:40 | subtext | 3 | 134027 | 111 | 32.640 | 4106.2 |
| 372 | 2025-01-15 04:27:46 | subtext | 2 | 107671 | 16 | 14.186 | 7589.9 |
| 371 | 2025-01-13 17:31:56 | subtext | 3 | 134027 | 111 | 39.830 | 3365.0 |
| 370 | 2025-01-13 09:57:49 | subtext | 1 | 69583 | 3 | 7.000 | 9940.4 |
| 369 | 2025-01-13 08:37:24 | subtext | 2 | 107671 | 16 | 3.343 | 32207.9 |
| 368 | 2025-01-12 22:34:00 | subtext | 3 | 134027 | 111 | 28.686 | 4672.2 |
| 367 | 2025-01-12 22:34:09 | subtext | 2 | 107671 | 16 | 16.670 | 6459.0 |
| 366 | 2025-01-12 22:32:53 | subtext | 1 | 69583 | 3 | 6.233 | 11163.6 |
| 365 | 2025-01-08 10:19:35 | subtext | 1 | 69583 | 3 | 5.390 | 12909.6 |
| 364 | 2025-01-02 14:15:05 | subtext | 1 | 69583 | 3 | 6.123 | 11364.2 |
| 363 | 2024-12-21 07:51:31 | subtext | 2 | 107671 | 16 | 16.640 | 6470.6 |
| 362 | 2024-12-21 07:47:38 | subtext | 3 | 134027 | 111 | 8.513 | 15743.8 |
| 361 | 2024-12-16 12:15:55 | subtext | 3 | 134027 | 111 | 35.936 | 3729.6 |
| 360 | 2024-12-16 06:37:20 | subtext | 3 | 134027 | 111 | 29.440 | 4552.5 |
| 359 | 2024-12-13 14:39:36 | subtext | 1 | 69583 | 3 | 2.266 | 30707.4 |
| 358 | 2024-12-12 03:18:56 | subtext | 2 | 107671 | 16 | 16.813 | 6404.0 |
| 357 | 2024-12-12 03:18:11 | subtext | 1 | 69583 | 3 | 5.016 | 13872.2 |
| 356 | 2024-12-04 03:22:44 | subtext | 1 | 69583 | 3 | 5.643 | 12330.9 |
| 355 | 2024-11-13 04:48:18 | subtext | 3 | 134027 | 111 | 18.643 | 7189.1 |
| 354 | 2024-11-13 04:48:19 | subtext | 2 | 107671 | 16 | 14.953 | 7200.6 |
| 353 | 2024-11-13 04:48:06 | subtext | 1 | 69583 | 3 | 5.500 | 12651.5 |
| 352 | 2024-11-12 14:16:52 | subtext | 3 | 134027 | 111 | 33.690 | 3978.2 |
| 351 | 2024-11-12 09:14:43 | subtext | 3 | 134027 | 111 | 22.796 | 5879.4 |
| 350 | 2024-11-11 08:37:03 | subtext | 3 | 134027 | 111 | 33.423 | 4010.0 |
| 349 | 2024-11-11 08:36:59 | subtext | 2 | 107671 | 16 | 13.270 | 8113.9 |
| 348 | 2024-11-06 17:13:05 | subtext | 1 | 69583 | 3 | 3.780 | 18408.2 |
| 347 | 2024-11-01 20:00:46 | subtext | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 346 | 2024-11-01 06:59:04 | subtext | 1 | 69583 | 3 | 8.640 | 8053.6 |
| 345 | 2024-10-12 22:34:31 | subtext | 1 | 69583 | 3 | 5.813 | 11970.2 |
| 344 | 2024-10-09 04:27:55 | subtext | 1 | 69583 | 3 | 5.236 | 13289.3 |
| 343 | 2024-10-02 03:00:17 | subtext | 1 | 69583 | 3 | 7.720 | 9013.3 |
| 342 | 2024-09-23 16:33:14 | subtext | 1 | 69583 | 3 | 13.376 | 5202.1 |
| 341 | 2024-09-14 01:25:02 | subtext | 3 | 134027 | 111 | 70.626 | 1897.7 |
| 340 | 2024-09-14 01:15:52 | subtext | 3 | 134027 | 111 | 72.990 | 1836.2 |
| 339 | 2024-09-13 09:17:24 | subtext | 3 | 134027 | 111 | 41.630 | 3219.5 |
| 338 | 2024-09-13 09:16:49 | subtext | 2 | 107671 | 16 | 7.313 | 14723.2 |
| 337 | 2024-09-12 23:35:12 | subtext | 2 | 107671 | 16 | 12.550 | 8579.4 |
| 336 | 2024-09-12 23:35:00 | subtext | 1 | 69583 | 3 | 13.110 | 5307.6 |
| 335 | 2024-08-15 17:37:45 | subtext | 1 | 69583 | 3 | 11.313 | 6150.7 |
| 334 | 2024-08-14 09:38:23 | subtext | 1 | 69583 | 3 | 4.466 | 15580.6 |
| 333 | 2024-08-08 05:15:17 | subtext | 1 | 69583 | 3 | 5.206 | 13365.9 |
| 332 | 2024-07-29 16:57:05 | subtext | 3 | 134027 | 111 | 28.813 | 4651.6 |
| 331 | 2024-07-29 12:13:53 | subtext | 3 | 134027 | 111 | 33.580 | 3991.3 |
| 330 | 2024-07-29 04:46:01 | subtext | 3 | 134027 | 111 | 32.830 | 4082.5 |
| 329 | 2024-07-28 10:35:21 | subtext | 3 | 134027 | 111 | 14.800 | 9055.9 |
| 328 | 2024-07-27 00:07:06 | subtext | 3 | 134027 | 111 | 16.876 | 7941.9 |
| 327 | 2024-07-26 02:38:04 | subtext | 3 | 134027 | 111 | 17.586 | 7621.2 |
| 326 | 2024-07-26 02:34:33 | subtext | 3 | 134027 | 111 | 18.423 | 7275.0 |
| 325 | 2024-07-25 20:35:52 | subtext | 1 | 69583 | 3 | 6.703 | 10380.9 |
| 324 | 2024-07-23 12:37:57 | subtext | 1 | 69583 | 3 | 4.423 | 15732.1 |
| 323 | 2024-07-11 01:12:16 | subtext | 1 | 69583 | 3 | 4.126 | 16864.5 |
| 322 | 2024-07-08 10:10:52 | subtext | 1 | 69583 | 3 | 2.220 | 31343.7 |
| 321 | 2024-06-29 05:37:07 | subtext | 1 | 69583 | 3 | 3.310 | 21022.1 |
| 320 | 2024-06-19 08:27:58 | subtext | 1 | 69583 | 3 | 2.236 | 31119.4 |
| 319 | 2024-06-07 09:02:04 | subtext | 1 | 69583 | 3 | 2.346 | 29660.3 |
| 318 | 2024-05-26 09:26:36 | subtext | 1 | 69583 | 3 | 3.500 | 19880.9 |
| 317 | 2024-05-14 12:22:14 | subtext | 2 | 107671 | 16 | 3.533 | 30475.8 |