History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"watthours"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
264 | 2025-06-30 07:20:22 | watthours | 1 | 81242 | 2 | 4.393 | 18493.5 |
263 | 2025-06-18 02:43:43 | watthours | 3 | 148641 | 14 | 42.783 | 3474.3 |
262 | 2025-06-17 10:12:58 | watthours | 1 | 81242 | 2 | 4.356 | 18650.6 |
261 | 2025-06-16 01:17:27 | watthours | 3 | 148641 | 14 | 20.940 | 7098.4 |
260 | 2025-06-11 07:19:37 | watthours | 3 | 148641 | 14 | 50.096 | 2967.1 |
259 | 2025-06-10 18:23:11 | watthours | 3 | 148641 | 14 | 30.970 | 4799.5 |
258 | 2025-06-05 05:07:47 | watthours | 3 | 148641 | 14 | 42.253 | 3517.9 |
257 | 2025-05-28 08:54:58 | watthours | 3 | 148641 | 14 | 36.093 | 4118.3 |
256 | 2025-05-27 08:17:09 | watthours | 2 | 121436 | 3 | 11.530 | 10532.2 |
255 | 2025-05-27 07:10:59 | watthours | 3 | 148641 | 14 | 38.973 | 3813.9 |
254 | 2025-05-25 03:49:58 | watthours | 1 | 81242 | 2 | 1.266 | 64172.2 |
253 | 2025-04-09 14:35:50 | watthours | 4 | 165329 | 224 | 60.940 | 2713.0 |
252 | 2025-04-07 08:48:28 | watthours | 4 | 165329 | 224 | 51.190 | 3229.7 |
251 | 2025-04-06 06:35:59 | watthours | 4 | 165329 | 224 | 51.283 | 3223.9 |
250 | 2025-04-06 06:02:11 | watthours | 4 | 165329 | 224 | 53.393 | 3096.5 |
249 | 2025-04-06 04:22:54 | watthours | 1 | 81242 | 2 | 3.686 | 22040.7 |
248 | 2025-04-04 19:35:18 | watthours | 4 | 165329 | 224 | 71.383 | 2316.1 |
247 | 2025-03-28 04:57:25 | watthours | 2 | 121436 | 3 | 3.606 | 33676.1 |
246 | 2025-03-28 01:39:36 | watthours | 3 | 148641 | 14 | 7.690 | 19329.1 |
245 | 2025-03-23 05:03:18 | watthours | 1 | 81242 | 2 | 7.860 | 10336.1 |
244 | 2025-03-23 00:12:43 | watthours | 1 | 81242 | 2 | 6.390 | 12713.9 |
243 | 2025-02-28 13:38:19 | watthours | 1 | 81242 | 2 | 6.986 | 11629.3 |
242 | 2025-02-22 07:28:01 | watthours | 3 | 148641 | 14 | 35.343 | 4205.7 |
241 | 2025-02-22 07:27:57 | watthours | 3 | 148641 | 14 | 26.970 | 5511.3 |
240 | 2025-02-22 07:27:57 | watthours | 2 | 121436 | 3 | 20.643 | 5882.7 |
239 | 2025-02-22 07:27:06 | watthours | 1 | 81242 | 2 | 4.170 | 19482.5 |
238 | 2025-01-26 23:48:23 | watthours | 1 | 81242 | 2 | 3.610 | 22504.7 |
237 | 2025-01-25 18:47:28 | watthours | 1 | 81242 | 2 | 2.690 | 30201.5 |
236 | 2025-01-13 16:05:12 | watthours | 1 | 81242 | 2 | 6.623 | 12266.6 |
235 | 2025-01-11 20:31:47 | watthours | 1 | 81242 | 2 | 6.140 | 13231.6 |
234 | 2024-12-24 06:02:23 | watthours | 3 | 148641 | 14 | 34.083 | 4361.1 |
233 | 2024-12-24 02:19:07 | watthours | 1 | 81242 | 2 | 6.080 | 13362.2 |
232 | 2024-12-21 20:20:13 | watthours | 3 | 148641 | 14 | 35.063 | 4239.3 |
231 | 2024-12-21 20:20:17 | watthours | 2 | 121436 | 3 | 15.970 | 7604.0 |
230 | 2024-12-21 20:19:26 | watthours | 1 | 81242 | 2 | 5.670 | 14328.4 |
229 | 2024-12-18 15:11:35 | watthours | 1 | 81242 | 2 | 8.436 | 9630.4 |
228 | 2024-12-07 10:20:05 | watthours | 1 | 81242 | 2 | 2.250 | 36107.6 |
227 | 2024-11-25 06:08:50 | watthours | 1 | 81242 | 2 | 6.313 | 12869.0 |
226 | 2024-11-24 14:51:15 | watthours | 4 | 165329 | 224 | 30.720 | 5381.8 |
225 | 2024-11-18 00:29:13 | watthours | 4 | 165329 | 224 | 48.680 | 3396.2 |
224 | 2024-11-17 16:34:02 | watthours | 4 | 165329 | 224 | 62.786 | 2633.2 |
223 | 2024-11-17 04:18:32 | watthours | 4 | 165329 | 224 | 65.036 | 2542.1 |
222 | 2024-11-08 18:12:42 | watthours | 1 | 81242 | 2 | 6.936 | 11713.1 |
221 | 2024-10-28 13:08:48 | watthours | 2 | 121436 | 3 | 26.626 | 4560.8 |
220 | 2024-10-28 13:08:52 | watthours | 3 | 148641 | 14 | 21.516 | 6908.4 |
219 | 2024-10-28 06:45:29 | watthours | 3 | 148641 | 14 | 48.020 | 3095.4 |
218 | 2024-10-28 06:45:30 | watthours | 2 | 121436 | 3 | 17.890 | 6787.9 |
217 | 2024-10-20 07:35:22 | watthours | 4 | 165329 | 224 | 56.486 | 2926.9 |
216 | 2024-10-19 14:54:30 | watthours | 4 | 165329 | 224 | 45.356 | 3645.1 |
215 | 2024-10-18 22:55:53 | watthours | 4 | 165329 | 224 | 48.346 | 3419.7 |
214 | 2024-10-17 07:45:15 | watthours | 4 | 165329 | 224 | 67.783 | 2439.1 |
213 | 2024-10-17 06:46:15 | watthours | 4 | 165329 | 224 | 60.893 | 2715.1 |
212 | 2024-10-17 06:46:18 | watthours | 3 | 148641 | 14 | 24.406 | 6090.3 |
211 | 2024-10-17 06:46:22 | watthours | 2 | 121436 | 3 | 14.923 | 8137.5 |
210 | 2024-10-17 06:44:19 | watthours | 1 | 81242 | 2 | 6.953 | 11684.5 |
209 | 2024-10-05 11:23:00 | watthours | 1 | 81242 | 2 | 11.406 | 7122.7 |
208 | 2024-09-13 13:57:34 | watthours | 3 | 148641 | 14 | 28.926 | 5138.7 |
207 | 2024-09-13 13:12:00 | watthours | 1 | 81242 | 2 | 9.516 | 8537.4 |
206 | 2024-08-27 09:44:25 | watthours | 1 | 81242 | 2 | 9.640 | 8427.6 |
205 | 2024-08-15 14:35:22 | watthours | 3 | 148641 | 14 | 72.346 | 2054.6 |
204 | 2024-08-15 09:38:08 | watthours | 3 | 148641 | 14 | 72.816 | 2041.3 |
203 | 2024-08-15 09:37:52 | watthours | 3 | 148641 | 14 | 74.753 | 1988.4 |
202 | 2024-08-13 12:41:47 | watthours | 1 | 81242 | 2 | 9.220 | 8811.5 |
201 | 2024-08-11 16:18:07 | watthours | 3 | 148641 | 14 | 30.906 | 4809.5 |
200 | 2024-08-11 16:18:18 | watthours | 2 | 121436 | 3 | 17.846 | 6804.7 |
199 | 2024-08-11 16:15:47 | watthours | 1 | 81242 | 2 | 4.750 | 17103.6 |
198 | 2024-08-02 21:51:05 | watthours | 3 | 148641 | 14 | 26.723 | 5562.3 |
197 | 2024-08-01 16:21:11 | watthours | 4 | 165329 | 224 | 50.766 | 3256.7 |
196 | 2024-08-01 11:30:02 | watthours | 3 | 148641 | 14 | 19.720 | 7537.6 |
195 | 2024-08-01 07:38:26 | watthours | 3 | 148641 | 14 | 33.936 | 4380.0 |
194 | 2024-08-01 01:12:20 | watthours | 4 | 165329 | 224 | 48.690 | 3395.5 |
193 | 2024-08-01 01:12:23 | watthours | 3 | 148641 | 14 | 33.500 | 4437.0 |
192 | 2024-08-01 01:12:21 | watthours | 2 | 121436 | 3 | 17.860 | 6799.3 |
191 | 2024-07-31 23:54:38 | watthours | 1 | 81242 | 2 | 1.420 | 57212.7 |
190 | 2024-07-24 08:03:51 | watthours | 1 | 81242 | 2 | 2.860 | 28406.3 |
189 | 2024-07-23 23:37:32 | watthours | 1 | 81242 | 2 | 6.250 | 12998.7 |
188 | 2024-07-22 06:33:51 | watthours | 1 | 81242 | 2 | 2.326 | 34927.8 |
187 | 2024-07-09 17:20:40 | watthours | 3 | 148641 | 14 | 14.410 | 10315.1 |
186 | 2024-07-09 17:20:31 | watthours | 3 | 148641 | 14 | 15.173 | 9796.4 |
185 | 2024-07-08 07:52:05 | watthours | 1 | 81242 | 2 | 4.236 | 19178.9 |
184 | 2024-07-08 07:51:46 | watthours | 1 | 81242 | 2 | 2.563 | 31698.0 |
183 | 2024-07-07 15:30:37 | watthours | 1 | 81242 | 2 | 4.953 | 16402.6 |
182 | 2024-07-05 22:22:50 | watthours | 1 | 81242 | 2 | 4.500 | 18053.8 |
181 | 2024-06-21 16:56:50 | watthours | 3 | 148641 | 14 | 34.970 | 4250.5 |
180 | 2024-06-21 09:11:26 | watthours | 2 | 121436 | 3 | 19.750 | 6148.7 |
179 | 2024-06-21 09:09:25 | watthours | 1 | 81242 | 2 | 6.033 | 13466.3 |
178 | 2024-06-10 22:31:53 | watthours | 3 | 148641 | 14 | 39.800 | 3734.7 |
177 | 2024-06-10 22:31:51 | watthours | 2 | 121436 | 3 | 6.733 | 18035.9 |
176 | 2024-06-06 22:36:37 | watthours | 1 | 81242 | 2 | 2.626 | 30937.5 |
175 | 2024-06-05 15:22:39 | watthours | 3 | 148641 | 14 | 6.390 | 23261.5 |
174 | 2024-06-05 12:11:45 | watthours | 1 | 81242 | 2 | 1.470 | 55266.7 |
173 | 2024-05-29 18:54:27 | watthours | 4 | 165329 | 224 | 56.956 | 2902.7 |
172 | 2024-05-29 18:54:23 | watthours | 3 | 148641 | 14 | 35.393 | 4199.7 |
171 | 2024-05-29 12:29:37 | watthours | 4 | 165329 | 224 | 45.486 | 3634.7 |
170 | 2024-05-29 12:29:32 | watthours | 3 | 148641 | 14 | 26.936 | 5518.3 |
169 | 2024-05-29 12:29:46 | watthours | 2 | 121436 | 3 | 13.330 | 9110.0 |
168 | 2024-05-29 12:29:07 | watthours | 1 | 81242 | 2 | 3.330 | 24397.0 |
167 | 2024-05-16 01:28:15 | watthours | 1 | 81242 | 2 | 4.873 | 16671.9 |
166 | 2024-05-12 21:41:38 | watthours | 1 | 81242 | 2 | 3.000 | 27080.7 |
165 | 2024-05-08 00:21:01 | watthours | 1 | 81242 | 2 | 1.703 | 47705.2 |