History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"strands"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
418 | 2024-04-30 02:32:33 | strands | 2 | 107671 | 41 | 11.296 | 9531.8 |
417 | 2024-04-29 08:07:45 | strands | 2 | 107671 | 41 | 3.263 | 32997.5 |
416 | 2024-04-29 08:06:57 | strands | 3 | 134027 | 448 | 7.046 | 19021.7 |
415 | 2024-04-28 21:40:47 | strands | 1 | 69583 | 3 | 1.280 | 54361.7 |
414 | 2024-04-25 14:30:50 | strands | 2 | 107671 | 41 | 3.203 | 33615.7 |
413 | 2024-04-25 14:30:24 | strands | 3 | 134027 | 448 | 7.593 | 17651.4 |
412 | 2024-04-24 18:36:14 | strands | 3 | 134027 | 448 | 13.766 | 9736.1 |
411 | 2024-04-23 16:47:02 | strands | 3 | 134027 | 448 | 14.846 | 9027.8 |
410 | 2024-04-23 03:55:44 | strands | 3 | 134027 | 448 | 14.626 | 9163.6 |
409 | 2024-04-22 11:05:19 | strands | 3 | 134027 | 448 | 26.723 | 5015.4 |
408 | 2024-04-21 11:47:21 | strands | 3 | 134027 | 448 | 19.250 | 6962.4 |
407 | 2024-04-21 11:45:41 | strands | 3 | 134027 | 448 | 14.906 | 8991.5 |
406 | 2024-02-27 15:23:38 | strands | 1 | 69583 | 3 | 1.343 | 51811.6 |
405 | 2024-01-27 00:30:13 | strands | 1 | 69583 | 3 | 1.310 | 53116.8 |
404 | 2024-01-19 04:25:09 | strands | 1 | 69583 | 3 | 1.153 | 60349.5 |
403 | 2024-01-11 18:36:00 | strands | 2 | 107671 | 41 | 3.280 | 32826.5 |
402 | 2024-01-10 08:47:55 | strands | 1 | 69583 | 3 | 1.190 | 58473.1 |
401 | 2023-12-15 02:52:06 | strands | 3 | 134027 | 448 | 5.796 | 23124.1 |
400 | 2023-12-08 20:17:44 | strands | 1 | 69583 | 3 | 1.080 | 64428.7 |
399 | 2023-11-27 16:14:38 | strands | 1 | 69583 | 3 | 1.080 | 64428.7 |
398 | 2023-11-26 17:48:30 | strands | 2 | 107671 | 41 | 3.343 | 32207.9 |
397 | 2023-11-25 19:36:11 | strands | 3 | 134027 | 448 | 6.953 | 19276.1 |
396 | 2023-11-20 16:12:03 | strands | 1 | 69583 | 3 | 2.170 | 32065.9 |
395 | 2023-11-19 09:20:17 | strands | 1 | 69583 | 3 | 1.126 | 61796.6 |
394 | 2023-10-31 07:56:06 | strands | 1 | 69583 | 3 | 1.186 | 58670.3 |
393 | 2023-10-27 08:59:36 | strands | 3 | 134027 | 448 | 6.360 | 21073.4 |
392 | 2023-10-27 08:59:38 | strands | 2 | 107671 | 41 | 3.326 | 32372.5 |
391 | 2023-10-22 12:40:23 | strands | 2 | 107671 | 41 | 3.296 | 32667.2 |
390 | 2023-10-21 01:27:49 | strands | 1 | 69583 | 3 | 1.093 | 63662.4 |
389 | 2023-10-11 07:50:00 | strands | 1 | 69583 | 3 | 1.186 | 58670.3 |
388 | 2023-10-03 16:17:50 | strands | 1 | 69583 | 3 | 1.203 | 57841.2 |
387 | 2023-09-25 08:49:26 | strands | 1 | 69583 | 3 | 1.203 | 57841.2 |
386 | 2023-09-24 06:21:49 | strands | 1 | 69583 | 3 | 1.093 | 63662.4 |
385 | 2023-09-15 04:34:49 | strands | 3 | 134027 | 448 | 6.156 | 21771.8 |
384 | 2023-07-31 19:03:33 | strands | 2 | 107671 | 41 | 3.250 | 33129.5 |
383 | 2023-06-14 16:27:44 | strands | 3 | 134027 | 448 | 6.313 | 21230.3 |
382 | 2023-06-01 17:30:43 | strands | 1 | 69583 | 3 | 1.076 | 64668.2 |
381 | 2023-04-11 04:08:05 | strands | 2 | 107671 | 41 | 3.030 | 35535.0 |
380 | 2023-03-15 06:42:07 | strands | 3 | 134027 | 448 | 5.766 | 23244.4 |
379 | 2023-02-09 22:43:45 | strands | 1 | 69583 | 3 | 1.063 | 65459.1 |
378 | 2023-01-17 14:54:37 | strands | 2 | 107671 | 41 | 2.830 | 38046.3 |
377 | 2022-12-27 09:23:00 | strands | 3 | 134027 | 448 | 6.330 | 21173.3 |
376 | 2022-12-22 14:14:56 | strands | 3 | 134027 | 448 | 6.343 | 21129.9 |
375 | 2022-12-17 16:38:19 | strands | 3 | 134027 | 448 | 5.733 | 23378.2 |
374 | 2022-11-25 04:27:06 | strands | 3 | 134027 | 448 | 5.843 | 22938.0 |
373 | 2022-11-11 16:35:47 | strands | 3 | 134027 | 448 | 6.750 | 19855.9 |
372 | 2022-11-09 18:50:46 | strands | 3 | 134027 | 448 | 6.016 | 22278.4 |
371 | 2022-10-29 03:09:01 | strands | 2 | 107671 | 41 | 2.813 | 38276.2 |
370 | 2022-10-16 04:32:32 | strands | 1 | 69583 | 3 | 1.080 | 64428.7 |
369 | 2022-10-14 09:28:09 | strands | 3 | 134027 | 448 | 5.876 | 22809.2 |
368 | 2022-09-17 09:07:22 | strands | 3 | 134027 | 448 | 6.690 | 20033.9 |
367 | 2022-08-12 18:36:20 | strands | 1 | 69583 | 3 | 1.076 | 64668.2 |
366 | 2022-08-10 02:08:03 | strands | 3 | 134027 | 448 | 5.953 | 22514.2 |
365 | 2022-06-14 14:03:23 | strands | 1 | 69583 | 3 | 1.173 | 59320.5 |
364 | 2022-06-10 23:04:56 | strands | 1 | 69583 | 3 | 1.096 | 63488.1 |
363 | 2022-05-31 01:33:16 | strands | 2 | 107671 | 41 | 2.813 | 38276.2 |
362 | 2022-04-29 00:27:47 | strands | 3 | 134027 | 448 | 7.936 | 16888.5 |
361 | 2022-04-24 15:29:40 | strands | 3 | 134027 | 448 | 7.126 | 18808.2 |
360 | 2022-04-01 19:50:16 | strands | 1 | 69583 | 3 | 1.093 | 63662.4 |
359 | 2022-03-08 20:50:40 | strands | 3 | 134027 | 448 | 6.750 | 19855.9 |
358 | 2022-02-13 15:51:20 | strands | 1 | 69583 | 3 | 1.280 | 54361.7 |
357 | 2022-01-05 14:57:33 | strands | 1 | 69583 | 3 | 1.266 | 54962.9 |
356 | 2021-12-18 03:53:47 | strands | 1 | 69583 | 3 | 1.220 | 57035.2 |
355 | 2021-11-21 20:59:05 | strands | 1 | 69583 | 3 | 1.186 | 58670.3 |
354 | 2021-11-05 21:45:17 | strands | 1 | 69583 | 3 | 1.250 | 55666.4 |
353 | 2021-10-23 13:40:06 | strands | 1 | 69583 | 3 | 1.203 | 57841.2 |
352 | 2021-09-19 05:37:30 | strands | 1 | 69583 | 3 | 1.186 | 58670.3 |
351 | 2021-08-17 08:11:40 | strands | 1 | 69583 | 3 | 1.203 | 57841.2 |
350 | 2021-08-15 03:27:00 | strands | 1 | 69583 | 3 | 1.190 | 58473.1 |
349 | 2021-07-16 04:52:51 | strands | 1 | 69583 | 3 | 1.093 | 63662.4 |
348 | 2021-05-25 15:55:51 | strands | 1 | 69583 | 3 | 1.220 | 57035.2 |
347 | 2021-04-29 09:27:59 | strands | 1 | 69583 | 3 | 1.283 | 54234.6 |
346 | 2021-04-13 10:03:14 | strands | 1 | 69583 | 3 | 1.266 | 54962.9 |
345 | 2021-03-28 23:49:30 | strands | 1 | 69583 | 3 | 1.076 | 64668.2 |
344 | 2021-01-12 18:00:03 | strands | 1 | 69583 | 3 | 1.080 | 64428.7 |
343 | 2021-01-03 15:25:35 | strands | 1 | 69583 | 3 | 1.080 | 64428.7 |
342 | 2020-10-31 02:41:59 | strands | 1 | 69583 | 3 | 1.216 | 57222.9 |
341 | 2020-10-27 07:14:23 | strands | 1 | 69583 | 3 | 2.403 | 28956.7 |
340 | 2020-10-24 23:56:18 | strands | 1 | 69583 | 3 | 1.110 | 62687.4 |
339 | 2020-10-22 16:27:31 | strands | 1 | 69583 | 3 | 1.216 | 57222.9 |
338 | 2020-10-17 19:07:33 | strands | 1 | 69583 | 3 | 1.093 | 63662.4 |
337 | 2020-10-01 20:18:52 | strands | 1 | 69583 | 3 | 1.203 | 57841.2 |
336 | 2020-08-27 08:30:09 | strands | 1 | 69583 | 3 | 1.096 | 63488.1 |
335 | 2020-06-18 12:18:29 | strands | 1 | 69583 | 3 | 1.140 | 61037.7 |
334 | 2020-06-08 04:16:00 | strands | 1 | 69583 | 3 | 1.140 | 61037.7 |
333 | 2020-03-29 01:22:02 | strands | 1 | 69583 | 3 | 1.343 | 51811.6 |
332 | 2020-03-24 14:16:08 | strands | 1 | 69583 | 3 | 1.220 | 57035.2 |
331 | 2020-03-23 13:41:37 | strands | 1 | 69583 | 3 | 1.330 | 52318.0 |
330 | 2020-03-20 20:59:00 | strands | 1 | 69583 | 3 | 1.453 | 47889.2 |
329 | 2020-03-04 23:50:37 | strands | 1 | 69583 | 3 | 1.076 | 64668.2 |
328 | 2020-02-26 08:53:07 | strands | 1 | 69583 | 3 | 2.656 | 26198.4 |
327 | 2020-02-19 11:30:02 | strands | 1 | 69583 | 3 | 1.406 | 49490.0 |
326 | 2020-02-15 06:02:36 | strands | 1 | 69583 | 3 | 2.673 | 26031.8 |
325 | 2020-02-05 13:12:23 | strands | 1 | 69583 | 3 | 1.436 | 48456.1 |
324 | 2020-02-03 23:27:19 | strands | 1 | 69583 | 3 | 1.310 | 53116.8 |
323 | 2020-02-03 14:58:06 | strands | 1 | 69583 | 3 | 1.830 | 38023.5 |
322 | 2020-01-31 13:25:31 | strands | 1 | 69583 | 3 | 1.703 | 40859.1 |
321 | 2020-01-26 22:13:45 | strands | 1 | 69583 | 3 | 1.330 | 52318.0 |
320 | 2020-01-24 00:49:07 | strands | 1 | 69583 | 3 | 4.250 | 16372.5 |
319 | 2020-01-15 06:23:10 | strands | 1 | 69583 | 3 | 1.453 | 47889.2 |