History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"candies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
428 | 2024-04-27 01:21:24 | candies | 1 | 69583 | 9 | 2.826 | 24622.4 |
427 | 2024-04-09 00:04:39 | candies | 1 | 69583 | 9 | 3.766 | 18476.6 |
426 | 2024-04-03 10:01:18 | candies | 1 | 69583 | 9 | 2.640 | 26357.2 |
425 | 2024-04-01 18:49:12 | candies | 2 | 107671 | 103 | 9.486 | 11350.5 |
424 | 2024-04-01 18:43:04 | candies | 1 | 69583 | 9 | 1.813 | 38380.0 |
423 | 2024-03-08 23:48:10 | candies | 1 | 69583 | 9 | 2.830 | 24587.6 |
422 | 2024-02-27 00:44:12 | candies | 2 | 107671 | 103 | 2.983 | 36094.9 |
421 | 2024-02-27 00:44:08 | candies | 1 | 69583 | 9 | 1.296 | 53690.6 |
420 | 2024-02-06 02:28:14 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
419 | 2024-01-12 11:49:10 | candies | 2 | 107671 | 103 | 3.376 | 31893.1 |
418 | 2024-01-06 22:42:12 | candies | 1 | 69583 | 9 | 1.143 | 60877.5 |
417 | 2023-12-22 09:56:20 | candies | 2 | 107671 | 103 | 3.390 | 31761.4 |
416 | 2023-12-22 04:53:50 | candies | 1 | 69583 | 9 | 1.143 | 60877.5 |
415 | 2023-12-10 20:45:02 | candies | 1 | 69583 | 9 | 1.233 | 56433.9 |
414 | 2023-11-26 03:51:01 | candies | 1 | 69583 | 9 | 1.220 | 57035.2 |
413 | 2023-11-17 06:27:45 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
412 | 2023-10-29 18:01:47 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
411 | 2023-10-28 03:20:55 | candies | 1 | 69583 | 9 | 1.233 | 56433.9 |
410 | 2023-10-25 11:17:37 | candies | 1 | 69583 | 9 | 1.156 | 60192.9 |
409 | 2023-10-11 11:13:09 | candies | 1 | 69583 | 9 | 1.296 | 53690.6 |
408 | 2023-10-09 16:19:38 | candies | 1 | 69583 | 9 | 1.186 | 58670.3 |
407 | 2023-09-26 02:23:27 | candies | 1 | 69583 | 9 | 1.263 | 55093.4 |
406 | 2023-09-24 14:54:38 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
405 | 2023-09-18 04:57:10 | candies | 1 | 69583 | 9 | 1.140 | 61037.7 |
404 | 2023-09-03 22:41:43 | candies | 1 | 69583 | 9 | 1.216 | 57222.9 |
403 | 2023-08-31 17:47:14 | candies | 1 | 69583 | 9 | 1.236 | 56296.9 |
402 | 2023-08-13 17:26:14 | candies | 1 | 69583 | 9 | 1.296 | 53690.6 |
401 | 2023-08-05 18:08:18 | candies | 1 | 69583 | 9 | 1.280 | 54361.7 |
400 | 2023-05-31 12:08:45 | candies | 1 | 69583 | 9 | 2.173 | 32021.6 |
399 | 2023-05-28 06:09:52 | candies | 1 | 69583 | 9 | 1.233 | 56433.9 |
398 | 2023-05-03 02:30:39 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
397 | 2023-02-27 03:47:05 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
396 | 2023-02-22 07:33:05 | candies | 1 | 69583 | 9 | 2.423 | 28717.7 |
395 | 2022-12-25 06:46:53 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
394 | 2022-11-19 13:35:52 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
393 | 2022-09-14 12:19:40 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
392 | 2022-09-12 23:33:08 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
391 | 2022-09-01 19:02:56 | candies | 1 | 69583 | 9 | 1.236 | 56296.9 |
390 | 2022-08-19 02:34:42 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
389 | 2022-08-15 19:37:56 | candies | 1 | 69583 | 9 | 1.110 | 62687.4 |
388 | 2022-08-14 21:01:45 | candies | 1 | 69583 | 9 | 1.123 | 61961.7 |
387 | 2022-08-06 14:18:23 | candies | 1 | 69583 | 9 | 1.123 | 61961.7 |
386 | 2022-07-17 13:06:56 | candies | 1 | 69583 | 9 | 1.106 | 62914.1 |
385 | 2022-05-10 05:08:42 | candies | 1 | 69583 | 9 | 1.126 | 61796.6 |
384 | 2022-03-21 11:38:10 | candies | 1 | 69583 | 9 | 1.343 | 51811.6 |
383 | 2022-03-19 09:05:44 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
382 | 2022-02-05 06:19:28 | candies | 1 | 69583 | 9 | 1.080 | 64428.7 |
381 | 2021-12-23 05:12:17 | candies | 1 | 69583 | 9 | 1.140 | 61037.7 |
380 | 2021-12-21 02:35:31 | candies | 1 | 69583 | 9 | 1.233 | 56433.9 |
379 | 2021-11-04 12:29:37 | candies | 1 | 69583 | 9 | 1.093 | 63662.4 |
378 | 2021-10-26 02:11:39 | candies | 1 | 69583 | 9 | 2.186 | 31831.2 |
377 | 2021-09-14 04:46:27 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
376 | 2021-08-27 14:25:12 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
375 | 2021-08-12 04:22:58 | candies | 1 | 69583 | 9 | 1.203 | 57841.2 |
374 | 2021-08-01 07:28:43 | candies | 1 | 69583 | 9 | 1.096 | 63488.1 |
373 | 2021-07-02 23:01:25 | candies | 1 | 69583 | 9 | 1.376 | 50569.0 |
372 | 2021-04-26 21:07:03 | candies | 1 | 69583 | 9 | 1.500 | 46388.7 |
371 | 2021-04-15 22:13:55 | candies | 1 | 69583 | 9 | 1.220 | 57035.2 |
370 | 2021-02-21 23:00:59 | candies | 1 | 69583 | 9 | 1.106 | 62914.1 |
369 | 2021-01-22 08:00:30 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
368 | 2020-11-04 07:11:07 | candies | 1 | 69583 | 9 | 2.110 | 32977.7 |
367 | 2020-11-02 07:13:57 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
366 | 2020-11-01 11:28:47 | candies | 1 | 69583 | 9 | 1.233 | 56433.9 |
365 | 2020-10-20 00:36:29 | candies | 1 | 69583 | 9 | 1.143 | 60877.5 |
364 | 2020-10-17 18:54:42 | candies | 1 | 69583 | 9 | 1.250 | 55666.4 |
363 | 2020-10-15 16:48:29 | candies | 1 | 69583 | 9 | 1.186 | 58670.3 |
362 | 2020-08-12 01:39:43 | candies | 1 | 69583 | 9 | 1.236 | 56296.9 |
361 | 2020-07-18 13:22:16 | candies | 1 | 69583 | 9 | 1.203 | 57841.2 |
360 | 2020-04-21 21:01:09 | candies | 1 | 69583 | 9 | 1.313 | 52995.4 |
359 | 2020-04-16 17:40:59 | candies | 1 | 69583 | 9 | 1.186 | 58670.3 |
358 | 2020-03-28 17:14:43 | candies | 1 | 69583 | 9 | 1.310 | 53116.8 |
357 | 2020-03-24 01:55:35 | candies | 1 | 69583 | 9 | 1.203 | 57841.2 |
356 | 2020-03-23 17:03:00 | candies | 1 | 69583 | 9 | 1.470 | 47335.4 |
355 | 2020-03-20 09:05:37 | candies | 1 | 69583 | 9 | 1.126 | 61796.6 |
354 | 2020-02-27 03:26:51 | candies | 1 | 69583 | 9 | 4.203 | 16555.6 |
353 | 2020-02-25 09:47:42 | candies | 1 | 69583 | 9 | 1.220 | 57035.2 |
352 | 2020-02-25 07:07:20 | candies | 1 | 69583 | 9 | 1.313 | 52995.4 |
351 | 2020-02-23 08:30:56 | candies | 1 | 69583 | 9 | 2.656 | 26198.4 |
350 | 2020-02-22 19:34:00 | candies | 1 | 69583 | 9 | 4.140 | 16807.5 |
349 | 2020-02-22 05:48:04 | candies | 1 | 69583 | 9 | 1.420 | 49002.1 |
348 | 2020-02-15 11:07:57 | candies | 1 | 69583 | 9 | 1.296 | 53690.6 |
347 | 2020-02-10 04:30:04 | candies | 1 | 69583 | 9 | 1.436 | 48456.1 |
346 | 2020-02-02 08:01:53 | candies | 1 | 69583 | 9 | 1.830 | 38023.5 |
345 | 2020-01-31 16:53:47 | candies | 1 | 69583 | 9 | 1.296 | 53690.6 |
344 | 2020-01-30 14:43:05 | candies | 1 | 69583 | 9 | 1.330 | 52318.0 |
343 | 2020-01-26 20:03:00 | candies | 1 | 69583 | 9 | 1.813 | 38380.0 |
342 | 2020-01-25 18:36:01 | candies | 1 | 69583 | 9 | 1.390 | 50059.7 |
341 | 2020-01-24 20:55:34 | candies | 1 | 69583 | 9 | 2.860 | 24329.7 |
340 | 2020-01-22 19:39:49 | candies | 1 | 69583 | 9 | 1.393 | 49951.9 |
339 | 2020-01-16 10:51:59 | candies | 1 | 69583 | 9 | 1.153 | 60349.5 |
338 | 2020-01-13 17:31:33 | candies | 1 | 69583 | 9 | 1.310 | 53116.8 |
337 | 2020-01-13 09:40:48 | candies | 1 | 69583 | 9 | 2.720 | 25582.0 |
336 | 2020-01-11 03:41:50 | candies | 1 | 69583 | 9 | 1.453 | 47889.2 |
335 | 2020-01-07 08:44:30 | candies | 1 | 69583 | 9 | 1.376 | 50569.0 |
334 | 2019-12-27 19:02:50 | candies | 1 | 69583 | 9 | 1.233 | 56433.9 |
333 | 2019-12-27 01:51:59 | candies | 1 | 69583 | 9 | 2.956 | 23539.6 |
332 | 2019-12-26 19:55:42 | candies | 1 | 69583 | 9 | 1.313 | 52995.4 |
331 | 2019-12-26 13:16:28 | candies | 1 | 69583 | 9 | 1.373 | 50679.5 |
330 | 2019-12-19 13:46:13 | candies | 1 | 69583 | 9 | 1.110 | 62687.4 |
329 | 2019-10-28 02:24:56 | candies | 1 | 69583 | 9 | 1.216 | 57222.9 |