History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drugs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
424 | 2024-04-15 13:15:15 | drugs | 1 | 28756 | 10 | 1.096 | 26237.2 |
423 | 2024-04-07 17:31:17 | drugs | 1 | 28756 | 10 | 0.530 | 54256.6 |
422 | 2024-04-04 15:51:26 | drugs | 2 | 53800 | 126 | 2.906 | 18513.4 |
421 | 2024-04-03 16:00:14 | drugs | 2 | 53800 | 126 | 3.876 | 13880.3 |
420 | 2024-04-03 00:57:26 | drugs | 1 | 28756 | 10 | 1.123 | 25606.4 |
419 | 2024-04-03 00:57:10 | drugs | 2 | 53800 | 126 | 5.610 | 9590.0 |
418 | 2024-04-02 22:10:41 | drugs | 2 | 53800 | 126 | 2.093 | 25704.7 |
417 | 2024-04-02 21:52:13 | drugs | 1 | 28756 | 10 | 0.546 | 52666.7 |
416 | 2024-04-01 17:33:20 | drugs | 1 | 28756 | 10 | 1.686 | 17055.8 |
415 | 2024-03-31 02:12:51 | drugs | 1 | 28756 | 10 | 0.686 | 41918.4 |
414 | 2024-03-07 18:48:26 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
413 | 2024-02-28 08:11:17 | drugs | 2 | 53800 | 126 | 1.923 | 27977.1 |
412 | 2024-02-25 22:08:23 | drugs | 2 | 53800 | 126 | 3.903 | 13784.3 |
411 | 2024-02-25 22:08:04 | drugs | 1 | 28756 | 10 | 1.623 | 17717.8 |
410 | 2024-01-26 20:02:29 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
409 | 2024-01-12 05:12:51 | drugs | 2 | 53800 | 126 | 1.530 | 35163.4 |
408 | 2024-01-11 14:00:45 | drugs | 2 | 53800 | 126 | 1.653 | 32546.9 |
407 | 2024-01-01 15:12:13 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
406 | 2023-12-27 00:25:46 | drugs | 1 | 28756 | 10 | 1.016 | 28303.1 |
405 | 2023-12-13 14:23:07 | drugs | 2 | 53800 | 126 | 1.466 | 36698.5 |
404 | 2023-12-04 21:15:00 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
403 | 2023-12-01 11:02:06 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
402 | 2023-11-23 02:51:57 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
401 | 2023-11-19 19:55:09 | drugs | 1 | 28756 | 10 | 0.513 | 56054.6 |
400 | 2023-11-15 12:42:53 | drugs | 1 | 28756 | 10 | 0.420 | 68466.7 |
399 | 2023-10-28 18:48:33 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
398 | 2023-10-23 13:42:44 | drugs | 2 | 53800 | 126 | 1.563 | 34421.0 |
397 | 2023-10-22 19:04:39 | drugs | 2 | 53800 | 126 | 1.593 | 33772.8 |
396 | 2023-10-20 04:00:31 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
395 | 2023-10-18 16:14:38 | drugs | 2 | 53800 | 126 | 1.343 | 40059.6 |
394 | 2023-10-17 00:57:08 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
393 | 2023-10-15 22:15:12 | drugs | 1 | 28756 | 10 | 0.873 | 32939.3 |
392 | 2023-10-13 16:50:02 | drugs | 1 | 28756 | 10 | 0.486 | 59168.7 |
391 | 2023-10-04 23:27:26 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
390 | 2023-09-27 15:12:11 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
389 | 2023-08-12 11:34:07 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
388 | 2023-08-12 05:39:19 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
387 | 2023-07-29 07:25:38 | drugs | 2 | 53800 | 126 | 1.343 | 40059.6 |
386 | 2023-05-10 23:17:19 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
385 | 2023-05-05 00:49:49 | drugs | 1 | 28756 | 10 | 0.420 | 68466.7 |
384 | 2023-04-09 14:43:43 | drugs | 2 | 53800 | 126 | 1.326 | 40573.2 |
383 | 2023-03-09 13:24:36 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
382 | 2023-01-26 09:30:38 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
381 | 2023-01-17 00:43:33 | drugs | 2 | 53800 | 126 | 1.343 | 40059.6 |
380 | 2022-12-29 01:49:59 | drugs | 1 | 28756 | 10 | 0.466 | 61708.2 |
379 | 2022-10-28 22:12:17 | drugs | 2 | 53800 | 126 | 1.326 | 40573.2 |
378 | 2022-10-12 02:21:01 | drugs | 1 | 28756 | 10 | 0.466 | 61708.2 |
377 | 2022-09-19 23:36:38 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
376 | 2022-09-17 17:46:48 | drugs | 1 | 28756 | 10 | 0.423 | 67981.1 |
375 | 2022-09-15 13:58:21 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
374 | 2022-09-12 06:17:21 | drugs | 1 | 28756 | 10 | 0.546 | 52666.7 |
373 | 2022-09-10 18:53:25 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
372 | 2022-08-14 20:40:35 | drugs | 1 | 28756 | 10 | 0.423 | 67981.1 |
371 | 2022-08-14 04:20:49 | drugs | 1 | 28756 | 10 | 0.486 | 59168.7 |
370 | 2022-08-07 03:15:57 | drugs | 1 | 28756 | 10 | 0.470 | 61183.0 |
369 | 2022-07-30 04:04:13 | drugs | 1 | 28756 | 10 | 0.486 | 59168.7 |
368 | 2022-07-29 04:52:44 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
367 | 2022-07-28 23:37:22 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
366 | 2022-07-17 23:39:47 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
365 | 2022-07-13 20:06:36 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
364 | 2022-07-03 11:16:08 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
363 | 2022-06-21 18:26:04 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
362 | 2022-06-16 11:15:15 | drugs | 1 | 28756 | 10 | 0.470 | 61183.0 |
361 | 2022-06-15 20:43:09 | drugs | 1 | 28756 | 10 | 0.466 | 61708.2 |
360 | 2022-06-08 16:56:04 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
359 | 2022-06-02 23:38:04 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
358 | 2022-06-01 13:15:10 | drugs | 1 | 28756 | 10 | 0.420 | 68466.7 |
357 | 2022-05-30 22:33:33 | drugs | 2 | 53800 | 126 | 1.356 | 39675.5 |
356 | 2022-05-26 03:17:33 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
355 | 2022-05-25 16:47:27 | drugs | 1 | 28756 | 10 | 0.486 | 59168.7 |
354 | 2022-04-26 19:58:28 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
353 | 2022-03-09 14:14:37 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
352 | 2022-03-05 22:38:59 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
351 | 2021-12-24 05:37:51 | drugs | 1 | 28756 | 10 | 0.533 | 53951.2 |
350 | 2021-12-22 02:41:17 | drugs | 1 | 28756 | 10 | 0.530 | 54256.6 |
349 | 2021-11-22 04:44:25 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
348 | 2021-10-29 03:20:38 | drugs | 1 | 28756 | 10 | 0.486 | 59168.7 |
347 | 2021-09-15 06:00:21 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
346 | 2021-08-28 15:46:32 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
345 | 2021-08-19 07:27:02 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
344 | 2021-07-27 22:10:37 | drugs | 1 | 28756 | 10 | 0.470 | 61183.0 |
343 | 2021-05-18 22:22:06 | drugs | 1 | 28756 | 10 | 0.860 | 33437.2 |
342 | 2021-05-18 14:26:31 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
341 | 2021-02-22 16:11:07 | drugs | 1 | 28756 | 10 | 0.550 | 52283.6 |
340 | 2021-02-15 09:35:13 | drugs | 1 | 28756 | 10 | 0.516 | 55728.7 |
339 | 2021-02-12 06:16:30 | drugs | 1 | 28756 | 10 | 0.500 | 57512.0 |
338 | 2021-01-31 07:25:05 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
337 | 2021-01-03 09:54:22 | drugs | 1 | 28756 | 10 | 0.486 | 59168.7 |
336 | 2020-11-11 19:13:33 | drugs | 1 | 28756 | 10 | 0.450 | 63902.2 |
335 | 2020-11-11 01:07:52 | drugs | 1 | 28756 | 10 | 0.623 | 46157.3 |
334 | 2020-10-28 23:12:12 | drugs | 1 | 28756 | 10 | 0.483 | 59536.2 |
333 | 2020-10-26 10:45:55 | drugs | 1 | 28756 | 10 | 0.470 | 61183.0 |
332 | 2020-10-24 16:29:22 | drugs | 1 | 28756 | 10 | 0.423 | 67981.1 |
331 | 2020-09-02 18:35:34 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
330 | 2020-08-30 18:13:36 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
329 | 2020-08-22 21:03:17 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
328 | 2020-08-13 21:06:27 | drugs | 1 | 28756 | 10 | 0.436 | 65954.1 |
327 | 2020-08-10 22:54:36 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |
326 | 2020-08-08 01:17:29 | drugs | 1 | 28756 | 10 | 0.453 | 63479.0 |
325 | 2020-08-05 11:32:56 | drugs | 1 | 28756 | 10 | 0.440 | 65354.5 |