History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"apatite"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
426 | 2024-05-11 00:12:06 | apatite | 1 | 69583 | 2 | 3.126 | 22259.4 |
425 | 2024-03-28 08:41:02 | apatite | 1 | 69583 | 2 | 1.220 | 57035.2 |
424 | 2024-03-01 18:37:13 | apatite | 1 | 69583 | 2 | 1.280 | 54361.7 |
423 | 2024-01-27 00:56:19 | apatite | 2 | 107671 | 13 | 6.563 | 16405.8 |
422 | 2024-01-27 00:55:27 | apatite | 3 | 134027 | 204 | 7.000 | 19146.7 |
421 | 2024-01-26 06:09:53 | apatite | 3 | 134027 | 204 | 14.033 | 9550.8 |
420 | 2024-01-15 18:24:36 | apatite | 3 | 134027 | 204 | 6.610 | 20276.4 |
419 | 2024-01-15 18:24:37 | apatite | 2 | 107671 | 13 | 3.330 | 32333.6 |
418 | 2023-12-30 21:19:36 | apatite | 1 | 69583 | 2 | 1.170 | 59472.6 |
417 | 2023-12-25 01:57:12 | apatite | 1 | 69583 | 2 | 1.076 | 64668.2 |
416 | 2023-12-09 21:02:13 | apatite | 1 | 69583 | 2 | 1.076 | 64668.2 |
415 | 2023-12-01 01:11:41 | apatite | 3 | 134027 | 204 | 8.500 | 15767.9 |
414 | 2023-12-01 01:11:37 | apatite | 2 | 107671 | 13 | 3.986 | 27012.3 |
413 | 2023-11-18 08:00:34 | apatite | 1 | 69583 | 2 | 1.233 | 56433.9 |
412 | 2023-11-17 09:21:43 | apatite | 1 | 69583 | 2 | 1.096 | 63488.1 |
411 | 2023-11-14 23:55:05 | apatite | 1 | 69583 | 2 | 1.093 | 63662.4 |
410 | 2023-11-11 04:13:56 | apatite | 1 | 69583 | 2 | 1.263 | 55093.4 |
409 | 2023-11-03 18:25:09 | apatite | 1 | 69583 | 2 | 1.250 | 55666.4 |
408 | 2023-10-27 17:47:00 | apatite | 1 | 69583 | 2 | 1.203 | 57841.2 |
407 | 2023-10-17 16:51:43 | apatite | 1 | 69583 | 2 | 1.343 | 51811.6 |
406 | 2023-10-14 01:38:21 | apatite | 1 | 69583 | 2 | 1.063 | 65459.1 |
405 | 2023-10-06 09:20:57 | apatite | 1 | 69583 | 2 | 1.203 | 57841.2 |
404 | 2023-09-26 07:17:04 | apatite | 1 | 69583 | 2 | 1.076 | 64668.2 |
403 | 2023-09-24 23:00:07 | apatite | 1 | 69583 | 2 | 1.156 | 60192.9 |
402 | 2023-09-12 17:47:28 | apatite | 1 | 69583 | 2 | 1.110 | 62687.4 |
401 | 2023-07-28 15:33:34 | apatite | 1 | 69583 | 2 | 1.093 | 63662.4 |
400 | 2023-07-22 02:02:05 | apatite | 1 | 69583 | 2 | 1.080 | 64428.7 |
399 | 2023-04-20 08:03:14 | apatite | 1 | 69583 | 2 | 1.080 | 64428.7 |
398 | 2023-04-19 17:18:07 | apatite | 1 | 69583 | 2 | 1.296 | 53690.6 |
397 | 2023-02-07 02:38:23 | apatite | 1 | 69583 | 2 | 1.186 | 58670.3 |
396 | 2023-01-15 08:39:05 | apatite | 1 | 69583 | 2 | 1.060 | 65644.3 |
395 | 2022-12-05 15:34:53 | apatite | 1 | 69583 | 2 | 1.063 | 65459.1 |
394 | 2022-10-01 09:24:31 | apatite | 1 | 69583 | 2 | 1.236 | 56296.9 |
393 | 2022-08-02 03:37:02 | apatite | 1 | 69583 | 2 | 1.106 | 62914.1 |
392 | 2022-06-14 08:56:25 | apatite | 1 | 69583 | 2 | 1.143 | 60877.5 |
391 | 2022-06-10 18:06:14 | apatite | 1 | 69583 | 2 | 1.220 | 57035.2 |
390 | 2022-03-27 11:28:05 | apatite | 1 | 69583 | 2 | 1.250 | 55666.4 |
389 | 2022-02-23 18:54:11 | apatite | 1 | 69583 | 2 | 1.470 | 47335.4 |
388 | 2022-01-02 08:46:12 | apatite | 1 | 69583 | 2 | 1.110 | 62687.4 |
387 | 2021-11-23 10:47:53 | apatite | 1 | 69583 | 2 | 1.250 | 55666.4 |
386 | 2021-11-15 14:42:58 | apatite | 1 | 69583 | 2 | 2.313 | 30083.4 |
385 | 2021-08-12 18:42:00 | apatite | 1 | 69583 | 2 | 1.076 | 64668.2 |
384 | 2021-05-12 01:34:55 | apatite | 1 | 69583 | 2 | 1.266 | 54962.9 |
383 | 2021-05-11 14:03:51 | apatite | 1 | 69583 | 2 | 1.123 | 61961.7 |
382 | 2021-05-01 22:04:00 | apatite | 1 | 69583 | 2 | 2.470 | 28171.3 |
381 | 2021-04-10 08:24:22 | apatite | 1 | 69583 | 2 | 1.203 | 57841.2 |
380 | 2021-02-07 16:27:59 | apatite | 1 | 69583 | 2 | 1.220 | 57035.2 |
379 | 2021-02-02 17:30:15 | apatite | 1 | 69583 | 2 | 1.096 | 63488.1 |
378 | 2021-01-29 12:37:12 | apatite | 1 | 69583 | 2 | 1.076 | 64668.2 |
377 | 2021-01-29 08:52:17 | apatite | 1 | 69583 | 2 | 1.093 | 63662.4 |
376 | 2021-01-24 20:31:31 | apatite | 1 | 69583 | 2 | 1.203 | 57841.2 |
375 | 2020-11-29 14:46:46 | apatite | 1 | 69583 | 2 | 1.076 | 64668.2 |
374 | 2020-11-03 04:09:00 | apatite | 1 | 69583 | 2 | 1.203 | 57841.2 |
373 | 2020-10-26 18:06:03 | apatite | 1 | 69583 | 2 | 1.156 | 60192.9 |
372 | 2020-10-17 02:04:40 | apatite | 1 | 69583 | 2 | 1.220 | 57035.2 |
371 | 2020-10-16 05:41:28 | apatite | 1 | 69583 | 2 | 1.093 | 63662.4 |
370 | 2020-10-08 11:17:11 | apatite | 1 | 69583 | 2 | 1.080 | 64428.7 |
369 | 2020-09-29 03:12:01 | apatite | 1 | 69583 | 2 | 1.110 | 62687.4 |
368 | 2020-09-02 00:57:18 | apatite | 1 | 69583 | 2 | 1.296 | 53690.6 |
367 | 2020-08-03 17:02:08 | apatite | 1 | 69583 | 2 | 1.156 | 60192.9 |
366 | 2020-07-22 23:13:52 | apatite | 1 | 69583 | 2 | 1.140 | 61037.7 |
365 | 2020-04-20 23:57:02 | apatite | 1 | 69583 | 2 | 1.126 | 61796.6 |
364 | 2020-03-28 13:09:53 | apatite | 1 | 69583 | 2 | 1.236 | 56296.9 |
363 | 2020-03-28 06:21:33 | apatite | 1 | 69583 | 2 | 1.283 | 54234.6 |
362 | 2020-03-23 16:48:26 | apatite | 1 | 69583 | 2 | 1.093 | 63662.4 |
361 | 2020-03-22 23:31:20 | apatite | 1 | 69583 | 2 | 1.200 | 57985.8 |
360 | 2020-03-20 12:12:19 | apatite | 1 | 69583 | 2 | 1.250 | 55666.4 |
359 | 2020-02-26 22:40:41 | apatite | 1 | 69583 | 2 | 1.343 | 51811.6 |
358 | 2020-02-23 11:39:26 | apatite | 1 | 69583 | 2 | 1.280 | 54361.7 |
357 | 2020-02-13 05:38:27 | apatite | 1 | 69583 | 2 | 2.030 | 34277.3 |
356 | 2020-02-07 21:35:18 | apatite | 1 | 69583 | 2 | 1.220 | 57035.2 |
355 | 2020-02-07 16:09:48 | apatite | 1 | 69583 | 2 | 1.830 | 38023.5 |
354 | 2020-02-06 17:40:30 | apatite | 1 | 69583 | 2 | 1.606 | 43326.9 |
353 | 2020-02-03 13:39:15 | apatite | 1 | 69583 | 2 | 2.033 | 34226.8 |
352 | 2020-02-02 10:32:21 | apatite | 1 | 69583 | 2 | 1.296 | 53690.6 |
351 | 2020-01-28 00:52:02 | apatite | 1 | 69583 | 2 | 4.076 | 17071.4 |
350 | 2020-01-22 22:36:14 | apatite | 1 | 69583 | 2 | 3.343 | 20814.5 |
349 | 2020-01-20 13:05:13 | apatite | 1 | 69583 | 2 | 1.906 | 36507.3 |
348 | 2020-01-16 12:50:40 | apatite | 1 | 69583 | 2 | 1.296 | 53690.6 |
347 | 2020-01-16 11:16:00 | apatite | 1 | 69583 | 2 | 2.716 | 25619.7 |
346 | 2020-01-13 05:06:21 | apatite | 1 | 69583 | 2 | 1.313 | 52995.4 |
345 | 2020-01-06 21:45:25 | apatite | 1 | 69583 | 2 | 2.923 | 23805.3 |
344 | 2019-12-29 01:00:11 | apatite | 1 | 69583 | 2 | 1.330 | 52318.0 |
343 | 2019-12-28 05:45:05 | apatite | 1 | 69583 | 2 | 1.390 | 50059.7 |
342 | 2019-12-27 23:22:27 | apatite | 1 | 69583 | 2 | 1.110 | 62687.4 |
341 | 2019-12-27 05:14:33 | apatite | 1 | 69583 | 2 | 1.123 | 61961.7 |
340 | 2019-10-27 03:44:37 | apatite | 2 | 107671 | 13 | 2.876 | 37437.8 |
339 | 2019-10-27 03:44:34 | apatite | 1 | 69583 | 2 | 1.216 | 57222.9 |
338 | 2019-10-21 13:51:30 | apatite | 1 | 69583 | 2 | 1.233 | 56433.9 |
337 | 2019-07-20 19:07:16 | apatite | 1 | 69583 | 2 | 1.093 | 63662.4 |
336 | 2019-04-19 18:54:26 | apatite | 1 | 69583 | 2 | 1.083 | 64250.2 |
335 | 2019-04-02 07:31:17 | apatite | 1 | 69583 | 2 | 1.103 | 63085.2 |
334 | 2019-03-06 05:45:22 | apatite | 1 | 69583 | 2 | 1.033 | 67360.1 |
333 | 2019-02-25 02:47:12 | apatite | 1 | 69583 | 2 | 1.193 | 58326.1 |
332 | 2019-02-20 17:47:03 | apatite | 1 | 69583 | 2 | 1.066 | 65274.9 |
331 | 2019-02-11 13:51:57 | apatite | 1 | 69583 | 2 | 1.156 | 60192.9 |
330 | 2019-02-09 18:11:52 | apatite | 1 | 69583 | 2 | 1.100 | 63257.3 |
329 | 2019-01-26 07:12:28 | apatite | 1 | 69583 | 2 | 1.196 | 58179.8 |
328 | 2019-01-17 15:06:42 | apatite | 1 | 69583 | 2 | 1.300 | 53525.4 |
327 | 2019-01-10 08:12:43 | apatite | 1 | 69583 | 2 | 1.166 | 59676.7 |