History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"playdays"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
420 | 2024-05-04 07:42:17 | playdays | 4 | 161609 | 455 | 25.080 | 6443.7 |
419 | 2024-05-03 18:26:39 | playdays | 2 | 121059 | 9 | 7.080 | 17098.7 |
418 | 2024-05-02 10:35:31 | playdays | 3 | 146162 | 50 | 17.986 | 8126.4 |
417 | 2024-05-02 08:42:43 | playdays | 4 | 161609 | 455 | 14.750 | 10956.5 |
416 | 2024-05-02 08:33:07 | playdays | 3 | 146162 | 50 | 25.750 | 5676.2 |
415 | 2024-05-02 08:33:04 | playdays | 4 | 161609 | 455 | 28.533 | 5663.9 |
414 | 2024-05-02 08:33:10 | playdays | 2 | 121059 | 9 | 14.220 | 8513.3 |
413 | 2024-05-02 08:32:34 | playdays | 1 | 82945 | 3 | 3.173 | 26140.9 |
412 | 2024-05-02 08:31:35 | playdays | 3 | 146162 | 50 | 14.656 | 9972.8 |
411 | 2024-05-02 08:31:27 | playdays | 4 | 161609 | 455 | 16.376 | 9868.6 |
410 | 2024-05-02 08:31:31 | playdays | 2 | 121059 | 9 | 8.623 | 14039.1 |
409 | 2024-05-02 08:31:38 | playdays | 1 | 82945 | 3 | 1.580 | 52496.8 |
408 | 2024-04-30 04:04:35 | playdays | 1 | 82945 | 3 | 1.280 | 64800.8 |
407 | 2024-04-30 01:37:10 | playdays | 1 | 82945 | 3 | 3.673 | 22582.4 |
406 | 2024-04-07 16:26:58 | playdays | 1 | 82945 | 3 | 2.766 | 29987.3 |
405 | 2024-04-06 10:37:36 | playdays | 3 | 146162 | 50 | 17.813 | 8205.4 |
404 | 2024-04-06 10:37:33 | playdays | 2 | 121059 | 9 | 14.126 | 8569.9 |
403 | 2024-04-05 10:54:12 | playdays | 3 | 146162 | 50 | 28.956 | 5047.7 |
402 | 2024-04-05 10:54:11 | playdays | 2 | 121059 | 9 | 7.233 | 16737.0 |
401 | 2024-04-05 10:54:06 | playdays | 1 | 82945 | 3 | 3.220 | 25759.3 |
400 | 2024-04-01 17:21:49 | playdays | 4 | 161609 | 455 | 36.330 | 4448.4 |
399 | 2024-04-01 06:26:07 | playdays | 1 | 82945 | 3 | 1.623 | 51106.0 |
398 | 2024-04-01 01:49:14 | playdays | 3 | 146162 | 50 | 17.220 | 8487.9 |
397 | 2024-04-01 01:49:12 | playdays | 2 | 121059 | 9 | 9.030 | 13406.3 |
396 | 2024-03-31 18:27:23 | playdays | 4 | 161609 | 455 | 16.300 | 9914.7 |
395 | 2024-03-31 05:16:10 | playdays | 4 | 161609 | 455 | 22.643 | 7137.3 |
394 | 2024-03-30 21:15:32 | playdays | 3 | 146162 | 50 | 17.643 | 8284.4 |
393 | 2024-03-30 21:15:30 | playdays | 4 | 161609 | 455 | 16.733 | 9658.1 |
392 | 2024-03-30 21:15:10 | playdays | 4 | 161609 | 455 | 28.940 | 5584.3 |
391 | 2024-03-30 21:15:32 | playdays | 2 | 121059 | 9 | 4.453 | 27185.9 |
390 | 2024-03-30 21:15:10 | playdays | 3 | 146162 | 50 | 22.156 | 6596.9 |
389 | 2024-03-30 21:15:26 | playdays | 1 | 82945 | 3 | 1.610 | 51518.6 |
388 | 2024-03-30 21:15:11 | playdays | 2 | 121059 | 9 | 5.796 | 20886.6 |
387 | 2024-03-30 21:15:03 | playdays | 1 | 82945 | 3 | 1.953 | 42470.6 |
386 | 2024-03-14 13:31:12 | playdays | 1 | 82945 | 3 | 1.423 | 58288.8 |
385 | 2024-03-06 04:09:38 | playdays | 1 | 82945 | 3 | 1.686 | 49196.3 |
384 | 2024-03-02 11:17:39 | playdays | 3 | 146162 | 50 | 13.500 | 10826.8 |
383 | 2024-03-01 16:06:29 | playdays | 4 | 161609 | 455 | 19.033 | 8491.0 |
382 | 2024-03-01 16:06:27 | playdays | 1 | 82945 | 3 | 2.783 | 29804.2 |
381 | 2024-03-01 16:06:17 | playdays | 2 | 121059 | 9 | 9.110 | 13288.6 |
380 | 2024-02-29 17:25:04 | playdays | 3 | 146162 | 50 | 13.796 | 10594.5 |
379 | 2024-02-29 12:34:44 | playdays | 2 | 121059 | 9 | 7.736 | 15648.8 |
378 | 2024-02-27 18:00:05 | playdays | 3 | 146162 | 50 | 7.190 | 20328.5 |
377 | 2024-02-27 18:00:05 | playdays | 2 | 121059 | 9 | 3.843 | 31501.2 |
376 | 2024-02-27 18:00:02 | playdays | 1 | 82945 | 3 | 1.530 | 54212.4 |
375 | 2024-02-24 19:02:29 | playdays | 4 | 161609 | 455 | 13.486 | 11983.5 |
374 | 2024-02-22 19:35:00 | playdays | 4 | 161609 | 455 | 12.736 | 12689.1 |
373 | 2024-01-25 18:08:23 | playdays | 4 | 161609 | 455 | 25.003 | 6463.6 |
372 | 2024-01-25 18:07:32 | playdays | 4 | 161609 | 455 | 16.563 | 9757.2 |
371 | 2024-01-15 22:11:57 | playdays | 4 | 161609 | 455 | 10.500 | 15391.3 |
370 | 2024-01-08 15:20:57 | playdays | 1 | 82945 | 3 | 1.403 | 59119.7 |
369 | 2023-12-01 14:00:15 | playdays | 1 | 82945 | 3 | 1.296 | 64000.8 |
368 | 2023-11-29 01:39:54 | playdays | 1 | 82945 | 3 | 1.453 | 57085.3 |
367 | 2023-11-28 13:41:19 | playdays | 1 | 82945 | 3 | 1.343 | 61761.0 |
366 | 2023-11-24 17:53:13 | playdays | 3 | 146162 | 50 | 6.580 | 22213.1 |
365 | 2023-11-17 17:06:49 | playdays | 4 | 161609 | 455 | 14.096 | 11464.9 |
364 | 2023-11-02 07:33:24 | playdays | 1 | 82945 | 3 | 1.466 | 56579.1 |
363 | 2023-10-28 07:26:55 | playdays | 1 | 82945 | 3 | 1.610 | 51518.6 |
362 | 2023-10-24 18:34:48 | playdays | 1 | 82945 | 3 | 1.360 | 60989.0 |
361 | 2023-08-25 06:48:48 | playdays | 1 | 82945 | 3 | 1.296 | 64000.8 |
360 | 2023-08-24 06:41:01 | playdays | 3 | 146162 | 50 | 6.173 | 23677.6 |
359 | 2023-08-18 19:34:06 | playdays | 4 | 161609 | 455 | 10.530 | 15347.5 |
358 | 2023-08-08 12:19:35 | playdays | 4 | 161609 | 455 | 12.533 | 12894.7 |
357 | 2023-08-07 15:54:49 | playdays | 1 | 82945 | 3 | 1.280 | 64800.8 |
356 | 2023-07-11 05:12:12 | playdays | 2 | 121059 | 9 | 3.173 | 38152.9 |
355 | 2023-07-04 00:02:18 | playdays | 1 | 82945 | 3 | 2.843 | 29175.2 |
354 | 2023-06-24 13:24:56 | playdays | 4 | 161609 | 455 | 11.330 | 14263.8 |
353 | 2023-06-23 13:36:20 | playdays | 4 | 161609 | 455 | 11.686 | 13829.3 |
352 | 2023-06-22 09:18:24 | playdays | 4 | 161609 | 455 | 10.923 | 14795.3 |
351 | 2023-06-21 09:08:43 | playdays | 4 | 161609 | 455 | 11.000 | 14691.7 |
350 | 2023-06-20 09:01:35 | playdays | 4 | 161609 | 455 | 11.813 | 13680.6 |
349 | 2023-06-19 09:06:50 | playdays | 4 | 161609 | 455 | 12.483 | 12946.3 |
348 | 2023-06-18 09:00:41 | playdays | 4 | 161609 | 455 | 11.970 | 13501.2 |
347 | 2023-06-18 02:21:17 | playdays | 4 | 161609 | 455 | 12.156 | 13294.6 |
346 | 2023-06-17 08:56:45 | playdays | 4 | 161609 | 455 | 12.313 | 13125.1 |
345 | 2023-06-16 08:57:55 | playdays | 4 | 161609 | 455 | 10.156 | 15912.7 |
344 | 2023-06-11 09:37:14 | playdays | 4 | 161609 | 455 | 10.513 | 15372.3 |
343 | 2023-06-10 12:43:01 | playdays | 2 | 121059 | 9 | 3.703 | 32692.1 |
342 | 2023-06-10 09:39:28 | playdays | 4 | 161609 | 455 | 10.893 | 14836.0 |
341 | 2023-06-09 09:37:48 | playdays | 4 | 161609 | 455 | 10.580 | 15275.0 |
340 | 2023-06-08 16:09:42 | playdays | 4 | 161609 | 455 | 10.313 | 15670.4 |
339 | 2023-06-04 09:47:01 | playdays | 4 | 161609 | 455 | 10.750 | 15033.4 |
338 | 2023-05-31 04:14:15 | playdays | 4 | 161609 | 455 | 10.453 | 15460.5 |
337 | 2023-05-28 01:18:17 | playdays | 4 | 161609 | 455 | 10.313 | 15670.4 |
336 | 2023-05-27 12:50:33 | playdays | 1 | 82945 | 3 | 1.250 | 66356.0 |
335 | 2023-05-21 12:36:11 | playdays | 4 | 161609 | 455 | 12.220 | 13225.0 |
334 | 2023-05-20 13:48:04 | playdays | 4 | 161609 | 455 | 10.220 | 15813.0 |
333 | 2023-05-19 20:14:34 | playdays | 4 | 161609 | 455 | 12.453 | 12977.5 |
332 | 2023-05-18 16:58:46 | playdays | 4 | 161609 | 455 | 12.813 | 12612.9 |
331 | 2023-05-17 18:04:23 | playdays | 4 | 161609 | 455 | 12.013 | 13452.8 |
330 | 2023-05-17 01:19:32 | playdays | 4 | 161609 | 455 | 10.233 | 15792.9 |
329 | 2023-05-16 02:57:18 | playdays | 4 | 161609 | 455 | 11.843 | 13646.0 |
328 | 2023-05-15 04:38:45 | playdays | 4 | 161609 | 455 | 12.440 | 12991.1 |
327 | 2023-05-08 06:06:28 | playdays | 3 | 146162 | 50 | 6.110 | 23921.8 |
326 | 2023-05-03 03:15:35 | playdays | 4 | 161609 | 455 | 10.530 | 15347.5 |
325 | 2023-04-20 16:23:31 | playdays | 4 | 161609 | 455 | 11.080 | 14585.6 |
324 | 2023-03-21 23:15:00 | playdays | 1 | 82945 | 3 | 1.263 | 65673.0 |
323 | 2023-02-17 16:57:31 | playdays | 3 | 146162 | 50 | 8.970 | 16294.5 |
322 | 2023-02-10 02:21:40 | playdays | 4 | 161609 | 455 | 10.376 | 15575.3 |
321 | 2023-02-03 17:33:50 | playdays | 4 | 161609 | 455 | 11.220 | 14403.7 |