History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"surnames"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 402 | 2025-12-11 16:05:12 | surnames | 3 | 146162 | 119 | 7.343 | 19904.9 |
| 401 | 2025-12-11 05:03:47 | surnames | 1 | 82945 | 5 | 2.610 | 31779.7 |
| 400 | 2025-12-10 06:18:03 | surnames | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 399 | 2025-12-09 21:44:01 | surnames | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 398 | 2025-12-08 20:00:34 | surnames | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 397 | 2025-12-07 08:01:10 | surnames | 1 | 82945 | 5 | 2.016 | 41143.4 |
| 396 | 2025-12-06 17:17:13 | surnames | 2 | 121059 | 10 | 3.813 | 31749.0 |
| 395 | 2025-12-06 05:46:14 | surnames | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 394 | 2025-12-02 00:51:20 | surnames | 1 | 82945 | 5 | 1.580 | 52496.8 |
| 393 | 2025-11-28 13:13:40 | surnames | 1 | 82945 | 5 | 2.326 | 35659.9 |
| 392 | 2025-11-28 01:15:52 | surnames | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 391 | 2025-11-10 05:20:16 | surnames | 1 | 82945 | 5 | 1.580 | 52496.8 |
| 390 | 2025-11-07 21:30:22 | surnames | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 389 | 2025-11-07 05:35:40 | surnames | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 388 | 2025-11-04 17:51:08 | surnames | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 387 | 2025-10-29 01:32:29 | surnames | 1 | 82945 | 5 | 5.796 | 14310.7 |
| 386 | 2025-10-28 02:40:27 | surnames | 1 | 82945 | 5 | 1.610 | 51518.6 |
| 385 | 2025-10-07 20:59:41 | surnames | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 384 | 2025-10-06 23:08:17 | surnames | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 383 | 2025-10-06 09:03:11 | surnames | 1 | 82945 | 5 | 1.513 | 54821.5 |
| 382 | 2025-10-01 21:07:44 | surnames | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 381 | 2025-09-30 02:27:29 | surnames | 2 | 121059 | 10 | 3.453 | 35059.1 |
| 380 | 2025-09-28 07:14:56 | surnames | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 379 | 2025-09-28 07:08:18 | surnames | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 378 | 2025-09-28 06:33:33 | surnames | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 377 | 2025-09-27 02:59:07 | surnames | 1 | 82945 | 5 | 1.576 | 52630.1 |
| 376 | 2025-09-26 14:10:38 | surnames | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 375 | 2025-09-14 19:46:55 | surnames | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 374 | 2025-09-08 01:06:46 | surnames | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 373 | 2025-09-05 22:39:44 | surnames | 1 | 82945 | 5 | 3.110 | 26670.4 |
| 372 | 2025-09-05 19:16:30 | surnames | 1 | 82945 | 5 | 1.513 | 54821.5 |
| 371 | 2025-08-28 06:07:06 | surnames | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 370 | 2025-08-27 18:28:08 | surnames | 2 | 121059 | 10 | 4.423 | 27370.3 |
| 369 | 2025-08-25 20:04:06 | surnames | 1 | 82945 | 5 | 3.203 | 25896.0 |
| 368 | 2025-08-25 06:51:12 | surnames | 1 | 82945 | 5 | 8.093 | 10249.0 |
| 367 | 2025-08-15 09:46:28 | surnames | 1 | 82945 | 5 | 3.423 | 24231.7 |
| 366 | 2025-08-11 22:08:52 | surnames | 1 | 82945 | 5 | 6.360 | 13041.7 |
| 365 | 2025-08-01 01:48:29 | surnames | 1 | 82945 | 5 | 3.610 | 22976.5 |
| 364 | 2025-07-27 15:20:27 | surnames | 3 | 146162 | 119 | 19.456 | 7512.4 |
| 363 | 2025-07-27 04:55:57 | surnames | 1 | 82945 | 5 | 7.626 | 10876.6 |
| 362 | 2025-07-20 11:24:02 | surnames | 3 | 146162 | 119 | 7.393 | 19770.3 |
| 361 | 2025-07-13 09:44:27 | surnames | 1 | 82945 | 5 | 3.890 | 21322.6 |
| 360 | 2025-07-13 04:19:59 | surnames | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 359 | 2025-07-11 02:35:15 | surnames | 1 | 82945 | 5 | 3.466 | 23931.0 |
| 358 | 2025-07-10 18:47:01 | surnames | 1 | 82945 | 5 | 6.953 | 11929.4 |
| 357 | 2025-07-10 18:11:29 | surnames | 3 | 146162 | 119 | 52.706 | 2773.2 |
| 356 | 2025-07-10 15:14:52 | surnames | 2 | 121059 | 10 | 12.673 | 9552.5 |
| 355 | 2025-07-09 09:12:35 | surnames | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 354 | 2025-07-01 21:59:38 | surnames | 1 | 82945 | 5 | 8.953 | 9264.5 |
| 353 | 2025-06-26 08:34:36 | surnames | 1 | 82945 | 5 | 6.033 | 13748.5 |
| 352 | 2025-06-26 04:17:45 | surnames | 1 | 82945 | 5 | 5.186 | 15994.0 |
| 351 | 2025-06-26 00:10:20 | surnames | 1 | 82945 | 5 | 3.970 | 20892.9 |
| 350 | 2025-06-20 09:30:37 | surnames | 1 | 82945 | 5 | 7.530 | 11015.3 |
| 349 | 2025-06-15 14:19:52 | surnames | 1 | 82945 | 5 | 1.576 | 52630.1 |
| 348 | 2025-06-12 12:13:41 | surnames | 2 | 121059 | 10 | 19.626 | 6168.3 |
| 347 | 2025-06-09 21:27:00 | surnames | 1 | 82945 | 5 | 5.610 | 14785.2 |
| 346 | 2025-06-08 01:50:34 | surnames | 2 | 121059 | 10 | 24.470 | 4947.2 |
| 345 | 2025-06-07 08:50:58 | surnames | 1 | 82945 | 5 | 6.796 | 12205.0 |
| 344 | 2025-05-31 20:06:15 | surnames | 3 | 146162 | 119 | 58.910 | 2481.1 |
| 343 | 2025-05-27 20:07:55 | surnames | 3 | 146162 | 119 | 7.563 | 19325.9 |
| 342 | 2025-05-23 17:22:39 | surnames | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 341 | 2025-05-20 04:58:18 | surnames | 1 | 82945 | 5 | 7.126 | 11639.8 |
| 340 | 2025-05-18 06:49:59 | surnames | 1 | 82945 | 5 | 6.610 | 12548.4 |
| 339 | 2025-05-18 00:04:14 | surnames | 1 | 82945 | 5 | 8.436 | 9832.3 |
| 338 | 2025-05-16 18:55:45 | surnames | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 337 | 2025-05-12 15:30:39 | surnames | 3 | 146162 | 119 | 32.253 | 4531.7 |
| 336 | 2025-05-08 18:07:57 | surnames | 3 | 146162 | 119 | 38.020 | 3844.3 |
| 335 | 2025-05-08 13:42:29 | surnames | 3 | 146162 | 119 | 32.293 | 4526.1 |
| 334 | 2025-05-07 23:22:48 | surnames | 3 | 146162 | 119 | 43.160 | 3386.5 |
| 333 | 2025-05-06 06:50:13 | surnames | 3 | 146162 | 119 | 50.110 | 2916.8 |
| 332 | 2025-04-29 21:05:09 | surnames | 1 | 82945 | 5 | 4.293 | 19321.0 |
| 331 | 2025-04-28 06:18:31 | surnames | 1 | 82945 | 5 | 5.923 | 14003.9 |
| 330 | 2025-04-20 02:30:34 | surnames | 1 | 82945 | 5 | 6.920 | 11986.3 |
| 329 | 2025-04-18 06:22:30 | surnames | 1 | 82945 | 5 | 9.470 | 8758.7 |
| 328 | 2025-04-15 22:10:07 | surnames | 1 | 82945 | 5 | 9.313 | 8906.4 |
| 327 | 2025-04-13 17:08:11 | surnames | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 326 | 2025-04-11 07:37:34 | surnames | 1 | 82945 | 5 | 7.373 | 11249.8 |
| 325 | 2025-03-23 19:34:38 | surnames | 3 | 146162 | 119 | 48.223 | 3031.0 |
| 324 | 2025-03-20 10:16:43 | surnames | 1 | 82945 | 5 | 10.410 | 7967.8 |
| 323 | 2025-03-19 23:30:40 | surnames | 3 | 146162 | 119 | 30.203 | 4839.3 |
| 322 | 2025-03-18 11:13:59 | surnames | 3 | 146162 | 119 | 40.456 | 3612.9 |
| 321 | 2025-03-16 00:27:36 | surnames | 1 | 82945 | 5 | 3.826 | 21679.3 |
| 320 | 2025-03-12 17:46:32 | surnames | 1 | 82945 | 5 | 5.046 | 16437.8 |
| 319 | 2025-03-11 13:59:58 | surnames | 3 | 146162 | 119 | 39.383 | 3711.3 |
| 318 | 2025-03-03 11:04:47 | surnames | 2 | 121059 | 10 | 24.486 | 4944.0 |
| 317 | 2025-03-03 11:04:49 | surnames | 3 | 146162 | 119 | 19.500 | 7495.5 |
| 316 | 2025-03-03 08:55:01 | surnames | 1 | 82945 | 5 | 6.186 | 13408.5 |
| 315 | 2025-02-12 22:41:35 | surnames | 1 | 82945 | 5 | 5.546 | 14955.8 |
| 314 | 2025-02-12 17:54:01 | surnames | 2 | 121059 | 10 | 12.890 | 9391.7 |
| 313 | 2025-02-12 16:49:45 | surnames | 3 | 146162 | 119 | 7.656 | 19091.2 |
| 312 | 2025-02-08 11:00:18 | surnames | 3 | 146162 | 119 | 21.186 | 6899.0 |
| 311 | 2025-02-07 09:16:06 | surnames | 2 | 121059 | 10 | 23.376 | 5178.8 |
| 310 | 2025-02-06 14:24:37 | surnames | 3 | 146162 | 119 | 33.580 | 4352.7 |
| 309 | 2025-02-06 14:24:51 | surnames | 1 | 82945 | 5 | 3.813 | 21753.2 |
| 308 | 2025-02-06 06:41:20 | surnames | 2 | 121059 | 10 | 3.736 | 32403.4 |
| 307 | 2025-02-06 06:40:25 | surnames | 3 | 146162 | 119 | 7.500 | 19488.3 |
| 306 | 2025-02-04 23:17:35 | surnames | 1 | 82945 | 5 | 7.076 | 11722.0 |
| 305 | 2025-02-04 13:41:41 | surnames | 1 | 82945 | 5 | 8.453 | 9812.5 |
| 304 | 2025-01-25 15:33:28 | surnames | 3 | 146162 | 119 | 29.813 | 4902.6 |
| 303 | 2025-01-06 18:37:43 | surnames | 1 | 82945 | 5 | 7.296 | 11368.6 |