History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shairns"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 421 | 2025-10-18 04:49:40 | shairns | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 420 | 2025-09-19 00:34:19 | shairns | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 419 | 2025-09-06 18:39:09 | shairns | 1 | 69583 | 4 | 1.470 | 47335.4 |
| 418 | 2025-08-24 20:04:16 | shairns | 1 | 69583 | 4 | 4.343 | 16021.9 |
| 417 | 2025-08-24 11:15:30 | shairns | 2 | 107671 | 33 | 3.500 | 30763.1 |
| 416 | 2025-08-22 20:38:26 | shairns | 1 | 69583 | 4 | 6.030 | 11539.5 |
| 415 | 2025-08-10 23:31:12 | shairns | 1 | 69583 | 4 | 5.906 | 11781.7 |
| 414 | 2025-08-03 11:07:15 | shairns | 1 | 69583 | 4 | 6.156 | 11303.3 |
| 413 | 2025-08-03 02:40:01 | shairns | 1 | 69583 | 4 | 6.000 | 11597.2 |
| 412 | 2025-08-01 02:08:50 | shairns | 1 | 69583 | 4 | 3.063 | 22717.3 |
| 411 | 2025-07-30 23:12:15 | shairns | 1 | 69583 | 4 | 6.406 | 10862.2 |
| 410 | 2025-07-24 17:08:06 | shairns | 1 | 69583 | 4 | 4.156 | 16742.8 |
| 409 | 2025-07-24 09:29:04 | shairns | 1 | 69583 | 4 | 7.920 | 8785.7 |
| 408 | 2025-07-23 18:37:32 | shairns | 1 | 69583 | 4 | 3.423 | 20328.1 |
| 407 | 2025-07-23 07:21:24 | shairns | 1 | 69583 | 4 | 5.390 | 12909.6 |
| 406 | 2025-07-23 04:42:25 | shairns | 1 | 69583 | 4 | 2.703 | 25742.9 |
| 405 | 2025-07-22 22:14:54 | shairns | 1 | 69583 | 4 | 2.860 | 24329.7 |
| 404 | 2025-07-18 15:34:28 | shairns | 3 | 134027 | 416 | 25.986 | 5157.7 |
| 403 | 2025-07-18 07:53:14 | shairns | 3 | 134027 | 416 | 38.113 | 3516.6 |
| 402 | 2025-07-16 14:08:59 | shairns | 3 | 134027 | 416 | 33.580 | 3991.3 |
| 401 | 2025-07-16 10:12:54 | shairns | 1 | 69583 | 4 | 3.076 | 22621.3 |
| 400 | 2025-07-15 13:55:40 | shairns | 3 | 134027 | 416 | 27.280 | 4913.0 |
| 399 | 2025-07-12 08:36:16 | shairns | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 398 | 2025-07-10 21:33:38 | shairns | 1 | 69583 | 4 | 2.956 | 23539.6 |
| 397 | 2025-07-07 04:50:19 | shairns | 2 | 107671 | 33 | 20.486 | 5255.8 |
| 396 | 2025-06-30 12:37:24 | shairns | 1 | 69583 | 4 | 6.233 | 11163.6 |
| 395 | 2025-06-30 00:37:47 | shairns | 1 | 69583 | 4 | 9.440 | 7371.1 |
| 394 | 2025-06-25 09:16:43 | shairns | 3 | 134027 | 416 | 35.720 | 3752.2 |
| 393 | 2025-06-23 20:15:06 | shairns | 2 | 107671 | 33 | 14.716 | 7316.6 |
| 392 | 2025-06-21 20:35:07 | shairns | 1 | 69583 | 4 | 4.093 | 17000.5 |
| 391 | 2025-06-15 14:58:02 | shairns | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 390 | 2025-06-13 21:57:59 | shairns | 1 | 69583 | 4 | 6.470 | 10754.7 |
| 389 | 2025-06-13 05:55:56 | shairns | 1 | 69583 | 4 | 2.783 | 25002.9 |
| 388 | 2025-06-06 20:54:23 | shairns | 3 | 134027 | 416 | 6.313 | 21230.3 |
| 387 | 2025-05-27 00:08:45 | shairns | 1 | 69583 | 4 | 5.703 | 12201.1 |
| 386 | 2025-05-21 20:47:16 | shairns | 1 | 69583 | 4 | 2.826 | 24622.4 |
| 385 | 2025-05-20 11:25:28 | shairns | 1 | 69583 | 4 | 4.016 | 17326.4 |
| 384 | 2025-05-11 23:27:27 | shairns | 3 | 134027 | 416 | 21.146 | 6338.2 |
| 383 | 2025-05-11 21:50:42 | shairns | 1 | 69583 | 4 | 5.833 | 11929.2 |
| 382 | 2025-05-07 08:51:55 | shairns | 2 | 107671 | 33 | 3.360 | 32044.9 |
| 381 | 2025-04-30 17:48:53 | shairns | 1 | 69583 | 4 | 2.406 | 28920.6 |
| 380 | 2025-04-28 10:51:53 | shairns | 1 | 69583 | 4 | 5.220 | 13330.1 |
| 379 | 2025-04-28 02:08:11 | shairns | 1 | 69583 | 4 | 2.983 | 23326.5 |
| 378 | 2025-04-25 10:38:38 | shairns | 2 | 107671 | 33 | 3.403 | 31640.0 |
| 377 | 2025-04-20 20:43:37 | shairns | 1 | 69583 | 4 | 7.110 | 9786.6 |
| 376 | 2025-04-16 11:28:19 | shairns | 1 | 69583 | 4 | 2.470 | 28171.3 |
| 375 | 2025-04-16 01:07:19 | shairns | 3 | 134027 | 416 | 29.460 | 4549.5 |
| 374 | 2025-04-15 22:10:23 | shairns | 1 | 69583 | 4 | 6.390 | 10889.4 |
| 373 | 2025-04-14 21:51:42 | shairns | 3 | 134027 | 416 | 51.456 | 2604.7 |
| 372 | 2025-04-13 05:00:02 | shairns | 3 | 134027 | 416 | 7.046 | 19021.7 |
| 371 | 2025-04-09 05:41:52 | shairns | 3 | 134027 | 416 | 34.580 | 3875.9 |
| 370 | 2025-04-09 02:57:49 | shairns | 2 | 107671 | 33 | 25.800 | 4173.3 |
| 369 | 2025-04-08 14:36:00 | shairns | 3 | 134027 | 416 | 17.953 | 7465.4 |
| 368 | 2025-04-08 07:56:34 | shairns | 2 | 107671 | 33 | 12.733 | 8456.1 |
| 367 | 2025-04-08 05:21:02 | shairns | 1 | 69583 | 4 | 2.860 | 24329.7 |
| 366 | 2025-04-07 10:13:21 | shairns | 3 | 134027 | 416 | 31.440 | 4262.9 |
| 365 | 2025-04-07 03:51:57 | shairns | 2 | 107671 | 33 | 15.750 | 6836.3 |
| 364 | 2025-04-05 20:39:51 | shairns | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 363 | 2025-04-02 06:03:49 | shairns | 1 | 69583 | 4 | 5.140 | 13537.5 |
| 362 | 2025-03-19 21:51:08 | shairns | 1 | 69583 | 4 | 3.893 | 17873.9 |
| 361 | 2025-03-17 12:34:54 | shairns | 1 | 69583 | 4 | 2.610 | 26660.2 |
| 360 | 2025-03-16 19:52:46 | shairns | 2 | 107671 | 33 | 15.966 | 6743.8 |
| 359 | 2025-03-16 19:52:32 | shairns | 1 | 69583 | 4 | 3.720 | 18705.1 |
| 358 | 2025-03-16 12:38:17 | shairns | 3 | 134027 | 416 | 30.676 | 4369.1 |
| 357 | 2025-03-16 10:52:15 | shairns | 3 | 134027 | 416 | 35.313 | 3795.4 |
| 356 | 2025-03-15 19:08:07 | shairns | 2 | 107671 | 33 | 8.860 | 12152.5 |
| 355 | 2025-03-15 19:07:58 | shairns | 1 | 69583 | 4 | 2.906 | 23944.6 |
| 354 | 2025-03-13 18:26:51 | shairns | 1 | 69583 | 4 | 4.126 | 16864.5 |
| 353 | 2025-03-13 10:39:49 | shairns | 1 | 69583 | 4 | 13.983 | 4976.3 |
| 352 | 2025-03-12 22:51:04 | shairns | 1 | 69583 | 4 | 8.016 | 8680.5 |
| 351 | 2025-03-03 00:26:58 | shairns | 1 | 69583 | 4 | 2.796 | 24886.6 |
| 350 | 2025-02-26 05:27:35 | shairns | 3 | 134027 | 416 | 31.113 | 4307.7 |
| 349 | 2025-02-26 02:53:20 | shairns | 3 | 134027 | 416 | 38.193 | 3509.2 |
| 348 | 2025-02-26 02:40:34 | shairns | 3 | 134027 | 416 | 39.800 | 3367.5 |
| 347 | 2025-02-25 21:06:45 | shairns | 3 | 134027 | 416 | 29.140 | 4599.4 |
| 346 | 2025-02-25 04:53:57 | shairns | 1 | 69583 | 4 | 5.970 | 11655.4 |
| 345 | 2025-02-17 00:36:32 | shairns | 2 | 107671 | 33 | 12.686 | 8487.4 |
| 344 | 2025-02-14 20:20:31 | shairns | 3 | 134027 | 416 | 36.533 | 3668.7 |
| 343 | 2025-02-14 19:20:17 | shairns | 3 | 134027 | 416 | 16.376 | 8184.4 |
| 342 | 2025-02-09 00:34:42 | shairns | 1 | 69583 | 4 | 6.060 | 11482.3 |
| 341 | 2025-01-26 08:26:39 | shairns | 3 | 134027 | 416 | 31.720 | 4225.3 |
| 340 | 2025-01-25 02:26:12 | shairns | 3 | 134027 | 416 | 30.346 | 4416.6 |
| 339 | 2025-01-25 02:26:12 | shairns | 2 | 107671 | 33 | 17.033 | 6321.3 |
| 338 | 2025-01-24 17:05:59 | shairns | 3 | 134027 | 416 | 33.423 | 4010.0 |
| 337 | 2025-01-24 17:05:56 | shairns | 2 | 107671 | 33 | 20.266 | 5312.9 |
| 336 | 2025-01-24 17:05:45 | shairns | 1 | 69583 | 4 | 7.453 | 9336.2 |
| 335 | 2025-01-24 09:20:25 | shairns | 1 | 69583 | 4 | 5.546 | 12546.5 |
| 334 | 2025-01-18 08:19:39 | shairns | 1 | 69583 | 4 | 3.250 | 21410.2 |
| 333 | 2025-01-09 04:32:09 | shairns | 1 | 69583 | 4 | 3.330 | 20895.8 |
| 332 | 2024-12-13 07:29:19 | shairns | 1 | 69583 | 4 | 5.983 | 11630.1 |
| 331 | 2024-12-09 16:45:14 | shairns | 1 | 69583 | 4 | 7.156 | 9723.7 |
| 330 | 2024-11-27 10:06:50 | shairns | 3 | 134027 | 416 | 35.003 | 3829.0 |
| 329 | 2024-11-27 09:46:55 | shairns | 2 | 107671 | 33 | 12.673 | 8496.1 |
| 328 | 2024-11-27 09:04:28 | shairns | 3 | 134027 | 416 | 6.580 | 20368.8 |
| 327 | 2024-11-20 20:34:23 | shairns | 3 | 134027 | 416 | 17.203 | 7790.9 |
| 326 | 2024-11-20 20:34:24 | shairns | 2 | 107671 | 33 | 15.266 | 7053.0 |
| 325 | 2024-11-20 20:34:16 | shairns | 1 | 69583 | 4 | 5.690 | 12229.0 |
| 324 | 2024-11-09 11:25:34 | shairns | 1 | 69583 | 4 | 2.956 | 23539.6 |
| 323 | 2024-11-09 10:30:46 | shairns | 1 | 69583 | 4 | 5.733 | 12137.3 |
| 322 | 2024-11-08 20:20:58 | shairns | 1 | 69583 | 4 | 6.000 | 11597.2 |