History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detective"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
465 | 2025-08-14 06:04:12 | detective | 1 | 81242 | 3 | 1.453 | 55913.3 |
464 | 2025-08-11 14:48:27 | detective | 3 | 148641 | 83 | 34.300 | 4333.6 |
463 | 2025-08-11 14:28:39 | detective | 2 | 121436 | 20 | 15.453 | 7858.4 |
462 | 2025-08-09 12:59:41 | detective | 1 | 81242 | 3 | 7.126 | 11400.8 |
461 | 2025-08-06 00:42:26 | detective | 3 | 148641 | 83 | 40.736 | 3648.9 |
460 | 2025-08-05 20:36:47 | detective | 2 | 121436 | 20 | 9.890 | 12278.7 |
459 | 2025-08-05 09:53:43 | detective | 1 | 81242 | 3 | 3.403 | 23873.6 |
458 | 2025-08-05 01:27:59 | detective | 1 | 81242 | 3 | 6.360 | 12773.9 |
457 | 2025-08-04 09:41:06 | detective | 1 | 81242 | 3 | 1.470 | 55266.7 |
456 | 2025-08-01 16:46:06 | detective | 1 | 81242 | 3 | 2.906 | 27956.6 |
455 | 2025-07-31 23:16:07 | detective | 2 | 121436 | 20 | 7.923 | 15327.0 |
454 | 2025-07-27 02:31:15 | detective | 1 | 81242 | 3 | 6.656 | 12205.8 |
453 | 2025-07-25 08:47:43 | detective | 1 | 81242 | 3 | 3.576 | 22718.7 |
452 | 2025-07-23 22:53:16 | detective | 1 | 81242 | 3 | 5.750 | 14129.0 |
451 | 2025-07-23 02:44:40 | detective | 1 | 81242 | 3 | 3.563 | 22801.6 |
450 | 2025-07-19 10:31:24 | detective | 1 | 81242 | 3 | 1.500 | 54161.3 |
449 | 2025-07-13 09:41:11 | detective | 1 | 81242 | 3 | 1.500 | 54161.3 |
448 | 2025-07-12 14:40:37 | detective | 1 | 81242 | 3 | 1.436 | 56575.2 |
447 | 2025-07-07 21:31:00 | detective | 2 | 121436 | 20 | 18.953 | 6407.2 |
446 | 2025-07-05 12:56:57 | detective | 3 | 148641 | 83 | 30.986 | 4797.0 |
445 | 2025-07-04 12:19:20 | detective | 1 | 81242 | 3 | 5.626 | 14440.5 |
444 | 2025-07-02 23:30:22 | detective | 3 | 148641 | 83 | 38.860 | 3825.0 |
443 | 2025-07-01 08:25:30 | detective | 1 | 81242 | 3 | 1.423 | 57092.1 |
442 | 2025-06-28 14:59:56 | detective | 1 | 81242 | 3 | 6.160 | 13188.6 |
441 | 2025-06-27 10:25:06 | detective | 3 | 148641 | 83 | 10.783 | 13784.8 |
440 | 2025-06-24 18:07:02 | detective | 1 | 81242 | 3 | 10.203 | 7962.6 |
439 | 2025-06-24 17:58:26 | detective | 1 | 81242 | 3 | 3.296 | 24648.7 |
438 | 2025-06-23 00:46:24 | detective | 2 | 121436 | 20 | 9.780 | 12416.8 |
437 | 2025-06-22 21:05:15 | detective | 3 | 148641 | 83 | 10.436 | 14243.1 |
436 | 2025-06-21 17:54:12 | detective | 1 | 81242 | 3 | 1.440 | 56418.1 |
435 | 2025-06-20 19:57:20 | detective | 1 | 81242 | 3 | 3.436 | 23644.4 |
434 | 2025-06-10 08:54:10 | detective | 1 | 81242 | 3 | 9.703 | 8372.9 |
433 | 2025-06-04 11:11:03 | detective | 1 | 81242 | 3 | 3.233 | 25129.0 |
432 | 2025-05-31 01:47:05 | detective | 1 | 81242 | 3 | 7.080 | 11474.9 |
431 | 2025-05-30 08:50:01 | detective | 1 | 81242 | 3 | 7.516 | 10809.2 |
430 | 2025-05-29 14:15:51 | detective | 1 | 81242 | 3 | 4.310 | 18849.7 |
429 | 2025-05-11 03:32:00 | detective | 1 | 81242 | 3 | 4.920 | 16512.6 |
428 | 2025-05-10 08:47:30 | detective | 1 | 81242 | 3 | 3.406 | 23852.6 |
427 | 2025-05-08 17:41:45 | detective | 1 | 81242 | 3 | 7.000 | 11606.0 |
426 | 2025-05-08 03:05:42 | detective | 1 | 81242 | 3 | 3.690 | 22016.8 |
425 | 2025-05-02 15:23:15 | detective | 1 | 81242 | 3 | 6.563 | 12378.8 |
424 | 2025-04-29 04:48:23 | detective | 1 | 81242 | 3 | 5.796 | 14016.9 |
423 | 2025-04-29 04:28:26 | detective | 1 | 81242 | 3 | 1.373 | 59171.2 |
422 | 2025-04-28 14:30:52 | detective | 1 | 81242 | 3 | 5.453 | 14898.6 |
421 | 2025-04-28 11:23:35 | detective | 1 | 81242 | 3 | 10.470 | 7759.5 |
420 | 2025-04-04 08:38:39 | detective | 1 | 81242 | 3 | 6.516 | 12468.1 |
419 | 2025-03-31 10:43:19 | detective | 1 | 81242 | 3 | 5.063 | 16046.2 |
418 | 2025-03-27 16:40:44 | detective | 1 | 81242 | 3 | 3.013 | 26963.8 |
417 | 2025-03-23 12:43:59 | detective | 1 | 81242 | 3 | 8.313 | 9772.9 |
416 | 2025-03-20 16:47:17 | detective | 1 | 81242 | 3 | 7.216 | 11258.6 |
415 | 2025-03-03 13:05:39 | detective | 3 | 148641 | 83 | 31.893 | 4660.6 |
414 | 2025-03-03 13:05:35 | detective | 3 | 148641 | 83 | 18.893 | 7867.5 |
413 | 2025-03-03 13:05:34 | detective | 2 | 121436 | 20 | 18.190 | 6676.0 |
412 | 2025-03-03 12:44:22 | detective | 1 | 81242 | 3 | 4.826 | 16834.2 |
411 | 2025-02-28 09:42:08 | detective | 1 | 81242 | 3 | 2.110 | 38503.3 |
410 | 2025-02-25 16:38:16 | detective | 1 | 81242 | 3 | 1.263 | 64324.6 |
409 | 2025-02-12 15:14:48 | detective | 3 | 148641 | 83 | 36.300 | 4094.8 |
408 | 2025-02-12 14:00:03 | detective | 1 | 81242 | 3 | 3.203 | 25364.3 |
407 | 2025-01-30 11:00:16 | detective | 2 | 121436 | 20 | 17.416 | 6972.7 |
406 | 2025-01-30 03:08:05 | detective | 3 | 148641 | 83 | 42.393 | 3506.3 |
405 | 2025-01-29 05:15:29 | detective | 3 | 148641 | 83 | 37.323 | 3982.6 |
404 | 2025-01-27 10:01:04 | detective | 3 | 148641 | 83 | 60.503 | 2456.8 |
403 | 2025-01-27 10:01:00 | detective | 3 | 148641 | 83 | 37.723 | 3940.3 |
402 | 2025-01-27 10:01:06 | detective | 2 | 121436 | 20 | 9.423 | 12887.2 |
401 | 2025-01-27 09:43:21 | detective | 1 | 81242 | 3 | 1.470 | 55266.7 |
400 | 2025-01-26 23:33:22 | detective | 1 | 81242 | 3 | 1.263 | 64324.6 |
399 | 2025-01-10 11:38:04 | detective | 1 | 81242 | 3 | 6.780 | 11982.6 |
398 | 2024-12-16 12:07:06 | detective | 2 | 121436 | 20 | 9.080 | 13374.0 |
397 | 2024-12-15 13:02:13 | detective | 3 | 148641 | 83 | 47.800 | 3109.6 |
396 | 2024-12-15 10:51:37 | detective | 1 | 81242 | 3 | 6.830 | 11894.9 |
395 | 2024-12-15 02:03:50 | detective | 2 | 121436 | 20 | 11.733 | 10350.0 |
394 | 2024-12-13 15:24:50 | detective | 2 | 121436 | 20 | 17.406 | 6976.7 |
393 | 2024-12-08 19:20:41 | detective | 3 | 148641 | 83 | 45.143 | 3292.7 |
392 | 2024-12-08 19:20:41 | detective | 3 | 148641 | 83 | 40.300 | 3688.4 |
391 | 2024-12-08 19:20:44 | detective | 2 | 121436 | 20 | 8.686 | 13980.7 |
390 | 2024-12-08 18:45:32 | detective | 1 | 81242 | 3 | 2.466 | 32944.8 |
389 | 2024-12-05 00:17:28 | detective | 1 | 81242 | 3 | 4.170 | 19482.5 |
388 | 2024-11-26 11:06:12 | detective | 1 | 81242 | 3 | 3.750 | 21664.5 |
387 | 2024-11-11 03:05:12 | detective | 2 | 121436 | 20 | 19.076 | 6365.9 |
386 | 2024-11-06 00:51:58 | detective | 3 | 148641 | 83 | 35.426 | 4195.8 |
385 | 2024-11-06 00:51:58 | detective | 2 | 121436 | 20 | 27.630 | 4395.1 |
384 | 2024-11-03 08:51:50 | detective | 1 | 81242 | 3 | 6.440 | 12615.2 |
383 | 2024-11-02 17:25:58 | detective | 3 | 148641 | 83 | 43.766 | 3396.3 |
382 | 2024-11-02 17:00:17 | detective | 3 | 148641 | 83 | 43.376 | 3426.8 |
381 | 2024-11-02 01:57:31 | detective | 3 | 148641 | 83 | 40.970 | 3628.0 |
380 | 2024-11-02 01:57:30 | detective | 3 | 148641 | 83 | 25.516 | 5825.4 |
379 | 2024-11-02 01:57:33 | detective | 2 | 121436 | 20 | 16.313 | 7444.1 |
378 | 2024-11-02 01:57:22 | detective | 1 | 81242 | 3 | 2.550 | 31859.6 |
377 | 2024-10-26 21:21:50 | detective | 1 | 81242 | 3 | 5.983 | 13578.8 |
376 | 2024-10-01 18:18:51 | detective | 1 | 81242 | 3 | 8.530 | 9524.3 |
375 | 2024-10-01 18:16:03 | detective | 2 | 121436 | 20 | 26.533 | 4576.8 |
374 | 2024-09-30 02:15:49 | detective | 3 | 148641 | 83 | 53.816 | 2762.0 |
373 | 2024-09-30 02:15:55 | detective | 2 | 121436 | 20 | 27.610 | 4398.3 |
372 | 2024-09-30 02:15:11 | detective | 1 | 81242 | 3 | 8.860 | 9169.5 |
371 | 2024-09-29 10:56:49 | detective | 3 | 148641 | 83 | 65.596 | 2266.0 |
370 | 2024-09-29 03:18:59 | detective | 1 | 81242 | 3 | 8.596 | 9451.1 |
369 | 2024-09-25 19:34:04 | detective | 3 | 148641 | 83 | 94.113 | 1579.4 |
368 | 2024-09-25 19:33:53 | detective | 3 | 148641 | 83 | 55.270 | 2689.4 |
367 | 2024-09-25 19:33:55 | detective | 2 | 121436 | 20 | 23.453 | 5177.8 |
366 | 2024-09-25 19:30:17 | detective | 1 | 81242 | 3 | 11.783 | 6894.8 |