History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substantial"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 418 | 2025-10-28 01:58:01 | substantial | 5 | 164607 | 174 | 52.330 | 3145.6 |
| 417 | 2025-10-27 05:36:36 | substantial | 5 | 164607 | 174 | 25.720 | 6400.0 |
| 416 | 2025-10-26 23:37:07 | substantial | 4 | 148819 | 41 | 14.813 | 10046.5 |
| 415 | 2025-10-22 01:41:43 | substantial | 4 | 148819 | 41 | 46.360 | 3210.1 |
| 414 | 2025-10-22 01:38:17 | substantial | 2 | 86808 | 8 | 11.750 | 7387.9 |
| 413 | 2025-10-16 19:32:44 | substantial | 5 | 164607 | 174 | 14.186 | 11603.5 |
| 412 | 2025-10-16 06:48:26 | substantial | 4 | 148819 | 41 | 8.000 | 18602.4 |
| 411 | 2025-10-15 13:01:59 | substantial | 2 | 86808 | 8 | 2.080 | 41734.6 |
| 410 | 2025-10-13 19:20:37 | substantial | 2 | 86808 | 8 | 2.420 | 35871.1 |
| 409 | 2025-10-13 11:19:35 | substantial | 4 | 148819 | 41 | 8.236 | 18069.3 |
| 408 | 2025-09-10 12:17:38 | substantial | 1 | 49908 | 3 | 0.860 | 58032.6 |
| 407 | 2025-09-10 02:50:42 | substantial | 2 | 86808 | 8 | 2.300 | 37742.6 |
| 406 | 2025-09-03 08:25:15 | substantial | 1 | 49908 | 3 | 0.766 | 65154.0 |
| 405 | 2025-08-27 03:19:22 | substantial | 1 | 49908 | 3 | 0.810 | 61614.8 |
| 404 | 2025-08-21 08:28:55 | substantial | 1 | 49908 | 3 | 2.093 | 23845.2 |
| 403 | 2025-08-15 07:25:09 | substantial | 1 | 49908 | 3 | 3.640 | 13711.0 |
| 402 | 2025-08-08 19:51:35 | substantial | 1 | 49908 | 3 | 3.016 | 16547.7 |
| 401 | 2025-08-07 20:34:49 | substantial | 3 | 121633 | 16 | 24.173 | 5031.8 |
| 400 | 2025-07-26 22:16:05 | substantial | 1 | 49908 | 3 | 3.580 | 13940.8 |
| 399 | 2025-07-25 01:14:12 | substantial | 1 | 49908 | 3 | 4.266 | 11699.0 |
| 398 | 2025-07-19 06:51:20 | substantial | 2 | 86808 | 8 | 2.266 | 38308.9 |
| 397 | 2025-07-19 00:10:50 | substantial | 3 | 121633 | 16 | 4.470 | 27211.0 |
| 396 | 2025-07-11 07:22:52 | substantial | 1 | 49908 | 3 | 4.483 | 11132.7 |
| 395 | 2025-07-06 19:32:49 | substantial | 1 | 49908 | 3 | 0.920 | 54247.8 |
| 394 | 2025-07-04 02:27:21 | substantial | 1 | 49908 | 3 | 4.326 | 11536.8 |
| 393 | 2025-06-27 20:53:47 | substantial | 1 | 49908 | 3 | 1.796 | 27788.4 |
| 392 | 2025-06-13 23:21:20 | substantial | 1 | 49908 | 3 | 1.860 | 26832.3 |
| 391 | 2025-06-12 13:00:06 | substantial | 4 | 148819 | 41 | 24.283 | 6128.5 |
| 390 | 2025-06-12 10:05:05 | substantial | 2 | 86808 | 8 | 9.846 | 8816.6 |
| 389 | 2025-06-12 04:20:52 | substantial | 3 | 121633 | 16 | 20.643 | 5892.2 |
| 388 | 2025-06-07 19:06:33 | substantial | 4 | 148819 | 41 | 42.383 | 3511.3 |
| 387 | 2025-06-07 08:10:00 | substantial | 2 | 86808 | 8 | 3.313 | 26202.2 |
| 386 | 2025-06-07 06:15:13 | substantial | 3 | 121633 | 16 | 4.360 | 27897.5 |
| 385 | 2025-05-28 19:26:50 | substantial | 1 | 49908 | 3 | 0.873 | 57168.4 |
| 384 | 2025-05-26 04:03:36 | substantial | 1 | 49908 | 3 | 4.390 | 11368.6 |
| 383 | 2025-05-21 23:32:01 | substantial | 1 | 49908 | 3 | 4.170 | 11968.3 |
| 382 | 2025-05-12 01:54:06 | substantial | 1 | 49908 | 3 | 3.923 | 12721.9 |
| 381 | 2025-05-04 01:23:55 | substantial | 1 | 49908 | 3 | 1.860 | 26832.3 |
| 380 | 2025-04-23 03:17:54 | substantial | 1 | 49908 | 3 | 2.143 | 23288.8 |
| 379 | 2025-04-22 19:25:32 | substantial | 1 | 49908 | 3 | 3.000 | 16636.0 |
| 378 | 2025-04-19 22:36:46 | substantial | 1 | 49908 | 3 | 2.220 | 22481.1 |
| 377 | 2025-03-20 23:08:37 | substantial | 1 | 49908 | 3 | 2.173 | 22967.3 |
| 376 | 2025-03-19 20:39:04 | substantial | 1 | 49908 | 3 | 2.966 | 16826.7 |
| 375 | 2025-02-21 05:01:16 | substantial | 1 | 49908 | 3 | 2.233 | 22350.2 |
| 374 | 2025-02-20 04:34:29 | substantial | 3 | 121633 | 16 | 25.860 | 4703.5 |
| 373 | 2025-02-20 04:34:17 | substantial | 2 | 86808 | 8 | 11.986 | 7242.4 |
| 372 | 2025-02-19 07:41:37 | substantial | 3 | 121633 | 16 | 25.783 | 4717.6 |
| 371 | 2025-02-19 07:41:38 | substantial | 2 | 86808 | 8 | 16.580 | 5235.7 |
| 370 | 2025-02-19 07:25:04 | substantial | 1 | 49908 | 3 | 3.703 | 13477.7 |
| 369 | 2025-02-17 21:17:38 | substantial | 4 | 148819 | 41 | 47.736 | 3117.5 |
| 368 | 2025-02-16 17:26:59 | substantial | 1 | 49908 | 3 | 4.046 | 12335.1 |
| 367 | 2025-02-13 13:57:39 | substantial | 4 | 148819 | 41 | 49.486 | 3007.3 |
| 366 | 2025-02-11 18:01:12 | substantial | 4 | 148819 | 41 | 45.753 | 3252.7 |
| 365 | 2025-02-11 11:21:00 | substantial | 3 | 121633 | 16 | 12.940 | 9399.8 |
| 364 | 2025-02-11 11:20:55 | substantial | 2 | 86808 | 8 | 5.376 | 16147.3 |
| 363 | 2025-02-11 10:10:13 | substantial | 1 | 49908 | 3 | 0.876 | 56972.6 |
| 362 | 2025-01-21 02:16:33 | substantial | 3 | 121633 | 16 | 29.940 | 4062.6 |
| 361 | 2025-01-21 02:16:47 | substantial | 2 | 86808 | 8 | 11.750 | 7387.9 |
| 360 | 2025-01-21 02:15:53 | substantial | 1 | 49908 | 3 | 2.626 | 19005.3 |
| 359 | 2025-01-14 21:50:23 | substantial | 4 | 148819 | 41 | 58.483 | 2544.7 |
| 358 | 2025-01-13 22:59:18 | substantial | 4 | 148819 | 41 | 44.203 | 3366.7 |
| 357 | 2025-01-13 11:02:49 | substantial | 5 | 164607 | 174 | 93.473 | 1761.0 |
| 356 | 2025-01-13 11:02:48 | substantial | 4 | 148819 | 41 | 44.656 | 3332.6 |
| 355 | 2025-01-13 11:02:48 | substantial | 3 | 121633 | 16 | 16.173 | 7520.7 |
| 354 | 2025-01-13 11:02:48 | substantial | 2 | 86808 | 8 | 10.923 | 7947.3 |
| 353 | 2025-01-13 09:34:51 | substantial | 5 | 164607 | 174 | 87.223 | 1887.2 |
| 352 | 2025-01-13 09:34:58 | substantial | 3 | 121633 | 16 | 23.643 | 5144.6 |
| 351 | 2025-01-13 09:34:54 | substantial | 2 | 86808 | 8 | 7.220 | 12023.3 |
| 350 | 2025-01-07 09:23:53 | substantial | 4 | 148819 | 41 | 24.093 | 6176.9 |
| 349 | 2025-01-07 05:59:54 | substantial | 1 | 49908 | 3 | 4.640 | 10756.0 |
| 348 | 2025-01-07 03:10:19 | substantial | 1 | 49908 | 3 | 4.060 | 12292.6 |
| 347 | 2025-01-04 08:34:39 | substantial | 1 | 49908 | 3 | 4.016 | 12427.3 |
| 346 | 2024-12-16 01:25:07 | substantial | 1 | 49908 | 3 | 4.033 | 12374.9 |
| 345 | 2024-12-15 02:45:15 | substantial | 3 | 121633 | 16 | 23.983 | 5071.6 |
| 344 | 2024-12-13 03:10:40 | substantial | 4 | 148819 | 41 | 36.953 | 4027.3 |
| 343 | 2024-12-11 21:26:54 | substantial | 3 | 121633 | 16 | 25.986 | 4680.7 |
| 342 | 2024-12-11 21:26:46 | substantial | 2 | 86808 | 8 | 13.140 | 6606.4 |
| 341 | 2024-12-07 17:34:32 | substantial | 3 | 121633 | 16 | 21.046 | 5779.4 |
| 340 | 2024-12-07 17:34:34 | substantial | 2 | 86808 | 8 | 5.813 | 14933.4 |
| 339 | 2024-12-07 17:33:15 | substantial | 1 | 49908 | 3 | 5.233 | 9537.2 |
| 338 | 2024-12-05 01:54:30 | substantial | 2 | 86808 | 8 | 11.626 | 7466.7 |
| 337 | 2024-12-05 01:07:27 | substantial | 4 | 148819 | 41 | 33.063 | 4501.1 |
| 336 | 2024-12-03 11:25:28 | substantial | 4 | 148819 | 41 | 61.080 | 2436.5 |
| 335 | 2024-12-03 00:41:13 | substantial | 4 | 148819 | 41 | 45.843 | 3246.3 |
| 334 | 2024-12-03 00:41:10 | substantial | 4 | 148819 | 41 | 39.300 | 3786.7 |
| 333 | 2024-12-03 00:41:17 | substantial | 2 | 86808 | 8 | 11.716 | 7409.4 |
| 332 | 2024-12-03 00:40:16 | substantial | 1 | 49908 | 3 | 1.810 | 27573.5 |
| 331 | 2024-11-30 23:15:13 | substantial | 1 | 49908 | 3 | 3.936 | 12679.9 |
| 330 | 2024-11-16 15:44:07 | substantial | 4 | 148819 | 41 | 56.880 | 2616.4 |
| 329 | 2024-11-14 22:05:04 | substantial | 3 | 121633 | 16 | 26.016 | 4675.3 |
| 328 | 2024-11-13 01:01:57 | substantial | 3 | 121633 | 16 | 26.843 | 4531.3 |
| 327 | 2024-11-12 12:17:33 | substantial | 1 | 49908 | 3 | 2.016 | 24756.0 |
| 326 | 2024-11-02 05:54:18 | substantial | 4 | 148819 | 41 | 45.503 | 3270.5 |
| 325 | 2024-11-02 05:54:15 | substantial | 3 | 121633 | 16 | 34.593 | 3516.1 |
| 324 | 2024-11-02 05:54:07 | substantial | 2 | 86808 | 8 | 9.110 | 9528.9 |
| 323 | 2024-11-01 19:53:15 | substantial | 4 | 148819 | 41 | 46.096 | 3228.5 |
| 322 | 2024-11-01 19:53:09 | substantial | 4 | 148819 | 41 | 49.100 | 3030.9 |
| 321 | 2024-11-01 19:53:12 | substantial | 3 | 121633 | 16 | 23.430 | 5191.3 |
| 320 | 2024-11-01 19:53:15 | substantial | 2 | 86808 | 8 | 9.986 | 8693.0 |
| 319 | 2024-11-01 19:52:00 | substantial | 1 | 49908 | 3 | 4.096 | 12184.6 |