History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"retiree"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
436 | 2024-03-03 10:49:04 | retiree | 2 | 107671 | 38 | 3.733 | 28843.0 |
435 | 2024-03-01 16:30:47 | retiree | 3 | 134027 | 361 | 8.546 | 15683.0 |
434 | 2024-02-29 00:53:44 | retiree | 2 | 107671 | 38 | 7.453 | 14446.7 |
433 | 2024-02-29 00:53:29 | retiree | 3 | 134027 | 361 | 7.203 | 18607.1 |
432 | 2024-02-28 08:19:44 | retiree | 3 | 134027 | 361 | 10.423 | 12858.8 |
431 | 2024-02-25 22:38:14 | retiree | 3 | 134027 | 361 | 9.876 | 13571.0 |
430 | 2024-02-25 22:38:17 | retiree | 2 | 107671 | 38 | 6.203 | 17357.9 |
429 | 2024-02-25 22:38:04 | retiree | 1 | 69583 | 6 | 3.296 | 21111.3 |
428 | 2024-02-17 23:12:19 | retiree | 1 | 69583 | 6 | 5.656 | 12302.5 |
427 | 2024-01-28 17:34:07 | retiree | 1 | 69583 | 6 | 1.280 | 54361.7 |
426 | 2023-12-22 09:52:24 | retiree | 2 | 107671 | 38 | 3.436 | 31336.1 |
425 | 2023-12-09 22:08:49 | retiree | 2 | 107671 | 38 | 4.860 | 22154.5 |
424 | 2023-12-01 19:42:17 | retiree | 3 | 134027 | 361 | 7.720 | 17361.0 |
423 | 2023-12-01 05:15:24 | retiree | 3 | 134027 | 361 | 7.623 | 17581.9 |
422 | 2023-12-01 05:15:20 | retiree | 2 | 107671 | 38 | 3.580 | 30075.7 |
421 | 2023-11-22 20:29:44 | retiree | 1 | 69583 | 6 | 1.126 | 61796.6 |
420 | 2023-11-22 13:10:28 | retiree | 3 | 134027 | 361 | 8.250 | 16245.7 |
419 | 2023-11-12 09:21:09 | retiree | 1 | 69583 | 6 | 1.076 | 64668.2 |
418 | 2023-11-10 23:42:07 | retiree | 1 | 69583 | 6 | 1.890 | 36816.4 |
417 | 2023-11-09 06:39:40 | retiree | 3 | 134027 | 361 | 6.783 | 19759.3 |
416 | 2023-11-09 06:39:16 | retiree | 2 | 107671 | 38 | 2.876 | 37437.8 |
415 | 2023-11-02 02:09:54 | retiree | 1 | 69583 | 6 | 1.156 | 60192.9 |
414 | 2023-10-27 17:58:43 | retiree | 1 | 69583 | 6 | 1.250 | 55666.4 |
413 | 2023-10-21 07:57:11 | retiree | 1 | 69583 | 6 | 1.250 | 55666.4 |
412 | 2023-10-18 00:13:07 | retiree | 1 | 69583 | 6 | 1.280 | 54361.7 |
411 | 2023-10-11 19:48:48 | retiree | 1 | 69583 | 6 | 1.376 | 50569.0 |
410 | 2023-10-04 19:08:43 | retiree | 1 | 69583 | 6 | 2.656 | 26198.4 |
409 | 2023-10-02 12:59:01 | retiree | 1 | 69583 | 6 | 1.216 | 57222.9 |
408 | 2023-09-26 12:33:31 | retiree | 1 | 69583 | 6 | 1.216 | 57222.9 |
407 | 2023-09-26 00:20:27 | retiree | 3 | 134027 | 361 | 6.500 | 20619.5 |
406 | 2023-09-26 00:20:26 | retiree | 2 | 107671 | 38 | 3.110 | 34620.9 |
405 | 2023-09-19 14:49:22 | retiree | 1 | 69583 | 6 | 1.233 | 56433.9 |
404 | 2023-09-10 00:11:28 | retiree | 1 | 69583 | 6 | 1.203 | 57841.2 |
403 | 2023-06-17 01:52:55 | retiree | 1 | 69583 | 6 | 1.080 | 64428.7 |
402 | 2023-05-30 04:32:28 | retiree | 1 | 69583 | 6 | 1.076 | 64668.2 |
401 | 2023-03-31 10:24:19 | retiree | 1 | 69583 | 6 | 1.173 | 59320.5 |
400 | 2023-02-07 00:11:42 | retiree | 1 | 69583 | 6 | 1.080 | 64428.7 |
399 | 2023-01-13 16:28:35 | retiree | 1 | 69583 | 6 | 1.200 | 57985.8 |
398 | 2022-10-28 20:27:55 | retiree | 1 | 69583 | 6 | 1.203 | 57841.2 |
397 | 2022-10-02 08:47:31 | retiree | 1 | 69583 | 6 | 1.110 | 62687.4 |
396 | 2022-06-17 18:19:21 | retiree | 1 | 69583 | 6 | 1.140 | 61037.7 |
395 | 2022-06-15 12:47:54 | retiree | 1 | 69583 | 6 | 1.106 | 62914.1 |
394 | 2022-06-01 08:09:29 | retiree | 1 | 69583 | 6 | 2.653 | 26228.0 |
393 | 2022-02-20 21:59:24 | retiree | 1 | 69583 | 6 | 1.126 | 61796.6 |
392 | 2022-01-31 07:58:02 | retiree | 1 | 69583 | 6 | 1.106 | 62914.1 |
391 | 2021-12-10 02:15:46 | retiree | 1 | 69583 | 6 | 1.250 | 55666.4 |
390 | 2021-10-19 10:07:37 | retiree | 1 | 69583 | 6 | 1.096 | 63488.1 |
389 | 2021-10-14 11:15:47 | retiree | 1 | 69583 | 6 | 1.096 | 63488.1 |
388 | 2021-10-11 04:45:36 | retiree | 1 | 69583 | 6 | 1.236 | 56296.9 |
387 | 2021-09-07 02:40:38 | retiree | 1 | 69583 | 6 | 1.076 | 64668.2 |
386 | 2021-09-04 21:59:22 | retiree | 1 | 69583 | 6 | 1.110 | 62687.4 |
385 | 2021-08-09 09:47:00 | retiree | 1 | 69583 | 6 | 1.190 | 58473.1 |
384 | 2021-07-09 14:52:33 | retiree | 1 | 69583 | 6 | 1.330 | 52318.0 |
383 | 2021-06-18 07:41:58 | retiree | 1 | 69583 | 6 | 1.266 | 54962.9 |
382 | 2021-04-05 18:30:13 | retiree | 1 | 69583 | 6 | 1.250 | 55666.4 |
381 | 2021-03-29 08:08:06 | retiree | 1 | 69583 | 6 | 1.233 | 56433.9 |
380 | 2021-02-23 13:37:26 | retiree | 1 | 69583 | 6 | 1.110 | 62687.4 |
379 | 2021-01-13 01:33:31 | retiree | 1 | 69583 | 6 | 1.106 | 62914.1 |
378 | 2020-12-28 00:31:26 | retiree | 1 | 69583 | 6 | 1.093 | 63662.4 |
377 | 2020-11-18 13:59:05 | retiree | 1 | 69583 | 6 | 1.343 | 51811.6 |
376 | 2020-10-25 05:30:29 | retiree | 1 | 69583 | 6 | 1.140 | 61037.7 |
375 | 2020-10-23 12:13:31 | retiree | 1 | 69583 | 6 | 1.216 | 57222.9 |
374 | 2020-09-24 10:06:03 | retiree | 1 | 69583 | 6 | 1.126 | 61796.6 |
373 | 2020-08-01 13:12:59 | retiree | 1 | 69583 | 6 | 1.296 | 53690.6 |
372 | 2020-07-29 06:41:20 | retiree | 1 | 69583 | 6 | 1.173 | 59320.5 |
371 | 2020-06-10 00:52:32 | retiree | 1 | 69583 | 6 | 1.153 | 60349.5 |
370 | 2020-03-31 14:00:50 | retiree | 1 | 69583 | 6 | 1.190 | 58473.1 |
369 | 2020-03-27 19:34:03 | retiree | 1 | 69583 | 6 | 1.250 | 55666.4 |
368 | 2020-03-25 23:46:51 | retiree | 1 | 69583 | 6 | 1.186 | 58670.3 |
367 | 2020-03-25 14:43:03 | retiree | 1 | 69583 | 6 | 1.420 | 49002.1 |
366 | 2020-03-23 21:52:18 | retiree | 1 | 69583 | 6 | 1.296 | 53690.6 |
365 | 2020-03-21 23:51:18 | retiree | 1 | 69583 | 6 | 1.330 | 52318.0 |
364 | 2020-03-19 20:27:31 | retiree | 1 | 69583 | 6 | 1.203 | 57841.2 |
363 | 2020-03-05 14:36:59 | retiree | 1 | 69583 | 6 | 1.266 | 54962.9 |
362 | 2020-02-28 22:02:34 | retiree | 1 | 69583 | 6 | 2.986 | 23303.1 |
361 | 2020-02-25 08:48:50 | retiree | 1 | 69583 | 6 | 2.360 | 29484.3 |
360 | 2020-02-06 14:24:28 | retiree | 1 | 69583 | 6 | 1.436 | 48456.1 |
359 | 2020-02-05 04:52:47 | retiree | 1 | 69583 | 6 | 2.813 | 24736.2 |
358 | 2020-02-05 04:30:08 | retiree | 1 | 69583 | 6 | 1.220 | 57035.2 |
357 | 2020-02-05 01:17:00 | retiree | 1 | 69583 | 6 | 3.783 | 18393.6 |
356 | 2020-02-02 04:56:21 | retiree | 1 | 69583 | 6 | 1.376 | 50569.0 |
355 | 2020-01-31 03:58:22 | retiree | 1 | 69583 | 6 | 1.266 | 54962.9 |
354 | 2020-01-20 12:28:19 | retiree | 1 | 69583 | 6 | 2.953 | 23563.5 |
353 | 2020-01-15 16:01:20 | retiree | 1 | 69583 | 6 | 1.436 | 48456.1 |
352 | 2020-01-15 09:35:29 | retiree | 1 | 69583 | 6 | 1.300 | 53525.4 |
351 | 2020-01-12 06:18:09 | retiree | 1 | 69583 | 6 | 1.766 | 39401.5 |
350 | 2020-01-08 04:57:52 | retiree | 1 | 69583 | 6 | 4.280 | 16257.7 |
349 | 2020-01-07 12:53:36 | retiree | 1 | 69583 | 6 | 1.250 | 55666.4 |
348 | 2019-12-27 04:51:32 | retiree | 1 | 69583 | 6 | 1.453 | 47889.2 |
347 | 2019-12-27 00:35:59 | retiree | 1 | 69583 | 6 | 1.376 | 50569.0 |
346 | 2019-12-26 07:02:17 | retiree | 1 | 69583 | 6 | 1.343 | 51811.6 |
345 | 2019-12-02 15:22:02 | retiree | 1 | 69583 | 6 | 1.123 | 61961.7 |
344 | 2019-09-03 09:00:47 | retiree | 1 | 69583 | 6 | 1.130 | 61577.9 |
343 | 2019-06-03 17:02:50 | retiree | 1 | 69583 | 6 | 1.223 | 56895.3 |
342 | 2019-02-25 11:40:45 | retiree | 1 | 69583 | 6 | 3.393 | 20507.8 |
341 | 2019-02-18 22:32:57 | retiree | 1 | 69583 | 6 | 1.226 | 56756.1 |
340 | 2019-01-16 18:10:22 | retiree | 1 | 69583 | 6 | 1.240 | 56115.3 |
339 | 2019-01-09 10:55:52 | retiree | 1 | 69583 | 6 | 1.123 | 61961.7 |
338 | 2019-01-07 08:25:10 | retiree | 1 | 69583 | 6 | 1.060 | 65644.3 |
337 | 2018-12-28 17:47:32 | retiree | 1 | 69583 | 6 | 1.293 | 53815.2 |