History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trumps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
409 | 2024-04-03 01:16:18 | trumps | 1 | 48755 | 10 | 1.280 | 38089.8 |
408 | 2024-02-28 08:21:02 | trumps | 1 | 48755 | 10 | 3.656 | 13335.6 |
407 | 2024-02-28 00:01:01 | trumps | 1 | 48755 | 10 | 0.923 | 52822.3 |
406 | 2024-02-12 01:00:39 | trumps | 3 | 112716 | 621 | 13.470 | 8367.9 |
405 | 2024-02-09 21:33:28 | trumps | 2 | 82551 | 80 | 4.466 | 18484.3 |
404 | 2024-02-09 16:44:13 | trumps | 3 | 112716 | 621 | 17.733 | 6356.3 |
403 | 2024-02-07 16:54:11 | trumps | 2 | 82551 | 80 | 2.846 | 29006.0 |
402 | 2024-02-07 16:53:47 | trumps | 3 | 112716 | 621 | 7.440 | 15150.0 |
401 | 2024-02-07 16:20:02 | trumps | 3 | 112716 | 621 | 9.796 | 11506.3 |
400 | 2024-02-07 15:35:14 | trumps | 2 | 82551 | 80 | 2.656 | 31080.9 |
399 | 2024-02-07 15:34:50 | trumps | 3 | 112716 | 621 | 5.110 | 22057.9 |
398 | 2024-02-07 14:56:01 | trumps | 2 | 82551 | 80 | 2.483 | 33246.5 |
397 | 2024-02-07 14:55:13 | trumps | 3 | 112716 | 621 | 5.750 | 19602.8 |
396 | 2024-02-07 04:41:26 | trumps | 3 | 112716 | 621 | 11.046 | 10204.2 |
395 | 2024-01-16 22:59:33 | trumps | 2 | 82551 | 80 | 2.673 | 30883.3 |
394 | 2024-01-07 04:07:29 | trumps | 3 | 112716 | 621 | 6.656 | 16934.5 |
393 | 2024-01-05 21:10:18 | trumps | 3 | 112716 | 621 | 7.373 | 15287.7 |
392 | 2023-12-13 10:36:43 | trumps | 2 | 82551 | 80 | 2.533 | 32590.2 |
391 | 2023-12-09 23:03:51 | trumps | 1 | 48755 | 10 | 0.860 | 56691.9 |
390 | 2023-12-07 08:38:48 | trumps | 1 | 48755 | 10 | 0.733 | 66514.3 |
389 | 2023-12-04 00:43:24 | trumps | 1 | 48755 | 10 | 0.936 | 52088.7 |
388 | 2023-11-18 23:08:57 | trumps | 1 | 48755 | 10 | 0.733 | 66514.3 |
387 | 2023-11-15 00:31:07 | trumps | 3 | 112716 | 621 | 5.140 | 21929.2 |
386 | 2023-10-31 03:25:29 | trumps | 1 | 48755 | 10 | 0.766 | 63648.8 |
385 | 2023-10-28 13:03:29 | trumps | 2 | 82551 | 80 | 2.576 | 32046.2 |
384 | 2023-10-27 17:18:39 | trumps | 1 | 48755 | 10 | 0.796 | 61250.0 |
383 | 2023-10-14 02:47:17 | trumps | 1 | 48755 | 10 | 0.766 | 63648.8 |
382 | 2023-10-04 22:43:04 | trumps | 3 | 112716 | 621 | 5.736 | 19650.6 |
381 | 2023-10-01 05:35:03 | trumps | 3 | 112716 | 621 | 5.393 | 20900.4 |
380 | 2023-10-01 05:35:02 | trumps | 2 | 82551 | 80 | 2.346 | 35188.0 |
379 | 2023-09-29 07:43:25 | trumps | 1 | 48755 | 10 | 0.826 | 59025.4 |
378 | 2023-09-22 12:17:39 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
377 | 2023-09-20 12:43:45 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
376 | 2023-08-16 07:35:20 | trumps | 3 | 112716 | 621 | 4.673 | 24120.7 |
375 | 2023-08-05 06:55:52 | trumps | 2 | 82551 | 80 | 2.343 | 35233.0 |
374 | 2023-07-13 12:00:10 | trumps | 1 | 48755 | 10 | 0.813 | 59969.2 |
373 | 2023-04-26 02:45:16 | trumps | 3 | 112716 | 621 | 5.126 | 21989.1 |
372 | 2023-04-21 16:55:07 | trumps | 2 | 82551 | 80 | 2.093 | 39441.5 |
371 | 2023-04-17 05:57:07 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
370 | 2023-02-08 22:55:12 | trumps | 1 | 48755 | 10 | 0.736 | 66243.2 |
369 | 2023-02-01 08:20:07 | trumps | 3 | 112716 | 621 | 4.826 | 23356.0 |
368 | 2023-01-27 02:12:31 | trumps | 2 | 82551 | 80 | 4.296 | 19215.8 |
367 | 2022-12-06 22:42:02 | trumps | 1 | 48755 | 10 | 0.733 | 66514.3 |
366 | 2022-11-25 23:14:15 | trumps | 1 | 48755 | 10 | 0.720 | 67715.3 |
365 | 2022-11-12 03:18:20 | trumps | 3 | 112716 | 621 | 4.583 | 24594.4 |
364 | 2022-11-09 11:49:36 | trumps | 2 | 82551 | 80 | 2.470 | 33421.5 |
363 | 2022-08-16 00:58:56 | trumps | 1 | 48755 | 10 | 0.826 | 59025.4 |
362 | 2022-08-07 12:50:40 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
361 | 2022-07-18 08:07:41 | trumps | 1 | 48755 | 10 | 0.733 | 66514.3 |
360 | 2022-07-10 10:46:44 | trumps | 1 | 48755 | 10 | 0.843 | 57835.1 |
359 | 2022-06-25 15:55:40 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
358 | 2022-06-14 09:24:37 | trumps | 3 | 112716 | 621 | 4.656 | 24208.8 |
357 | 2022-06-09 23:12:38 | trumps | 1 | 48755 | 10 | 0.843 | 57835.1 |
356 | 2022-06-01 19:38:16 | trumps | 1 | 48755 | 10 | 0.826 | 59025.4 |
355 | 2022-05-07 01:57:56 | trumps | 2 | 82551 | 80 | 2.140 | 38575.2 |
354 | 2022-03-30 04:59:53 | trumps | 1 | 48755 | 10 | 0.893 | 54596.9 |
353 | 2022-01-31 07:17:41 | trumps | 3 | 112716 | 621 | 4.593 | 24540.8 |
352 | 2022-01-29 04:35:02 | trumps | 3 | 112716 | 621 | 4.766 | 23650.0 |
351 | 2022-01-08 20:42:08 | trumps | 2 | 82551 | 80 | 2.530 | 32628.9 |
350 | 2022-01-05 03:01:03 | trumps | 1 | 48755 | 10 | 1.000 | 48755.0 |
349 | 2021-11-26 07:56:34 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
348 | 2021-11-05 18:45:06 | trumps | 3 | 112716 | 621 | 5.186 | 21734.7 |
347 | 2021-11-03 09:23:31 | trumps | 1 | 48755 | 10 | 0.876 | 55656.4 |
346 | 2021-09-16 11:28:35 | trumps | 1 | 48755 | 10 | 0.766 | 63648.8 |
345 | 2021-09-10 12:11:42 | trumps | 1 | 48755 | 10 | 0.813 | 59969.2 |
344 | 2021-08-29 22:19:41 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
343 | 2021-08-27 17:24:24 | trumps | 1 | 48755 | 10 | 0.936 | 52088.7 |
342 | 2021-04-24 03:08:37 | trumps | 1 | 48755 | 10 | 1.623 | 30040.0 |
341 | 2021-02-28 03:48:30 | trumps | 1 | 48755 | 10 | 0.810 | 60191.4 |
340 | 2021-02-04 05:02:21 | trumps | 1 | 48755 | 10 | 0.783 | 62266.9 |
339 | 2020-11-23 17:17:37 | trumps | 1 | 48755 | 10 | 0.873 | 55847.7 |
338 | 2020-10-22 18:22:55 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
337 | 2020-10-21 09:55:49 | trumps | 1 | 48755 | 10 | 0.843 | 57835.1 |
336 | 2020-10-11 19:46:11 | trumps | 1 | 48755 | 10 | 0.733 | 66514.3 |
335 | 2020-07-23 17:39:06 | trumps | 1 | 48755 | 10 | 0.813 | 59969.2 |
334 | 2020-07-20 10:32:12 | trumps | 1 | 48755 | 10 | 0.796 | 61250.0 |
333 | 2020-04-16 13:19:39 | trumps | 1 | 48755 | 10 | 0.923 | 52822.3 |
332 | 2020-03-27 20:46:33 | trumps | 1 | 48755 | 10 | 0.890 | 54780.9 |
331 | 2020-03-26 02:55:05 | trumps | 1 | 48755 | 10 | 0.890 | 54780.9 |
330 | 2020-03-25 14:33:46 | trumps | 1 | 48755 | 10 | 0.860 | 56691.9 |
329 | 2020-03-23 23:02:56 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
328 | 2020-03-23 13:01:08 | trumps | 1 | 48755 | 10 | 1.876 | 25988.8 |
327 | 2020-03-19 23:22:12 | trumps | 1 | 48755 | 10 | 0.750 | 65006.7 |
326 | 2020-03-13 06:46:16 | trumps | 1 | 48755 | 10 | 0.780 | 62506.4 |
325 | 2020-03-13 06:32:22 | trumps | 1 | 48755 | 10 | 0.796 | 61250.0 |
324 | 2020-02-29 06:03:53 | trumps | 2 | 82551 | 80 | 2.720 | 30349.6 |
323 | 2020-02-29 01:07:18 | trumps | 1 | 48755 | 10 | 2.750 | 17729.1 |
322 | 2020-02-27 21:00:14 | trumps | 2 | 82551 | 80 | 3.733 | 22113.8 |
321 | 2020-02-27 11:05:36 | trumps | 2 | 82551 | 80 | 2.690 | 30688.1 |
320 | 2020-02-21 15:39:04 | trumps | 1 | 48755 | 10 | 0.983 | 49598.2 |
319 | 2020-02-16 08:13:18 | trumps | 1 | 48755 | 10 | 0.873 | 55847.7 |
318 | 2020-02-14 09:22:51 | trumps | 1 | 48755 | 10 | 0.936 | 52088.7 |
317 | 2020-02-14 06:00:37 | trumps | 3 | 112716 | 621 | 10.750 | 10485.2 |
316 | 2020-02-07 20:46:15 | trumps | 1 | 48755 | 10 | 0.890 | 54780.9 |
315 | 2020-02-07 19:54:35 | trumps | 3 | 112716 | 621 | 8.970 | 12565.9 |
314 | 2020-02-07 15:41:46 | trumps | 1 | 48755 | 10 | 0.796 | 61250.0 |
313 | 2020-02-07 15:28:28 | trumps | 3 | 112716 | 621 | 6.296 | 17902.8 |
312 | 2020-02-07 12:45:36 | trumps | 3 | 112716 | 621 | 5.546 | 20323.8 |
311 | 2020-02-06 22:10:34 | trumps | 1 | 48755 | 10 | 0.906 | 53813.5 |
310 | 2020-02-06 21:20:35 | trumps | 3 | 112716 | 621 | 5.203 | 21663.7 |