History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"widgets"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
414 | 2024-03-30 16:18:16 | widgets | 2 | 107671 | 32 | 11.203 | 9610.9 |
413 | 2024-03-30 02:00:36 | widgets | 1 | 69583 | 5 | 3.610 | 19275.1 |
412 | 2024-03-29 03:36:28 | widgets | 2 | 107671 | 32 | 7.750 | 13893.0 |
411 | 2024-03-28 21:12:27 | widgets | 1 | 69583 | 5 | 3.923 | 17737.2 |
410 | 2024-02-27 14:31:17 | widgets | 1 | 69583 | 5 | 1.203 | 57841.2 |
409 | 2024-01-15 06:45:22 | widgets | 3 | 134027 | 352 | 6.220 | 21547.7 |
408 | 2024-01-15 06:45:21 | widgets | 2 | 107671 | 32 | 3.063 | 35152.1 |
407 | 2024-01-07 09:38:25 | widgets | 1 | 69583 | 5 | 1.233 | 56433.9 |
406 | 2023-12-04 23:04:39 | widgets | 1 | 69583 | 5 | 1.173 | 59320.5 |
405 | 2023-12-04 11:30:02 | widgets | 2 | 107671 | 32 | 3.093 | 34811.2 |
404 | 2023-11-25 21:29:19 | widgets | 1 | 69583 | 5 | 1.156 | 60192.9 |
403 | 2023-11-17 12:55:23 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
402 | 2023-11-05 16:44:12 | widgets | 1 | 69583 | 5 | 1.170 | 59472.6 |
401 | 2023-10-30 19:41:50 | widgets | 1 | 69583 | 5 | 1.233 | 56433.9 |
400 | 2023-10-25 10:33:18 | widgets | 1 | 69583 | 5 | 1.296 | 53690.6 |
399 | 2023-10-24 02:40:29 | widgets | 1 | 69583 | 5 | 1.156 | 60192.9 |
398 | 2023-10-21 18:27:59 | widgets | 1 | 69583 | 5 | 1.173 | 59320.5 |
397 | 2023-10-17 20:40:48 | widgets | 1 | 69583 | 5 | 1.030 | 67556.3 |
396 | 2023-09-27 10:00:51 | widgets | 1 | 69583 | 5 | 1.060 | 65644.3 |
395 | 2023-09-02 13:25:55 | widgets | 2 | 107671 | 32 | 2.640 | 40784.5 |
394 | 2023-08-24 06:56:29 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
393 | 2023-06-14 00:23:56 | widgets | 1 | 69583 | 5 | 1.030 | 67556.3 |
392 | 2023-05-23 19:58:53 | widgets | 1 | 69583 | 5 | 1.030 | 67556.3 |
391 | 2023-05-18 08:35:13 | widgets | 2 | 107671 | 32 | 2.686 | 40086.0 |
390 | 2023-03-28 15:47:07 | widgets | 2 | 107671 | 32 | 3.013 | 35735.5 |
389 | 2023-03-18 17:49:31 | widgets | 1 | 69583 | 5 | 1.016 | 68487.2 |
388 | 2023-02-24 02:08:48 | widgets | 2 | 107671 | 32 | 2.656 | 40538.8 |
387 | 2023-02-12 09:52:22 | widgets | 1 | 69583 | 5 | 1.140 | 61037.7 |
386 | 2023-02-08 21:59:52 | widgets | 1 | 69583 | 5 | 1.016 | 68487.2 |
385 | 2023-01-07 18:31:31 | widgets | 1 | 69583 | 5 | 1.203 | 57841.2 |
384 | 2022-12-03 21:12:57 | widgets | 2 | 107671 | 32 | 2.656 | 40538.8 |
383 | 2022-10-07 17:53:08 | widgets | 1 | 69583 | 5 | 1.030 | 67556.3 |
382 | 2022-10-04 05:20:22 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
381 | 2022-09-29 17:01:13 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
380 | 2022-08-01 04:41:37 | widgets | 3 | 134027 | 352 | 5.516 | 24297.9 |
379 | 2022-07-28 17:48:12 | widgets | 3 | 134027 | 352 | 5.593 | 23963.3 |
378 | 2022-07-19 13:58:37 | widgets | 3 | 134027 | 352 | 5.923 | 22628.2 |
377 | 2022-05-13 14:46:20 | widgets | 1 | 69583 | 5 | 1.640 | 42428.7 |
376 | 2022-04-14 19:53:29 | widgets | 2 | 107671 | 32 | 3.140 | 34290.1 |
375 | 2022-02-16 06:15:45 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
374 | 2022-02-09 04:22:53 | widgets | 1 | 69583 | 5 | 1.076 | 64668.2 |
373 | 2022-02-03 18:15:34 | widgets | 1 | 69583 | 5 | 1.140 | 61037.7 |
372 | 2022-02-01 13:59:26 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
371 | 2021-11-27 17:18:40 | widgets | 1 | 69583 | 5 | 1.186 | 58670.3 |
370 | 2021-11-06 10:40:27 | widgets | 3 | 134027 | 352 | 6.453 | 20769.7 |
369 | 2021-10-12 21:08:02 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
368 | 2021-10-09 06:17:25 | widgets | 1 | 69583 | 5 | 1.063 | 65459.1 |
367 | 2021-09-18 01:41:09 | widgets | 1 | 69583 | 5 | 1.173 | 59320.5 |
366 | 2021-07-07 17:33:14 | widgets | 1 | 69583 | 5 | 1.233 | 56433.9 |
365 | 2021-05-06 00:35:34 | widgets | 3 | 134027 | 352 | 6.783 | 19759.3 |
364 | 2021-05-02 12:23:49 | widgets | 1 | 69583 | 5 | 1.186 | 58670.3 |
363 | 2021-04-25 11:18:26 | widgets | 3 | 134027 | 352 | 5.766 | 23244.4 |
362 | 2021-04-07 22:36:27 | widgets | 1 | 69583 | 5 | 2.393 | 29077.7 |
361 | 2021-04-03 18:46:28 | widgets | 1 | 69583 | 5 | 1.156 | 60192.9 |
360 | 2021-02-17 08:51:03 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
359 | 2021-01-19 12:15:33 | widgets | 3 | 134027 | 352 | 5.580 | 24019.2 |
358 | 2020-12-29 18:36:08 | widgets | 1 | 69583 | 5 | 1.050 | 66269.5 |
357 | 2020-11-07 05:21:05 | widgets | 3 | 134027 | 352 | 6.123 | 21889.1 |
356 | 2020-10-30 18:54:08 | widgets | 3 | 134027 | 352 | 6.783 | 19759.3 |
355 | 2020-10-27 15:32:52 | widgets | 1 | 69583 | 5 | 1.063 | 65459.1 |
354 | 2020-10-18 08:58:47 | widgets | 1 | 69583 | 5 | 1.063 | 65459.1 |
353 | 2020-09-26 10:54:41 | widgets | 1 | 69583 | 5 | 1.030 | 67556.3 |
352 | 2020-08-11 13:37:26 | widgets | 1 | 69583 | 5 | 1.440 | 48321.5 |
351 | 2020-06-11 15:18:20 | widgets | 1 | 69583 | 5 | 1.170 | 59472.6 |
350 | 2020-04-08 10:32:05 | widgets | 1 | 69583 | 5 | 1.186 | 58670.3 |
349 | 2020-03-29 03:01:10 | widgets | 1 | 69583 | 5 | 2.330 | 29863.9 |
348 | 2020-03-25 10:22:29 | widgets | 1 | 69583 | 5 | 2.326 | 29915.3 |
347 | 2020-03-24 16:44:24 | widgets | 1 | 69583 | 5 | 1.186 | 58670.3 |
346 | 2020-03-20 16:34:34 | widgets | 1 | 69583 | 5 | 1.046 | 66522.9 |
345 | 2020-02-27 08:23:04 | widgets | 1 | 69583 | 5 | 1.190 | 58473.1 |
344 | 2020-02-23 09:31:05 | widgets | 3 | 134027 | 352 | 10.860 | 12341.3 |
343 | 2020-02-23 07:46:38 | widgets | 3 | 134027 | 352 | 13.500 | 9927.9 |
342 | 2020-02-22 23:07:29 | widgets | 1 | 69583 | 5 | 3.343 | 20814.5 |
341 | 2020-02-22 16:05:46 | widgets | 3 | 134027 | 352 | 13.126 | 10210.8 |
340 | 2020-02-20 13:25:06 | widgets | 1 | 69583 | 5 | 1.296 | 53690.6 |
339 | 2020-02-17 19:33:12 | widgets | 3 | 134027 | 352 | 9.656 | 13880.2 |
338 | 2020-02-17 05:55:54 | widgets | 3 | 134027 | 352 | 14.893 | 8999.3 |
337 | 2020-02-14 05:55:41 | widgets | 1 | 69583 | 5 | 3.966 | 17544.9 |
336 | 2020-02-12 19:24:33 | widgets | 1 | 69583 | 5 | 2.440 | 28517.6 |
335 | 2020-02-07 17:41:13 | widgets | 1 | 69583 | 5 | 1.250 | 55666.4 |
334 | 2020-02-05 23:32:15 | widgets | 1 | 69583 | 5 | 2.390 | 29114.2 |
333 | 2020-02-01 04:39:36 | widgets | 3 | 134027 | 352 | 21.143 | 6339.1 |
332 | 2020-01-31 16:42:00 | widgets | 3 | 134027 | 352 | 7.860 | 17051.8 |
331 | 2020-01-27 08:28:22 | widgets | 2 | 107671 | 32 | 6.126 | 17576.1 |
330 | 2020-01-25 07:05:26 | widgets | 1 | 69583 | 5 | 1.283 | 54234.6 |
329 | 2020-01-24 13:14:24 | widgets | 1 | 69583 | 5 | 1.156 | 60192.9 |
328 | 2020-01-22 23:46:14 | widgets | 3 | 134027 | 352 | 7.046 | 19021.7 |
327 | 2020-01-22 19:33:22 | widgets | 3 | 134027 | 352 | 7.143 | 18763.4 |
326 | 2020-01-22 11:45:23 | widgets | 3 | 134027 | 352 | 6.203 | 21606.8 |
325 | 2020-01-21 04:21:18 | widgets | 1 | 69583 | 5 | 1.326 | 52475.9 |
324 | 2020-01-19 18:29:18 | widgets | 1 | 69583 | 5 | 1.733 | 40151.8 |
323 | 2020-01-18 01:41:57 | widgets | 1 | 69583 | 5 | 2.563 | 27149.0 |
322 | 2020-01-15 18:13:56 | widgets | 3 | 134027 | 352 | 15.656 | 8560.7 |
321 | 2020-01-14 11:52:26 | widgets | 1 | 69583 | 5 | 1.156 | 60192.9 |
320 | 2020-01-07 23:04:37 | widgets | 1 | 69583 | 5 | 1.263 | 55093.4 |
319 | 2019-12-31 07:05:47 | widgets | 3 | 134027 | 352 | 6.906 | 19407.3 |
318 | 2019-12-31 01:39:14 | widgets | 3 | 134027 | 352 | 15.280 | 8771.4 |
317 | 2019-12-28 23:30:02 | widgets | 3 | 134027 | 352 | 6.813 | 19672.2 |
316 | 2019-12-28 21:45:38 | widgets | 3 | 134027 | 352 | 6.250 | 21444.3 |
315 | 2019-12-28 21:45:23 | widgets | 2 | 107671 | 32 | 3.110 | 34620.9 |