History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lehua"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
417 | 2024-04-26 23:10:35 | lehua | 1 | 28756 | 2 | 2.093 | 13739.1 |
416 | 2024-04-16 23:03:26 | lehua | 1 | 28756 | 2 | 0.546 | 52666.7 |
415 | 2024-04-16 22:57:07 | lehua | 1 | 28756 | 2 | 1.170 | 24577.8 |
414 | 2024-04-06 07:44:47 | lehua | 3 | 83667 | 435 | 7.826 | 10690.9 |
413 | 2024-04-06 07:44:50 | lehua | 2 | 53800 | 17 | 1.923 | 27977.1 |
412 | 2024-04-06 07:44:43 | lehua | 1 | 28756 | 2 | 1.080 | 26625.9 |
411 | 2024-03-31 15:45:54 | lehua | 1 | 28756 | 2 | 0.453 | 63479.0 |
410 | 2024-03-29 18:04:45 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
409 | 2024-03-07 05:57:23 | lehua | 1 | 28756 | 2 | 1.170 | 24577.8 |
408 | 2024-03-01 13:49:17 | lehua | 1 | 28756 | 2 | 0.513 | 56054.6 |
407 | 2024-02-28 14:11:15 | lehua | 2 | 53800 | 17 | 1.690 | 31834.3 |
406 | 2024-02-28 14:10:56 | lehua | 3 | 83667 | 435 | 6.500 | 12871.8 |
405 | 2024-02-28 07:49:06 | lehua | 3 | 83667 | 435 | 10.766 | 7771.4 |
404 | 2024-02-28 07:49:09 | lehua | 2 | 53800 | 17 | 2.186 | 24611.2 |
403 | 2024-02-28 07:48:49 | lehua | 1 | 28756 | 2 | 0.953 | 30174.2 |
402 | 2024-02-20 09:10:15 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
401 | 2024-02-03 23:24:03 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
400 | 2024-01-31 05:30:26 | lehua | 1 | 28756 | 2 | 0.483 | 59536.2 |
399 | 2024-01-29 14:57:59 | lehua | 2 | 53800 | 17 | 1.686 | 31909.8 |
398 | 2024-01-29 14:57:55 | lehua | 1 | 28756 | 2 | 0.516 | 55728.7 |
397 | 2024-01-29 03:32:41 | lehua | 1 | 28756 | 2 | 0.533 | 53951.2 |
396 | 2023-12-31 10:24:45 | lehua | 3 | 83667 | 435 | 3.656 | 22884.8 |
395 | 2023-12-31 10:24:43 | lehua | 2 | 53800 | 17 | 1.516 | 35488.1 |
394 | 2023-12-22 21:38:17 | lehua | 3 | 83667 | 435 | 3.826 | 21868.0 |
393 | 2023-12-22 21:38:15 | lehua | 2 | 53800 | 17 | 1.530 | 35163.4 |
392 | 2023-11-26 19:58:00 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
391 | 2023-11-25 11:46:33 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
390 | 2023-11-13 23:07:18 | lehua | 1 | 28756 | 2 | 0.453 | 63479.0 |
389 | 2023-11-12 04:10:30 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
388 | 2023-11-04 02:14:49 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
387 | 2023-10-24 04:53:09 | lehua | 1 | 28756 | 2 | 0.486 | 59168.7 |
386 | 2023-10-23 03:09:24 | lehua | 1 | 28756 | 2 | 0.483 | 59536.2 |
385 | 2023-10-13 17:38:55 | lehua | 1 | 28756 | 2 | 0.486 | 59168.7 |
384 | 2023-10-08 17:10:22 | lehua | 1 | 28756 | 2 | 0.453 | 63479.0 |
383 | 2023-09-28 12:30:22 | lehua | 1 | 28756 | 2 | 0.453 | 63479.0 |
382 | 2023-09-26 19:23:04 | lehua | 1 | 28756 | 2 | 0.906 | 31739.5 |
381 | 2023-09-25 04:41:06 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
380 | 2023-09-14 02:33:59 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
379 | 2023-09-12 08:31:27 | lehua | 1 | 28756 | 2 | 0.483 | 59536.2 |
378 | 2023-06-23 16:37:37 | lehua | 1 | 28756 | 2 | 0.513 | 56054.6 |
377 | 2023-05-12 08:09:33 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
376 | 2023-04-05 04:21:25 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
375 | 2023-01-20 17:56:28 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
374 | 2023-01-11 16:41:24 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
373 | 2022-11-16 14:58:48 | lehua | 1 | 28756 | 2 | 0.470 | 61183.0 |
372 | 2022-09-06 06:16:32 | lehua | 1 | 28756 | 2 | 0.483 | 59536.2 |
371 | 2022-08-29 14:37:22 | lehua | 1 | 28756 | 2 | 0.483 | 59536.2 |
370 | 2022-07-08 15:38:49 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
369 | 2022-04-16 07:45:21 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
368 | 2022-03-09 02:05:17 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
367 | 2022-01-03 08:38:32 | lehua | 1 | 28756 | 2 | 0.486 | 59168.7 |
366 | 2021-12-15 12:58:56 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
365 | 2021-08-29 11:26:42 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
364 | 2021-07-31 01:01:34 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
363 | 2021-05-20 08:33:48 | lehua | 1 | 28756 | 2 | 0.450 | 63902.2 |
362 | 2021-05-12 02:47:20 | lehua | 1 | 28756 | 2 | 0.530 | 54256.6 |
361 | 2021-04-20 13:12:05 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
360 | 2021-04-15 23:55:01 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
359 | 2021-02-24 14:31:36 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
358 | 2021-02-07 18:13:33 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
357 | 2021-02-02 19:11:57 | lehua | 1 | 28756 | 2 | 0.470 | 61183.0 |
356 | 2021-01-05 05:41:29 | lehua | 1 | 28756 | 2 | 0.453 | 63479.0 |
355 | 2020-12-08 01:05:14 | lehua | 1 | 28756 | 2 | 0.440 | 65354.5 |
354 | 2020-10-31 22:56:58 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
353 | 2020-10-31 22:12:23 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
352 | 2020-10-28 17:55:38 | lehua | 1 | 28756 | 2 | 0.453 | 63479.0 |
351 | 2020-10-20 10:11:30 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
350 | 2020-10-18 18:01:33 | lehua | 1 | 28756 | 2 | 0.516 | 55728.7 |
349 | 2020-08-01 20:40:38 | lehua | 1 | 28756 | 2 | 0.466 | 61708.2 |
348 | 2020-04-30 09:26:38 | lehua | 1 | 28756 | 2 | 0.593 | 48492.4 |
347 | 2020-03-27 08:19:19 | lehua | 1 | 28756 | 2 | 0.706 | 40730.9 |
346 | 2020-03-25 01:39:03 | lehua | 1 | 28756 | 2 | 1.123 | 25606.4 |
345 | 2020-03-23 12:27:20 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
344 | 2020-03-21 22:51:46 | lehua | 1 | 28756 | 2 | 0.530 | 54256.6 |
343 | 2020-03-21 16:29:42 | lehua | 1 | 28756 | 2 | 0.470 | 61183.0 |
342 | 2020-03-21 00:08:59 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
341 | 2020-03-17 20:59:51 | lehua | 1 | 28756 | 2 | 0.436 | 65954.1 |
340 | 2020-02-24 20:08:11 | lehua | 1 | 28756 | 2 | 1.170 | 24577.8 |
339 | 2020-02-24 12:18:02 | lehua | 1 | 28756 | 2 | 1.033 | 27837.4 |
338 | 2020-02-10 01:30:11 | lehua | 1 | 28756 | 2 | 1.110 | 25906.3 |
337 | 2020-02-02 02:14:15 | lehua | 1 | 28756 | 2 | 0.530 | 54256.6 |
336 | 2020-01-31 14:27:30 | lehua | 1 | 28756 | 2 | 0.546 | 52666.7 |
335 | 2020-01-30 20:35:49 | lehua | 1 | 28756 | 2 | 1.190 | 24164.7 |
334 | 2020-01-30 04:43:43 | lehua | 1 | 28756 | 2 | 1.140 | 25224.6 |
333 | 2020-01-29 10:20:09 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
332 | 2020-01-27 14:07:33 | lehua | 1 | 28756 | 2 | 0.453 | 63479.0 |
331 | 2020-01-27 12:33:05 | lehua | 1 | 28756 | 2 | 0.530 | 54256.6 |
330 | 2020-01-20 13:10:47 | lehua | 1 | 28756 | 2 | 1.153 | 24940.2 |
329 | 2020-01-11 21:30:21 | lehua | 1 | 28756 | 2 | 1.326 | 21686.3 |
328 | 2020-01-11 07:36:21 | lehua | 1 | 28756 | 2 | 1.076 | 26724.9 |
327 | 2020-01-09 16:36:57 | lehua | 1 | 28756 | 2 | 0.516 | 55728.7 |
326 | 2020-01-02 00:53:25 | lehua | 1 | 28756 | 2 | 0.546 | 52666.7 |
325 | 2019-12-25 11:42:32 | lehua | 1 | 28756 | 2 | 0.593 | 48492.4 |
324 | 2019-12-25 06:45:57 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
323 | 2019-12-24 09:40:29 | lehua | 1 | 28756 | 2 | 0.530 | 54256.6 |
322 | 2019-12-23 13:35:36 | lehua | 1 | 28756 | 2 | 0.500 | 57512.0 |
321 | 2019-12-09 14:30:34 | lehua | 2 | 53800 | 17 | 1.453 | 37026.8 |
320 | 2019-11-28 16:36:40 | lehua | 3 | 83667 | 435 | 4.016 | 20833.4 |
319 | 2019-11-27 10:10:32 | lehua | 2 | 53800 | 17 | 1.453 | 37026.8 |
318 | 2019-11-25 18:32:41 | lehua | 3 | 83667 | 435 | 3.466 | 24139.4 |