History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lancer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
436 | 2024-04-25 17:04:18 | lancer | 1 | 48755 | 13 | 0.860 | 56691.9 |
435 | 2024-03-30 00:55:36 | lancer | 1 | 48755 | 13 | 2.030 | 24017.2 |
434 | 2024-03-29 03:46:43 | lancer | 1 | 48755 | 13 | 0.970 | 50262.9 |
433 | 2024-03-29 01:22:41 | lancer | 1 | 48755 | 13 | 2.940 | 16583.3 |
432 | 2024-03-20 19:04:49 | lancer | 1 | 48755 | 13 | 1.826 | 26700.4 |
431 | 2024-03-20 19:04:24 | lancer | 2 | 82551 | 164 | 5.140 | 16060.5 |
430 | 2024-03-04 06:21:05 | lancer | 1 | 48755 | 13 | 0.763 | 63899.1 |
429 | 2024-02-28 11:02:31 | lancer | 2 | 82551 | 164 | 2.593 | 31836.1 |
428 | 2024-02-28 00:09:01 | lancer | 2 | 82551 | 164 | 2.703 | 30540.5 |
427 | 2024-02-27 22:59:09 | lancer | 2 | 82551 | 164 | 7.690 | 10734.9 |
426 | 2024-02-27 22:58:54 | lancer | 1 | 48755 | 13 | 2.030 | 24017.2 |
425 | 2024-02-18 20:26:34 | lancer | 2 | 82551 | 164 | 2.890 | 28564.4 |
424 | 2024-01-12 20:00:51 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
423 | 2023-12-07 21:36:55 | lancer | 2 | 82551 | 164 | 2.656 | 31080.9 |
422 | 2023-11-27 07:16:17 | lancer | 2 | 82551 | 164 | 2.403 | 34353.3 |
421 | 2023-11-13 17:23:22 | lancer | 1 | 48755 | 13 | 0.796 | 61250.0 |
420 | 2023-11-10 11:25:26 | lancer | 2 | 82551 | 164 | 2.483 | 33246.5 |
419 | 2023-11-08 00:56:39 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
418 | 2023-11-05 20:28:19 | lancer | 1 | 48755 | 13 | 0.813 | 59969.2 |
417 | 2023-11-04 20:50:59 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
416 | 2023-11-03 19:28:29 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
415 | 2023-10-21 23:27:49 | lancer | 1 | 48755 | 13 | 0.783 | 62266.9 |
414 | 2023-10-18 15:35:32 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
413 | 2023-10-14 22:59:58 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
412 | 2023-10-07 10:43:50 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
411 | 2023-09-23 08:00:25 | lancer | 1 | 48755 | 13 | 0.783 | 62266.9 |
410 | 2023-09-15 11:26:42 | lancer | 1 | 48755 | 13 | 0.876 | 55656.4 |
409 | 2023-08-27 10:26:25 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
408 | 2023-07-28 11:34:41 | lancer | 1 | 48755 | 13 | 0.826 | 59025.4 |
407 | 2023-05-27 22:21:38 | lancer | 1 | 48755 | 13 | 0.733 | 66514.3 |
406 | 2023-04-23 21:15:49 | lancer | 1 | 48755 | 13 | 0.793 | 61481.7 |
405 | 2023-03-22 03:57:45 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
404 | 2023-01-18 22:55:02 | lancer | 1 | 48755 | 13 | 0.846 | 57630.0 |
403 | 2023-01-08 12:33:37 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
402 | 2022-10-08 08:44:59 | lancer | 1 | 48755 | 13 | 0.923 | 52822.3 |
401 | 2022-10-07 21:16:47 | lancer | 1 | 48755 | 13 | 0.860 | 56691.9 |
400 | 2022-09-19 07:01:59 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
399 | 2022-09-10 20:28:15 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
398 | 2022-08-31 19:39:48 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
397 | 2022-08-23 04:47:53 | lancer | 1 | 48755 | 13 | 0.783 | 62266.9 |
396 | 2022-08-14 13:55:24 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
395 | 2022-07-28 20:56:43 | lancer | 1 | 48755 | 13 | 0.783 | 62266.9 |
394 | 2022-06-17 23:10:54 | lancer | 1 | 48755 | 13 | 0.783 | 62266.9 |
393 | 2022-06-14 05:45:41 | lancer | 1 | 48755 | 13 | 0.830 | 58741.0 |
392 | 2022-05-28 08:02:54 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
391 | 2022-03-05 22:07:46 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
390 | 2022-02-12 14:44:02 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
389 | 2022-02-05 07:16:44 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
388 | 2021-12-01 05:42:21 | lancer | 1 | 48755 | 13 | 0.873 | 55847.7 |
387 | 2021-11-28 22:20:45 | lancer | 1 | 48755 | 13 | 1.500 | 32503.3 |
386 | 2021-11-12 00:20:32 | lancer | 1 | 48755 | 13 | 0.860 | 56691.9 |
385 | 2021-10-12 19:01:23 | lancer | 1 | 48755 | 13 | 0.983 | 49598.2 |
384 | 2021-09-06 14:28:27 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
383 | 2021-08-26 00:17:57 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
382 | 2021-08-17 20:09:30 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
381 | 2021-07-01 11:32:31 | lancer | 1 | 48755 | 13 | 0.813 | 59969.2 |
380 | 2021-05-25 04:46:02 | lancer | 1 | 48755 | 13 | 0.893 | 54596.9 |
379 | 2021-04-13 11:35:01 | lancer | 1 | 48755 | 13 | 0.813 | 59969.2 |
378 | 2021-03-17 06:15:26 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
377 | 2021-02-19 16:08:48 | lancer | 1 | 48755 | 13 | 0.873 | 55847.7 |
376 | 2020-12-01 20:24:55 | lancer | 1 | 48755 | 13 | 0.860 | 56691.9 |
375 | 2020-11-16 00:36:32 | lancer | 1 | 48755 | 13 | 0.763 | 63899.1 |
374 | 2020-10-29 11:41:05 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
373 | 2020-10-28 16:01:05 | lancer | 1 | 48755 | 13 | 0.906 | 53813.5 |
372 | 2020-10-04 04:58:44 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
371 | 2020-08-29 01:48:59 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
370 | 2020-08-20 17:59:36 | lancer | 1 | 48755 | 13 | 0.893 | 54596.9 |
369 | 2020-08-13 21:46:28 | lancer | 1 | 48755 | 13 | 0.813 | 59969.2 |
368 | 2020-08-10 22:30:33 | lancer | 1 | 48755 | 13 | 0.796 | 61250.0 |
367 | 2020-08-04 01:16:58 | lancer | 1 | 48755 | 13 | 0.783 | 62266.9 |
366 | 2020-07-20 16:39:09 | lancer | 1 | 48755 | 13 | 0.780 | 62506.4 |
365 | 2020-07-20 08:03:25 | lancer | 1 | 48755 | 13 | 0.843 | 57835.1 |
364 | 2020-07-12 14:18:03 | lancer | 1 | 48755 | 13 | 0.906 | 53813.5 |
363 | 2020-05-09 17:16:36 | lancer | 1 | 48755 | 13 | 0.813 | 59969.2 |
362 | 2020-03-30 01:29:26 | lancer | 1 | 48755 | 13 | 0.893 | 54596.9 |
361 | 2020-03-26 13:45:37 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
360 | 2020-03-26 10:08:34 | lancer | 1 | 48755 | 13 | 1.453 | 33554.7 |
359 | 2020-03-26 09:50:43 | lancer | 1 | 48755 | 13 | 0.826 | 59025.4 |
358 | 2020-03-23 16:41:06 | lancer | 1 | 48755 | 13 | 0.860 | 56691.9 |
357 | 2020-03-22 15:29:36 | lancer | 1 | 48755 | 13 | 0.796 | 61250.0 |
356 | 2020-03-18 06:59:01 | lancer | 1 | 48755 | 13 | 0.830 | 58741.0 |
355 | 2020-02-26 05:51:37 | lancer | 1 | 48755 | 13 | 2.000 | 24377.5 |
354 | 2020-02-22 19:17:10 | lancer | 1 | 48755 | 13 | 0.936 | 52088.7 |
353 | 2020-02-15 01:31:16 | lancer | 1 | 48755 | 13 | 2.736 | 17819.8 |
352 | 2020-02-11 12:16:26 | lancer | 1 | 48755 | 13 | 0.953 | 51159.5 |
351 | 2020-02-07 03:58:36 | lancer | 1 | 48755 | 13 | 0.890 | 54780.9 |
350 | 2020-02-02 02:20:21 | lancer | 1 | 48755 | 13 | 0.876 | 55656.4 |
349 | 2020-02-01 06:40:52 | lancer | 1 | 48755 | 13 | 1.013 | 48129.3 |
348 | 2020-01-31 15:14:43 | lancer | 1 | 48755 | 13 | 2.406 | 20263.9 |
347 | 2020-01-30 04:02:18 | lancer | 1 | 48755 | 13 | 1.423 | 34262.1 |
346 | 2020-01-30 01:14:39 | lancer | 1 | 48755 | 13 | 1.953 | 24964.2 |
345 | 2020-01-28 09:32:35 | lancer | 1 | 48755 | 13 | 0.876 | 55656.4 |
344 | 2020-01-25 14:51:36 | lancer | 1 | 48755 | 13 | 1.000 | 48755.0 |
343 | 2020-01-22 07:22:06 | lancer | 1 | 48755 | 13 | 1.813 | 26891.9 |
342 | 2020-01-13 08:04:43 | lancer | 1 | 48755 | 13 | 1.156 | 42175.6 |
341 | 2020-01-13 07:47:17 | lancer | 1 | 48755 | 13 | 0.890 | 54780.9 |
340 | 2020-01-11 00:35:53 | lancer | 1 | 48755 | 13 | 1.233 | 39541.8 |
339 | 2020-01-05 04:15:41 | lancer | 1 | 48755 | 13 | 0.953 | 51159.5 |
338 | 2019-12-26 15:52:02 | lancer | 1 | 48755 | 13 | 0.876 | 55656.4 |
337 | 2019-12-26 13:33:27 | lancer | 1 | 48755 | 13 | 0.936 | 52088.7 |