History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cecity"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
412 | 2024-04-28 01:01:22 | cecity | 1 | 48755 | 1 | 3.623 | 13457.1 |
411 | 2024-04-12 21:00:47 | cecity | 1 | 48755 | 1 | 0.890 | 54780.9 |
410 | 2024-04-06 10:01:28 | cecity | 1 | 48755 | 1 | 2.923 | 16679.8 |
409 | 2024-03-30 19:33:00 | cecity | 3 | 112716 | 288 | 11.656 | 9670.2 |
408 | 2024-03-30 06:27:36 | cecity | 3 | 112716 | 288 | 11.406 | 9882.2 |
407 | 2024-03-29 02:02:15 | cecity | 3 | 112716 | 288 | 12.876 | 8754.0 |
406 | 2024-03-29 01:13:39 | cecity | 3 | 112716 | 288 | 14.436 | 7808.0 |
405 | 2024-03-29 01:13:50 | cecity | 1 | 48755 | 1 | 0.953 | 51159.5 |
404 | 2024-03-29 01:13:38 | cecity | 2 | 82551 | 13 | 8.610 | 9587.8 |
403 | 2024-03-29 01:13:37 | cecity | 1 | 48755 | 1 | 1.483 | 32875.9 |
402 | 2024-03-26 21:07:53 | cecity | 1 | 48755 | 1 | 1.093 | 44606.6 |
401 | 2024-01-17 03:14:25 | cecity | 3 | 112716 | 288 | 5.186 | 21734.7 |
400 | 2024-01-17 03:14:24 | cecity | 2 | 82551 | 13 | 2.576 | 32046.2 |
399 | 2024-01-14 12:05:59 | cecity | 3 | 112716 | 288 | 5.970 | 18880.4 |
398 | 2024-01-03 18:45:12 | cecity | 3 | 112716 | 288 | 9.906 | 11378.6 |
397 | 2024-01-03 18:45:10 | cecity | 2 | 82551 | 13 | 2.423 | 34069.7 |
396 | 2023-12-29 22:51:05 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
395 | 2023-12-15 07:47:50 | cecity | 1 | 48755 | 1 | 0.796 | 61250.0 |
394 | 2023-12-11 22:02:21 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
393 | 2023-11-25 13:10:21 | cecity | 1 | 48755 | 1 | 0.906 | 53813.5 |
392 | 2023-11-17 06:35:46 | cecity | 1 | 48755 | 1 | 0.860 | 56691.9 |
391 | 2023-11-14 15:49:51 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
390 | 2023-11-02 01:12:13 | cecity | 2 | 82551 | 13 | 2.580 | 31996.5 |
389 | 2023-11-02 00:43:14 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
388 | 2023-11-01 15:43:18 | cecity | 3 | 112716 | 288 | 4.733 | 23814.9 |
387 | 2023-11-01 15:43:07 | cecity | 2 | 82551 | 13 | 2.436 | 33887.9 |
386 | 2023-10-24 00:01:12 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
385 | 2023-10-19 02:55:09 | cecity | 1 | 48755 | 1 | 0.813 | 59969.2 |
384 | 2023-10-18 16:44:12 | cecity | 1 | 48755 | 1 | 0.843 | 57835.1 |
383 | 2023-10-11 05:37:17 | cecity | 1 | 48755 | 1 | 0.783 | 62266.9 |
382 | 2023-10-05 05:28:46 | cecity | 1 | 48755 | 1 | 0.736 | 66243.2 |
381 | 2023-09-24 08:10:16 | cecity | 1 | 48755 | 1 | 0.856 | 56956.8 |
380 | 2023-09-11 06:19:56 | cecity | 1 | 48755 | 1 | 0.843 | 57835.1 |
379 | 2023-08-15 18:56:10 | cecity | 1 | 48755 | 1 | 0.860 | 56691.9 |
378 | 2023-08-13 06:27:01 | cecity | 1 | 48755 | 1 | 0.970 | 50262.9 |
377 | 2023-05-12 12:03:26 | cecity | 1 | 48755 | 1 | 0.780 | 62506.4 |
376 | 2023-05-05 00:49:40 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
375 | 2023-03-06 13:16:04 | cecity | 1 | 48755 | 1 | 0.780 | 62506.4 |
374 | 2023-01-22 18:19:51 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
373 | 2023-01-05 13:40:06 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
372 | 2022-12-30 04:30:13 | cecity | 1 | 48755 | 1 | 0.843 | 57835.1 |
371 | 2022-11-20 06:02:48 | cecity | 1 | 48755 | 1 | 0.840 | 58041.7 |
370 | 2022-11-17 05:37:54 | cecity | 1 | 48755 | 1 | 0.876 | 55656.4 |
369 | 2022-10-28 14:35:16 | cecity | 1 | 48755 | 1 | 0.736 | 66243.2 |
368 | 2022-10-04 20:47:51 | cecity | 1 | 48755 | 1 | 0.736 | 66243.2 |
367 | 2022-09-24 18:06:24 | cecity | 1 | 48755 | 1 | 0.813 | 59969.2 |
366 | 2022-09-19 04:51:44 | cecity | 1 | 48755 | 1 | 0.890 | 54780.9 |
365 | 2022-09-13 09:05:04 | cecity | 1 | 48755 | 1 | 0.763 | 63899.1 |
364 | 2022-09-10 19:03:25 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
363 | 2022-08-26 08:17:30 | cecity | 1 | 48755 | 1 | 0.796 | 61250.0 |
362 | 2022-08-17 17:01:28 | cecity | 1 | 48755 | 1 | 0.796 | 61250.0 |
361 | 2022-06-10 15:57:28 | cecity | 1 | 48755 | 1 | 1.546 | 31536.2 |
360 | 2022-05-16 04:43:50 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
359 | 2022-04-30 20:46:52 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
358 | 2022-02-23 16:19:52 | cecity | 1 | 48755 | 1 | 1.140 | 42767.5 |
357 | 2022-01-19 22:06:20 | cecity | 1 | 48755 | 1 | 1.346 | 36222.1 |
356 | 2022-01-17 18:26:23 | cecity | 1 | 48755 | 1 | 0.766 | 63648.8 |
355 | 2021-11-28 01:39:51 | cecity | 1 | 48755 | 1 | 0.796 | 61250.0 |
354 | 2021-11-12 05:21:39 | cecity | 1 | 48755 | 1 | 0.826 | 59025.4 |
353 | 2021-11-05 10:22:19 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
352 | 2021-08-12 16:11:30 | cecity | 1 | 48755 | 1 | 0.843 | 57835.1 |
351 | 2021-07-28 17:37:52 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
350 | 2021-06-28 23:36:02 | cecity | 1 | 48755 | 1 | 0.860 | 56691.9 |
349 | 2021-06-17 20:10:22 | cecity | 1 | 48755 | 1 | 0.826 | 59025.4 |
348 | 2021-05-11 23:11:55 | cecity | 1 | 48755 | 1 | 0.813 | 59969.2 |
347 | 2021-05-11 08:16:55 | cecity | 1 | 48755 | 1 | 0.873 | 55847.7 |
346 | 2021-03-28 17:43:11 | cecity | 1 | 48755 | 1 | 0.766 | 63648.8 |
345 | 2021-02-07 13:18:29 | cecity | 1 | 48755 | 1 | 0.766 | 63648.8 |
344 | 2021-02-01 13:55:42 | cecity | 1 | 48755 | 1 | 0.796 | 61250.0 |
343 | 2021-01-11 18:22:21 | cecity | 1 | 48755 | 1 | 0.780 | 62506.4 |
342 | 2020-12-07 22:53:18 | cecity | 1 | 48755 | 1 | 0.986 | 49447.3 |
341 | 2020-11-06 16:27:22 | cecity | 1 | 48755 | 1 | 0.983 | 49598.2 |
340 | 2020-11-05 18:31:23 | cecity | 1 | 48755 | 1 | 0.893 | 54596.9 |
339 | 2020-10-22 00:04:10 | cecity | 1 | 48755 | 1 | 1.063 | 45865.5 |
338 | 2020-09-28 02:21:44 | cecity | 1 | 48755 | 1 | 0.830 | 58741.0 |
337 | 2020-09-19 12:26:16 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
336 | 2020-08-05 06:09:09 | cecity | 1 | 48755 | 1 | 0.810 | 60191.4 |
335 | 2020-08-04 22:56:31 | cecity | 1 | 48755 | 1 | 0.780 | 62506.4 |
334 | 2020-08-01 17:39:19 | cecity | 1 | 48755 | 1 | 0.920 | 52994.6 |
333 | 2020-06-14 10:50:39 | cecity | 1 | 48755 | 1 | 0.796 | 61250.0 |
332 | 2020-04-30 06:16:47 | cecity | 1 | 48755 | 1 | 0.780 | 62506.4 |
331 | 2020-04-18 10:36:40 | cecity | 1 | 48755 | 1 | 0.843 | 57835.1 |
330 | 2020-04-17 11:23:26 | cecity | 1 | 48755 | 1 | 0.936 | 52088.7 |
329 | 2020-04-16 11:22:17 | cecity | 1 | 48755 | 1 | 0.920 | 52994.6 |
328 | 2020-03-28 16:15:12 | cecity | 1 | 48755 | 1 | 0.906 | 53813.5 |
327 | 2020-03-28 05:53:14 | cecity | 1 | 48755 | 1 | 0.843 | 57835.1 |
326 | 2020-03-27 07:00:15 | cecity | 1 | 48755 | 1 | 0.953 | 51159.5 |
325 | 2020-03-23 13:34:19 | cecity | 1 | 48755 | 1 | 0.936 | 52088.7 |
324 | 2020-03-22 20:13:19 | cecity | 1 | 48755 | 1 | 1.360 | 35849.3 |
323 | 2020-03-19 22:40:11 | cecity | 1 | 48755 | 1 | 0.783 | 62266.9 |
322 | 2020-03-13 06:18:42 | cecity | 1 | 48755 | 1 | 0.766 | 63648.8 |
321 | 2020-03-12 06:38:29 | cecity | 1 | 48755 | 1 | 0.800 | 60943.8 |
320 | 2020-03-05 12:45:12 | cecity | 1 | 48755 | 1 | 0.750 | 65006.7 |
319 | 2020-03-04 12:01:19 | cecity | 1 | 48755 | 1 | 0.780 | 62506.4 |
318 | 2020-03-03 11:48:25 | cecity | 1 | 48755 | 1 | 0.796 | 61250.0 |
317 | 2020-03-01 08:37:46 | cecity | 1 | 48755 | 1 | 0.830 | 58741.0 |
316 | 2020-02-29 07:51:04 | cecity | 1 | 48755 | 1 | 0.783 | 62266.9 |
315 | 2020-02-27 22:22:47 | cecity | 3 | 112716 | 288 | 7.623 | 14786.3 |
314 | 2020-02-27 17:46:45 | cecity | 1 | 48755 | 1 | 1.826 | 26700.4 |
313 | 2020-02-27 09:05:26 | cecity | 3 | 112716 | 288 | 5.160 | 21844.2 |