History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detained"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
430 | 2024-04-02 07:47:44 | detained | 2 | 121059 | 37 | 4.393 | 27557.3 |
429 | 2024-04-02 07:47:04 | detained | 3 | 146162 | 299 | 8.266 | 17682.3 |
428 | 2024-03-31 18:55:47 | detained | 2 | 121059 | 37 | 3.986 | 30371.0 |
427 | 2024-03-31 18:55:41 | detained | 1 | 82945 | 7 | 1.406 | 58993.6 |
426 | 2024-03-31 18:55:25 | detained | 2 | 121059 | 37 | 7.780 | 15560.3 |
425 | 2024-03-30 21:37:33 | detained | 3 | 146162 | 299 | 16.233 | 9004.0 |
424 | 2024-03-30 18:03:44 | detained | 2 | 121059 | 37 | 14.923 | 8112.2 |
423 | 2024-03-30 17:46:49 | detained | 3 | 146162 | 299 | 10.406 | 14045.9 |
422 | 2024-03-30 08:36:25 | detained | 3 | 146162 | 299 | 19.250 | 7592.8 |
421 | 2024-03-30 08:36:24 | detained | 2 | 121059 | 37 | 5.203 | 23267.2 |
420 | 2024-03-30 08:23:16 | detained | 1 | 82945 | 7 | 1.623 | 51106.0 |
419 | 2024-03-11 11:14:08 | detained | 1 | 82945 | 7 | 1.626 | 51011.7 |
418 | 2024-02-28 03:51:50 | detained | 1 | 82945 | 7 | 1.780 | 46598.3 |
417 | 2024-02-03 22:02:11 | detained | 3 | 146162 | 299 | 7.376 | 19815.9 |
416 | 2024-01-30 10:46:25 | detained | 2 | 121059 | 37 | 3.860 | 31362.4 |
415 | 2024-01-30 10:45:25 | detained | 3 | 146162 | 299 | 7.593 | 19249.6 |
414 | 2024-01-29 19:44:43 | detained | 3 | 146162 | 299 | 9.936 | 14710.3 |
413 | 2024-01-23 01:59:43 | detained | 3 | 146162 | 299 | 12.093 | 12086.5 |
412 | 2024-01-15 02:14:56 | detained | 3 | 146162 | 299 | 10.033 | 14568.1 |
411 | 2024-01-15 02:14:54 | detained | 2 | 121059 | 37 | 6.220 | 19462.9 |
410 | 2024-01-01 00:58:50 | detained | 2 | 121059 | 37 | 3.233 | 37444.8 |
409 | 2023-12-20 07:29:08 | detained | 1 | 82945 | 7 | 1.436 | 57761.1 |
408 | 2023-12-15 12:49:04 | detained | 3 | 146162 | 299 | 8.326 | 17554.9 |
407 | 2023-12-15 12:49:06 | detained | 2 | 121059 | 37 | 4.750 | 25486.1 |
406 | 2023-12-12 15:02:42 | detained | 1 | 82945 | 7 | 1.343 | 61761.0 |
405 | 2023-12-11 22:50:27 | detained | 1 | 82945 | 7 | 1.436 | 57761.1 |
404 | 2023-12-03 23:42:15 | detained | 3 | 146162 | 299 | 7.643 | 19123.6 |
403 | 2023-12-03 23:42:03 | detained | 2 | 121059 | 37 | 3.516 | 34430.9 |
402 | 2023-11-25 07:35:16 | detained | 1 | 82945 | 7 | 1.263 | 65673.0 |
401 | 2023-11-18 04:27:41 | detained | 1 | 82945 | 7 | 1.483 | 55930.5 |
400 | 2023-11-11 07:55:42 | detained | 1 | 82945 | 7 | 1.486 | 55817.6 |
399 | 2023-10-23 06:38:21 | detained | 1 | 82945 | 7 | 1.546 | 53651.4 |
398 | 2023-10-22 07:46:40 | detained | 1 | 82945 | 7 | 1.360 | 60989.0 |
397 | 2023-10-18 17:51:04 | detained | 1 | 82945 | 7 | 1.513 | 54821.5 |
396 | 2023-10-17 03:44:51 | detained | 1 | 82945 | 7 | 1.453 | 57085.3 |
395 | 2023-10-05 10:21:56 | detained | 2 | 121059 | 37 | 3.283 | 36874.5 |
394 | 2023-09-30 04:27:30 | detained | 1 | 82945 | 7 | 1.296 | 64000.8 |
393 | 2023-09-26 12:55:39 | detained | 1 | 82945 | 7 | 1.313 | 63172.1 |
392 | 2023-09-17 08:35:58 | detained | 1 | 82945 | 7 | 1.343 | 61761.0 |
391 | 2023-09-16 23:53:21 | detained | 1 | 82945 | 7 | 1.436 | 57761.1 |
390 | 2023-09-14 18:44:57 | detained | 1 | 82945 | 7 | 1.470 | 56425.2 |
389 | 2023-08-31 04:22:39 | detained | 1 | 82945 | 7 | 1.360 | 60989.0 |
388 | 2023-07-27 05:15:31 | detained | 1 | 82945 | 7 | 1.280 | 64800.8 |
387 | 2023-07-17 20:54:24 | detained | 2 | 121059 | 37 | 3.423 | 35366.3 |
386 | 2023-05-18 05:27:51 | detained | 1 | 82945 | 7 | 1.250 | 66356.0 |
385 | 2023-05-17 15:57:28 | detained | 1 | 82945 | 7 | 1.263 | 65673.0 |
384 | 2023-04-24 13:52:38 | detained | 1 | 82945 | 7 | 1.250 | 66356.0 |
383 | 2023-04-01 04:26:46 | detained | 2 | 121059 | 37 | 3.326 | 36397.8 |
382 | 2023-02-13 00:38:29 | detained | 1 | 82945 | 7 | 1.250 | 66356.0 |
381 | 2023-01-31 19:57:44 | detained | 1 | 82945 | 7 | 1.280 | 64800.8 |
380 | 2022-12-30 01:06:44 | detained | 2 | 121059 | 37 | 3.610 | 33534.3 |
379 | 2022-12-10 02:42:52 | detained | 1 | 82945 | 7 | 1.423 | 58288.8 |
378 | 2022-10-14 01:42:57 | detained | 1 | 82945 | 7 | 1.263 | 65673.0 |
377 | 2022-09-01 15:36:00 | detained | 2 | 121059 | 37 | 3.203 | 37795.5 |
376 | 2022-08-13 03:04:43 | detained | 1 | 82945 | 7 | 1.266 | 65517.4 |
375 | 2022-07-01 10:14:34 | detained | 1 | 82945 | 7 | 1.283 | 64649.3 |
374 | 2022-04-12 17:32:44 | detained | 2 | 121059 | 37 | 4.030 | 30039.5 |
373 | 2022-04-02 02:59:43 | detained | 1 | 82945 | 7 | 1.280 | 64800.8 |
372 | 2022-03-11 02:15:32 | detained | 1 | 82945 | 7 | 1.423 | 58288.8 |
371 | 2022-01-03 18:48:04 | detained | 1 | 82945 | 7 | 1.406 | 58993.6 |
370 | 2021-11-27 07:53:10 | detained | 1 | 82945 | 7 | 1.280 | 64800.8 |
369 | 2021-11-06 05:16:06 | detained | 1 | 82945 | 7 | 1.470 | 56425.2 |
368 | 2021-09-25 20:08:42 | detained | 1 | 82945 | 7 | 1.296 | 64000.8 |
367 | 2021-09-08 15:43:29 | detained | 1 | 82945 | 7 | 1.406 | 58993.6 |
366 | 2021-08-21 01:13:53 | detained | 1 | 82945 | 7 | 1.453 | 57085.3 |
365 | 2021-08-17 17:44:34 | detained | 1 | 82945 | 7 | 1.436 | 57761.1 |
364 | 2021-05-24 10:39:21 | detained | 1 | 82945 | 7 | 1.470 | 56425.2 |
363 | 2021-05-17 03:11:23 | detained | 1 | 82945 | 7 | 1.360 | 60989.0 |
362 | 2021-05-02 21:36:56 | detained | 1 | 82945 | 7 | 1.486 | 55817.6 |
361 | 2021-04-27 13:35:00 | detained | 1 | 82945 | 7 | 2.003 | 41410.4 |
360 | 2021-03-27 15:55:34 | detained | 1 | 82945 | 7 | 1.296 | 64000.8 |
359 | 2021-02-10 04:21:13 | detained | 1 | 82945 | 7 | 1.343 | 61761.0 |
358 | 2021-01-10 22:39:47 | detained | 1 | 82945 | 7 | 1.280 | 64800.8 |
357 | 2020-11-20 00:58:10 | detained | 1 | 82945 | 7 | 1.280 | 64800.8 |
356 | 2020-11-08 15:42:54 | detained | 1 | 82945 | 7 | 1.343 | 61761.0 |
355 | 2020-11-08 14:16:17 | detained | 1 | 82945 | 7 | 1.356 | 61168.9 |
354 | 2020-10-18 01:40:07 | detained | 1 | 82945 | 7 | 1.406 | 58993.6 |
353 | 2020-09-29 04:10:43 | detained | 1 | 82945 | 7 | 1.373 | 60411.5 |
352 | 2020-08-31 20:07:01 | detained | 1 | 82945 | 7 | 1.296 | 64000.8 |
351 | 2020-08-06 13:38:58 | detained | 1 | 82945 | 7 | 1.296 | 64000.8 |
350 | 2020-07-24 21:32:59 | detained | 1 | 82945 | 7 | 1.453 | 57085.3 |
349 | 2020-07-21 16:18:24 | detained | 1 | 82945 | 7 | 1.360 | 60989.0 |
348 | 2020-05-05 03:41:02 | detained | 1 | 82945 | 7 | 1.436 | 57761.1 |
347 | 2020-04-18 15:38:38 | detained | 1 | 82945 | 7 | 1.440 | 57600.7 |
346 | 2020-03-25 18:27:58 | detained | 1 | 82945 | 7 | 1.513 | 54821.5 |
345 | 2020-03-21 14:49:02 | detained | 1 | 82945 | 7 | 1.390 | 59672.7 |
344 | 2020-03-01 00:52:18 | detained | 1 | 82945 | 7 | 1.423 | 58288.8 |
343 | 2020-02-20 06:59:18 | detained | 1 | 82945 | 7 | 3.280 | 25288.1 |
342 | 2020-02-10 04:33:59 | detained | 1 | 82945 | 7 | 3.220 | 25759.3 |
341 | 2020-02-09 00:14:34 | detained | 1 | 82945 | 7 | 3.206 | 25871.8 |
340 | 2020-02-06 01:28:49 | detained | 1 | 82945 | 7 | 1.456 | 56967.7 |
339 | 2020-02-05 13:02:42 | detained | 1 | 82945 | 7 | 1.610 | 51518.6 |
338 | 2020-02-05 04:01:11 | detained | 1 | 82945 | 7 | 4.970 | 16689.1 |
337 | 2020-02-02 21:15:02 | detained | 1 | 82945 | 7 | 1.610 | 51518.6 |
336 | 2020-01-30 21:38:48 | detained | 1 | 82945 | 7 | 3.390 | 24467.6 |
335 | 2020-01-25 16:39:18 | detained | 1 | 82945 | 7 | 3.280 | 25288.1 |
334 | 2020-01-17 22:17:38 | detained | 1 | 82945 | 7 | 2.140 | 38759.3 |
333 | 2020-01-17 12:35:35 | detained | 1 | 82945 | 7 | 1.546 | 53651.4 |
332 | 2020-01-14 06:48:09 | detained | 1 | 82945 | 7 | 3.170 | 26165.6 |
331 | 2020-01-09 00:50:59 | detained | 1 | 82945 | 7 | 1.530 | 54212.4 |