History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mineral"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
422 | 2024-04-25 20:23:30 | mineral | 2 | 107671 | 16 | 11.046 | 9747.5 |
421 | 2024-04-25 20:23:00 | mineral | 3 | 134027 | 226 | 27.940 | 4797.0 |
420 | 2024-04-25 20:22:51 | mineral | 1 | 69583 | 2 | 1.373 | 50679.5 |
419 | 2024-03-30 21:39:36 | mineral | 1 | 69583 | 2 | 4.953 | 14048.7 |
418 | 2024-03-30 09:23:56 | mineral | 1 | 69583 | 2 | 1.576 | 44151.6 |
417 | 2024-03-17 11:12:50 | mineral | 1 | 69583 | 2 | 1.330 | 52318.0 |
416 | 2024-03-07 11:55:35 | mineral | 1 | 69583 | 2 | 2.733 | 25460.3 |
415 | 2024-03-02 18:03:06 | mineral | 3 | 134027 | 226 | 20.076 | 6676.0 |
414 | 2024-03-02 04:44:18 | mineral | 2 | 107671 | 16 | 8.220 | 13098.7 |
413 | 2024-03-02 04:30:16 | mineral | 3 | 134027 | 226 | 7.326 | 18294.7 |
412 | 2024-02-29 03:51:50 | mineral | 1 | 69583 | 2 | 2.453 | 28366.5 |
411 | 2024-02-25 17:00:05 | mineral | 3 | 134027 | 226 | 16.453 | 8146.1 |
410 | 2024-02-25 10:35:13 | mineral | 3 | 134027 | 226 | 15.220 | 8806.0 |
409 | 2024-02-24 00:48:08 | mineral | 3 | 134027 | 226 | 6.796 | 19721.5 |
408 | 2024-02-14 23:12:31 | mineral | 1 | 69583 | 2 | 1.360 | 51164.0 |
407 | 2024-02-01 16:40:16 | mineral | 1 | 69583 | 2 | 2.110 | 32977.7 |
406 | 2024-01-16 20:59:20 | mineral | 3 | 134027 | 226 | 7.360 | 18210.2 |
405 | 2024-01-16 20:59:19 | mineral | 2 | 107671 | 16 | 7.233 | 14886.1 |
404 | 2024-01-06 06:47:40 | mineral | 2 | 107671 | 16 | 2.796 | 38508.9 |
403 | 2024-01-04 18:04:34 | mineral | 1 | 69583 | 2 | 1.126 | 61796.6 |
402 | 2023-12-20 08:13:42 | mineral | 1 | 69583 | 2 | 1.233 | 56433.9 |
401 | 2023-12-18 15:05:36 | mineral | 1 | 69583 | 2 | 1.156 | 60192.9 |
400 | 2023-12-18 02:48:31 | mineral | 1 | 69583 | 2 | 1.093 | 63662.4 |
399 | 2023-11-30 09:06:43 | mineral | 3 | 134027 | 226 | 6.170 | 21722.4 |
398 | 2023-11-30 09:06:44 | mineral | 2 | 107671 | 16 | 3.126 | 34443.7 |
397 | 2023-11-21 07:54:05 | mineral | 3 | 134027 | 226 | 5.830 | 22989.2 |
396 | 2023-11-20 17:40:58 | mineral | 1 | 69583 | 2 | 1.030 | 67556.3 |
395 | 2023-11-17 19:59:31 | mineral | 1 | 69583 | 2 | 1.280 | 54361.7 |
394 | 2023-11-03 11:23:03 | mineral | 1 | 69583 | 2 | 1.203 | 57841.2 |
393 | 2023-10-22 05:07:50 | mineral | 1 | 69583 | 2 | 1.280 | 54361.7 |
392 | 2023-10-12 04:36:39 | mineral | 2 | 107671 | 16 | 3.080 | 34958.1 |
391 | 2023-10-07 01:10:45 | mineral | 1 | 69583 | 2 | 2.483 | 28023.8 |
390 | 2023-10-05 09:33:08 | mineral | 1 | 69583 | 2 | 1.233 | 56433.9 |
389 | 2023-10-03 18:53:42 | mineral | 1 | 69583 | 2 | 1.060 | 65644.3 |
388 | 2023-09-29 15:13:36 | mineral | 1 | 69583 | 2 | 1.050 | 66269.5 |
387 | 2023-09-24 20:48:34 | mineral | 1 | 69583 | 2 | 1.173 | 59320.5 |
386 | 2023-08-21 08:37:44 | mineral | 3 | 134027 | 226 | 6.936 | 19323.4 |
385 | 2023-08-01 18:24:35 | mineral | 1 | 69583 | 2 | 1.156 | 60192.9 |
384 | 2023-07-22 02:07:50 | mineral | 2 | 107671 | 16 | 2.796 | 38508.9 |
383 | 2023-06-16 20:48:51 | mineral | 1 | 69583 | 2 | 1.203 | 57841.2 |
382 | 2023-05-06 13:13:33 | mineral | 3 | 134027 | 226 | 5.686 | 23571.4 |
381 | 2023-04-29 18:27:05 | mineral | 1 | 69583 | 2 | 1.250 | 55666.4 |
380 | 2023-04-03 13:56:19 | mineral | 2 | 107671 | 16 | 2.766 | 38926.6 |
379 | 2023-03-01 02:40:35 | mineral | 1 | 69583 | 2 | 1.046 | 66522.9 |
378 | 2023-02-18 19:59:14 | mineral | 1 | 69583 | 2 | 1.046 | 66522.9 |
377 | 2023-02-12 16:05:08 | mineral | 3 | 134027 | 226 | 5.593 | 23963.3 |
376 | 2022-12-30 20:25:57 | mineral | 2 | 107671 | 16 | 2.750 | 39153.1 |
375 | 2022-12-17 07:48:06 | mineral | 1 | 69583 | 2 | 1.173 | 59320.5 |
374 | 2022-11-24 17:03:40 | mineral | 3 | 134027 | 226 | 5.766 | 23244.4 |
373 | 2022-11-12 06:00:25 | mineral | 1 | 69583 | 2 | 1.140 | 61037.7 |
372 | 2022-09-19 22:32:53 | mineral | 1 | 69583 | 2 | 1.033 | 67360.1 |
371 | 2022-09-12 07:15:54 | mineral | 1 | 69583 | 2 | 1.173 | 59320.5 |
370 | 2022-09-10 15:31:53 | mineral | 1 | 69583 | 2 | 1.203 | 57841.2 |
369 | 2022-09-03 07:49:40 | mineral | 2 | 107671 | 16 | 3.046 | 35348.3 |
368 | 2022-08-31 03:34:04 | mineral | 1 | 69583 | 2 | 1.080 | 64428.7 |
367 | 2022-08-31 00:11:30 | mineral | 1 | 69583 | 2 | 1.173 | 59320.5 |
366 | 2022-08-14 20:13:27 | mineral | 1 | 69583 | 2 | 1.063 | 65459.1 |
365 | 2022-07-29 04:25:33 | mineral | 1 | 69583 | 2 | 1.060 | 65644.3 |
364 | 2022-07-26 17:30:42 | mineral | 1 | 69583 | 2 | 1.080 | 64428.7 |
363 | 2022-07-23 01:30:39 | mineral | 1 | 69583 | 2 | 1.076 | 64668.2 |
362 | 2022-06-12 23:00:35 | mineral | 1 | 69583 | 2 | 1.170 | 59472.6 |
361 | 2022-05-20 02:06:01 | mineral | 1 | 69583 | 2 | 1.203 | 57841.2 |
360 | 2022-04-25 05:50:48 | mineral | 1 | 69583 | 2 | 1.186 | 58670.3 |
359 | 2022-04-13 07:52:29 | mineral | 1 | 69583 | 2 | 1.076 | 64668.2 |
358 | 2022-04-10 01:51:36 | mineral | 3 | 134027 | 226 | 5.703 | 23501.1 |
357 | 2022-04-09 23:38:16 | mineral | 1 | 69583 | 2 | 1.080 | 64428.7 |
356 | 2022-04-08 13:29:56 | mineral | 2 | 107671 | 16 | 3.856 | 27923.0 |
355 | 2022-03-25 08:10:55 | mineral | 1 | 69583 | 2 | 1.516 | 45899.1 |
354 | 2021-12-11 05:54:50 | mineral | 1 | 69583 | 2 | 1.263 | 55093.4 |
353 | 2021-08-28 08:04:16 | mineral | 1 | 69583 | 2 | 1.156 | 60192.9 |
352 | 2021-05-29 00:24:03 | mineral | 1 | 69583 | 2 | 1.216 | 57222.9 |
351 | 2021-05-27 14:01:13 | mineral | 1 | 69583 | 2 | 1.063 | 65459.1 |
350 | 2021-05-03 08:25:35 | mineral | 1 | 69583 | 2 | 1.076 | 64668.2 |
349 | 2021-02-22 07:00:10 | mineral | 1 | 69583 | 2 | 1.093 | 63662.4 |
348 | 2021-02-10 08:00:26 | mineral | 2 | 107671 | 16 | 3.173 | 33933.5 |
347 | 2021-01-29 12:50:17 | mineral | 2 | 107671 | 16 | 3.173 | 33933.5 |
346 | 2021-01-16 18:21:05 | mineral | 2 | 107671 | 16 | 6.106 | 17633.6 |
345 | 2021-01-16 15:52:53 | mineral | 1 | 69583 | 2 | 1.076 | 64668.2 |
344 | 2020-12-17 02:17:17 | mineral | 3 | 134027 | 226 | 6.253 | 21434.0 |
343 | 2020-12-04 21:40:21 | mineral | 2 | 107671 | 16 | 2.843 | 37872.3 |
342 | 2020-11-21 20:39:34 | mineral | 1 | 69583 | 2 | 1.080 | 64428.7 |
341 | 2020-11-19 06:12:24 | mineral | 1 | 69583 | 2 | 1.280 | 54361.7 |
340 | 2020-11-06 18:03:59 | mineral | 3 | 134027 | 226 | 6.906 | 19407.3 |
339 | 2020-11-02 19:20:01 | mineral | 2 | 107671 | 16 | 3.000 | 35890.3 |
338 | 2020-11-02 07:44:25 | mineral | 2 | 107671 | 16 | 6.280 | 17145.1 |
337 | 2020-10-27 22:54:29 | mineral | 2 | 107671 | 16 | 7.156 | 15046.3 |
336 | 2020-10-27 14:06:10 | mineral | 1 | 69583 | 2 | 1.096 | 63488.1 |
335 | 2020-10-02 21:25:53 | mineral | 1 | 69583 | 2 | 1.076 | 64668.2 |
334 | 2020-08-28 11:38:58 | mineral | 2 | 107671 | 16 | 2.843 | 37872.3 |
333 | 2020-08-24 11:43:55 | mineral | 2 | 107671 | 16 | 3.216 | 33479.8 |
332 | 2020-08-22 15:54:20 | mineral | 1 | 69583 | 2 | 1.093 | 63662.4 |
331 | 2020-08-12 22:51:24 | mineral | 1 | 69583 | 2 | 1.123 | 61961.7 |
330 | 2020-08-03 01:54:13 | mineral | 1 | 69583 | 2 | 1.140 | 61037.7 |
329 | 2020-08-02 18:32:33 | mineral | 1 | 69583 | 2 | 1.296 | 53690.6 |
328 | 2020-05-11 20:55:09 | mineral | 1 | 69583 | 2 | 1.046 | 66522.9 |
327 | 2020-03-27 21:53:39 | mineral | 1 | 69583 | 2 | 1.420 | 49002.1 |
326 | 2020-03-25 02:15:36 | mineral | 1 | 69583 | 2 | 2.046 | 34009.3 |
325 | 2020-03-23 12:42:15 | mineral | 1 | 69583 | 2 | 1.250 | 55666.4 |
324 | 2020-03-22 03:19:36 | mineral | 1 | 69583 | 2 | 1.310 | 53116.8 |
323 | 2020-03-19 22:26:41 | mineral | 1 | 69583 | 2 | 1.093 | 63662.4 |