History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sphene"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
412 | 2024-04-14 08:31:36 | sphene | 2 | 82551 | 36 | 10.470 | 7884.5 |
411 | 2024-04-14 08:28:29 | sphene | 2 | 82551 | 36 | 4.093 | 20168.8 |
410 | 2024-04-08 21:58:54 | sphene | 3 | 112716 | 494 | 17.783 | 6338.4 |
409 | 2024-04-08 06:50:50 | sphene | 2 | 82551 | 36 | 2.656 | 31080.9 |
408 | 2024-04-08 06:50:27 | sphene | 3 | 112716 | 494 | 7.643 | 14747.6 |
407 | 2024-04-08 03:08:23 | sphene | 3 | 112716 | 494 | 11.940 | 9440.2 |
406 | 2024-04-06 06:46:25 | sphene | 3 | 112716 | 494 | 17.843 | 6317.1 |
405 | 2024-04-06 06:46:26 | sphene | 2 | 82551 | 36 | 10.800 | 7643.6 |
404 | 2024-04-06 06:46:22 | sphene | 1 | 48755 | 3 | 1.250 | 39004.0 |
403 | 2024-03-30 02:31:59 | sphene | 1 | 48755 | 3 | 1.860 | 26212.4 |
402 | 2024-03-26 11:42:41 | sphene | 1 | 48755 | 3 | 0.920 | 52994.6 |
401 | 2024-03-17 06:55:29 | sphene | 1 | 48755 | 3 | 1.626 | 29984.6 |
400 | 2024-01-27 21:37:35 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
399 | 2024-01-11 22:15:40 | sphene | 2 | 82551 | 36 | 4.936 | 16724.3 |
398 | 2023-12-21 00:21:09 | sphene | 1 | 48755 | 3 | 0.796 | 61250.0 |
397 | 2023-12-17 18:47:53 | sphene | 1 | 48755 | 3 | 0.873 | 55847.7 |
396 | 2023-12-15 22:50:35 | sphene | 1 | 48755 | 3 | 1.500 | 32503.3 |
395 | 2023-12-14 13:52:00 | sphene | 3 | 112716 | 494 | 5.453 | 20670.5 |
394 | 2023-12-14 13:52:02 | sphene | 2 | 82551 | 36 | 2.593 | 31836.1 |
393 | 2023-12-13 13:40:29 | sphene | 1 | 48755 | 3 | 0.766 | 63648.8 |
392 | 2023-12-08 23:31:33 | sphene | 2 | 82551 | 36 | 2.330 | 35429.6 |
391 | 2023-12-04 08:29:55 | sphene | 2 | 82551 | 36 | 2.526 | 32680.5 |
390 | 2023-12-04 08:29:52 | sphene | 2 | 82551 | 36 | 2.376 | 34743.7 |
389 | 2023-12-03 00:43:01 | sphene | 2 | 82551 | 36 | 2.393 | 34496.9 |
388 | 2023-12-03 00:42:56 | sphene | 3 | 112716 | 494 | 5.250 | 21469.7 |
387 | 2023-11-23 05:02:14 | sphene | 3 | 112716 | 494 | 5.796 | 19447.2 |
386 | 2023-11-17 02:50:44 | sphene | 1 | 48755 | 3 | 0.810 | 60191.4 |
385 | 2023-11-11 10:28:05 | sphene | 1 | 48755 | 3 | 0.876 | 55656.4 |
384 | 2023-11-09 23:16:30 | sphene | 1 | 48755 | 3 | 0.733 | 66514.3 |
383 | 2023-11-02 15:36:05 | sphene | 3 | 112716 | 494 | 5.376 | 20966.5 |
382 | 2023-11-02 15:36:04 | sphene | 2 | 82551 | 36 | 2.406 | 34310.5 |
381 | 2023-10-27 22:03:27 | sphene | 1 | 48755 | 3 | 0.780 | 62506.4 |
380 | 2023-10-20 22:34:01 | sphene | 1 | 48755 | 3 | 0.953 | 51159.5 |
379 | 2023-10-18 05:00:01 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
378 | 2023-10-14 06:46:29 | sphene | 1 | 48755 | 3 | 0.843 | 57835.1 |
377 | 2023-10-04 13:11:02 | sphene | 1 | 48755 | 3 | 0.830 | 58741.0 |
376 | 2023-09-30 00:58:05 | sphene | 1 | 48755 | 3 | 0.796 | 61250.0 |
375 | 2023-09-23 12:17:55 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
374 | 2023-09-12 06:37:06 | sphene | 1 | 48755 | 3 | 0.796 | 61250.0 |
373 | 2023-09-06 00:30:07 | sphene | 2 | 82551 | 36 | 2.096 | 39385.0 |
372 | 2023-08-11 14:12:32 | sphene | 1 | 48755 | 3 | 0.860 | 56691.9 |
371 | 2023-08-07 22:31:10 | sphene | 1 | 48755 | 3 | 0.843 | 57835.1 |
370 | 2023-07-28 09:52:32 | sphene | 1 | 48755 | 3 | 0.830 | 58741.0 |
369 | 2023-07-14 01:38:08 | sphene | 1 | 48755 | 3 | 0.843 | 57835.1 |
368 | 2023-05-21 13:25:34 | sphene | 2 | 82551 | 36 | 2.110 | 39123.7 |
367 | 2023-04-25 16:22:39 | sphene | 1 | 48755 | 3 | 0.873 | 55847.7 |
366 | 2023-04-11 23:48:31 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
365 | 2023-02-27 23:50:19 | sphene | 2 | 82551 | 36 | 2.110 | 39123.7 |
364 | 2023-02-17 10:32:13 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
363 | 2022-12-19 08:58:25 | sphene | 1 | 48755 | 3 | 0.860 | 56691.9 |
362 | 2022-12-13 07:06:13 | sphene | 1 | 48755 | 3 | 0.736 | 66243.2 |
361 | 2022-12-08 08:46:52 | sphene | 2 | 82551 | 36 | 2.326 | 35490.5 |
360 | 2022-08-20 09:48:08 | sphene | 1 | 48755 | 3 | 0.736 | 66243.2 |
359 | 2022-08-18 01:26:49 | sphene | 1 | 48755 | 3 | 0.826 | 59025.4 |
358 | 2022-08-09 11:07:24 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
357 | 2022-07-19 14:46:13 | sphene | 2 | 82551 | 36 | 2.156 | 38289.0 |
356 | 2022-07-19 13:42:00 | sphene | 2 | 82551 | 36 | 2.356 | 35038.6 |
355 | 2022-07-19 13:41:39 | sphene | 3 | 112716 | 494 | 5.140 | 21929.2 |
354 | 2022-07-18 20:05:44 | sphene | 1 | 48755 | 3 | 0.780 | 62506.4 |
353 | 2022-07-18 00:18:54 | sphene | 1 | 48755 | 3 | 0.733 | 66514.3 |
352 | 2022-07-03 04:33:11 | sphene | 1 | 48755 | 3 | 0.876 | 55656.4 |
351 | 2022-06-25 09:38:21 | sphene | 1 | 48755 | 3 | 0.763 | 63899.1 |
350 | 2022-06-08 23:55:25 | sphene | 1 | 48755 | 3 | 0.766 | 63648.8 |
349 | 2022-05-26 08:49:14 | sphene | 1 | 48755 | 3 | 0.766 | 63648.8 |
348 | 2022-04-02 07:12:40 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
347 | 2022-03-31 02:39:44 | sphene | 1 | 48755 | 3 | 0.813 | 59969.2 |
346 | 2022-03-28 23:28:36 | sphene | 1 | 48755 | 3 | 1.123 | 43415.0 |
345 | 2022-02-25 14:31:29 | sphene | 2 | 82551 | 36 | 2.513 | 32849.6 |
344 | 2022-02-23 10:55:13 | sphene | 2 | 82551 | 36 | 2.640 | 31269.3 |
343 | 2022-01-01 18:19:02 | sphene | 1 | 48755 | 3 | 0.890 | 54780.9 |
342 | 2021-12-30 14:47:24 | sphene | 1 | 48755 | 3 | 0.906 | 53813.5 |
341 | 2021-12-06 05:57:41 | sphene | 2 | 82551 | 36 | 2.110 | 39123.7 |
340 | 2021-12-01 13:20:51 | sphene | 1 | 48755 | 3 | 0.873 | 55847.7 |
339 | 2021-11-10 05:36:07 | sphene | 1 | 48755 | 3 | 0.826 | 59025.4 |
338 | 2021-11-08 12:34:43 | sphene | 1 | 48755 | 3 | 0.763 | 63899.1 |
337 | 2021-11-04 06:15:52 | sphene | 1 | 48755 | 3 | 0.766 | 63648.8 |
336 | 2021-09-28 01:15:26 | sphene | 1 | 48755 | 3 | 0.766 | 63648.8 |
335 | 2021-09-21 12:14:19 | sphene | 1 | 48755 | 3 | 0.766 | 63648.8 |
334 | 2021-09-20 10:04:56 | sphene | 1 | 48755 | 3 | 0.796 | 61250.0 |
333 | 2021-09-14 02:21:34 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
332 | 2021-08-26 11:18:40 | sphene | 1 | 48755 | 3 | 0.763 | 63899.1 |
331 | 2021-08-24 07:31:19 | sphene | 1 | 48755 | 3 | 0.766 | 63648.8 |
330 | 2021-08-15 04:15:00 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
329 | 2021-05-04 06:58:16 | sphene | 1 | 48755 | 3 | 0.860 | 56691.9 |
328 | 2021-05-02 08:32:12 | sphene | 1 | 48755 | 3 | 1.640 | 29728.7 |
327 | 2021-04-30 17:10:50 | sphene | 1 | 48755 | 3 | 1.766 | 27607.6 |
326 | 2021-03-31 16:08:07 | sphene | 1 | 48755 | 3 | 0.890 | 54780.9 |
325 | 2021-02-18 11:10:46 | sphene | 1 | 48755 | 3 | 0.860 | 56691.9 |
324 | 2021-01-15 11:26:52 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
323 | 2021-01-02 06:25:31 | sphene | 1 | 48755 | 3 | 0.750 | 65006.7 |
322 | 2020-11-19 04:08:31 | sphene | 1 | 48755 | 3 | 0.966 | 50471.0 |
321 | 2020-10-31 17:47:44 | sphene | 1 | 48755 | 3 | 0.733 | 66514.3 |
320 | 2020-10-01 20:19:05 | sphene | 1 | 48755 | 3 | 0.860 | 56691.9 |
319 | 2020-09-26 04:24:58 | sphene | 1 | 48755 | 3 | 0.733 | 66514.3 |
318 | 2020-09-18 15:50:12 | sphene | 1 | 48755 | 3 | 0.840 | 58041.7 |
317 | 2020-08-10 10:37:41 | sphene | 1 | 48755 | 3 | 0.783 | 62266.9 |
316 | 2020-07-24 20:13:32 | sphene | 1 | 48755 | 3 | 0.830 | 58741.0 |
315 | 2020-07-18 02:08:04 | sphene | 1 | 48755 | 3 | 0.796 | 61250.0 |
314 | 2020-06-11 09:26:32 | sphene | 1 | 48755 | 3 | 0.796 | 61250.0 |
313 | 2020-05-05 11:12:40 | sphene | 1 | 48755 | 3 | 0.780 | 62506.4 |