History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spiff"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
436 | 2024-04-27 19:46:26 | spiff | 1 | 28756 | 7 | 0.533 | 53951.2 |
435 | 2024-04-06 00:32:51 | spiff | 1 | 28756 | 7 | 0.516 | 55728.7 |
434 | 2024-03-31 16:35:46 | spiff | 1 | 28756 | 7 | 1.050 | 27386.7 |
433 | 2024-03-28 20:28:19 | spiff | 1 | 28756 | 7 | 0.533 | 53951.2 |
432 | 2024-03-06 22:21:07 | spiff | 2 | 53800 | 69 | 4.686 | 11481.0 |
431 | 2024-03-06 21:23:57 | spiff | 3 | 83667 | 666 | 11.500 | 7275.4 |
430 | 2024-03-06 20:54:07 | spiff | 1 | 28756 | 7 | 1.126 | 25538.2 |
429 | 2024-03-05 21:47:03 | spiff | 3 | 83667 | 666 | 7.440 | 11245.6 |
428 | 2024-03-05 21:47:04 | spiff | 2 | 53800 | 69 | 3.516 | 15301.5 |
427 | 2024-03-01 12:52:55 | spiff | 1 | 28756 | 7 | 0.456 | 63061.4 |
426 | 2024-02-28 11:42:56 | spiff | 2 | 53800 | 69 | 1.733 | 31044.4 |
425 | 2024-02-28 11:42:32 | spiff | 3 | 83667 | 666 | 5.470 | 15295.6 |
424 | 2024-02-27 09:37:39 | spiff | 2 | 53800 | 69 | 1.610 | 33416.1 |
423 | 2024-02-27 09:36:50 | spiff | 3 | 83667 | 666 | 5.093 | 16427.8 |
422 | 2024-02-27 00:40:06 | spiff | 1 | 28756 | 7 | 0.513 | 56054.6 |
421 | 2024-02-25 19:20:41 | spiff | 3 | 83667 | 666 | 3.703 | 22594.4 |
420 | 2024-02-25 19:20:42 | spiff | 2 | 53800 | 69 | 1.733 | 31044.4 |
419 | 2024-02-25 19:20:35 | spiff | 1 | 28756 | 7 | 0.486 | 59168.7 |
418 | 2024-02-03 17:30:43 | spiff | 1 | 28756 | 7 | 0.516 | 55728.7 |
417 | 2024-01-29 02:49:39 | spiff | 1 | 28756 | 7 | 0.483 | 59536.2 |
416 | 2024-01-26 04:49:33 | spiff | 1 | 28756 | 7 | 0.483 | 59536.2 |
415 | 2024-01-21 02:22:01 | spiff | 3 | 83667 | 666 | 3.453 | 24230.2 |
414 | 2024-01-20 18:14:03 | spiff | 3 | 83667 | 666 | 3.750 | 22311.2 |
413 | 2024-01-07 14:16:33 | spiff | 3 | 83667 | 666 | 3.420 | 24464.0 |
412 | 2024-01-07 14:16:32 | spiff | 2 | 53800 | 69 | 1.440 | 37361.1 |
411 | 2024-01-02 06:04:50 | spiff | 2 | 53800 | 69 | 1.623 | 33148.5 |
410 | 2024-01-02 06:04:42 | spiff | 3 | 83667 | 666 | 3.970 | 21074.8 |
409 | 2023-12-06 13:01:37 | spiff | 1 | 28756 | 7 | 0.440 | 65354.5 |
408 | 2023-11-18 20:52:30 | spiff | 3 | 83667 | 666 | 3.470 | 24111.5 |
407 | 2023-11-18 20:52:32 | spiff | 2 | 53800 | 69 | 1.513 | 35558.5 |
406 | 2023-11-17 08:46:38 | spiff | 3 | 83667 | 666 | 3.423 | 24442.6 |
405 | 2023-11-17 08:46:34 | spiff | 2 | 53800 | 69 | 1.546 | 34799.5 |
404 | 2023-11-15 04:46:35 | spiff | 1 | 28756 | 7 | 0.470 | 61183.0 |
403 | 2023-11-14 20:28:25 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
402 | 2023-10-26 22:52:43 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
401 | 2023-10-21 15:44:01 | spiff | 3 | 83667 | 666 | 3.483 | 24021.5 |
400 | 2023-10-21 15:43:53 | spiff | 2 | 53800 | 69 | 1.390 | 38705.0 |
399 | 2023-10-21 13:43:50 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
398 | 2023-10-16 23:59:16 | spiff | 1 | 28756 | 7 | 0.513 | 56054.6 |
397 | 2023-10-13 11:03:08 | spiff | 1 | 28756 | 7 | 0.440 | 65354.5 |
396 | 2023-10-06 02:58:20 | spiff | 1 | 28756 | 7 | 0.440 | 65354.5 |
395 | 2023-09-29 12:53:27 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
394 | 2023-09-26 07:51:59 | spiff | 1 | 28756 | 7 | 0.563 | 51076.4 |
393 | 2023-09-26 03:59:21 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
392 | 2023-09-20 22:53:47 | spiff | 1 | 28756 | 7 | 1.013 | 28387.0 |
391 | 2023-07-23 10:17:31 | spiff | 1 | 28756 | 7 | 0.530 | 54256.6 |
390 | 2023-07-14 13:42:37 | spiff | 1 | 28756 | 7 | 0.470 | 61183.0 |
389 | 2023-05-23 18:48:03 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
388 | 2023-04-16 02:39:21 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
387 | 2023-02-06 07:24:16 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
386 | 2023-01-20 07:29:59 | spiff | 1 | 28756 | 7 | 0.483 | 59536.2 |
385 | 2022-12-04 22:52:28 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
384 | 2022-09-10 22:17:35 | spiff | 1 | 28756 | 7 | 0.606 | 47452.1 |
383 | 2022-07-31 03:46:47 | spiff | 1 | 28756 | 7 | 0.470 | 61183.0 |
382 | 2022-05-01 14:19:44 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
381 | 2022-03-27 17:41:34 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
380 | 2022-01-04 16:55:26 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
379 | 2022-01-02 15:04:40 | spiff | 1 | 28756 | 7 | 0.466 | 61708.2 |
378 | 2021-11-03 01:14:12 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
377 | 2021-10-07 09:08:03 | spiff | 1 | 28756 | 7 | 0.483 | 59536.2 |
376 | 2021-09-26 08:20:33 | spiff | 2 | 53800 | 69 | 1.376 | 39098.8 |
375 | 2021-09-25 12:33:14 | spiff | 2 | 53800 | 69 | 3.076 | 17490.2 |
374 | 2021-09-19 20:29:37 | spiff | 2 | 53800 | 69 | 1.376 | 39098.8 |
373 | 2021-09-19 00:09:19 | spiff | 1 | 28756 | 7 | 0.470 | 61183.0 |
372 | 2021-07-28 11:46:38 | spiff | 1 | 28756 | 7 | 0.486 | 59168.7 |
371 | 2021-06-15 21:22:50 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
370 | 2021-05-19 19:24:57 | spiff | 1 | 28756 | 7 | 1.046 | 27491.4 |
369 | 2021-04-19 19:20:41 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
368 | 2021-03-22 15:38:10 | spiff | 1 | 28756 | 7 | 0.513 | 56054.6 |
367 | 2021-03-12 23:24:29 | spiff | 1 | 28756 | 7 | 0.470 | 61183.0 |
366 | 2021-02-25 02:39:29 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
365 | 2021-02-01 03:08:54 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
364 | 2021-01-11 09:11:19 | spiff | 3 | 83667 | 666 | 3.326 | 25155.4 |
363 | 2021-01-04 13:12:54 | spiff | 1 | 28756 | 7 | 0.486 | 59168.7 |
362 | 2020-12-05 20:56:28 | spiff | 1 | 28756 | 7 | 0.436 | 65954.1 |
361 | 2020-11-11 02:44:48 | spiff | 2 | 53800 | 69 | 1.373 | 39184.3 |
360 | 2020-11-04 21:05:13 | spiff | 2 | 53800 | 69 | 1.576 | 34137.1 |
359 | 2020-11-04 19:22:47 | spiff | 3 | 83667 | 666 | 3.406 | 24564.6 |
358 | 2020-10-23 18:45:08 | spiff | 3 | 83667 | 666 | 3.296 | 25384.4 |
357 | 2020-10-08 01:38:43 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
356 | 2020-09-16 00:37:45 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
355 | 2020-09-04 05:56:24 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
354 | 2020-09-03 14:59:05 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
353 | 2020-08-21 07:38:24 | spiff | 1 | 28756 | 7 | 0.530 | 54256.6 |
352 | 2020-07-26 19:23:06 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
351 | 2020-07-19 23:01:04 | spiff | 1 | 28756 | 7 | 0.516 | 55728.7 |
350 | 2020-07-18 06:57:23 | spiff | 1 | 28756 | 7 | 0.470 | 61183.0 |
349 | 2020-05-30 07:43:45 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
348 | 2020-05-10 19:09:43 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
347 | 2020-03-26 06:47:15 | spiff | 1 | 28756 | 7 | 0.530 | 54256.6 |
346 | 2020-03-24 18:45:45 | spiff | 1 | 28756 | 7 | 0.516 | 55728.7 |
345 | 2020-03-23 01:18:41 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
344 | 2020-03-22 09:07:47 | spiff | 1 | 28756 | 7 | 0.500 | 57512.0 |
343 | 2020-03-21 04:40:18 | spiff | 1 | 28756 | 7 | 0.550 | 52283.6 |
342 | 2020-03-18 14:37:29 | spiff | 1 | 28756 | 7 | 0.486 | 59168.7 |
341 | 2020-03-06 14:19:29 | spiff | 1 | 28756 | 7 | 0.453 | 63479.0 |
340 | 2020-03-01 02:59:28 | spiff | 1 | 28756 | 7 | 0.530 | 54256.6 |
339 | 2020-02-25 20:13:26 | spiff | 1 | 28756 | 7 | 0.513 | 56054.6 |
338 | 2020-02-25 02:49:08 | spiff | 1 | 28756 | 7 | 1.093 | 26309.2 |
337 | 2020-02-23 15:48:27 | spiff | 1 | 28756 | 7 | 1.096 | 26237.2 |