History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spellings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
416 | 2024-04-17 00:16:08 | spellings | 2 | 121436 | 31 | 7.673 | 15826.4 |
415 | 2024-04-10 13:52:50 | spellings | 2 | 121436 | 31 | 9.296 | 13063.3 |
414 | 2024-04-10 13:19:32 | spellings | 1 | 81242 | 3 | 3.170 | 25628.4 |
413 | 2024-04-09 20:04:46 | spellings | 1 | 81242 | 3 | 1.436 | 56575.2 |
412 | 2024-04-06 08:32:32 | spellings | 3 | 148641 | 188 | 26.393 | 5631.8 |
411 | 2024-04-06 08:32:31 | spellings | 2 | 121436 | 31 | 4.156 | 29219.4 |
410 | 2024-04-05 01:53:03 | spellings | 3 | 148641 | 188 | 21.796 | 6819.6 |
409 | 2024-04-05 01:53:04 | spellings | 2 | 121436 | 31 | 13.656 | 8892.5 |
408 | 2024-04-05 01:52:20 | spellings | 1 | 81242 | 3 | 1.580 | 51419.0 |
407 | 2024-03-04 11:19:48 | spellings | 1 | 81242 | 3 | 1.376 | 59042.2 |
406 | 2024-03-01 05:48:14 | spellings | 1 | 81242 | 3 | 1.423 | 57092.1 |
405 | 2024-02-16 07:32:03 | spellings | 2 | 121436 | 31 | 4.076 | 29792.9 |
404 | 2024-02-16 05:37:47 | spellings | 1 | 81242 | 3 | 2.830 | 28707.4 |
403 | 2024-02-02 17:14:56 | spellings | 3 | 148641 | 188 | 6.733 | 22076.5 |
402 | 2024-02-02 17:14:16 | spellings | 2 | 121436 | 31 | 3.140 | 38673.9 |
401 | 2024-02-02 16:55:44 | spellings | 1 | 81242 | 3 | 1.453 | 55913.3 |
400 | 2024-01-30 10:11:54 | spellings | 1 | 81242 | 3 | 1.470 | 55266.7 |
399 | 2024-01-18 12:33:11 | spellings | 1 | 81242 | 3 | 1.280 | 63470.3 |
398 | 2024-01-03 12:23:51 | spellings | 1 | 81242 | 3 | 1.360 | 59736.8 |
397 | 2023-12-13 20:37:45 | spellings | 1 | 81242 | 3 | 1.406 | 57782.4 |
396 | 2023-12-12 09:46:05 | spellings | 1 | 81242 | 3 | 1.233 | 65889.7 |
395 | 2023-12-08 18:10:19 | spellings | 1 | 81242 | 3 | 1.390 | 58447.5 |
394 | 2023-12-02 11:36:18 | spellings | 1 | 81242 | 3 | 1.280 | 63470.3 |
393 | 2023-11-16 10:53:17 | spellings | 1 | 81242 | 3 | 1.250 | 64993.6 |
392 | 2023-11-09 23:20:27 | spellings | 1 | 81242 | 3 | 1.440 | 56418.1 |
391 | 2023-11-06 20:10:52 | spellings | 1 | 81242 | 3 | 1.390 | 58447.5 |
390 | 2023-10-17 10:39:14 | spellings | 1 | 81242 | 3 | 3.046 | 26671.7 |
389 | 2023-09-02 17:14:24 | spellings | 1 | 81242 | 3 | 1.483 | 54782.2 |
388 | 2023-07-25 04:16:58 | spellings | 1 | 81242 | 3 | 1.266 | 64172.2 |
387 | 2023-06-09 07:17:15 | spellings | 1 | 81242 | 3 | 1.500 | 54161.3 |
386 | 2023-03-29 00:44:41 | spellings | 1 | 81242 | 3 | 1.216 | 66810.9 |
385 | 2023-03-22 10:48:31 | spellings | 1 | 81242 | 3 | 1.376 | 59042.2 |
384 | 2023-01-11 21:21:03 | spellings | 1 | 81242 | 3 | 1.236 | 65729.8 |
383 | 2022-11-13 21:51:41 | spellings | 1 | 81242 | 3 | 1.233 | 65889.7 |
382 | 2022-10-17 15:02:31 | spellings | 1 | 81242 | 3 | 1.406 | 57782.4 |
381 | 2022-09-06 09:09:32 | spellings | 2 | 121436 | 31 | 3.126 | 38847.1 |
380 | 2022-07-31 00:55:10 | spellings | 1 | 81242 | 3 | 1.250 | 64993.6 |
379 | 2022-07-04 04:54:02 | spellings | 1 | 81242 | 3 | 1.373 | 59171.2 |
378 | 2022-07-03 17:39:04 | spellings | 1 | 81242 | 3 | 1.300 | 62493.8 |
377 | 2022-06-08 04:22:17 | spellings | 1 | 81242 | 3 | 1.283 | 63321.9 |
376 | 2022-02-24 02:47:01 | spellings | 1 | 81242 | 3 | 1.643 | 49447.4 |
375 | 2022-02-13 16:20:00 | spellings | 1 | 81242 | 3 | 1.373 | 59171.2 |
374 | 2021-12-17 19:14:20 | spellings | 1 | 81242 | 3 | 1.563 | 51978.2 |
373 | 2021-10-30 02:59:25 | spellings | 1 | 81242 | 3 | 1.266 | 64172.2 |
372 | 2021-07-16 08:58:25 | spellings | 1 | 81242 | 3 | 1.233 | 65889.7 |
371 | 2021-06-05 06:48:06 | spellings | 1 | 81242 | 3 | 1.466 | 55417.5 |
370 | 2021-05-13 01:13:22 | spellings | 3 | 148641 | 188 | 6.970 | 21325.8 |
369 | 2021-05-11 04:45:19 | spellings | 1 | 81242 | 3 | 1.513 | 53696.0 |
368 | 2021-04-13 14:40:26 | spellings | 1 | 81242 | 3 | 2.953 | 27511.7 |
367 | 2021-04-11 20:01:30 | spellings | 3 | 148641 | 188 | 6.563 | 22648.3 |
366 | 2021-04-09 21:49:27 | spellings | 1 | 81242 | 3 | 1.453 | 55913.3 |
365 | 2021-02-18 20:07:51 | spellings | 3 | 148641 | 188 | 6.343 | 23433.9 |
364 | 2021-01-27 15:11:56 | spellings | 1 | 81242 | 3 | 1.266 | 64172.2 |
363 | 2021-01-24 10:52:20 | spellings | 1 | 81242 | 3 | 1.250 | 64993.6 |
362 | 2020-12-31 00:19:13 | spellings | 1 | 81242 | 3 | 1.390 | 58447.5 |
361 | 2020-10-19 21:03:18 | spellings | 1 | 81242 | 3 | 1.233 | 65889.7 |
360 | 2020-10-10 00:05:24 | spellings | 1 | 81242 | 3 | 1.390 | 58447.5 |
359 | 2020-09-27 16:51:06 | spellings | 1 | 81242 | 3 | 1.233 | 65889.7 |
358 | 2020-09-22 10:36:25 | spellings | 1 | 81242 | 3 | 1.263 | 64324.6 |
357 | 2020-09-08 00:29:32 | spellings | 1 | 81242 | 3 | 1.296 | 62686.7 |
356 | 2020-06-09 12:44:56 | spellings | 1 | 81242 | 3 | 1.563 | 51978.2 |
355 | 2020-03-24 02:34:17 | spellings | 1 | 81242 | 3 | 1.390 | 58447.5 |
354 | 2020-02-27 06:21:11 | spellings | 3 | 148641 | 188 | 8.810 | 16871.9 |
353 | 2020-02-27 00:14:59 | spellings | 3 | 148641 | 188 | 18.453 | 8055.1 |
352 | 2020-02-26 22:13:05 | spellings | 3 | 148641 | 188 | 8.360 | 17780.0 |
351 | 2020-02-25 20:28:39 | spellings | 1 | 81242 | 3 | 1.500 | 54161.3 |
350 | 2020-02-25 05:13:25 | spellings | 1 | 81242 | 3 | 1.500 | 54161.3 |
349 | 2020-02-23 08:46:32 | spellings | 3 | 148641 | 188 | 10.986 | 13530.0 |
348 | 2020-02-22 23:35:11 | spellings | 1 | 81242 | 3 | 1.596 | 50903.5 |
347 | 2020-02-22 13:15:56 | spellings | 3 | 148641 | 188 | 13.440 | 11059.6 |
346 | 2020-02-19 00:50:39 | spellings | 1 | 81242 | 3 | 1.580 | 51419.0 |
345 | 2020-02-17 03:32:22 | spellings | 1 | 81242 | 3 | 3.186 | 25499.7 |
344 | 2020-02-07 20:49:20 | spellings | 1 | 81242 | 3 | 3.220 | 25230.4 |
343 | 2020-02-07 15:43:25 | spellings | 1 | 81242 | 3 | 3.063 | 26523.7 |
342 | 2020-02-05 23:26:34 | spellings | 2 | 121436 | 31 | 3.250 | 37364.9 |
341 | 2020-02-05 11:45:19 | spellings | 2 | 121436 | 31 | 7.953 | 15269.2 |
340 | 2020-02-04 18:30:25 | spellings | 2 | 121436 | 31 | 3.720 | 32644.1 |
339 | 2020-02-04 14:24:59 | spellings | 1 | 81242 | 3 | 3.343 | 24302.1 |
338 | 2020-01-24 08:26:25 | spellings | 3 | 148641 | 188 | 27.283 | 5448.1 |
337 | 2020-01-24 07:25:22 | spellings | 3 | 148641 | 188 | 16.656 | 8924.2 |
336 | 2020-01-24 00:53:37 | spellings | 2 | 121436 | 31 | 11.266 | 10779.0 |
335 | 2020-01-24 00:53:34 | spellings | 3 | 148641 | 188 | 10.593 | 14032.0 |
334 | 2020-01-23 21:03:29 | spellings | 1 | 81242 | 3 | 3.343 | 24302.1 |
333 | 2020-01-23 19:57:34 | spellings | 1 | 81242 | 3 | 4.013 | 20244.7 |
332 | 2020-01-23 19:38:43 | spellings | 1 | 81242 | 3 | 1.890 | 42985.2 |
331 | 2020-01-18 01:57:13 | spellings | 2 | 121436 | 31 | 4.126 | 29431.9 |
330 | 2020-01-17 21:09:10 | spellings | 1 | 81242 | 3 | 1.513 | 53696.0 |
329 | 2020-01-17 19:45:11 | spellings | 1 | 81242 | 3 | 2.983 | 27235.0 |
328 | 2020-01-14 18:02:09 | spellings | 1 | 81242 | 3 | 1.983 | 40969.2 |
327 | 2020-01-02 02:46:06 | spellings | 1 | 81242 | 3 | 1.656 | 49059.2 |
326 | 2019-12-31 13:45:45 | spellings | 1 | 81242 | 3 | 1.343 | 60492.9 |
325 | 2019-11-23 09:57:25 | spellings | 1 | 81242 | 3 | 1.423 | 57092.1 |
324 | 2019-08-25 12:58:09 | spellings | 1 | 81242 | 3 | 1.306 | 62206.7 |
323 | 2019-08-21 11:08:31 | spellings | 1 | 81242 | 3 | 1.333 | 60946.7 |
322 | 2019-06-11 15:22:51 | spellings | 1 | 81242 | 3 | 1.483 | 54782.2 |
321 | 2019-06-04 04:25:57 | spellings | 1 | 81242 | 3 | 2.903 | 27985.5 |
320 | 2019-05-30 14:31:21 | spellings | 1 | 81242 | 3 | 1.396 | 58196.3 |
319 | 2019-05-12 07:09:53 | spellings | 1 | 81242 | 3 | 1.443 | 56300.8 |
318 | 2019-05-09 03:04:39 | spellings | 1 | 81242 | 3 | 1.486 | 54671.6 |
317 | 2019-05-01 04:31:48 | spellings | 1 | 81242 | 3 | 1.306 | 62206.7 |