History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spectrum"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 421 | 2025-10-28 06:31:30 | spectrum | 4 | 161609 | 243 | 12.300 | 13138.9 |
| 420 | 2025-10-27 16:24:10 | spectrum | 3 | 146162 | 34 | 7.783 | 18779.6 |
| 419 | 2025-10-26 18:43:16 | spectrum | 1 | 82945 | 2 | 6.220 | 13335.2 |
| 418 | 2025-10-18 15:03:14 | spectrum | 4 | 161609 | 243 | 12.330 | 13107.0 |
| 417 | 2025-10-08 22:43:25 | spectrum | 1 | 82945 | 2 | 1.703 | 48705.2 |
| 416 | 2025-10-03 06:56:22 | spectrum | 4 | 161609 | 243 | 11.563 | 13976.4 |
| 415 | 2025-09-25 13:00:25 | spectrum | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 414 | 2025-09-08 07:05:37 | spectrum | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 413 | 2025-08-18 22:18:17 | spectrum | 1 | 82945 | 2 | 7.283 | 11388.9 |
| 412 | 2025-08-14 16:35:38 | spectrum | 2 | 121059 | 9 | 3.360 | 36029.5 |
| 411 | 2025-08-08 20:53:16 | spectrum | 1 | 82945 | 2 | 7.563 | 10967.2 |
| 410 | 2025-07-23 17:16:14 | spectrum | 1 | 82945 | 2 | 3.813 | 21753.2 |
| 409 | 2025-07-23 10:47:45 | spectrum | 1 | 82945 | 2 | 9.156 | 9059.1 |
| 408 | 2025-07-22 21:59:19 | spectrum | 1 | 82945 | 2 | 4.596 | 18047.2 |
| 407 | 2025-07-13 05:32:58 | spectrum | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 406 | 2025-07-07 02:00:12 | spectrum | 4 | 161609 | 243 | 43.596 | 3707.0 |
| 405 | 2025-07-01 22:11:34 | spectrum | 1 | 82945 | 2 | 3.873 | 21416.2 |
| 404 | 2025-06-28 00:34:12 | spectrum | 3 | 146162 | 34 | 25.253 | 5787.9 |
| 403 | 2025-06-27 21:38:41 | spectrum | 3 | 146162 | 34 | 42.720 | 3421.4 |
| 402 | 2025-06-26 17:30:53 | spectrum | 2 | 121059 | 9 | 15.280 | 7922.7 |
| 401 | 2025-06-26 06:21:02 | spectrum | 3 | 146162 | 34 | 33.903 | 4311.2 |
| 400 | 2025-06-25 13:24:25 | spectrum | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 399 | 2025-06-23 09:02:00 | spectrum | 4 | 161609 | 243 | 60.846 | 2656.0 |
| 398 | 2025-06-21 09:21:13 | spectrum | 3 | 146162 | 34 | 7.406 | 19735.6 |
| 397 | 2025-06-21 04:47:56 | spectrum | 2 | 121059 | 9 | 18.343 | 6599.7 |
| 396 | 2025-06-21 02:02:30 | spectrum | 4 | 161609 | 243 | 13.436 | 12028.1 |
| 395 | 2025-06-20 11:05:02 | spectrum | 1 | 82945 | 2 | 4.580 | 18110.3 |
| 394 | 2025-06-18 21:57:28 | spectrum | 4 | 161609 | 243 | 29.236 | 5527.7 |
| 393 | 2025-06-18 12:44:30 | spectrum | 1 | 82945 | 2 | 6.483 | 12794.2 |
| 392 | 2025-06-16 09:21:05 | spectrum | 4 | 161609 | 243 | 73.970 | 2184.8 |
| 391 | 2025-06-14 11:38:25 | spectrum | 4 | 161609 | 243 | 47.363 | 3412.1 |
| 390 | 2025-06-12 16:05:10 | spectrum | 4 | 161609 | 243 | 57.806 | 2795.7 |
| 389 | 2025-06-10 21:19:25 | spectrum | 4 | 161609 | 243 | 33.300 | 4853.1 |
| 388 | 2025-06-03 22:49:10 | spectrum | 1 | 82945 | 2 | 3.373 | 24590.9 |
| 387 | 2025-05-28 10:40:40 | spectrum | 3 | 146162 | 34 | 12.220 | 11960.9 |
| 386 | 2025-05-20 08:28:07 | spectrum | 1 | 82945 | 2 | 7.123 | 11644.7 |
| 385 | 2025-05-20 06:06:38 | spectrum | 3 | 146162 | 34 | 38.986 | 3749.1 |
| 384 | 2025-05-20 02:29:07 | spectrum | 4 | 161609 | 243 | 44.243 | 3652.8 |
| 383 | 2025-05-18 22:16:08 | spectrum | 3 | 146162 | 34 | 28.186 | 5185.6 |
| 382 | 2025-05-18 09:33:07 | spectrum | 3 | 146162 | 34 | 48.143 | 3036.0 |
| 381 | 2025-05-17 10:34:33 | spectrum | 4 | 161609 | 243 | 13.300 | 12151.1 |
| 380 | 2025-05-17 08:45:20 | spectrum | 2 | 121059 | 9 | 16.446 | 7361.0 |
| 379 | 2025-05-16 23:59:39 | spectrum | 3 | 146162 | 34 | 27.704 | 5275.8 |
| 378 | 2025-05-15 21:42:30 | spectrum | 1 | 82945 | 2 | 6.516 | 12729.4 |
| 377 | 2025-05-07 23:47:39 | spectrum | 1 | 82945 | 2 | 7.110 | 11666.0 |
| 376 | 2025-05-06 11:25:20 | spectrum | 3 | 146162 | 34 | 26.750 | 5464.0 |
| 375 | 2025-05-06 07:55:58 | spectrum | 3 | 146162 | 34 | 32.910 | 4441.3 |
| 374 | 2025-05-06 04:43:47 | spectrum | 1 | 82945 | 2 | 3.703 | 22399.4 |
| 373 | 2025-05-04 22:10:48 | spectrum | 1 | 82945 | 2 | 3.733 | 22219.4 |
| 372 | 2025-04-16 07:47:54 | spectrum | 1 | 82945 | 2 | 4.970 | 16689.1 |
| 371 | 2025-04-02 12:33:48 | spectrum | 1 | 82945 | 2 | 4.266 | 19443.3 |
| 370 | 2025-04-02 04:33:07 | spectrum | 1 | 82945 | 2 | 4.393 | 18881.2 |
| 369 | 2025-03-31 01:39:55 | spectrum | 4 | 161609 | 243 | 65.626 | 2462.6 |
| 368 | 2025-03-29 11:09:21 | spectrum | 4 | 161609 | 243 | 44.796 | 3607.7 |
| 367 | 2025-03-28 08:16:31 | spectrum | 4 | 161609 | 243 | 24.673 | 6550.0 |
| 366 | 2025-03-25 09:24:32 | spectrum | 4 | 161609 | 243 | 66.080 | 2445.7 |
| 365 | 2025-03-22 15:21:52 | spectrum | 1 | 82945 | 2 | 5.110 | 16231.9 |
| 364 | 2025-03-19 23:12:28 | spectrum | 1 | 82945 | 2 | 6.346 | 13070.4 |
| 363 | 2025-03-05 19:50:05 | spectrum | 1 | 82945 | 2 | 4.906 | 16906.8 |
| 362 | 2025-03-03 23:02:30 | spectrum | 1 | 82945 | 2 | 3.453 | 24021.1 |
| 361 | 2025-02-27 17:15:56 | spectrum | 4 | 161609 | 243 | 67.596 | 2390.8 |
| 360 | 2025-02-27 08:02:50 | spectrum | 4 | 161609 | 243 | 78.003 | 2071.8 |
| 359 | 2025-02-27 05:49:28 | spectrum | 4 | 161609 | 243 | 40.740 | 3966.8 |
| 358 | 2025-02-26 10:41:48 | spectrum | 1 | 82945 | 2 | 7.220 | 11488.2 |
| 357 | 2025-02-26 10:27:48 | spectrum | 4 | 161609 | 243 | 38.046 | 4247.7 |
| 356 | 2025-02-26 10:27:48 | spectrum | 2 | 121059 | 9 | 16.920 | 7154.8 |
| 355 | 2025-02-26 10:27:16 | spectrum | 3 | 146162 | 34 | 8.940 | 16349.2 |
| 354 | 2025-02-18 20:02:53 | spectrum | 3 | 146162 | 34 | 34.813 | 4198.5 |
| 353 | 2025-02-17 02:34:38 | spectrum | 3 | 146162 | 34 | 37.596 | 3887.7 |
| 352 | 2025-02-14 22:35:56 | spectrum | 3 | 146162 | 34 | 33.800 | 4324.3 |
| 351 | 2025-02-12 14:19:49 | spectrum | 1 | 82945 | 2 | 5.313 | 15611.7 |
| 350 | 2025-02-07 02:24:21 | spectrum | 1 | 82945 | 2 | 5.266 | 15751.0 |
| 349 | 2025-02-05 06:38:19 | spectrum | 4 | 161609 | 243 | 57.750 | 2798.4 |
| 348 | 2025-01-26 23:58:55 | spectrum | 4 | 161609 | 243 | 66.254 | 2439.2 |
| 347 | 2025-01-25 22:14:29 | spectrum | 4 | 161609 | 243 | 55.476 | 2913.1 |
| 346 | 2025-01-25 21:58:06 | spectrum | 4 | 161609 | 243 | 17.956 | 9000.3 |
| 345 | 2025-01-25 21:58:08 | spectrum | 3 | 146162 | 34 | 16.250 | 8994.6 |
| 344 | 2025-01-25 21:58:05 | spectrum | 2 | 121059 | 9 | 7.406 | 16346.1 |
| 343 | 2025-01-25 21:58:05 | spectrum | 1 | 82945 | 2 | 3.280 | 25288.1 |
| 342 | 2025-01-09 17:39:32 | spectrum | 3 | 146162 | 34 | 19.143 | 7635.3 |
| 341 | 2025-01-05 04:12:09 | spectrum | 1 | 82945 | 2 | 6.720 | 12343.0 |
| 340 | 2025-01-03 22:40:34 | spectrum | 3 | 146162 | 34 | 19.033 | 7679.4 |
| 339 | 2025-01-03 15:50:19 | spectrum | 3 | 146162 | 34 | 27.126 | 5388.3 |
| 338 | 2025-01-03 14:29:47 | spectrum | 3 | 146162 | 34 | 18.656 | 7834.6 |
| 337 | 2025-01-01 19:51:07 | spectrum | 1 | 82945 | 2 | 10.303 | 8050.6 |
| 336 | 2024-12-26 17:07:58 | spectrum | 1 | 82945 | 2 | 3.626 | 22875.1 |
| 335 | 2024-12-04 03:31:51 | spectrum | 3 | 146162 | 34 | 36.720 | 3980.4 |
| 334 | 2024-12-04 00:54:02 | spectrum | 4 | 161609 | 243 | 60.816 | 2657.3 |
| 333 | 2024-12-04 00:53:33 | spectrum | 3 | 146162 | 34 | 33.690 | 4338.4 |
| 332 | 2024-12-04 00:53:34 | spectrum | 2 | 121059 | 9 | 21.830 | 5545.5 |
| 331 | 2024-12-03 18:42:19 | spectrum | 4 | 161609 | 243 | 49.583 | 3259.4 |
| 330 | 2024-12-02 19:02:54 | spectrum | 2 | 121059 | 9 | 13.203 | 9169.1 |
| 329 | 2024-12-02 18:56:10 | spectrum | 3 | 146162 | 34 | 7.720 | 18932.9 |
| 328 | 2024-11-30 01:13:12 | spectrum | 1 | 82945 | 2 | 4.906 | 16906.8 |
| 327 | 2024-11-27 23:08:21 | spectrum | 3 | 146162 | 34 | 71.643 | 2040.1 |
| 326 | 2024-11-27 22:03:15 | spectrum | 3 | 146162 | 34 | 34.386 | 4250.6 |
| 325 | 2024-11-26 13:07:54 | spectrum | 3 | 146162 | 34 | 34.096 | 4286.8 |
| 324 | 2024-11-26 13:07:54 | spectrum | 2 | 121059 | 9 | 14.126 | 8569.9 |
| 323 | 2024-11-26 13:07:37 | spectrum | 1 | 82945 | 2 | 1.920 | 43200.5 |
| 322 | 2024-11-26 02:26:34 | spectrum | 4 | 161609 | 243 | 67.646 | 2389.0 |