History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sconces"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
436 | 2024-04-26 06:03:40 | sconces | 1 | 69583 | 4 | 1.283 | 54234.6 |
435 | 2024-04-25 21:58:36 | sconces | 2 | 107671 | 33 | 4.360 | 24695.2 |
434 | 2024-04-25 21:55:52 | sconces | 3 | 134027 | 485 | 8.953 | 14970.1 |
433 | 2024-04-25 21:26:08 | sconces | 2 | 107671 | 33 | 10.656 | 10104.3 |
432 | 2024-04-25 21:23:24 | sconces | 3 | 134027 | 485 | 7.296 | 18369.9 |
431 | 2024-04-25 18:39:58 | sconces | 3 | 134027 | 485 | 13.703 | 9780.9 |
430 | 2024-04-25 13:16:07 | sconces | 3 | 134027 | 485 | 10.923 | 12270.2 |
429 | 2024-04-09 22:57:32 | sconces | 1 | 69583 | 4 | 1.280 | 54361.7 |
428 | 2024-04-05 09:52:34 | sconces | 1 | 69583 | 4 | 5.360 | 12981.9 |
427 | 2024-03-31 17:59:19 | sconces | 1 | 69583 | 4 | 1.890 | 36816.4 |
426 | 2024-03-31 13:48:08 | sconces | 1 | 69583 | 4 | 2.876 | 24194.4 |
425 | 2024-03-08 23:54:47 | sconces | 3 | 134027 | 485 | 19.126 | 7007.6 |
424 | 2024-03-08 23:51:30 | sconces | 3 | 134027 | 485 | 21.236 | 6311.3 |
423 | 2024-03-08 23:51:31 | sconces | 2 | 107671 | 33 | 4.410 | 24415.2 |
422 | 2024-03-08 00:25:12 | sconces | 2 | 107671 | 33 | 3.423 | 31455.2 |
421 | 2024-03-08 00:24:52 | sconces | 3 | 134027 | 485 | 7.016 | 19103.1 |
420 | 2024-03-06 23:09:29 | sconces | 3 | 134027 | 485 | 23.673 | 5661.6 |
419 | 2024-03-06 23:09:29 | sconces | 2 | 107671 | 33 | 7.893 | 13641.3 |
418 | 2024-03-06 21:13:55 | sconces | 1 | 69583 | 4 | 1.236 | 56296.9 |
417 | 2024-02-07 12:51:58 | sconces | 2 | 107671 | 33 | 2.983 | 36094.9 |
416 | 2024-02-07 12:51:38 | sconces | 3 | 134027 | 485 | 6.203 | 21606.8 |
415 | 2024-01-29 13:19:53 | sconces | 3 | 134027 | 485 | 7.110 | 18850.5 |
414 | 2024-01-20 22:34:46 | sconces | 2 | 107671 | 33 | 3.266 | 32967.2 |
413 | 2024-01-20 22:34:41 | sconces | 3 | 134027 | 485 | 6.876 | 19492.0 |
412 | 2024-01-05 05:20:39 | sconces | 2 | 107671 | 33 | 3.313 | 32499.5 |
411 | 2024-01-03 09:06:27 | sconces | 1 | 69583 | 4 | 1.393 | 49951.9 |
410 | 2023-12-28 07:14:43 | sconces | 1 | 69583 | 4 | 1.126 | 61796.6 |
409 | 2023-12-14 01:27:44 | sconces | 3 | 134027 | 485 | 5.796 | 23124.1 |
408 | 2023-12-06 01:18:48 | sconces | 3 | 134027 | 485 | 5.966 | 22465.1 |
407 | 2023-12-06 01:18:41 | sconces | 2 | 107671 | 33 | 2.843 | 37872.3 |
406 | 2023-11-18 04:25:09 | sconces | 1 | 69583 | 4 | 1.233 | 56433.9 |
405 | 2023-11-16 03:01:09 | sconces | 1 | 69583 | 4 | 1.156 | 60192.9 |
404 | 2023-11-11 06:15:35 | sconces | 1 | 69583 | 4 | 1.186 | 58670.3 |
403 | 2023-11-05 00:41:10 | sconces | 1 | 69583 | 4 | 1.080 | 64428.7 |
402 | 2023-10-25 20:43:57 | sconces | 1 | 69583 | 4 | 1.250 | 55666.4 |
401 | 2023-10-17 06:38:09 | sconces | 1 | 69583 | 4 | 1.173 | 59320.5 |
400 | 2023-10-12 16:51:38 | sconces | 2 | 107671 | 33 | 2.846 | 37832.4 |
399 | 2023-09-26 18:35:53 | sconces | 1 | 69583 | 4 | 1.216 | 57222.9 |
398 | 2023-09-21 22:51:31 | sconces | 1 | 69583 | 4 | 1.173 | 59320.5 |
397 | 2023-09-12 22:29:27 | sconces | 3 | 134027 | 485 | 5.966 | 22465.1 |
396 | 2023-08-28 18:05:40 | sconces | 1 | 69583 | 4 | 1.126 | 61796.6 |
395 | 2023-08-13 13:09:13 | sconces | 1 | 69583 | 4 | 1.360 | 51164.0 |
394 | 2023-08-11 13:15:59 | sconces | 3 | 134027 | 485 | 5.750 | 23309.0 |
393 | 2023-07-23 17:22:30 | sconces | 2 | 107671 | 33 | 2.810 | 38317.1 |
392 | 2023-06-07 22:17:10 | sconces | 3 | 134027 | 485 | 5.910 | 22678.0 |
391 | 2023-05-13 15:26:47 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
390 | 2023-05-11 11:54:01 | sconces | 1 | 69583 | 4 | 1.296 | 53690.6 |
389 | 2023-05-10 10:44:54 | sconces | 3 | 134027 | 485 | 5.830 | 22989.2 |
388 | 2023-04-06 17:50:16 | sconces | 3 | 134027 | 485 | 6.080 | 22043.9 |
387 | 2023-04-05 06:54:06 | sconces | 2 | 107671 | 33 | 3.390 | 31761.4 |
386 | 2023-03-11 00:08:17 | sconces | 3 | 134027 | 485 | 7.076 | 18941.1 |
385 | 2023-03-07 16:52:05 | sconces | 1 | 69583 | 4 | 1.076 | 64668.2 |
384 | 2023-01-25 17:24:08 | sconces | 1 | 69583 | 4 | 1.076 | 64668.2 |
383 | 2023-01-03 18:43:43 | sconces | 2 | 107671 | 33 | 3.296 | 32667.2 |
382 | 2022-12-29 11:15:52 | sconces | 1 | 69583 | 4 | 1.186 | 58670.3 |
381 | 2022-12-16 05:59:38 | sconces | 3 | 134027 | 485 | 6.610 | 20276.4 |
380 | 2022-10-07 16:58:23 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
379 | 2022-10-04 04:38:40 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
378 | 2022-09-19 20:31:08 | sconces | 1 | 69583 | 4 | 1.106 | 62914.1 |
377 | 2022-09-08 07:51:19 | sconces | 2 | 107671 | 33 | 3.186 | 33795.0 |
376 | 2022-08-29 00:55:09 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
375 | 2022-08-18 17:57:45 | sconces | 1 | 69583 | 4 | 1.186 | 58670.3 |
374 | 2022-08-07 09:10:43 | sconces | 3 | 134027 | 485 | 6.000 | 22337.8 |
373 | 2022-07-26 12:39:46 | sconces | 1 | 69583 | 4 | 1.220 | 57035.2 |
372 | 2022-07-01 02:27:13 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
371 | 2022-06-09 23:49:47 | sconces | 1 | 69583 | 4 | 1.110 | 62687.4 |
370 | 2022-03-08 13:47:15 | sconces | 3 | 134027 | 485 | 7.623 | 17581.9 |
369 | 2022-03-06 00:15:32 | sconces | 1 | 69583 | 4 | 1.266 | 54962.9 |
368 | 2022-02-16 05:25:55 | sconces | 1 | 69583 | 4 | 1.220 | 57035.2 |
367 | 2021-12-20 16:53:47 | sconces | 1 | 69583 | 4 | 1.330 | 52318.0 |
366 | 2021-10-28 23:59:59 | sconces | 1 | 69583 | 4 | 1.704 | 40835.1 |
365 | 2021-10-25 18:20:33 | sconces | 1 | 69583 | 4 | 1.110 | 62687.4 |
364 | 2021-10-25 17:12:19 | sconces | 1 | 69583 | 4 | 1.233 | 56433.9 |
363 | 2021-09-21 08:27:06 | sconces | 1 | 69583 | 4 | 1.096 | 63488.1 |
362 | 2021-09-14 07:07:40 | sconces | 1 | 69583 | 4 | 1.173 | 59320.5 |
361 | 2021-09-13 19:26:29 | sconces | 1 | 69583 | 4 | 1.076 | 64668.2 |
360 | 2021-09-11 15:34:50 | sconces | 1 | 69583 | 4 | 1.156 | 60192.9 |
359 | 2021-07-18 19:36:08 | sconces | 1 | 69583 | 4 | 1.170 | 59472.6 |
358 | 2021-06-24 21:08:46 | sconces | 1 | 69583 | 4 | 1.280 | 54361.7 |
357 | 2021-05-16 16:40:45 | sconces | 1 | 69583 | 4 | 1.233 | 56433.9 |
356 | 2021-05-04 08:02:28 | sconces | 1 | 69583 | 4 | 1.123 | 61961.7 |
355 | 2021-04-16 03:15:22 | sconces | 1 | 69583 | 4 | 2.436 | 28564.4 |
354 | 2021-04-12 07:16:53 | sconces | 1 | 69583 | 4 | 1.203 | 57841.2 |
353 | 2021-04-02 10:48:43 | sconces | 1 | 69583 | 4 | 2.156 | 32274.1 |
352 | 2021-03-07 01:19:44 | sconces | 1 | 69583 | 4 | 1.343 | 51811.6 |
351 | 2021-02-13 12:22:37 | sconces | 1 | 69583 | 4 | 1.310 | 53116.8 |
350 | 2021-01-17 11:35:33 | sconces | 1 | 69583 | 4 | 1.063 | 65459.1 |
349 | 2020-12-26 05:30:59 | sconces | 1 | 69583 | 4 | 1.080 | 64428.7 |
348 | 2020-11-23 08:49:46 | sconces | 1 | 69583 | 4 | 1.203 | 57841.2 |
347 | 2020-10-27 23:46:34 | sconces | 3 | 134027 | 485 | 6.983 | 19193.3 |
346 | 2020-10-26 23:35:54 | sconces | 1 | 69583 | 4 | 1.250 | 55666.4 |
345 | 2020-10-25 18:34:35 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
344 | 2020-10-14 07:58:55 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
343 | 2020-09-18 14:18:54 | sconces | 1 | 69583 | 4 | 1.063 | 65459.1 |
342 | 2020-09-14 12:26:42 | sconces | 1 | 69583 | 4 | 1.093 | 63662.4 |
341 | 2020-09-12 07:48:07 | sconces | 1 | 69583 | 4 | 1.140 | 61037.7 |
340 | 2020-08-24 02:50:36 | sconces | 1 | 69583 | 4 | 1.233 | 56433.9 |
339 | 2020-08-08 00:43:54 | sconces | 1 | 69583 | 4 | 1.170 | 59472.6 |
338 | 2020-07-26 04:27:41 | sconces | 1 | 69583 | 4 | 1.203 | 57841.2 |
337 | 2020-07-18 03:32:00 | sconces | 1 | 69583 | 4 | 1.236 | 56296.9 |