History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"happier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
433 | 2024-04-27 02:57:21 | happier | 1 | 69583 | 8 | 2.406 | 28920.6 |
432 | 2024-04-26 22:39:35 | happier | 1 | 69583 | 8 | 4.483 | 15521.5 |
431 | 2024-03-31 18:01:38 | happier | 2 | 107671 | 69 | 23.796 | 4524.8 |
430 | 2024-03-31 16:38:05 | happier | 2 | 107671 | 69 | 7.940 | 13560.6 |
429 | 2024-03-31 01:18:22 | happier | 3 | 134027 | 537 | 25.470 | 5262.2 |
428 | 2024-03-31 00:10:05 | happier | 2 | 107671 | 69 | 10.673 | 10088.2 |
427 | 2024-03-30 12:42:09 | happier | 3 | 134027 | 537 | 23.156 | 5788.0 |
426 | 2024-03-30 09:47:58 | happier | 3 | 134027 | 537 | 20.440 | 6557.1 |
425 | 2024-03-30 09:47:58 | happier | 2 | 107671 | 69 | 11.580 | 9298.0 |
424 | 2024-03-30 09:47:28 | happier | 1 | 69583 | 8 | 3.253 | 21390.4 |
423 | 2024-03-10 22:48:46 | happier | 1 | 69583 | 8 | 2.530 | 27503.2 |
422 | 2024-02-10 19:48:03 | happier | 1 | 69583 | 8 | 2.686 | 25905.8 |
421 | 2024-01-01 23:44:46 | happier | 2 | 107671 | 69 | 3.233 | 33303.7 |
420 | 2024-01-01 00:42:48 | happier | 3 | 134027 | 537 | 6.530 | 20524.8 |
419 | 2024-01-01 00:42:50 | happier | 2 | 107671 | 69 | 3.233 | 33303.7 |
418 | 2023-12-25 20:42:15 | happier | 1 | 69583 | 8 | 1.236 | 56296.9 |
417 | 2023-12-15 05:52:12 | happier | 1 | 69583 | 8 | 1.093 | 63662.4 |
416 | 2023-12-01 18:17:46 | happier | 1 | 69583 | 8 | 1.080 | 64428.7 |
415 | 2023-11-14 09:18:09 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
414 | 2023-11-11 04:46:29 | happier | 1 | 69583 | 8 | 1.156 | 60192.9 |
413 | 2023-10-17 15:54:16 | happier | 1 | 69583 | 8 | 1.403 | 49595.9 |
412 | 2023-10-15 13:41:04 | happier | 1 | 69583 | 8 | 1.093 | 63662.4 |
411 | 2023-10-15 12:47:00 | happier | 1 | 69583 | 8 | 1.266 | 54962.9 |
410 | 2023-10-09 16:22:15 | happier | 2 | 107671 | 69 | 3.330 | 32333.6 |
409 | 2023-10-08 23:46:03 | happier | 3 | 134027 | 537 | 6.203 | 21606.8 |
408 | 2023-10-08 23:46:01 | happier | 2 | 107671 | 69 | 3.000 | 35890.3 |
407 | 2023-10-03 15:11:43 | happier | 1 | 69583 | 8 | 1.236 | 56296.9 |
406 | 2023-10-02 14:42:46 | happier | 1 | 69583 | 8 | 1.110 | 62687.4 |
405 | 2023-09-26 13:30:39 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
404 | 2023-09-25 02:52:20 | happier | 1 | 69583 | 8 | 1.280 | 54361.7 |
403 | 2023-07-31 10:42:21 | happier | 1 | 69583 | 8 | 1.203 | 57841.2 |
402 | 2023-07-20 09:55:17 | happier | 2 | 107671 | 69 | 5.766 | 18673.4 |
401 | 2023-06-24 22:24:09 | happier | 1 | 69583 | 8 | 1.203 | 57841.2 |
400 | 2023-04-28 10:30:04 | happier | 1 | 69583 | 8 | 1.220 | 57035.2 |
399 | 2023-04-04 08:14:58 | happier | 2 | 107671 | 69 | 2.796 | 38508.9 |
398 | 2023-03-06 01:57:37 | happier | 1 | 69583 | 8 | 1.203 | 57841.2 |
397 | 2023-02-19 19:48:40 | happier | 1 | 69583 | 8 | 1.030 | 67556.3 |
396 | 2023-01-02 20:03:18 | happier | 2 | 107671 | 69 | 3.096 | 34777.5 |
395 | 2022-12-16 19:37:36 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
394 | 2022-11-10 05:53:25 | happier | 1 | 69583 | 8 | 1.076 | 64668.2 |
393 | 2022-09-07 02:02:18 | happier | 2 | 107671 | 69 | 2.826 | 38100.1 |
392 | 2022-08-26 21:37:24 | happier | 1 | 69583 | 8 | 1.050 | 66269.5 |
391 | 2022-07-21 01:16:11 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
390 | 2022-07-17 07:49:58 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
389 | 2022-04-06 01:03:18 | happier | 1 | 69583 | 8 | 1.140 | 61037.7 |
388 | 2022-03-20 00:38:02 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
387 | 2022-03-16 14:12:01 | happier | 1 | 69583 | 8 | 1.250 | 55666.4 |
386 | 2022-01-05 10:24:03 | happier | 1 | 69583 | 8 | 1.220 | 57035.2 |
385 | 2022-01-03 08:26:20 | happier | 1 | 69583 | 8 | 1.156 | 60192.9 |
384 | 2021-11-29 10:17:46 | happier | 1 | 69583 | 8 | 1.203 | 57841.2 |
383 | 2021-11-11 01:59:17 | happier | 1 | 69583 | 8 | 1.186 | 58670.3 |
382 | 2021-11-09 22:00:20 | happier | 1 | 69583 | 8 | 1.236 | 56296.9 |
381 | 2021-09-29 14:39:46 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
380 | 2021-09-12 12:09:28 | happier | 1 | 69583 | 8 | 1.203 | 57841.2 |
379 | 2021-08-26 12:07:09 | happier | 1 | 69583 | 8 | 1.203 | 57841.2 |
378 | 2021-05-25 19:18:12 | happier | 1 | 69583 | 8 | 1.220 | 57035.2 |
377 | 2021-05-10 09:00:42 | happier | 1 | 69583 | 8 | 1.110 | 62687.4 |
376 | 2021-04-09 01:17:24 | happier | 1 | 69583 | 8 | 1.186 | 58670.3 |
375 | 2021-02-20 08:01:59 | happier | 1 | 69583 | 8 | 1.093 | 63662.4 |
374 | 2021-02-13 01:50:49 | happier | 1 | 69583 | 8 | 1.093 | 63662.4 |
373 | 2021-01-23 20:21:27 | happier | 1 | 69583 | 8 | 1.076 | 64668.2 |
372 | 2020-11-28 14:28:50 | happier | 1 | 69583 | 8 | 1.076 | 64668.2 |
371 | 2020-11-21 09:32:22 | happier | 1 | 69583 | 8 | 1.063 | 65459.1 |
370 | 2020-11-06 04:30:31 | happier | 2 | 107671 | 69 | 2.876 | 37437.8 |
369 | 2020-10-29 04:37:07 | happier | 1 | 69583 | 8 | 2.266 | 30707.4 |
368 | 2020-10-25 11:59:26 | happier | 3 | 134027 | 537 | 5.920 | 22639.7 |
367 | 2020-10-24 13:07:12 | happier | 1 | 69583 | 8 | 1.060 | 65644.3 |
366 | 2020-10-16 18:06:04 | happier | 1 | 69583 | 8 | 1.080 | 64428.7 |
365 | 2020-10-06 13:08:15 | happier | 1 | 69583 | 8 | 1.110 | 62687.4 |
364 | 2020-09-18 02:12:24 | happier | 1 | 69583 | 8 | 1.106 | 62914.1 |
363 | 2020-08-20 20:26:04 | happier | 1 | 69583 | 8 | 1.093 | 63662.4 |
362 | 2020-08-14 08:40:51 | happier | 1 | 69583 | 8 | 1.250 | 55666.4 |
361 | 2020-08-11 09:15:36 | happier | 1 | 69583 | 8 | 1.190 | 58473.1 |
360 | 2020-08-03 20:12:28 | happier | 1 | 69583 | 8 | 1.233 | 56433.9 |
359 | 2020-07-30 17:44:08 | happier | 1 | 69583 | 8 | 1.233 | 56433.9 |
358 | 2020-06-20 23:30:13 | happier | 1 | 69583 | 8 | 1.280 | 54361.7 |
357 | 2020-06-05 16:53:27 | happier | 3 | 134027 | 537 | 5.860 | 22871.5 |
356 | 2020-05-07 03:51:02 | happier | 1 | 69583 | 8 | 1.156 | 60192.9 |
355 | 2020-04-04 10:29:56 | happier | 1 | 69583 | 8 | 1.080 | 64428.7 |
354 | 2020-03-29 13:57:45 | happier | 1 | 69583 | 8 | 1.280 | 54361.7 |
353 | 2020-03-29 02:36:11 | happier | 1 | 69583 | 8 | 1.173 | 59320.5 |
352 | 2020-03-25 15:11:15 | happier | 1 | 69583 | 8 | 1.220 | 57035.2 |
351 | 2020-03-25 04:39:26 | happier | 1 | 69583 | 8 | 1.080 | 64428.7 |
350 | 2020-03-20 18:02:30 | happier | 1 | 69583 | 8 | 1.203 | 57841.2 |
349 | 2020-02-27 20:33:50 | happier | 1 | 69583 | 8 | 1.500 | 46388.7 |
348 | 2020-02-27 19:33:03 | happier | 1 | 69583 | 8 | 1.233 | 56433.9 |
347 | 2020-02-25 07:39:33 | happier | 1 | 69583 | 8 | 1.080 | 64428.7 |
346 | 2020-02-10 15:16:56 | happier | 1 | 69583 | 8 | 1.296 | 53690.6 |
345 | 2020-02-10 10:33:07 | happier | 1 | 69583 | 8 | 1.373 | 50679.5 |
344 | 2020-02-07 16:52:44 | happier | 1 | 69583 | 8 | 1.266 | 54962.9 |
343 | 2020-02-05 06:28:53 | happier | 1 | 69583 | 8 | 1.296 | 53690.6 |
342 | 2020-02-04 15:47:48 | happier | 1 | 69583 | 8 | 1.376 | 50569.0 |
341 | 2020-02-03 03:30:11 | happier | 1 | 69583 | 8 | 1.923 | 36184.6 |
340 | 2020-01-31 06:52:24 | happier | 1 | 69583 | 8 | 3.623 | 19205.9 |
339 | 2020-01-31 00:15:05 | happier | 1 | 69583 | 8 | 2.360 | 29484.3 |
338 | 2020-01-20 16:16:02 | happier | 1 | 69583 | 8 | 3.860 | 18026.7 |
337 | 2020-01-18 15:34:17 | happier | 1 | 69583 | 8 | 2.436 | 28564.4 |
336 | 2020-01-16 13:32:35 | happier | 1 | 69583 | 8 | 1.313 | 52995.4 |
335 | 2020-01-13 05:19:16 | happier | 1 | 69583 | 8 | 1.873 | 37150.6 |
334 | 2019-12-31 04:26:15 | happier | 1 | 69583 | 8 | 1.236 | 56296.9 |