History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jaloppy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
252 | 2024-05-01 13:44:31 | jaloppy | 2 | 107671 | 8 | 12.296 | 8756.6 |
251 | 2024-05-01 13:44:26 | jaloppy | 3 | 134027 | 41 | 13.670 | 9804.5 |
250 | 2024-05-01 13:43:57 | jaloppy | 1 | 69583 | 2 | 3.966 | 17544.9 |
249 | 2024-04-30 01:43:15 | jaloppy | 4 | 151207 | 517 | 24.203 | 6247.4 |
248 | 2024-04-28 07:48:43 | jaloppy | 1 | 69583 | 2 | 1.250 | 55666.4 |
247 | 2024-04-17 21:05:08 | jaloppy | 1 | 69583 | 2 | 1.610 | 43219.3 |
246 | 2024-04-16 08:23:50 | jaloppy | 2 | 107671 | 8 | 3.576 | 30109.3 |
245 | 2024-04-16 08:22:30 | jaloppy | 3 | 134027 | 41 | 9.453 | 14178.3 |
244 | 2024-04-15 12:05:08 | jaloppy | 4 | 151207 | 517 | 27.986 | 5403.0 |
243 | 2024-04-15 12:05:10 | jaloppy | 3 | 134027 | 41 | 19.970 | 6711.4 |
242 | 2024-04-15 12:05:18 | jaloppy | 1 | 69583 | 2 | 1.533 | 45390.1 |
241 | 2024-04-15 12:05:11 | jaloppy | 2 | 107671 | 8 | 4.063 | 26500.4 |
240 | 2024-04-15 12:05:02 | jaloppy | 1 | 69583 | 2 | 1.843 | 37755.3 |
239 | 2024-04-15 11:59:49 | jaloppy | 4 | 151207 | 517 | 32.156 | 4702.3 |
238 | 2024-04-13 18:42:09 | jaloppy | 4 | 151207 | 517 | 45.720 | 3307.2 |
237 | 2024-04-10 22:28:34 | jaloppy | 4 | 151207 | 517 | 32.876 | 4599.3 |
236 | 2024-04-09 17:31:39 | jaloppy | 4 | 151207 | 517 | 30.800 | 4909.3 |
235 | 2024-04-09 02:48:08 | jaloppy | 4 | 151207 | 517 | 26.970 | 5606.5 |
234 | 2024-03-31 03:26:30 | jaloppy | 1 | 69583 | 2 | 2.936 | 23699.9 |
233 | 2024-03-29 11:11:39 | jaloppy | 1 | 69583 | 2 | 2.000 | 34791.5 |
232 | 2024-03-18 09:32:33 | jaloppy | 3 | 134027 | 41 | 6.250 | 21444.3 |
231 | 2024-03-18 09:32:33 | jaloppy | 2 | 107671 | 8 | 3.156 | 34116.3 |
230 | 2024-03-18 09:32:29 | jaloppy | 1 | 69583 | 2 | 1.266 | 54962.9 |
229 | 2024-03-10 12:24:04 | jaloppy | 4 | 151207 | 517 | 36.333 | 4161.7 |
228 | 2024-03-08 23:52:46 | jaloppy | 4 | 151207 | 517 | 32.330 | 4677.0 |
227 | 2024-03-07 21:52:09 | jaloppy | 4 | 151207 | 517 | 12.186 | 12408.3 |
226 | 2024-03-07 00:00:50 | jaloppy | 4 | 151207 | 517 | 32.266 | 4686.3 |
225 | 2024-03-06 17:17:22 | jaloppy | 1 | 69583 | 2 | 4.093 | 17000.5 |
224 | 2024-03-05 18:53:11 | jaloppy | 4 | 151207 | 517 | 21.440 | 7052.6 |
223 | 2024-03-05 17:12:14 | jaloppy | 3 | 134027 | 41 | 14.890 | 9001.1 |
222 | 2024-03-05 17:12:12 | jaloppy | 4 | 151207 | 517 | 13.483 | 11214.6 |
221 | 2024-03-05 17:12:15 | jaloppy | 2 | 107671 | 8 | 3.860 | 27894.0 |
220 | 2024-03-05 17:12:11 | jaloppy | 1 | 69583 | 2 | 1.360 | 51164.0 |
219 | 2024-03-04 18:53:49 | jaloppy | 1 | 69583 | 2 | 2.733 | 25460.3 |
218 | 2024-02-28 07:44:57 | jaloppy | 1 | 69583 | 2 | 1.250 | 55666.4 |
217 | 2024-02-20 18:19:35 | jaloppy | 1 | 69583 | 2 | 2.686 | 25905.8 |
216 | 2024-02-09 21:09:14 | jaloppy | 2 | 107671 | 8 | 2.813 | 38276.2 |
215 | 2024-02-09 21:08:11 | jaloppy | 3 | 134027 | 41 | 6.686 | 20045.9 |
214 | 2024-02-05 09:27:51 | jaloppy | 2 | 107671 | 8 | 3.610 | 29825.8 |
213 | 2024-02-05 09:27:42 | jaloppy | 2 | 107671 | 8 | 7.063 | 15244.4 |
212 | 2024-02-05 09:27:22 | jaloppy | 3 | 134027 | 41 | 7.783 | 17220.5 |
211 | 2024-02-05 09:27:18 | jaloppy | 3 | 134027 | 41 | 7.126 | 18808.2 |
210 | 2024-02-03 05:15:28 | jaloppy | 1 | 69583 | 2 | 3.796 | 18330.6 |
209 | 2024-02-02 04:57:20 | jaloppy | 4 | 151207 | 517 | 10.283 | 14704.6 |
208 | 2024-02-01 08:39:04 | jaloppy | 4 | 151207 | 517 | 13.643 | 11083.1 |
207 | 2024-02-01 04:20:40 | jaloppy | 4 | 151207 | 517 | 21.860 | 6917.1 |
206 | 2024-01-31 23:54:08 | jaloppy | 4 | 151207 | 517 | 10.313 | 14661.8 |
205 | 2024-01-31 23:54:04 | jaloppy | 2 | 107671 | 8 | 3.093 | 34811.2 |
204 | 2024-01-31 23:53:56 | jaloppy | 3 | 134027 | 41 | 6.783 | 19759.3 |
203 | 2024-01-31 23:54:00 | jaloppy | 1 | 69583 | 2 | 1.216 | 57222.9 |
202 | 2023-12-27 21:15:35 | jaloppy | 1 | 69583 | 2 | 1.360 | 51164.0 |
201 | 2023-12-06 17:40:07 | jaloppy | 1 | 69583 | 2 | 1.063 | 65459.1 |
200 | 2023-12-04 21:13:52 | jaloppy | 1 | 69583 | 2 | 1.080 | 64428.7 |
199 | 2023-11-22 18:34:40 | jaloppy | 1 | 69583 | 2 | 1.140 | 61037.7 |
198 | 2023-10-14 01:52:17 | jaloppy | 1 | 69583 | 2 | 1.190 | 58473.1 |
197 | 2023-09-27 15:24:20 | jaloppy | 1 | 69583 | 2 | 1.203 | 57841.2 |
196 | 2023-09-22 10:53:29 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
195 | 2023-07-18 11:00:08 | jaloppy | 1 | 69583 | 2 | 1.186 | 58670.3 |
194 | 2023-04-18 22:51:24 | jaloppy | 1 | 69583 | 2 | 1.173 | 59320.5 |
193 | 2023-02-06 17:08:52 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
192 | 2022-12-06 03:37:27 | jaloppy | 1 | 69583 | 2 | 1.140 | 61037.7 |
191 | 2022-11-28 17:26:06 | jaloppy | 3 | 134027 | 41 | 6.233 | 21502.8 |
190 | 2022-09-01 16:46:18 | jaloppy | 3 | 134027 | 41 | 5.813 | 23056.4 |
189 | 2022-08-02 16:43:20 | jaloppy | 1 | 69583 | 2 | 1.063 | 65459.1 |
188 | 2022-07-06 05:11:45 | jaloppy | 3 | 134027 | 41 | 5.610 | 23890.7 |
187 | 2022-03-27 23:55:20 | jaloppy | 1 | 69583 | 2 | 1.233 | 56433.9 |
186 | 2022-02-15 05:45:37 | jaloppy | 3 | 134027 | 41 | 6.453 | 20769.7 |
185 | 2022-02-13 01:51:37 | jaloppy | 3 | 134027 | 41 | 6.153 | 21782.4 |
184 | 2022-01-05 00:10:31 | jaloppy | 1 | 69583 | 2 | 1.233 | 56433.9 |
183 | 2021-11-09 16:45:26 | jaloppy | 3 | 134027 | 41 | 6.360 | 21073.4 |
182 | 2021-11-05 09:27:00 | jaloppy | 1 | 69583 | 2 | 1.263 | 55093.4 |
181 | 2021-10-07 14:31:56 | jaloppy | 1 | 69583 | 2 | 1.236 | 56296.9 |
180 | 2021-03-20 10:51:21 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
179 | 2021-03-09 07:33:18 | jaloppy | 1 | 69583 | 2 | 1.156 | 60192.9 |
178 | 2021-03-07 02:06:13 | jaloppy | 1 | 69583 | 2 | 1.296 | 53690.6 |
177 | 2021-02-10 16:49:10 | jaloppy | 1 | 69583 | 2 | 1.186 | 58670.3 |
176 | 2021-02-08 14:19:59 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
175 | 2021-02-07 22:28:09 | jaloppy | 1 | 69583 | 2 | 1.063 | 65459.1 |
174 | 2021-02-06 18:11:22 | jaloppy | 1 | 69583 | 2 | 1.063 | 65459.1 |
173 | 2021-02-02 16:01:26 | jaloppy | 1 | 69583 | 2 | 1.060 | 65644.3 |
172 | 2021-02-01 02:31:54 | jaloppy | 1 | 69583 | 2 | 1.170 | 59472.6 |
171 | 2021-01-30 02:36:38 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
170 | 2021-01-30 00:29:55 | jaloppy | 1 | 69583 | 2 | 1.220 | 57035.2 |
169 | 2021-01-28 22:21:31 | jaloppy | 1 | 69583 | 2 | 1.080 | 64428.7 |
168 | 2021-01-28 03:15:07 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
167 | 2021-01-25 06:32:16 | jaloppy | 1 | 69583 | 2 | 1.080 | 64428.7 |
166 | 2021-01-05 02:15:35 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
165 | 2020-12-26 03:24:06 | jaloppy | 1 | 69583 | 2 | 1.170 | 59472.6 |
164 | 2020-11-10 08:27:09 | jaloppy | 1 | 69583 | 2 | 1.093 | 63662.4 |
163 | 2020-10-14 02:57:55 | jaloppy | 1 | 69583 | 2 | 1.046 | 66522.9 |
162 | 2020-07-11 15:18:33 | jaloppy | 1 | 69583 | 2 | 1.093 | 63662.4 |
161 | 2020-03-29 05:24:26 | jaloppy | 1 | 69583 | 2 | 1.376 | 50569.0 |
160 | 2020-03-27 21:04:02 | jaloppy | 1 | 69583 | 2 | 1.106 | 62914.1 |
159 | 2020-03-27 18:37:42 | jaloppy | 1 | 69583 | 2 | 2.326 | 29915.3 |
158 | 2020-03-27 03:53:08 | jaloppy | 1 | 69583 | 2 | 1.126 | 61796.6 |
157 | 2020-03-22 01:35:20 | jaloppy | 1 | 69583 | 2 | 2.516 | 27656.2 |
156 | 2020-03-01 08:07:53 | jaloppy | 1 | 69583 | 2 | 3.173 | 21929.7 |
155 | 2020-03-01 06:23:36 | jaloppy | 1 | 69583 | 2 | 1.203 | 57841.2 |
154 | 2020-03-01 00:19:07 | jaloppy | 1 | 69583 | 2 | 2.593 | 26834.9 |
153 | 2020-02-28 23:09:45 | jaloppy | 1 | 69583 | 2 | 1.906 | 36507.3 |