History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lilac"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
423 | 2024-04-26 08:51:53 | lilac | 1 | 28756 | 3 | 0.533 | 53951.2 |
422 | 2024-04-17 02:59:28 | lilac | 1 | 28756 | 3 | 0.486 | 59168.7 |
421 | 2024-04-06 05:59:42 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
420 | 2024-04-03 10:42:59 | lilac | 3 | 83667 | 794 | 16.000 | 5229.2 |
419 | 2024-04-03 08:37:12 | lilac | 3 | 83667 | 794 | 5.423 | 15428.2 |
418 | 2024-03-31 14:24:15 | lilac | 3 | 83667 | 794 | 12.610 | 6635.0 |
417 | 2024-03-31 14:24:15 | lilac | 2 | 53800 | 33 | 5.656 | 9512.0 |
416 | 2024-03-31 14:15:56 | lilac | 1 | 28756 | 3 | 1.080 | 26625.9 |
415 | 2024-03-29 23:54:50 | lilac | 1 | 28756 | 3 | 1.030 | 27918.4 |
414 | 2024-03-15 17:32:51 | lilac | 1 | 28756 | 3 | 0.546 | 52666.7 |
413 | 2024-03-07 03:48:21 | lilac | 1 | 28756 | 3 | 0.686 | 41918.4 |
412 | 2024-03-01 12:18:58 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
411 | 2024-02-28 20:17:06 | lilac | 1 | 28756 | 3 | 1.046 | 27491.4 |
410 | 2024-02-03 23:23:39 | lilac | 1 | 28756 | 3 | 0.470 | 61183.0 |
409 | 2024-01-29 07:58:34 | lilac | 1 | 28756 | 3 | 0.533 | 53951.2 |
408 | 2024-01-29 05:34:55 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
407 | 2024-01-12 03:27:31 | lilac | 1 | 28756 | 3 | 0.546 | 52666.7 |
406 | 2023-12-27 01:32:46 | lilac | 2 | 53800 | 33 | 1.640 | 32804.9 |
405 | 2023-12-26 12:41:27 | lilac | 3 | 83667 | 794 | 3.733 | 22412.8 |
404 | 2023-12-19 14:10:31 | lilac | 3 | 83667 | 794 | 3.513 | 23816.4 |
403 | 2023-12-19 14:10:32 | lilac | 2 | 53800 | 33 | 1.563 | 34421.0 |
402 | 2023-12-17 04:18:24 | lilac | 1 | 28756 | 3 | 0.533 | 53951.2 |
401 | 2023-12-16 11:44:45 | lilac | 1 | 28756 | 3 | 0.516 | 55728.7 |
400 | 2023-12-04 16:49:07 | lilac | 3 | 83667 | 794 | 7.126 | 11741.1 |
399 | 2023-11-13 22:50:15 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
398 | 2023-11-13 11:10:30 | lilac | 3 | 83667 | 794 | 3.373 | 24804.9 |
397 | 2023-11-13 11:10:21 | lilac | 2 | 53800 | 33 | 1.360 | 39558.8 |
396 | 2023-11-12 01:44:43 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
395 | 2023-11-10 02:49:50 | lilac | 1 | 28756 | 3 | 1.046 | 27491.4 |
394 | 2023-11-04 02:59:17 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
393 | 2023-10-21 09:28:09 | lilac | 1 | 28756 | 3 | 0.470 | 61183.0 |
392 | 2023-10-18 15:36:21 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
391 | 2023-10-13 17:39:02 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
390 | 2023-10-05 14:24:08 | lilac | 1 | 28756 | 3 | 0.453 | 63479.0 |
389 | 2023-10-03 11:41:31 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
388 | 2023-09-28 23:50:35 | lilac | 1 | 28756 | 3 | 0.546 | 52666.7 |
387 | 2023-09-22 15:23:11 | lilac | 1 | 28756 | 3 | 0.420 | 68466.7 |
386 | 2023-09-01 09:28:31 | lilac | 3 | 83667 | 794 | 3.296 | 25384.4 |
385 | 2023-07-31 17:03:19 | lilac | 1 | 28756 | 3 | 0.423 | 67981.1 |
384 | 2023-07-19 04:41:06 | lilac | 1 | 28756 | 3 | 0.516 | 55728.7 |
383 | 2023-05-21 03:07:52 | lilac | 3 | 83667 | 794 | 3.453 | 24230.2 |
382 | 2023-04-27 05:20:49 | lilac | 1 | 28756 | 3 | 0.873 | 32939.3 |
381 | 2023-04-03 22:34:37 | lilac | 1 | 28756 | 3 | 0.876 | 32826.5 |
380 | 2023-02-27 23:13:26 | lilac | 3 | 83667 | 794 | 3.920 | 21343.6 |
379 | 2023-02-17 02:25:25 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
378 | 2022-12-17 01:50:48 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
377 | 2022-12-12 09:26:15 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
376 | 2022-12-09 10:35:31 | lilac | 3 | 83667 | 794 | 3.703 | 22594.4 |
375 | 2022-09-20 01:00:22 | lilac | 1 | 28756 | 3 | 0.596 | 48248.3 |
374 | 2022-09-01 14:30:26 | lilac | 3 | 83667 | 794 | 3.356 | 24930.6 |
373 | 2022-08-31 22:31:42 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
372 | 2022-08-23 23:51:57 | lilac | 1 | 28756 | 3 | 0.453 | 63479.0 |
371 | 2022-08-21 13:53:16 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
370 | 2022-08-15 09:04:14 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
369 | 2022-08-01 18:58:40 | lilac | 2 | 53800 | 33 | 1.390 | 38705.0 |
368 | 2022-07-29 05:27:37 | lilac | 1 | 28756 | 3 | 0.453 | 63479.0 |
367 | 2022-07-27 12:20:05 | lilac | 3 | 83667 | 794 | 3.360 | 24900.9 |
366 | 2022-07-10 10:22:33 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
365 | 2022-07-02 19:41:59 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
364 | 2022-06-15 21:50:40 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
363 | 2022-04-18 04:06:59 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
362 | 2022-04-07 14:22:33 | lilac | 1 | 28756 | 3 | 0.703 | 40904.7 |
361 | 2022-03-07 03:11:17 | lilac | 3 | 83667 | 794 | 3.470 | 24111.5 |
360 | 2022-03-05 13:52:56 | lilac | 2 | 53800 | 33 | 1.360 | 39558.8 |
359 | 2022-01-07 01:06:35 | lilac | 1 | 28756 | 3 | 0.470 | 61183.0 |
358 | 2021-12-26 20:16:22 | lilac | 1 | 28756 | 3 | 0.546 | 52666.7 |
357 | 2021-12-09 19:05:33 | lilac | 2 | 53800 | 33 | 1.576 | 34137.1 |
356 | 2021-12-02 22:48:53 | lilac | 3 | 83667 | 794 | 4.140 | 20209.4 |
355 | 2021-11-09 10:08:13 | lilac | 1 | 28756 | 3 | 0.593 | 48492.4 |
354 | 2021-11-07 07:49:12 | lilac | 1 | 28756 | 3 | 0.516 | 55728.7 |
353 | 2021-09-26 23:04:46 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
352 | 2021-09-25 14:32:22 | lilac | 3 | 83667 | 794 | 3.376 | 24782.9 |
351 | 2021-09-24 20:31:19 | lilac | 1 | 28756 | 3 | 0.486 | 59168.7 |
350 | 2021-09-06 19:33:04 | lilac | 1 | 28756 | 3 | 0.453 | 63479.0 |
349 | 2021-09-05 09:51:46 | lilac | 1 | 28756 | 3 | 0.470 | 61183.0 |
348 | 2021-07-06 08:55:46 | lilac | 3 | 83667 | 794 | 3.706 | 22576.1 |
347 | 2021-06-05 19:19:44 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
346 | 2021-05-27 17:15:04 | lilac | 1 | 28756 | 3 | 0.516 | 55728.7 |
345 | 2021-05-16 11:03:39 | lilac | 3 | 83667 | 794 | 3.673 | 22778.9 |
344 | 2021-05-15 10:25:25 | lilac | 3 | 83667 | 794 | 3.796 | 22040.8 |
343 | 2021-05-01 23:08:35 | lilac | 1 | 28756 | 3 | 0.483 | 59536.2 |
342 | 2021-04-30 16:18:42 | lilac | 1 | 28756 | 3 | 0.533 | 53951.2 |
341 | 2021-04-20 20:02:51 | lilac | 3 | 83667 | 794 | 3.360 | 24900.9 |
340 | 2021-03-03 16:33:29 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
339 | 2021-02-01 22:18:54 | lilac | 3 | 83667 | 794 | 3.360 | 24900.9 |
338 | 2021-01-14 20:19:48 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
337 | 2020-12-25 05:49:08 | lilac | 2 | 53800 | 33 | 1.373 | 39184.3 |
336 | 2020-12-02 14:45:51 | lilac | 1 | 28756 | 3 | 0.500 | 57512.0 |
335 | 2020-11-23 11:16:40 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
334 | 2020-11-17 17:09:25 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
333 | 2020-10-22 17:12:36 | lilac | 1 | 28756 | 3 | 0.453 | 63479.0 |
332 | 2020-10-22 17:06:06 | lilac | 1 | 28756 | 3 | 0.470 | 61183.0 |
331 | 2020-10-21 08:19:06 | lilac | 1 | 28756 | 3 | 0.453 | 63479.0 |
330 | 2020-10-01 21:10:43 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
329 | 2020-09-21 21:16:08 | lilac | 1 | 28756 | 3 | 0.546 | 52666.7 |
328 | 2020-09-21 11:08:53 | lilac | 1 | 28756 | 3 | 0.436 | 65954.1 |
327 | 2020-08-31 13:29:47 | lilac | 1 | 28756 | 3 | 0.530 | 54256.6 |
326 | 2020-08-03 09:57:38 | lilac | 1 | 28756 | 3 | 0.453 | 63479.0 |
325 | 2020-05-29 19:48:44 | lilac | 1 | 28756 | 3 | 0.440 | 65354.5 |
324 | 2020-04-20 04:16:33 | lilac | 2 | 53800 | 33 | 1.563 | 34421.0 |