History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subtype"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 438 | 2025-12-04 01:56:26 | subtype | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 437 | 2025-12-01 14:12:20 | subtype | 1 | 69583 | 2 | 1.170 | 59472.6 |
| 436 | 2025-11-30 06:28:14 | subtype | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 435 | 2025-11-27 22:56:15 | subtype | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 434 | 2025-11-27 18:27:51 | subtype | 4 | 151207 | 706 | 11.686 | 12939.2 |
| 433 | 2025-11-27 03:12:04 | subtype | 4 | 151207 | 706 | 11.436 | 13222.0 |
| 432 | 2025-11-26 14:34:15 | subtype | 3 | 134027 | 66 | 16.876 | 7941.9 |
| 431 | 2025-11-24 16:56:00 | subtype | 4 | 151207 | 706 | 33.906 | 4459.6 |
| 430 | 2025-11-22 20:08:31 | subtype | 1 | 69583 | 2 | 1.263 | 55093.4 |
| 429 | 2025-11-22 10:11:00 | subtype | 1 | 69583 | 2 | 1.283 | 54234.6 |
| 428 | 2025-11-21 03:10:48 | subtype | 1 | 69583 | 2 | 1.280 | 54361.7 |
| 427 | 2025-11-14 04:49:37 | subtype | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 426 | 2025-11-12 00:30:01 | subtype | 1 | 69583 | 2 | 2.593 | 26834.9 |
| 425 | 2025-11-11 19:06:04 | subtype | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 424 | 2025-11-05 18:54:27 | subtype | 1 | 69583 | 2 | 1.326 | 52475.9 |
| 423 | 2025-10-28 20:04:51 | subtype | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 422 | 2025-10-28 12:47:48 | subtype | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 421 | 2025-10-22 10:48:39 | subtype | 1 | 69583 | 2 | 4.110 | 16930.2 |
| 420 | 2025-10-21 20:04:47 | subtype | 1 | 69583 | 2 | 3.016 | 23071.3 |
| 419 | 2025-10-20 11:10:29 | subtype | 1 | 69583 | 2 | 3.266 | 21305.3 |
| 418 | 2025-10-18 18:09:48 | subtype | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 417 | 2025-10-18 02:44:46 | subtype | 1 | 69583 | 2 | 1.110 | 62687.4 |
| 416 | 2025-10-17 02:05:05 | subtype | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 415 | 2025-10-14 05:53:28 | subtype | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 414 | 2025-10-11 17:23:01 | subtype | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 413 | 2025-10-11 02:47:47 | subtype | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 412 | 2025-10-03 21:21:28 | subtype | 4 | 151207 | 706 | 11.410 | 13252.1 |
| 411 | 2025-09-30 23:10:59 | subtype | 3 | 134027 | 66 | 6.283 | 21331.7 |
| 410 | 2025-09-29 06:53:32 | subtype | 3 | 134027 | 66 | 6.890 | 19452.4 |
| 409 | 2025-09-27 01:05:51 | subtype | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 408 | 2025-09-26 13:24:14 | subtype | 3 | 134027 | 66 | 6.750 | 19855.9 |
| 407 | 2025-09-26 09:04:36 | subtype | 1 | 69583 | 2 | 2.076 | 33517.8 |
| 406 | 2025-09-25 00:41:18 | subtype | 4 | 151207 | 706 | 61.973 | 2439.9 |
| 405 | 2025-09-25 00:41:09 | subtype | 4 | 151207 | 706 | 57.846 | 2614.0 |
| 404 | 2025-09-25 00:40:54 | subtype | 4 | 151207 | 706 | 68.350 | 2212.2 |
| 403 | 2025-09-25 00:41:01 | subtype | 4 | 151207 | 706 | 37.190 | 4065.8 |
| 402 | 2025-09-24 06:08:12 | subtype | 4 | 151207 | 706 | 10.673 | 14167.2 |
| 401 | 2025-09-19 12:24:37 | subtype | 2 | 107671 | 5 | 3.140 | 34290.1 |
| 400 | 2025-09-18 23:26:37 | subtype | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 399 | 2025-09-18 15:00:40 | subtype | 4 | 151207 | 706 | 13.826 | 10936.4 |
| 398 | 2025-09-18 02:23:12 | subtype | 1 | 69583 | 2 | 1.750 | 39761.7 |
| 397 | 2025-09-16 17:40:58 | subtype | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 396 | 2025-09-15 22:35:32 | subtype | 2 | 107671 | 5 | 3.376 | 31893.1 |
| 395 | 2025-09-13 23:42:51 | subtype | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 394 | 2025-09-10 12:19:08 | subtype | 4 | 151207 | 706 | 10.483 | 14424.0 |
| 393 | 2025-09-10 11:00:17 | subtype | 3 | 134027 | 66 | 7.890 | 16986.9 |
| 392 | 2025-09-10 05:50:02 | subtype | 2 | 107671 | 5 | 5.970 | 18035.3 |
| 391 | 2025-09-09 16:20:26 | subtype | 1 | 69583 | 2 | 1.123 | 61961.7 |
| 390 | 2025-09-09 02:15:10 | subtype | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 389 | 2025-09-08 23:36:00 | subtype | 3 | 134027 | 66 | 6.500 | 20619.5 |
| 388 | 2025-09-08 08:27:06 | subtype | 4 | 151207 | 706 | 10.373 | 14577.0 |
| 387 | 2025-09-08 08:11:10 | subtype | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 386 | 2025-09-07 20:48:09 | subtype | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 385 | 2025-09-03 16:45:43 | subtype | 1 | 69583 | 2 | 1.123 | 61961.7 |
| 384 | 2025-09-01 06:04:20 | subtype | 4 | 151207 | 706 | 11.220 | 13476.6 |
| 383 | 2025-09-01 02:12:50 | subtype | 1 | 69583 | 2 | 1.360 | 51164.0 |
| 382 | 2025-08-31 13:40:43 | subtype | 4 | 151207 | 706 | 10.533 | 14355.5 |
| 381 | 2025-08-28 13:07:23 | subtype | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 380 | 2025-08-28 00:27:28 | subtype | 1 | 69583 | 2 | 1.110 | 62687.4 |
| 379 | 2025-08-27 20:04:09 | subtype | 4 | 151207 | 706 | 55.096 | 2744.4 |
| 378 | 2025-08-27 19:02:57 | subtype | 4 | 151207 | 706 | 11.453 | 13202.4 |
| 377 | 2025-08-25 21:24:01 | subtype | 2 | 107671 | 5 | 7.563 | 14236.5 |
| 376 | 2025-08-25 06:03:37 | subtype | 4 | 151207 | 706 | 61.800 | 2446.7 |
| 375 | 2025-08-24 03:31:05 | subtype | 4 | 151207 | 706 | 11.673 | 12953.6 |
| 374 | 2025-08-24 01:59:36 | subtype | 3 | 134027 | 66 | 6.390 | 20974.5 |
| 373 | 2025-08-23 21:57:34 | subtype | 1 | 69583 | 2 | 1.373 | 50679.5 |
| 372 | 2025-08-21 04:05:08 | subtype | 3 | 134027 | 66 | 17.076 | 7848.9 |
| 371 | 2025-08-19 16:54:29 | subtype | 3 | 134027 | 66 | 30.443 | 4402.6 |
| 370 | 2025-08-18 12:35:03 | subtype | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 369 | 2025-08-17 22:18:21 | subtype | 3 | 134027 | 66 | 21.190 | 6325.0 |
| 368 | 2025-08-15 16:10:22 | subtype | 3 | 134027 | 66 | 15.173 | 8833.3 |
| 367 | 2025-08-14 23:56:34 | subtype | 2 | 107671 | 5 | 15.216 | 7076.2 |
| 366 | 2025-08-14 01:40:11 | subtype | 1 | 69583 | 2 | 1.110 | 62687.4 |
| 365 | 2025-08-12 12:48:49 | subtype | 4 | 151207 | 706 | 41.993 | 3600.8 |
| 364 | 2025-08-11 13:53:04 | subtype | 1 | 69583 | 2 | 2.563 | 27149.0 |
| 363 | 2025-08-10 12:08:29 | subtype | 1 | 69583 | 2 | 3.110 | 22374.0 |
| 362 | 2025-08-07 20:16:29 | subtype | 4 | 151207 | 706 | 58.906 | 2566.9 |
| 361 | 2025-08-07 16:40:49 | subtype | 1 | 69583 | 2 | 5.106 | 13627.7 |
| 360 | 2025-08-03 06:08:50 | subtype | 4 | 151207 | 706 | 55.753 | 2712.1 |
| 359 | 2025-08-02 23:35:52 | subtype | 4 | 151207 | 706 | 28.940 | 5224.8 |
| 358 | 2025-07-30 06:28:14 | subtype | 4 | 151207 | 706 | 27.906 | 5418.4 |
| 357 | 2025-07-24 12:34:57 | subtype | 1 | 69583 | 2 | 2.860 | 24329.7 |
| 356 | 2025-07-24 02:22:19 | subtype | 1 | 69583 | 2 | 4.623 | 15051.5 |
| 355 | 2025-07-23 11:13:20 | subtype | 1 | 69583 | 2 | 6.220 | 11187.0 |
| 354 | 2025-07-21 06:42:05 | subtype | 4 | 151207 | 706 | 10.390 | 14553.1 |
| 353 | 2025-07-20 22:08:14 | subtype | 4 | 151207 | 706 | 21.190 | 7135.8 |
| 352 | 2025-07-20 16:56:36 | subtype | 4 | 151207 | 706 | 12.563 | 12035.9 |
| 351 | 2025-07-19 14:07:09 | subtype | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 350 | 2025-07-19 07:36:38 | subtype | 4 | 151207 | 706 | 11.736 | 12884.0 |
| 349 | 2025-07-17 09:10:11 | subtype | 2 | 107671 | 5 | 13.266 | 8116.3 |
| 348 | 2025-07-16 14:18:39 | subtype | 4 | 151207 | 706 | 51.193 | 2953.7 |
| 347 | 2025-07-14 16:56:51 | subtype | 1 | 69583 | 2 | 9.153 | 7602.2 |
| 346 | 2025-07-11 13:08:46 | subtype | 4 | 151207 | 706 | 46.720 | 3236.5 |
| 345 | 2025-07-10 11:35:03 | subtype | 1 | 69583 | 2 | 1.640 | 42428.7 |
| 344 | 2025-07-07 12:31:34 | subtype | 1 | 69583 | 2 | 4.250 | 16372.5 |
| 343 | 2025-07-06 01:10:45 | subtype | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 342 | 2025-06-27 10:35:30 | subtype | 2 | 107671 | 5 | 14.033 | 7672.7 |
| 341 | 2025-06-25 17:32:08 | subtype | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 340 | 2025-06-21 15:11:50 | subtype | 3 | 134027 | 66 | 24.173 | 5544.5 |
| 339 | 2025-06-20 01:23:09 | subtype | 3 | 134027 | 66 | 22.046 | 6079.4 |