History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gestate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
407 | 2024-04-27 11:09:32 | gestate | 1 | 69583 | 6 | 1.983 | 35089.8 |
406 | 2024-04-26 02:04:20 | gestate | 2 | 107671 | 37 | 3.970 | 27121.2 |
405 | 2024-04-26 02:03:36 | gestate | 3 | 134027 | 307 | 7.610 | 17612.0 |
404 | 2024-04-25 21:11:40 | gestate | 2 | 107671 | 37 | 3.813 | 28237.9 |
403 | 2024-04-25 21:02:00 | gestate | 3 | 134027 | 307 | 6.936 | 19323.4 |
402 | 2024-04-25 19:37:10 | gestate | 3 | 134027 | 307 | 14.923 | 8981.2 |
401 | 2024-03-17 13:29:52 | gestate | 1 | 69583 | 6 | 2.703 | 25742.9 |
400 | 2024-03-16 17:34:40 | gestate | 1 | 69583 | 6 | 1.360 | 51164.0 |
399 | 2024-01-31 11:51:15 | gestate | 3 | 134027 | 307 | 6.530 | 20524.8 |
398 | 2024-01-31 10:16:07 | gestate | 3 | 134027 | 307 | 6.876 | 19492.0 |
397 | 2024-01-31 10:15:59 | gestate | 2 | 107671 | 37 | 3.360 | 32044.9 |
396 | 2024-01-28 14:11:56 | gestate | 2 | 107671 | 37 | 2.890 | 37256.4 |
395 | 2023-12-27 05:08:26 | gestate | 1 | 69583 | 6 | 1.143 | 60877.5 |
394 | 2023-12-23 23:06:06 | gestate | 1 | 69583 | 6 | 1.123 | 61961.7 |
393 | 2023-12-15 00:11:11 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
392 | 2023-12-13 23:31:19 | gestate | 1 | 69583 | 6 | 1.156 | 60192.9 |
391 | 2023-12-11 02:35:30 | gestate | 2 | 107671 | 37 | 3.203 | 33615.7 |
390 | 2023-12-11 02:35:18 | gestate | 3 | 134027 | 307 | 6.673 | 20085.0 |
389 | 2023-11-11 04:00:36 | gestate | 1 | 69583 | 6 | 1.156 | 60192.9 |
388 | 2023-11-06 13:21:11 | gestate | 2 | 107671 | 37 | 2.906 | 37051.3 |
387 | 2023-11-06 12:06:57 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
386 | 2023-11-05 09:16:57 | gestate | 1 | 69583 | 6 | 1.076 | 64668.2 |
385 | 2023-10-17 04:29:24 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
384 | 2023-09-30 19:09:40 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
383 | 2023-09-29 11:48:13 | gestate | 1 | 69583 | 6 | 1.190 | 58473.1 |
382 | 2023-09-17 01:47:38 | gestate | 1 | 69583 | 6 | 1.173 | 59320.5 |
381 | 2023-08-27 22:31:36 | gestate | 1 | 69583 | 6 | 1.140 | 61037.7 |
380 | 2023-08-12 00:11:01 | gestate | 2 | 107671 | 37 | 2.953 | 36461.6 |
379 | 2023-07-27 23:53:28 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
378 | 2023-05-14 09:07:20 | gestate | 1 | 69583 | 6 | 1.093 | 63662.4 |
377 | 2023-04-25 08:52:55 | gestate | 1 | 69583 | 6 | 1.046 | 66522.9 |
376 | 2023-04-25 05:42:34 | gestate | 2 | 107671 | 37 | 2.796 | 38508.9 |
375 | 2023-02-17 07:29:21 | gestate | 1 | 69583 | 6 | 1.046 | 66522.9 |
374 | 2023-01-31 12:17:07 | gestate | 2 | 107671 | 37 | 2.750 | 39153.1 |
373 | 2023-01-28 12:27:31 | gestate | 1 | 69583 | 6 | 1.076 | 64668.2 |
372 | 2023-01-24 21:09:04 | gestate | 1 | 69583 | 6 | 1.156 | 60192.9 |
371 | 2022-12-14 16:08:20 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
370 | 2022-11-11 13:33:31 | gestate | 2 | 107671 | 37 | 2.983 | 36094.9 |
369 | 2022-10-06 22:28:06 | gestate | 1 | 69583 | 6 | 1.046 | 66522.9 |
368 | 2022-09-12 13:38:47 | gestate | 1 | 69583 | 6 | 2.076 | 33517.8 |
367 | 2022-09-04 12:23:27 | gestate | 1 | 69583 | 6 | 1.046 | 66522.9 |
366 | 2022-08-23 09:29:10 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
365 | 2022-06-20 04:09:21 | gestate | 1 | 69583 | 6 | 1.046 | 66522.9 |
364 | 2022-05-30 15:58:23 | gestate | 2 | 107671 | 37 | 2.796 | 38508.9 |
363 | 2022-04-19 09:22:13 | gestate | 1 | 69583 | 6 | 1.373 | 50679.5 |
362 | 2022-04-17 05:25:05 | gestate | 1 | 69583 | 6 | 1.076 | 64668.2 |
361 | 2022-03-01 01:08:38 | gestate | 1 | 69583 | 6 | 1.233 | 56433.9 |
360 | 2022-01-16 20:08:43 | gestate | 2 | 107671 | 37 | 3.233 | 33303.7 |
359 | 2022-01-08 16:05:56 | gestate | 1 | 69583 | 6 | 1.170 | 59472.6 |
358 | 2021-11-20 19:09:19 | gestate | 1 | 69583 | 6 | 1.093 | 63662.4 |
357 | 2021-11-12 15:07:27 | gestate | 2 | 107671 | 37 | 3.310 | 32529.0 |
356 | 2021-11-10 23:14:49 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
355 | 2021-09-24 08:09:36 | gestate | 1 | 69583 | 6 | 1.203 | 57841.2 |
354 | 2021-09-22 05:08:18 | gestate | 1 | 69583 | 6 | 1.140 | 61037.7 |
353 | 2021-08-21 05:35:34 | gestate | 1 | 69583 | 6 | 1.123 | 61961.7 |
352 | 2021-06-03 23:13:09 | gestate | 1 | 69583 | 6 | 1.263 | 55093.4 |
351 | 2021-05-20 14:51:26 | gestate | 1 | 69583 | 6 | 1.076 | 64668.2 |
350 | 2021-05-09 15:00:55 | gestate | 1 | 69583 | 6 | 1.080 | 64428.7 |
349 | 2021-04-08 05:30:19 | gestate | 1 | 69583 | 6 | 1.173 | 59320.5 |
348 | 2021-02-18 01:31:57 | gestate | 1 | 69583 | 6 | 1.110 | 62687.4 |
347 | 2021-02-15 21:17:08 | gestate | 1 | 69583 | 6 | 1.093 | 63662.4 |
346 | 2021-02-12 19:15:46 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
345 | 2020-11-13 21:43:40 | gestate | 1 | 69583 | 6 | 1.076 | 64668.2 |
344 | 2020-10-19 12:41:01 | gestate | 1 | 69583 | 6 | 1.060 | 65644.3 |
343 | 2020-10-18 18:16:48 | gestate | 1 | 69583 | 6 | 1.046 | 66522.9 |
342 | 2020-10-11 21:24:33 | gestate | 1 | 69583 | 6 | 1.046 | 66522.9 |
341 | 2020-08-17 03:50:21 | gestate | 1 | 69583 | 6 | 1.060 | 65644.3 |
340 | 2020-08-09 17:19:34 | gestate | 1 | 69583 | 6 | 1.110 | 62687.4 |
339 | 2020-05-15 02:49:18 | gestate | 1 | 69583 | 6 | 1.080 | 64428.7 |
338 | 2020-05-08 12:29:36 | gestate | 1 | 69583 | 6 | 1.170 | 59472.6 |
337 | 2020-03-29 19:36:49 | gestate | 1 | 69583 | 6 | 1.250 | 55666.4 |
336 | 2020-03-28 19:55:30 | gestate | 1 | 69583 | 6 | 1.860 | 37410.2 |
335 | 2020-03-24 09:10:57 | gestate | 1 | 69583 | 6 | 1.126 | 61796.6 |
334 | 2020-03-22 15:28:56 | gestate | 1 | 69583 | 6 | 1.110 | 62687.4 |
333 | 2020-03-20 16:51:39 | gestate | 1 | 69583 | 6 | 1.233 | 56433.9 |
332 | 2020-02-28 06:36:45 | gestate | 1 | 69583 | 6 | 1.313 | 52995.4 |
331 | 2020-02-27 15:16:36 | gestate | 1 | 69583 | 6 | 1.310 | 53116.8 |
330 | 2020-02-17 04:14:50 | gestate | 3 | 134027 | 307 | 17.220 | 7783.2 |
329 | 2020-02-15 02:18:04 | gestate | 1 | 69583 | 6 | 3.016 | 23071.3 |
328 | 2020-02-07 06:54:43 | gestate | 1 | 69583 | 6 | 1.266 | 54962.9 |
327 | 2020-02-06 10:21:23 | gestate | 1 | 69583 | 6 | 1.220 | 57035.2 |
326 | 2020-02-05 22:50:54 | gestate | 1 | 69583 | 6 | 2.360 | 29484.3 |
325 | 2020-02-05 04:13:12 | gestate | 1 | 69583 | 6 | 1.313 | 52995.4 |
324 | 2020-02-02 04:51:46 | gestate | 1 | 69583 | 6 | 3.203 | 21724.3 |
323 | 2020-01-31 12:24:28 | gestate | 3 | 134027 | 307 | 7.706 | 17392.6 |
322 | 2020-01-30 21:24:49 | gestate | 1 | 69583 | 6 | 4.033 | 17253.4 |
321 | 2020-01-24 01:00:22 | gestate | 1 | 69583 | 6 | 2.470 | 28171.3 |
320 | 2020-01-22 19:15:46 | gestate | 3 | 134027 | 307 | 19.233 | 6968.6 |
319 | 2020-01-22 03:42:47 | gestate | 3 | 134027 | 307 | 18.453 | 7263.2 |
318 | 2020-01-21 23:09:28 | gestate | 3 | 134027 | 307 | 21.236 | 6311.3 |
317 | 2020-01-18 11:12:04 | gestate | 3 | 134027 | 307 | 9.390 | 14273.4 |
316 | 2020-01-18 05:53:39 | gestate | 3 | 134027 | 307 | 14.253 | 9403.4 |
315 | 2020-01-16 13:06:30 | gestate | 1 | 69583 | 6 | 1.313 | 52995.4 |
314 | 2020-01-16 07:48:36 | gestate | 1 | 69583 | 6 | 1.063 | 65459.1 |
313 | 2020-01-12 23:12:00 | gestate | 2 | 107671 | 37 | 3.733 | 28843.0 |
312 | 2020-01-12 21:24:15 | gestate | 1 | 69583 | 6 | 2.656 | 26198.4 |
311 | 2020-01-08 09:19:28 | gestate | 1 | 69583 | 6 | 2.593 | 26834.9 |
310 | 2020-01-01 14:39:17 | gestate | 1 | 69583 | 6 | 1.266 | 54962.9 |
309 | 2019-12-30 01:30:55 | gestate | 3 | 134027 | 307 | 7.050 | 19010.9 |
308 | 2019-12-29 23:58:48 | gestate | 3 | 134027 | 307 | 7.326 | 18294.7 |