History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dognap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
284 | 2024-04-11 00:28:36 | dognap | 3 | 112716 | 160 | 9.440 | 11940.3 |
283 | 2024-04-11 00:28:34 | dognap | 1 | 48755 | 2 | 1.033 | 47197.5 |
282 | 2024-04-05 15:06:19 | dognap | 1 | 48755 | 2 | 1.906 | 25579.7 |
281 | 2024-03-31 13:45:02 | dognap | 1 | 48755 | 2 | 2.173 | 22436.7 |
280 | 2024-03-29 08:07:55 | dognap | 1 | 48755 | 2 | 2.890 | 16870.2 |
279 | 2024-03-26 01:04:10 | dognap | 1 | 48755 | 2 | 0.953 | 51159.5 |
278 | 2024-03-26 01:02:59 | dognap | 1 | 48755 | 2 | 1.903 | 25620.1 |
277 | 2024-03-12 19:39:27 | dognap | 3 | 112716 | 160 | 11.140 | 10118.1 |
276 | 2024-03-12 00:30:59 | dognap | 2 | 82551 | 14 | 2.593 | 31836.1 |
275 | 2024-03-11 21:33:25 | dognap | 3 | 112716 | 160 | 11.986 | 9404.0 |
274 | 2024-03-10 05:44:00 | dognap | 2 | 82551 | 14 | 5.750 | 14356.7 |
273 | 2024-03-10 05:42:12 | dognap | 3 | 112716 | 160 | 5.860 | 19234.8 |
272 | 2024-03-08 22:49:54 | dognap | 2 | 82551 | 14 | 5.330 | 15488.0 |
271 | 2024-03-08 22:49:49 | dognap | 1 | 48755 | 2 | 0.936 | 52088.7 |
270 | 2024-03-08 22:49:30 | dognap | 3 | 112716 | 160 | 8.016 | 14061.4 |
269 | 2024-03-08 21:17:08 | dognap | 3 | 112716 | 160 | 6.123 | 18408.6 |
268 | 2024-01-18 19:57:12 | dognap | 3 | 112716 | 160 | 10.720 | 10514.6 |
267 | 2024-01-18 19:57:14 | dognap | 2 | 82551 | 14 | 4.736 | 17430.5 |
266 | 2024-01-11 15:05:06 | dognap | 1 | 48755 | 2 | 0.843 | 57835.1 |
265 | 2023-12-22 05:02:42 | dognap | 1 | 48755 | 2 | 0.856 | 56956.8 |
264 | 2023-12-20 11:38:57 | dognap | 1 | 48755 | 2 | 0.783 | 62266.9 |
263 | 2023-11-28 18:58:32 | dognap | 3 | 112716 | 160 | 5.440 | 20719.9 |
262 | 2023-11-28 12:28:41 | dognap | 1 | 48755 | 2 | 0.733 | 66514.3 |
261 | 2023-11-17 19:47:54 | dognap | 1 | 48755 | 2 | 0.733 | 66514.3 |
260 | 2023-11-10 16:27:24 | dognap | 1 | 48755 | 2 | 0.830 | 58741.0 |
259 | 2023-11-03 20:06:08 | dognap | 1 | 48755 | 2 | 0.890 | 54780.9 |
258 | 2023-10-13 16:14:42 | dognap | 1 | 48755 | 2 | 0.736 | 66243.2 |
257 | 2023-10-06 21:30:09 | dognap | 1 | 48755 | 2 | 0.890 | 54780.9 |
256 | 2023-10-04 22:56:17 | dognap | 1 | 48755 | 2 | 0.736 | 66243.2 |
255 | 2023-09-25 17:21:16 | dognap | 1 | 48755 | 2 | 0.846 | 57630.0 |
254 | 2023-09-24 23:18:47 | dognap | 1 | 48755 | 2 | 0.783 | 62266.9 |
253 | 2023-09-01 20:45:16 | dognap | 1 | 48755 | 2 | 0.750 | 65006.7 |
252 | 2023-08-28 14:01:57 | dognap | 3 | 112716 | 160 | 4.610 | 24450.3 |
251 | 2023-08-03 01:27:24 | dognap | 1 | 48755 | 2 | 0.826 | 59025.4 |
250 | 2023-05-16 05:18:00 | dognap | 3 | 112716 | 160 | 4.640 | 24292.2 |
249 | 2023-05-05 05:32:20 | dognap | 1 | 48755 | 2 | 0.843 | 57835.1 |
248 | 2023-04-28 08:01:51 | dognap | 1 | 48755 | 2 | 0.750 | 65006.7 |
247 | 2023-02-22 10:34:08 | dognap | 1 | 48755 | 2 | 0.733 | 66514.3 |
246 | 2023-02-22 01:16:10 | dognap | 3 | 112716 | 160 | 4.860 | 23192.6 |
245 | 2023-01-11 17:47:52 | dognap | 1 | 48755 | 2 | 0.736 | 66243.2 |
244 | 2022-12-19 15:07:40 | dognap | 1 | 48755 | 2 | 0.750 | 65006.7 |
243 | 2022-12-03 15:52:43 | dognap | 3 | 112716 | 160 | 4.546 | 24794.5 |
242 | 2022-09-09 19:55:38 | dognap | 1 | 48755 | 2 | 0.763 | 63899.1 |
241 | 2022-09-01 17:48:11 | dognap | 1 | 48755 | 2 | 1.670 | 29194.6 |
240 | 2022-08-30 09:10:33 | dognap | 1 | 48755 | 2 | 0.763 | 63899.1 |
239 | 2022-07-11 12:52:02 | dognap | 3 | 112716 | 160 | 4.843 | 23274.0 |
238 | 2022-04-30 04:58:19 | dognap | 1 | 48755 | 2 | 0.830 | 58741.0 |
237 | 2022-04-23 04:42:00 | dognap | 1 | 48755 | 2 | 0.766 | 63648.8 |
236 | 2022-04-19 18:27:30 | dognap | 1 | 48755 | 2 | 0.813 | 59969.2 |
235 | 2021-12-31 13:02:56 | dognap | 1 | 48755 | 2 | 0.783 | 62266.9 |
234 | 2021-09-18 01:02:02 | dognap | 1 | 48755 | 2 | 0.830 | 58741.0 |
233 | 2021-06-18 04:48:46 | dognap | 1 | 48755 | 2 | 0.830 | 58741.0 |
232 | 2021-06-04 05:52:42 | dognap | 1 | 48755 | 2 | 0.856 | 56956.8 |
231 | 2021-05-30 03:09:06 | dognap | 2 | 82551 | 14 | 2.516 | 32810.4 |
230 | 2021-05-10 00:10:51 | dognap | 1 | 48755 | 2 | 0.830 | 58741.0 |
229 | 2021-05-05 22:04:21 | dognap | 3 | 112716 | 160 | 5.546 | 20323.8 |
228 | 2021-05-04 18:05:34 | dognap | 2 | 82551 | 14 | 2.236 | 36919.1 |
227 | 2021-04-08 16:16:55 | dognap | 1 | 48755 | 2 | 0.830 | 58741.0 |
226 | 2021-04-04 00:57:49 | dognap | 3 | 112716 | 160 | 4.750 | 23729.7 |
225 | 2021-03-18 23:22:51 | dognap | 1 | 48755 | 2 | 0.856 | 56956.8 |
224 | 2021-03-08 11:23:23 | dognap | 3 | 112716 | 160 | 5.360 | 21029.1 |
223 | 2021-01-23 13:24:29 | dognap | 1 | 48755 | 2 | 0.780 | 62506.4 |
222 | 2021-01-19 08:52:11 | dognap | 3 | 112716 | 160 | 4.640 | 24292.2 |
221 | 2021-01-17 20:36:31 | dognap | 2 | 82551 | 14 | 2.110 | 39123.7 |
220 | 2021-01-01 12:31:54 | dognap | 3 | 112716 | 160 | 4.626 | 24365.8 |
219 | 2020-12-16 01:47:06 | dognap | 1 | 48755 | 2 | 0.736 | 66243.2 |
218 | 2020-11-28 07:02:54 | dognap | 1 | 48755 | 2 | 0.750 | 65006.7 |
217 | 2020-11-02 14:14:33 | dognap | 3 | 112716 | 160 | 4.800 | 23482.5 |
216 | 2020-10-29 01:40:52 | dognap | 3 | 112716 | 160 | 5.373 | 20978.2 |
215 | 2020-10-21 20:05:43 | dognap | 1 | 48755 | 2 | 0.736 | 66243.2 |
214 | 2020-10-20 20:09:41 | dognap | 1 | 48755 | 2 | 0.780 | 62506.4 |
213 | 2020-10-17 04:52:08 | dognap | 1 | 48755 | 2 | 0.733 | 66514.3 |
212 | 2020-10-16 06:56:49 | dognap | 2 | 82551 | 14 | 2.440 | 33832.4 |
211 | 2020-10-04 19:27:12 | dognap | 3 | 112716 | 160 | 5.360 | 21029.1 |
210 | 2020-09-17 17:37:13 | dognap | 1 | 48755 | 2 | 0.736 | 66243.2 |
209 | 2020-09-11 23:21:46 | dognap | 1 | 48755 | 2 | 0.766 | 63648.8 |
208 | 2020-09-01 05:35:13 | dognap | 3 | 112716 | 160 | 4.796 | 23502.1 |
207 | 2020-08-28 18:00:17 | dognap | 3 | 112716 | 160 | 4.843 | 23274.0 |
206 | 2020-05-28 05:50:38 | dognap | 1 | 48755 | 2 | 0.750 | 65006.7 |
205 | 2020-05-25 06:32:38 | dognap | 1 | 48755 | 2 | 0.750 | 65006.7 |
204 | 2020-03-28 11:32:46 | dognap | 1 | 48755 | 2 | 0.873 | 55847.7 |
203 | 2020-03-27 01:00:39 | dognap | 1 | 48755 | 2 | 1.470 | 33166.7 |
202 | 2020-03-26 12:50:29 | dognap | 1 | 48755 | 2 | 0.856 | 56956.8 |
201 | 2020-03-24 08:53:56 | dognap | 1 | 48755 | 2 | 0.860 | 56691.9 |
200 | 2020-03-23 17:30:37 | dognap | 1 | 48755 | 2 | 0.826 | 59025.4 |
199 | 2020-03-22 10:55:59 | dognap | 1 | 48755 | 2 | 0.920 | 52994.6 |
198 | 2020-03-18 19:30:48 | dognap | 1 | 48755 | 2 | 0.826 | 59025.4 |
197 | 2020-02-29 08:05:11 | dognap | 3 | 112716 | 160 | 6.593 | 17096.3 |
196 | 2020-02-29 03:42:56 | dognap | 3 | 112716 | 160 | 10.063 | 11201.0 |
195 | 2020-02-28 23:13:20 | dognap | 3 | 112716 | 160 | 11.610 | 9708.5 |
194 | 2020-02-28 13:47:03 | dognap | 3 | 112716 | 160 | 6.706 | 16808.2 |
193 | 2020-02-21 09:19:39 | dognap | 1 | 48755 | 2 | 2.046 | 23829.4 |
192 | 2020-02-13 05:11:24 | dognap | 1 | 48755 | 2 | 1.046 | 46610.9 |
191 | 2020-02-08 12:26:01 | dognap | 1 | 48755 | 2 | 0.843 | 57835.1 |
190 | 2020-02-08 09:51:41 | dognap | 1 | 48755 | 2 | 1.156 | 42175.6 |
189 | 2020-02-08 08:40:50 | dognap | 1 | 48755 | 2 | 1.063 | 45865.5 |
188 | 2020-02-05 22:57:47 | dognap | 1 | 48755 | 2 | 0.733 | 66514.3 |
187 | 2020-02-04 06:01:00 | dognap | 1 | 48755 | 2 | 0.876 | 55656.4 |
186 | 2020-01-29 05:52:42 | dognap | 1 | 48755 | 2 | 0.890 | 54780.9 |
185 | 2020-01-23 17:15:06 | dognap | 1 | 48755 | 2 | 1.906 | 25579.7 |