History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"glass"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
450 | 2024-04-03 02:24:18 | glass | 1 | 28756 | 9 | 1.110 | 25906.3 |
449 | 2024-03-31 03:37:53 | glass | 1 | 28756 | 9 | 0.530 | 54256.6 |
448 | 2024-03-30 18:44:47 | glass | 1 | 28756 | 9 | 0.546 | 52666.7 |
447 | 2024-03-27 04:21:31 | glass | 1 | 28756 | 9 | 0.830 | 34645.8 |
446 | 2024-03-07 07:27:18 | glass | 1 | 28756 | 9 | 1.140 | 25224.6 |
445 | 2024-03-03 20:53:24 | glass | 1 | 28756 | 9 | 0.530 | 54256.6 |
444 | 2024-02-25 19:10:21 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
443 | 2024-02-21 02:39:24 | glass | 1 | 28756 | 9 | 0.576 | 49923.6 |
442 | 2024-01-29 02:13:52 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
441 | 2024-01-26 18:55:01 | glass | 1 | 28756 | 9 | 0.440 | 65354.5 |
440 | 2024-01-03 14:59:17 | glass | 2 | 53800 | 187 | 1.923 | 27977.1 |
439 | 2023-12-22 04:38:29 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
438 | 2023-12-20 19:28:38 | glass | 2 | 53800 | 187 | 1.360 | 39558.8 |
437 | 2023-12-07 21:16:21 | glass | 2 | 53800 | 187 | 1.686 | 31909.8 |
436 | 2023-12-04 18:56:12 | glass | 1 | 28756 | 9 | 0.486 | 59168.7 |
435 | 2023-12-04 18:56:11 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
434 | 2023-11-27 23:06:01 | glass | 2 | 53800 | 187 | 1.606 | 33499.4 |
433 | 2023-11-13 18:56:56 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
432 | 2023-11-12 07:53:12 | glass | 1 | 28756 | 9 | 0.470 | 61183.0 |
431 | 2023-11-07 16:49:43 | glass | 1 | 28756 | 9 | 0.486 | 59168.7 |
430 | 2023-10-28 06:56:23 | glass | 1 | 28756 | 9 | 1.030 | 27918.4 |
429 | 2023-10-21 23:49:52 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
428 | 2023-10-18 15:48:34 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
427 | 2023-10-11 03:15:05 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
426 | 2023-10-10 10:51:46 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
425 | 2023-10-07 10:37:14 | glass | 1 | 28756 | 9 | 0.576 | 49923.6 |
424 | 2023-09-27 18:50:17 | glass | 1 | 28756 | 9 | 0.486 | 59168.7 |
423 | 2023-09-13 17:22:00 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
422 | 2023-09-09 23:43:25 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
421 | 2023-08-09 21:00:03 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
420 | 2023-08-06 22:10:30 | glass | 1 | 28756 | 9 | 0.420 | 68466.7 |
419 | 2023-07-24 03:04:23 | glass | 1 | 28756 | 9 | 0.423 | 67981.1 |
418 | 2023-07-11 15:59:03 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
417 | 2023-05-03 10:37:31 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
416 | 2023-04-12 08:51:18 | glass | 1 | 28756 | 9 | 0.470 | 61183.0 |
415 | 2023-03-31 15:01:21 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
414 | 2023-02-27 10:50:30 | glass | 1 | 28756 | 9 | 0.470 | 61183.0 |
413 | 2023-01-07 07:12:32 | glass | 1 | 28756 | 9 | 0.470 | 61183.0 |
412 | 2022-12-25 17:00:32 | glass | 1 | 28756 | 9 | 0.423 | 67981.1 |
411 | 2022-09-23 12:33:43 | glass | 1 | 28756 | 9 | 0.423 | 67981.1 |
410 | 2022-09-13 08:46:26 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
409 | 2022-09-10 15:32:12 | glass | 1 | 28756 | 9 | 0.470 | 61183.0 |
408 | 2022-08-31 03:35:34 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
407 | 2022-08-26 04:40:53 | glass | 1 | 28756 | 9 | 0.420 | 68466.7 |
406 | 2022-08-17 15:30:13 | glass | 1 | 28756 | 9 | 0.420 | 68466.7 |
405 | 2022-07-14 23:10:49 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
404 | 2022-06-06 13:20:16 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
403 | 2022-03-17 02:07:42 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
402 | 2022-02-26 14:43:59 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
401 | 2021-12-25 03:49:53 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
400 | 2021-11-15 01:44:44 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
399 | 2021-10-25 22:18:26 | glass | 1 | 28756 | 9 | 0.486 | 59168.7 |
398 | 2021-09-09 17:16:12 | glass | 1 | 28756 | 9 | 0.420 | 68466.7 |
397 | 2021-08-25 06:12:29 | glass | 1 | 28756 | 9 | 0.420 | 68466.7 |
396 | 2021-08-15 13:10:22 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
395 | 2021-08-12 13:22:58 | glass | 1 | 28756 | 9 | 0.440 | 65354.5 |
394 | 2021-07-25 05:51:15 | glass | 1 | 28756 | 9 | 0.466 | 61708.2 |
393 | 2021-05-15 12:05:13 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
392 | 2021-05-14 21:26:30 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
391 | 2021-03-17 18:35:15 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
390 | 2021-02-12 00:20:30 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
389 | 2020-12-30 10:55:07 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
388 | 2020-11-21 05:16:03 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
387 | 2020-11-10 07:32:03 | glass | 1 | 28756 | 9 | 0.423 | 67981.1 |
386 | 2020-10-31 00:44:30 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
385 | 2020-10-28 23:49:33 | glass | 1 | 28756 | 9 | 0.440 | 65354.5 |
384 | 2020-10-27 06:50:48 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
383 | 2020-10-26 11:40:40 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
382 | 2020-10-16 03:44:20 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
381 | 2020-10-09 17:40:18 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
380 | 2020-09-22 12:44:27 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
379 | 2020-08-14 14:18:08 | glass | 1 | 28756 | 9 | 0.470 | 61183.0 |
378 | 2020-08-10 13:06:53 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
377 | 2020-06-13 01:18:40 | glass | 1 | 28756 | 9 | 0.533 | 53951.2 |
376 | 2020-06-12 01:08:33 | glass | 1 | 28756 | 9 | 0.436 | 65954.1 |
375 | 2020-05-09 07:52:53 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
374 | 2020-04-21 09:16:15 | glass | 1 | 28756 | 9 | 0.420 | 68466.7 |
373 | 2020-04-09 02:57:08 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
372 | 2020-04-01 23:23:38 | glass | 1 | 28756 | 9 | 0.453 | 63479.0 |
371 | 2020-03-25 04:56:37 | glass | 1 | 28756 | 9 | 0.513 | 56054.6 |
370 | 2020-03-24 23:34:02 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
369 | 2020-03-23 12:02:04 | glass | 1 | 28756 | 9 | 0.860 | 33437.2 |
368 | 2020-03-22 15:12:30 | glass | 1 | 28756 | 9 | 0.486 | 59168.7 |
367 | 2020-03-22 08:41:06 | glass | 1 | 28756 | 9 | 0.516 | 55728.7 |
366 | 2020-03-21 00:06:36 | glass | 1 | 28756 | 9 | 0.420 | 68466.7 |
365 | 2020-03-18 00:29:04 | glass | 1 | 28756 | 9 | 0.500 | 57512.0 |
364 | 2020-02-25 09:36:50 | glass | 1 | 28756 | 9 | 0.513 | 56054.6 |
363 | 2020-02-25 06:58:20 | glass | 1 | 28756 | 9 | 0.483 | 59536.2 |
362 | 2020-02-22 14:31:00 | glass | 1 | 28756 | 9 | 0.530 | 54256.6 |
361 | 2020-02-18 18:42:21 | glass | 1 | 28756 | 9 | 1.173 | 24514.9 |
360 | 2020-02-18 12:02:59 | glass | 1 | 28756 | 9 | 0.576 | 49923.6 |
359 | 2020-02-13 05:06:27 | glass | 1 | 28756 | 9 | 0.516 | 55728.7 |
358 | 2020-02-08 11:28:03 | glass | 1 | 28756 | 9 | 1.046 | 27491.4 |
357 | 2020-02-06 18:45:39 | glass | 1 | 28756 | 9 | 0.513 | 56054.6 |
356 | 2020-02-01 11:50:48 | glass | 1 | 28756 | 9 | 0.563 | 51076.4 |
355 | 2020-01-30 01:23:22 | glass | 1 | 28756 | 9 | 0.546 | 52666.7 |
354 | 2020-01-29 07:05:25 | glass | 1 | 28756 | 9 | 0.593 | 48492.4 |
353 | 2020-01-24 11:26:21 | glass | 1 | 28756 | 9 | 1.123 | 25606.4 |
352 | 2020-01-23 12:06:19 | glass | 1 | 28756 | 9 | 1.780 | 16155.1 |
351 | 2020-01-22 10:12:16 | glass | 1 | 28756 | 9 | 0.560 | 51350.0 |