History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spectra"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 467 | 2026-01-03 00:22:20 | spectra | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 466 | 2026-01-01 23:49:00 | spectra | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 465 | 2025-12-29 19:36:19 | spectra | 3 | 134027 | 96 | 7.610 | 17612.0 |
| 464 | 2025-12-24 21:28:43 | spectra | 3 | 134027 | 96 | 9.940 | 13483.6 |
| 463 | 2025-12-15 08:11:25 | spectra | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 462 | 2025-12-05 20:57:39 | spectra | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 461 | 2025-11-30 17:41:55 | spectra | 2 | 107671 | 9 | 3.076 | 35003.6 |
| 460 | 2025-11-30 10:17:46 | spectra | 4 | 151207 | 1030 | 10.640 | 14211.2 |
| 459 | 2025-11-30 04:31:13 | spectra | 2 | 107671 | 9 | 3.766 | 28590.3 |
| 458 | 2025-11-14 22:08:16 | spectra | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 457 | 2025-11-12 22:03:45 | spectra | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 456 | 2025-11-11 23:33:54 | spectra | 4 | 151207 | 1030 | 10.843 | 13945.1 |
| 455 | 2025-10-24 12:35:28 | spectra | 4 | 151207 | 1030 | 11.410 | 13252.1 |
| 454 | 2025-10-23 22:47:53 | spectra | 4 | 151207 | 1030 | 10.623 | 14233.9 |
| 453 | 2025-10-12 00:08:44 | spectra | 2 | 107671 | 9 | 3.203 | 33615.7 |
| 452 | 2025-10-04 12:08:47 | spectra | 4 | 151207 | 1030 | 11.906 | 12700.1 |
| 451 | 2025-10-04 02:58:37 | spectra | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 450 | 2025-10-03 14:35:29 | spectra | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 449 | 2025-09-30 20:05:28 | spectra | 4 | 151207 | 1030 | 20.970 | 7210.6 |
| 448 | 2025-09-26 05:32:36 | spectra | 4 | 151207 | 1030 | 17.423 | 8678.6 |
| 447 | 2025-09-25 10:56:50 | spectra | 3 | 134027 | 96 | 25.986 | 5157.7 |
| 446 | 2025-09-25 10:56:40 | spectra | 3 | 134027 | 96 | 18.733 | 7154.6 |
| 445 | 2025-09-25 10:56:19 | spectra | 3 | 134027 | 96 | 37.706 | 3554.5 |
| 444 | 2025-09-25 10:56:25 | spectra | 3 | 134027 | 96 | 28.736 | 4664.1 |
| 443 | 2025-09-23 11:30:58 | spectra | 3 | 134027 | 96 | 6.453 | 20769.7 |
| 442 | 2025-09-10 11:24:42 | spectra | 4 | 151207 | 1030 | 10.923 | 13843.0 |
| 441 | 2025-09-10 11:24:32 | spectra | 3 | 134027 | 96 | 6.046 | 22167.9 |
| 440 | 2025-09-07 20:00:51 | spectra | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 439 | 2025-08-30 03:13:43 | spectra | 3 | 134027 | 96 | 13.656 | 9814.5 |
| 438 | 2025-08-28 23:57:39 | spectra | 4 | 151207 | 1030 | 12.250 | 12343.4 |
| 437 | 2025-08-28 14:12:44 | spectra | 3 | 134027 | 96 | 7.733 | 17331.8 |
| 436 | 2025-08-25 16:08:18 | spectra | 3 | 134027 | 96 | 38.816 | 3452.9 |
| 435 | 2025-08-24 06:16:36 | spectra | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 434 | 2025-08-22 20:48:46 | spectra | 3 | 134027 | 96 | 37.220 | 3600.9 |
| 433 | 2025-08-19 14:48:54 | spectra | 1 | 69583 | 3 | 2.720 | 25582.0 |
| 432 | 2025-08-19 06:25:51 | spectra | 1 | 69583 | 3 | 2.903 | 23969.3 |
| 431 | 2025-08-16 06:08:17 | spectra | 3 | 134027 | 96 | 11.173 | 11995.6 |
| 430 | 2025-08-15 20:48:44 | spectra | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 429 | 2025-08-15 13:06:39 | spectra | 4 | 151207 | 1030 | 56.003 | 2700.0 |
| 428 | 2025-08-09 15:33:19 | spectra | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 427 | 2025-08-06 21:58:53 | spectra | 3 | 134027 | 96 | 25.783 | 5198.3 |
| 426 | 2025-08-05 06:48:34 | spectra | 4 | 151207 | 1030 | 29.046 | 5205.8 |
| 425 | 2025-08-04 14:57:12 | spectra | 4 | 151207 | 1030 | 51.096 | 2959.3 |
| 424 | 2025-08-04 11:20:16 | spectra | 4 | 151207 | 1030 | 74.333 | 2034.2 |
| 423 | 2025-08-04 01:36:36 | spectra | 4 | 151207 | 1030 | 35.610 | 4246.2 |
| 422 | 2025-08-04 00:12:54 | spectra | 4 | 151207 | 1030 | 32.686 | 4626.0 |
| 421 | 2025-08-03 09:57:29 | spectra | 4 | 151207 | 1030 | 55.020 | 2748.2 |
| 420 | 2025-08-03 02:06:44 | spectra | 2 | 107671 | 9 | 19.360 | 5561.5 |
| 419 | 2025-08-03 02:03:34 | spectra | 3 | 134027 | 96 | 24.623 | 5443.2 |
| 418 | 2025-08-01 19:35:13 | spectra | 1 | 69583 | 3 | 7.393 | 9412.0 |
| 417 | 2025-07-31 00:49:17 | spectra | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 416 | 2025-07-27 03:29:43 | spectra | 1 | 69583 | 3 | 2.123 | 32775.8 |
| 415 | 2025-07-27 01:19:31 | spectra | 3 | 134027 | 96 | 16.270 | 8237.7 |
| 414 | 2025-07-26 23:25:52 | spectra | 2 | 107671 | 9 | 8.283 | 12999.0 |
| 413 | 2025-07-26 23:23:39 | spectra | 3 | 134027 | 96 | 16.936 | 7913.7 |
| 412 | 2025-07-26 21:29:50 | spectra | 3 | 134027 | 96 | 18.376 | 7293.6 |
| 411 | 2025-07-24 17:24:28 | spectra | 3 | 134027 | 96 | 34.860 | 3844.7 |
| 410 | 2025-07-22 09:32:44 | spectra | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 409 | 2025-07-20 18:20:47 | spectra | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 408 | 2025-07-19 01:41:54 | spectra | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 407 | 2025-07-14 14:03:15 | spectra | 2 | 107671 | 9 | 20.593 | 5228.5 |
| 406 | 2025-07-13 20:25:05 | spectra | 3 | 134027 | 96 | 33.406 | 4012.1 |
| 405 | 2025-07-13 07:05:48 | spectra | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 404 | 2025-06-30 18:14:22 | spectra | 1 | 69583 | 3 | 6.516 | 10678.8 |
| 403 | 2025-06-24 02:58:04 | spectra | 1 | 69583 | 3 | 5.923 | 11747.9 |
| 402 | 2025-06-22 02:34:28 | spectra | 3 | 134027 | 96 | 29.976 | 4471.1 |
| 401 | 2025-06-17 00:12:11 | spectra | 3 | 134027 | 96 | 22.860 | 5862.9 |
| 400 | 2025-06-16 15:58:40 | spectra | 1 | 69583 | 3 | 10.313 | 6747.1 |
| 399 | 2025-06-14 12:52:11 | spectra | 4 | 151207 | 1030 | 61.706 | 2450.4 |
| 398 | 2025-06-14 11:05:05 | spectra | 4 | 151207 | 1030 | 75.266 | 2009.0 |
| 397 | 2025-06-14 10:20:44 | spectra | 3 | 134027 | 96 | 23.296 | 5753.2 |
| 396 | 2025-06-14 05:49:41 | spectra | 4 | 151207 | 1030 | 64.190 | 2355.6 |
| 395 | 2025-06-12 15:34:37 | spectra | 3 | 134027 | 96 | 22.906 | 5851.2 |
| 394 | 2025-06-12 13:35:50 | spectra | 2 | 107671 | 9 | 14.580 | 7384.8 |
| 393 | 2025-06-12 06:30:33 | spectra | 1 | 69583 | 3 | 5.986 | 11624.3 |
| 392 | 2025-06-11 23:48:12 | spectra | 4 | 151207 | 1030 | 44.220 | 3419.4 |
| 391 | 2025-06-11 14:02:26 | spectra | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 390 | 2025-06-10 07:47:37 | spectra | 1 | 69583 | 3 | 3.153 | 22068.8 |
| 389 | 2025-06-07 04:04:56 | spectra | 1 | 69583 | 3 | 6.080 | 11444.6 |
| 388 | 2025-06-07 01:21:37 | spectra | 2 | 107671 | 9 | 9.873 | 10905.6 |
| 387 | 2025-05-24 03:08:34 | spectra | 1 | 69583 | 3 | 4.063 | 17126.0 |
| 386 | 2025-05-09 23:56:08 | spectra | 3 | 134027 | 96 | 20.030 | 6691.3 |
| 385 | 2025-05-09 14:28:19 | spectra | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 384 | 2025-05-09 07:42:37 | spectra | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 383 | 2025-05-06 17:41:16 | spectra | 1 | 69583 | 3 | 2.780 | 25029.9 |
| 382 | 2025-05-03 16:49:18 | spectra | 2 | 107671 | 9 | 3.280 | 32826.5 |
| 381 | 2025-05-01 08:28:30 | spectra | 2 | 107671 | 9 | 3.406 | 31612.2 |
| 380 | 2025-04-23 01:40:13 | spectra | 1 | 69583 | 3 | 8.876 | 7839.5 |
| 379 | 2025-04-22 20:10:38 | spectra | 3 | 134027 | 96 | 36.046 | 3718.2 |
| 378 | 2025-04-21 00:10:02 | spectra | 3 | 134027 | 96 | 35.673 | 3757.1 |
| 377 | 2025-04-20 20:12:04 | spectra | 3 | 134027 | 96 | 42.660 | 3141.7 |
| 376 | 2025-04-20 08:51:08 | spectra | 3 | 134027 | 96 | 15.393 | 8707.0 |
| 375 | 2025-04-19 00:50:01 | spectra | 3 | 134027 | 96 | 6.530 | 20524.8 |
| 374 | 2025-04-11 15:17:35 | spectra | 1 | 69583 | 3 | 3.610 | 19275.1 |
| 373 | 2025-04-09 14:25:18 | spectra | 1 | 69583 | 3 | 5.593 | 12441.1 |
| 372 | 2025-03-30 21:02:36 | spectra | 3 | 134027 | 96 | 33.146 | 4043.5 |
| 371 | 2025-03-29 19:51:17 | spectra | 1 | 69583 | 3 | 9.093 | 7652.4 |
| 370 | 2025-03-23 18:27:41 | spectra | 2 | 107671 | 9 | 11.420 | 9428.3 |
| 369 | 2025-03-22 21:26:48 | spectra | 3 | 134027 | 96 | 34.813 | 3849.9 |
| 368 | 2025-03-22 02:29:03 | spectra | 1 | 69583 | 3 | 1.233 | 56433.9 |