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 |
| 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 |
| 338 | 2025-06-18 16:41:41 | subtype | 3 | 134027 | 66 | 35.893 | 3734.1 |
| 337 | 2025-06-14 21:10:02 | subtype | 3 | 134027 | 66 | 44.550 | 3008.5 |
| 336 | 2025-06-08 09:42:23 | subtype | 3 | 134027 | 66 | 37.566 | 3567.8 |
| 335 | 2025-06-08 06:49:22 | subtype | 1 | 69583 | 2 | 3.030 | 22964.7 |
| 334 | 2025-06-07 14:51:21 | subtype | 3 | 134027 | 66 | 24.076 | 5566.8 |
| 333 | 2025-06-06 23:01:01 | subtype | 1 | 69583 | 2 | 3.656 | 19032.5 |
| 332 | 2025-06-06 04:14:52 | subtype | 2 | 107671 | 5 | 16.670 | 6459.0 |
| 331 | 2025-06-05 12:08:31 | subtype | 3 | 134027 | 66 | 8.780 | 15265.0 |
| 330 | 2025-06-04 01:18:12 | subtype | 1 | 69583 | 2 | 5.686 | 12237.6 |
| 329 | 2025-06-02 10:32:38 | subtype | 3 | 134027 | 66 | 52.643 | 2546.0 |
| 328 | 2025-05-30 11:48:06 | subtype | 1 | 69583 | 2 | 3.063 | 22717.3 |
| 327 | 2025-05-27 16:31:02 | subtype | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 326 | 2025-05-25 11:31:36 | subtype | 4 | 151207 | 706 | 25.470 | 5936.7 |
| 325 | 2025-05-25 05:04:51 | subtype | 4 | 151207 | 706 | 29.440 | 5136.1 |
| 324 | 2025-05-24 05:41:10 | subtype | 4 | 151207 | 706 | 47.923 | 3155.2 |