History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yellow"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
408 | 2024-04-17 11:10:57 | yellow | 1 | 48755 | 6 | 0.920 | 52994.6 |
407 | 2024-04-06 13:08:48 | yellow | 1 | 48755 | 6 | 3.030 | 16090.8 |
406 | 2024-04-02 22:18:13 | yellow | 2 | 82551 | 41 | 5.766 | 14316.9 |
405 | 2024-04-01 02:18:00 | yellow | 2 | 82551 | 41 | 5.563 | 14839.3 |
404 | 2024-03-30 19:30:30 | yellow | 3 | 112716 | 258 | 16.453 | 6850.8 |
403 | 2024-03-29 19:28:51 | yellow | 2 | 82551 | 41 | 2.733 | 30205.3 |
402 | 2024-03-29 19:28:36 | yellow | 3 | 112716 | 258 | 6.373 | 17686.5 |
401 | 2024-03-29 01:55:14 | yellow | 2 | 82551 | 41 | 6.516 | 12669.0 |
400 | 2024-03-29 01:54:53 | yellow | 3 | 112716 | 258 | 18.186 | 6198.0 |
399 | 2024-03-28 18:13:36 | yellow | 3 | 112716 | 258 | 6.593 | 17096.3 |
398 | 2024-03-28 18:13:41 | yellow | 1 | 48755 | 6 | 0.860 | 56691.9 |
397 | 2024-03-28 18:13:35 | yellow | 2 | 82551 | 41 | 2.796 | 29524.7 |
396 | 2024-03-28 18:13:29 | yellow | 1 | 48755 | 6 | 0.873 | 55847.7 |
395 | 2024-03-07 05:56:40 | yellow | 1 | 48755 | 6 | 2.016 | 24184.0 |
394 | 2024-02-28 10:34:21 | yellow | 3 | 112716 | 258 | 5.703 | 19764.3 |
393 | 2024-02-28 10:34:20 | yellow | 2 | 82551 | 41 | 2.470 | 33421.5 |
392 | 2024-02-27 15:28:55 | yellow | 3 | 112716 | 258 | 5.390 | 20912.1 |
391 | 2024-02-27 15:28:57 | yellow | 2 | 82551 | 41 | 2.516 | 32810.4 |
390 | 2024-02-27 15:28:54 | yellow | 1 | 48755 | 6 | 0.800 | 60943.8 |
389 | 2024-01-29 13:21:48 | yellow | 2 | 82551 | 41 | 2.500 | 33020.4 |
388 | 2024-01-29 13:21:43 | yellow | 1 | 48755 | 6 | 0.826 | 59025.4 |
387 | 2024-01-22 08:22:08 | yellow | 3 | 112716 | 258 | 5.250 | 21469.7 |
386 | 2024-01-15 12:06:51 | yellow | 3 | 112716 | 258 | 4.593 | 24540.8 |
385 | 2023-12-31 16:14:49 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
384 | 2023-12-31 04:23:08 | yellow | 1 | 48755 | 6 | 0.813 | 59969.2 |
383 | 2023-12-13 21:05:38 | yellow | 3 | 112716 | 258 | 5.596 | 20142.2 |
382 | 2023-12-09 01:05:00 | yellow | 2 | 82551 | 41 | 2.110 | 39123.7 |
381 | 2023-12-02 08:03:55 | yellow | 1 | 48755 | 6 | 0.826 | 59025.4 |
380 | 2023-11-11 08:06:29 | yellow | 3 | 112716 | 258 | 16.846 | 6691.0 |
379 | 2023-11-10 19:06:06 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
378 | 2023-11-05 02:30:45 | yellow | 1 | 48755 | 6 | 0.860 | 56691.9 |
377 | 2023-11-02 00:48:53 | yellow | 1 | 48755 | 6 | 0.780 | 62506.4 |
376 | 2023-11-01 19:33:49 | yellow | 3 | 112716 | 258 | 4.950 | 22770.9 |
375 | 2023-10-17 21:57:36 | yellow | 1 | 48755 | 6 | 0.720 | 67715.3 |
374 | 2023-10-11 21:47:14 | yellow | 1 | 48755 | 6 | 0.796 | 61250.0 |
373 | 2023-09-29 00:02:19 | yellow | 1 | 48755 | 6 | 0.733 | 66514.3 |
372 | 2023-09-19 14:17:31 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
371 | 2023-08-14 04:57:33 | yellow | 1 | 48755 | 6 | 0.830 | 58741.0 |
370 | 2023-08-09 15:49:13 | yellow | 3 | 112716 | 258 | 4.560 | 24718.4 |
369 | 2023-08-01 11:42:54 | yellow | 1 | 48755 | 6 | 0.813 | 59969.2 |
368 | 2023-05-10 10:04:12 | yellow | 1 | 48755 | 6 | 0.720 | 67715.3 |
367 | 2023-04-18 08:36:26 | yellow | 3 | 112716 | 258 | 4.453 | 25312.4 |
366 | 2023-03-18 22:29:54 | yellow | 1 | 48755 | 6 | 0.843 | 57835.1 |
365 | 2023-03-06 23:48:06 | yellow | 1 | 48755 | 6 | 0.720 | 67715.3 |
364 | 2023-01-26 09:17:31 | yellow | 3 | 112716 | 258 | 5.546 | 20323.8 |
363 | 2023-01-12 20:36:17 | yellow | 3 | 112716 | 258 | 5.140 | 21929.2 |
362 | 2022-12-28 19:53:43 | yellow | 1 | 48755 | 6 | 0.720 | 67715.3 |
361 | 2022-12-12 10:35:52 | yellow | 3 | 112716 | 258 | 4.923 | 22895.8 |
360 | 2022-11-08 19:20:34 | yellow | 3 | 112716 | 258 | 5.423 | 20784.8 |
359 | 2022-11-06 13:38:47 | yellow | 1 | 48755 | 6 | 1.610 | 30282.6 |
358 | 2022-09-18 16:30:25 | yellow | 1 | 48755 | 6 | 0.733 | 66514.3 |
357 | 2022-09-15 13:17:18 | yellow | 1 | 48755 | 6 | 0.890 | 54780.9 |
356 | 2022-07-19 13:16:58 | yellow | 1 | 48755 | 6 | 0.720 | 67715.3 |
355 | 2022-07-10 05:20:36 | yellow | 1 | 48755 | 6 | 0.796 | 61250.0 |
354 | 2022-06-21 23:02:19 | yellow | 1 | 48755 | 6 | 0.720 | 67715.3 |
353 | 2022-06-10 22:08:50 | yellow | 3 | 112716 | 258 | 4.576 | 24632.0 |
352 | 2022-03-16 23:34:14 | yellow | 1 | 48755 | 6 | 0.780 | 62506.4 |
351 | 2022-02-13 05:06:21 | yellow | 1 | 48755 | 6 | 0.766 | 63648.8 |
350 | 2022-02-06 13:21:20 | yellow | 1 | 48755 | 6 | 0.860 | 56691.9 |
349 | 2021-12-25 02:30:07 | yellow | 1 | 48755 | 6 | 0.796 | 61250.0 |
348 | 2021-10-29 22:52:11 | yellow | 1 | 48755 | 6 | 0.826 | 59025.4 |
347 | 2021-10-27 21:30:24 | yellow | 1 | 48755 | 6 | 0.813 | 59969.2 |
346 | 2021-10-04 00:45:38 | yellow | 1 | 48755 | 6 | 0.826 | 59025.4 |
345 | 2021-09-13 23:19:45 | yellow | 1 | 48755 | 6 | 0.860 | 56691.9 |
344 | 2021-08-27 09:00:02 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
343 | 2021-07-25 06:34:53 | yellow | 1 | 48755 | 6 | 0.703 | 69352.8 |
342 | 2021-07-01 10:37:35 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
341 | 2021-05-15 12:02:32 | yellow | 1 | 48755 | 6 | 0.810 | 60191.4 |
340 | 2021-03-31 12:45:58 | yellow | 1 | 48755 | 6 | 1.703 | 28628.9 |
339 | 2021-03-18 11:54:22 | yellow | 1 | 48755 | 6 | 0.796 | 61250.0 |
338 | 2021-03-15 22:45:56 | yellow | 2 | 82551 | 41 | 4.530 | 18223.2 |
337 | 2021-02-18 23:08:39 | yellow | 2 | 82551 | 41 | 2.453 | 33653.1 |
336 | 2021-01-28 05:06:20 | yellow | 1 | 48755 | 6 | 0.733 | 66514.3 |
335 | 2020-12-30 12:11:51 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
334 | 2020-12-27 00:13:16 | yellow | 1 | 48755 | 6 | 0.796 | 61250.0 |
333 | 2020-11-03 12:44:36 | yellow | 1 | 48755 | 6 | 0.783 | 62266.9 |
332 | 2020-11-02 15:06:28 | yellow | 1 | 48755 | 6 | 0.873 | 55847.7 |
331 | 2020-10-02 18:21:55 | yellow | 1 | 48755 | 6 | 0.716 | 68093.6 |
330 | 2020-09-23 08:44:17 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
329 | 2020-08-14 15:05:44 | yellow | 1 | 48755 | 6 | 0.763 | 63899.1 |
328 | 2020-08-09 18:21:56 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
327 | 2020-06-12 06:09:40 | yellow | 1 | 48755 | 6 | 0.813 | 59969.2 |
326 | 2020-06-06 09:16:18 | yellow | 1 | 48755 | 6 | 0.750 | 65006.7 |
325 | 2020-06-03 12:40:32 | yellow | 1 | 48755 | 6 | 0.716 | 68093.6 |
324 | 2020-03-29 06:32:47 | yellow | 1 | 48755 | 6 | 0.906 | 53813.5 |
323 | 2020-03-28 07:28:17 | yellow | 1 | 48755 | 6 | 1.720 | 28345.9 |
322 | 2020-03-26 07:28:01 | yellow | 1 | 48755 | 6 | 0.826 | 59025.4 |
321 | 2020-03-24 01:56:45 | yellow | 1 | 48755 | 6 | 0.890 | 54780.9 |
320 | 2020-03-23 23:08:22 | yellow | 1 | 48755 | 6 | 0.796 | 61250.0 |
319 | 2020-03-20 01:33:21 | yellow | 1 | 48755 | 6 | 0.813 | 59969.2 |
318 | 2020-03-16 21:58:18 | yellow | 1 | 48755 | 6 | 0.843 | 57835.1 |
317 | 2020-02-29 07:27:53 | yellow | 1 | 48755 | 6 | 0.906 | 53813.5 |
316 | 2020-02-22 23:33:37 | yellow | 1 | 48755 | 6 | 0.923 | 52822.3 |
315 | 2020-02-14 21:41:24 | yellow | 1 | 48755 | 6 | 0.983 | 49598.2 |
314 | 2020-02-13 05:17:31 | yellow | 1 | 48755 | 6 | 1.843 | 26454.2 |
313 | 2020-02-12 14:00:24 | yellow | 1 | 48755 | 6 | 0.906 | 53813.5 |
312 | 2020-02-05 18:49:46 | yellow | 1 | 48755 | 6 | 0.970 | 50262.9 |
311 | 2020-02-04 07:01:47 | yellow | 1 | 48755 | 6 | 0.950 | 51321.1 |
310 | 2020-01-30 03:58:48 | yellow | 1 | 48755 | 6 | 0.876 | 55656.4 |
309 | 2020-01-25 11:29:41 | yellow | 1 | 48755 | 6 | 0.830 | 58741.0 |