History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spense"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
395 | 2024-04-28 05:05:05 | spense | 1 | 48755 | 5 | 1.936 | 25183.4 |
394 | 2024-04-27 01:28:37 | spense | 1 | 48755 | 5 | 0.953 | 51159.5 |
393 | 2024-04-22 05:30:37 | spense | 1 | 48755 | 5 | 0.966 | 50471.0 |
392 | 2024-04-06 02:17:37 | spense | 3 | 112716 | 708 | 7.250 | 15547.0 |
391 | 2024-04-06 02:17:31 | spense | 2 | 82551 | 59 | 5.063 | 16304.8 |
390 | 2024-04-06 02:17:11 | spense | 1 | 48755 | 5 | 2.596 | 18780.8 |
389 | 2024-03-06 23:58:01 | spense | 1 | 48755 | 5 | 1.936 | 25183.4 |
388 | 2024-02-28 04:54:07 | spense | 1 | 48755 | 5 | 0.970 | 50262.9 |
387 | 2024-02-20 10:19:04 | spense | 1 | 48755 | 5 | 2.013 | 24220.1 |
386 | 2024-01-19 04:13:46 | spense | 3 | 112716 | 708 | 5.920 | 19039.9 |
385 | 2024-01-19 04:13:45 | spense | 2 | 82551 | 59 | 2.656 | 31080.9 |
384 | 2024-01-15 07:01:22 | spense | 3 | 112716 | 708 | 4.796 | 23502.1 |
383 | 2024-01-14 23:27:01 | spense | 2 | 82551 | 59 | 2.530 | 32628.9 |
382 | 2024-01-07 05:11:08 | spense | 1 | 48755 | 5 | 0.796 | 61250.0 |
381 | 2024-01-02 16:15:04 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
380 | 2023-12-31 17:52:57 | spense | 3 | 112716 | 708 | 4.860 | 23192.6 |
379 | 2023-12-31 17:51:09 | spense | 2 | 82551 | 59 | 2.406 | 34310.5 |
378 | 2023-11-17 11:29:57 | spense | 1 | 48755 | 5 | 0.813 | 59969.2 |
377 | 2023-11-16 09:06:18 | spense | 1 | 48755 | 5 | 0.893 | 54596.9 |
376 | 2023-11-09 23:23:24 | spense | 1 | 48755 | 5 | 0.733 | 66514.3 |
375 | 2023-10-30 19:57:36 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
374 | 2023-10-23 03:07:11 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
373 | 2023-10-22 20:48:24 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
372 | 2023-10-20 15:46:49 | spense | 1 | 48755 | 5 | 0.830 | 58741.0 |
371 | 2023-10-19 18:52:56 | spense | 1 | 48755 | 5 | 0.830 | 58741.0 |
370 | 2023-10-11 14:20:44 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
369 | 2023-10-08 18:36:13 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
368 | 2023-09-28 14:34:12 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
367 | 2023-09-26 18:33:32 | spense | 1 | 48755 | 5 | 0.780 | 62506.4 |
366 | 2023-09-18 00:56:24 | spense | 1 | 48755 | 5 | 0.796 | 61250.0 |
365 | 2023-09-14 09:01:49 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
364 | 2023-08-17 05:23:05 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
363 | 2023-05-26 03:19:35 | spense | 1 | 48755 | 5 | 0.763 | 63899.1 |
362 | 2023-05-19 05:11:21 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
361 | 2023-03-14 18:47:53 | spense | 1 | 48755 | 5 | 0.830 | 58741.0 |
360 | 2023-01-30 04:34:33 | spense | 1 | 48755 | 5 | 0.890 | 54780.9 |
359 | 2022-09-27 21:08:35 | spense | 1 | 48755 | 5 | 0.763 | 63899.1 |
358 | 2022-07-29 08:36:26 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
357 | 2022-07-13 03:28:33 | spense | 1 | 48755 | 5 | 0.733 | 66514.3 |
356 | 2022-05-14 19:31:42 | spense | 1 | 48755 | 5 | 0.903 | 53992.2 |
355 | 2022-03-06 21:25:42 | spense | 1 | 48755 | 5 | 0.780 | 62506.4 |
354 | 2022-01-10 06:13:18 | spense | 1 | 48755 | 5 | 0.856 | 56956.8 |
353 | 2021-12-15 06:13:25 | spense | 1 | 48755 | 5 | 0.906 | 53813.5 |
352 | 2021-10-26 12:32:54 | spense | 1 | 48755 | 5 | 0.846 | 57630.0 |
351 | 2021-09-29 14:13:23 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
350 | 2021-09-21 07:17:41 | spense | 1 | 48755 | 5 | 1.516 | 32160.3 |
349 | 2021-05-25 05:14:30 | spense | 1 | 48755 | 5 | 0.830 | 58741.0 |
348 | 2021-05-13 23:20:23 | spense | 1 | 48755 | 5 | 1.030 | 47335.0 |
347 | 2021-04-28 16:53:11 | spense | 1 | 48755 | 5 | 0.890 | 54780.9 |
346 | 2021-03-28 12:01:21 | spense | 1 | 48755 | 5 | 0.763 | 63899.1 |
345 | 2021-01-11 20:02:32 | spense | 1 | 48755 | 5 | 0.893 | 54596.9 |
344 | 2020-11-07 04:05:08 | spense | 1 | 48755 | 5 | 0.890 | 54780.9 |
343 | 2020-10-30 10:22:45 | spense | 1 | 48755 | 5 | 0.860 | 56691.9 |
342 | 2020-10-29 10:50:40 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
341 | 2020-09-29 17:49:40 | spense | 1 | 48755 | 5 | 0.843 | 57835.1 |
340 | 2020-08-18 10:52:37 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
339 | 2020-08-15 20:49:16 | spense | 1 | 48755 | 5 | 0.780 | 62506.4 |
338 | 2020-05-18 10:50:54 | spense | 1 | 48755 | 5 | 0.826 | 59025.4 |
337 | 2020-03-28 14:43:02 | spense | 1 | 48755 | 5 | 0.966 | 50471.0 |
336 | 2020-03-24 12:02:20 | spense | 1 | 48755 | 5 | 0.920 | 52994.6 |
335 | 2020-03-23 11:24:24 | spense | 1 | 48755 | 5 | 0.936 | 52088.7 |
334 | 2020-03-20 02:24:44 | spense | 1 | 48755 | 5 | 0.810 | 60191.4 |
333 | 2020-03-13 12:38:16 | spense | 1 | 48755 | 5 | 0.813 | 59969.2 |
332 | 2020-02-20 16:24:43 | spense | 1 | 48755 | 5 | 0.856 | 56956.8 |
331 | 2020-02-20 01:28:50 | spense | 1 | 48755 | 5 | 0.940 | 51867.0 |
330 | 2020-02-18 04:04:54 | spense | 1 | 48755 | 5 | 1.106 | 44082.3 |
329 | 2020-02-05 22:59:48 | spense | 1 | 48755 | 5 | 0.983 | 49598.2 |
328 | 2020-02-05 12:17:31 | spense | 1 | 48755 | 5 | 1.813 | 26891.9 |
327 | 2020-02-04 09:55:55 | spense | 1 | 48755 | 5 | 0.986 | 49447.3 |
326 | 2020-02-01 04:04:10 | spense | 1 | 48755 | 5 | 1.013 | 48129.3 |
325 | 2020-01-27 03:21:19 | spense | 1 | 48755 | 5 | 0.953 | 51159.5 |
324 | 2020-01-24 16:33:17 | spense | 1 | 48755 | 5 | 1.876 | 25988.8 |
323 | 2020-01-15 07:34:25 | spense | 1 | 48755 | 5 | 1.736 | 28084.7 |
322 | 2020-01-14 23:25:15 | spense | 1 | 48755 | 5 | 0.873 | 55847.7 |
321 | 2020-01-11 20:35:32 | spense | 1 | 48755 | 5 | 0.876 | 55656.4 |
320 | 2020-01-07 15:04:47 | spense | 1 | 48755 | 5 | 1.563 | 31193.2 |
319 | 2020-01-02 18:23:26 | spense | 1 | 48755 | 5 | 1.720 | 28345.9 |
318 | 2019-12-27 02:22:08 | spense | 1 | 48755 | 5 | 0.920 | 52994.6 |
317 | 2019-12-26 20:17:02 | spense | 1 | 48755 | 5 | 0.920 | 52994.6 |
316 | 2019-12-26 16:42:56 | spense | 1 | 48755 | 5 | 0.923 | 52822.3 |
315 | 2019-12-26 05:28:35 | spense | 1 | 48755 | 5 | 0.923 | 52822.3 |
314 | 2019-12-10 15:17:06 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
313 | 2019-11-29 07:05:50 | spense | 1 | 48755 | 5 | 0.750 | 65006.7 |
312 | 2019-10-07 23:43:39 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
311 | 2019-09-19 06:18:28 | spense | 1 | 48755 | 5 | 0.706 | 69058.1 |
310 | 2019-09-08 19:37:14 | spense | 1 | 48755 | 5 | 0.770 | 63318.2 |
309 | 2019-07-26 20:04:19 | spense | 1 | 48755 | 5 | 0.870 | 56040.2 |
308 | 2019-06-09 03:15:18 | spense | 1 | 48755 | 5 | 0.826 | 59025.4 |
307 | 2019-06-06 01:37:50 | spense | 1 | 48755 | 5 | 0.826 | 59025.4 |
306 | 2019-06-02 02:31:38 | spense | 1 | 48755 | 5 | 0.826 | 59025.4 |
305 | 2019-02-28 14:28:45 | spense | 1 | 48755 | 5 | 0.760 | 64151.3 |
304 | 2019-02-27 00:37:45 | spense | 1 | 48755 | 5 | 0.723 | 67434.3 |
303 | 2019-02-24 18:02:38 | spense | 1 | 48755 | 5 | 0.720 | 67715.3 |
302 | 2019-02-23 08:19:24 | spense | 1 | 48755 | 5 | 0.840 | 58041.7 |
301 | 2019-02-20 00:09:25 | spense | 1 | 48755 | 5 | 0.810 | 60191.4 |
300 | 2019-02-02 19:58:07 | spense | 1 | 48755 | 5 | 0.863 | 56494.8 |
299 | 2019-01-30 12:42:08 | spense | 2 | 82551 | 59 | 2.546 | 32423.8 |
298 | 2019-01-26 06:58:43 | spense | 1 | 48755 | 5 | 0.766 | 63648.8 |
297 | 2019-01-25 01:55:34 | spense | 1 | 48755 | 5 | 0.836 | 58319.4 |
296 | 2019-01-15 03:08:53 | spense | 1 | 48755 | 5 | 0.726 | 67155.6 |