History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yacht"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
424 | 2024-03-08 23:47:01 | yacht | 2 | 53800 | 41 | 3.406 | 15795.7 |
423 | 2024-03-08 23:46:58 | yacht | 1 | 28756 | 2 | 0.626 | 45936.1 |
422 | 2024-03-08 23:46:24 | yacht | 2 | 53800 | 41 | 2.063 | 26078.5 |
421 | 2024-03-08 23:46:04 | yacht | 3 | 83667 | 609 | 7.483 | 11180.9 |
420 | 2024-03-07 07:27:56 | yacht | 3 | 83667 | 609 | 11.610 | 7206.5 |
419 | 2024-03-07 07:27:50 | yacht | 2 | 53800 | 41 | 3.283 | 16387.5 |
418 | 2024-03-07 05:03:23 | yacht | 1 | 28756 | 2 | 1.580 | 18200.0 |
417 | 2024-03-01 11:41:52 | yacht | 1 | 28756 | 2 | 0.483 | 59536.2 |
416 | 2024-02-28 20:39:25 | yacht | 1 | 28756 | 2 | 0.486 | 59168.7 |
415 | 2024-02-13 10:58:30 | yacht | 3 | 83667 | 609 | 5.686 | 14714.6 |
414 | 2024-02-13 00:38:00 | yacht | 3 | 83667 | 609 | 3.860 | 21675.4 |
413 | 2024-02-03 22:58:11 | yacht | 1 | 28756 | 2 | 1.046 | 27491.4 |
412 | 2024-01-29 19:36:01 | yacht | 1 | 28756 | 2 | 0.453 | 63479.0 |
411 | 2024-01-29 10:52:55 | yacht | 1 | 28756 | 2 | 0.516 | 55728.7 |
410 | 2024-01-15 07:25:54 | yacht | 2 | 53800 | 41 | 1.593 | 33772.8 |
409 | 2024-01-11 00:33:12 | yacht | 3 | 83667 | 609 | 4.140 | 20209.4 |
408 | 2024-01-09 06:03:02 | yacht | 2 | 53800 | 41 | 1.453 | 37026.8 |
407 | 2024-01-07 23:42:59 | yacht | 1 | 28756 | 2 | 0.423 | 67981.1 |
406 | 2024-01-01 09:53:35 | yacht | 3 | 83667 | 609 | 3.296 | 25384.4 |
405 | 2023-12-16 20:26:25 | yacht | 3 | 83667 | 609 | 3.406 | 24564.6 |
404 | 2023-12-16 20:26:24 | yacht | 2 | 53800 | 41 | 1.533 | 35094.6 |
403 | 2023-11-23 14:20:41 | yacht | 3 | 83667 | 609 | 3.970 | 21074.8 |
402 | 2023-11-23 14:20:42 | yacht | 2 | 53800 | 41 | 1.703 | 31591.3 |
401 | 2023-11-17 22:40:41 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
400 | 2023-11-14 02:38:27 | yacht | 3 | 83667 | 609 | 3.190 | 26227.9 |
399 | 2023-11-12 03:41:21 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
398 | 2023-11-03 12:47:12 | yacht | 1 | 28756 | 2 | 0.466 | 61708.2 |
397 | 2023-11-01 06:12:59 | yacht | 1 | 28756 | 2 | 0.440 | 65354.5 |
396 | 2023-10-21 23:27:42 | yacht | 1 | 28756 | 2 | 0.423 | 67981.1 |
395 | 2023-10-18 13:32:55 | yacht | 1 | 28756 | 2 | 0.453 | 63479.0 |
394 | 2023-10-17 04:12:50 | yacht | 2 | 53800 | 41 | 1.516 | 35488.1 |
393 | 2023-10-11 05:03:39 | yacht | 1 | 28756 | 2 | 0.466 | 61708.2 |
392 | 2023-10-07 09:37:10 | yacht | 1 | 28756 | 2 | 0.440 | 65354.5 |
391 | 2023-10-03 12:06:56 | yacht | 3 | 83667 | 609 | 3.983 | 21006.0 |
390 | 2023-10-01 17:52:38 | yacht | 3 | 83667 | 609 | 3.610 | 23176.5 |
389 | 2023-10-01 17:52:39 | yacht | 2 | 53800 | 41 | 1.626 | 33087.3 |
388 | 2023-09-29 08:17:01 | yacht | 1 | 28756 | 2 | 0.500 | 57512.0 |
387 | 2023-09-14 03:09:51 | yacht | 1 | 28756 | 2 | 0.703 | 40904.7 |
386 | 2023-08-25 19:22:11 | yacht | 1 | 28756 | 2 | 0.516 | 55728.7 |
385 | 2023-08-16 22:37:35 | yacht | 3 | 83667 | 609 | 3.220 | 25983.5 |
384 | 2023-07-23 15:55:48 | yacht | 1 | 28756 | 2 | 0.466 | 61708.2 |
383 | 2023-05-29 00:16:54 | yacht | 1 | 28756 | 2 | 0.423 | 67981.1 |
382 | 2023-04-28 07:38:39 | yacht | 3 | 83667 | 609 | 3.703 | 22594.4 |
381 | 2023-04-06 13:41:14 | yacht | 2 | 53800 | 41 | 1.500 | 35866.7 |
380 | 2023-03-25 03:48:11 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
379 | 2023-03-11 06:48:24 | yacht | 1 | 28756 | 2 | 0.500 | 57512.0 |
378 | 2023-02-02 20:37:23 | yacht | 3 | 83667 | 609 | 3.140 | 26645.5 |
377 | 2023-01-08 23:47:36 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
376 | 2023-01-04 09:10:25 | yacht | 2 | 53800 | 41 | 1.313 | 40974.9 |
375 | 2022-11-15 23:32:16 | yacht | 3 | 83667 | 609 | 4.173 | 20049.6 |
374 | 2022-10-18 12:54:04 | yacht | 1 | 28756 | 2 | 0.533 | 53951.2 |
373 | 2022-10-14 19:29:04 | yacht | 1 | 28756 | 2 | 0.423 | 67981.1 |
372 | 2022-10-08 15:39:21 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
371 | 2022-09-07 22:02:51 | yacht | 2 | 53800 | 41 | 1.343 | 40059.6 |
370 | 2022-09-05 19:56:22 | yacht | 2 | 53800 | 41 | 1.483 | 36277.8 |
369 | 2022-08-15 11:37:06 | yacht | 1 | 28756 | 2 | 0.466 | 61708.2 |
368 | 2022-08-14 06:21:31 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
367 | 2022-07-11 09:38:23 | yacht | 3 | 83667 | 609 | 3.140 | 26645.5 |
366 | 2022-06-26 05:35:16 | yacht | 3 | 83667 | 609 | 3.593 | 23286.1 |
365 | 2022-06-20 14:33:17 | yacht | 3 | 83667 | 609 | 3.173 | 26368.4 |
364 | 2022-05-27 18:33:50 | yacht | 1 | 28756 | 2 | 0.483 | 59536.2 |
363 | 2022-05-24 00:26:09 | yacht | 1 | 28756 | 2 | 0.466 | 61708.2 |
362 | 2022-05-17 02:29:13 | yacht | 1 | 28756 | 2 | 0.440 | 65354.5 |
361 | 2022-03-24 22:10:15 | yacht | 2 | 53800 | 41 | 2.000 | 26900.0 |
360 | 2022-02-11 05:05:02 | yacht | 1 | 28756 | 2 | 0.593 | 48492.4 |
359 | 2022-02-09 00:28:31 | yacht | 1 | 28756 | 2 | 0.440 | 65354.5 |
358 | 2022-01-09 04:10:22 | yacht | 1 | 28756 | 2 | 0.453 | 63479.0 |
357 | 2021-12-02 19:33:56 | yacht | 1 | 28756 | 2 | 1.080 | 26625.9 |
356 | 2021-11-30 17:01:27 | yacht | 1 | 28756 | 2 | 0.563 | 51076.4 |
355 | 2021-11-10 19:53:38 | yacht | 1 | 28756 | 2 | 0.516 | 55728.7 |
354 | 2021-10-10 04:09:15 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
353 | 2021-09-10 13:21:07 | yacht | 1 | 28756 | 2 | 0.483 | 59536.2 |
352 | 2021-09-08 06:03:02 | yacht | 1 | 28756 | 2 | 0.420 | 68466.7 |
351 | 2021-09-06 01:16:08 | yacht | 1 | 28756 | 2 | 0.453 | 63479.0 |
350 | 2021-08-21 14:54:12 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
349 | 2021-07-26 12:57:00 | yacht | 1 | 28756 | 2 | 0.483 | 59536.2 |
348 | 2021-05-24 07:35:40 | yacht | 1 | 28756 | 2 | 0.423 | 67981.1 |
347 | 2021-05-16 14:19:45 | yacht | 1 | 28756 | 2 | 0.533 | 53951.2 |
346 | 2021-05-15 18:20:45 | yacht | 1 | 28756 | 2 | 0.533 | 53951.2 |
345 | 2021-04-22 08:28:24 | yacht | 1 | 28756 | 2 | 0.516 | 55728.7 |
344 | 2021-04-16 08:21:38 | yacht | 1 | 28756 | 2 | 0.513 | 56054.6 |
343 | 2021-03-19 10:48:53 | yacht | 1 | 28756 | 2 | 0.516 | 55728.7 |
342 | 2021-01-28 03:27:36 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
341 | 2021-01-28 02:50:33 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
340 | 2021-01-26 01:56:37 | yacht | 1 | 28756 | 2 | 0.733 | 39230.6 |
339 | 2020-12-31 16:17:50 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
338 | 2020-11-08 21:49:14 | yacht | 1 | 28756 | 2 | 0.986 | 29164.3 |
337 | 2020-10-31 05:15:16 | yacht | 1 | 28756 | 2 | 0.483 | 59536.2 |
336 | 2020-10-16 23:00:13 | yacht | 1 | 28756 | 2 | 0.703 | 40904.7 |
335 | 2020-10-14 21:17:13 | yacht | 1 | 28756 | 2 | 0.423 | 67981.1 |
334 | 2020-08-18 14:20:08 | yacht | 1 | 28756 | 2 | 0.516 | 55728.7 |
333 | 2020-06-17 08:40:49 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
332 | 2020-06-01 09:08:54 | yacht | 1 | 28756 | 2 | 0.466 | 61708.2 |
331 | 2020-03-29 19:59:56 | yacht | 1 | 28756 | 2 | 0.466 | 61708.2 |
330 | 2020-03-25 09:22:33 | yacht | 1 | 28756 | 2 | 0.483 | 59536.2 |
329 | 2020-03-23 11:50:29 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
328 | 2020-03-21 20:49:02 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
327 | 2020-03-21 05:30:46 | yacht | 1 | 28756 | 2 | 0.453 | 63479.0 |
326 | 2020-03-20 19:12:57 | yacht | 1 | 28756 | 2 | 0.436 | 65954.1 |
325 | 2020-03-18 03:20:47 | yacht | 1 | 28756 | 2 | 0.423 | 67981.1 |