History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"retinol"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
437 | 2025-04-24 04:47:15 | retinol | 2 | 107671 | 19 | 17.673 | 6092.4 |
436 | 2025-04-21 01:35:48 | retinol | 3 | 134027 | 204 | 40.516 | 3308.0 |
435 | 2025-04-20 19:41:51 | retinol | 3 | 134027 | 204 | 35.656 | 3758.9 |
434 | 2025-04-20 10:08:26 | retinol | 2 | 107671 | 19 | 3.513 | 30649.3 |
433 | 2025-04-20 09:43:57 | retinol | 1 | 69583 | 3 | 4.533 | 15350.3 |
432 | 2025-04-20 01:59:36 | retinol | 3 | 134027 | 204 | 38.330 | 3496.7 |
431 | 2025-04-18 07:11:20 | retinol | 2 | 107671 | 19 | 10.720 | 10043.9 |
430 | 2025-04-15 22:47:03 | retinol | 1 | 69583 | 3 | 3.220 | 21609.6 |
429 | 2025-04-11 14:23:06 | retinol | 1 | 69583 | 3 | 6.263 | 11110.2 |
428 | 2025-03-27 15:06:24 | retinol | 1 | 69583 | 3 | 6.093 | 11420.2 |
427 | 2025-03-20 12:06:05 | retinol | 1 | 69583 | 3 | 6.373 | 10918.4 |
426 | 2025-03-17 07:47:25 | retinol | 1 | 69583 | 3 | 6.076 | 11452.1 |
425 | 2025-03-15 01:12:35 | retinol | 1 | 69583 | 3 | 6.266 | 11104.9 |
424 | 2025-03-09 11:06:37 | retinol | 1 | 69583 | 3 | 4.733 | 14701.7 |
423 | 2025-03-09 08:03:30 | retinol | 1 | 69583 | 3 | 7.343 | 9476.1 |
422 | 2025-02-24 14:42:16 | retinol | 1 | 69583 | 3 | 6.326 | 10999.5 |
421 | 2025-02-08 20:31:09 | retinol | 1 | 69583 | 3 | 8.800 | 7907.2 |
420 | 2025-02-04 01:33:55 | retinol | 1 | 69583 | 3 | 1.186 | 58670.3 |
419 | 2025-02-03 22:35:44 | retinol | 1 | 69583 | 3 | 2.970 | 23428.6 |
418 | 2025-01-15 06:29:37 | retinol | 1 | 69583 | 3 | 5.466 | 12730.2 |
417 | 2025-01-15 04:59:05 | retinol | 2 | 107671 | 19 | 16.453 | 6544.2 |
416 | 2025-01-12 16:29:59 | retinol | 3 | 134027 | 204 | 34.106 | 3929.7 |
415 | 2025-01-12 13:42:43 | retinol | 2 | 107671 | 19 | 16.453 | 6544.2 |
414 | 2025-01-12 13:42:29 | retinol | 3 | 134027 | 204 | 28.610 | 4684.6 |
413 | 2025-01-12 13:42:10 | retinol | 1 | 69583 | 3 | 6.170 | 11277.6 |
412 | 2024-12-08 15:43:05 | retinol | 1 | 69583 | 3 | 3.220 | 21609.6 |
411 | 2024-10-31 11:20:04 | retinol | 1 | 69583 | 3 | 3.343 | 20814.5 |
410 | 2024-10-07 20:09:32 | retinol | 1 | 69583 | 3 | 2.736 | 25432.4 |
409 | 2024-10-07 19:51:16 | retinol | 3 | 134027 | 204 | 83.736 | 1600.6 |
408 | 2024-10-06 17:27:27 | retinol | 1 | 69583 | 3 | 7.593 | 9164.1 |
407 | 2024-10-03 01:27:58 | retinol | 3 | 134027 | 204 | 53.643 | 2498.5 |
406 | 2024-10-01 13:37:50 | retinol | 2 | 107671 | 19 | 27.660 | 3892.7 |
405 | 2024-09-30 16:28:26 | retinol | 3 | 134027 | 204 | 73.040 | 1835.0 |
404 | 2024-09-30 16:28:20 | retinol | 2 | 107671 | 19 | 36.580 | 2943.4 |
403 | 2024-09-30 16:26:38 | retinol | 1 | 69583 | 3 | 5.190 | 13407.1 |
402 | 2024-09-17 00:38:01 | retinol | 1 | 69583 | 3 | 4.470 | 15566.7 |
401 | 2024-08-24 22:49:22 | retinol | 1 | 69583 | 3 | 9.096 | 7649.8 |
400 | 2024-08-20 07:35:13 | retinol | 1 | 69583 | 3 | 14.186 | 4905.0 |
399 | 2024-08-20 07:32:55 | retinol | 1 | 69583 | 3 | 12.300 | 5657.2 |
398 | 2024-08-16 18:08:49 | retinol | 1 | 69583 | 3 | 6.970 | 9983.2 |
397 | 2024-08-16 05:56:12 | retinol | 1 | 69583 | 3 | 12.580 | 5531.2 |
396 | 2024-08-12 13:18:51 | retinol | 1 | 69583 | 3 | 8.893 | 7824.5 |
395 | 2024-07-24 00:43:21 | retinol | 1 | 69583 | 3 | 4.546 | 15306.4 |
394 | 2024-07-18 12:31:39 | retinol | 1 | 69583 | 3 | 4.923 | 14134.3 |
393 | 2024-07-16 20:03:23 | retinol | 1 | 69583 | 3 | 3.000 | 23194.3 |
392 | 2024-07-15 05:04:13 | retinol | 1 | 69583 | 3 | 6.750 | 10308.6 |
391 | 2024-07-09 22:05:18 | retinol | 1 | 69583 | 3 | 2.923 | 23805.3 |
390 | 2024-07-06 14:50:59 | retinol | 1 | 69583 | 3 | 3.826 | 18186.9 |
389 | 2024-07-05 21:23:40 | retinol | 1 | 69583 | 3 | 5.593 | 12441.1 |
388 | 2024-06-24 04:09:01 | retinol | 1 | 69583 | 3 | 3.656 | 19032.5 |
387 | 2024-06-08 06:05:09 | retinol | 1 | 69583 | 3 | 6.516 | 10678.8 |
386 | 2024-05-31 15:02:33 | retinol | 3 | 134027 | 204 | 41.593 | 3222.3 |
385 | 2024-05-31 04:47:52 | retinol | 2 | 107671 | 19 | 5.250 | 20508.8 |
384 | 2024-05-31 04:47:40 | retinol | 3 | 134027 | 204 | 7.440 | 18014.4 |
383 | 2024-05-31 03:47:47 | retinol | 2 | 107671 | 19 | 3.533 | 30475.8 |
382 | 2024-05-31 03:47:36 | retinol | 3 | 134027 | 204 | 9.533 | 14059.3 |
381 | 2024-05-31 02:53:50 | retinol | 3 | 134027 | 204 | 8.736 | 15341.9 |
380 | 2024-05-30 03:05:59 | retinol | 1 | 69583 | 3 | 5.126 | 13574.5 |
379 | 2024-05-29 10:22:17 | retinol | 1 | 69583 | 3 | 4.640 | 14996.3 |
378 | 2024-05-08 07:58:44 | retinol | 1 | 69583 | 3 | 1.093 | 63662.4 |
377 | 2024-05-02 09:52:45 | retinol | 1 | 69583 | 3 | 1.343 | 51811.6 |
376 | 2024-04-27 16:40:22 | retinol | 2 | 107671 | 19 | 6.763 | 15920.6 |
375 | 2024-04-25 20:13:06 | retinol | 2 | 107671 | 19 | 3.920 | 27467.1 |
374 | 2024-04-23 03:37:38 | retinol | 1 | 69583 | 3 | 1.266 | 54962.9 |
373 | 2024-04-23 03:37:29 | retinol | 2 | 107671 | 19 | 3.610 | 29825.8 |
372 | 2024-04-20 14:04:55 | retinol | 3 | 134027 | 204 | 25.613 | 5232.8 |
371 | 2024-04-20 14:04:54 | retinol | 2 | 107671 | 19 | 10.160 | 10597.5 |
370 | 2024-04-20 14:04:00 | retinol | 1 | 69583 | 3 | 1.670 | 41666.5 |
369 | 2024-04-18 23:22:13 | retinol | 1 | 69583 | 3 | 1.156 | 60192.9 |
368 | 2024-03-31 22:26:41 | retinol | 3 | 134027 | 204 | 19.190 | 6984.2 |
367 | 2024-03-31 22:20:07 | retinol | 3 | 134027 | 204 | 17.826 | 7518.6 |
366 | 2024-03-25 03:04:10 | retinol | 2 | 107671 | 19 | 2.923 | 36835.8 |
365 | 2024-03-25 03:03:06 | retinol | 3 | 134027 | 204 | 8.236 | 16273.3 |
364 | 2024-03-22 09:57:17 | retinol | 2 | 107671 | 19 | 7.703 | 13977.8 |
363 | 2024-03-22 09:57:00 | retinol | 3 | 134027 | 204 | 7.393 | 18128.9 |
362 | 2024-03-19 17:02:08 | retinol | 3 | 134027 | 204 | 8.970 | 14941.7 |
361 | 2024-03-19 08:25:05 | retinol | 1 | 69583 | 3 | 2.703 | 25742.9 |
360 | 2024-03-19 08:24:56 | retinol | 3 | 134027 | 204 | 8.606 | 15573.7 |
359 | 2024-03-19 08:24:54 | retinol | 2 | 107671 | 19 | 3.843 | 28017.4 |
358 | 2024-03-19 08:24:51 | retinol | 1 | 69583 | 3 | 1.703 | 40859.1 |
357 | 2024-02-28 17:25:53 | retinol | 1 | 69583 | 3 | 1.250 | 55666.4 |
356 | 2024-02-18 06:33:57 | retinol | 1 | 69583 | 3 | 2.716 | 25619.7 |
355 | 2024-01-17 22:59:28 | retinol | 1 | 69583 | 3 | 1.110 | 62687.4 |
354 | 2024-01-17 21:07:10 | retinol | 1 | 69583 | 3 | 1.143 | 60877.5 |
353 | 2024-01-11 01:51:25 | retinol | 3 | 134027 | 204 | 6.906 | 19407.3 |
352 | 2024-01-07 15:57:12 | retinol | 3 | 134027 | 204 | 7.906 | 16952.6 |
351 | 2023-12-31 02:15:49 | retinol | 1 | 69583 | 3 | 1.126 | 61796.6 |
350 | 2023-12-15 06:39:28 | retinol | 2 | 107671 | 19 | 3.953 | 27237.8 |
349 | 2023-12-09 01:11:52 | retinol | 1 | 69583 | 3 | 1.126 | 61796.6 |
348 | 2023-11-19 01:30:37 | retinol | 1 | 69583 | 3 | 1.080 | 64428.7 |
347 | 2023-11-10 09:40:52 | retinol | 1 | 69583 | 3 | 1.076 | 64668.2 |
346 | 2023-10-31 00:45:26 | retinol | 3 | 134027 | 204 | 7.423 | 18055.6 |
345 | 2023-10-19 18:40:14 | retinol | 3 | 134027 | 204 | 6.076 | 22058.4 |
344 | 2023-09-25 16:34:14 | retinol | 1 | 69583 | 3 | 1.090 | 63837.6 |
343 | 2023-09-15 05:11:40 | retinol | 2 | 107671 | 19 | 2.986 | 36058.6 |
342 | 2023-09-14 19:30:37 | retinol | 1 | 69583 | 3 | 1.140 | 61037.7 |
341 | 2023-09-02 21:54:47 | retinol | 1 | 69583 | 3 | 1.110 | 62687.4 |
340 | 2023-08-29 05:57:23 | retinol | 3 | 134027 | 204 | 6.376 | 21020.5 |
339 | 2023-08-18 18:30:40 | retinol | 1 | 69583 | 3 | 1.080 | 64428.7 |
338 | 2023-07-31 01:18:39 | retinol | 3 | 134027 | 204 | 6.033 | 22215.6 |