History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"optician"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
435 | 2025-08-27 06:42:45 | optician | 1 | 82945 | 2 | 1.560 | 53169.9 |
434 | 2025-08-17 06:44:35 | optician | 1 | 82945 | 2 | 3.190 | 26001.6 |
433 | 2025-08-15 22:06:40 | optician | 3 | 146162 | 39 | 7.060 | 20702.8 |
432 | 2025-08-13 22:14:23 | optician | 3 | 146162 | 39 | 7.233 | 20207.7 |
431 | 2025-08-13 12:55:09 | optician | 1 | 82945 | 2 | 5.720 | 14500.9 |
430 | 2025-08-05 15:37:24 | optician | 1 | 82945 | 2 | 2.830 | 29309.2 |
429 | 2025-08-04 17:32:22 | optician | 1 | 82945 | 2 | 7.796 | 10639.4 |
428 | 2025-08-01 00:40:00 | optician | 1 | 82945 | 2 | 6.610 | 12548.4 |
427 | 2025-07-28 23:19:30 | optician | 1 | 82945 | 2 | 3.470 | 23903.5 |
426 | 2025-07-25 09:22:41 | optician | 1 | 82945 | 2 | 5.313 | 15611.7 |
425 | 2025-07-24 17:50:24 | optician | 1 | 82945 | 2 | 7.046 | 11771.9 |
424 | 2025-07-23 15:17:49 | optician | 1 | 82945 | 2 | 5.203 | 15941.8 |
423 | 2025-07-21 06:59:32 | optician | 1 | 82945 | 2 | 1.470 | 56425.2 |
422 | 2025-07-13 16:48:11 | optician | 1 | 82945 | 2 | 1.436 | 57761.1 |
421 | 2025-07-13 13:41:11 | optician | 1 | 82945 | 2 | 1.466 | 56579.1 |
420 | 2025-07-10 14:46:56 | optician | 1 | 82945 | 2 | 6.860 | 12091.1 |
419 | 2025-07-04 12:26:42 | optician | 1 | 82945 | 2 | 7.376 | 11245.3 |
418 | 2025-07-01 17:51:10 | optician | 1 | 82945 | 2 | 1.423 | 58288.8 |
417 | 2025-06-30 00:33:48 | optician | 3 | 146162 | 39 | 44.520 | 3283.1 |
416 | 2025-06-29 06:49:06 | optician | 1 | 82945 | 2 | 3.766 | 22024.7 |
415 | 2025-06-24 09:06:25 | optician | 3 | 146162 | 39 | 41.393 | 3531.1 |
414 | 2025-06-16 07:57:02 | optician | 1 | 82945 | 2 | 6.843 | 12121.1 |
413 | 2025-06-16 00:49:52 | optician | 3 | 146162 | 39 | 39.160 | 3732.4 |
412 | 2025-06-12 03:54:53 | optician | 3 | 146162 | 39 | 34.720 | 4209.7 |
411 | 2025-06-10 11:21:03 | optician | 3 | 146162 | 39 | 37.243 | 3924.5 |
410 | 2025-06-10 11:04:14 | optician | 1 | 82945 | 2 | 6.406 | 12948.0 |
409 | 2025-05-29 02:05:17 | optician | 1 | 82945 | 2 | 4.846 | 17116.2 |
408 | 2025-05-28 02:55:18 | optician | 1 | 82945 | 2 | 1.296 | 64000.8 |
407 | 2025-05-25 22:19:43 | optician | 2 | 121059 | 6 | 16.800 | 7205.9 |
406 | 2025-05-22 04:33:40 | optician | 1 | 82945 | 2 | 5.250 | 15799.0 |
405 | 2025-05-19 09:59:15 | optician | 1 | 82945 | 2 | 1.406 | 58993.6 |
404 | 2025-05-18 00:37:59 | optician | 1 | 82945 | 2 | 6.580 | 12605.6 |
403 | 2025-05-13 06:38:55 | optician | 1 | 82945 | 2 | 2.190 | 37874.4 |
402 | 2025-05-07 12:13:47 | optician | 1 | 82945 | 2 | 1.470 | 56425.2 |
401 | 2025-05-03 09:15:39 | optician | 1 | 82945 | 2 | 6.703 | 12374.3 |
400 | 2025-04-20 06:54:13 | optician | 1 | 82945 | 2 | 7.250 | 11440.7 |
399 | 2025-04-11 16:41:12 | optician | 1 | 82945 | 2 | 5.673 | 14621.0 |
398 | 2025-03-28 16:20:31 | optician | 2 | 121059 | 6 | 3.470 | 34887.3 |
397 | 2025-03-26 14:42:58 | optician | 3 | 146162 | 39 | 29.063 | 5029.1 |
396 | 2025-03-21 12:39:21 | optician | 1 | 82945 | 2 | 3.483 | 23814.2 |
395 | 2025-03-20 07:55:40 | optician | 1 | 82945 | 2 | 7.640 | 10856.7 |
394 | 2025-03-19 10:19:23 | optician | 2 | 121059 | 6 | 3.343 | 36212.7 |
393 | 2025-03-07 18:10:42 | optician | 1 | 82945 | 2 | 4.923 | 16848.5 |
392 | 2025-03-05 16:42:34 | optician | 3 | 146162 | 39 | 62.970 | 2321.1 |
391 | 2025-03-05 16:42:30 | optician | 2 | 121059 | 6 | 14.690 | 8240.9 |
390 | 2025-03-05 16:42:23 | optician | 1 | 82945 | 2 | 6.063 | 13680.5 |
389 | 2025-03-03 02:50:16 | optician | 3 | 146162 | 39 | 52.380 | 2790.4 |
388 | 2025-03-03 02:50:15 | optician | 2 | 121059 | 6 | 26.376 | 4589.7 |
387 | 2025-03-03 02:19:07 | optician | 1 | 82945 | 2 | 4.940 | 16790.5 |
386 | 2025-03-02 09:28:18 | optician | 3 | 146162 | 39 | 35.393 | 4129.7 |
385 | 2025-03-01 10:05:23 | optician | 3 | 146162 | 39 | 46.473 | 3145.1 |
384 | 2025-02-24 17:01:57 | optician | 3 | 146162 | 39 | 40.566 | 3603.1 |
383 | 2025-02-22 10:14:49 | optician | 3 | 146162 | 39 | 47.390 | 3084.2 |
382 | 2025-02-22 10:14:55 | optician | 3 | 146162 | 39 | 36.406 | 4014.8 |
381 | 2025-02-22 10:14:47 | optician | 2 | 121059 | 6 | 12.580 | 9623.1 |
380 | 2025-02-22 10:14:31 | optician | 1 | 82945 | 2 | 3.966 | 20914.0 |
379 | 2025-02-07 15:02:51 | optician | 1 | 82945 | 2 | 6.440 | 12879.7 |
378 | 2025-01-16 07:52:06 | optician | 2 | 121059 | 6 | 17.013 | 7115.7 |
377 | 2025-01-16 07:51:19 | optician | 1 | 82945 | 2 | 9.046 | 9169.2 |
376 | 2025-01-14 17:14:04 | optician | 1 | 82945 | 2 | 8.763 | 9465.4 |
375 | 2025-01-14 11:51:05 | optician | 1 | 82945 | 2 | 1.453 | 57085.3 |
374 | 2025-01-09 00:23:20 | optician | 3 | 146162 | 39 | 51.800 | 2821.7 |
373 | 2025-01-08 13:22:36 | optician | 2 | 121059 | 6 | 22.800 | 5309.6 |
372 | 2025-01-06 17:40:25 | optician | 3 | 146162 | 39 | 11.660 | 12535.3 |
371 | 2025-01-05 11:55:22 | optician | 3 | 146162 | 39 | 38.033 | 3843.0 |
370 | 2025-01-04 03:05:09 | optician | 3 | 146162 | 39 | 46.126 | 3168.8 |
369 | 2025-01-04 03:05:11 | optician | 2 | 121059 | 6 | 27.093 | 4468.3 |
368 | 2025-01-04 03:04:39 | optician | 1 | 82945 | 2 | 5.470 | 15163.6 |
367 | 2025-01-02 22:19:28 | optician | 4 | 161609 | 289 | 71.543 | 2258.9 |
366 | 2025-01-02 11:16:09 | optician | 4 | 161609 | 289 | 59.393 | 2721.0 |
365 | 2025-01-02 06:04:39 | optician | 4 | 161609 | 289 | 61.470 | 2629.1 |
364 | 2025-01-02 03:24:27 | optician | 4 | 161609 | 289 | 71.163 | 2271.0 |
363 | 2024-12-20 04:57:33 | optician | 2 | 121059 | 6 | 23.953 | 5054.0 |
362 | 2024-12-12 16:49:02 | optician | 4 | 161609 | 289 | 63.673 | 2538.1 |
361 | 2024-12-12 02:37:35 | optician | 1 | 82945 | 2 | 6.516 | 12729.4 |
360 | 2024-12-07 10:07:13 | optician | 3 | 146162 | 39 | 7.953 | 18378.2 |
359 | 2024-12-06 00:26:04 | optician | 3 | 146162 | 39 | 21.876 | 6681.4 |
358 | 2024-12-05 03:21:37 | optician | 3 | 146162 | 39 | 42.236 | 3460.6 |
357 | 2024-12-04 15:38:00 | optician | 3 | 146162 | 39 | 6.753 | 21644.0 |
356 | 2024-12-04 15:38:01 | optician | 2 | 121059 | 6 | 3.580 | 33815.4 |
355 | 2024-12-04 15:37:57 | optician | 1 | 82945 | 2 | 1.343 | 61761.0 |
354 | 2024-12-02 11:06:50 | optician | 4 | 161609 | 289 | 12.420 | 13012.0 |
353 | 2024-12-02 05:36:28 | optician | 4 | 161609 | 289 | 54.580 | 2961.0 |
352 | 2024-11-30 10:00:53 | optician | 4 | 161609 | 289 | 36.156 | 4469.8 |
351 | 2024-11-30 08:51:12 | optician | 4 | 161609 | 289 | 63.523 | 2544.1 |
350 | 2024-11-20 01:15:23 | optician | 4 | 161609 | 289 | 45.003 | 3591.1 |
349 | 2024-11-08 20:40:21 | optician | 1 | 82945 | 2 | 7.983 | 10390.2 |
348 | 2024-11-04 02:02:50 | optician | 1 | 82945 | 2 | 9.940 | 8344.6 |
347 | 2024-11-03 03:57:21 | optician | 2 | 121059 | 6 | 9.250 | 13087.5 |
346 | 2024-11-02 14:08:28 | optician | 1 | 82945 | 2 | 4.733 | 17524.8 |
345 | 2024-10-30 21:27:43 | optician | 4 | 161609 | 289 | 59.643 | 2709.6 |
344 | 2024-10-30 15:02:34 | optician | 2 | 121059 | 6 | 3.873 | 31257.2 |
343 | 2024-10-29 20:57:41 | optician | 4 | 161609 | 289 | 59.973 | 2694.7 |
342 | 2024-10-29 09:31:45 | optician | 4 | 161609 | 289 | 52.016 | 3106.9 |
341 | 2024-10-29 08:03:08 | optician | 4 | 161609 | 289 | 55.283 | 2923.3 |
340 | 2024-10-29 08:03:31 | optician | 2 | 121059 | 6 | 16.500 | 7336.9 |
339 | 2024-10-29 08:02:53 | optician | 1 | 82945 | 2 | 7.750 | 10702.6 |
338 | 2024-10-24 12:32:22 | optician | 3 | 146162 | 39 | 12.126 | 12053.6 |
337 | 2024-10-21 10:18:08 | optician | 3 | 146162 | 39 | 21.876 | 6681.4 |
336 | 2024-10-14 18:43:20 | optician | 3 | 146162 | 39 | 22.393 | 6527.1 |