History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"duperies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-04-27 20:20:20 | duperies | 1 | 82945 | 1 | 4.720 | 17573.1 |
280 | 2024-04-19 00:13:52 | duperies | 3 | 146162 | 211 | 17.440 | 8380.8 |
279 | 2024-04-19 00:13:52 | duperies | 2 | 121059 | 17 | 14.533 | 8329.9 |
278 | 2024-04-18 20:44:02 | duperies | 1 | 82945 | 1 | 1.313 | 63172.1 |
277 | 2024-04-05 11:20:56 | duperies | 1 | 82945 | 1 | 6.156 | 13473.8 |
276 | 2024-03-26 18:15:00 | duperies | 2 | 121059 | 17 | 3.373 | 35890.6 |
275 | 2024-03-26 18:14:48 | duperies | 3 | 146162 | 211 | 7.110 | 20557.2 |
274 | 2024-03-25 10:46:29 | duperies | 2 | 121059 | 17 | 3.516 | 34430.9 |
273 | 2024-03-25 10:46:17 | duperies | 3 | 146162 | 211 | 7.123 | 20519.7 |
272 | 2024-03-23 07:05:23 | duperies | 2 | 121059 | 17 | 5.250 | 23058.9 |
271 | 2024-03-23 07:04:09 | duperies | 3 | 146162 | 211 | 7.436 | 19656.0 |
270 | 2024-03-22 10:42:11 | duperies | 2 | 121059 | 17 | 4.876 | 24827.5 |
269 | 2024-03-22 10:41:55 | duperies | 3 | 146162 | 211 | 8.376 | 17450.1 |
268 | 2024-03-22 05:39:59 | duperies | 1 | 82945 | 1 | 3.296 | 25165.4 |
267 | 2024-03-20 19:19:32 | duperies | 3 | 146162 | 211 | 15.266 | 9574.3 |
266 | 2024-03-19 17:24:58 | duperies | 3 | 146162 | 211 | 26.500 | 5515.5 |
265 | 2024-03-19 17:24:54 | duperies | 2 | 121059 | 17 | 9.563 | 12659.1 |
264 | 2024-03-19 17:18:02 | duperies | 1 | 82945 | 1 | 1.343 | 61761.0 |
263 | 2024-03-18 09:15:37 | duperies | 1 | 82945 | 1 | 1.296 | 64000.8 |
262 | 2024-03-07 11:18:02 | duperies | 1 | 82945 | 1 | 4.750 | 17462.1 |
261 | 2024-01-30 18:05:43 | duperies | 1 | 82945 | 1 | 1.373 | 60411.5 |
260 | 2024-01-29 17:27:59 | duperies | 1 | 82945 | 1 | 1.466 | 56579.1 |
259 | 2024-01-11 20:50:22 | duperies | 3 | 146162 | 211 | 7.250 | 20160.3 |
258 | 2024-01-11 20:50:19 | duperies | 2 | 121059 | 17 | 3.576 | 33853.2 |
257 | 2023-12-15 19:26:48 | duperies | 1 | 82945 | 1 | 1.453 | 57085.3 |
256 | 2023-12-07 00:50:23 | duperies | 1 | 82945 | 1 | 1.453 | 57085.3 |
255 | 2023-12-02 08:19:28 | duperies | 1 | 82945 | 1 | 1.580 | 52496.8 |
254 | 2023-11-15 20:20:27 | duperies | 1 | 82945 | 1 | 1.266 | 65517.4 |
253 | 2023-11-06 10:29:47 | duperies | 1 | 82945 | 1 | 1.393 | 59544.1 |
252 | 2023-11-04 06:10:07 | duperies | 1 | 82945 | 1 | 1.250 | 66356.0 |
251 | 2023-10-24 09:05:33 | duperies | 1 | 82945 | 1 | 1.263 | 65673.0 |
250 | 2023-10-08 16:15:34 | duperies | 1 | 82945 | 1 | 1.390 | 59672.7 |
249 | 2023-09-30 20:32:03 | duperies | 1 | 82945 | 1 | 1.220 | 67987.7 |
248 | 2023-09-29 20:53:01 | duperies | 1 | 82945 | 1 | 1.250 | 66356.0 |
247 | 2023-08-13 08:29:44 | duperies | 1 | 82945 | 1 | 1.453 | 57085.3 |
246 | 2023-07-27 14:32:24 | duperies | 1 | 82945 | 1 | 1.326 | 62552.8 |
245 | 2023-05-02 07:01:29 | duperies | 1 | 82945 | 1 | 1.250 | 66356.0 |
244 | 2023-04-28 14:06:15 | duperies | 1 | 82945 | 1 | 1.360 | 60989.0 |
243 | 2023-04-24 17:11:45 | duperies | 1 | 82945 | 1 | 1.420 | 58412.0 |
242 | 2023-02-12 21:02:20 | duperies | 1 | 82945 | 1 | 1.233 | 67270.9 |
241 | 2023-01-20 00:00:15 | duperies | 1 | 82945 | 1 | 1.250 | 66356.0 |
240 | 2022-12-11 08:27:33 | duperies | 1 | 82945 | 1 | 1.406 | 58993.6 |
239 | 2022-10-02 05:55:16 | duperies | 1 | 82945 | 1 | 1.296 | 64000.8 |
238 | 2022-08-14 09:35:54 | duperies | 1 | 82945 | 1 | 1.360 | 60989.0 |
237 | 2022-08-12 01:03:07 | duperies | 1 | 82945 | 1 | 1.266 | 65517.4 |
236 | 2022-06-11 15:01:39 | duperies | 1 | 82945 | 1 | 1.250 | 66356.0 |
235 | 2022-04-01 03:53:56 | duperies | 1 | 82945 | 1 | 1.673 | 49578.6 |
234 | 2022-03-30 02:16:10 | duperies | 1 | 82945 | 1 | 1.670 | 49667.7 |
233 | 2022-02-28 00:33:25 | duperies | 1 | 82945 | 1 | 1.410 | 58826.2 |
232 | 2021-12-31 15:33:14 | duperies | 1 | 82945 | 1 | 1.503 | 55186.3 |
231 | 2021-11-28 17:29:55 | duperies | 2 | 121059 | 17 | 3.423 | 35366.3 |
230 | 2021-11-28 05:36:47 | duperies | 2 | 121059 | 17 | 3.563 | 33976.7 |
229 | 2021-11-27 14:11:20 | duperies | 2 | 121059 | 17 | 4.000 | 30264.8 |
228 | 2021-11-24 23:03:11 | duperies | 3 | 146162 | 211 | 6.516 | 22431.2 |
227 | 2021-11-23 05:07:32 | duperies | 1 | 82945 | 1 | 1.453 | 57085.3 |
226 | 2021-11-22 07:06:57 | duperies | 2 | 121059 | 17 | 3.703 | 32692.1 |
225 | 2021-11-21 19:00:32 | duperies | 2 | 121059 | 17 | 3.720 | 32542.7 |
224 | 2021-11-21 02:05:49 | duperies | 2 | 121059 | 17 | 3.530 | 34294.3 |
223 | 2021-11-07 08:29:45 | duperies | 2 | 121059 | 17 | 3.250 | 37248.9 |
222 | 2021-11-06 14:01:22 | duperies | 2 | 121059 | 17 | 3.030 | 39953.5 |
221 | 2021-11-05 10:52:35 | duperies | 2 | 121059 | 17 | 3.423 | 35366.3 |
220 | 2021-11-04 21:20:04 | duperies | 2 | 121059 | 17 | 3.563 | 33976.7 |
219 | 2021-11-03 18:43:14 | duperies | 2 | 121059 | 17 | 3.160 | 38309.8 |
218 | 2021-11-01 16:49:29 | duperies | 2 | 121059 | 17 | 3.576 | 33853.2 |
217 | 2021-11-01 03:28:01 | duperies | 1 | 82945 | 1 | 1.236 | 67107.6 |
216 | 2021-10-31 20:37:46 | duperies | 2 | 121059 | 17 | 3.080 | 39304.9 |
215 | 2021-10-30 02:43:23 | duperies | 1 | 82945 | 1 | 1.236 | 67107.6 |
214 | 2021-10-14 12:51:35 | duperies | 1 | 82945 | 1 | 1.406 | 58993.6 |
213 | 2021-10-13 16:05:31 | duperies | 1 | 82945 | 1 | 1.310 | 63316.8 |
212 | 2021-10-12 08:38:39 | duperies | 1 | 82945 | 1 | 1.436 | 57761.1 |
211 | 2021-10-11 11:32:21 | duperies | 1 | 82945 | 1 | 1.280 | 64800.8 |
210 | 2021-10-10 08:30:35 | duperies | 1 | 82945 | 1 | 1.406 | 58993.6 |
209 | 2021-09-26 06:43:55 | duperies | 2 | 121059 | 17 | 3.063 | 39523.0 |
208 | 2021-09-25 07:44:45 | duperies | 2 | 121059 | 17 | 3.453 | 35059.1 |
207 | 2021-09-20 15:47:16 | duperies | 1 | 82945 | 1 | 1.406 | 58993.6 |
206 | 2021-09-20 00:25:17 | duperies | 1 | 82945 | 1 | 2.783 | 29804.2 |
205 | 2021-09-19 21:21:28 | duperies | 3 | 146162 | 211 | 6.280 | 23274.2 |
204 | 2021-09-19 21:20:30 | duperies | 2 | 121059 | 17 | 6.296 | 19227.9 |
203 | 2021-09-13 07:34:48 | duperies | 1 | 82945 | 1 | 1.420 | 58412.0 |
202 | 2021-08-20 04:41:07 | duperies | 1 | 82945 | 1 | 1.250 | 66356.0 |
201 | 2021-05-19 11:30:20 | duperies | 1 | 82945 | 1 | 1.283 | 64649.3 |
200 | 2021-04-23 09:57:25 | duperies | 1 | 82945 | 1 | 1.530 | 54212.4 |
199 | 2021-04-22 11:25:54 | duperies | 1 | 82945 | 1 | 1.656 | 50087.6 |
198 | 2021-02-25 20:49:01 | duperies | 3 | 146162 | 211 | 6.436 | 22710.1 |
197 | 2021-02-25 01:38:33 | duperies | 2 | 121059 | 17 | 3.406 | 35542.9 |
196 | 2021-02-08 23:51:09 | duperies | 1 | 82945 | 1 | 2.796 | 29665.6 |
195 | 2021-02-03 17:53:16 | duperies | 1 | 82945 | 1 | 1.280 | 64800.8 |
194 | 2021-01-29 03:35:38 | duperies | 1 | 82945 | 1 | 1.296 | 64000.8 |
193 | 2020-12-31 14:54:59 | duperies | 1 | 82945 | 1 | 1.266 | 65517.4 |
192 | 2020-11-09 18:34:44 | duperies | 1 | 82945 | 1 | 1.310 | 63316.8 |
191 | 2020-11-02 01:12:12 | duperies | 1 | 82945 | 1 | 1.373 | 60411.5 |
190 | 2020-10-31 02:09:15 | duperies | 1 | 82945 | 1 | 1.453 | 57085.3 |
189 | 2020-10-27 19:58:17 | duperies | 1 | 82945 | 1 | 1.390 | 59672.7 |
188 | 2020-09-28 01:50:00 | duperies | 1 | 82945 | 1 | 1.233 | 67270.9 |
187 | 2020-09-01 20:52:52 | duperies | 1 | 82945 | 1 | 1.250 | 66356.0 |
186 | 2020-08-25 10:47:34 | duperies | 1 | 82945 | 1 | 1.266 | 65517.4 |
185 | 2020-07-30 08:32:03 | duperies | 1 | 82945 | 1 | 1.296 | 64000.8 |
184 | 2020-07-27 01:40:26 | duperies | 1 | 82945 | 1 | 1.343 | 61761.0 |
183 | 2020-04-24 19:35:19 | duperies | 1 | 82945 | 1 | 1.373 | 60411.5 |
182 | 2020-03-28 15:15:38 | duperies | 1 | 82945 | 1 | 1.453 | 57085.3 |