History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"complains"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
442 | 2024-04-20 07:30:19 | complains | 1 | 81242 | 5 | 1.283 | 63321.9 |
441 | 2024-04-13 14:20:35 | complains | 1 | 81242 | 5 | 1.593 | 50999.4 |
440 | 2024-04-06 09:31:13 | complains | 1 | 81242 | 5 | 3.263 | 24897.9 |
439 | 2024-04-05 20:46:46 | complains | 1 | 81242 | 5 | 3.576 | 22718.7 |
438 | 2024-04-05 00:30:34 | complains | 4 | 165329 | 573 | 17.250 | 9584.3 |
437 | 2024-04-01 20:31:59 | complains | 4 | 165329 | 573 | 45.050 | 3669.9 |
436 | 2024-04-01 20:31:52 | complains | 3 | 148641 | 81 | 8.936 | 16634.0 |
435 | 2024-04-01 00:09:34 | complains | 1 | 81242 | 5 | 1.623 | 50056.7 |
434 | 2024-03-30 05:51:22 | complains | 4 | 165329 | 573 | 32.626 | 5067.4 |
433 | 2024-03-30 02:15:05 | complains | 1 | 81242 | 5 | 1.733 | 46879.4 |
432 | 2024-03-29 22:58:23 | complains | 4 | 165329 | 573 | 44.223 | 3738.5 |
431 | 2024-03-29 22:58:26 | complains | 3 | 148641 | 81 | 21.673 | 6858.3 |
430 | 2024-03-29 22:58:23 | complains | 2 | 121436 | 15 | 8.533 | 14231.3 |
429 | 2024-03-29 22:06:29 | complains | 1 | 81242 | 5 | 2.360 | 34424.6 |
428 | 2024-03-29 02:07:17 | complains | 1 | 81242 | 5 | 1.453 | 55913.3 |
427 | 2024-03-08 22:05:13 | complains | 1 | 81242 | 5 | 1.546 | 52549.8 |
426 | 2024-03-07 02:30:33 | complains | 1 | 81242 | 5 | 1.423 | 57092.1 |
425 | 2024-02-28 00:38:38 | complains | 1 | 81242 | 5 | 1.343 | 60492.9 |
424 | 2024-02-26 04:24:48 | complains | 1 | 81242 | 5 | 3.140 | 25873.2 |
423 | 2024-02-07 18:37:52 | complains | 3 | 148641 | 81 | 26.393 | 5631.8 |
422 | 2024-01-30 02:48:58 | complains | 1 | 81242 | 5 | 1.453 | 55913.3 |
421 | 2024-01-29 13:42:31 | complains | 1 | 81242 | 5 | 2.953 | 27511.7 |
420 | 2024-01-29 03:26:17 | complains | 3 | 148641 | 81 | 6.283 | 23657.6 |
419 | 2024-01-28 14:13:15 | complains | 1 | 81242 | 5 | 1.296 | 62686.7 |
418 | 2023-12-22 08:56:12 | complains | 1 | 81242 | 5 | 1.266 | 64172.2 |
417 | 2023-12-16 13:20:01 | complains | 2 | 121436 | 15 | 3.343 | 36325.5 |
416 | 2023-12-12 10:41:47 | complains | 4 | 165329 | 573 | 12.203 | 13548.2 |
415 | 2023-12-12 10:41:41 | complains | 3 | 148641 | 81 | 7.563 | 19653.7 |
414 | 2023-12-12 10:41:43 | complains | 2 | 121436 | 15 | 3.783 | 32100.4 |
413 | 2023-12-05 19:48:01 | complains | 4 | 165329 | 573 | 10.750 | 15379.4 |
412 | 2023-12-03 18:38:30 | complains | 4 | 165329 | 573 | 14.373 | 11502.7 |
411 | 2023-12-03 18:38:30 | complains | 3 | 148641 | 81 | 12.406 | 11981.4 |
410 | 2023-12-03 18:38:25 | complains | 2 | 121436 | 15 | 4.190 | 28982.3 |
409 | 2023-11-26 20:18:36 | complains | 4 | 165329 | 573 | 12.576 | 13146.4 |
408 | 2023-11-26 20:18:40 | complains | 2 | 121436 | 15 | 3.843 | 31599.3 |
407 | 2023-11-26 20:18:32 | complains | 3 | 148641 | 81 | 6.830 | 21763.0 |
406 | 2023-11-11 03:29:16 | complains | 1 | 81242 | 5 | 1.233 | 65889.7 |
405 | 2023-11-10 02:03:09 | complains | 1 | 81242 | 5 | 1.453 | 55913.3 |
404 | 2023-11-07 07:57:40 | complains | 1 | 81242 | 5 | 1.390 | 58447.5 |
403 | 2023-10-29 05:54:07 | complains | 1 | 81242 | 5 | 1.326 | 61268.5 |
402 | 2023-10-27 23:57:30 | complains | 1 | 81242 | 5 | 1.263 | 64324.6 |
401 | 2023-10-20 04:10:41 | complains | 1 | 81242 | 5 | 1.346 | 60358.1 |
400 | 2023-10-18 01:06:13 | complains | 1 | 81242 | 5 | 1.346 | 60358.1 |
399 | 2023-10-14 04:08:16 | complains | 1 | 81242 | 5 | 1.436 | 56575.2 |
398 | 2023-10-10 10:23:15 | complains | 1 | 81242 | 5 | 1.390 | 58447.5 |
397 | 2023-10-04 05:48:44 | complains | 1 | 81242 | 5 | 1.310 | 62016.8 |
396 | 2023-09-23 12:29:50 | complains | 1 | 81242 | 5 | 1.263 | 64324.6 |
395 | 2023-09-23 12:24:46 | complains | 4 | 165329 | 573 | 23.360 | 7077.4 |
394 | 2023-09-16 21:08:19 | complains | 4 | 165329 | 573 | 24.830 | 6658.4 |
393 | 2023-09-15 05:32:00 | complains | 4 | 165329 | 573 | 13.220 | 12506.0 |
392 | 2023-09-13 20:33:05 | complains | 2 | 121436 | 15 | 3.576 | 33958.6 |
391 | 2023-09-12 05:41:43 | complains | 1 | 81242 | 5 | 1.360 | 59736.8 |
390 | 2023-09-02 14:44:08 | complains | 4 | 165329 | 573 | 10.733 | 15403.8 |
389 | 2023-08-06 16:04:18 | complains | 1 | 81242 | 5 | 1.266 | 64172.2 |
388 | 2023-07-05 12:11:51 | complains | 1 | 81242 | 5 | 1.296 | 62686.7 |
387 | 2023-05-30 20:17:48 | complains | 2 | 121436 | 15 | 3.110 | 39046.9 |
386 | 2023-05-25 20:13:40 | complains | 4 | 165329 | 573 | 10.436 | 15842.2 |
385 | 2023-05-21 10:23:14 | complains | 4 | 165329 | 573 | 10.326 | 16010.9 |
384 | 2023-05-06 14:40:03 | complains | 1 | 81242 | 5 | 1.250 | 64993.6 |
383 | 2023-04-24 05:23:21 | complains | 1 | 81242 | 5 | 1.936 | 41963.8 |
382 | 2023-04-13 00:49:51 | complains | 4 | 165329 | 573 | 11.000 | 15029.9 |
381 | 2023-04-03 12:10:54 | complains | 4 | 165329 | 573 | 11.890 | 13904.9 |
380 | 2023-03-21 23:35:06 | complains | 1 | 81242 | 5 | 1.280 | 63470.3 |
379 | 2023-03-21 23:12:24 | complains | 4 | 165329 | 573 | 11.843 | 13960.1 |
378 | 2023-03-20 01:17:25 | complains | 1 | 81242 | 5 | 1.263 | 64324.6 |
377 | 2023-03-10 11:50:39 | complains | 2 | 121436 | 15 | 3.580 | 33920.7 |
376 | 2023-03-03 01:02:05 | complains | 1 | 81242 | 5 | 1.406 | 57782.4 |
375 | 2023-02-28 04:06:43 | complains | 1 | 81242 | 5 | 1.280 | 63470.3 |
374 | 2023-02-27 22:34:43 | complains | 4 | 165329 | 573 | 10.250 | 16129.7 |
373 | 2023-01-16 14:19:20 | complains | 4 | 165329 | 573 | 12.096 | 13668.1 |
372 | 2022-12-24 18:46:00 | complains | 1 | 81242 | 5 | 1.233 | 65889.7 |
371 | 2022-12-14 09:19:18 | complains | 2 | 121436 | 15 | 3.456 | 35137.7 |
370 | 2022-12-08 04:17:44 | complains | 4 | 165329 | 573 | 12.280 | 13463.3 |
369 | 2022-12-03 21:01:53 | complains | 1 | 81242 | 5 | 1.250 | 64993.6 |
368 | 2022-11-15 12:59:22 | complains | 4 | 165329 | 573 | 10.546 | 15676.9 |
367 | 2022-11-14 14:57:12 | complains | 4 | 165329 | 573 | 10.500 | 15745.6 |
366 | 2022-11-04 12:48:15 | complains | 4 | 165329 | 573 | 11.283 | 14652.9 |
365 | 2022-09-27 13:58:27 | complains | 4 | 165329 | 573 | 10.530 | 15700.8 |
364 | 2022-09-23 22:46:51 | complains | 4 | 165329 | 573 | 10.393 | 15907.7 |
363 | 2022-09-14 14:14:59 | complains | 1 | 81242 | 5 | 1.263 | 64324.6 |
362 | 2022-09-03 09:45:45 | complains | 4 | 165329 | 573 | 11.326 | 14597.3 |
361 | 2022-08-25 14:48:05 | complains | 1 | 81242 | 5 | 1.436 | 56575.2 |
360 | 2022-08-16 06:03:19 | complains | 4 | 165329 | 573 | 10.440 | 15836.1 |
359 | 2022-08-07 20:19:12 | complains | 4 | 165329 | 573 | 11.970 | 13811.9 |
358 | 2022-08-06 23:18:32 | complains | 1 | 81242 | 5 | 1.420 | 57212.7 |
357 | 2022-08-04 10:55:18 | complains | 2 | 121436 | 15 | 3.250 | 37364.9 |
356 | 2022-07-01 23:38:53 | complains | 1 | 81242 | 5 | 1.266 | 64172.2 |
355 | 2022-06-26 08:20:07 | complains | 1 | 81242 | 5 | 1.266 | 64172.2 |
354 | 2022-06-18 04:44:04 | complains | 4 | 165329 | 573 | 10.486 | 15766.6 |
353 | 2022-05-25 21:43:44 | complains | 1 | 81242 | 5 | 1.330 | 61084.2 |
352 | 2022-05-09 00:09:19 | complains | 4 | 165329 | 573 | 10.690 | 15465.8 |
351 | 2022-04-28 10:55:10 | complains | 4 | 165329 | 573 | 13.390 | 12347.2 |
350 | 2022-04-12 14:28:50 | complains | 4 | 165329 | 573 | 14.893 | 11101.1 |
349 | 2022-04-09 02:40:52 | complains | 1 | 81242 | 5 | 1.296 | 62686.7 |
348 | 2022-03-30 11:44:45 | complains | 4 | 165329 | 573 | 12.503 | 13223.1 |
347 | 2022-03-28 08:36:25 | complains | 4 | 165329 | 573 | 14.093 | 11731.3 |
346 | 2022-03-11 04:56:10 | complains | 1 | 81242 | 5 | 1.360 | 59736.8 |
345 | 2022-03-09 00:55:16 | complains | 1 | 81242 | 5 | 1.640 | 49537.8 |
344 | 2021-12-21 18:55:27 | complains | 1 | 81242 | 5 | 1.343 | 60492.9 |
343 | 2021-12-19 11:59:48 | complains | 1 | 81242 | 5 | 1.360 | 59736.8 |