History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lanced"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
462 | 2024-05-06 04:40:03 | lanced | 1 | 48755 | 9 | 1.953 | 24964.2 |
461 | 2024-05-06 04:00:03 | lanced | 2 | 82551 | 156 | 2.716 | 30394.3 |
460 | 2024-05-06 03:04:34 | lanced | 1 | 48755 | 9 | 0.856 | 56956.8 |
459 | 2024-04-30 06:49:30 | lanced | 1 | 48755 | 9 | 1.906 | 25579.7 |
458 | 2024-04-27 15:15:51 | lanced | 1 | 48755 | 9 | 0.906 | 53813.5 |
457 | 2024-04-25 19:22:09 | lanced | 1 | 48755 | 9 | 0.956 | 50999.0 |
456 | 2024-04-13 14:06:59 | lanced | 2 | 82551 | 156 | 2.593 | 31836.1 |
455 | 2024-04-12 19:58:37 | lanced | 2 | 82551 | 156 | 2.546 | 32423.8 |
454 | 2024-04-12 19:58:33 | lanced | 1 | 48755 | 9 | 0.876 | 55656.4 |
453 | 2024-04-12 19:58:25 | lanced | 2 | 82551 | 156 | 2.686 | 30733.8 |
452 | 2024-04-06 02:13:53 | lanced | 1 | 48755 | 9 | 2.920 | 16696.9 |
451 | 2024-03-31 06:00:31 | lanced | 1 | 48755 | 9 | 1.013 | 48129.3 |
450 | 2024-03-04 08:23:56 | lanced | 1 | 48755 | 9 | 1.780 | 27390.4 |
449 | 2024-03-04 08:23:49 | lanced | 2 | 82551 | 156 | 5.483 | 15055.8 |
448 | 2024-03-03 23:54:01 | lanced | 1 | 48755 | 9 | 1.970 | 24748.7 |
447 | 2024-02-29 01:02:19 | lanced | 2 | 82551 | 156 | 2.640 | 31269.3 |
446 | 2024-02-27 23:04:22 | lanced | 2 | 82551 | 156 | 5.766 | 14316.9 |
445 | 2024-02-27 22:25:29 | lanced | 2 | 82551 | 156 | 6.860 | 12033.7 |
444 | 2024-02-27 22:25:25 | lanced | 1 | 48755 | 9 | 2.030 | 24017.2 |
443 | 2024-02-18 03:26:06 | lanced | 1 | 48755 | 9 | 0.860 | 56691.9 |
442 | 2024-01-30 03:55:35 | lanced | 1 | 48755 | 9 | 0.890 | 54780.9 |
441 | 2023-12-16 19:51:25 | lanced | 2 | 82551 | 156 | 2.610 | 31628.7 |
440 | 2023-12-03 11:40:17 | lanced | 1 | 48755 | 9 | 0.890 | 54780.9 |
439 | 2023-12-03 11:40:16 | lanced | 1 | 48755 | 9 | 0.890 | 54780.9 |
438 | 2023-12-02 21:45:12 | lanced | 1 | 48755 | 9 | 0.983 | 49598.2 |
437 | 2023-11-30 23:56:18 | lanced | 2 | 82551 | 156 | 2.280 | 36206.6 |
436 | 2023-11-27 07:22:23 | lanced | 2 | 82551 | 156 | 2.203 | 37472.1 |
435 | 2023-11-11 21:12:42 | lanced | 1 | 48755 | 9 | 0.843 | 57835.1 |
434 | 2023-11-10 11:26:06 | lanced | 1 | 48755 | 9 | 0.856 | 56956.8 |
433 | 2023-11-05 16:12:41 | lanced | 1 | 48755 | 9 | 0.733 | 66514.3 |
432 | 2023-10-21 23:28:18 | lanced | 1 | 48755 | 9 | 0.890 | 54780.9 |
431 | 2023-10-18 12:49:04 | lanced | 1 | 48755 | 9 | 0.843 | 57835.1 |
430 | 2023-10-12 09:40:44 | lanced | 1 | 48755 | 9 | 0.750 | 65006.7 |
429 | 2023-10-07 10:43:54 | lanced | 1 | 48755 | 9 | 0.750 | 65006.7 |
428 | 2023-10-01 14:47:02 | lanced | 1 | 48755 | 9 | 0.830 | 58741.0 |
427 | 2023-09-28 09:27:32 | lanced | 1 | 48755 | 9 | 0.953 | 51159.5 |
426 | 2023-09-27 09:55:54 | lanced | 2 | 82551 | 156 | 2.563 | 32208.7 |
425 | 2023-09-19 17:56:07 | lanced | 1 | 48755 | 9 | 0.763 | 63899.1 |
424 | 2023-09-18 12:48:04 | lanced | 1 | 48755 | 9 | 0.796 | 61250.0 |
423 | 2023-09-16 16:04:23 | lanced | 2 | 82551 | 156 | 4.843 | 17045.4 |
422 | 2023-09-10 16:45:48 | lanced | 1 | 48755 | 9 | 0.890 | 54780.9 |
421 | 2023-07-09 13:02:30 | lanced | 1 | 48755 | 9 | 0.766 | 63648.8 |
420 | 2023-06-08 01:17:23 | lanced | 1 | 48755 | 9 | 0.766 | 63648.8 |
419 | 2023-04-15 21:40:07 | lanced | 1 | 48755 | 9 | 0.766 | 63648.8 |
418 | 2023-02-26 15:13:38 | lanced | 1 | 48755 | 9 | 0.830 | 58741.0 |
417 | 2023-02-09 20:58:13 | lanced | 1 | 48755 | 9 | 0.736 | 66243.2 |
416 | 2022-12-07 14:39:34 | lanced | 1 | 48755 | 9 | 0.736 | 66243.2 |
415 | 2022-11-17 01:44:55 | lanced | 1 | 48755 | 9 | 0.780 | 62506.4 |
414 | 2022-09-01 20:01:25 | lanced | 1 | 48755 | 9 | 0.843 | 57835.1 |
413 | 2022-08-13 13:55:06 | lanced | 1 | 48755 | 9 | 0.830 | 58741.0 |
412 | 2022-08-09 17:10:34 | lanced | 1 | 48755 | 9 | 0.733 | 66514.3 |
411 | 2022-04-09 05:09:51 | lanced | 1 | 48755 | 9 | 0.763 | 63899.1 |
410 | 2022-03-30 03:35:50 | lanced | 1 | 48755 | 9 | 1.156 | 42175.6 |
409 | 2022-03-27 22:29:12 | lanced | 1 | 48755 | 9 | 0.906 | 53813.5 |
408 | 2021-12-29 13:40:15 | lanced | 1 | 48755 | 9 | 0.846 | 57630.0 |
407 | 2021-12-21 21:04:20 | lanced | 1 | 48755 | 9 | 0.873 | 55847.7 |
406 | 2021-12-18 15:58:42 | lanced | 1 | 48755 | 9 | 0.800 | 60943.8 |
405 | 2021-11-13 13:43:48 | lanced | 1 | 48755 | 9 | 0.766 | 63648.8 |
404 | 2021-11-10 06:21:27 | lanced | 1 | 48755 | 9 | 0.843 | 57835.1 |
403 | 2021-11-08 13:19:39 | lanced | 1 | 48755 | 9 | 1.890 | 25796.3 |
402 | 2021-10-30 19:05:53 | lanced | 1 | 48755 | 9 | 0.860 | 56691.9 |
401 | 2021-10-29 17:46:13 | lanced | 1 | 48755 | 9 | 0.860 | 56691.9 |
400 | 2021-10-26 02:36:32 | lanced | 1 | 48755 | 9 | 0.780 | 62506.4 |
399 | 2021-09-27 00:04:28 | lanced | 1 | 48755 | 9 | 0.876 | 55656.4 |
398 | 2021-09-21 17:01:34 | lanced | 1 | 48755 | 9 | 0.766 | 63648.8 |
397 | 2021-09-20 23:29:35 | lanced | 1 | 48755 | 9 | 0.876 | 55656.4 |
396 | 2021-09-20 06:17:31 | lanced | 1 | 48755 | 9 | 0.750 | 65006.7 |
395 | 2021-09-14 16:23:26 | lanced | 1 | 48755 | 9 | 0.830 | 58741.0 |
394 | 2021-09-14 02:32:49 | lanced | 1 | 48755 | 9 | 0.763 | 63899.1 |
393 | 2021-08-16 17:02:59 | lanced | 1 | 48755 | 9 | 0.763 | 63899.1 |
392 | 2021-06-14 13:39:44 | lanced | 1 | 48755 | 9 | 0.783 | 62266.9 |
391 | 2021-05-27 12:57:29 | lanced | 1 | 48755 | 9 | 0.876 | 55656.4 |
390 | 2021-05-01 18:04:01 | lanced | 1 | 48755 | 9 | 0.860 | 56691.9 |
389 | 2021-03-08 03:19:15 | lanced | 1 | 48755 | 9 | 0.893 | 54596.9 |
388 | 2021-02-08 19:47:03 | lanced | 1 | 48755 | 9 | 0.783 | 62266.9 |
387 | 2021-01-14 15:55:50 | lanced | 1 | 48755 | 9 | 0.763 | 63899.1 |
386 | 2020-12-04 12:56:53 | lanced | 1 | 48755 | 9 | 0.750 | 65006.7 |
385 | 2020-11-18 15:19:23 | lanced | 1 | 48755 | 9 | 1.673 | 29142.3 |
384 | 2020-10-21 23:27:12 | lanced | 1 | 48755 | 9 | 1.686 | 28917.6 |
383 | 2020-10-21 06:35:56 | lanced | 1 | 48755 | 9 | 0.766 | 63648.8 |
382 | 2020-09-10 09:53:01 | lanced | 1 | 48755 | 9 | 0.750 | 65006.7 |
381 | 2020-08-29 18:45:35 | lanced | 1 | 48755 | 9 | 0.860 | 56691.9 |
380 | 2020-08-08 19:32:42 | lanced | 1 | 48755 | 9 | 0.783 | 62266.9 |
379 | 2020-08-06 19:58:32 | lanced | 1 | 48755 | 9 | 0.860 | 56691.9 |
378 | 2020-08-05 13:31:29 | lanced | 1 | 48755 | 9 | 0.766 | 63648.8 |
377 | 2020-07-29 06:06:37 | lanced | 1 | 48755 | 9 | 0.843 | 57835.1 |
376 | 2020-07-20 09:05:52 | lanced | 1 | 48755 | 9 | 0.796 | 61250.0 |
375 | 2020-05-28 03:07:06 | lanced | 1 | 48755 | 9 | 0.750 | 65006.7 |
374 | 2020-05-25 04:05:03 | lanced | 1 | 48755 | 9 | 0.856 | 56956.8 |
373 | 2020-04-27 11:47:50 | lanced | 1 | 48755 | 9 | 0.796 | 61250.0 |
372 | 2020-03-26 14:28:30 | lanced | 1 | 48755 | 9 | 0.873 | 55847.7 |
371 | 2020-03-26 07:36:03 | lanced | 1 | 48755 | 9 | 0.970 | 50262.9 |
370 | 2020-03-24 07:22:12 | lanced | 1 | 48755 | 9 | 0.876 | 55656.4 |
369 | 2020-03-24 02:09:00 | lanced | 1 | 48755 | 9 | 0.906 | 53813.5 |
368 | 2020-03-22 09:45:52 | lanced | 1 | 48755 | 9 | 0.873 | 55847.7 |
367 | 2020-03-18 15:07:02 | lanced | 1 | 48755 | 9 | 0.780 | 62506.4 |
366 | 2020-02-28 07:48:32 | lanced | 1 | 48755 | 9 | 1.436 | 33951.9 |
365 | 2020-02-25 03:04:58 | lanced | 1 | 48755 | 9 | 0.953 | 51159.5 |
364 | 2020-02-24 23:28:36 | lanced | 1 | 48755 | 9 | 1.046 | 46610.9 |
363 | 2020-02-22 21:40:08 | lanced | 1 | 48755 | 9 | 1.876 | 25988.8 |