History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hollands"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
307 | 2024-04-19 00:03:43 | hollands | 2 | 121059 | 13 | 12.436 | 9734.6 |
306 | 2024-04-19 00:03:41 | hollands | 3 | 146162 | 123 | 9.220 | 15852.7 |
305 | 2024-04-18 21:08:59 | hollands | 1 | 82945 | 2 | 1.376 | 60279.8 |
304 | 2024-03-30 03:11:44 | hollands | 2 | 121059 | 13 | 3.716 | 32577.8 |
303 | 2024-03-30 03:11:45 | hollands | 1 | 82945 | 2 | 1.436 | 57761.1 |
302 | 2024-03-24 14:55:21 | hollands | 3 | 146162 | 123 | 24.066 | 6073.4 |
301 | 2024-03-24 11:37:25 | hollands | 3 | 146162 | 123 | 16.686 | 8759.6 |
300 | 2024-03-18 22:47:43 | hollands | 3 | 146162 | 123 | 16.110 | 9072.7 |
299 | 2024-03-18 13:51:33 | hollands | 3 | 146162 | 123 | 8.610 | 16975.8 |
298 | 2024-03-18 13:51:35 | hollands | 2 | 121059 | 13 | 4.233 | 28598.9 |
297 | 2024-03-18 06:32:44 | hollands | 2 | 121059 | 13 | 7.343 | 16486.3 |
296 | 2024-03-18 04:50:36 | hollands | 3 | 146162 | 123 | 7.063 | 20694.0 |
295 | 2024-03-14 16:24:26 | hollands | 2 | 121059 | 13 | 12.923 | 9367.7 |
294 | 2024-03-14 16:24:16 | hollands | 3 | 146162 | 123 | 17.456 | 8373.2 |
293 | 2024-03-14 16:05:21 | hollands | 1 | 82945 | 2 | 1.283 | 64649.3 |
292 | 2024-03-07 12:53:06 | hollands | 1 | 82945 | 2 | 1.280 | 64800.8 |
291 | 2024-02-27 12:23:58 | hollands | 2 | 121059 | 13 | 3.970 | 30493.5 |
290 | 2024-02-27 12:23:59 | hollands | 1 | 82945 | 2 | 1.560 | 53169.9 |
289 | 2024-02-15 11:35:26 | hollands | 2 | 121059 | 13 | 3.656 | 33112.4 |
288 | 2024-02-15 11:35:11 | hollands | 3 | 146162 | 123 | 8.000 | 18270.3 |
287 | 2024-02-10 03:10:38 | hollands | 3 | 146162 | 123 | 10.533 | 13876.6 |
286 | 2024-02-09 20:50:33 | hollands | 2 | 121059 | 13 | 3.890 | 31120.6 |
285 | 2024-02-09 20:18:41 | hollands | 3 | 146162 | 123 | 8.530 | 17135.1 |
284 | 2024-02-08 18:06:24 | hollands | 3 | 146162 | 123 | 17.360 | 8419.5 |
283 | 2024-01-30 10:40:50 | hollands | 1 | 82945 | 2 | 1.483 | 55930.5 |
282 | 2024-01-20 21:32:19 | hollands | 1 | 82945 | 2 | 1.373 | 60411.5 |
281 | 2024-01-19 08:34:35 | hollands | 1 | 82945 | 2 | 1.283 | 64649.3 |
280 | 2024-01-18 12:40:03 | hollands | 3 | 146162 | 123 | 6.670 | 21913.3 |
279 | 2024-01-08 05:20:07 | hollands | 2 | 121059 | 13 | 3.516 | 34430.9 |
278 | 2023-12-28 03:36:07 | hollands | 1 | 82945 | 2 | 1.266 | 65517.4 |
277 | 2023-12-15 13:26:54 | hollands | 3 | 146162 | 123 | 9.986 | 14636.7 |
276 | 2023-11-20 16:15:36 | hollands | 1 | 82945 | 2 | 1.453 | 57085.3 |
275 | 2023-11-20 08:35:17 | hollands | 1 | 82945 | 2 | 1.440 | 57600.7 |
274 | 2023-11-14 00:21:19 | hollands | 1 | 82945 | 2 | 1.330 | 62364.7 |
273 | 2023-11-02 00:29:10 | hollands | 1 | 82945 | 2 | 1.266 | 65517.4 |
272 | 2023-10-29 05:37:43 | hollands | 1 | 82945 | 2 | 2.313 | 35860.4 |
271 | 2023-10-28 22:56:51 | hollands | 3 | 146162 | 123 | 7.923 | 18447.8 |
270 | 2023-10-15 01:10:01 | hollands | 1 | 82945 | 2 | 1.280 | 64800.8 |
269 | 2023-10-14 03:52:32 | hollands | 2 | 121059 | 13 | 3.096 | 39101.7 |
268 | 2023-09-29 06:07:34 | hollands | 1 | 82945 | 2 | 1.326 | 62552.8 |
267 | 2023-09-02 04:11:41 | hollands | 1 | 82945 | 2 | 1.250 | 66356.0 |
266 | 2023-08-29 09:34:23 | hollands | 1 | 82945 | 2 | 1.360 | 60989.0 |
265 | 2023-08-06 14:10:30 | hollands | 3 | 146162 | 123 | 6.190 | 23612.6 |
264 | 2023-07-24 06:19:51 | hollands | 2 | 121059 | 13 | 3.126 | 38726.5 |
263 | 2023-06-05 04:33:19 | hollands | 1 | 82945 | 2 | 1.390 | 59672.7 |
262 | 2023-05-12 03:58:40 | hollands | 1 | 82945 | 2 | 1.216 | 68211.3 |
261 | 2023-04-17 02:58:28 | hollands | 3 | 146162 | 123 | 8.266 | 17682.3 |
260 | 2023-04-05 12:53:53 | hollands | 2 | 121059 | 13 | 3.486 | 34727.2 |
259 | 2023-03-24 17:54:30 | hollands | 1 | 82945 | 2 | 1.220 | 67987.7 |
258 | 2023-02-02 07:53:37 | hollands | 1 | 82945 | 2 | 1.236 | 67107.6 |
257 | 2023-01-22 04:27:20 | hollands | 3 | 146162 | 123 | 6.860 | 21306.4 |
256 | 2023-01-10 11:15:13 | hollands | 1 | 82945 | 2 | 1.233 | 67270.9 |
255 | 2023-01-07 06:24:05 | hollands | 1 | 82945 | 2 | 1.250 | 66356.0 |
254 | 2023-01-01 03:35:40 | hollands | 2 | 121059 | 13 | 3.563 | 33976.7 |
253 | 2022-12-16 00:47:22 | hollands | 1 | 82945 | 2 | 1.250 | 66356.0 |
252 | 2022-12-10 05:24:54 | hollands | 1 | 82945 | 2 | 1.373 | 60411.5 |
251 | 2022-11-21 03:22:16 | hollands | 1 | 82945 | 2 | 1.390 | 59672.7 |
250 | 2022-11-16 09:06:23 | hollands | 1 | 82945 | 2 | 1.250 | 66356.0 |
249 | 2022-11-05 16:32:29 | hollands | 1 | 82945 | 2 | 1.236 | 67107.6 |
248 | 2022-11-03 02:48:41 | hollands | 3 | 146162 | 123 | 6.076 | 24055.6 |
247 | 2022-10-15 19:13:42 | hollands | 1 | 82945 | 2 | 1.250 | 66356.0 |
246 | 2022-10-11 07:30:29 | hollands | 1 | 82945 | 2 | 1.483 | 55930.5 |
245 | 2022-10-05 05:28:38 | hollands | 1 | 82945 | 2 | 1.440 | 57600.7 |
244 | 2022-09-30 19:30:26 | hollands | 1 | 82945 | 2 | 1.236 | 67107.6 |
243 | 2022-09-02 03:08:19 | hollands | 2 | 121059 | 13 | 3.266 | 37066.4 |
242 | 2022-06-21 17:29:31 | hollands | 1 | 82945 | 2 | 1.266 | 65517.4 |
241 | 2022-06-09 14:45:00 | hollands | 1 | 82945 | 2 | 1.283 | 64649.3 |
240 | 2022-05-30 00:37:05 | hollands | 1 | 82945 | 2 | 1.283 | 64649.3 |
239 | 2022-05-27 20:16:32 | hollands | 1 | 82945 | 2 | 1.330 | 62364.7 |
238 | 2022-05-18 14:26:16 | hollands | 1 | 82945 | 2 | 1.606 | 51646.9 |
237 | 2022-05-17 00:20:59 | hollands | 3 | 146162 | 123 | 6.813 | 21453.4 |
236 | 2022-05-10 08:36:31 | hollands | 1 | 82945 | 2 | 1.623 | 51106.0 |
235 | 2022-03-02 11:22:03 | hollands | 1 | 82945 | 2 | 1.690 | 49079.9 |
234 | 2022-02-13 08:54:52 | hollands | 1 | 82945 | 2 | 1.580 | 52496.8 |
233 | 2022-01-12 03:06:40 | hollands | 3 | 146162 | 123 | 6.546 | 22328.4 |
232 | 2021-12-06 23:04:47 | hollands | 1 | 82945 | 2 | 1.563 | 53067.8 |
231 | 2021-12-04 21:07:36 | hollands | 1 | 82945 | 2 | 1.623 | 51106.0 |
230 | 2021-11-15 11:28:39 | hollands | 1 | 82945 | 2 | 1.313 | 63172.1 |
229 | 2021-10-12 06:29:07 | hollands | 1 | 82945 | 2 | 1.516 | 54713.1 |
228 | 2021-09-06 01:03:38 | hollands | 1 | 82945 | 2 | 1.410 | 58826.2 |
227 | 2021-08-17 06:42:46 | hollands | 1 | 82945 | 2 | 1.343 | 61761.0 |
226 | 2021-08-12 15:10:08 | hollands | 1 | 82945 | 2 | 1.453 | 57085.3 |
225 | 2021-07-11 16:19:39 | hollands | 1 | 82945 | 2 | 1.280 | 64800.8 |
224 | 2021-06-13 07:58:38 | hollands | 1 | 82945 | 2 | 1.390 | 59672.7 |
223 | 2021-05-26 02:26:07 | hollands | 1 | 82945 | 2 | 1.440 | 57600.7 |
222 | 2021-05-05 02:07:27 | hollands | 1 | 82945 | 2 | 1.500 | 55296.7 |
221 | 2021-04-08 01:41:32 | hollands | 1 | 82945 | 2 | 1.360 | 60989.0 |
220 | 2021-03-29 10:50:33 | hollands | 1 | 82945 | 2 | 1.420 | 58412.0 |
219 | 2021-02-25 15:17:34 | hollands | 1 | 82945 | 2 | 1.406 | 58993.6 |
218 | 2021-02-02 13:06:15 | hollands | 1 | 82945 | 2 | 1.393 | 59544.1 |
217 | 2021-01-13 04:55:04 | hollands | 1 | 82945 | 2 | 1.266 | 65517.4 |
216 | 2020-11-13 08:14:41 | hollands | 1 | 82945 | 2 | 1.330 | 62364.7 |
215 | 2020-10-31 16:12:37 | hollands | 1 | 82945 | 2 | 1.403 | 59119.7 |
214 | 2020-10-22 15:23:33 | hollands | 1 | 82945 | 2 | 1.453 | 57085.3 |
213 | 2020-10-16 12:17:05 | hollands | 1 | 82945 | 2 | 1.250 | 66356.0 |
212 | 2020-09-22 01:26:11 | hollands | 1 | 82945 | 2 | 1.310 | 63316.8 |
211 | 2020-09-07 08:08:40 | hollands | 1 | 82945 | 2 | 1.436 | 57761.1 |
210 | 2020-08-01 16:41:29 | hollands | 1 | 82945 | 2 | 1.343 | 61761.0 |
209 | 2020-04-30 05:32:48 | hollands | 1 | 82945 | 2 | 1.280 | 64800.8 |
208 | 2020-03-29 22:48:25 | hollands | 1 | 82945 | 2 | 1.406 | 58993.6 |