History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trophies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
474 | 2024-04-28 13:52:26 | trophies | 1 | 82945 | 3 | 1.310 | 63316.8 |
473 | 2024-04-28 00:29:20 | trophies | 1 | 82945 | 3 | 1.626 | 51011.7 |
472 | 2024-04-27 18:03:14 | trophies | 1 | 82945 | 3 | 2.266 | 36604.1 |
471 | 2024-04-11 02:50:09 | trophies | 2 | 121059 | 22 | 7.516 | 16106.8 |
470 | 2024-04-10 21:42:26 | trophies | 3 | 146162 | 205 | 10.000 | 14616.2 |
469 | 2024-04-10 14:18:40 | trophies | 2 | 121059 | 22 | 3.830 | 31608.1 |
468 | 2024-04-09 01:16:55 | trophies | 3 | 146162 | 205 | 10.483 | 13942.8 |
467 | 2024-04-09 01:17:01 | trophies | 1 | 82945 | 3 | 1.626 | 51011.7 |
466 | 2024-04-09 01:16:50 | trophies | 2 | 121059 | 22 | 4.250 | 28484.5 |
465 | 2024-04-09 01:16:50 | trophies | 1 | 82945 | 3 | 3.500 | 23698.6 |
464 | 2024-04-08 10:46:05 | trophies | 2 | 121059 | 22 | 14.000 | 8647.1 |
463 | 2024-04-08 04:40:02 | trophies | 1 | 82945 | 3 | 1.436 | 57761.1 |
462 | 2024-04-06 14:57:57 | trophies | 3 | 146162 | 205 | 7.640 | 19131.2 |
461 | 2024-04-06 14:57:56 | trophies | 2 | 121059 | 22 | 7.456 | 16236.5 |
460 | 2024-04-06 14:57:54 | trophies | 1 | 82945 | 3 | 1.356 | 61168.9 |
459 | 2024-03-31 06:16:32 | trophies | 3 | 146162 | 205 | 23.440 | 6235.6 |
458 | 2024-03-30 14:57:01 | trophies | 2 | 121059 | 22 | 4.096 | 29555.4 |
457 | 2024-03-30 14:56:49 | trophies | 3 | 146162 | 205 | 8.516 | 17163.2 |
456 | 2024-03-29 03:35:09 | trophies | 3 | 146162 | 205 | 20.563 | 7108.0 |
455 | 2024-03-29 03:35:10 | trophies | 2 | 121059 | 22 | 6.453 | 18760.1 |
454 | 2024-03-29 03:35:04 | trophies | 1 | 82945 | 3 | 5.860 | 14154.4 |
453 | 2024-03-09 04:07:12 | trophies | 1 | 82945 | 3 | 1.296 | 64000.8 |
452 | 2024-03-09 04:07:01 | trophies | 2 | 121059 | 22 | 3.813 | 31749.0 |
451 | 2024-03-09 04:07:00 | trophies | 1 | 82945 | 3 | 1.576 | 52630.1 |
450 | 2024-03-08 22:26:38 | trophies | 3 | 146162 | 205 | 13.923 | 10497.9 |
449 | 2024-03-07 19:52:49 | trophies | 3 | 146162 | 205 | 24.660 | 5927.1 |
448 | 2024-03-07 07:53:56 | trophies | 3 | 146162 | 205 | 26.516 | 5512.2 |
447 | 2024-03-07 07:53:56 | trophies | 2 | 121059 | 22 | 12.596 | 9610.9 |
446 | 2024-03-07 05:48:17 | trophies | 1 | 82945 | 3 | 1.470 | 56425.2 |
445 | 2024-03-01 09:51:32 | trophies | 2 | 121059 | 22 | 16.266 | 7442.5 |
444 | 2024-03-01 09:11:09 | trophies | 1 | 82945 | 3 | 1.436 | 57761.1 |
443 | 2024-02-26 08:24:37 | trophies | 3 | 146162 | 205 | 7.220 | 20244.0 |
442 | 2024-02-26 08:24:37 | trophies | 2 | 121059 | 22 | 3.966 | 30524.2 |
441 | 2024-02-26 08:24:35 | trophies | 1 | 82945 | 3 | 1.546 | 53651.4 |
440 | 2024-02-21 07:30:25 | trophies | 3 | 146162 | 205 | 16.203 | 9020.7 |
439 | 2024-02-10 06:06:01 | trophies | 3 | 146162 | 205 | 8.830 | 16552.9 |
438 | 2024-02-10 06:06:00 | trophies | 2 | 121059 | 22 | 4.186 | 28920.0 |
437 | 2024-02-07 21:43:01 | trophies | 3 | 146162 | 205 | 15.893 | 9196.6 |
436 | 2024-02-07 21:43:02 | trophies | 2 | 121059 | 22 | 6.343 | 19085.4 |
435 | 2024-02-07 21:42:51 | trophies | 1 | 82945 | 3 | 3.030 | 27374.6 |
434 | 2024-02-04 01:38:47 | trophies | 3 | 146162 | 205 | 7.156 | 20425.1 |
433 | 2024-01-31 00:42:36 | trophies | 1 | 82945 | 3 | 1.486 | 55817.6 |
432 | 2024-01-08 19:52:47 | trophies | 1 | 82945 | 3 | 2.953 | 28088.4 |
431 | 2024-01-05 11:47:57 | trophies | 1 | 82945 | 3 | 2.890 | 28700.7 |
430 | 2024-01-05 10:55:53 | trophies | 3 | 146162 | 205 | 6.360 | 22981.4 |
429 | 2023-12-25 06:14:31 | trophies | 1 | 82945 | 3 | 1.296 | 64000.8 |
428 | 2023-12-15 05:15:54 | trophies | 3 | 146162 | 205 | 7.686 | 19016.7 |
427 | 2023-12-15 05:15:51 | trophies | 2 | 121059 | 22 | 3.716 | 32577.8 |
426 | 2023-12-09 17:36:41 | trophies | 2 | 121059 | 22 | 3.220 | 37596.0 |
425 | 2023-11-25 07:04:32 | trophies | 1 | 82945 | 3 | 1.343 | 61761.0 |
424 | 2023-10-29 02:05:45 | trophies | 1 | 82945 | 3 | 1.470 | 56425.2 |
423 | 2023-10-28 22:59:17 | trophies | 1 | 82945 | 3 | 1.296 | 64000.8 |
422 | 2023-10-25 11:16:37 | trophies | 1 | 82945 | 3 | 3.190 | 26001.6 |
421 | 2023-10-19 22:34:20 | trophies | 1 | 82945 | 3 | 1.233 | 67270.9 |
420 | 2023-10-12 05:53:54 | trophies | 3 | 146162 | 205 | 9.983 | 14641.1 |
419 | 2023-09-14 03:44:16 | trophies | 1 | 82945 | 3 | 1.250 | 66356.0 |
418 | 2023-09-08 17:45:27 | trophies | 2 | 121059 | 22 | 3.296 | 36729.1 |
417 | 2023-08-26 03:56:09 | trophies | 1 | 82945 | 3 | 1.390 | 59672.7 |
416 | 2023-08-21 20:21:51 | trophies | 1 | 82945 | 3 | 2.563 | 32362.5 |
415 | 2023-07-23 00:09:31 | trophies | 3 | 146162 | 205 | 7.033 | 20782.3 |
414 | 2023-05-30 20:18:48 | trophies | 2 | 121059 | 22 | 3.233 | 37444.8 |
413 | 2023-05-20 11:07:13 | trophies | 1 | 82945 | 3 | 1.390 | 59672.7 |
412 | 2023-05-08 23:38:46 | trophies | 1 | 82945 | 3 | 1.216 | 68211.3 |
411 | 2023-04-04 10:29:49 | trophies | 3 | 146162 | 205 | 6.953 | 21021.4 |
410 | 2023-03-16 04:51:59 | trophies | 1 | 82945 | 3 | 1.250 | 66356.0 |
409 | 2023-03-08 01:46:16 | trophies | 2 | 121059 | 22 | 3.173 | 38152.9 |
408 | 2023-01-23 01:32:15 | trophies | 1 | 82945 | 3 | 1.250 | 66356.0 |
407 | 2023-01-17 09:02:46 | trophies | 1 | 82945 | 3 | 1.250 | 66356.0 |
406 | 2023-01-03 05:03:29 | trophies | 1 | 82945 | 3 | 1.466 | 56579.1 |
405 | 2023-01-03 00:56:45 | trophies | 3 | 146162 | 205 | 6.093 | 23988.5 |
404 | 2022-12-12 16:24:24 | trophies | 2 | 121059 | 22 | 3.126 | 38726.5 |
403 | 2022-09-27 22:42:31 | trophies | 1 | 82945 | 3 | 1.393 | 59544.1 |
402 | 2022-09-21 00:19:56 | trophies | 1 | 82945 | 3 | 1.423 | 58288.8 |
401 | 2022-09-09 13:53:55 | trophies | 3 | 146162 | 205 | 6.266 | 23326.2 |
400 | 2022-08-01 08:08:24 | trophies | 2 | 121059 | 22 | 3.106 | 38975.9 |
399 | 2022-07-02 12:21:28 | trophies | 1 | 82945 | 3 | 1.376 | 60279.8 |
398 | 2022-06-30 08:36:09 | trophies | 1 | 82945 | 3 | 1.280 | 64800.8 |
397 | 2022-05-21 17:20:55 | trophies | 1 | 82945 | 3 | 1.280 | 64800.8 |
396 | 2022-05-18 07:33:25 | trophies | 1 | 82945 | 3 | 1.500 | 55296.7 |
395 | 2022-02-26 19:32:59 | trophies | 1 | 82945 | 3 | 1.483 | 55930.5 |
394 | 2022-01-30 13:46:22 | trophies | 1 | 82945 | 3 | 1.250 | 66356.0 |
393 | 2022-01-27 02:27:08 | trophies | 1 | 82945 | 3 | 1.296 | 64000.8 |
392 | 2021-12-17 21:54:56 | trophies | 1 | 82945 | 3 | 1.470 | 56425.2 |
391 | 2021-11-02 03:49:47 | trophies | 1 | 82945 | 3 | 1.436 | 57761.1 |
390 | 2021-10-22 10:52:14 | trophies | 1 | 82945 | 3 | 1.546 | 53651.4 |
389 | 2021-10-21 10:39:03 | trophies | 1 | 82945 | 3 | 1.420 | 58412.0 |
388 | 2021-10-13 17:08:08 | trophies | 1 | 82945 | 3 | 1.373 | 60411.5 |
387 | 2021-09-22 15:31:40 | trophies | 1 | 82945 | 3 | 1.453 | 57085.3 |
386 | 2021-09-21 23:20:21 | trophies | 1 | 82945 | 3 | 1.326 | 62552.8 |
385 | 2021-09-21 16:10:48 | trophies | 1 | 82945 | 3 | 1.280 | 64800.8 |
384 | 2021-09-21 12:46:54 | trophies | 1 | 82945 | 3 | 1.423 | 58288.8 |
383 | 2021-09-19 11:12:49 | trophies | 1 | 82945 | 3 | 1.453 | 57085.3 |
382 | 2021-09-15 04:46:39 | trophies | 1 | 82945 | 3 | 1.453 | 57085.3 |
381 | 2021-07-12 15:22:56 | trophies | 1 | 82945 | 3 | 1.266 | 65517.4 |
380 | 2021-05-09 23:24:45 | trophies | 1 | 82945 | 3 | 1.533 | 54106.3 |
379 | 2021-04-08 22:44:22 | trophies | 1 | 82945 | 3 | 1.513 | 54821.5 |
378 | 2021-04-04 18:01:07 | trophies | 1 | 82945 | 3 | 1.403 | 59119.7 |
377 | 2021-03-12 21:09:41 | trophies | 1 | 82945 | 3 | 1.470 | 56425.2 |
376 | 2021-02-16 06:17:30 | trophies | 1 | 82945 | 3 | 1.513 | 54821.5 |
375 | 2020-12-30 19:09:25 | trophies | 1 | 82945 | 3 | 1.310 | 63316.8 |