History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tansy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
400 | 2024-03-06 23:37:05 | tansy | 2 | 53800 | 120 | 2.013 | 26726.3 |
399 | 2024-03-06 19:28:33 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
398 | 2024-03-05 21:03:45 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
397 | 2024-03-01 13:46:21 | tansy | 1 | 28756 | 4 | 0.563 | 51076.4 |
396 | 2024-03-01 12:54:17 | tansy | 1 | 28756 | 4 | 0.533 | 53951.2 |
395 | 2024-03-01 10:43:22 | tansy | 1 | 28756 | 4 | 1.546 | 18600.3 |
394 | 2024-02-27 19:48:02 | tansy | 1 | 28756 | 4 | 0.516 | 55728.7 |
393 | 2024-02-03 18:19:03 | tansy | 1 | 28756 | 4 | 0.893 | 32201.6 |
392 | 2024-01-29 09:32:03 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
391 | 2024-01-28 18:33:33 | tansy | 1 | 28756 | 4 | 0.516 | 55728.7 |
390 | 2024-01-17 19:50:18 | tansy | 2 | 53800 | 120 | 1.626 | 33087.3 |
389 | 2024-01-14 00:21:22 | tansy | 1 | 28756 | 4 | 0.436 | 65954.1 |
388 | 2023-12-30 02:40:23 | tansy | 2 | 53800 | 120 | 1.470 | 36598.6 |
387 | 2023-12-28 09:26:25 | tansy | 2 | 53800 | 120 | 1.750 | 30742.9 |
386 | 2023-12-10 08:23:35 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
385 | 2023-11-19 18:25:45 | tansy | 1 | 28756 | 4 | 0.576 | 49923.6 |
384 | 2023-11-17 20:19:32 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
383 | 2023-11-13 00:15:59 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
382 | 2023-10-30 14:56:17 | tansy | 1 | 28756 | 4 | 0.546 | 52666.7 |
381 | 2023-10-22 08:44:24 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
380 | 2023-10-20 11:38:52 | tansy | 1 | 28756 | 4 | 0.436 | 65954.1 |
379 | 2023-10-16 12:09:32 | tansy | 1 | 28756 | 4 | 0.456 | 63061.4 |
378 | 2023-10-03 16:10:41 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
377 | 2023-09-26 02:10:03 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
376 | 2023-09-25 07:35:34 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
375 | 2023-09-22 15:16:40 | tansy | 1 | 28756 | 4 | 0.470 | 61183.0 |
374 | 2023-07-23 08:24:15 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
373 | 2023-06-11 05:54:43 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
372 | 2023-04-23 22:31:31 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
371 | 2023-02-12 23:26:00 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
370 | 2023-02-12 08:42:28 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
369 | 2022-12-10 13:05:30 | tansy | 1 | 28756 | 4 | 0.436 | 65954.1 |
368 | 2022-09-27 13:50:22 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
367 | 2022-09-23 22:56:54 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
366 | 2022-08-14 08:06:07 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
365 | 2022-04-30 06:48:25 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
364 | 2022-04-07 13:05:35 | tansy | 1 | 28756 | 4 | 0.440 | 65354.5 |
363 | 2022-03-13 00:38:01 | tansy | 1 | 28756 | 4 | 0.563 | 51076.4 |
362 | 2022-01-04 21:26:44 | tansy | 1 | 28756 | 4 | 0.466 | 61708.2 |
361 | 2022-01-03 12:34:08 | tansy | 1 | 28756 | 4 | 0.466 | 61708.2 |
360 | 2021-12-14 09:30:19 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
359 | 2021-11-11 16:08:25 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
358 | 2021-11-03 03:45:25 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
357 | 2021-09-20 12:37:19 | tansy | 1 | 28756 | 4 | 1.030 | 27918.4 |
356 | 2021-09-14 14:14:29 | tansy | 1 | 28756 | 4 | 0.450 | 63902.2 |
355 | 2021-09-03 02:27:38 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
354 | 2021-06-11 02:33:35 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
353 | 2021-06-10 12:19:22 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
352 | 2021-03-20 09:27:48 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
351 | 2021-03-08 01:14:31 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
350 | 2021-02-12 04:00:32 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
349 | 2021-01-01 20:23:10 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
348 | 2020-12-05 09:25:43 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
347 | 2020-12-04 10:24:17 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
346 | 2020-11-04 00:58:46 | tansy | 1 | 28756 | 4 | 0.513 | 56054.6 |
345 | 2020-10-25 01:24:53 | tansy | 1 | 28756 | 4 | 0.516 | 55728.7 |
344 | 2020-10-14 19:36:13 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
343 | 2020-10-13 00:21:59 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
342 | 2020-09-02 05:47:02 | tansy | 1 | 28756 | 4 | 0.923 | 31154.9 |
341 | 2020-08-29 16:07:09 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
340 | 2020-08-23 09:00:26 | tansy | 1 | 28756 | 4 | 0.516 | 55728.7 |
339 | 2020-07-21 16:00:02 | tansy | 1 | 28756 | 4 | 0.516 | 55728.7 |
338 | 2020-05-23 21:22:13 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
337 | 2020-05-15 16:41:23 | tansy | 1 | 28756 | 4 | 0.466 | 61708.2 |
336 | 2020-05-12 17:29:07 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
335 | 2020-03-25 06:15:32 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
334 | 2020-03-24 23:42:52 | tansy | 1 | 28756 | 4 | 0.513 | 56054.6 |
333 | 2020-03-23 14:57:16 | tansy | 1 | 28756 | 4 | 0.550 | 52283.6 |
332 | 2020-03-22 06:36:08 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
331 | 2020-03-21 21:05:37 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
330 | 2020-03-21 04:26:58 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
329 | 2020-03-18 00:33:34 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
328 | 2020-02-29 07:39:59 | tansy | 1 | 28756 | 4 | 0.606 | 47452.1 |
327 | 2020-02-24 21:16:11 | tansy | 1 | 28756 | 4 | 0.533 | 53951.2 |
326 | 2020-02-19 13:31:46 | tansy | 1 | 28756 | 4 | 0.580 | 49579.3 |
325 | 2020-02-17 18:03:30 | tansy | 1 | 28756 | 4 | 1.030 | 27918.4 |
324 | 2020-02-14 10:05:46 | tansy | 1 | 28756 | 4 | 0.580 | 49579.3 |
323 | 2020-02-10 06:34:05 | tansy | 1 | 28756 | 4 | 1.706 | 16855.8 |
322 | 2020-02-08 09:19:55 | tansy | 1 | 28756 | 4 | 0.593 | 48492.4 |
321 | 2020-02-07 03:22:39 | tansy | 1 | 28756 | 4 | 0.470 | 61183.0 |
320 | 2020-01-31 17:27:40 | tansy | 1 | 28756 | 4 | 0.546 | 52666.7 |
319 | 2020-01-29 23:26:56 | tansy | 1 | 28756 | 4 | 0.546 | 52666.7 |
318 | 2020-01-29 04:21:26 | tansy | 1 | 28756 | 4 | 1.736 | 16564.5 |
317 | 2020-01-22 19:57:51 | tansy | 1 | 28756 | 4 | 1.186 | 24246.2 |
316 | 2020-01-22 06:10:01 | tansy | 1 | 28756 | 4 | 1.703 | 16885.5 |
315 | 2020-01-20 22:23:41 | tansy | 1 | 28756 | 4 | 1.766 | 16283.1 |
314 | 2020-01-12 20:26:19 | tansy | 1 | 28756 | 4 | 0.470 | 61183.0 |
313 | 2020-01-11 01:50:31 | tansy | 1 | 28756 | 4 | 1.093 | 26309.2 |
312 | 2020-01-09 19:24:20 | tansy | 1 | 28756 | 4 | 1.110 | 25906.3 |
311 | 2020-01-06 22:06:58 | tansy | 1 | 28756 | 4 | 1.736 | 16564.5 |
310 | 2020-01-03 05:45:06 | tansy | 1 | 28756 | 4 | 1.783 | 16127.9 |
309 | 2019-12-24 16:27:21 | tansy | 1 | 28756 | 4 | 0.483 | 59536.2 |
308 | 2019-12-23 22:50:21 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
307 | 2019-12-23 16:31:52 | tansy | 1 | 28756 | 4 | 0.466 | 61708.2 |
306 | 2019-12-23 13:00:56 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
305 | 2019-12-18 15:38:47 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |
304 | 2019-11-06 14:27:59 | tansy | 1 | 28756 | 4 | 0.513 | 56054.6 |
303 | 2019-08-05 09:41:51 | tansy | 1 | 28756 | 4 | 0.460 | 62513.0 |
302 | 2019-07-29 19:58:13 | tansy | 1 | 28756 | 4 | 0.500 | 57512.0 |
301 | 2019-04-26 00:00:53 | tansy | 1 | 28756 | 4 | 0.453 | 63479.0 |