History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assaying"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
407 | 2024-04-08 15:53:42 | assaying | 1 | 82945 | 2 | 1.813 | 45750.1 |
406 | 2024-03-30 04:37:09 | assaying | 1 | 82945 | 2 | 3.560 | 23299.2 |
405 | 2024-03-24 23:54:12 | assaying | 1 | 82945 | 2 | 1.483 | 55930.5 |
404 | 2024-03-15 09:48:28 | assaying | 1 | 82945 | 2 | 5.296 | 15661.8 |
403 | 2024-03-14 11:42:29 | assaying | 2 | 121059 | 21 | 5.250 | 23058.9 |
402 | 2024-03-14 11:41:53 | assaying | 3 | 146162 | 197 | 9.013 | 16216.8 |
401 | 2024-03-13 16:03:28 | assaying | 3 | 146162 | 197 | 17.313 | 8442.3 |
400 | 2024-03-09 01:00:50 | assaying | 3 | 146162 | 197 | 24.706 | 5916.1 |
399 | 2024-03-08 23:32:13 | assaying | 2 | 121059 | 21 | 8.283 | 14615.4 |
398 | 2024-03-08 23:31:34 | assaying | 3 | 146162 | 197 | 9.063 | 16127.3 |
397 | 2024-03-07 23:57:32 | assaying | 3 | 146162 | 197 | 7.860 | 18595.7 |
396 | 2024-03-07 22:50:21 | assaying | 3 | 146162 | 197 | 7.280 | 20077.2 |
395 | 2024-03-07 22:50:17 | assaying | 2 | 121059 | 21 | 5.750 | 21053.7 |
394 | 2024-02-28 13:32:36 | assaying | 1 | 82945 | 2 | 1.673 | 49578.6 |
393 | 2024-02-15 23:58:11 | assaying | 1 | 82945 | 2 | 1.313 | 63172.1 |
392 | 2024-02-05 00:05:47 | assaying | 3 | 146162 | 197 | 8.046 | 18165.8 |
391 | 2024-02-04 10:52:51 | assaying | 3 | 146162 | 197 | 10.520 | 13893.7 |
390 | 2024-01-30 06:12:17 | assaying | 3 | 146162 | 197 | 13.253 | 11028.6 |
389 | 2024-01-30 06:12:21 | assaying | 2 | 121059 | 21 | 3.906 | 30993.1 |
388 | 2024-01-30 04:51:46 | assaying | 2 | 121059 | 21 | 4.126 | 29340.5 |
387 | 2024-01-30 04:50:51 | assaying | 3 | 146162 | 197 | 7.733 | 18901.1 |
386 | 2024-01-30 04:38:03 | assaying | 3 | 146162 | 197 | 13.423 | 10888.9 |
385 | 2024-01-30 04:38:07 | assaying | 2 | 121059 | 21 | 4.436 | 27290.1 |
384 | 2024-01-30 04:37:59 | assaying | 1 | 82945 | 2 | 1.500 | 55296.7 |
383 | 2024-01-28 10:41:45 | assaying | 1 | 82945 | 2 | 1.576 | 52630.1 |
382 | 2023-12-19 02:09:25 | assaying | 1 | 82945 | 2 | 1.296 | 64000.8 |
381 | 2023-11-28 05:50:20 | assaying | 1 | 82945 | 2 | 1.266 | 65517.4 |
380 | 2023-11-22 07:26:24 | assaying | 1 | 82945 | 2 | 1.280 | 64800.8 |
379 | 2023-11-10 23:21:32 | assaying | 1 | 82945 | 2 | 1.376 | 60279.8 |
378 | 2023-11-04 01:38:41 | assaying | 1 | 82945 | 2 | 2.156 | 38471.7 |
377 | 2023-10-07 03:18:40 | assaying | 1 | 82945 | 2 | 1.500 | 55296.7 |
376 | 2023-10-06 14:01:22 | assaying | 1 | 82945 | 2 | 1.263 | 65673.0 |
375 | 2023-10-04 10:16:05 | assaying | 1 | 82945 | 2 | 1.406 | 58993.6 |
374 | 2023-09-26 12:38:48 | assaying | 1 | 82945 | 2 | 1.296 | 64000.8 |
373 | 2023-09-15 17:09:37 | assaying | 1 | 82945 | 2 | 1.440 | 57600.7 |
372 | 2023-08-03 06:54:21 | assaying | 1 | 82945 | 2 | 1.266 | 65517.4 |
371 | 2023-07-26 11:31:41 | assaying | 1 | 82945 | 2 | 1.453 | 57085.3 |
370 | 2023-06-19 14:52:42 | assaying | 1 | 82945 | 2 | 1.390 | 59672.7 |
369 | 2023-05-03 17:38:13 | assaying | 1 | 82945 | 2 | 1.266 | 65517.4 |
368 | 2023-02-27 12:17:39 | assaying | 1 | 82945 | 2 | 1.266 | 65517.4 |
367 | 2023-02-25 02:39:11 | assaying | 1 | 82945 | 2 | 1.266 | 65517.4 |
366 | 2023-02-13 22:55:16 | assaying | 1 | 82945 | 2 | 1.453 | 57085.3 |
365 | 2022-12-25 19:09:45 | assaying | 1 | 82945 | 2 | 1.250 | 66356.0 |
364 | 2022-12-25 11:59:48 | assaying | 1 | 82945 | 2 | 1.236 | 67107.6 |
363 | 2022-11-18 23:22:32 | assaying | 1 | 82945 | 2 | 1.280 | 64800.8 |
362 | 2022-11-15 00:34:06 | assaying | 1 | 82945 | 2 | 1.250 | 66356.0 |
361 | 2022-11-01 06:41:36 | assaying | 1 | 82945 | 2 | 1.250 | 66356.0 |
360 | 2022-09-13 05:29:29 | assaying | 1 | 82945 | 2 | 1.376 | 60279.8 |
359 | 2022-07-20 00:08:58 | assaying | 1 | 82945 | 2 | 1.330 | 62364.7 |
358 | 2022-07-18 21:01:16 | assaying | 1 | 82945 | 2 | 1.530 | 54212.4 |
357 | 2022-07-03 21:12:26 | assaying | 1 | 82945 | 2 | 1.313 | 63172.1 |
356 | 2022-06-09 20:32:05 | assaying | 1 | 82945 | 2 | 1.420 | 58412.0 |
355 | 2022-05-26 12:07:48 | assaying | 1 | 82945 | 2 | 1.420 | 58412.0 |
354 | 2022-03-28 06:53:56 | assaying | 1 | 82945 | 2 | 1.296 | 64000.8 |
353 | 2022-03-17 09:36:01 | assaying | 1 | 82945 | 2 | 1.860 | 44594.1 |
352 | 2022-03-15 06:11:53 | assaying | 1 | 82945 | 2 | 1.283 | 64649.3 |
351 | 2022-01-07 07:52:18 | assaying | 1 | 82945 | 2 | 1.450 | 57203.4 |
350 | 2021-12-17 05:12:40 | assaying | 1 | 82945 | 2 | 1.423 | 58288.8 |
349 | 2021-09-06 17:46:35 | assaying | 1 | 82945 | 2 | 1.280 | 64800.8 |
348 | 2021-06-05 17:34:41 | assaying | 1 | 82945 | 2 | 2.610 | 31779.7 |
347 | 2021-04-29 23:32:27 | assaying | 1 | 82945 | 2 | 1.423 | 58288.8 |
346 | 2021-03-03 14:43:55 | assaying | 1 | 82945 | 2 | 1.266 | 65517.4 |
345 | 2021-02-16 21:44:13 | assaying | 1 | 82945 | 2 | 1.296 | 64000.8 |
344 | 2020-12-25 18:20:11 | assaying | 1 | 82945 | 2 | 1.423 | 58288.8 |
343 | 2020-12-02 12:49:22 | assaying | 1 | 82945 | 2 | 1.250 | 66356.0 |
342 | 2020-11-11 08:02:27 | assaying | 1 | 82945 | 2 | 2.950 | 28116.9 |
341 | 2020-10-25 03:43:28 | assaying | 1 | 82945 | 2 | 1.296 | 64000.8 |
340 | 2020-10-17 15:19:00 | assaying | 1 | 82945 | 2 | 1.390 | 59672.7 |
339 | 2020-08-31 11:35:02 | assaying | 1 | 82945 | 2 | 1.343 | 61761.0 |
338 | 2020-08-15 05:51:22 | assaying | 1 | 82945 | 2 | 1.436 | 57761.1 |
337 | 2020-05-26 16:54:13 | assaying | 1 | 82945 | 2 | 1.266 | 65517.4 |
336 | 2020-05-10 08:28:56 | assaying | 1 | 82945 | 2 | 1.390 | 59672.7 |
335 | 2020-03-22 20:21:27 | assaying | 1 | 82945 | 2 | 1.640 | 50576.2 |
334 | 2020-02-28 07:57:24 | assaying | 3 | 146162 | 197 | 13.486 | 10838.1 |
333 | 2020-02-25 16:30:18 | assaying | 1 | 82945 | 2 | 1.533 | 54106.3 |
332 | 2020-02-23 11:50:45 | assaying | 1 | 82945 | 2 | 2.326 | 35659.9 |
331 | 2020-02-23 10:33:58 | assaying | 3 | 146162 | 197 | 16.346 | 8941.8 |
330 | 2020-02-23 04:13:05 | assaying | 3 | 146162 | 197 | 11.966 | 12214.8 |
329 | 2020-02-18 02:54:42 | assaying | 1 | 82945 | 2 | 1.516 | 54713.1 |
328 | 2020-02-17 05:30:04 | assaying | 1 | 82945 | 2 | 1.623 | 51106.0 |
327 | 2020-02-14 13:48:05 | assaying | 1 | 82945 | 2 | 1.310 | 63316.8 |
326 | 2020-02-08 23:39:50 | assaying | 3 | 146162 | 197 | 9.220 | 15852.7 |
325 | 2020-02-08 08:35:48 | assaying | 3 | 146162 | 197 | 9.300 | 15716.3 |
324 | 2020-02-06 09:04:42 | assaying | 2 | 121059 | 21 | 3.170 | 38189.0 |
323 | 2020-02-03 03:57:07 | assaying | 1 | 82945 | 2 | 2.436 | 34049.7 |
322 | 2020-02-02 21:55:51 | assaying | 1 | 82945 | 2 | 1.516 | 54713.1 |
321 | 2020-02-02 03:06:10 | assaying | 1 | 82945 | 2 | 4.703 | 17636.6 |
320 | 2020-01-24 07:10:56 | assaying | 1 | 82945 | 2 | 1.826 | 45424.4 |
319 | 2020-01-24 05:48:17 | assaying | 1 | 82945 | 2 | 1.673 | 49578.6 |
318 | 2020-01-23 14:30:13 | assaying | 3 | 146162 | 197 | 6.516 | 22431.2 |
317 | 2020-01-23 08:32:38 | assaying | 3 | 146162 | 197 | 24.736 | 5908.9 |
316 | 2020-01-23 04:05:03 | assaying | 3 | 146162 | 197 | 23.060 | 6338.3 |
315 | 2020-01-22 01:35:17 | assaying | 1 | 82945 | 2 | 4.343 | 19098.5 |
314 | 2020-01-19 04:39:50 | assaying | 3 | 146162 | 197 | 8.236 | 17746.7 |
313 | 2020-01-18 15:19:26 | assaying | 2 | 121059 | 21 | 3.920 | 30882.4 |
312 | 2020-01-18 15:18:43 | assaying | 3 | 146162 | 197 | 17.800 | 8211.3 |
311 | 2020-01-18 08:06:38 | assaying | 1 | 82945 | 2 | 1.563 | 53067.8 |
310 | 2020-01-12 21:46:54 | assaying | 1 | 82945 | 2 | 1.563 | 53067.8 |
309 | 2020-01-02 13:55:12 | assaying | 1 | 82945 | 2 | 1.560 | 53169.9 |
308 | 2020-01-01 11:17:43 | assaying | 1 | 82945 | 2 | 1.486 | 55817.6 |